This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55871 | 55871 | 1936-03-14 | 2 | c | Administrative changes of the six counties in Chaha'er province. | China | http://trove.nla.gov.au/newspaper/page/24096776 | 24096776 | |
55872 | 55872 | 1936-03-14 | 2 | c | Students in Shanghai continue their patriotic propaganda. | China | http://trove.nla.gov.au/newspaper/page/24096776 | 24096776 | |
55873 | 55873 | 1936-03-14 | 2 | f | Departments of the central government in Nanjing to be reshuffled. | China | http://trove.nla.gov.au/newspaper/page/24096776 | 24096776 | |
55874 | 55874 | 1936-03-14 | 2 | f | Efforts to improve the relations between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096776 | 24096776 | |
55875 | 55875 | 1936-03-14 | 3 | a | A meeting in Tianjin and Japanese effort to control north China. | China | http://trove.nla.gov.au/newspaper/page/24096775 | 24096775 | |
55877 | 55877 | 1936-03-14 | 3 | c | Cooperation between China and France on navigation. | China | http://trove.nla.gov.au/newspaper/page/24096775 | 24096775 | |
55878 | 55878 | 1936-03-14 | 3 | c | Tense between Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24096775 | 24096775 | |
55879 | 55879 | 1936-03-14 | 3 | d | British government outlines its six-year plan for warship building. | China | http://trove.nla.gov.au/newspaper/page/24096775 | 24096775 | |
55880 | 55880 | 1936-03-14 | 3 | d | The war clouds over the border of Manchuria and Russia. | China | http://trove.nla.gov.au/newspaper/page/24096775 | 24096775 | |
55881 | 55881 | 1936-03-14 | 5 | a | The New Year's eve in Nanjing and the celebrations. | China | http://trove.nla.gov.au/newspaper/page/24096777 | 24096777 | |
55882 | 55882 | 1936-03-14 | 6-7 | a-d | Guangdong news/ Hu Hanmin's condition for going north. Japanese army commander visit Guangzhou. The anti-Japanese demonstration of the Guangzhou students. Exhibition of new helicopter in Guangzhou. Crisis is over in Guiyang, capital of Guizhou province. Export from China to Holland. | China | http://trove.nla.gov.au/newspaper/page/24096780 | 24096780 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);