This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26277 | 26277 | 1912-06-15 | 2 | c | Letters form Beijing | Premier Tang attempted to place people in Domestic Ministry and conflicted with the minister. Domestic minister Zhao claims to resign. Yang Jinchen and Tang Jirao are competing for governor of Guizhou. | China | http://trove.nla.gov.au/newspaper/page/24092272 | 24092272 |
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]);