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 |
---|---|---|---|---|---|---|---|---|---|
54247 | 54247 | 1934-06-23 | 3 | a | Feng Yuxiang in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096059 | 24096059 | |
54254 | 54254 | 1934-06-23 | 6 | a | Relations between China and Japan deteriorate. | China | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 | |
54253 | 54253 | 1934-06-23 | 7-8 | a-f | Guangdong news/ Guangdong and Guangxi begin joint defence. Zhang Zhiying organise special army unit. Guangdong to set up a steel factory with foreign loans. Japanese ambition in south China. Land tax in Panyu county. The insurance companies in Guangdong organised by businessmen returned from overseas. Export of Chinese tea. Floods in east Guangdong. Clan fighting in Dongguan. Bandits in Shenzhen. Grain prices going up in Foshan. Heavy rain and disasters in Longchuan county. | China | http://trove.nla.gov.au/newspaper/page/24096063 | 24096063 | |
54244 | 54244 | 1934-06-23 | 2 | b | Opium trade in some provinces in China and the statistics. | China | http://trove.nla.gov.au/newspaper/page/24096060 | 24096060 | |
54248 | 54248 | 1934-06-23 | 3 | b | Attitude of the League of Nations towards the Manchurian issues. | Other... | http://trove.nla.gov.au/newspaper/page/24096059 | 24096059 | |
54249 | 54249 | 1934-06-23 | 3 | b | Russia to join the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096059 | 24096059 | |
54255 | 54255 | 1934-06-23 | 6 | b | Earthquake in Argentina. | America | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 | |
54245 | 54245 | 1934-06-23 | 2 | c | Jiang Jieshi may use Zhang Xueliang's troops to attack Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24096060 | 24096060 | |
54250 | 54250 | 1934-06-23 | 3 | c | Rumour says Russia and France may have signed military agreement. | France | http://trove.nla.gov.au/newspaper/page/24096059 | 24096059 | |
54256 | 54256 | 1934-06-23 | 6 | c | Deputy Japanese consul disappears in Nanjing and the report. | China | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 | |
54251 | 54251 | 1934-06-23 | 5 | d | History of prostitution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096061 | 24096061 | |
54246 | 54246 | 1934-06-23 | 2 | e | Rumours in Fuzhou, capital of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096060 | 24096060 | |
54252 | 54252 | 1934-06-23 | 5 | e | Committee members of the Chinese Society (zhong hua gong hui) in Melbourne in 1934. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096061 | 24096061 | |
54257 | 54257 | 1934-06-23 | 6 | e | Bandits in Beijing murder American missionary. | China | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 | |
54258 | 54258 | 1934-06-23 | 6 | f | Australia news/ Proposal to lift ban on entry of Chinese businessmen. Guo Shun gives dinner to the Australian trade delegation on their return. Police in Cairns, Queensland, search China Town. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 |
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]);