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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
55235 | 55235 | 1935-07-06 | 2 | f | Hebei provincial government moves to Baoding. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
55238 | 55238 | 1935-07-06 | 3 | b | Japan to develop civil aviation service. | Japan | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);