This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
81 | 81 | 1898-07-06 | 3 | f | A rich man in Adelaide donates money to hospital in will. | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
82 | 82 | 1898-07-06 | 3 | f | magic knife found in Henan province. | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
92 | 92 | 1898-07-06 | 2 | f | A boy in Guangzhou found to be genius. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
93 | 93 | 1898-07-06 | 2 | f | Fire in Guangzhou destroys 40 shops. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
108 | 108 | 1898-07-06 | 4 | f | Chinese return home by Nippon ocean liner. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 |
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]);