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 |
|---|---|---|---|---|---|---|---|---|---|
| 42222 | 42222 | 1924-10-25 | 2-3 | a-b | An open letter to all compatriots from the self-defence corps of the Guangdong commercial chambers (regarding their conflict with the Guangzhou government). | China | http://trove.nla.gov.au/newspaper/page/24100905 | 24100905 | |
| 42223 | 42223 | 1924-10-25 | 2 | c-d | Wing On Life Assurance Company Ltd is established and raises more funds by floating shares among the Australian Chinese communities. Initiators are Wing On companies in Shanghai, Hong Kong, Sydney, Wing On Insurance Company Ltd and Wing On Textile Company Ltd, Shanghai. The preparatory committee members include Guo Biao, Ma Zuxing, Guo Le, Guo Quan, Ouyang Minqing, Guo Ruixiang, Du Zewen, Guo Shun, Liang Chuang, Lin Binan and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100905 | 24100905 | |
| 42224 | 42224 | 1924-10-25 | 3 | b | Sun Yatsen orders to disband all commercial associations in Guangdong. An urgent telegram from the Guangdong commercial chambers to the Chinese Chamber of Commerce in Sydney over their fighting with the government authority. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42225 | 42225 | 1924-10-25 | 3 | b-c | The League of Nations and China, a report from London. | Britain | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42226 | 42226 | 1924-10-25 | 3 | c | Duan Qirui publicly attacks Cao Kun and his Zhixi faction. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42227 | 42227 | 1924-10-25 | 3 | c-d | The war between Jiangsu and Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42228 | 42228 | 1924-10-25 | 3 | d | Sun Yatsen orders to disarm all commercial associations. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42229 | 42229 | 1924-10-25 | 3 | d | Sun Yatsen sets fire in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42230 | 42230 | 1924-10-25 | 3 | e | Xu Shuzheng and the Anfu faction are back to life in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42231 | 42231 | 1924-10-25 | 3 | e | International settlement in Shanghai refuses to admit Xu Shuzheng. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42232 | 42232 | 1924-10-25 | 3 | e | The war between Jiangsu and Zhejiang comes to an end. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
| 42233 | 42233 | 1924-10-25 | 6 | a-b | Guangdong suffers under Sun Yatsen, comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100909 | 24100909 | |
| 42234 | 42234 | 1924-10-25 | 6 | b | Solution to the conflict between Guangzhou government and the commercial chambers over the purchase of weapon. | China | http://trove.nla.gov.au/newspaper/page/24100909 | 24100909 | |
| 42235 | 42235 | 1924-10-25 | 6 | b-d | First part of travel notes written by Yu Wenhou on his trip to the South Pacific (Samoa, Tonga, Fiji and other islands), and his report on the Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100909 | 24100909 | |
| 42236 | 42236 | 1924-10-25 | 6 | d-e | Guangdong turns into a world of bandits and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100909 | 24100909 | |
| 42237 | 42237 | 1924-10-25 | 7 | a | English newspaper in Sydney comments Sun Yatsen. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42238 | 42238 | 1924-10-25 | 7 | a | Bandits in Melbourne kidnap policeman. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42239 | 42239 | 1924-10-25 | 7 | a | A Sydney man is penalised for sexual harassment. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42240 | 42240 | 1924-10-25 | 7 | b | Burglary of a jewellery in Newtown, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42241 | 42241 | 1924-10-25 | 7 | b | Investigation of a case of raping in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42242 | 42242 | 1924-10-25 | 7 | b | Optimism on the sale of shares of the Wing On Life Assurance Company Ltd, Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42243 | 42243 | 1924-10-25 | 7 | c | Further report on the looting and burning committed by Sun Yatsen's troops in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42244 | 42244 | 1924-10-25 | 7 | c | Chen Jiongming's army launch a counterattack. | China | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42245 | 42245 | 1924-10-25 | 7 | c | Anti-Chinese movement in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42246 | 42246 | 1924-10-25 | 7 | c | Battle in the Dongjiang area, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42247 | 42247 | 1924-10-25 | 7 | c-d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42248 | 42248 | 1924-10-25 | 7 | d | A notice by the Zhenguang Company Ltd, Hong Kong, to its shareholders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42249 | 42249 | 1924-10-25 | 7 | d | A notice by the Chinese Chamber of Commerce in Sydney and their support to the Guangdong commercial chambers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
| 42250 | 42250 | 1924-10-25 | 8 | a-d | Guangdong news/ Sun Yatsen flees Shaoguan and has arrived Guangzhou. A new government to be organised in the southwest. Obstacles to Hu Hanmin's attempt to be the governor of Guangdong. Fan Shisheng disapproves Li Fulin to be the mayor of Guangzhou. The move of Yunnan army in Guangdong. Orders issued by Sun Yatsen on his departure for the North Expedition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 | |
| 42251 | 42251 | 1924-10-25 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 | |
| 42252 | 42252 | 1924-10-25 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100911 | 24100911 |
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]);