This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25187 | 25187 | 1911-10-28 | 2 | c | Hong Kong correspondence | Riots resulted from the railway issue in Sichuan. Only political parties try to save China. Branches of Constitution Society set up in other provinces. | Other... | http://trove.nla.gov.au/newspaper/page/24091976 | 24091976 |
25197 | 25197 | 1911-10-28 | 3 | c | Women's right for vote | American women try to win their right for vote. | America | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
25198 | 25198 | 1911-10-28 | 3 | c | Beijing news | Fund for imperial family is finalised. The Regent is frightened on his way home. Department of Education decides names of degrees. Lushun military port changed to be trade port. Member of state council tries to control overseas students. Secret message to crack down riots in Sichuan. | Other... | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
25210 | 25210 | 1911-10-28 | 8 | c | Donations to floods in Anhui | More than 50 people's names listed for their donations to floods in Anhui collected by China's consulate-general to Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24091982 | 24091982 |
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]);