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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
55235 | 55235 | 1935-07-06 | 2 | f | Hebei provincial government moves to Baoding. | China | http://trove.nla.gov.au/newspaper/page/24096489 | 24096489 | |
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 | |
55237 | 55237 | 1935-07-06 | 3 | a | Japanese aggressive ambition around the world. | Japan | 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 | |
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 | |
55240 | 55240 | 1935-07-06 | 3 | d | Research institutions in the Chinese universities. | China | 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 | |
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 | |
55243 | 55243 | 1935-07-06 | 3 | e | Japanese Buddhists come to visit China. | Japan | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
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 | |
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 | |
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 | |
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 |
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]);