This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 8085 | 8085 | 1901-07-03 | 3 | a | Sydney woman penalised for drinking and attempting suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8086 | 8086 | 1901-07-03 | 3 | a | A homeless boy in Adelaide, South Australia, was sent to work for the government. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8087 | 8087 | 1901-07-03 | 3 | a | Sand storm in Indonesia. The sand was probably volcanic ash. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8088 | 8088 | 1901-07-03 | 3 | a | Some British families have several children serving in the army; gold production in South Africa decreases as a result of the Boer war. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8091 | 8091 | 1901-07-03 | 3 | c | Zhang Zhidong's comments on the Empress during his meeting with British consul general in Hankou. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8092 | 8092 | 1901-07-03 | 3 | c | Prince of Britain and his wife have left New Zealand for Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8093 | 8093 | 1901-07-03 | 3 | c | A British ship ran onto rocks, endangering the lives of those on board. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
| 8094 | 8094 | 1901-07-03 | 3 | d | Religious riots in the Philippines (Luzon). | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 |
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]);