This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25286 | 25286 | 1911-11-18 | 2 | c-d | Crisis in Mongolia | Mongolian king secretly makes deal with Russia for protection and the latter sends more troops to Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24092002 | 24092002 |
25291 | 25291 | 1911-11-18 | 3 | c-d | Guangdong news | Poor budget of Guangdong government. A big gun is put in front of the building of Guangdong governor's. More people are exchanging paper money for silver money. New Association is to build shopping center. Robberies rise in Sheng Dushui, Guangdong. Two robberies occur in Bai Tu Xu, Guangdong. Government troops are gathering in Guangzhou for preventing riots. | China | http://trove.nla.gov.au/newspaper/page/24092001 | 24092001 |
25303 | 25303 | 1911-11-18 | 8 | c-d | Criticising East Warning newspaper | East Warning newspaper should not make rumours and attack good people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092008 | 24092008 |
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]);