This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18915 | 18915 | 1908-02-22 | 3 | d | Miscellaneous notes/ Submarine cable in the world. Stamps of the world. Female member of secret society in Russia. Newspaper in the world and its history. Jewish people and their distribution around the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801637 | 26801637 | |
18916 | 18916 | 1908-02-22 | 3 | d | Different love. Manchurian and Han people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801637 | 26801637 | |
18933 | 18933 | 1908-02-22 | 7 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801641 | 26801641 | |
18937 | 18937 | 1908-02-22 | 8 | d | Comments. Send a telegram. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801644 | 26801644 |
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]);