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 |
|---|---|---|---|---|---|---|---|---|---|
| 54664 | 54664 | 1934-11-17 | 2 | a | Editorial on the national heroes in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096232 | 24096232 | |
| 54665 | 54665 | 1934-11-17 | 2 | c | China news/ Celebrations on the National Day in China. Japanese troops in Manchuria to have an exercise. Jiang Jieshi and Zhang Xueliang to Luoyang in Henan province. Chinese government negotiates with Japan on the deportation of Chinese immigrants. Jiang Bocheng arrives Shanghai from Guangzhou. Jiang Jieshi and his strategies to eradicate the communists. Airport building in Hengyang, Hunan province. Gu Zhutong dies in an air accident. Disasters in south Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096232 | 24096232 | |
| 54666 | 54666 | 1934-11-17 | 3 | a | Speech of General Cai Tingkai at the welcome ceremony of the Chinese communities in Boston. | America | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
| 54667 | 54667 | 1934-11-17 | 3 | c | German prophet predicts the second world war will break out next summer. | America | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
| 54668 | 54668 | 1934-11-17 | 3 | d | Efforts to suppress the communist troops in Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
| 54669 | 54669 | 1934-11-17 | 3 | e | Chinese communities in America help China's export. | China | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
| 54670 | 54670 | 1934-11-17 | 3 | f | Japan regards Taiwan as the first front-line of national defence. | China | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
| 54671 | 54671 | 1934-11-17 | 5 | b | First part of biography of Liang Qichao and his photograph. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096233 | 24096233 | |
| 54672 | 54672 | 1934-11-17 | 7-8 | a-f | Guangdong news/ Provincial legislature assembly promote social morality. Wang Chonghui on the cooperation between Hong Kong and Guangdong. Intelligence reports that more than 70,000 communist troops gather in Ruijin, of Jiangxi province. Tang Shaoyi is hospitalised and the situation in Zhongshan county. Zhongshan people recommend Zhu Zhuowen the new magistrate. Xiao Focheng comments on the reply of the Central Government in Nanjing. Army commander Luo Zhuoying arrives Guangzhou. Business in Macao. Exhibition of Chinese products in the Philippines. County troops involved in mutiny in Zhongshan county and the future of Tang Shaoyi. Jiang Guanglai returns to his hometown in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24096235 | 24096235 | |
| 54673 | 54673 | 1934-11-17 | 6 | a | Celebrations in Soviet Russia on the National Day. | Russia | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 | |
| 54674 | 54674 | 1934-11-17 | 6 | b | Britain seeks to sell planes to China. | Britain | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 | |
| 54675 | 54675 | 1934-11-17 | 6 | b | British businessmen in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 | |
| 54676 | 54676 | 1934-11-17 | 6 | c | Australia news/ Members of the new federal cabinet. Chinese tobacco shop robbed in Sydney. Heavy rains in Victoria. A robbery in Sydney. Prince of Britain tours Tasmania. Jewellery shop is robbed in Sydney. Sydney welcomes Prince of Britain and the ceremony. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 |
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]);