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 |
---|---|---|---|---|---|---|---|---|---|
14836 | 14836 | 1905-09-30 | 3 | a | Report on a clash between Canadian gunboats and American fishing men. | Australia | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14837 | 14837 | 1905-09-30 | 3 | a | Dalai Lama has left Mongolia but is reluctant to return to Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14838 | 14838 | 1905-09-30 | 3 | a | Finland may see chaos in the near future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14839 | 14839 | 1905-09-30 | 3 | a | Reports on the chaos in Russia. | Other... | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14840 | 14840 | 1905-09-30 | 3 | a | Every citizen is required to be a soldier in the Netherlands. | Australia | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14841 | 14841 | 1905-09-30 | 3 | a | Britain is to build a navy base in Singapore. | Australia | http://trove.nla.gov.au/newspaper/page/26800787 | 26800787 | |
14845 | 14845 | 1905-09-30 | Suppl't | a | Report by See Yup Society, Melbourne Chinese communities protest against the renewed American immigration policy that ban Chinese entry. Chinese businessmen in Sydney protest against American immigration policy and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800789 | 26800789 |
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]);