This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48550 | 48550 | 1929-10-19 | 2 | b | Jiang Jieshi and Feng Yuxiang may have a war and the analysis by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
48551 | 48551 | 1929-10-19 | 2 | c | Students of eight Beijing universities harass the Ministry of Education after failure to talking with minister Jiang Menglin. Minister of Finance Song Ziwen to issues more government bonds. Lu Zhonglin asks for payment of provisions to his Second Group Army. News on the Northwest army. Dethroned emperor Xuantong sues Chen Guangyuan. The focus of negotiations between China and Russia. Russian soldiers want rob grains from the Chinese side. Tibet troops invade Xikang and the report. Jiang Jieshi removes Yang Shuzhuang. The fall of Suifen in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
48552 | 48552 | 1929-10-19 | 2 | f | Some Russian people are anti-Communist and support the friendship with China. | Russia | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
48553 | 48553 | 1929-10-19 | 2 | f | Budget for the reorganisation of Feng Yuxiang's army. | China | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
48554 | 48554 | 1929-10-19 | 2 | f | Wu Peifu seeks to stage a comeback. | China | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
48555 | 48555 | 1929-10-19 | 2 | f | Sun Ke borrows money from America to purchase aeroplanes. | China | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 |
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]);