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 |
|---|---|---|---|---|---|---|---|---|---|
| 34616 | 34616 | 1919-06-28 | 2 | a-b | First part of an editorial by Tung Wah Times on the national shame of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
| 34617 | 34617 | 1919-06-28 | 2 | c-d | Third part of the report written by American journalist that reveals Japan's conspiracy in China. | America | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
| 34618 | 34618 | 1919-06-28 | 2 | d-e | New Dutch ambassador to China presents his credentials to Chinese President Xu Shichang. | China | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
| 34619 | 34619 | 1919-06-28 | 2 | e | First part of the motion tabled by Chinese delegation at the Paris Peace Conference. | China | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
| 34620 | 34620 | 1919-06-28 | 2 | f | Protest gathering in Shandong province and the report. | China | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
| 34621 | 34621 | 1919-06-28 | 3 | a-b | Protest in China against the diplomatic failure (Cao Rulin to be impeached, Zhang Zongxiang besieged, boycott to Japanese goods in Shanghai, and others). | China | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 | |
| 34622 | 34622 | 1919-06-28 | 3 | c-e | Students' demonstration in Beijing on May Fourth and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 | |
| 34623 | 34623 | 1919-06-28 | 3 | e-f | Miscellaneous report/ Japanese ambassador to America leaves Washington and returns home. Chinese ambassador to Japan resigns. Chinese President Xu Shichang and the cabinet resign. Anti-Japanese movement in Shanghai. America to expand naval forces. Japanese warships on the Chinese ports. Germany wants to delay to sign the treaty. Japanese delegate to the Paris Conference rebuffs Germany. German navy destroy warships. | Other... | http://trove.nla.gov.au/newspaper/page/24097767 | 24097767 | |
| 34624 | 34624 | 1919-06-28 | 6 | a-c | Special prescription for the epidemic disease in New South Wales, written by Chen Fangyu in Townsville and Peng Lichuan in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097772 | 24097772 | |
| 34625 | 34625 | 1919-06-28 | 7 | a | Germany has signed the Treaty at the Paris Peace Conference. | Australia | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34626 | 34626 | 1919-06-28 | 7 | a | Preparation for the celebration parade in Melbourne and Sydney for the world peace after the World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34627 | 34627 | 1919-06-28 | 7 | a | British naval captain comets to visit Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34628 | 34628 | 1919-06-28 | 7 | b | Business is halted in Sydney due to the epidemic disease. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34629 | 34629 | 1919-06-28 | 7 | b | Liu Guangfu (William Liu) in Sydney welcomes and gives dinner party to Ma Yingbiao and Chen Lizhen, both are important figures of The Sincere Company (in Hong Kong and Shanghai). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34630 | 34630 | 1919-06-28 | 7 | b | Many Australian servicemen marry English women. | Britain | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34631 | 34631 | 1919-06-28 | 7 | b-c | Anti-Japanese riots in Singapore. | Other... | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34632 | 34632 | 1919-06-28 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
| 34633 | 34633 | 1919-06-28 | 8 | a | Chinese Consul in Samoa Lin Baoheng reports from Apia about the celebration parade on the end of the World War I and the involvement of the Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 | |
| 34634 | 34634 | 1919-06-28 | 8 | a-b | Beijing news/ Report on the peace talks between the south and the north. President Xu Shichang on the peace talks. | China | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 | |
| 34635 | 34635 | 1919-06-28 | 8 | b-c | Guangdong news/ Salary payment to the speaker of the provincial legislature assembly. Chaos in the provincial legislature assembly. Flood in Dongjiang area. New management authority to be organised for the Guangzhou-Hankou railway. Businessmen in Beijing and Shanghai organise to protect local products. Efforts in Zhaoqing to stabilise the rice market. Deng Muzhou, of the Wing On Company in Shanghai, writes and requests the provincial authority to suppress bandits because his uncle is kidnaped. | China | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 |
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]);