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 |
---|---|---|---|---|---|---|---|---|---|
54502 | 54502 | 1934-09-08 | 6 | f | Australia news/ Federal government promotes tobacco industry. Robbers in Sydney kill the victims. Gold price in Australia is high. Cheap price of Japanese wheat flour on the Australian market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54501 | 54501 | 1934-09-08 | 6 | d | Resistance of Chinese troops to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54500 | 54500 | 1934-09-08 | 6 | d | Australia and Japan sign a trade agreement. | Japan | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54499 | 54499 | 1934-09-08 | 6 | c | Airforce troops on exercise in France. | France | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54498 | 54498 | 1934-09-08 | 6 | c | British businessmen boycott to Australian products. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54497 | 54497 | 1934-09-08 | 6 | b | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54496 | 54496 | 1934-09-08 | 6 | b | Belgium proposes to sign a war pact. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54495 | 54495 | 1934-09-08 | 6 | b | Ex-servicemen of 23 countries gather in London for the world peace. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54494 | 54494 | 1934-09-08 | 6 | b | Further report on the alliance of Britain and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54493 | 54493 | 1934-09-08 | 6 | a | Japanese prepares to invade Russia soon. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54492 | 54492 | 1934-09-08 | 7-8 | a-f | Guangdong news/ The meeting of Japanese consuls in Taiwan and the programme. Bai Chongxi may return to Guangxi soon. Agriculture in the north. Huang Guangrui leaves Hong Kong for Guangzhou. Afforestation in the Humen area. Gold mine in Enping. Bride in Taishan kills a thief. Big turtle discovered in Xinhui. Exorbitant education levy imposed in Gaoming. Heavy rain in Jiujiang area. | China | http://trove.nla.gov.au/newspaper/page/24096153 | 24096153 | |
54491 | 54491 | 1934-09-08 | 3 | d | Both Britain and Germany are preparing for the coming war. | America | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54490 | 54490 | 1934-09-08 | 3 | c | Japanese preparation for the war with Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54489 | 54489 | 1934-09-08 | 3 | b | Talks in Britain and Spain on the coming world war. | Britain | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54488 | 54488 | 1934-09-08 | 3 | a | Possible tariff change in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54487 | 54487 | 1934-09-08 | 2 | f | Chinese judicial authority to use convicts to build roads. | China | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54486 | 54486 | 1934-09-08 | 2 | f | Chinese in Macao oppose to Japanese contract of the tap water project. | Other... | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54485 | 54485 | 1934-09-08 | 2 | e | Sales of Chinese local products in south China. | China | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54484 | 54484 | 1934-09-08 | 2 | e | The whereabouts of Ou Shounian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54483 | 54483 | 1934-09-08 | 2 | c | Hu Hanmin in Hong Kong talks about the Dalian conference. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54482 | 54482 | 1934-09-08 | 2 | a | Editorial on the commercial recovery in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 |
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]);