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 |
---|---|---|---|---|---|---|---|---|---|
41523 | 41523 | 1924-05-10 | 2 | a-b | Editorial on the true colours of Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41524 | 41524 | 1924-05-10 | 2 | b-c | First part of a report submitted by Sun Baoqi on the negotiations with Russian | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41525 | 41525 | 1924-05-10 | 2 | c-d | Li Jinghe prepares for an international exhibition to celebrate the Republic. | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41526 | 41526 | 1924-05-10 | 2 | d-e | Russian envoy in Beijing sends telegram to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41527 | 41527 | 1924-05-10 | 2 | e-f | Another report on the treaty negotiation between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41528 | 41528 | 1924-05-10 | 2 | f | A proposal to unify the army command in China. | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41529 | 41529 | 1924-05-10 | 2-3 | f-a | Sun Yatsen denies any subsidy from Soviet Russian government. | China | http://trove.nla.gov.au/newspaper/page/24100713 | 24100713 | |
41530 | 41530 | 1924-05-10 | 3 | a-b | Military and political situation in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41531 | 41531 | 1924-05-10 | 3 | b-c | Qi Xieyuan questions Sun Chuanfang. | China | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41532 | 41532 | 1924-05-10 | 3 | c | Silk factory workers in Shanghai are on strike and the report. | China | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41533 | 41533 | 1924-05-10 | 3 | d | Nanhua (South China) football team and their achievements after visiting Australia. | China | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41534 | 41534 | 1924-05-10 | 3 | e | French consulate in Guangzhou helps to release American and Chinese missionary workers in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41535 | 41535 | 1924-05-10 | 3 | e | Workers in Guangzhou demands eight-hours' working. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41536 | 41536 | 1924-05-10 | 3 | e | Russian ambassador in Germany returns. | Britain | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41537 | 41537 | 1924-05-10 | 3 | e-f | Germany builds huge submarine. | America | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41538 | 41538 | 1924-05-10 | 6 | a-c | Second part of the report on the anti-Communist movement within the Nationalist Party (Borodin, Liao Zhongkai and overseas Chinese members, Fan Liren, and Sun Yatsen). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100717 | 24100717 | |
41539 | 41539 | 1924-05-10 | 6 | c-d | First part of a report on the Guangzhou government and their livelihood policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100717 | 24100717 | |
41540 | 41540 | 1924-05-10 | 7 | a | Tung Wah Times comments on the eight-hour working movement in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41541 | 41541 | 1924-05-10 | 7 | a-b | Tram workers in Melbourne are on strike. | Australia | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41542 | 41542 | 1924-05-10 | 7 | b | The Sydney Chinese School and the Chinese Chamber of Commerce farewell Tang Longxiang, chief-editor of the Gong Bao and voluntary school teacher, who is returning to China. Speakers include Ye Tonggui, Chen Qingyi, Pan Yonghan, Liu Guangfu, Zhu Songqing, Zheng Fanchang, Ye Bingnan, Wu Elou, Zhan Zhuoying, and Zhou Lianjie. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41543 | 41543 | 1924-05-10 | 7 | c | Three thieves are arrested in a Chinese market garden, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41544 | 41544 | 1924-05-10 | 7 | c | Pipe leaks in a Melbourne refinery. | Australia | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41545 | 41545 | 1924-05-10 | 7 | c | Fundraising for Sydney hospitals and involvement of Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41546 | 41546 | 1924-05-10 | 7 | c | Rangers in New Zealand call for killing of some deer. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41547 | 41547 | 1924-05-10 | 7 | d | Pirates hijack a Portuguese ship near Jiangmen. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41548 | 41548 | 1924-05-10 | 7 | d | Thirty-eight pirates are executed in Xiangshan county. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41549 | 41549 | 1924-05-10 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. Mails for pickup at the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41550 | 41550 | 1924-05-10 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
41551 | 41551 | 1924-05-10 | 8 | a-d | Guangdong news/ Sun Yatsen orders his army to cancel some taxes imposed to businessmen in Guangzhou. Chief of the Public Security Bureau Wu Tiecheng execute orders with force. Revision of tax collections in Guangdong and the resistance. Boat people in Guangdong call for relaxation of tax collection. Troops in Guangzhou occupy house of local residents. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100719 | 24100719 | |
41552 | 41552 | 1924-05-10 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100719 | 24100719 | |
41553 | 41553 | 1924-05-10 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100719 | 24100719 |
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]);