This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51230 | 51230 | 1932-02-27 | 5 | a | Australia news/ The 19th meeting of the Sydney Chinese Saving China Association and their telegram to the 19th Route Army in Shanghai. Chinese doctor Tan Liangnan flies from Sydney to Tenterfield to see his patient. Chinese businessman in Cobar, NSW, Huang Huazhi, dies and leaves huge amount of inheritance. Telegram from the Tung Wah Hospital in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090713 | 24090713 | |
51231 | 51231 | 1932-02-27 | 5 | c | Zhang Minli organises the Saving China Army in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090713 | 24090713 | |
51232 | 51232 | 1932-02-27 | 5 | d | Politicians in Tianjin organise an association to promote the constitutional reform. | China | http://trove.nla.gov.au/newspaper/page/24090713 | 24090713 | |
51233 | 51233 | 1932-02-27 | 5 | d | Chinese communities in Sydney donate to the military funds for resistance to Japanese invasion, and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090713 | 24090713 |
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]);