This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24134 | 24134 | 1911-01-07 | 7 | a | Australian news | The Commonwealth government released a new legislation to ban opium; the survey on the numbers of naturalisation in Australia; Hanyang steel sells well in Australia; the Minister of Australia Defence requested to establish a Navy College before the British military commander finishes his survey on Australia's national defence; the jurisdiction of Nortern Territory is now transferred from South Australia to the Commonwealth; the numbers of money notes produced by the Commonwealth; Australia implements compulsory military service law; aboriginal crown coronation taking place in Bortmin in NSW ; Murder or suicide in Glanviwlle in South Australia; an American sugar industrialist visited Sydney, warning Australia to keep eyes on Japan which might invade Australia's north. | Australia | http://trove.nla.gov.au/newspaper/page/24091592 | 24091592 |
24135 | 24135 | 1911-01-07 | 7 | b | London's anarchist Party | The headquarter of the anarchist party was destroyed by London's polices. | Britain | http://trove.nla.gov.au/newspaper/page/24091592 | 24091592 |
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]);