This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28155 | 28155 | 1913-11-22 | 2 | d | Chinese President Yuan Shikai is sworn in and his speech at the ceremony. | China | http://trove.nla.gov.au/newspaper/page/24092897 | 24092897 | |
28166 | 28166 | 1913-11-22 | 3 | d | Guangdong news/ Grand ceremony in Chongqing on the National Day and the congratulations to the Chinese new president. Central government urges Guangdong authority to suppress rebellions. Weapon smuggling in Guangdong. Martial law in Guangzhou. Government to relax its control on gambling. | China | http://trove.nla.gov.au/newspaper/page/24092896 | 24092896 |
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]);