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 |
|---|---|---|---|---|---|---|---|---|---|
| 40183 | 40183 | 1923-08-04 | 2 | a-b | First part of Tung Wah Times editorial which provides some advice to the people who are fighting for the Chinese presidency. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094496 | 24094496 | |
| 40196 | 40196 | 1923-08-04 | 6 | a | China should set up more schools and other technical training institution, written by Zhou Xianchao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094500 | 24094500 | |
| 40200 | 40200 | 1923-08-04 | 7 | a | Message from Zhong Baoxuan, professor of the Agriculture School, Lingnan University, Guangzhou, who comes to Sydney to raise funds for the school development. Photograph of Zhong Baoxuan. Ma Yingbiao and other Chinese businessmen in Hong Kong donate to the Agriculture School of Lingnan University. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
| 40201 | 40201 | 1923-08-04 | 7 | a | Chinese Nanhua Football (Soccer) Team to have match with New South Wales team in Sydney. Advertisement for the match. And photograph of a Chinese football team member. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
| 40202 | 40202 | 1923-08-04 | 7 | b | Chinese Nanhua (South China) Football Team arrives Townsville, Queensland, and their telegram to the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
| 40203 | 40203 | 1923-08-04 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
| 40204 | 40204 | 1923-08-04 | 7 | c | Chinese Nanhua (South China) Football (Soccer) Team comes to visit Australian by Japanese liner and the explanation of the travel. They will have matches with Australian teams in Sydney, New Castle, Wollongong, and Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
| 40207 | 40207 | 1923-08-04 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40208 | 40208 | 1923-08-04 | 8 | a-d | Guangdong news/ Yuan Dai issues an open letter to the Guangdong people. Chen Jiongming orders his troops to attack the Guangzhou city. Chen Jiongming's army attack Boluo. Porters killed in the battle in Guangzhou. Guangzhou municipal public security bureau to check the defence headquarters. Policemen in Guangzhou are prohibited from extorting money from peddlers. Yao Yuping's mediation between different political groups in Guangdong. Japanese kill local residents in Changsha, capital of Hunan province, and the demonstration in Guangzhou. Looting in Zhaoqing. Headquarters in Guangzhou borrows loans from the Xinning Railway company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40209 | 40209 | 1923-08-04 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 | |
| 40210 | 40210 | 1923-08-04 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094502 | 24094502 |
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]);