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 |
|---|---|---|---|---|---|---|---|---|---|
| 47287 | 47287 | 1928-08-04 | 2 | b | First part of editorial by Tung Wah Times worries about the rapid spread of Communism in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47288 | 47288 | 1928-08-04 | 2 | c | Japanese troops fire at the Nationalist army in Shouguang county, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47289 | 47289 | 1928-08-04 | 2 | d | The internal fighting in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47290 | 47290 | 1928-08-04 | 2 | f | Foreign minister Wang Zhengting is optimistic on the revision of foreign treaties. | China | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47291 | 47291 | 1928-08-04 | 2 | f | Zhang Xueliang and his recent attitudes. | China | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47292 | 47292 | 1928-08-04 | 2 | f | The disarmament plan proposed by Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098898 | 24098898 | |
| 47293 | 47293 | 1928-08-04 | 3 | b | Yan Xishan on the disarmament plan proposed by Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
| 47294 | 47294 | 1928-08-04 | 3 | b | Zhang Xueliang and Wu Tailai are blamed. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
| 47295 | 47295 | 1928-08-04 | 3 | c | Jiang Jieshi convenes an economic conference in Shanghai and the participants. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
| 47296 | 47296 | 1928-08-04 | 3 | c | The Nanjing government appoints Wang Dading the first ambassador to Japan. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
| 47297 | 47297 | 1928-08-04 | 3 | d | Xue Dubi, Minister of Internal Affairs of the Nanjing government, prohibits women from restraining themselves. Feng Yuxiang resigns and the reason. Dethroned emperor Puyi and Zhang Xueliang and the future of Manchuria. The Nanjing government to replace some of the overseas missions. Yang Yuting is killed by Zhang Xueliang. Chief justice changed in the temporary court in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098897 | 24098897 | |
| 47298 | 47298 | 1928-08-04 | 5 | a | Hong Kong news/ Husband murders wife during his honeymoon. He Xiangni and Li Fulin are back to Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098899 | 24098899 | |
| 47299 | 47299 | 1928-08-04 | 5 | b | First part of a survey on the mercurial mining resources in Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098899 | 24098899 | |
| 47300 | 47300 | 1928-08-04 | 5 | c | Vernacular drama performance of the female youth association in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098899 | 24098899 | |
| 47301 | 47301 | 1928-08-04 | 6-7 | a-d | Guangdong news/ Security troops demand the Panyu county authority to hand over civil corps and the clashes. Li Jishen leaves Guangzhou for Nanjing. The Communist Party in Guangzhou engages many female servants as spy. Opposition of the Guangdong authority to Wang Jingwei. A thorough search for the Communists in Guangzhou. Mutiny of the 13th Army in Guangdong. Floods in local Guangdong. Road construction from Jiangmen to Foshan. Division Commander of the Red Army is arrested in Haifeng county. Epidemic disease in Zhongshan county. House maids are lured away in Zhongshan county. The Communist offices are uncovered in Dongguan county. Feud and fighting of two clans, Zhang and Jiang, in Zengcheng county. Martial law enforced in six villages in Taishan county. Storm in Xinhui. Road construction in Zhaoqing. Bandits in Jiujiang hijack two ferries. Bandits in Enping county. Roamer is killed in Chencun Village, Nanhai county. | China | http://trove.nla.gov.au/newspaper/page/24098902 | 24098902 | |
| 47302 | 47302 | 1928-08-04 | 8 | a | Riots in Yantai, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
| 47303 | 47303 | 1928-08-04 | 8 | a | Marine insurance companies in Britain refuse to Chinese clients. | Britain | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
| 47304 | 47304 | 1928-08-04 | 8 | a | Strike in India and the report. | Other... | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
| 47305 | 47305 | 1928-08-04 | 8 | a | Bandits rob shops in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
| 47306 | 47306 | 1928-08-04 | 8 | a | Dog racing in Shanghai. American government may recognise the Chinese tariff autonomy. | China | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
| 47307 | 47307 | 1928-08-04 | 8 | b | Australia news/ Japanese purchase iron resources from Australia. Drunken men and women are detained in Sydney. Train derails in Queensland. A letter from the Chinese Chamber of Commerce in New South Wales to the Sydney city council on the vegetable booths, and the letter is signed by Liu Guangfu and Charlie Deng. Unemployment in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 |
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]);