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 |
---|---|---|---|---|---|---|---|---|---|
54499 | 54499 | 1934-09-08 | 6 | c | Airforce troops on exercise in France. | France | 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 | |
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 | |
54496 | 54496 | 1934-09-08 | 6 | b | Belgium proposes to sign a war pact. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
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 | |
54498 | 54498 | 1934-09-08 | 6 | c | British businessmen boycott to Australian products. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
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 | |
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 | |
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 | |
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 | |
54497 | 54497 | 1934-09-08 | 6 | b | Floods in India. | Other... | 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 | |
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 | |
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 | |
54490 | 54490 | 1934-09-08 | 3 | c | Japanese preparation for the war with Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54493 | 54493 | 1934-09-08 | 6 | a | Japanese prepares to invade Russia soon. | Britain | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54488 | 54488 | 1934-09-08 | 3 | a | Possible tariff change in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
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 | |
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 | |
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 | |
54484 | 54484 | 1934-09-08 | 2 | e | The whereabouts of Ou Shounian. | 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]);