This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44844 | 44844 | 1926-06-19 | 2 | d | A circular telegram issued by Yan Huiqing, premier of China. | China | http://trove.nla.gov.au/newspaper/page/24101600 | 24101600 | |
44845 | 44845 | 1926-06-19 | 2 | e | Wu Peifu talks on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24101600 | 24101600 | |
44846 | 44846 | 1926-06-19 | 2 | f | Arrests of political dissidents in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101600 | 24101600 | |
44847 | 44847 | 1926-06-19 | 3 | d | An anti-communist public gathering in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101599 | 24101599 | |
44848 | 44848 | 1926-06-19 | 3 | d | A reply from Sun Chuanfang to Yang Huiqing. | China | http://trove.nla.gov.au/newspaper/page/24101599 | 24101599 | |
44849 | 44849 | 1926-06-19 | 3 | d | Wu Peifu is preparing to aid Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24101599 | 24101599 | |
44850 | 44850 | 1926-06-19 | 3 | f | Feng Yuxiang arrives Moscow. | China | http://trove.nla.gov.au/newspaper/page/24101599 | 24101599 | |
44851 | 44851 | 1926-06-19 | 3 | f | Liang Qichao is seriously ill. | China | http://trove.nla.gov.au/newspaper/page/24101599 | 24101599 | |
44852 | 44852 | 1926-06-19 | 5 | a | Wife of a Canadian Methodist minister is murdered in Sichuan province, China, and the murderer is executed. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44855 | 44855 | 1926-06-19 | 5 | a | Drought in south Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44857 | 44857 | 1926-06-19 | 5 | a | Foreign minister of the Guangzhou government is ready to talk with Hong Kong authority to end the strike. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44858 | 44858 | 1926-06-19 | 5 | b | The Guangzhou government aids Hunan authority. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44859 | 44859 | 1926-06-19 | 5 | b | Foreigners injured in Sichuan during the battles. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44860 | 44860 | 1926-06-19 | 5 | b | The Outer Mongolia under the control of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24101601 | 24101601 | |
44866 | 44866 | 1926-06-19 | 8 | a-d | Guangdong news/ Jiang Jieshi seeks alliance from Sun Chuanfang. Xu Qian sends another telegram to the Guangzhou government. Envoy of Xu Chongzhi on the way to Guangzhou. Guarantee needed for the release of Li Zhilong. | China | http://trove.nla.gov.au/newspaper/page/24101606 | 24101606 |
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]);