This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31336 | 31336 | 1916-06-24 | 2 | c-d | Feng Guozhang's telegram advises Yuan Shikai to give up the throne. | China | http://trove.nla.gov.au/newspaper/page/24095308 | 24095308 | |
31339 | 31339 | 1916-06-24 | 3 | c-d | Cai E and his troops arrives Sichuan province and their public notice. | China | http://trove.nla.gov.au/newspaper/page/24095307 | 24095307 | |
31352 | 31352 | 1916-06-24 | 8 | c-d | Guangdong news/ Current situation in Guangdong and the mediation. Training of civil corps in Guangdong. Liang Qichao leaves Guangzhou. Civil corps in Zengcheng occupy many towns. Civil corps in Dongguan county and their lootings. | China | http://trove.nla.gov.au/newspaper/page/24095313 | 24095313 |
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]);