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 |
|---|---|---|---|---|---|---|---|---|---|
| 54794 | 54794 | 1935-01-19 | 2 | b | Editorial on the victory of suppression of communists in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 | |
| 54795 | 54795 | 1935-01-19 | 2 | c | China news/ The communist troops and their atrocities in south China. Japanese still seek to occupy the whole north China. News on the Fifth Plenary Session in Nanjing. Remains of the communist troops flee Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 | |
| 54796 | 54796 | 1935-01-19 | 3 | a | Jiang Jieshi on the suppression of the communist troops and meaning of the victory. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
| 54797 | 54797 | 1935-01-19 | 3 | c | Japanese and the railways in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
| 54798 | 54798 | 1935-01-19 | 3 | c | Puyi is preparing for a visit to Japan. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
| 54799 | 54799 | 1935-01-19 | 3 | c | American government on the naval forces. | America | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
| 54800 | 54800 | 1935-01-19 | 3 | d | Huang Shaoxiong becomes governor of Zhejiang province and his team. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
| 54801 | 54801 | 1935-01-19 | 5 | a | The fourth part of a study on the development of the northwest China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096296 | 24096296 | |
| 54802 | 54802 | 1935-01-19 | 5 | c | A breakfast of Napoleon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096296 | 24096296 | |
| 54803 | 54803 | 1935-01-19 | 7-8 | a-f | Guangdong news/ Hu Hanmin and others issue an open letter on the cooperation between Guangzhou and Nanjing. Guangxi dispatches more troops to suppress the communists. Shao Zeru dies in Guangzhou. Zou Lu and Tan Qixiu arrive Guangzhou. Promotion of Chinese products. Hong Kong banks transport silver to Britain and America. Villagers from Zengcheng present their petitions to the provincial government. | China | http://trove.nla.gov.au/newspaper/page/24096298 | 24096298 | |
| 54804 | 54804 | 1935-01-19 | 6 | a | National debt of the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
| 54805 | 54805 | 1935-01-19 | 6 | a | League of Nations on the membership of Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
| 54806 | 54806 | 1935-01-19 | 6 | b | Police in Shanghai raid drug smuggling chains. | China | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
| 54807 | 54807 | 1935-01-19 | 6 | d | Australia news/ Storm in Victoria and the damages. Chinese ferry in Melbourne has an accident. Chinese swimmer Guo Zhenheng joins the competition in Canberra. Chinese government murders journalists. Japanese are very confident in the New Year. Chinese General Qiu Zhaoshen tours Albury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 |
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]);