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 |
|---|---|---|---|---|---|---|---|---|---|
| 54963 | 54963 | 1935-03-23 | 2 | a | Second and final part of editorial comments on the criticism of welcome of General Cai Tingkai by the Sydney Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096367 | 24096367 | |
| 54964 | 54964 | 1935-03-23 | 2 | d | Wang Chonghui on the cooperation between Guangzhou and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096367 | 24096367 | |
| 54965 | 54965 | 1935-03-23 | 2 | f | Yan Huiqing leaves Shanghai for Russia. | China | http://trove.nla.gov.au/newspaper/page/24096367 | 24096367 | |
| 54966 | 54966 | 1935-03-23 | 3 | a | Hong Kong journalist interview Xiao Focheng. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096366 | 24096366 | |
| 54967 | 54967 | 1935-03-23 | 3 | b | Former governor of Rehe province Tang Yulin now enjoys his life. | China | http://trove.nla.gov.au/newspaper/page/24096366 | 24096366 | |
| 54968 | 54968 | 1935-03-23 | 3 | d | The communist troops in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096366 | 24096366 | |
| 54969 | 54969 | 1935-03-23 | 3 | e | Britain is closely watching the Far East. | China | http://trove.nla.gov.au/newspaper/page/24096366 | 24096366 | |
| 54970 | 54970 | 1935-03-23 | 5 | a | Chinese communities in Sydney farewell General Cai Tingkai and his secretary. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096368 | 24096368 | |
| 54971 | 54971 | 1935-03-23 | 7-8 | a-f | Guangdong news/ Envoy of the Central Government Huang Musong on his visit to Tibet. Government troops in Guizhou and their pursuit of the communist army. Cai Yuanpei and Li Shizeng continue to secure the cooperation between Guangzhou and Nanjing after Wang Chonghui left. He Jian of Hunan province condemns Hu Shi. Luo Xincai back to Guangdong. Industry and business in Guangzhou. Panyu county sets up another police station. | China | http://trove.nla.gov.au/newspaper/page/24096370 | 24096370 | |
| 54972 | 54972 | 1935-03-23 | 7 | a | Comments on the visit of General Cai Tingkai and the welcome ceremony organised by the Sydney Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096370 | 24096370 | |
| 54973 | 54973 | 1935-03-23 | 6 | a | Chinese communities in Brisbane welcome General Cai Tingkai. Their communications with Zhu Songqing, chairman of the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096371 | 24096371 | |
| 54974 | 54974 | 1935-03-23 | 6 | c | Chinese associations in Sydney, Goulburn and Melbourne welcome General Cai Tingkai (Zengcheng lian yi tang, si yi Society, Chinese Medical Association and Nanjing Cafe). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096371 | 24096371 |
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]);