This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50649 | 50649 | 1931-08-29 | 2 | d | Zhang Xueliang's troops attack Shi Yousan. | China | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
50650 | 50650 | 1931-08-29 | 2 | d | Chinese foreign minister Wang Zhengting wants to resign. Many troops from the northeast are entering the Shanhaiguan. Zhang Xueliang will stay in the Summer Palace for a summer holiday. Family members of Shi Yousan are detained. Jiang Jieshi dispatches more troops to Fujian province. Nanjing government to issue more bonds. Telegram from Zhang Ji and Wu Tiecheng to Gu Yingfen and Sun Ke. Investigation on the anti-Chinese movement in Korea. Jiang Jieshi to gather his troops in Wuhan. Anti-Japanese gathering in Shanghai. Unprecedented floods in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
50653 | 50653 | 1931-08-29 | 3 | d | The Nationalist troops recapture Guangchang and Ningdu in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24090502 | 24090502 | |
50657 | 50657 | 1931-08-29 | 5 | d | The ten characteristics of great men. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090504 | 24090504 | |
50658 | 50658 | 1931-08-29 | 5 | d | Notices issued by the Chinese Consulate in Melbourne and Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090504 | 24090504 | |
50667 | 50667 | 1931-08-29 | 8 | d | Australia news/ Chinese consul-general Gui Zhi talks with various parties on the murder case involved Chinese. The Overseas Chinese Famine Relief Committee in Shanghai calls for donations to the flooding victims in China. The Nationalists and the Hua An Hui (Chinese Society) in Darwin fight each other for the remains of the deceased countrymen. Six Chinese are beheaded in New Zealand. Another bank is closed down in Sydney. Proposal to stop import of tomato. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 |
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]);