This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41655 | 41655 | 1924-06-07 | 3 | a | Guangdong government extorts large sums of money from local residents. | China | http://trove.nla.gov.au/newspaper/page/24100744 | 24100744 | |
41666 | 41666 | 1924-06-07 | 6 | a | Tung Wah Times comments on the restrictions imposed by Australian government upon Chinese students (for their school education in Australia). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100749 | 24100749 | |
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 |
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]);