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 |
|---|---|---|---|---|---|---|---|---|---|
| 46930 | 46930 | 1928-04-14 | 2 | b | Editorial on the alliance of Jiang Jieshi, Feng Yuxiang and Yan Xishan and their joint attack to Zhang Zuolin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098760 | 24098760 | |
| 46931 | 46931 | 1928-04-14 | 2 | c | The Northern Expedition after the meeting of Jiang Jieshi and Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24098760 | 24098760 | |
| 46932 | 46932 | 1928-04-14 | 2 | d | High-level commanders of the Fengxi (under Zhang Zuolin) have a meeting in Beijing and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24098760 | 24098760 | |
| 46933 | 46933 | 1928-04-14 | 2 | e | Disasters, famine and refugees in Shandong province, a survey. | China | http://trove.nla.gov.au/newspaper/page/24098760 | 24098760 | |
| 46934 | 46934 | 1928-04-14 | 3 | b | Guangdong government sets up offices (zhao shang ju) to attract foreign investment. | China | http://trove.nla.gov.au/newspaper/page/24098759 | 24098759 | |
| 46935 | 46935 | 1928-04-14 | 3 | c | Central Executive Committee of the Nationalist Party stops to subsidise local branches. | China | http://trove.nla.gov.au/newspaper/page/24098759 | 24098759 | |
| 46936 | 46936 | 1928-04-14 | 3 | c | Yellow River burst its banks in Lijin, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098759 | 24098759 | |
| 46937 | 46937 | 1928-04-14 | 3 | d | Miu Peinan and Fang Dingying lead their troops on the way from Guangdong to Anhui province via Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/24098759 | 24098759 | |
| 46938 | 46938 | 1928-04-14 | 5 | a | Hong Kong news/ Counterfeit bank notes found in the market. Woman is arrested for swindling. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098761 | 24098761 | |
| 46939 | 46939 | 1928-04-14 | 5 | b | Third and final part of the survey on the handmade paper industry in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098761 | 24098761 | |
| 46940 | 46940 | 1928-04-14 | 5 | b | A case of divorce in Pingyang county, of Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24098761 | 24098761 | |
| 46941 | 46941 | 1928-04-14 | 6 | a-d | Guangdong news/ Chen Mingshu refuses to be the chairman of the provincial government and the reason. Provincial government to take back the old French consulate building. The Communist in Chaozhou and Meixian county and the complaints of the local residents. The Communist forces from Haifeng and Lufeng occupy Huilai city and the report. | China | http://trove.nla.gov.au/newspaper/page/24098764 | 24098764 | |
| 46942 | 46942 | 1928-04-14 | 7 | a | The war break out in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46943 | 46943 | 1928-04-14 | 7 | a | A plane explodes in the sky over Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46944 | 46944 | 1928-04-14 | 7 | a | Chinese businessmen in Shanghai boycott to British liner services. | China | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46945 | 46945 | 1928-04-14 | 7 | a | Farmers are detained in Soviet Russia for illegal storage of grains. | Russia | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46946 | 46946 | 1928-04-14 | 7 | a | The Communist evils in Guangdong. Boycott to British shipping service in Yichang, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46947 | 46947 | 1928-04-14 | 7 | a | Japanese naval fleet arrives Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46948 | 46948 | 1928-04-14 | 7 | b | Australia news/ Forged bank notes found in the racing grounds in Melbourne and Sydney. Number of visitors to the Royal Agricultural Show in Sydney. A street fighting in Sydney. A poor man in Sydney is charged and the case. A white man is charged with burglary. A baby is stolen on the street. A furniture factory in Melbourne turns to ashes after a fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 46949 | 46949 | 1928-04-14 | 8 | a-d | Guangdong news/ Guangzhou welcomes the governor of Hong Kong. Peasants' bandits in Dongguan county attack civil corps again. Smuggled weapons found in the government building in Taishan county. Refugees from Dongguan county and their petition in Guangzhou. Bandits in Daliang. Zhongshan University takes over the sericulture in Maoming county. All trade unions in Zhaoqing are ordered to disband. Zhongshan county requests Macao authority to extradite the Communist activists. Communists Xian Hongbiao and three others are executed in Zhongshan county. Bandits set fire on ferries in Taishan county. | China | http://trove.nla.gov.au/newspaper/page/24098766 | 24098766 |
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]);