This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45015 | 45015 | 1926-07-31 | 7 | a-c | Australia news/ Liners to Asian ports increase fares. Illegal Chinese immigrants detained in Singapore. Storm in Geelong, Victoria. Western priest talks on the Chinese situation on his return to Sydney. Japanese immigrants in north Queensland. Welcome ceremony at the Chinese Presbyterian church in Sydney for Rev. Liang Lanxin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101651 | 24101651 | |
45016 | 45016 | 1926-07-31 | 7 | c | Moscow dispatches communists activists to Finland, Poland, Germany and Romania. | Britain | http://trove.nla.gov.au/newspaper/page/24101651 | 24101651 | |
45017 | 45017 | 1926-07-31 | 7 | c | American Catholic father is kidnapped in the west of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24101651 | 24101651 |
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]);