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 |
|---|---|---|---|---|---|---|---|---|---|
| 42515 | 42515 | 1925-01-03 | 2 | a-b | Editorial by the Tung Wah Times on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100987 | 24100987 | |
| 42516 | 42516 | 1925-01-03 | 2 | b | Wu Peifu to set up a constitutional government in central China and the impact upon China's political change. | Other... | http://trove.nla.gov.au/newspaper/page/24100987 | 24100987 | |
| 42517 | 42517 | 1925-01-03 | 2-3 | b-a | Duan Qirui and others in Tianjin are determined to protect the constitution by force. | China | http://trove.nla.gov.au/newspaper/page/24100987 | 24100987 | |
| 42518 | 42518 | 1925-01-03 | 2 | c-d | Wing On Life Assurance Company Ltd is established and raises more funds by floating shares among the Australian Chinese communities. Initiators are Wing On companies in Shanghai, Hong Kong, Sydney, Wing On Insurance Company Ltd and Wing On Textile Company Ltd, Shanghai. The preparatory committee members include Guo Biao, Ma Zuxing, Guo Le, Guo Quan, Ouyang Minqing, Guo Ruixiang, Du Zewen, Guo Shun, Liang Chuang, Lin Binan and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100987 | 24100987 | |
| 42519 | 42519 | 1925-01-03 | 3 | a | The provisional government in Beijing and its departments. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42520 | 42520 | 1925-01-03 | 3 | a | Wu Peifu issues a circular telegram to protect the constitution. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42521 | 42521 | 1925-01-03 | 3 | a-b | Correspondence between Duan Qirui and Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42522 | 42522 | 1925-01-03 | 3 | b | Duan Qirui, Zhang Zuolin, Feng Yuxiang and others in the north and their attitude towards Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42523 | 42523 | 1925-01-03 | 3 | b-c | People in Jiangsu province condemn Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42524 | 42524 | 1925-01-03 | 3 | c | Qi Xieyuan's plan for the united defence in the Yangtze River area. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42525 | 42525 | 1925-01-03 | 3 | d-e | First part of a report on the checkup of the assets and privileges of the retired imperial Qing family in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42526 | 42526 | 1925-01-03 | 3 | f | Chinese government confirms that all foreign treaties remain valid. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42527 | 42527 | 1925-01-03 | 3 | f | A Christmas party in Canada is swept by fire. | Canada | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42528 | 42528 | 1925-01-03 | 3 | f | A British ship is detained by American authority for wine smuggling. | America | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42529 | 42529 | 1925-01-03 | 5 | a-d | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming and other Nationalist Party members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100988 | 24100988 | |
| 42530 | 42530 | 1925-01-03 | 6 | a | Sun Yatsen is going north and the comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100991 | 24100991 | |
| 42531 | 42531 | 1925-01-03 | 6 | b-d | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming and other Nationalist Party members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100991 | 24100991 | |
| 42532 | 42532 | 1925-01-03 | 6 | d | A telegram from the commercial chamber in Shanghai to Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24100991 | 24100991 | |
| 42533 | 42533 | 1925-01-03 | 7 | a | A school in Sydney is burned to ashes during the Christmas holiday. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42534 | 42534 | 1925-01-03 | 7 | a | A homicide case in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42535 | 42535 | 1925-01-03 | 7 | a | A failed robbery in Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42536 | 42536 | 1925-01-03 | 7 | a | A Chinese man in Melbourne injures a white woman with knife and is detained by police. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42537 | 42537 | 1925-01-03 | 7 | b | Price of bread is going up in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42538 | 42538 | 1925-01-03 | 7 | b | Chinese sailors of a Dutch ship win their strike in Fremantle, Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42539 | 42539 | 1925-01-03 | 7 | b | A thief in Caulfield, Melbourne, hurts his fellow. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42540 | 42540 | 1925-01-03 | 7 | b | Seven passengers and the pilot die in an air crash from London to Paris. | Britain | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42541 | 42541 | 1925-01-03 | 7 | b-c | American industrialists come to visit Australia with their naval fleet. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42542 | 42542 | 1925-01-03 | 7 | c | The woman who attempts to assassinate Russian ambassador to France is imprisoned. | France | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42543 | 42543 | 1925-01-03 | 7 | c | Black communist members from South Africa visit Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42544 | 42544 | 1925-01-03 | 7 | c | Romanian authority raid communist offices. | Other... | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42545 | 42545 | 1925-01-03 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42546 | 42546 | 1925-01-03 | 8 | a-d | Guangdong news/ Chen Jiongming and the defence plan in suburb Guangzhou. Chen Jiongming reviews his troops in Chaoan county. Disaster of war in Taishan county. Tan Qixiu's troops extort businessmen in Humen. Commercial chambers in Guangzhou and their self-defence strategy. Chen Lianbo's followers are wanted by the provincial authority. More troops on the way to Dongguan county. Local self-defence in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100993 | 24100993 | |
| 42547 | 42547 | 1925-01-03 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100993 | 24100993 | |
| 42548 | 42548 | 1925-01-03 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100993 | 24100993 |
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]);