This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56150 | 56150 | 1936-08-15 | 2 | b | The Saving China Association in Guangzhou requests Jiang Jieshi to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56151 | 56151 | 1936-08-15 | 2 | c | Chinese foreign minister Zhang Qun reports China's policy towards Japan. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56152 | 56152 | 1936-08-15 | 2 | d | Bai Chongxi on the resistance of Japanese invasion and the saving of Chinese nation. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56153 | 56153 | 1936-08-15 | 2 | e | Japanese protest to Wu Tiecheng. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56154 | 56154 | 1936-08-15 | 2 | f | Nanjing government prepares to collect personal income tax. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56155 | 56155 | 1936-08-15 | 2 | g | Famine in the west of Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24096954 | 24096954 | |
56156 | 56156 | 1936-08-15 | 3 | a | Japanese purchase textile factories in north China. | China | http://trove.nla.gov.au/newspaper/page/24096953 | 24096953 | |
56166 | 56166 | 1936-08-15 | 6-7 | a-d | Guangdong news/ Chen Jitang orders Yu Hanmou to return and protect Dayu Fortification. Chen Jitang arrives Hong Kong and the report. The troops under command of Yu Hanmou. Exchange rate of Hong Kong currency going up. Li Shuzong, commander of the security troops in Guangzhou, resigns. Amount of silver deposited in the Hong Kong banks. Wang Xunzhi on the Guangxi army and their determination to resist Japanese invasion. Gaoyao county authority pleas for help to the minority nationality. Bandit chieftain arrested in Zengcheng. Civilians in Nanhai organise associations to fight Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096958 | 24096958 | |
56170 | 56170 | 1936-08-15 | 8 | e | Japanese seek to control Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096960 | 24096960 |
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]);