This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37931 | 37931 | 1921-12-03 | 3 | b | Sichuan troops are defeated by the Zhili army from the north. | China | http://trove.nla.gov.au/newspaper/page/24093774 | 24093774 | |
37932 | 37932 | 1921-12-03 | 3 | b | Progress of negotiation with Portuguese authority over the military conflict near Macao. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093774 | 24093774 | |
37944 | 37944 | 1921-12-03 | 7 | b | A Sydney city councillor is charged with corruption. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 | |
37945 | 37945 | 1921-12-03 | 7 | b | Pinnacle of the Queen Victoria Building is struck by lightening. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 | |
37946 | 37946 | 1921-12-03 | 7 | b | Sydney Museum collects Chinese opium smoking paraphernalia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 | |
37947 | 37947 | 1921-12-03 | 7 | b | A Chinese market gardener in Sydney is penalised for horse abuse. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 | |
37948 | 37948 | 1921-12-03 | 7 | b | A young mother in New South Wales is arrested for burying her baby daughter under the house. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093778 | 24093778 |
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]);