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 |
|---|---|---|---|---|---|---|---|---|---|
| 47714 | 47714 | 1929-01-05 | 2 | b | Greetings and editorial by Tung Wah Times on the occasion of the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099074 | 24099074 | |
| 47715 | 47715 | 1929-01-05 | 2 | c-f | Troops in Shanghai harbour opium smuggling and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24099074 | 24099074 | |
| 47716 | 47716 | 1929-01-05 | 2 | f | Bai Chongxi refuses to go to Xinjiang, north-west of China. | China | http://trove.nla.gov.au/newspaper/page/24099074 | 24099074 | |
| 47717 | 47717 | 1929-01-05 | 3 | b | Prominent figures in Sichuan province suggest to set up the Tibet province and their appeal. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
| 47718 | 47718 | 1929-01-05 | 3 | d | Ancient graves found in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
| 47719 | 47719 | 1929-01-05 | 3 | d | Fu Zuoyi in Tianjin resigns due to his empty pockets. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
| 47720 | 47720 | 1929-01-05 | 3 | e | Internal disputes in Manchuria. Zhang Xueliang's attitude is still unstable. Zhou Xicheng from Guizhou province sends telegram to his representative in Nanjing. Soviet Russia seeks to control Xinjiang province. Japanese conspiracy in Dalian, Fengtian province. Bandits in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
| 47721 | 47721 | 1929-01-05 | 3 | f | Japanese police in Tokyo stop the plan to erect a statue of Sun Yatsen. | Japan | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
| 47722 | 47722 | 1929-01-05 | 5 | a | Hong Kong news/ Naval forces wipe out bandits in Sanmen Bay. The bankruptcy of wan shun feng in Hong Kong and the debt problem. The Communist members find new way to make trouble in Hong Kong. Another porcelain shop is closed down. Well-known bandits from Dongguan are arrested in Hong Kong. Miscellaneous report from Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099075 | 24099075 | |
| 47723 | 47723 | 1929-01-05 | 6-7 | a-d | Guangdong news/ Guangxi provincial authority tries to civilise the Miao and Yao minority people and the strategies. Candidates for the chairman of the provincial government. Leftists are very active in Guangzhou. Proposal to punish Chen Gongbo, Wang Zhaoming, Yan Mengyu and Gan Naiguang. Fruit shops in Guangzhou suffer from the strike. Communist offices are smashed in Gaoyao county. Special levy for road construction in Taishan claims five lives and the report. Troops in Xinhui county have clash with bandits. House demolished in Dongguan for the road projects. Bandits in Zhongshan and Shunde county. Drought and floods in Puning county. | China | http://trove.nla.gov.au/newspaper/page/24099078 | 24099078 | |
| 47724 | 47724 | 1929-01-05 | 8 | a | China may move its national capital to Xi'an, of Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
| 47725 | 47725 | 1929-01-05 | 8 | a | Japanese immigration to Brazil and the influence. | Japan | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
| 47726 | 47726 | 1929-01-05 | 8 | a | Zhang Xueliang in Manchuria turns to support the Nationalist government in Nanjing. Twelve countries have signed treaties with China including America, Germany, France, Italy, Britain, Holland and Switzerland. Famine in Beiping and the victims. | China | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
| 47727 | 47727 | 1929-01-05 | 8 | a | Australia news/ Chinese gardener in New South Wales is shot dead. Chinese sailor is detained in Sydney for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
| 47728 | 47728 | 1929-01-05 | 8 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
| 47729 | 47729 | 1929-01-05 | 8 | c | Advertisement for the National Bank of Australia Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 |
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]);