This data as json, CSV (advanced)
Suggested facets: date, column, title, source, page_url, trove_id
date (date) 2 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22403 | 22403 | 1910-02-12 | 34 | a | Photograph of Emperor Xuantong, his father and brother. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802526 | 26802526 | |
22404 | 22404 | 1910-02-12 | 34 | a | American expert predicts that China would have more trouble if borrowing foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/26802526 | 26802526 | |
24287 | 24287 | 1911-02-04 | 34 | a-b | Hobbies of kings in various countries | It tells about the hobbies of kings in various countries such as Britain and Italy. | Other... | http://trove.nla.gov.au/newspaper/page/24091655 | 24091655 |
24288 | 24288 | 1911-02-04 | 34 | a | Photograph of a mine well | Phtograph of a mine well in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24091655 | 24091655 |
24289 | 24289 | 1911-02-04 | 34 | b | Postpone of the Imperial examination ceremony | Due to the need for preparation, it was suggested the imperial examination was postponed. | China | http://trove.nla.gov.au/newspaper/page/24091655 | 24091655 |
24290 | 24290 | 1911-02-04 | 34 | b | Proposal of establishing more diplomatic relations with other countries | A proposal was put forward for establishing more diplomatic relations with other countries. | Other... | http://trove.nla.gov.au/newspaper/page/24091655 | 24091655 |
24291 | 24291 | 1911-02-04 | 34 | b | Publication of the Gesushi (nnn) newspaper | The publication of the Gesushi (nnn) newspaper in Hungary. | Other... | http://trove.nla.gov.au/newspaper/page/24091655 | 24091655 |
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]);