This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22420 | 22420 | 1910-02-26 | 3 | a-b | Californian senator proposes to ban entry of Japanese immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22421 | 22421 | 1910-02-26 | 3 | b | Tsar of Russia and his navy. | Britain | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22422 | 22422 | 1910-02-26 | 3 | b | Chinese orders powerful cannon from German arsenal. | Britain | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22423 | 22423 | 1910-02-26 | 3 | b | An Chung-gun is sentenced to death for assassination of Ito Hirobumi. | Britain | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22424 | 22424 | 1910-02-26 | 3 | b | British department of foreign affairs agrees to return the mines in Anhui province to China at a price. | Britain | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22425 | 22425 | 1910-02-26 | 3 | b | German newspaper on German's interest in Manchuria and China. | Germany | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22426 | 22426 | 1910-02-26 | 3 | b-c | Chinese students in Java are penalised for fighting with Dutch and local students. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22427 | 22427 | 1910-02-26 | 3 | c | A public notice from the Chinese Consulate General in Melbourne on a census of Chinese population in Australia, and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
22428 | 22428 | 1910-02-26 | 3 | c-d | Correspondence from Beijing/ Government departments in Beijing and their operation. | China | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 |
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]);