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 |
---|---|---|---|---|---|---|---|---|---|
21441 | 21441 | 1909-08-07 | 3 | b | Clashes between Morocco and Spain. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21442 | 21442 | 1909-08-07 | 3 | c | British colonies have a conference in London on military defence. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21443 | 21443 | 1909-08-07 | 3 | c | Britain and Japan are to organise an exhibition. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21444 | 21444 | 1909-08-07 | 3 | c | Tsar of Russia, Nicholas II, visits France, Italy and Turkey. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21445 | 21445 | 1909-08-07 | 3 | c | Earthquake in Mexico and report on the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21446 | 21446 | 1909-08-07 | 3 | c | Flooding in Jilin province, Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21447 | 21447 | 1909-08-07 | 3 | c | Flooding in Osaka, Japan. | Britain | http://trove.nla.gov.au/newspaper/page/26802279 | 26802279 | |
21453 | 21453 | 1909-08-07 | 6 | b-c | Constitutional crisis in Turkey and the reform movement. | Britain | http://trove.nla.gov.au/newspaper/page/26802284 | 26802284 |
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]);