This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25160 | 25160 | 1911-10-21 | 2 | a-b | Revolution unrest results from railways unrest in China | The revolutionary riots and unrest are actually caused by the railways unrest in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25170 | 25170 | 1911-10-21 | 6 | a-b | Navy world | Budget of Japanese navy. Military expenses comparison of various military powers. | Other... | http://trove.nla.gov.au/newspaper/page/24091971 | 24091971 |
25173 | 25173 | 1911-10-21 | 7 | a-b | Australia news | Pan Yunkong answers Business Protection Association. Japanese bankers are coming to visit Australia. Trade unions are getting more powerful. Newcastle shipwreck killed 15 seamen. A fire in a Melbourne company resulted in heavy loss. A navy institute is to set up in Sydney. People in Sydney oppose exhibition conference. Test results of Sydney China's Primary School. Memorising Confucius' birthday in Sydney. False wines were found in Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24091970 | 24091970 |
25176 | 25176 | 1911-10-21 | 8 | a-b | Sheng Xuanhui should be killed to pacify anger of the people | Nationalisation initiated by Sheng Xuanhui resulted in disasters for China. | China | http://trove.nla.gov.au/newspaper/page/24091973 | 24091973 |
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]);