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 |
|---|---|---|---|---|---|---|---|---|---|
| 54929 | 54929 | 1935-03-09 | 2 | a | Editorial on the diplomatic crisis between China and Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24096351 | 24096351 | |
| 54930 | 54930 | 1935-03-09 | 2 | b | China news/ Memorial services in China on the January 28. Li Rong and Sheng Shicai rebuff rumours. Communist leader Fang Zhimin is arrested. | China | http://trove.nla.gov.au/newspaper/page/24096351 | 24096351 | |
| 54931 | 54931 | 1935-03-09 | 3 | a | Disasters in west Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54932 | 54932 | 1935-03-09 | 3 | b | Governor of the Philippines visits Shanghai and his talks on independence. | China | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54933 | 54933 | 1935-03-09 | 3 | c | Japanese police in Dalian arrest Chinese civilians. | China | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54934 | 54934 | 1935-03-09 | 3 | d | American government on the air defence. | America | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54935 | 54935 | 1935-03-09 | 3 | d | Song Ziwen talks to journalists. | China | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54936 | 54936 | 1935-03-09 | 3 | d | Italian air force troops to have an exercise. | Other... | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54937 | 54937 | 1935-03-09 | 3 | e | Panchen Lama is to return. | China | http://trove.nla.gov.au/newspaper/page/24096350 | 24096350 | |
| 54938 | 54938 | 1935-03-09 | 5 | a | Chinese communities in Sydney welcome General Cai Tingkai and his speech. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096352 | 24096352 | |
| 54939 | 54939 | 1935-03-09 | 7-8 | a-f | Guangdong news/ The central authority in Nanjing to reorganise Guizhou provincial government. Steps for the cooperation between Guangzhou and Nanjing. Munitions factory in Guangzhou and the manufacturing of warplanes. Southwest authority on the situation changes in north China. Zhang Zhiying saves money to build warships. Comments on the business in Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24096354 | 24096354 | |
| 54940 | 54940 | 1935-03-09 | 6 | a | Japanese businessmen come to visit China. | Japan | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 | |
| 54941 | 54941 | 1935-03-09 | 6 | a | Another revolutionary movement in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 | |
| 54942 | 54942 | 1935-03-09 | 6 | a | King of Thailand gives up his throne. | Britain | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 | |
| 54943 | 54943 | 1935-03-09 | 6 | a | Australian missionary is kidnapped and murdered in Shanxi province, China. | China | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 | |
| 54944 | 54944 | 1935-03-09 | 6 | a | Effort of the Nationalist government in Nanjing to seek cooperation from the south. | China | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 | |
| 54945 | 54945 | 1935-03-09 | 6 | b | Australia news/ Chinese Consul-General in Sydney Chen Weipin comments on General Cai Tingkai. Zhi gong tang and other Chinese associations in Sydney welcome General Cai Tingkai and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096355 | 24096355 |
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]);