This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13969 | 13969 | 1904-11-05 | 2-3 | d | Bandits and civil corps in Shunde county. Soldiers in Guangdong are to cut their pigtail and change uniform. Governor Qin Chunxuan in Guangxi once again in order to suppress bandits there. Bandits and social chaos in Huaiji county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/26800560 | 26800560 |
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]);