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 |
|---|---|---|---|---|---|---|---|---|---|
| 46886 | 46886 | 1928-03-31 | 2 | b | Tung Wah Times comments on the orders issued by Guangdong government to disband all trade unions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46887 | 46887 | 1928-03-31 | 2 | c | Jiang Jieshi removes He Yingqin from his post of military commander. | China | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46888 | 46888 | 1928-03-31 | 2 | d | Sun Chuanfang to govern Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46889 | 46889 | 1928-03-31 | 2 | d | Collaboration between the Guangxi faction and the jiaotong faction. | China | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46890 | 46890 | 1928-03-31 | 2 | e | Japan's new policy under the new cabinet. | Japan | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46891 | 46891 | 1928-03-31 | 2 | f | Situation in Sichuan province is alleviated, Wu Peifu still stays in Dazhu while Deng Xihou to resume his office soon. | China | http://trove.nla.gov.au/newspaper/page/24098744 | 24098744 | |
| 46892 | 46892 | 1928-03-31 | 3 | b | The new Japanese cabinet and their China policy. | China | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
| 46893 | 46893 | 1928-03-31 | 3 | b | The enthroning ceremony for the emperor of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
| 46894 | 46894 | 1928-03-31 | 3 | c | News from Fengtian province (devaluation of currency, bandits, closure of shops and refugees). | China | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
| 46895 | 46895 | 1928-03-31 | 3 | d | The Big Sword Society in Fengtian and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
| 46896 | 46896 | 1928-03-31 | 3 | e | The Nationalist navy is to purchase old warship from Argentina. | China | http://trove.nla.gov.au/newspaper/page/24098743 | 24098743 | |
| 46897 | 46897 | 1928-03-31 | 5 | a | Hong Kong news/ Hong Kong businessmen have high hope on Li Jishen. Hong Kong is preparing to welcome Li Jishen. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098745 | 24098745 | |
| 46898 | 46898 | 1928-03-31 | 5 | b | First part of a survey on the handmade paper industry in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098745 | 24098745 | |
| 46899 | 46899 | 1928-03-31 | 5 | d | Revenge against a playboy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098745 | 24098745 | |
| 46900 | 46900 | 1928-03-31 | 6 | a-e | Guangdong news/ Fierce battle between the 16th Army and the Communist forces in Renhua county, Guangdong. Li Jishen on his disarmament policy. Li Jishen to disband Fan Shisheng's troops. Police chief Deng Yanhua ban dancing in Guangzhou. Chen Jitang is very pessimistic. Police chief Deng Yanhua lists corruption and evil habit of the police force. The provincial government to reinstall the land management bureau in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098748 | 24098748 | |
| 46901 | 46901 | 1928-03-31 | 7 | a | Feng Yuxiang leads his troops to retreat to Zhangde while Jiang Jieshi is guiding his army going north. Zhang Shaozeng is assassinated in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46902 | 46902 | 1928-03-31 | 7 | a | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46903 | 46903 | 1928-03-31 | 7 | a | Foreigners in north China are very arrogant. British ambassador on his negotiation with the Nanjing government before leaving Shanghai. Japanese in Xiamen, Fujian, arrest to Korean men in the Chinese territory. Borodin is back to China again. | China | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46904 | 46904 | 1928-03-31 | 7 | b | Australia news/ A young woman is raped in Darlinghurst, Sydney. Chinese school boy in Sydney dies in an accident. Chinese are penalised for opium smoking. White men are penalised for gambling. White women in Melbourne are detained for dating black boys from America. Young woman in detained in Sydney for shoplift. Ouyang Nan, businessman in Sydney and member of the Nationalist Party branch, sues Liang Yunzhou because their have different attitude towards the Nanjing and Wuhan governments. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46905 | 46905 | 1928-03-31 | 7 | e | A notice by the Wing On Textile Company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46906 | 46906 | 1928-03-31 | 7 | e | A notice by the Chinese Presbyterian Church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
| 46907 | 46907 | 1928-03-31 | 8 | a-d | Guangdong news/ Bandits in Shilong town, of Dongguan county. Xu Kequan and his troops defect and the influence of the Communist forces. Li Jishen and his strategy to deal with Jiang Jieshi. The Northern Expedition troops overlook the Communist forces. Some prominent figures are considering to deal with the aftermath of the Communist disaster. Peng Bai, leader of the peasants' movement in Haifeng and Lufeng county, is arrested. | China | http://trove.nla.gov.au/newspaper/page/24098750 | 24098750 |
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]);