This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31550 | 31550 | 1916-09-09 | 2 | a-c | Editorial on the peaceful solution to the Guangdong problems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095398 | 24095398 | |
31559 | 31559 | 1916-09-09 | 6 | a-c | Qin Chunxuan's open letter to the provincial legislature assembly on the crimes of Long Jiguang. Some members of the Guangdong provincial legislature assembly request to denounce Long Jiguang and their circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24095402 | 24095402 |
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]);