This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25840 | 25840 | 1912-03-09 | 3 | b | Another riot in Mexico | American president notifies Americans not to go to Mexico as there occurs another riot over position of president. | America | http://trove.nla.gov.au/newspaper/page/24092156 | 24092156 |
25841 | 25841 | 1912-03-09 | 3 | b | News of Beijing's troop riot | A troop in Beijing started a terrifying riot over pay reduction, leading to huge robberies and destruction of shops. Foreign troops are ordered to go into Beijing for protecting their embassies. Yuan Shikai blamed the rumours for cutting soldiers' pay that caused the riot. Yuan's power has been shaken by the troop riot. | http://trove.nla.gov.au/newspaper/page/24092156 | 24092156 | |
25855 | 25855 | 1912-03-09 | 8 | b | Guangdong railway issue | Guangdong railway sharers hold its general meeting. | Other... | http://trove.nla.gov.au/newspaper/page/24092163 | 24092163 |
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]);