This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47720 | 47720 | 1929-01-05 | 3 | e | Internal disputes in Manchuria. Zhang Xueliang's attitude is still unstable. Zhou Xicheng from Guizhou province sends telegram to his representative in Nanjing. Soviet Russia seeks to control Xinjiang province. Japanese conspiracy in Dalian, Fengtian province. Bandits in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 |
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]);