This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26267 | 26267 | 1912-06-08 | 7 | a-b | Australian news | Draught in New South Wales has led to widespread worries. A soldier was punished for his smoking at military exercise for celebrating British emperor's birthday. Two Indian criminals were sentenced to death for their killing a man in Fiji. The Japanese ship with its smallpox patient cured was released. A station warehouse in New South Wales was stolen. A printing company in Sydney was burned resulting in huge loss. A group of scandals fought with policemen with 6,000 people watching in a Sydney circus. A Melbourne woman was arrested for killing her child. Statistics of wine consumption in Victoria. An European couple in Sydney attempted to divorce due to misunderstanding. | Australia | http://trove.nla.gov.au/newspaper/page/24092267 | 24092267 |
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]);