This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33543 | 33543 | 1918-08-24 | 2 | c-d | Wang Jiaxiang's talks on the national Chinese parliament. | China | http://trove.nla.gov.au/newspaper/page/24097404 | 24097404 | |
33562 | 33562 | 1918-08-24 | 8 | c-d | Guangdong news/ Guangdong may have new governor. Investigation on the feud and fighting between two family clans, Chen and Lin, in Xinhui county. Tang Shaoyi on the current situations. Tang Jiyao's envoy arrives Guangzhou. Epidemic in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24097410 | 24097410 |
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]);