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 |
---|---|---|---|---|---|---|---|---|---|
55614 | 55614 | 1935-11-30 | 2 | b | Wang Jingwei is seriously injured in an assignation in Nanjing and the report. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
55615 | 55615 | 1935-11-30 | 2 | e | Japanese seduce Yan Xishan to organise another government in north China. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
55616 | 55616 | 1935-11-30 | 2 | e | Jiang Jieshi and his strategies to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
55617 | 55617 | 1935-11-30 | 2 | f | Many villages in northeast of Siyang county, Jiangsu province, are flooded. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
55618 | 55618 | 1935-11-30 | 3 | a | Wang Jingwei, Song Ziwen and others meet in Nanjing on the relations with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
55619 | 55619 | 1935-11-30 | 3 | a | Nanjing government prepares to accept Japanese demands. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
55621 | 55621 | 1935-11-30 | 8 | c | Peasants in Hebei and Henan province organise their own rebellions against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
55622 | 55622 | 1935-11-30 | 3 | e | Jiang Jingguo, the eldest son of Jiang Jieshi, return to China from Russia. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
55625 | 55625 | 1935-11-30 | 6-7 | a-f | Guangdong news/ Japanese military commander Okamara visits Guangdong. South China improves its relationship with Japan. Bank of Guangdong is ready to reopen. Japanese seek to expand its market in south China. Guangdong businessmen are active after the visit of Okamara. Hong Kong and Shanghai Banking Corporation in Guangzhou. Businessmen need some national conscientiousness. Export of silver from China. Group wedding in Zhongshan county on the National Day. Villages are fighting for land in Panyu. Bandits in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24096664 | 24096664 | |
55628 | 55628 | 1935-11-30 | 8 | b | Japanese demand autonomy of the five provinces in north China and the report. | China | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 |
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]);