This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54800 | 54800 | 1935-01-19 | 3 | d | Huang Shaoxiong becomes governor of Zhejiang province and his team. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54807 | 54807 | 1935-01-19 | 6 | d | Australia news/ Storm in Victoria and the damages. Chinese ferry in Melbourne has an accident. Chinese swimmer Guo Zhenheng joins the competition in Canberra. Chinese government murders journalists. Japanese are very confident in the New Year. Chinese General Qiu Zhaoshen tours Albury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 |
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]);