This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25184 | 25184 | 1911-10-28 | 2 | a-b | People should support government to protect their country | Revolution is leading to collapse of old government, the future of China is uncertain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091976 | 24091976 |
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 |
25202 | 25202 | 1911-10-28 | 6 | a-b | Procuratorate | Liu Zhongtang asks for keeping procuratorate. | Other... | http://trove.nla.gov.au/newspaper/page/24091980 | 24091980 |
25205 | 25205 | 1911-10-28 | 7 | a-b | Australian news | Celebration for Confucius's birthday. Federal army chief asks for attention to Japan. Sydney train station is to be built. Sydney World Workers Union Conference opened yesterday. Chairman of Sydney Imperial Constitution Association gives a report on his visit to China. Celebration for Confucius's birthday held outside Sydney. | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 | |
25212 | 25212 | 1911-10-28 | suppl. | a-b | On revolution | Article on various terms and contents of revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24091981 | 24091981 |
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]);