This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49988 | 49988 | 1931-02-14 | 2 | b | First part of editorial by Tung Wah Times on the silver price and the foreign debts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
49998 | 49998 | 1931-02-14 | 5 | c | Poems by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090273 | 24090273 | |
49999 | 49999 | 1931-02-14 | 5 | e | Various types of fish in the sea near Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090273 | 24090273 | |
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]);