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 |
---|---|---|---|---|---|---|---|---|---|
55179 | 55179 | 1935-06-08 | 2 | a | Editorial on the communist crisis in the southwest of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
55180 | 55180 | 1935-06-08 | 2 | b | Jiang Jieshi to leave Guiyang for Kunming. | China | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
55181 | 55181 | 1935-06-08 | 2 | c | A further report on the welcome ceremony in Shanghai for the visiting American industrial delegation. | China | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
55182 | 55182 | 1935-06-08 | 2 | d | Guizhou province has a new government. | China | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
55183 | 55183 | 1935-06-08 | 2 | e | Detailed report on the anti-Chinese movement in Thailand. | China | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
55184 | 55184 | 1935-06-08 | 3 | a | The communist uprising in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55185 | 55185 | 1935-06-08 | 3 | c | Turkey welcomes Chinese ambassador. | Other... | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55186 | 55186 | 1935-06-08 | 3 | d | Chinese ambassador in Washington Shi Zhaoji on the silver price and its influence upon Chinese economy. | America | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55187 | 55187 | 1935-06-08 | 3 | e | American parliament approves new budget for the building of more warships. | America | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55188 | 55188 | 1935-06-08 | 3 | e | Soviet Russia expands naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55189 | 55189 | 1935-06-08 | 6-7 | a-f | Guangdong news/ A survey on the peasants' life in Guangdong. Some counties to have deputy magistrate. Fighting the Communist troops in the southwest. Welcome for Cai Tingkai in Hong Kong. Construction of arsenal in Guangzhou to be completed soon. The communists in the Hainan island. Jiang Guanglai arrives Hong Kong. Anniversary celebrations in Hong Kong for the King of Britain. Tang Shaoyi asks for release of Lin Jinghun in Zhongshan county. Ferry bombed in Gaoming. Businessmen returned from Thailand are kidnapped in Jieyang county. | China | http://trove.nla.gov.au/newspaper/page/24096461 | 24096461 | |
55190 | 55190 | 1935-06-08 | 8 | a | Typhoon swaps France and the floods. | France | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55191 | 55191 | 1935-06-08 | 8 | a | Another earthquake in Taiwan. | Japan | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55192 | 55192 | 1935-06-08 | 8 | b | Japanese troops in north China and their ambition in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55193 | 55193 | 1935-06-08 | 8 | d | Earthquake in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55194 | 55194 | 1935-06-08 | 8 | e | Australia news/ Federal government issues more bonds. Japanese envoy comes to visit Australia. Investigation on the murder of Chinese gardener in Sydney. A Chinese body found in Nepean River, NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55195 | 55195 | 1935-06-08 | 8 | f | Advertisement of the Australian Loan Council for the new loans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 |
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]);