This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50059 | 50059 | 1931-03-07 | 2 | f | Bandits in Shanghai and the kidnap. Li Jishen refuses to talk about current situations. Jiang Jieshi, Huang Shaoxiong, Chen Jitang and others discuss solutions to the Guangxi situations. Reorganisation of Shanxi army. Zhang Xueliang and his methods to reorganise Shanxi army. | China | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 |
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]);