This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29029 | 29029 | 1914-07-11 | 2 | a-b | Editorial by the Tung Wah Times on the suffering of Chinese fellows in Noumea, New Caledonia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 | |
29030 | 29030 | 1914-07-11 | 2 | b | Guangdong military governor Long Jiguang and governor Li Kaishen jointly write to the Chinese Chamber of Commerce in Sydney and call for donations to the flood victims in their home province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 | |
29031 | 29031 | 1914-07-11 | 2 | b-c | Orders issued by Chinese President Yuan Shikai on May 24 on the revised constitution and others. | China | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 | |
29032 | 29032 | 1914-07-11 | 2 | c-d | Newly appointed state councillors in China and their backgrounds (Xu Shichang, Sun Baoqi, Liang Dunyan, Zhu Qiqin, Zhang Qian, Duan Qirui, Zhang Zongxiang, Zhou Ziqin, Tang Hualong and Liu Guanxiong). | China | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 | |
29033 | 29033 | 1914-07-11 | 2 | d | Chinese Education Minister Tang Hualong orders to worship Confucianism and the instructions. | China | http://trove.nla.gov.au/newspaper/page/24093172 | 24093172 |
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]);