This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35014 | 35014 | 1919-10-25 | 3 | c | American senate says no to the resolutions on Shandong issues passed by the Paris Peace Conference. | America | http://trove.nla.gov.au/newspaper/page/24097907 | 24097907 | |
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]);