This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49023 | 49023 | 1930-04-05 | 2 | b | Third 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/24099586 | 24099586 | |
49024 | 49024 | 1930-04-05 | 2 | c | Correspondence between Jiang Jieshi and Yan Xishan on the national affairs. | China | http://trove.nla.gov.au/newspaper/page/24099586 | 24099586 | |
49025 | 49025 | 1930-04-05 | 2 | d | A circular telegram issued by Yan Xishan, Feng Yuxiang, Li Zongren, Huang Shaoxiong, Zhang Fakui and others to condemn the Nanjing government under Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099586 | 24099586 | |
49026 | 49026 | 1930-04-05 | 2 | e | Jiang Jieshi's final advice to Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24099586 | 24099586 | |
49027 | 49027 | 1930-04-05 | 2 | e | Wan Zinan of the zhi gong tang in Jinmen island writes to Yan Xishan. Jiang Jieshi orders Song Ziwen to raise more funds. Japanese troops in Manchuria. Ministry of Industry and Commerce and their plan to borrow loans. | China | http://trove.nla.gov.au/newspaper/page/24099586 | 24099586 | |
49028 | 49028 | 1930-04-05 | 2 | f | Shanxi army guard in Dagu Fortification. Liu Zhennian is moving. Yan Xishan in Shanxi formally declares war with Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099586 | 24099586 |
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]);