This data as json, CSV (advanced)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 8074 | 8074 | 1901-07-03 | 2 | d | Flooding in America. | Australia | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
| 8075 | 8075 | 1901-07-03 | 2 | d | British army in Newport had an accident while undertaking military exercises. | Australia | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
| 8077 | 8077 | 1901-07-03 | 2 | d | A mad man who was trying to assassinate the Emperor of Germany has been detained. | Australia | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
| 8084 | 8084 | 1901-07-03 | 2 | f | A rotten corpse was found on the road. | Australia | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
| 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]);