This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36935 | 36935 | 1921-05-07 | 3 | a | American President Harding has some new ideas on international cooperation and the world peace. | Japan | http://trove.nla.gov.au/newspaper/page/24093532 | 24093532 | |
36936 | 36936 | 1921-05-07 | 3 | a-b | Chinese government is not able to repay Japan the due debt. Britain, America, Japan and France are to have an international conference on Chinese problems if it could not be unified within one year. | Japan | http://trove.nla.gov.au/newspaper/page/24093532 | 24093532 |
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]);