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 |
---|---|---|---|---|---|---|---|---|---|
49366 | 49366 | 1930-08-02 | 2 | c | Zhang Fakui's troops enter Jiangxi province. Wu Peifu to leave Sichuan and assistance promised by Liu Xiang. Situation in Shandong after the fall of Jinan. Jiang Jieshi seeks alliance of Zhang Xueliang. Nanjing government to reinstate Wang Jingwei as the Party member. Circular telegram issued by Sun Baoqi. Communist disasters in Shashi, of Hunan province. Wang Shizhen dies in Beijing. Jiang Jieshi's troops attack Chen Qi in Shanxi. The war along the Longhai railway. | China | http://trove.nla.gov.au/newspaper/page/24099723 | 24099723 | |
49369 | 49369 | 1930-08-02 | 3 | c | Chinese Ministry of Education to abolish classical Chinese textbooks. | China | http://trove.nla.gov.au/newspaper/page/24099722 | 24099722 | |
49376 | 49376 | 1930-08-02 | 8 | c | Foreign religious associations in China protest the Nanjing government for their ban on religious education in Chinese schools. | China | http://trove.nla.gov.au/newspaper/page/24099729 | 24099729 | |
49377 | 49377 | 1930-08-02 | 8 | c | Police in Japan guard against possible riots of the unemployed workers. | Japan | http://trove.nla.gov.au/newspaper/page/24099729 | 24099729 | |
49378 | 49378 | 1930-08-02 | 8 | c | Earthquake in Italy and the aftermath. | Other... | http://trove.nla.gov.au/newspaper/page/24099729 | 24099729 | |
49379 | 49379 | 1930-08-02 | 8 | c | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099729 | 24099729 | |
49380 | 49380 | 1930-08-02 | 8 | c | American archaeologists return to Beijing after a field research in central Asia. | China | http://trove.nla.gov.au/newspaper/page/24099729 | 24099729 |
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]);