This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29158 | 29158 | 1914-08-15 | 2 | b-c | Chinese President Yuan Shikai and Premier Xu Shichang talk on the politics. | China | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
29159 | 29159 | 1914-08-15 | 2 | b-c | Chinese Ministry of Internal Affairs on the haircut. | China | http://trove.nla.gov.au/newspaper/page/24093212 | 24093212 | |
29171 | 29171 | 1914-08-15 | 8 | b-c | Beijing news/ President Yuan Shikai cares about overseas Chinese. New plan to retrieve paper bank notes. Judicial law to be revised and the key points. Budget for the central government has been finalised. China to compensate foreign countries fro their loss during the 1911 Revolution. Plague of bandits and locusts in Xiangyang, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 |
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]);