This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 32378 | 32378 | 1917-06-16 | 2 | a-c | Editorial by Tung Wah Times on the current international diplomacy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095729 | 24095729 | |
| 32379 | 32379 | 1917-06-16 | 2 | c | Comments written by anonymous author on the Chinese parliament and its members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095729 | 24095729 | |
| 32380 | 32380 | 1917-06-16 | 2 | d-f | Chinese Vice-President Feng Guozhang sues the Central China News (zhong yuan bao). An open letter from the Central China News (zhong yuan bao) to other newspapers. | China | http://trove.nla.gov.au/newspaper/page/24095729 | 24095729 | |
| 32381 | 32381 | 1917-06-16 | 2 | f | An open letter from Zhang Yan to Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24095729 | 24095729 | |
| 32382 | 32382 | 1917-06-16 | 3 | b | Chinese government should be cautious in its relationship with Germany. | China | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32383 | 32383 | 1917-06-16 | 3 | b-c | Chinese Premier Duan Qirui answers questions in the parliament on the bribery case of the Ministry of Finance. | China | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32384 | 32384 | 1917-06-16 | 3 | c-d | Second and final part of the report on the unusual phenomena in Hubei province blood rain, sex change and others). | China | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32385 | 32385 | 1917-06-16 | 3 | d-e | Chaos in China and the report. | Britain | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32386 | 32386 | 1917-06-16 | 3 | e-f | Japan will not interfere with the chaos in China. Zhang Xun enters Beijing with his troops. The chaos in China may be pacified. | America | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32387 | 32387 | 1917-06-16 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
| 32388 | 32388 | 1917-06-16 | 6 | a-b | Fifth and final part of Kang Youwei's poems on his 60th birthday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095733 | 24095733 | |
| 32389 | 32389 | 1917-06-16 | 6 | b-c | Beijing news/ Debate on the status of Confucianism in the Chinese parliament. Hails in Shanghai. Xu Shiying is dismissed. Cipher telegram stopped in Shanghai. Many government officials are trying to protect Chen Jintao, Minister of Finance in China. Secret ransom letters found in Chen Jintao's residence. The military conference in Beijing on China's involvement in the War. | China | http://trove.nla.gov.au/newspaper/page/24095733 | 24095733 | |
| 32390 | 32390 | 1917-06-16 | 6 | c | Guangdong news/ Zhu Qinglan suggests truce to the two sides in Sichuan province. Guangdong authority on opium ban. A training institute to be established in Shunde county for silk industry. Police in Dongguan county kidnap village woman. | China | http://trove.nla.gov.au/newspaper/page/24095733 | 24095733 | |
| 32391 | 32391 | 1917-06-16 | 7 | a-b | Australia news/ Amount of notes issued by Australian banks. A pawn shop is burglarised in Melbourne. A Chinese man is robbed in Sydney. Flooding in Murray River. Catholic church in Bathurst, New South Wales, prays for peace. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095732 | 24095732 | |
| 32392 | 32392 | 1917-06-16 | 7 | b | Chaos in China/ Zhang Xun requests to dissolve the parliament. Wu Tingfang and the parliament. President Li Yuanhong gives in to Zhang Xun. | China | http://trove.nla.gov.au/newspaper/page/24095732 | 24095732 | |
| 32393 | 32393 | 1917-06-16 | 7 | c-d | News on the World War I (revolution in Russia, chaos in Ireland, enlistment in America and the number of soldiers). | Other... | http://trove.nla.gov.au/newspaper/page/24095732 | 24095732 | |
| 32394 | 32394 | 1917-06-16 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095732 | 24095732 |
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]);