This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33642 | 33642 | 1918-09-21 | 3 | c-d | Chinese President Feng Guozhang issues a circular telegram and resigns. | China | http://trove.nla.gov.au/newspaper/page/24097435 | 24097435 | |
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]);