This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 5805 | 5805 | 1900-08-08 | 2 | d | A report on the capture of Dagu fortifications near Tianjin. | Africa | http://trove.nla.gov.au/newspaper/page/24102900 | 24102900 | |
| 18963 | 18963 | 1908-02-29 | 6 | b-c | Correspondence from South Africa. Chinese servant Zhou Guihe hangs himself in protest against the discrimination registration requirement for Asian immigrants. | Africa | http://trove.nla.gov.au/newspaper/page/26801650 | 26801650 | |
| 28421 | 28421 | 1914-01-17 | 3 | b | Labour movement in Johannesburg, South Africa. | Africa | http://trove.nla.gov.au/newspaper/page/24092960 | 24092960 | |
| 36888 | 36888 | 1921-04-23 | 3 | c | South African government to reduce administrative expenditure. | Africa | http://trove.nla.gov.au/newspaper/page/24093516 | 24093516 | |
| 38410 | 38410 | 1922-03-11 | 6 | c | Hurricane in east Africa. | Africa | http://trove.nla.gov.au/newspaper/page/24093900 | 24093900 | |
| 38439 | 38439 | 1922-03-18 | 3 | e | Strike in South Africa and the chaos followed. | Africa | http://trove.nla.gov.au/newspaper/page/24093903 | 24093903 | |
| 38473 | 38473 | 1922-03-25 | 3 | e | Strike in South Africa ends. | Africa | http://trove.nla.gov.au/newspaper/page/24093911 | 24093911 | |
| 42109 | 42109 | 1924-09-20 | 7 | b | South African authority detains large amount of weapons smuggled from Germany to China. | Africa | http://trove.nla.gov.au/newspaper/page/24100868 | 24100868 | |
| 50428 | 50428 | 1931-06-20 | 8 | b | Wu Chaoshu resigns as Chinese ambassador to America. | Africa | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 53132 | 53132 | 1933-07-29 | 6 | a | Bush fire in Morocco. | Africa | http://trove.nla.gov.au/newspaper/page/24091314 | 24091314 | |
| 55951 | 55951 | 1936-04-04 | 8 | d | The war in east Africa. | Africa | http://trove.nla.gov.au/newspaper/page/24096806 | 24096806 |
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]);