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 |
---|---|---|---|---|---|---|---|---|---|
53045 | 53045 | 1933-07-08 | 2 | b | Circular telegram jointly issued by military commanders in Chaha'er and their support of Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24091286 | 24091286 | |
53046 | 53046 | 1933-07-08 | 2 | c | Xiong Bin to Tianjin to organise special police unit. | China | http://trove.nla.gov.au/newspaper/page/24091286 | 24091286 | |
53047 | 53047 | 1933-07-08 | 2 | d | Feng Yuxiang seeks to expand his troops to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091286 | 24091286 | |
53048 | 53048 | 1933-07-08 | 2 | e | A letter from Liao Baifang to Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091286 | 24091286 | |
53049 | 53049 | 1933-07-08 | 3 | a | Resistance in north China to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091285 | 24091285 | |
53053 | 53053 | 1933-07-08 | 3 | e | Wang Jingwei reports the truce negotiation with Japan. | China | http://trove.nla.gov.au/newspaper/page/24091285 | 24091285 | |
53054 | 53054 | 1933-07-08 | 3 | e | Japanese administration of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091285 | 24091285 | |
53060 | 53060 | 1933-07-08 | 7-8 | a-f | Guangdong news/ Chinese generals Ma Zhanshan and Su Bingwen arrive Hong Kong. Chen Jitang issues circular telegram about his new appointment. The communist troops from Jiangxi province invade east Guangdong. Chen Jitang dispatches envoy to inspect the munitions factory. Guangdong troops withdraw after the sign of truce with Japan. Guangxi helps Guizhou to develop aviation industry. | China | http://trove.nla.gov.au/newspaper/page/24091289 | 24091289 | |
53062 | 53062 | 1933-07-08 | 6 | b | Floods of the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24091290 | 24091290 | |
53064 | 53064 | 1933-07-08 | 6 | c | German pirates hijack a Chinese merchant ship and a further report. | China | http://trove.nla.gov.au/newspaper/page/24091290 | 24091290 |
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]);