This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25560 | 25560 | 1912-01-13 | 2 | c-d | Guilin situation | Guilin back to normal after three day riots. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25572 | 25572 | 1912-01-13 | 3 | c-d | Guangdong news | Republic military government concerns education, urging to investigate problems in education. Law graduates finishes three books about republic, election and constitution. A government official is robbed in Huazhou. Wang Jingwei is to return to Guangdong after released from prison. Some in Zhaocheng force people to cut pigtails. Bijiangkou asks for military help as gangsters active there. Lianzhou asks for military help as gangsters active there. Beihai urges military help as increasing riots there. | Other... | http://trove.nla.gov.au/newspaper/page/24092066 | 24092066 |
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]);