This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50103 | 50103 | 1931-03-21 | 2 | b | First part of comments by Tung Wah Times on Japan's new policy on railway construction and management in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50104 | 50104 | 1931-03-21 | 2 | c | Debates and fighting in Japanese parliament. | Japan | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50105 | 50105 | 1931-03-21 | 2 | c | Huang Shaoxiong and Chen Jitang are both leaving Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50106 | 50106 | 1931-03-21 | 2 | d | Current situation in Guangxi and proposals for solutions. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50107 | 50107 | 1931-03-21 | 2 | d | Nanjing government to secure the loans from America. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 | |
50108 | 50108 | 1931-03-21 | 2 | e | Song Ziwen on the current situations. Loans for the construction of Longhai railway. Chen Youren still in Shanghai. Shanxi people request to sell the munitions factory. Japanese troops on exercise in Beijing. Five requests from the people in Shanxi province. Female communists in Hubei are involved in prostitution for their propaganda. Ma Xiaojun arrives Shanghai and talks on the Guangxi situation. Yan Xishan to stage a comeback. Zhang Xueliang seeks to take over the munitions factory in Shanxi. Police in Tianjin arrest communists. Wang Zhengting on the negotiations between China and Russia. Gu Weijun and Luo Wengan on the way to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090316 | 24090316 |
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]);