This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54447 | 54447 | 1934-08-25 | 2 | b | China news/ Drought in north China. Shi Yousan seeks to stage a comeback. Gu Weijun on the international affairs. Russia and Japan may have confrontation. Japanese conspiracy in north China. Authority on the railway from Beijing to Shenyang. Ancient graves found in the east of Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54453 | 54453 | 1934-08-25 | 3 | b | New Japanese foreign minister and his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 |
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]);