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 |
---|---|---|---|---|---|---|---|---|---|
45185 | 45185 | 1926-09-25 | 8 | a-d | Guangdong news/ Heat waves in Guangzhou and the casualties. Heat waves sweeps Foshan. Rewards offered in the capture of Zhu Zhuowen. The Guangzhou government sends envoys to Xiamen. Road construction in the west of Guangzhou and the disputes. A street fighting in Guangzhou. A man in Guangzhou mortgages his wife. | China | http://trove.nla.gov.au/newspaper/page/24101726 | 24101726 | |
45184 | 45184 | 1926-09-25 | 7 | b-c | News from China on the Northern Expedition. | China | http://trove.nla.gov.au/newspaper/page/24101723 | 24101723 | |
45183 | 45183 | 1926-09-25 | 7 | a | Australia news/ Police in Sydney raid Chinese gambling dens. Attention to the people who want to send parcels to China. Bank teller in Sydney pays customers wrong amount of money. A man in Sydney is punished for sexual harassment. Three illegal Chinese immigrants are detained in Tamworth, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101723 | 24101723 | |
45182 | 45182 | 1926-09-25 | 6 | b-d | Chinese community in Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101724 | 24101724 | |
45181 | 45181 | 1926-09-25 | 6 | a | Preparation of the Sydney Chinese Chamber of Commerce for the birthday celebration of Confucius, procedure of the ceremony and guest speakers. Photograph of Guo Jianying (W. Gock Young), honorary organiser of the committee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101724 | 24101724 | |
45180 | 45180 | 1926-09-25 | 5 | c | Storm in America. | America | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45179 | 45179 | 1926-09-25 | 5 | c | Yang Sen agrees to return British ships. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45178 | 45178 | 1926-09-25 | 5 | b | News on the war between the south and the north in China. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45177 | 45177 | 1926-09-25 | 5 | b | British government appoints new ambassador to China. | Britain | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45176 | 45176 | 1926-09-25 | 5 | a | Wu Peifu and Sun Chuanfang prepare a counterattack. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45175 | 45175 | 1926-09-25 | 5 | a | An attempt to bomb the Japanese consulate in Shanghai fails. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45174 | 45174 | 1926-09-25 | 5 | a | The China Inland Mission and its priests. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45173 | 45173 | 1926-09-25 | 5 | a | British merchants' ships enter Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45172 | 45172 | 1926-09-25 | 5 | a | Transportation between Guangzhou and Hong Kong to be resumed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45171 | 45171 | 1926-09-25 | 3 | f | American's view on the future war with Japan. | America | http://trove.nla.gov.au/newspaper/page/24101719 | 24101719 | |
45170 | 45170 | 1926-09-25 | 3 | e | Five more provinces join the war (Jiangsu, Anhui and others). | China | http://trove.nla.gov.au/newspaper/page/24101719 | 24101719 | |
45169 | 45169 | 1926-09-25 | 3 | d | Feng Yuxiang's ancestors' grave are destroyed in Baoding. | China | http://trove.nla.gov.au/newspaper/page/24101719 | 24101719 | |
45168 | 45168 | 1926-09-25 | 2 | f | Wu Peifu has different strategies in the north and in the south of China. | China | http://trove.nla.gov.au/newspaper/page/24101720 | 24101720 | |
45167 | 45167 | 1926-09-25 | 2 | e | The League of Nations to discuss territorial waters. | America | http://trove.nla.gov.au/newspaper/page/24101720 | 24101720 | |
45166 | 45166 | 1926-09-25 | 2 | e | Tang Jiyao seeks alliance from Wu Peifu to jointly wipe out the communists. | China | http://trove.nla.gov.au/newspaper/page/24101720 | 24101720 | |
45165 | 45165 | 1926-09-25 | 2 | d | Sun Chuanfang and Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24101720 | 24101720 | |
45164 | 45164 | 1926-09-25 | 2 | c | Editorial on the hope to solve the strike in Guangzhou and Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101720 | 24101720 |
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]);