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 |
|---|---|---|---|---|---|---|---|---|---|
| 32341 | 32341 | 1917-06-02 | 2 | a-c | Second and final part of the letter from Kang Youwei to Chinese President Li Yuanhong and Premier Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24095713 | 24095713 | |
| 32342 | 32342 | 1917-06-02 | 2 | d-e | First part of a report selected from Central China News (zhong yuan bao) on Feng Guozhang's dream to be the President of China, and the lawsuit. | China | http://trove.nla.gov.au/newspaper/page/24095713 | 24095713 | |
| 32343 | 32343 | 1917-06-02 | 2 | e-f | Chinese cabinet, after a meeting, has passed the new regulations on the currency system in China. | China | http://trove.nla.gov.au/newspaper/page/24095713 | 24095713 | |
| 32344 | 32344 | 1917-06-02 | 2 | f | A true report on China's relationship with Germany. | China | http://trove.nla.gov.au/newspaper/page/24095713 | 24095713 | |
| 32345 | 32345 | 1917-06-02 | 3 | a | China's preconditions to declare war with Germany and response of various countries. | China | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
| 32346 | 32346 | 1917-06-02 | 3 | b | Technical education in Shandong province and the technical development in China. | China | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
| 32347 | 32347 | 1917-06-02 | 3 | c-e | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
| 32348 | 32348 | 1917-06-02 | 3 | e-f | More than 20 military governors in China request to dissolve the national parliament. President Li Yuanhong dismisses Premier Duan Qirui. The Chinese government and parliament on the War. | China | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
| 32349 | 32349 | 1917-06-02 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
| 32350 | 32350 | 1917-06-02 | 6 | a | Third part of Kang Youwei's poems on his 60th birthday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095717 | 24095717 | |
| 32351 | 32351 | 1917-06-02 | 6 | b-c | Beijing news/ Qin Chunxuan opposes to China's involvement in the World War I. The military conference is postponed. The central and provincial governments have different power in foreign policy. Tan Sitong's son dies. Dutch government takes over German settlements in China. | China | http://trove.nla.gov.au/newspaper/page/24095717 | 24095717 | |
| 32352 | 32352 | 1917-06-02 | 6 | c-d | Guangdong news/ The feud and fighting between Huang and Liang clans in Xiangshan county and the solutions. | China | http://trove.nla.gov.au/newspaper/page/24095717 | 24095717 | |
| 32353 | 32353 | 1917-06-02 | 7 | a-c | Australia news/ Budget report delivered by the federal treasury. A man is arrested in Sydney for counterfeit bank notes. Sydney police raid an opium den. Zhou Fengzhen's speech at the annual conference of the Chinese Chamber of Commerce in Bendigo, Victoria. Number of casualties of Australian troops in the World War I. An Indian immigrant is killed in Lismore, New South Wales. Seven tons of mice caught in Mallee, Victoria. More opium addicts are detained in Sydney. Flood in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32354 | 32354 | 1917-06-02 | 7 | c | Li Jingyi is appointed Chinese Premier. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32355 | 32355 | 1917-06-02 | 7 | c | Famine in China. | Britain | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32356 | 32356 | 1917-06-02 | 7 | c | Fire in Tokyo. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32357 | 32357 | 1917-06-02 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32358 | 32358 | 1917-06-02 | 7 | c | Farewell words by Ma Zuxing who is going to work for the Wing On Company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 |
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]);