This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46425 | 46425 | 1927-11-12 | 7 | a | Australia news/ Captain of Dutch liner Almkerk is penalised in Freemantle, Western Australia, for illegal immigrants. Sailors found epidemic disease on board of liner from Singapore on arrival in Sydney. Bandits rob shops in Newtown, Sydney. Ferry Greycliffe sinks in Sydney harbour after a collision with another ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46426 | 46426 | 1927-11-12 | 7 | b | Floods in New England, America. | America | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46427 | 46427 | 1927-11-12 | 7 | b | Guangdong news/ Business in Foshan. Brief biography of Zou Minchu, acting treasurer of the provincial government. Sericulture in Zhongshan and Shunde county. Local security corps organised in Xinhui county. Land price in Zhongshan county. Vietnamese authority abolishes new regulations on Chinese medicine. | China | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 |
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]);