This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21877 | 21877 | 1909-10-30 | 3 | b | Hurricane in Hong Kong and India and the disaster. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21878 | 21878 | 1909-10-30 | 3 | b | Reconstruction is nearly completed in San Francisco (since the earthquake). | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21879 | 21879 | 1909-10-30 | 3 | b | Russian government is determined to take away Viborg from Finland. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21880 | 21880 | 1909-10-30 | 3 | b | Spain has a new cabinet. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21881 | 21881 | 1909-10-30 | 3 | b | Germany builds new warship, Thuringia. Naval budget and equipment of Britain, American, Germany, France, Japan and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21882 | 21882 | 1909-10-30 | 3 | b-c | Italy welcomes Tsar of Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21883 | 21883 | 1909-10-30 | 3 | c | Earthquake in Sicily, Italy, and Baluchistan in Asia. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21884 | 21884 | 1909-10-30 | 3 | c | Wealthy American man (Morgan) purchases porcelain from China. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21885 | 21885 | 1909-10-30 | 3 | c | American government responds to the Manchuria treaty signed between China and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/26802375 | 26802375 | |
21889 | 21889 | 1909-10-30 | 6 | b | Ito Hirobumi is assassinated by An Chung-gun, a member of the Korean independence movement, in Harbin. | Britain | http://trove.nla.gov.au/newspaper/page/26802380 | 26802380 |
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]);