This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56267 | 56267 | 1936-09-19 | 2 | b | Comments on the air bomb of the Nanjing government in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096996 | 24096996 | |
56268 | 56268 | 1936-09-19 | 2 | d | Mauneuvre of Japanese troops in north China and their preparation for war. | China | http://trove.nla.gov.au/newspaper/page/24096996 | 24096996 | |
56269 | 56269 | 1936-09-19 | 2 | d | China news/ Jiang Jieshi's attack on Guangxi and Japanese invasion of north China. Storm in Nanchang, capital of Jiangxi province. Problems of currency exchange in Guangdong. Chen Jitang is to tour overseas. The white Russian refugees in Shanghai and their life. Overseas Chinese are remitting more money back to China recently and a report by American commercial authority. Two rich Chinese businessmen are beheaded in Cuba. | China | http://trove.nla.gov.au/newspaper/page/24096996 | 24096996 | |
56270 | 56270 | 1936-09-19 | 3 | a | People in Manchuria are waiting for resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56271 | 56271 | 1936-09-19 | 3 | a | Japanese newspaper comment on Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56272 | 56272 | 1936-09-19 | 3 | a | The trade between China and America last year. | China | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56273 | 56273 | 1936-09-19 | 3 | c | Brazilian government prepares to give some lands to Japanese for cultivation. | Other... | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56274 | 56274 | 1936-09-19 | 3 | c | A meeting of Japanese military officers in Tianjin on the current situation in north China. | China | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56275 | 56275 | 1936-09-19 | 3 | c | Japanese force Chinese consul to leave Korea. | China | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56276 | 56276 | 1936-09-19 | 3 | d | Talks between Russia and Japan over their fishing disputes. | Japan | http://trove.nla.gov.au/newspaper/page/24096995 | 24096995 | |
56277 | 56277 | 1936-09-19 | 5 | a | Scientific news. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096998 | 24096998 | |
56278 | 56278 | 1936-09-19 | 6-7 | a-d | Guangdong news/ General Cai Tingkai delivers a speech in Nanning, Guangxi province. Zhu Jiahua may replace Zou Lu to be the President of Zhongshan University. Chen Ce, commander of the Humen Fortification, asks for leave due to the illness of his son. Chen Cheng sets up a headquarters. Some high-level military commanders are leaving for overseas. Comet seen in the Hong Kong sky. Jiang Jieshi's troops are ready to attack Guangxi. Jiang Jieshi dispatches more troops to Guangdong. A mad man arrested in Taishan for attempted rape. Bandits in Zhongshan and Nanhai. | China | http://trove.nla.gov.au/newspaper/page/24097000 | 24097000 | |
56279 | 56279 | 1936-09-19 | 8 | a | The revolution in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
56280 | 56280 | 1936-09-19 | 8 | c | Japanese man murdered in Beihai, of Guangxi province. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
56281 | 56281 | 1936-09-19 | 8 | d | Exercise of the Red Army in Soviet Union. | Russia | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
56282 | 56282 | 1936-09-19 | 8 | d | Princess of Holland to marry. | Other... | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
56283 | 56283 | 1936-09-19 | 8 | e | Australia news/ Australia and Japan resume their trade talks. A post office in Sydney nearly on fire. Tariff to be reduced. Recommend taxi service in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 |
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]);