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 |
---|---|---|---|---|---|---|---|---|---|
55247 | 55247 | 1935-07-06 | 8 | e | Australia news/ Total population in Australia. Federal government and the national defence. Timely rain in north New South Wales. Bandits rob passengers in Sydney. Chinese consul-general in Sydney Chen Weipin has a car accident. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096495 | 24096495 | |
55246 | 55246 | 1935-07-06 | 6-7 | a-f | Guangdong news/ Labourer Chen Lin is killed in an accident in Shilong town, Nanhai county. Customs officers detain Chinese businessmen returned from Cuba. Guangdong to ban opium from next year. Pawn industry in Guangzhou. Rubber industry in Hong Kong. Bandits in Zhongshan. A young girl in Taishan is found pregnant. Dragon boat competition in Dongguan. Villagers in Kaiping are murdered. | China | http://trove.nla.gov.au/newspaper/page/24096493 | 24096493 | |
55245 | 55245 | 1935-07-06 | 5 | a | Comments on the north China crisis and the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096490 | 24096490 | |
55244 | 55244 | 1935-07-06 | 3 | e | German envoy to discuss naval cooperation with Britain. | Germany | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55243 | 55243 | 1935-07-06 | 3 | e | Japanese Buddhists come to visit China. | Japan | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55242 | 55242 | 1935-07-06 | 3 | d | A discussion in Geneva on the opium problems in the international settlements in China. | Other... | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55241 | 55241 | 1935-07-06 | 3 | d | Many Korean people are opium addicted under Japanese rule. | Other... | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55240 | 55240 | 1935-07-06 | 3 | d | Research institutions in the Chinese universities. | China | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55239 | 55239 | 1935-07-06 | 3 | c | China and Vietnam have finalise their trade agreement. | China | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55238 | 55238 | 1935-07-06 | 3 | b | Japan to develop civil aviation service. | Japan | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55237 | 55237 | 1935-07-06 | 3 | a | Japanese aggressive ambition around the world. | Japan | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55236 | 55236 | 1935-07-06 | 3 | a | Japanese government dispatches envoys to visit south Asian countries. | Japan | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
55235 | 55235 | 1935-07-06 | 2 | f | Hebei provincial government moves to Baoding. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55234 | 55234 | 1935-07-06 | 2 | f | The communist troops under He Long in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55233 | 55233 | 1935-07-06 | 2 | c | Local authorities in China protest against the Thailand government over the anti-Chinese movement. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55232 | 55232 | 1935-07-06 | 2 | c | Yu Xuezhong and Zhang Ting'e to step down together following the north China crisis. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55231 | 55231 | 1935-07-06 | 2 | b | The Nanjing government has no response to the north China crisis. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55230 | 55230 | 1935-07-06 | 2 | b | First part of comments on the north China crisis by Li Jishen, Chen Mingshu, Jiang Guanglai and Cai Tingkai. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 |
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]);