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 |
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]);