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 |
|---|---|---|---|---|---|---|---|---|---|
| 55305 | 55305 | 1935-08-03 | 2 | b | Further report on the national crisis in China and the suppression of the communist troops in Sichuan and Xikang area, southwest of China. | China | http://trove.nla.gov.au/newspaper/page/24096521 | 24096521 | |
| 55306 | 55306 | 1935-08-03 | 2 | b | Declaration issued by mass associations in Guangxi to fight Japanese invaders. Report on Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24096521 | 24096521 | |
| 55307 | 55307 | 1935-08-03 | 2 | f | The communist troops under Xu Xiangqian to invade Chengdu, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096521 | 24096521 | |
| 55308 | 55308 | 1935-08-03 | 3 | a | Chinese communities in the Nanyang area like to use hand-woven cloth from China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
| 55309 | 55309 | 1935-08-03 | 3 | b | British parliament debates the north China crisis. | Britain | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
| 55310 | 55310 | 1935-08-03 | 3 | c | Japanese newspaper reveals the warm attitude of Nanjing government towards Japanese invaders. | Japan | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
| 55311 | 55311 | 1935-08-03 | 3 | c | Japanese economic invasion of north China and their exploitation of the natural resources. Chinese troops in Manchuria fight Japanese invaders. Remains of Ma Zhanshan's troops in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
| 55312 | 55312 | 1935-08-03 | 3 | e | Japan and Germany may have a military alliance. | America | http://trove.nla.gov.au/newspaper/page/24096520 | 24096520 | |
| 55313 | 55313 | 1935-08-03 | 5 | d | Poems written by Zou Lu on the departure of Hu Hanmin for Europe. | China | http://trove.nla.gov.au/newspaper/page/24096522 | 24096522 | |
| 55314 | 55314 | 1935-08-03 | 5 | f | The Chinese School in Melbourne and its budget. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096522 | 24096522 | |
| 55315 | 55315 | 1935-08-03 | 6-7 | a-f | Guangdong news/ Professors of Zhongshan University jointly issue circular telegram to condemn Jiang Jieshi and Wang Jingwei. Relations between Guangzhou and Nanjing following the fall of north China. Floods victims in Zhongshan and Shunde counties. Bandits in Taishan. Old woman in Zhongshan gives birth to twin boys. Floods in Gaoyao and Gaoming counties. Famine victims in Kaiping plea for help. | China | http://trove.nla.gov.au/newspaper/page/24096525 | 24096525 | |
| 55316 | 55316 | 1935-08-03 | 8 | a | Italian newspaper condemns Japanese invasion of China. | Britain | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
| 55317 | 55317 | 1935-08-03 | 8 | a | A blast in Singapore and the investigation. | Singapore | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
| 55318 | 55318 | 1935-08-03 | 8 | c | Exhibition in London of Chinese products. | Britain | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
| 55319 | 55319 | 1935-08-03 | 8 | c | Japan increases its military expenditure. | Japan | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 | |
| 55320 | 55320 | 1935-08-03 | 8 | e | Australia news/ It is time to lodge personal tax again. Red snow in Victoria. Old attendant in the Sydney See Yup Temple dies suddenly. Many Italian immigrants are applying for Australian citizenship. Chinese man killed in a tram accident in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096527 | 24096527 |
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]);