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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
55193 | 55193 | 1935-06-08 | 8 | d | Earthquake in India. | Other... | 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 | |
55191 | 55191 | 1935-06-08 | 8 | a | Another earthquake in Taiwan. | Japan | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55190 | 55190 | 1935-06-08 | 8 | a | Typhoon swaps France and the floods. | France | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
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 | |
55188 | 55188 | 1935-06-08 | 3 | e | Soviet Russia expands naval forces. | Britain | 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 | |
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 | |
55185 | 55185 | 1935-06-08 | 3 | c | Turkey welcomes Chinese ambassador. | Other... | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
55184 | 55184 | 1935-06-08 | 3 | a | The communist uprising in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24096456 | 24096456 | |
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 | |
55182 | 55182 | 1935-06-08 | 2 | d | Guizhou province has a new government. | 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 | |
55180 | 55180 | 1935-06-08 | 2 | b | Jiang Jieshi to leave Guiyang for Kunming. | China | http://trove.nla.gov.au/newspaper/page/24096457 | 24096457 | |
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 |
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]);