This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50924 | 50924 | 1931-12-05 | 2 | e | Yan Xishan requests civil administration. Talks by Hu Hanmin. Zhang Xueliang is optimistic over the Chinese affairs. Loss of railways in Manchuria. Japanese troops in Shenyang set fire on radio station. Du Xuantai is arrested. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 |
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]);