This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24711 | 24711 | 1911-07-15 | 3 | c | Beijing news | The inefficient new cabinet. The big budget for a military exercise. Excellent Chinese navy students in Japan. The navy department orders for new military ships. Russia and China negotiate road trade. Several news about the Federation of Provincial Advisory Committees. | Other... | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
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]);