This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24775 | 24775 | 1911-07-29 | 7 | a-c | Australian news | A speech by an Australian navy official about the Pacific Ocean and Australia (Australia in danger). More Chinese illegally arrive in Australia with fake passports. Governor General advocates Australia to be independent from Britain. Australian revenue from postage and tax. The issue of gambling of Chinese people. Albambra Theatre opens. Form Chinese consul-general to Australia writes to all Chinese in Australia. Sugar workers on strike. | Other... | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24776 | 24776 | 1911-07-29 | 7 | c | Recruitment of foreign engineer | Transport Department recruits a foreign chief engineer. | China | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24777 | 24777 | 1911-07-29 | 7 | c | Mexican government promises compensation | Mexican government promises compensation for those Chinese killed recently. | Other... | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
24778 | 24778 | 1911-07-29 | 7 | c | Thefts in Guangdong | Thefts are popular in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24091862 | 24091862 |
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]);