This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51201 | 51201 | 1932-02-20 | 3 | b | Students in Hunan organise demonstration and associations against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51206 | 51206 | 1932-02-20 | 5 | b | Chinese communities in Sydney meet again for fund-raising for the resistance to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51207 | 51207 | 1932-02-20 | 5 | b | Resistance to Japanese invasion in Heilongjiang province and the army unit. | China | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51209 | 51209 | 1932-02-20 | 6 | b | Guangdong news/ Air force troops and police will not be involved in the internal fighting. Chen Jinjie of the Fourth Group Army runs away with public funds. Battery industry in prosperous in Guangzhou. Wu Qiwei reports his travel. The Fourth Group Army sets up a pressgang office. Disease of Hu Hanmin. Provincial bank to issue new bank notes. Commissioner of appeasement on their way to start working. Extortion in Jiangmen. Gambling and tax in Guangzhou. Budget for the implementation of appeasement policy. | China | http://trove.nla.gov.au/newspaper/page/24090708 | 24090708 | |
51211 | 51211 | 1932-02-20 | 7 | b | Zhang Xueliang replies to Wu Zhihui. | China | http://trove.nla.gov.au/newspaper/page/24090707 | 24090707 | |
51216 | 51216 | 1932-02-20 | 8 | b | Yan Huiqing speaks to the League of Nations. Resolutions passed by the League of Nations | Britain | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 | |
51217 | 51217 | 1932-02-20 | 8 | b | Miscellaneous report on Japanese invasion of Shanghai, resistance of Chinese troops, and responses of other foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 |
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]);