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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 45173 | 45173 | 1926-09-25 | 5 | a | British merchants' ships enter Guangzhou. | 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 | |
| 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 | |
| 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 | |
| 45177 | 45177 | 1926-09-25 | 5 | b | British government appoints new ambassador to China. | Britain | 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 | |
| 45179 | 45179 | 1926-09-25 | 5 | c | Yang Sen agrees to return British ships. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
| 45180 | 45180 | 1926-09-25 | 5 | c | Storm in America. | America | 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 | |
| 45182 | 45182 | 1926-09-25 | 6 | b-d | Chinese community in Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101724 | 24101724 | |
| 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 | |
| 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 | |
| 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 |
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]);