This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49006 | 49006 | 1930-03-29 | 2 | b | Second part of comments on the three crisis of the national defence in Manchuria, written by Guo Zhentai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 | |
49007 | 49007 | 1930-03-29 | 2 | c | Some Chinese students in Paris protest against Gao Lu, Chinese ambassador to France. | France | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 | |
49008 | 49008 | 1930-03-29 | 2 | c | A call for autonomous administration in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 | |
49009 | 49009 | 1930-03-29 | 2 | d | Jiang Jieshi seals off all representative offices of Shanxi province. Plain clothes spies from Shanxi province make trouble in Shanghai. Shanxi troops on the way south. Feng Yuxiang's army preparing for war. Military manoeuvre and the war clouds in China. Yan Xishan is arrogant. Air force in the northeast China. | China | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 | |
49010 | 49010 | 1930-03-29 | 2 | f | Colour of human face can be changed, an invention in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 | |
49011 | 49011 | 1930-03-29 | 2 | f | Conscription in the northeast China. Zhang Xueliang dispatches troops to enter Shanhaiguan. | China | http://trove.nla.gov.au/newspaper/page/24099578 | 24099578 |
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]);