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 |
|---|---|---|---|---|---|---|---|---|---|
| 40153 | 40153 | 1923-07-28 | 2 | a-b | Editorial on more crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
| 40154 | 40154 | 1923-07-28 | 2 | c-d | Political struggle in Beijing (Li Yuanhong, Yan Huiqing, Zhang Shaozeng, Feng Yuxiang, and others). | China | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
| 40155 | 40155 | 1923-07-28 | 2 | d-f | Political situation in Beijing before the flea of Li Yuanhong. | China | http://trove.nla.gov.au/newspaper/page/24094488 | 24094488 | |
| 40156 | 40156 | 1923-07-28 | 3 | a-b | Effort to topple Li Yuanhong in Beijing and the political conspiracy. Correspondence between different power groups (Gao Lingwei and five others resign, telegram to Zhang Shaozeng in Tianjin, Wang Chengbin to Li Yuanhong, Qi Xieyuan's circular telegram). | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
| 40157 | 40157 | 1923-07-28 | 3 | c-d | Li Yuanhong issues a circular telegram which says that he is forced to abdicate. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
| 40158 | 40158 | 1923-07-28 | 3 | d-e | Japanese businessmen in Shanghai seek to stop the boycott to Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
| 40159 | 40159 | 1923-07-28 | 3 | e | Foreign diplomats in Beijing on the possible cooperation between Zhang Zuolin, Wu Peifu and Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24094487 | 24094487 | |
| 40160 | 40160 | 1923-07-28 | 6 | a | Three orders issued by Chinese President Li Yuanhong before his leaving for Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40161 | 40161 | 1923-07-28 | 6 | a-b | Situation in Guangdong may have fundamental change. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40162 | 40162 | 1923-07-28 | 6 | b | Ma Xiaojin on Sun Yatsen and the current Guangdong situation. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40163 | 40163 | 1923-07-28 | 6 | b-c | The China Mail Line Company Ltd, established by Chinese businessmen in America, is bankrupt, and its liner Nile has been auctioned. | America | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40164 | 40164 | 1923-07-28 | 6 | c | Students in Jilin province promotes Chinese goods. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40165 | 40165 | 1923-07-28 | 6 | c-d | China, America and Japan may jointly develop their radio communication. | China | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40166 | 40166 | 1923-07-28 | 6 | d | French troops in Germany. German authority seeks help from American government to maintain the value of mark. | Germany | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40167 | 40167 | 1923-07-28 | 6 | d | American senator says they would never treat Japanese equally. | Japan | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
| 40168 | 40168 | 1923-07-28 | 7 | a | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40169 | 40169 | 1923-07-28 | 7 | a | Postal service in Australia makes profit. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40170 | 40170 | 1923-07-28 | 7 | a | New South Wales premier returns to Sydney after touring Britain, south Europe, America and Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40171 | 40171 | 1923-07-28 | 7 | a | Two trains collide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40172 | 40172 | 1923-07-28 | 7 | a | Husband and wife suffers in Sydney due to unemployment. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40173 | 40173 | 1923-07-28 | 7 | b-c | Zhi gong tang in Sydney celebrates the birthday of Huang Zhu, chairman of the association. Speakers include Tang Longxiang, Li Xiangbo, Ye Tonggui, Peng Lichuan, Wu Elou, Wu Gen, Lin Dasan and many white people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40174 | 40174 | 1923-07-28 | 7 | c | Epidemics in Glen Innes and Tingha, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40175 | 40175 | 1923-07-28 | 7 | c | A Briton is kidnapped in Yunnan province, China. | Britain | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40176 | 40176 | 1923-07-28 | 7 | c | Chinese treasurer Huang Kaiwen has resigned. | Britain | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40177 | 40177 | 1923-07-28 | 7 | c | First part of an investigation on economic activities in China conducted by the Beijing government (the making and export of hairnet). | China | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40178 | 40178 | 1923-07-28 | 7 | c-d | Bandits on the border of Tibet and Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
| 40179 | 40179 | 1923-07-28 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094494 | 24094494 | |
| 40180 | 40180 | 1923-07-28 | 8 | a-d | Guangdong news/ Yao Yuping in Hong Kong mediates for the peace in Guangdong and his talks with Chen Fang. Sun Yatsen tries to raise more funds. Zhong Xifen is penalised. Guangzhou authority to control all grain warehouses. Sun Yatsen appoints Ye Gongchuo treasurer and Wang Tang financial minister. Guangzhou residents boycott to the house tax. Guangzhou municipal authority to confiscate all temple properties. No way to mediate the conflict between Sun Yatsen and Chen Jiongming. Rice businessmen in Guangzhou refuse to provide to the army. Shen Hongying's army to attack Zhaoqing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094494 | 24094494 | |
| 40181 | 40181 | 1923-07-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094494 | 24094494 | |
| 40182 | 40182 | 1923-07-28 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094494 | 24094494 |
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]);