This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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]);