This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43401 | 43401 | 1925-06-27 | 5 | a | Miscellaneous report on the demonstration in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43407 | 43407 | 1925-06-27 | 6 | a | Debate in the British parliament on their China policy. | Britain | http://trove.nla.gov.au/newspaper/page/24101188 | 24101188 | |
43409 | 43409 | 1925-06-27 | 7 | a | A notice issued by the Chinese Consulate General in Melbourne to the Chinese herbalists and Chinese medicine practitioners in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43410 | 43410 | 1925-06-27 | 7 | a | New South Wales has new state government and their policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43411 | 43411 | 1925-06-27 | 7 | a | Number of unemployed and homeless people in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43412 | 43412 | 1925-06-27 | 7 | a | Human arms found inside of a shark in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43391 | 43391 | 1925-06-27 | 2 | a-b | China is not able to declare war to any other foreign countries, comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101184 | 24101184 | |
43395 | 43395 | 1925-06-27 | 3 | a-b | The war and chaos in the west of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43408 | 43408 | 1925-06-27 | 6 | a-c | Demonstration and strike in Shanghai, Hankou, Guangzhou, Beijing and other cities in China. | China | http://trove.nla.gov.au/newspaper/page/24101188 | 24101188 | |
43416 | 43416 | 1925-06-27 | 8 | a-d | Guangdong news/ Guangzhou people gather for local security. Machine industry union to declare their anti-Communist attitude. Lin Hu leads his army to attack Beijiang area. Silk industry in Nanhai and Shunde counties. Power struggle between different political parties in Chaozhou and Meixian county. Market in Shilong is influenced by the new currency. People in Zhongshan county oppose to the Nationalist rule. Robbery and kidnap in Zengcheng county. Bandits in Dongguan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101190 | 24101190 | |
43396 | 43396 | 1925-06-27 | 3 | b | Former Guangxi governor Tan Haoming is murdered by his house servant in Shanghai and the trial on the case. | China | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43402 | 43402 | 1925-06-27 | 5 | b | Japan dispatches more warships to Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43403 | 43403 | 1925-06-27 | 5 | b | British warships in China. | Britain | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43404 | 43404 | 1925-06-27 | 5 | b | Representatives of the Shanghai demonstration meet Chinese government ministers and their request. | China | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43413 | 43413 | 1925-06-27 | 7 | b | Storm and heavy rain in Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43414 | 43414 | 1925-06-27 | 7 | b | Influence of the May 30 demonstration in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43392 | 43392 | 1925-06-27 | 2 | b-c | Documents published on the solution to the case of gold Franc. | China | http://trove.nla.gov.au/newspaper/page/24101184 | 24101184 | |
43405 | 43405 | 1925-06-27 | 5 | b-c | Anti-foreign movement in Shanghai and other provinces following the May 30 Demonstration. | China | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43397 | 43397 | 1925-06-27 | 3 | c | Japan to deport Chinese labourers. | Japan | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43398 | 43398 | 1925-06-27 | 3 | c | Four foreign countries refuse to consider the increase of Chinese tariff. | China | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43406 | 43406 | 1925-06-27 | 5 | c | Students in Hong Kong continue their class. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101185 | 24101185 | |
43415 | 43415 | 1925-06-27 | 7 | c | Detailed report about expenditure of a Chinese funeral, prepared by Lei Zhangqian for the late Luo Jianrong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101187 | 24101187 | |
43393 | 43393 | 1925-06-27 | 2 | c-d | Beijing authorities take every precaution against any possible students demonstration in May. | China | http://trove.nla.gov.au/newspaper/page/24101184 | 24101184 | |
43399 | 43399 | 1925-06-27 | 3 | c-d | Duan Qirui in Beijing and his political advisors. | China | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43394 | 43394 | 1925-06-27 | 2 | d | An ancient city found in Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101184 | 24101184 | |
43400 | 43400 | 1925-06-27 | 3 | d | Large-scale famine in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101183 | 24101183 | |
43417 | 43417 | 1925-06-27 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101190 | 24101190 | |
43418 | 43418 | 1925-06-27 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101190 | 24101190 |
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]);