This data as json, CSV (advanced)
Suggested facets: page, source, 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 | |
22069 | 22069 | 1909-12-04 | 6 | b | Disasters in Fujian province (drought, fire, and hurricane). | China | http://trove.nla.gov.au/newspaper/page/26802420 | 26802420 | |
22077 | 22077 | 1909-12-04 | 7 | b | State parliament of New South Wales debates restrictions on Chinese workshop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802419 | 26802419 | |
22078 | 22078 | 1909-12-04 | 7 | b | First Chinese consul to Germany, Samoa Lin Runzhao, has taken his office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802419 | 26802419 | |
22079 | 22079 | 1909-12-04 | 7 | b | A public notice from Chinese Bazaar in New Zealand. | Tung Wah | 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]);