This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50001 | 50001 | 1931-02-14 | 8 | b | Bank collapses in Paris. | France | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50002 | 50002 | 1931-02-14 | 8 | b | Sale of Australian wheat in China. | Canada | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50003 | 50003 | 1931-02-14 | 8 | b | The plague in the west of India. | Other... | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50004 | 50004 | 1931-02-14 | 8 | b | Cruelty to the prisoners in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50005 | 50005 | 1931-02-14 | 8 | b | Indian government sells public bonds in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50006 | 50006 | 1931-02-14 | 8 | b | Hurricane in Japan and the damages. | Japan | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50007 | 50007 | 1931-02-14 | 8 | b | Collision of French and Japanese ships. | Britain | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50008 | 50008 | 1931-02-14 | 8 | c | Australia news/ Governments raise funds to help the farmers who suffer from the lowest wheat price. Further report on the earthquake in New Zealand. Heavy rain and the damages in Lismore. Chinese Consul-General Gui Zhi visits state governor of New South Wales. Chinese Consulate-General negotiates with a Sydney hospital about Chinese patient Liu Tao. New survey on the Australian population. Floods in Queensland. Rescue work in New Zealand after the earthquake. Astronomical observatory predicts another earthquake. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50009 | 50009 | 1931-02-14 | 8 | e | Notice issued by Chinese Consul-General in Australia Gui Zhi on the application for Chinese passport on return. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 |
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]);