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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54493 | 54493 | 1934-09-08 | 6 | a | Japanese prepares to invade Russia soon. | 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 | |
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 | |
54496 | 54496 | 1934-09-08 | 6 | b | Belgium proposes to sign a war pact. | Britain | 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 | |
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 | |
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 | |
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 | |
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 | |
54499 | 54499 | 1934-09-08 | 6 | c | Airforce troops on exercise in France. | France | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
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 | |
54488 | 54488 | 1934-09-08 | 3 | a | Possible tariff change in Hong Kong. | Hong Kong | 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 | |
54500 | 54500 | 1934-09-08 | 6 | d | Australia and Japan sign a trade agreement. | Japan | 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 | |
54497 | 54497 | 1934-09-08 | 6 | b | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
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 | |
54484 | 54484 | 1934-09-08 | 2 | e | The whereabouts of Ou Shounian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
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 |
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]);