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 |
---|---|---|---|---|---|---|---|---|---|
20708 | 20708 | 1909-02-27 | 6 | b | Earthquake in Persia. | Britain | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20709 | 20709 | 1909-02-27 | 6 | b | Anarchist in Russia under arrest. | Britain | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20710 | 20710 | 1909-02-27 | 6 | b | A series of murder in Germany has claimed 31 woman victims. | Britain | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20711 | 20711 | 1909-02-27 | 6 | b | American government to keep some naval forces in the Pacific. | Britain | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20712 | 20712 | 1909-02-27 | 6 | b | Four woman activists are detained in Britain for demonstration. | Britain | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20713 | 20713 | 1909-02-27 | 6 | b | American President Roosevelt comments on the debate in Californian parliament on the Japanese and Chinese immigration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20714 | 20714 | 1909-02-27 | 6 | b | Former president of the United States to visit Japan and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20715 | 20715 | 1909-02-27 | 6 | b | Russian authority expands its army significantly. | Russia | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20716 | 20716 | 1909-02-27 | 6 | b | The third international fishing conference in Washington. | America | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
20723 | 20723 | 1909-02-27 | 7 | b | Thirty-five Chinese in Redfern, Sydney, are penalised for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20724 | 20724 | 1909-02-27 | 7 | b | Several cases of opium smuggling in Sydney and the involvement of Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20725 | 20725 | 1909-02-27 | 7 | b | A Chinese man in Sydney murders his white girlfriend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 |
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]);