This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54794 | 54794 | 1935-01-19 | 2 | b | Editorial on the victory of suppression of communists in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 | |
54795 | 54795 | 1935-01-19 | 2 | c | China news/ The communist troops and their atrocities in south China. Japanese still seek to occupy the whole north China. News on the Fifth Plenary Session in Nanjing. Remains of the communist troops flee Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 |
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]);