This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45509 | 45509 | 1927-02-26 | 7 | a-b | Australia news/ A boy in Sydney is stung by spider. Robbery in a Sydney church. Two women are arrested on board of German liner for pretending to be man. Bomb explosion in Sydney. Chinese community in Sydney donate to Dongguan hospital. Duke of York arrives Auckland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 | |
45510 | 45510 | 1927-02-26 | 7 | b-c | County magistrate in Xiangshan is besieged by bandits and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 | |
45511 | 45511 | 1927-02-26 | 7 | c-d | Names listed for donations to the Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 |
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]);