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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
56282 | 56282 | 1936-09-19 | 8 | d | Princess of Holland to marry. | Other... | 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 | |
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 | |
56279 | 56279 | 1936-09-19 | 8 | a | The revolution in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
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 | |
56277 | 56277 | 1936-09-19 | 5 | a | Scientific news. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096998 | 24096998 | |
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 | |
56275 | 56275 | 1936-09-19 | 3 | c | Japanese force Chinese consul to leave Korea. | China | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);