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 |
---|---|---|---|---|---|---|---|---|---|
54626 | 54626 | 1934-10-27 | 2 | a | Editorial on the bookish and corrupt Chinese officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096206 | 24096206 | |
54627 | 54627 | 1934-10-27 | 2 | c | Wang Jingwei and Sun Ke meet Jiang Jieshi in Jiangxi. Jiang Jieshi moves more troops to Fujian. The Confucian temples in Shandong to be renovated. Communist troops under Xiao Ke harass Liping in Hubei province. Yan Xishan's suggestions to the central committee conference in Nanjing. Original agreement on the railway project from Guangzhou to Kowloon. China's import surplus from January to August. China's import of perfume last year. Remains of Chen Jiongming to be buried in Huizhou. | China | http://trove.nla.gov.au/newspaper/page/24096206 | 24096206 | |
54628 | 54628 | 1934-10-27 | 3 | a | More Japanese troops gather along the Great Wall. | China | http://trove.nla.gov.au/newspaper/page/24096205 | 24096205 | |
54629 | 54629 | 1934-10-27 | 3 | a | Japanese government replies to China's protest against deportation of Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24096205 | 24096205 | |
54630 | 54630 | 1934-10-27 | 3 | b | American newspaper condemns Japan. | America | http://trove.nla.gov.au/newspaper/page/24096205 | 24096205 | |
54631 | 54631 | 1934-10-27 | 7-8 | a-f | Guangdong news/ Memorial service in Guangzhou on the birthday of Confucius. Relations between Guangzhou and Nanjing. Guangxi authority on the defence. Chen Jitang moves warplanes from Shaoguan to Nanxiong. Memorial service in Guangzhou on September 18. Bai Chongxi inspects the front-line in Quanzhou. Chinese businessmen from Nanyang to return for an industrial investigation. Car accident in Zhongshan and the casualties. Clan fighting in Nanhai and the solution. Man and ghost fight in Boluo. Opium smuggling in Panyu. Ferry sinks in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24096211 | 24096211 | |
54632 | 54632 | 1934-10-27 | 6 | a | Prince of Britain is engaged. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54633 | 54633 | 1934-10-27 | 6 | a | British businessman suggests to open a commercial port in north Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54634 | 54634 | 1934-10-27 | 6 | b | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54635 | 54635 | 1934-10-27 | 6 | b | Centenary celebration in Melbourne. | Britain | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54636 | 54636 | 1934-10-27 | 6 | d | Australia news/ Preparations for the centenary celebration in Melbourne. Australian plane flies over the Pacific. Trams on strike in Melbourne and the solution. American warship arrives Sydney. Plane disappears in Tasmania. Flight competition in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 |
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]);