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 |
---|---|---|---|---|---|---|---|---|---|
54849 | 54849 | 1935-02-09 | 2 | c | China news/ Government troops in Guizhou fight the communists. Japanese in Manchuria. Cotton production in Shaanxi province. Troops manoeuvre in Fujian province. Bandits and government troops fight in Xuzhou, north Jiangsu province. Expenses of the Government officials. Li Jiayu on the suppression of communists. | China | http://trove.nla.gov.au/newspaper/page/24096319 | 24096319 | |
54853 | 54853 | 1935-02-09 | 3 | c | Japanese in Manchuria are selling drugs. | China | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54854 | 54854 | 1935-02-09 | 3 | c | Singaporean authority restricts entry of foreign servicemen. | Singapore | http://trove.nla.gov.au/newspaper/page/24096318 | 24096318 | |
54866 | 54866 | 1935-02-09 | 6 | c | Jiang Jieshi reaches agreement with Japanese. | Japan | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54867 | 54867 | 1935-02-09 | 6 | c | Japanese seek to topple the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 |
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]);