This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25311 | 25311 | 1911-11-25 | 2 | c-d | Progress of revolution | Revolutions spring up everywhere in China. Conflicts between government and revolutionaries are intensified. | http://trove.nla.gov.au/newspaper/page/24092010 | 24092010 | |
25321 | 25321 | 1911-11-25 | 3 | c-d | Guangdong news | Governor orders to stop collecting taxation from people. Governor asks for postpone of implementing the new administration. Foreign warships arrive one after another in Guangdong. The advisory committee states it did not receive a message from Hubei. The autumn military exercise is postponed. Sichuan army asks for its soldiers in Guangdong back to Sichuan due to increasing revolutionary riots there. | Other... | http://trove.nla.gov.au/newspaper/page/24092009 | 24092009 |
25337 | 25337 | 1911-11-25 | 8 | c-d | Proses | Several proses on various topics. | Other... | http://trove.nla.gov.au/newspaper/page/24092016 | 24092016 |
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]);