This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45191 | 45191 | 1926-10-02 | 5 | a-c | Miscellaneous report on war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101729 | 24101729 | |
45195 | 45195 | 1926-10-02 | 7 | a-c | Australia news/ Foreign missions in Melbourne have a party chaired by Wei Zijing, Chinese Consul-General. Chinese fighting in Footscray, Melbourne. Tourist in Sydney is stolen. Russian refugees speak in Sydney. Sydney police raid Chinese gambling dens. Passengers on board of liner Taiping. Price of tap water increased for the Chinese gardens in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 |
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]);