This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54750 | 54750 | 1934-12-22 | 2 | c | Jiang Jieshi's train is bombed and the report. Japanese troops invade Rehe province in north China. Financial situation is recovering in north China. Japanese plan to control the Manchuria. Wang Shuchang entertains Mongolian royalties. Police in Tangshan, Hebei province, smash the communist offices. | China | http://trove.nla.gov.au/newspaper/page/24096271 | 24096271 | |
54758 | 54758 | 1934-12-22 | 6 | c | American businessmen secure huge profit during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 |
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]);