This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24758 | 24758 | 1911-07-29 | 3 | a | Corruption in Russia | Corrupted officials have been prosecuted. | Russia | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24759 | 24759 | 1911-07-29 | 3 | a | Riots in Persia | Several riots in Persia. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24760 | 24760 | 1911-07-29 | 3 | a | Strikes in Britain | Strikes spread all over Britain and as a result several Chinese laundries were burned down. | Britain | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24761 | 24761 | 1911-07-29 | 3 | a | Japanese King visits China | Japanese King is to visit China. | Other... | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24762 | 24762 | 1911-07-29 | 3 | a | Canada issues entry restrictions on Chinese | Canada issues entry restrictions on Chinese. | Canada | http://trove.nla.gov.au/newspaper/page/24091858 | 24091858 |
24769 | 24769 | 1911-07-29 | 6 | a | China-America joint ventures | China and America are to set up a China-America bank and China-America ship company. | China | http://trove.nla.gov.au/newspaper/page/24091863 | 24091863 |
24779 | 24779 | 1911-07-29 | 8 | a | Refute Sun Wen's fallacy | The article is on Sun Wen's speech made in New York. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091865 | 24091865 |
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]);