This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27916 | 27916 | 1913-09-27 | 2 | d | A committee set up in Beijing to draft the constitution of China. | China | http://trove.nla.gov.au/newspaper/page/24092833 | 24092833 | |
27929 | 27929 | 1913-09-27 | 3 | d | Guangdong news/ Long Jiguang advises his followers not to join any political party. The fall of Kaiping county town. Liao Zhongkai and Zhong Rongguang are wanted by the Guangdong provincial authority. Singaporean authority asks Chen Jiongming to leave within 24 hours. A wedding in Xinning county and the riots. | China | http://trove.nla.gov.au/newspaper/page/24092832 | 24092832 |
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]);