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 |
|---|---|---|---|---|---|---|---|---|---|
| 22055 | 22055 | 1909-12-04 | 3 | b | American navy to build a naval port in Hawaii. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22056 | 22056 | 1909-12-04 | 3 | b | Corruption in Russian army. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22057 | 22057 | 1909-12-04 | 3 | b | Duan Fang has been removed from his position. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22058 | 22058 | 1909-12-04 | 3 | b | Britain builds another dockyard in Swansea. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22059 | 22059 | 1909-12-04 | 3 | b | Twenty thousand woman workers in New York are on strike for more pay. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22060 | 22060 | 1909-12-04 | 3 | b | Accident in a coal mine in Japan claims more than 15 lives. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22061 | 22061 | 1909-12-04 | 3 | b-c | France, Germany and Argentina expand their naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22062 | 22062 | 1909-12-04 | 3 | c | Local residents in north Persia attack Russian consulate. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22063 | 22063 | 1909-12-04 | 3 | c | King of Portugal arrives in France for a visit. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22064 | 22064 | 1909-12-04 | 3 | c | Expense for the funeral of late Emperor Guangxu. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22065 | 22065 | 1909-12-04 | 3 | c | Germany launches another warship Thuringin. Tonnage of British, German and American naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/26802415 | 26802415 | |
| 22075 | 22075 | 1909-12-04 | 7 | a | Australia welcomes immigrants from Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802419 | 26802419 |
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]);