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 |
|---|---|---|---|---|---|---|---|---|---|
| 48597 | 48597 | 1929-11-02 | 2 | b | Comments by Tung Wah Times on the government officials and bandits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099413 | 24099413 | |
| 48598 | 48598 | 1929-11-02 | 2 | c | Jiang Jieshi may execute Fang Zhenwu. Feng Yuxiang may lead his troops going east. Political turbulence in Anhui province. Attitude of Mongolian people towards Soviet Russia. Wang Jingwei declares war with Jiang Jieshi. Central Executive Committee in Nanjing decides to arrest Chen Gongbo, Wang Faqin, Bai Wenwei and others. The Nanjing government gives priority to the Party members for government employment. Soviet Russia assists Chinese dissidents. Japan's China policy. | China | http://trove.nla.gov.au/newspaper/page/24099413 | 24099413 | |
| 48599 | 48599 | 1929-11-02 | 2 | f | Zhang Fakui leads his troops to leave Yichang, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24099413 | 24099413 | |
| 48600 | 48600 | 1929-11-02 | 2 | f | Chinese and Russian troops fight in Manzhouli. | China | http://trove.nla.gov.au/newspaper/page/24099413 | 24099413 | |
| 48601 | 48601 | 1929-11-02 | 3 | a | Japanese troops in Tieling, Liaoning province, and their atrocities. | China | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48602 | 48602 | 1929-11-02 | 3 | b | Military commander Wang Fulin is determined to fight for Chinese territory. | China | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48603 | 48603 | 1929-11-02 | 3 | b | Sheng Xuanhuai's properties are sealed off. | China | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48604 | 48604 | 1929-11-02 | 3 | c | New political party organised in China, the Chinese Youth Party. | China | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48605 | 48605 | 1929-11-02 | 3 | c | The Communist forces under the leadership of Zhu De and Mao Zedong. | China | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48606 | 48606 | 1929-11-02 | 3 | e | Motor vehicles in New York. | America | http://trove.nla.gov.au/newspaper/page/24099412 | 24099412 | |
| 48607 | 48607 | 1929-11-02 | 5 | a | Hong Kong news/ Communist offices smashed in Hong Kong and the arrest. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099414 | 24099414 | |
| 48608 | 48608 | 1929-11-02 | 5 | c | Women in Shanghai and their new fashion. Gay and homosexual in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099414 | 24099414 | |
| 48609 | 48609 | 1929-11-02 | 6-7 | a-d | Guangdong news/ The Guangdong troops on the way to Guangxi. Chen Jitang personally supervise the military operations in Xijiang area. Jiang Jieshi moves Mao Bingwen's troops to Guangdong. Provincial government provides extra funds to troops. Few people apply for the county magistrate examinations. Communist school principal Chen Dianbang in Gaoyao is arrested. Waitress in the opium dens. Bandits bomb ferry port. Floods in Thailand and its influence upon the food supply in Chaozhou and Meixian county. Dongguan county magistrate improves the administration of prison. Police in Zhongshan county and the superstition. A shop owner in Zengcheng sleeps with his daughter-in-law. Road construction in Kaiping and Enping. | China | http://trove.nla.gov.au/newspaper/page/24099417 | 24099417 | |
| 48610 | 48610 | 1929-11-02 | 8 | c | Feng Yuxiang occupies Zhengzhou. | China | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48611 | 48611 | 1929-11-02 | 8 | c | Soviet Russian authority arrests monarchists. | Russia | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48612 | 48612 | 1929-11-02 | 8 | c | Wife of Chinese deputy-consul in San Francisco is brought to trial in Nanjing for opium smuggling. Jiang Jieshi defeats Feng Yuxiang in Luoyang, Henan province. Zhang Xueliang reports the border situations. | China | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48613 | 48613 | 1929-11-02 | 8 | d | Foreign visitor on the Chinese situations. | China | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48614 | 48614 | 1929-11-02 | 8 | d | The Nationalist government appropriates funds to Zhang Xueliang for the defence against Russia. | China | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48615 | 48615 | 1929-11-02 | 8 | e | Jiang Jieshi is determined to overthrow Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48616 | 48616 | 1929-11-02 | 8 | e | Zhang Xueliang seeks another talks with Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 48617 | 48617 | 1929-11-02 | 8 | f | Australia news/ Four bandits try to rob Chinese gardener in Sydney. Shop clerk is robbed on his way to the bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 |
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]);