This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8631 | 8631 | 1901-09-25 | 2 | d | Sydney saw a storm recently. | Australia | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8637 | 8637 | 1901-09-25 | 2 | e | Bank notes were stolen from a house in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8638 | 8638 | 1901-09-25 | 2 | f | A Sydney man was sentenced for fraud. | Australia | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8648 | 8648 | 1901-09-25 | 3 | b | A Sydney businessman discussed with a journalist about the proposals to ban entry of Chinese and Japanese into Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8649 | 8649 | 1901-09-25 | 3 | c | A woman in Sydney was compensated for defamation. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8651 | 8651 | 1901-09-25 | 3 | d | Representatives from Gibbs Bright & Co, Nippon Yusen Haisha Japan Mail Steamship Co, and China Navigation Co. went to see Prime Minister Barton on the new regulation to ban entry of Chinese into Australia. Record of their talks. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 |
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]);