This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54848 | 54848 | 1935-02-09 | 2 | a | Editorial by Tung Wah Times on the political principles. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096319 | 24096319 | |
54849 | 54849 | 1935-02-09 | 2 | c | China news/ Government troops in Guizhou fight the communists. Japanese in Manchuria. Cotton production in Shaanxi province. Troops manoeuvre in Fujian province. Bandits and government troops fight in Xuzhou, north Jiangsu province. Expenses of the Government officials. Li Jiayu on the suppression of communists. | China | http://trove.nla.gov.au/newspaper/page/24096319 | 24096319 |
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]);