This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41670 | 41670 | 1924-06-07 | 7 | a | Bank notes that are supposed to be destroyed can still be found in the Melbourne market. | Australia | http://trove.nla.gov.au/newspaper/page/24100748 | 24100748 | |
41671 | 41671 | 1924-06-07 | 7 | a | Young and arrogant Russia immigrant is detained in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100748 | 24100748 | |
41672 | 41672 | 1924-06-07 | 7 | a | Investigation on a robbery in Paddington, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100748 | 24100748 | |
41673 | 41673 | 1924-06-07 | 7 | a | Customs officers in Fremantle, Western Australia, seize smuggled weapons in a Dutch ship. | Australia | http://trove.nla.gov.au/newspaper/page/24100748 | 24100748 | |
41674 | 41674 | 1924-06-07 | 7 | a-b | Theft in Sydney Hotel. | Australia | http://trove.nla.gov.au/newspaper/page/24100748 | 24100748 |
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]);