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 |
---|---|---|---|---|---|---|---|---|---|
16741 | 16741 | 1907-01-12 | 3 | d | American businessman, alias "King of Railway", dies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801190 | 26801190 | |
16742 | 16742 | 1907-01-12 | 3 | d | French authority drives gamblers out of Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801190 | 26801190 | |
16743 | 16743 | 1907-01-12 | 3 | d | Miscellaneous report. Population of different continents: Asia, Europe, Africa, North America, South America, and Australasia. Population increase in the United States in the past 100 years. Population percentage of different races. Different religious groups in the world and their followers. European languages and number of the speakers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801190 | 26801190 | |
16752 | 16752 | 1907-01-12 | 6 | d | Sydney market report: price list for fruits, vegetables, local products, meat and groceries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801195 | 26801195 |
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]);