This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31009 | 31009 | 1916-03-04 | 7 | a-b | Australia news/Sydney starts to construct its internal railways. A German shop in Sydney is bombed. Statistics show that crimes in New South Wales increase this year. Infantile paralysis is spreading in New Zealand resulting in schools closing. Government does not regulate the closing time of public bars in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24095182 | 24095182 |
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]);