This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50646 | 50646 | 1931-08-29 | 2 | b | Editorial by Tung Wah Times on the efforts to eliminate bandits in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090503 | 24090503 | |
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 |
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]);