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 |
|---|---|---|---|---|---|---|---|---|---|
| 43285 | 43285 | 1925-06-06 | 2 | a | My criticism on Sun Yatsen, written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43286 | 43286 | 1925-06-06 | 2 | a-b | Duan Qirui is afraid of united provincial government. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43287 | 43287 | 1925-06-06 | 2 | b-c | Zhang Zuolin on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43288 | 43288 | 1925-06-06 | 2 | c | China and Russia to start another round of negotiations in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43289 | 43289 | 1925-06-06 | 2 | c-d | Japan and Russia have finalised their treaty talks. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43290 | 43290 | 1925-06-06 | 2 | d | Fang Benren narrowly escapes an assassination in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43291 | 43291 | 1925-06-06 | 2-3 | d-a | Feng Ziyou, Yu Youren, Lu Shidi, Zhu Zhuowen and other Nationalists organise an anti-Communist group in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
| 43292 | 43292 | 1925-06-06 | 3 | a | China's repayment of indemnity to foreign countries in the past decade. | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 | |
| 43293 | 43293 | 1925-06-06 | 3 | b | The Duan Qirui government in Beijing divides Guangdong into nine administrative regions and appoints new military commanders and civil administrators each of them. | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 | |
| 43294 | 43294 | 1925-06-06 | 3 | b-c | The Nationalist Party (Guomindang) splits in Beijing and the members who are against communists (Zhang Binglin, Peng Yangguang, Feng Ziyou, Wu Chaoshu, Wang Zhengting, Dan Maoxi, Wu Qingyang, Zhang Jingjiang, Zhang Juzheng, Tang Shaoyi, Sun Ke, Ma Junwu, and many others). | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 | |
| 43295 | 43295 | 1925-06-06 | 3 | c | Beijing government and their new policy to deal with the aftermath in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 | |
| 43296 | 43296 | 1925-06-06 | 3 | c-d | Xu Chongzhi leads his army to attack Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 | |
| 43297 | 43297 | 1925-06-06 | 5 | a | Tung Wah Times comments on the division of Guangdong into nine administrative regions. | China | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43298 | 43298 | 1925-06-06 | 5 | a-b | Some Russian refugees in Manchuria recruit army for rebellion. | China | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43299 | 43299 | 1925-06-06 | 5 | b | Six hundred and eighty-eight Russian communists enter France under the guise of businessmen and are detained. | France | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43300 | 43300 | 1925-06-06 | 5 | b | A Western businessman is kidnapped by pirates in Jiangmen, Guangdong, and escapes. | China | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43301 | 43301 | 1925-06-06 | 5 | b | A Catholic church is bombed in Sofia, Bulgaria and the suspects are arrested. | Other... | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43302 | 43302 | 1925-06-06 | 5 | b | Prince George of Britain visits Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43303 | 43303 | 1925-06-06 | 5 | c | An old virgin dies in London at the age of 104. | Britain | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43304 | 43304 | 1925-06-06 | 5 | c | Japanese and a case of their patriotism. | Japan | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43305 | 43305 | 1925-06-06 | 5 | c | A London hospital purchase radio for the entertainment of their patients and donations from royal family. | Britain | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43306 | 43306 | 1925-06-06 | 5 | c | Soviet leader on the existence of American power in the Pacific region. | Britain | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43307 | 43307 | 1925-06-06 | 5 | c | A Japanese plane arrives Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43308 | 43308 | 1925-06-06 | 5 | c | The Times in London suggests that foreign powers should help China to suppress rebellions. | Britain | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
| 43309 | 43309 | 1925-06-06 | 6 | a-c | Xiangshan county in Guangdong is renamed Zhongshan county with Sun Ke as the magistrate and other changes. | China | http://trove.nla.gov.au/newspaper/page/24101162 | 24101162 | |
| 43310 | 43310 | 1925-06-06 | 6 | c | A Japanese expert predicts the second World War. | Japan | http://trove.nla.gov.au/newspaper/page/24101162 | 24101162 | |
| 43311 | 43311 | 1925-06-06 | 6 | c-d | Tang Jiyao's army leave Nanning, capital of Guangxi, for the east. | China | http://trove.nla.gov.au/newspaper/page/24101162 | 24101162 | |
| 43312 | 43312 | 1925-06-06 | 7 | a | A Sydney girl, 17, disappears. | Australia | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43313 | 43313 | 1925-06-06 | 7 | a | A Chinese market garden in New Castle turns to ashes in a fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43314 | 43314 | 1925-06-06 | 7 | a | Hairdresser roaming in Sydney hotels is in fact a thief. | Australia | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43315 | 43315 | 1925-06-06 | 7 | b | Introduce Dr Ian Crawford, sight testing and spectacule specialist in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43316 | 43316 | 1925-06-06 | 7 | b-d | Large-scale anti-Japanese demonstration in Shanghai on May 30, the reason and the further report. | China | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43317 | 43317 | 1925-06-06 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
| 43318 | 43318 | 1925-06-06 | 8 | a-d | Guangdong news/ Guangdong may see another political crisis. Guangdong government is determined to stop Liu Zhenhuan back to Guangxi. Xiangshan (Zhongshan) county to start communist system and the people gather to protest. People in Xiangshan county demonstrate the name change and takeover by the Central Executive Committee. Division of the new eight administrative regions. Primary school teachers in Guangzhou to have a strike for more pay. Army looting in Zengcheng. Strange rain in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 | |
| 43319 | 43319 | 1925-06-06 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 | |
| 43320 | 43320 | 1925-06-06 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101164 | 24101164 |
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]);