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 |
|---|---|---|---|---|---|---|---|---|---|
| 43321 | 43321 | 1925-06-13 | 2 | a-c | Thirty-seven labour unions & associations in Shanghai refuse to recognise the Second National Labour Conference organised by the Chinese Communist Party (CCP). And the fatal destiny of the Chinese Communist Party. | China | http://trove.nla.gov.au/newspaper/page/24101166 | 24101166 | |
| 43322 | 43322 | 1925-06-13 | 2 | c-d | Rumours from Tianjin on Li Yuanhong, Duan Qirui, Wu Peifu, Zhang Zuolin and their destiny. | China | http://trove.nla.gov.au/newspaper/page/24101166 | 24101166 | |
| 43323 | 43323 | 1925-06-13 | 2 | d | New education minister Zhang Shizhao issues his plan to reform the educational system and institution. | China | http://trove.nla.gov.au/newspaper/page/24101166 | 24101166 | |
| 43324 | 43324 | 1925-06-13 | 3 | a | Wu Peifu's eight capable persons are under investigation for their involvement in bribery and their personal properties are confiscated. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43325 | 43325 | 1925-06-13 | 3 | a | Chinese delegates to the Pacific Conference include Yan Yangchu, Ma Yanchu, Hu Shi, and some others. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43326 | 43326 | 1925-06-13 | 3 | a-b | China and Peru resume their treaty talks and the treatment of Chinese residents in Peru. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43327 | 43327 | 1925-06-13 | 3 | b | Puyi is to move out Zhang Yuan in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43328 | 43328 | 1925-06-13 | 3 | b | Guangdong people in Beijing are against the appointment of eight civil administrators for the eight divided Guangdong regions. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43329 | 43329 | 1925-06-13 | 3 | b-c | Earth wall in Beijing is auctioned, which belongs to Princess Xiao hundreds of years ago. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43330 | 43330 | 1925-06-13 | 3 | c | Telegrams to Tang Jiyao from Xiong Kewu, Li Liejun and Lin Junting. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43331 | 43331 | 1925-06-13 | 3 | c | Zhou Yinren tries to retain Sa Zhenbing in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43332 | 43332 | 1925-06-13 | 3 | c | Liu Houwu, representative of the Chinese communities in Vietnam and Thailand, has arrived in Beijing and his contact with government authorities. | China | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43333 | 43333 | 1925-06-13 | 3 | c-d | Chinese in Japan are murdered during the disaster relief after the earthquake and the investigation. | Japan | http://trove.nla.gov.au/newspaper/page/24101165 | 24101165 | |
| 43334 | 43334 | 1925-06-13 | 5 | a | Government authority in Marseille, France, ransacks communist offices. | Britain | http://trove.nla.gov.au/newspaper/page/24101167 | 24101167 | |
| 43335 | 43335 | 1925-06-13 | 5 | a | Russian and Chinese may have a war in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24101167 | 24101167 | |
| 43336 | 43336 | 1925-06-13 | 5 | a-c | Further report on the May 30 demonstration, the aftermath, and foreign reports on the protest. Japan's attitude towards the demonstrations in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24101167 | 24101167 | |
| 43337 | 43337 | 1925-06-13 | 5 | c | Students in Guangzhou and Beijing organise demonstration in response to the anti-Japanese movement in Shanghai. Comments by Russian ambassador in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101167 | 24101167 | |
| 43338 | 43338 | 1925-06-13 | 6 | a-c | The anti-Communist sentiment in Zhongshan county and other chaos after the name change. | China | http://trove.nla.gov.au/newspaper/page/24101170 | 24101170 | |
| 43339 | 43339 | 1925-06-13 | 7 | a | Vegetable price in low in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43340 | 43340 | 1925-06-13 | 7 | a | Fire in Flinders Street, Melbourne, destroys many shops. | Australia | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43341 | 43341 | 1925-06-13 | 7 | a | Australia imports more from Germany. | Australia | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43342 | 43342 | 1925-06-13 | 7 | a | American and Japanese navel fleet arrive Shanghai to deal with the chaos and demonstrations. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43343 | 43343 | 1925-06-13 | 7 | b-c | Miscellaneous report on the May 30 demonstration in Shanghai and the aftermath. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43344 | 43344 | 1925-06-13 | 7 | c | Labour union in Britain supports their counterparts in China. | Britain | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43345 | 43345 | 1925-06-13 | 7 | c | Chinese students in Japan and their request on the solution to the May 30 demonstration in Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43346 | 43346 | 1925-06-13 | 7 | c | Another war break out in Guangzhou between Yang Ximin, Liu Zhenhuan and Zhu Peide. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43347 | 43347 | 1925-06-13 | 7 | d | More Japanese cruisers are on the way to China. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43348 | 43348 | 1925-06-13 | 7 | d | Some workers are preparing for more riots in Guangzhou and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
| 43349 | 43349 | 1925-06-13 | 8 | a-d | Guangdong news/ Guangxi and Yunnan army to jointly deal with the Guangdong problem. Feng Yuxiang intervene with the Guangdong affairs. Hong Zhaolin issues an open letter to foreign consuls in Shantou. Chinese community in Vietnam and the Guangzhou-Hankou railway company. A public notice issued by the Nationalist Party to take back Zhongshan county and put it directly under control of the central committee. Chinese community (zhi gong tang) in Cuba write to Chen Jiongming and to fight with Communists. More shops are re-opened in Boluo county. Hong Zhaolin and Xiong Lue are following Lin Hu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101172 | 24101172 | |
| 43350 | 43350 | 1925-06-13 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101172 | 24101172 | |
| 43351 | 43351 | 1925-06-13 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101172 | 24101172 |
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]);