This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25193 | 25193 | 1911-10-28 | 3 | a-b | Revolutionary riots in China | Revolutionary riots are in Hankou, Hubei, Hunan and other places. | China | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
25194 | 25194 | 1911-10-28 | 3 | b | Portuguese royal party | Members of Portuguese royal party are captured. | Other... | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
25195 | 25195 | 1911-10-28 | 3 | b | Canadian parliament is to open | Canadian parliament is to open soon. | Other... | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
25196 | 25196 | 1911-10-28 | 3 | b-c | Census in Canada | Current population in Canada. | Other... | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
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 |
25199 | 25199 | 1911-10-28 | 3 | c-d | Guangdong news | Members of railway protection society suggest to support people on the railway issue. Budget cut for each department. China's hard-time negotiation with Portugal over Macao. Two battalions sent to Sichuan. Fights between two villages. Revolutionary pigtail cutters arrested. Staff from Zhongyuan Newspaper questioned. | Other... | http://trove.nla.gov.au/newspaper/page/24091975 | 24091975 |
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]);