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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
45177 | 45177 | 1926-09-25 | 5 | b | British government appoints new ambassador to China. | Britain | 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 | |
45182 | 45182 | 1926-09-25 | 6 | b-d | Chinese community in Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101724 | 24101724 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
45165 | 45165 | 1926-09-25 | 2 | d | Sun Chuanfang and Jiang Jieshi. | China | 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 | |
45174 | 45174 | 1926-09-25 | 5 | a | The China Inland Mission and its priests. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
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 | |
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 | |
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 | |
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 | |
45179 | 45179 | 1926-09-25 | 5 | c | Yang Sen agrees to return British ships. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 |
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]);