This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50647 | 50647 | 1931-08-29 | 2 | c | Jiang Jieshi issues a circular telegram on the anti-Chinese movement in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
50648 | 50648 | 1931-08-29 | 2 | c | Jiang Jieshi and Zhang Xueliang jointly issue a circular telegram on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
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 | |
50651 | 50651 | 1931-08-29 | 3 | a | Foreign Minister Wang Zhengting reports the anti-Chinese movement in Korea and the atrocity of Japanese police in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24090502 | 24090502 | |
50652 | 50652 | 1931-08-29 | 3 | b | A public gathering in Shanghai mourns the fellow countrymen murdered in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090502 | 24090502 | |
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 | |
50654 | 50654 | 1931-08-29 | 3 | e | Korean people are driving away Chinese from Wanbao Mountain area in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090502 | 24090502 | |
50659 | 50659 | 1931-08-29 | 6-7 | a-d | Guangdong news/ Criminal suspect arrested in Guangzhou for attempted sabotage in the air force base. Complaints about the tap water in Guangzhou. News on the Communist forces and their recent manoeuvre. The world of bandits in north Guangdong. Chen Youren arrives Japan secretly. Hundreds of innocent people killed in a clan fighting in Boluo county. Fire and tragedy in Ducheng. Young man returned from overseas is robbed in Dongguan. Opium ban in Zhongshan county. Monster fish in Heyuan county devours man. Butchers in Xinhui fight exorbitant taxes. Communist troops in Dapu county fight bandits. Bandits in Panyu. | China | http://trove.nla.gov.au/newspaper/page/24090507 | 24090507 | |
50662 | 50662 | 1931-08-29 | 8 | b | The flooding Yangtze River in China. | China | 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]);