This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 |
25174 | 25174 | 1911-10-21 | 7 | b | Revolution unrest | Revolutionary uprising in Wu Chang led to foreigners to escape and Yuang Shikai is appointed the governor of Hubei Province. | China | http://trove.nla.gov.au/newspaper/page/24091970 | 24091970 |
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]);