This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18865 | 18865 | 1908-02-15 | 3 | a-b | Russia to build double-track for the Trans-Siberia Railroad. | Britain | http://trove.nla.gov.au/newspaper/page/26801628 | 26801628 | |
18867 | 18867 | 1908-02-15 | 3 | b | Transvaal (South African) authority relaxes its restrictions upon Chinese and Indian immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/26801628 | 26801628 | |
18870 | 18870 | 1908-02-15 | 3 | b | Important news. Chinese customs officers raid a Japanese cargo ship near Macao that smuggles weapon for Sun Yatsen. Rumours in Paris, Berlin and Vienna that the Tsar of Russia has been assassinated. Many unemployed and homeless people in America. | Britain | http://trove.nla.gov.au/newspaper/page/26801628 | 26801628 | |
18871 | 18871 | 1908-02-15 | 3 | b-c | King of Portugal is assassinated. Assassinations of the world in the past 50 years. | Britain | http://trove.nla.gov.au/newspaper/page/26801628 | 26801628 |
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]);