This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31056 | 31056 | 1916-03-18 | 8 | b-d | Guangdong news/Huizhou republican troops have a severe battle with government troops. Lulang factory in Guangzhou is enclosed by revolutionary party members. People in Caozhou and Shangtou oppose imperial system and demand their governments to be independent. Bei County in Guangzhou is occupied by the republican troops. Government troops in Qingyuan, Guangdong, subjugated to the republican troops. | China | http://trove.nla.gov.au/newspaper/page/24095200 | 24095200 |
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]);