This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50892 | 50892 | 1931-11-21 | 5 | a | University professors in Shanghai put forward their proposal to save China. | China | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 | |
50893 | 50893 | 1931-11-21 | 5 | d | First part of a letter from Chen Jiongming to Cai Yuanpei and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 | |
50894 | 50894 | 1931-11-21 | 5 | e | Chinese communities in Sydney gather and mourn the countrymen killed by Japanese troops in Manchuria. Chinese Chamber of Commerce and the zhi gong tang in Sydney farewell former Chinese consul-general Guizhi, Liu Guangfu and his wife on their departure for China, and speakers include Zhu Songqing, Huang Zhu, Ye Bingnan, Wu Gen, Ma Xinsi, Huang Guangzhao, Liang Bai, Guo Jianying, Zhang Fuxiang, Liu Guangfu and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 |
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]);