This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45341 | 45341 | 1926-12-04 | 7 | a-d | Australia news/ Sydney police raid Chinese gambling dens. Export of Sanders from Western Australia to China. Sale of local products in Sydney. Two men are sentenced for raping in Bondi, Sydney. Cashier is found stealing money for the Sydney shop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101803 | 24101803 | |
45342 | 45342 | 1926-12-04 | 7 | b-d | The crisis in Hankou, of Hubei province. British involvement in the Chinese crisis. | China | http://trove.nla.gov.au/newspaper/page/24101803 | 24101803 |
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]);