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 |
---|---|---|---|---|---|---|---|---|---|
50031 | 50031 | 1931-02-28 | 2 | b | First part of editorial on the American loans to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090292 | 24090292 | |
50035 | 50035 | 1931-02-28 | 3 | b | Taiyuan, capital of Shanxi province, suffers and the report. | China | http://trove.nla.gov.au/newspaper/page/24090291 | 24090291 | |
50046 | 50046 | 1931-02-28 | 8 | b | An old couple in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50047 | 50047 | 1931-02-28 | 8 | b | Explosion of a coal mine in Germany claims many lives. | Germany | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50048 | 50048 | 1931-02-28 | 8 | b | Russian troops on the border of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50049 | 50049 | 1931-02-28 | 8 | b | Prince of Britain continues his tour in South America. | South America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50050 | 50050 | 1931-02-28 | 8 | b | Famine in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50051 | 50051 | 1931-02-28 | 8 | b | More riots in Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 |
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]);