This data as json, CSV (advanced)
Suggested facets: column
date (date) 15 ✖
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 5022 | 5022 | 1900-04-21 | 2 | f | A kind of birds in Venezuela, South America, can be used to tend sheep. | South America | http://trove.nla.gov.au/newspaper/page/24102775 | 24102775 | |
| 17645 | 17645 | 1907-06-22 | 2 | c-d | Ridiculous politics. Tianjin actress Yang Cuixi stirs Beijing officialdom. | South America | http://trove.nla.gov.au/newspaper/page/26801372 | 26801372 | |
| 21611 | 21611 | 1909-09-04 | 8 | b-c | A Chinese newspaper in Peru reports sufferings of Chinese labourers there. | South America | http://trove.nla.gov.au/newspaper/page/26802318 | 26802318 | |
| 22012 | 22012 | 1909-11-20 | 8 | a-b | A letter from Chinese merchants society in Panama to the Beijing government. | South America | http://trove.nla.gov.au/newspaper/page/26802406 | 26802406 | |
| 33602 | 33602 | 1918-09-07 | 6 | b-c | Newspapers in Peru report and comment on the yellow peril. | South America | http://trove.nla.gov.au/newspaper/page/24097424 | 24097424 | |
| 38514 | 38514 | 1922-04-01 | 7 | b | A factory worker dies at his post and his wife demands compensation. | South America | http://trove.nla.gov.au/newspaper/page/24093923 | 24093923 | |
| 49734 | 49734 | 1930-11-22 | 8 | b | Australia news/ Chinese garden robbed near Sydney. Returned servicemen in Sydney defrauded by girls. A man is penalised for illegally selling wines. Bank robbery in Sydney. Gibbs Bright Company changes line. Woman in Sydney imprisoned for theft. Butchers on strike in Sydney and the report. Sydney police stop communist demonstration. | South America | http://trove.nla.gov.au/newspaper/page/24099860 | 24099860 | |
| 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 | |
| 51603 | 51603 | 1932-06-11 | 5 | e | Zhu Songqing introduces well-known lawyer in Sydney A. W. Gardner. | South America | http://trove.nla.gov.au/newspaper/page/24090833 | 24090833 | |
| 52900 | 52900 | 1933-05-20 | 6 | e | Paraguay declares war with Bolivia. | South America | http://trove.nla.gov.au/newspaper/page/24091232 | 24091232 | |
| 52951 | 52951 | 1933-06-03 | 6 | d | The war between Colombia and Peru. | South America | http://trove.nla.gov.au/newspaper/page/24091250 | 24091250 | |
| 53815 | 53815 | 1934-01-27 | 6 | g | Sydney reintroduces old traffic regulations. | South America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
| 54274 | 54274 | 1934-06-30 | 6 | e | The war in South America. | South America | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
| 54644 | 54644 | 1934-11-03 | 5 | d | The ten most spoken languages in the world. | South America | http://trove.nla.gov.au/newspaper/page/24096217 | 24096217 | |
| 55561 | 55561 | 1935-11-02 | 8 | g | Australia news/ Funeral of the Lord Mayor of Sydney. Tariff exempted for the imported Chinese medicine. Sand storm in Broken Hill. | South America | http://trove.nla.gov.au/newspaper/page/24096634 | 24096634 |
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]);