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 |
---|---|---|---|---|---|---|---|---|---|
24791 | 24791 | 1911-08-05 | 3 | a | Morocco riots | Morocco Riots affect the relations among Britain, France and Gernany. | Britain | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24792 | 24792 | 1911-08-05 | 3 | a | Turkey fire | Fire in Turkey destroyed thousands of houses and other properties. | Other... | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24793 | 24793 | 1911-08-05 | 3 | a | Hurricane in Japan | About 100 people are killed in hurricane close to Japanese sea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24794 | 24794 | 1911-08-05 | 3 | a | Flooding in China | Flooding in Yangtze River area and the casualties. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24804 | 24804 | 1911-08-05 | 6 | a | Notice of International Chinese Students Association Paper | International Chinese Students Association Paper is issued in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091871 | 24091871 |
24809 | 24809 | 1911-08-05 | 7 | a | Australia news | Investigation statistics of New South Wales institutes. Fi She (nnn), Australian premier wants Australia to be independant. More opium smuggles are exposed. Ya Chang, a Chinese merchant, is robbed in Sydney. More Chinese were attacked in Sydney. Proposal of land nationalisation cause debates in parliament. Intensified strike in Tasmania. New commonwealth governor is to take office. A Chinese woman is to be expelled. Attacks on Chinese occurred in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091870 | 24091870 |
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]);