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 |
|---|---|---|---|---|---|---|---|---|---|
| 8554 | 8554 | 1901-09-18 | 2 | d | A coal mine accident in Britain. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8555 | 8555 | 1901-09-18 | 2 | d | Famine in Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8556 | 8556 | 1901-09-18 | 2 | d | More than 30 sheep were found dead near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8558 | 8558 | 1901-09-18 | 2 | e | A French man found a way to transmit more news in a phone line and faster. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8567 | 8567 | 1901-09-18 | 3 | a | A local court in Britain held a hearing on murder case committed by a French man. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8568 | 8568 | 1901-09-18 | 3 | a | Sydney tram on the way again after a fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8569 | 8569 | 1901-09-18 | 3 | a | A Sydney man was punished for being rude to a girl. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8571 | 8571 | 1901-09-18 | 3 | b | Canadian government requires that all Chinese and Japanese immigrants must pass English test before being permitted to land. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8572 | 8572 | 1901-09-18 | 3 | b | Prince of Britain is now in Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8573 | 8573 | 1901-09-18 | 3 | b | Several men in Sydney were detained for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8582 | 8582 | 1901-09-18 | 3 | d | Rabbit hunting in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8583 | 8583 | 1901-09-18 | 3 | e | President of the United States of America, William McKinley, passed away. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 |
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]);