This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25706 | 25706 | 1912-02-10 | 2 | d | Pitiful Beijing | With a fake imperial edict, many Beijing people cut their pigtails. Sichuan. Hubei and other provinces stop their donations to Beijing after they announced independent. Prince Zan Xun lives in fear and panic. | Other... | http://trove.nla.gov.au/newspaper/page/24092099 | 24092099 |
25707 | 25707 | 1912-02-10 | 2 | d | Grievous news from Henan | About 30 people arrested for their intention of overthrowing government in Henan. | Other... | http://trove.nla.gov.au/newspaper/page/24092099 | 24092099 |
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]);