This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
54797 | 54797 | 1935-01-19 | 3 | c | Japanese and the railways in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54798 | 54798 | 1935-01-19 | 3 | c | Puyi is preparing for a visit to Japan. | China | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54799 | 54799 | 1935-01-19 | 3 | c | American government on the naval forces. | America | http://trove.nla.gov.au/newspaper/page/24096294 | 24096294 | |
54802 | 54802 | 1935-01-19 | 5 | c | A breakfast of Napoleon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096296 | 24096296 |
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]);