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 |
---|---|---|---|---|---|---|---|---|---|
52551 | 52551 | 1933-02-18 | 2 | f | Rich people in Beijing are in panic. | China | http://trove.nla.gov.au/newspaper/page/24091122 | 24091122 | |
52552 | 52552 | 1933-02-18 | 2 | f | Japanese seek to block the move of Chinese armies. | China | http://trove.nla.gov.au/newspaper/page/24091122 | 24091122 | |
52553 | 52553 | 1933-02-18 | 2 | f | Wong Zhaoyuan, Tan Qixiu and Zhang Yan are awarded in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091122 | 24091122 | |
52554 | 52554 | 1933-02-18 | 2 | f | Both China and Japan are to purchase weapons from America. | Britain | http://trove.nla.gov.au/newspaper/page/24091122 | 24091122 | |
52555 | 52555 | 1933-02-18 | 2 | f | Declaration of the Chinese Civil Rights Protection Alliance in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091122 | 24091122 | |
52578 | 52578 | 1933-02-18 | 6 | f | Report on the trade conference organised in Canberra by the federal Ministry of Trade. Photograph of Zhu Songqing, chairman of the Chinese Chamber of Commerce in NSW, Chen Weipin, Chinese Consul-General in Sydney, and their Dutch counterparts outside of the trade conference in Canberra. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091126 | 24091126 |
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]);