This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33658 | 33658 | 1918-09-21 | 8 | c-d | Guangdong news/ The first meeting of the military government. Beijing government reports no restoration of imperial monarchy. Staff in the military government for internal affairs and advisory. Robbery in Xinhui county. Flooding disaster and the tragedy in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24097442 | 24097442 |
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]);