This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16284 | 16284 | 1906-10-06 | 3 | a | Leader of Finnish revolutionary movement and his entourage are captured in the capital of Sweden. A Swedish ship is intercepted while transporting 3,000 rifles to Finland. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16285 | 16285 | 1906-10-06 | 3 | a | One hundred thousand troops from Balkan countries approach the border of Turkey. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16286 | 16286 | 1906-10-06 | 3 | a | Number of casualties of epidemic diseases in India from 1896 to 1906. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16287 | 16287 | 1906-10-06 | 3 | a | Nearly 1,000 Black people are in armed clash with Whites in Brownsville, United States of America. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16288 | 16288 | 1906-10-06 | 3 | a | 1,701 Chinese labourers are returning home from the South African mines. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16289 | 16289 | 1906-10-06 | 3 | a | In St Petersburg, the capital of Russian, nearly 200 political offenders are sent into exile every day. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 | |
16290 | 16290 | 1906-10-06 | 3 | a | Hurricane, floods and casualties in Alabama and Florida of the United States of America. | Australia | http://trove.nla.gov.au/newspaper/page/26801100 | 26801100 |
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]);