This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 8946 | 8946 | 1901-10-30 | 2 | e | A husband in Sydney commits suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100213 | 24100213 | |
| 8947 | 8947 | 1901-10-30 | 2 | f | A ship from New Zealand to Sydney did not arrive until many days later. | Australia | http://trove.nla.gov.au/newspaper/page/24100213 | 24100213 | |
| 8949 | 8949 | 1901-10-30 | 3 | a | Two employees from the Bank of New South Wales are rewarded for beating robbers. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8951 | 8951 | 1901-10-30 | 3 | b | A suspect was detained in Queanbeyan, New South Wales, for rape. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8953 | 8953 | 1901-10-30 | 3 | b | Two drunken men were stolen on Melbourne street. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8956 | 8956 | 1901-10-30 | 3 | c | A wife in Sydney pardoned her husband. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8957 | 8957 | 1901-10-30 | 3 | c | Governor of New South Wales tries to help a poor woman and her child. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8958 | 8958 | 1901-10-30 | 3 | c | Fire in Victoria and New South Wales claims lives. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8959 | 8959 | 1901-10-30 | 3 | d | Sydney experienced hail fall recently. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8960 | 8960 | 1901-10-30 | 3 | d | Parliament of New South Wales questions the validity of a newspaper report. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 | |
| 8965 | 8965 | 1901-10-30 | 3 | e | The man who stole a mansion in Britain has been arrested. | Australia | http://trove.nla.gov.au/newspaper/page/24100212 | 24100212 |
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]);