This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18780 | 18780 | 1908-01-18 | 2 | b-c | Facts about Xijiang River in west Guangdong (history, river valley, natural resources, military importance, etc.). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801612 | 26801612 | |
18786 | 18786 | 1908-01-18 | 3 | b-c | Riots in Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26801611 | 26801611 | |
18799 | 18799 | 1908-01-18 | 6 | b-c | Miscellaneous notes/ The biggest painting in the world. The deepest lake. The longest plant. The longest letter of love. The oldest love letter. The oldest money. The longest tunnel. The biggest school. The oldest code. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801616 | 26801616 | |
18817 | 18817 | 1908-01-18 | 8 | b-c | Selection of famous couplets from around China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801618 | 26801618 |
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]);