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 |
|---|---|---|---|---|---|---|---|---|---|
| 34442 | 34442 | 1919-05-03 | 2 | a-c | First part of the Covenant of the League of Nations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097702 | 24097702 | |
| 34443 | 34443 | 1919-05-03 | 2 | d-f | The secret treaty between China and Japan is released for the first time. | China | http://trove.nla.gov.au/newspaper/page/24097702 | 24097702 | |
| 34444 | 34444 | 1919-05-03 | 2 | f | Report on the peace talks in Shanghai between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097702 | 24097702 | |
| 34445 | 34445 | 1919-05-03 | 3 | a | English Times in Beijing and Tianjin reveals the alliance of Japan and Germany. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34446 | 34446 | 1919-05-03 | 3 | b-c | Korean people and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34447 | 34447 | 1919-05-03 | 3 | d | Chinese labourers in France and their return to China. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34448 | 34448 | 1919-05-03 | 3 | d | Chinese delegation to the Paris Peace Conference. | France | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34449 | 34449 | 1919-05-03 | 3 | e | Items on racial equality included in the treaty to be signed at the Paris Peace Conference. Discussions on the Shandong issues at the Paris Peace Conference. Relations between China and Japan at the peace conference. | France | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34450 | 34450 | 1919-05-03 | 3 | f | Hundreds of people killed in the turmoil in Korea. | America | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34451 | 34451 | 1919-05-03 | 3 | f | Italy at the Paris Peace Conference. | Other... | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34452 | 34452 | 1919-05-03 | 3 | f | Japan wants to take over Shandong and Jiaozhou peninsula at the Paris Peace Conference and their attitude is strong. | Britain | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
| 34453 | 34453 | 1919-05-03 | 6 | a-c | Third and final part of the letter from Kang Youwei to Lu Zhengxiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097706 | 24097706 | |
| 34454 | 34454 | 1919-05-03 | 6 | c | The Allies countries have finalised the treaty with Germany at the Paris Peace Conference. | Canada | http://trove.nla.gov.au/newspaper/page/24097706 | 24097706 | |
| 34455 | 34455 | 1919-05-03 | 7 | a | The Tung Wah Times also sells medicines, seeds, fertilisers and others, and its advertisement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34456 | 34456 | 1919-05-03 | 7 | a | Australia news/ A white gardener is crushed to death by train. Epidemic and casualties in Victoria. Australian naval fleet is returning from Europe. Epidemic in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34457 | 34457 | 1919-05-03 | 7 | b | Chinese community in Waterloo, Sydney, donates to the local hospital and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34458 | 34458 | 1919-05-03 | 7 | b-c | Journalist and branch leader of the Nationalist Party (Guomindang) is arrested in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34459 | 34459 | 1919-05-03 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34460 | 34460 | 1919-05-03 | 7 | c | Farewell message by Zhu Yingli on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 34461 | 34461 | 1919-05-03 | 8 | a | The New South Wales Chinese Chamber of Commerce calls for donations to the famine victims in Guangdong. Names listed for donations received. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 | |
| 34462 | 34462 | 1919-05-03 | 8 | a-b | Beijing news/ Conflict between the Chinese cabinet and the navy. Naval commander Sa Zhenbing is leaving for Europe. Chinese foreign ministry replies to ambassadors of Britain, America, France and Italy in Beijing. Zhang Qian writes to President Xu Shichang and requests to ban constitutional reform organisations. Air mail service between Beijing and Shanghai. Brazil to recruit some Chinese farmers. Chinese tea may have ready market in Europe. | China | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 | |
| 34463 | 34463 | 1919-05-03 | 8 | b-c | Guangdong news/ Road construction in Guangzhou. Preparation for the opening of the second provincial legislature. Rice price continues going down. Many people donate to the famine victims in Guangdong. Rice market in Dongguan county. Bandits in Dongguan. Bandits in Yangshan county. | China | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 |
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]);