This data as json, CSV (advanced)
Suggested facets: column
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 11076 | 11076 | 1902-10-11 | 3 | a | An old man of Murray River, New South Wales, was penalised for burying his dog alive. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11079 | 11079 | 1902-10-11 | 3 | b | A fruit peddler in Sydney was shot and injured by Chinese. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11080 | 11080 | 1902-10-11 | 3 | b | A Chinese man, Liu De, was murdered in Melbourne. The case is under investigation. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11081 | 11081 | 1902-10-11 | 3 | b | A man in Sydney was brought to trial for allegedly murdering Chinese businessman Mei Guangda. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11082 | 11082 | 1902-10-11 | 3 | b | A man in Yanderra, New South Wales, was shot and injured by a hunter. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11083 | 11083 | 1902-10-11 | 3 | c | A Chinese businessman, Mr Tan, of Perth, was charged with selling stolen cigarettes. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11084 | 11084 | 1902-10-11 | 3 | c | Liu De, a Chinese gardener in Melbourne, was murdered and the case is on trial. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11085 | 11085 | 1902-10-11 | 3 | c | A lake in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 | |
| 11086 | 11086 | 1902-10-11 | 3 | c | A young Chinese sues a White woman for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100511 | 24100511 |
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]);