This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51219 | 51219 | 1932-02-27 | 2 | a | The indignation of Chinese people towards Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 | |
51220 | 51220 | 1932-02-27 | 2 | d | Chen Youren resigns and the reason. | China | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 | |
51221 | 51221 | 1932-02-27 | 2 | e | Foreign troops are trying to maintain public security in the international settlement in Shanghai. Wu Peifu arrives Beijing. Protest of Japanese consul in Shanghai. Wu Peifu is still active. Explosion of arsenal in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 | |
51222 | 51222 | 1932-02-27 | 2 | f | Communist leader Zhu De is arrested in Nanchang, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 | |
51223 | 51223 | 1932-02-27 | 2 | f | Mongolian people fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 | |
51224 | 51224 | 1932-02-27 | 2 | f | Railway building from Zhuzhou in Hunan to Shaoguan in Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24090712 | 24090712 |
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]);