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 |
---|---|---|---|---|---|---|---|---|---|
10625 | 10625 | 1902-05-17 | 2 | e | Australian soldiers in Transvaal were rewarded for their bravery in the Boer War, South Africa, | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10626 | 10626 | 1902-05-17 | 2 | e | A special newspaper in Adelaide for the blind people. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10627 | 10627 | 1902-05-17 | 2 | e | A baby was found dead in Sydney railway station; young woman of Sydney committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10628 | 10628 | 1902-05-17 | 2 | f | Statistics of epidemics in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10629 | 10629 | 1902-05-17 | 2 | f | Lord Hopetoun, Governor General of Australia, wrote to thank Adelaide people for their kind hospitality. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10630 | 10630 | 1902-05-17 | 2 | f | A Brisbane company for express travel services is bankrupt. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
10645 | 10645 | 1902-05-17 | 3 | d | All Chinese houses in Alexandria, New South Wales, have been demolished because one of them was infected with the epidemic disease. | Australia | http://trove.nla.gov.au/newspaper/page/24100427 | 24100427 |
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]);