This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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]);