This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
49040 | 49040 | 1930-04-05 | 8 | c | British foreign secretary reports the Chinese situations. | Britain | http://trove.nla.gov.au/newspaper/page/24099591 | 24099591 | |
49041 | 49041 | 1930-04-05 | 8 | c | Jiang Jieshi's troops are ready to fight Yan Xishan and Feng Yuxiang. Jiang Jieshi tries to buy over Zhang Xueliang. The Nanjing government and its new policy to deal with financial crisis. | China | http://trove.nla.gov.au/newspaper/page/24099591 | 24099591 |
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]);