This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28261 | 28261 | 1913-12-13 | 2 | c-d | Fifth part of the draft constitution of the Republic of China, proposed by Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24092921 | 24092921 | |
28277 | 28277 | 1913-12-13 | 3 | c-d | Guangdong news/ Military governor Long Jiguang bans gambling. Long Jiguang convenes a military meeting. Zhang Mingqi on the way to Guangdong. Chen Jiongming's properties in Huizhou are confiscated. Some servicemen commit looting in Guangzhou. Army commander Li Yaohan and his troops in Zhaoqing. Provincial legislature assembly to be reorganised. Zhong Rongguang's residence is searched. | China | http://trove.nla.gov.au/newspaper/page/24092920 | 24092920 |
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]);