This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 22321 | 22321 | 1910-01-29 | 3 | b | Empress of Russia is ill. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22322 | 22322 | 1910-01-29 | 3 | b-c | A drama in Deccan, India, incites rebellion against British colonist, and is widely supported by local residents. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22323 | 22323 | 1910-01-29 | 3 | c | Both Germany and France experience an increase in their international trade in 1909. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22324 | 22324 | 1910-01-29 | 3 | c | China purchases cannon from Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22325 | 22325 | 1910-01-29 | 3 | c | Royal palace in Turkey on fire while American and Russian sailors turn into firefighters. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22326 | 22326 | 1910-01-29 | 3 | c | Canadian and American governments to jointly build a railway from Winnipeg to Yukon. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22327 | 22327 | 1910-01-29 | 3 | c | Russia and Japan compete against each other in Manchuria; the response from America. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22328 | 22328 | 1910-01-29 | 3 | c | Earthquake in Paris. | Britain | http://trove.nla.gov.au/newspaper/page/26802479 | 26802479 | |
| 22333 | 22333 | 1910-01-29 | 6 | b | Britain, France, Germany and America will all be involved in the loan to Sichuan-Hubei railway construction. | Britain | http://trove.nla.gov.au/newspaper/page/26802484 | 26802484 |
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]);