This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34833 | 34833 | 1919-08-23 | 8 | b-d | Guangdong news/ Guangdong people request to appoint Wu Tingfang the provincial governor. Normal school students in Guangzhou and their patriotic demonstration. Acting provincial governor Zhang Jinfang and his backgrounds. Detention centre in Guangzhou is actually the hell. Army in Zengcheng county and their illegal activities. Magistrate of Yangchun county is injured. | China | http://trove.nla.gov.au/newspaper/page/24097842 | 24097842 |
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]);