This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50082 | 50082 | 1931-03-14 | 2 | b | Report written by Wan Boping on the steps of Soviet Union to implement communist policy in the railway management in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090308 | 24090308 | |
50083 | 50083 | 1931-03-14 | 2 | d | Fan Qiwu on the financial administration. American investment on the navigation in China. Yan Xishan's properties sealed off. Sun Baoqi dies in Shanghai. Civil aviation service between China and Germany. Jiang Jieshi to solve the Guangxi problem by force. Chen Jitang is rewarded in Nanjing. Huang Shaoxiong is detained. Peace comes to an end in Guangxi. Chaos in Sichuan. Zhang Qun declines to enter Sichuan. Reorganisation of the Shanxi army. | China | http://trove.nla.gov.au/newspaper/page/24090308 | 24090308 |
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]);