This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16826 | 16826 | 1907-01-26 | 3 | b | Chaos in Russia. Tsar says Russian economy in chaos and needs foreign loans to recover. Russian prime minister and the proposed political reform. Eight cannons are stolen in Turkmenistan probably by revolutionaries. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 | |
16831 | 16831 | 1907-01-26 | 3 | c | An exhibition fair will be held next month in London for the local products of South Africa, which will be opened by the King of Britain. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 | |
16832 | 16832 | 1907-01-26 | 3 | c | Afghan ahung and his followers visit Indian and a detailed report. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 | |
16833 | 16833 | 1907-01-26 | 3 | c | Japanese authority seeks to double its naval force by 1915. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 | |
16834 | 16834 | 1907-01-26 | 3 | c | Coronation of the new King of Persia. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 | |
16836 | 16836 | 1907-01-26 | 3 | c-d | Earthquake in Kingston, Jamaica, and the casualties. Report by Tung Wah Times on the country Jamaica. | Australia | http://trove.nla.gov.au/newspaper/page/26801206 | 26801206 |
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]);