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 |
|---|---|---|---|---|---|---|---|---|---|
| 55115 | 55115 | 1935-05-18 | 2 | a | Editorial promotes Chinese products in order to save the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55116 | 55116 | 1935-05-18 | 2 | b | The Chinese communities in the Philippines welcome General Cai Tingkai and a further report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55117 | 55117 | 1935-05-18 | 2 | d | Army officer in Sichuan province kidnaps a girl student and the investigation by the order of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55118 | 55118 | 1935-05-18 | 2 | e | Memorial service in Jiangxi province for those who are killed during the suppression of the communists. | China | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55119 | 55119 | 1935-05-18 | 2 | e | Economic authority in Nanjing to promote cotton production in north China. Jiang Jieshi on the cultivation of waste land. | China | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55120 | 55120 | 1935-05-18 | 2 | f | Dai Ji is appointed advisor in Nanjing. Funeral service in Nanjing for Gao Tangyou. | China | http://trove.nla.gov.au/newspaper/page/24096433 | 24096433 | |
| 55121 | 55121 | 1935-05-18 | 3 | a | Economic existence of foreign powers in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096432 | 24096432 | |
| 55122 | 55122 | 1935-05-18 | 3 | c | Jiang Jieshi removes Tian Songyao. The national industrial authority to administer commodity export. Wang Jingwei talks to foreign journalists. | China | http://trove.nla.gov.au/newspaper/page/24096432 | 24096432 | |
| 55123 | 55123 | 1935-05-18 | 3 | d | European countries are preparing for war and report from Italy, France, Germany and others. | Britain | http://trove.nla.gov.au/newspaper/page/24096432 | 24096432 | |
| 55124 | 55124 | 1935-05-18 | 5 | a | Memorial ceremony in Tangyin, Henan province, for the Song Dynasty national hero Yue Fei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096434 | 24096434 | |
| 55125 | 55125 | 1935-05-18 | 5 | d | Second part of the budget report on the donations of Sydney Chinese communities for the welcome of General Cai Tingkai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096434 | 24096434 | |
| 55126 | 55126 | 1935-05-18 | 6-7 | a-f | Guangdong news/ The communist troops are fleeing north Guangxi province. Foreigners are setting up radio communication in Guangzhou. Deserted soldiers in south Fujian province. Xiao Focheng is leaving Hong Kong for Thailand. Tan Qixiu becomes commander of the First Division. Guangdong authority to unify commercial activities throughout the province. Trade between Hong Kong and the Nanyang area. Hong Kong businessman introduces Japanese goods. Fighting and injury in Xinhui. Floods in Huiyang. Gold found in Taishan. Bandits in Shunde and their robbery. Panyu county authority detains bandit chieftain. Bandits from Jiangxi province are making trouble in Meixian county. | China | http://trove.nla.gov.au/newspaper/page/24096437 | 24096437 | |
| 55127 | 55127 | 1935-05-18 | 8 | a | Storm in Brazil. | Other... | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 | |
| 55128 | 55128 | 1935-05-18 | 8 | a | Japan boycotts to Canadian goods. | Canada | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 | |
| 55129 | 55129 | 1935-05-18 | 8 | b | A Sydney girl disappears in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 | |
| 55130 | 55130 | 1935-05-18 | 8 | c | King of Britain tours the Chinatown in London. | Britain | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 | |
| 55131 | 55131 | 1935-05-18 | 8 | d | Australia news/ New members of the Chinese Chamber of Commerce in NSW are sworn in and the ceremony. A letter from General Cai Tingkai to the Chinese Chamber of Commerce in NSW. New Australian trade commissioner to the Far East. Old Chinese man killed in a train accident in NSW. State election in Queensland. Chinese man is robbed in Sydney. State election in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 |
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]);