This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24746 | 24746 | 1911-07-22 | 7 | a-b | Australian news | Thailand buys horses from Australia. American businessmen associations plansto have an Australia tour group to visit Australia. Less tax for Fiji bananas. Governor general to Australia is returning to Australia. More opium cases. A meeting for imperial constitution. A Chinese businessman is robbed. | Other... | http://trove.nla.gov.au/newspaper/page/24091854 | 24091854 |
24747 | 24747 | 1911-07-22 | 7 | b-c | Donations to those killed in Mexico | Donations are sought for those killed in Mexico. Donators include Wang Zhongxiang, Ouyang Ruqiao and Tang Dirong. | Other... | http://trove.nla.gov.au/newspaper/page/24091854 | 24091854 |
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]);