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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54484 | 54484 | 1934-09-08 | 2 | e | The whereabouts of Ou Shounian. | Tung Wah | 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 | |
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 | |
54488 | 54488 | 1934-09-08 | 3 | a | Possible tariff change in Hong Kong. | Hong Kong | 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 | |
54490 | 54490 | 1934-09-08 | 3 | c | Japanese preparation for the war with Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
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 | |
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 | |
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 | |
54497 | 54497 | 1934-09-08 | 6 | b | Floods in India. | Other... | 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 | |
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 | |
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 | |
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]);