This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35007 | 35007 | 1919-10-25 | 2 | d | Japanese in Shandong province and their cruelty. Japanese in Dalian, Fengtian province, abuse Chinese residents. | China | http://trove.nla.gov.au/newspaper/page/24097908 | 24097908 | |
35015 | 35015 | 1919-10-25 | 3 | d | American army has new plan for expansion. Japan to have more air force. Japanese ambassador to America on the Shandong issues. China seeks to borrow more foreign loans. Boycott to Japanese goods in China and the influence. | America | http://trove.nla.gov.au/newspaper/page/24097907 | 24097907 |
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]);