This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46420 | 46420 | 1927-11-12 | 5 | a | The Sun Club in Berlin and their naked sunbath. | Germany | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46421 | 46421 | 1927-11-12 | 5 | a | Soldiers of the Nationalist government ask for payment of their salary. The Communist forces occupy Yixing, Jiangsu province. A British woman is injured in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
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 |
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]);