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 |
|---|---|---|---|---|---|---|---|---|---|
| 48107 | 48107 | 1929-05-18 | 2 | b | Guangxi army start their attack on Guangdong and comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099218 | 24099218 | |
| 48108 | 48108 | 1929-05-18 | 2 | c | Li Mingrui defects to Jiang Jieshi. Feng Yuxiang issues a declaration to the Guangxi army. Tao Jun surrenders himself to Jiang Jieshi. Jiang Jieshi still suspects Tang Shengzhi. Branch in Kaifeng, Henan province, of the political council is disbanded. Xu Dubi is determined to leave China. Rumours says Chu Yucheng dies. Smuggled weapons seized in Nanjing. Jiang Jieshi appoint Sun Liangcheng to administer Shandong province. Jiang Jieshi issues a public notice after taking over Wuhan. Both He Jian and Li Mingrui defect to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099218 | 24099218 | |
| 48109 | 48109 | 1929-05-18 | 2 | e | New appointments by the Nationalist government in Nanjing (Yang Shuzhuang, Fan Qiwu and Wong Guiqing). | China | http://trove.nla.gov.au/newspaper/page/24099218 | 24099218 | |
| 48110 | 48110 | 1929-05-18 | 2 | f | Military clashes in Changding, Fujian province, between the Communist forces and the government troops. | China | http://trove.nla.gov.au/newspaper/page/24099218 | 24099218 | |
| 48111 | 48111 | 1929-05-18 | 2 | f | Mongolian nobilities oppose to the Three People's Principles of Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24099218 | 24099218 | |
| 48112 | 48112 | 1929-05-18 | 3 | a | Troops from Nanjing are now trying to maintain public order in Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48113 | 48113 | 1929-05-18 | 3 | a | Report from Shanghai says Sichuan army are coming back. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48114 | 48114 | 1929-05-18 | 3 | b | Japanese troops in Jinan, Shandong province, urge Chinese side to relieve the garrison. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48115 | 48115 | 1929-05-18 | 3 | b | Huge amount of coal resources found in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48116 | 48116 | 1929-05-18 | 3 | d | A survey on the mining resources in the east of Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48117 | 48117 | 1929-05-18 | 3 | e | The power of foreigners in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48118 | 48118 | 1929-05-18 | 3 | e | The social order in Wuhan after its fall. | China | http://trove.nla.gov.au/newspaper/page/24099217 | 24099217 | |
| 48119 | 48119 | 1929-05-18 | 5 | a | Hong Kong news/ Guangdong provincial authority ban the entry of Hong Kong newspaper. Hong Kong authority investigates the disappearance of some money. Chen Mingshu is to be discharged from the hospital. Pilots from Yunnan province are testing flying in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099219 | 24099219 | |
| 48120 | 48120 | 1929-05-18 | 6-7 | a-d | Guangdong news/ Li Bai and his new battle plan. Guangzhou on high alert. Fan Shisheng leads his troops to leave Chenzhou, Hunan. Guangdong authority has new decision on the army provisions to the Guangxi troops. Chen Shu as new naval commander. Businessmen urge the government to abolish strict restrictions. Provincial authority prohibits local counties from killing farm cattle. Poultry businessmen protest against surtax. New office set up in Zhongshan county for political training. The state government will take over the coastal areas in Shiqi. Innocent people in Zhongshan county are punished as communist members. Protest in Taishan county against road construction. Feud and fighting between two clans, Mo and Wu, in Enping county. Rinderpest in Gaoming county. All actresses of a drama troupe are kidnapped in Nanxiong county. Looting of the Communist Party in Fengshun county. Police in Zengcheng trap waitress. Bandits in Dongguan county. Salt businessmen are on strike in Taishan county. Bandits in Rongji. | China | http://trove.nla.gov.au/newspaper/page/24099222 | 24099222 |
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]);