This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49146 | 49146 | 1930-05-17 | 2 | c | Students in Nanjing planning an uprising. Communist forces occupy Nanchang, capital of Jiangxi province. Nepal troops invade Tibet. French authority in Vietnam may dispatch troops to the Guangxi border. Military forces against Jiang Jieshi in north Anhui and Jiangsu province. Attempt to assassinate Jiang Jieshi in Ningbo, Zhejiang province and the suspect is escorted to Nanjing. School students in Xikang issue a public appeal after the invasion of Nepal troops. Various troops gather in Zhengzhou, capital of Henan province, against Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099635 | 24099635 | |
49154 | 49154 | 1930-05-17 | 3 | c | Bandits on the border of Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24099634 | 24099634 | |
49163 | 49163 | 1930-05-17 | 8 | c | The war between Jiang Jieshi and Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24099641 | 24099641 | |
49164 | 49164 | 1930-05-17 | 8 | c | Earthquake in Burma. | China | http://trove.nla.gov.au/newspaper/page/24099641 | 24099641 | |
49165 | 49165 | 1930-05-17 | 8 | c | Some Nationalist members gather in Tianjin with a purpose to overthrow Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099641 | 24099641 |
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]);