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 |
---|---|---|---|---|---|---|---|---|---|
119 | 119 | 1898-07-09 | 3 | f | Six men in Victoria find huge quantities of gold. | http://trove.nla.gov.au/newspaper/page/24102056 | 24102056 | ||
120 | 120 | 1898-07-09 | 3 | f | Parliamentary Speaker of New Zealand invited Queen to visit but was politely refused. | http://trove.nla.gov.au/newspaper/page/24102056 | 24102056 | ||
121 | 121 | 1898-07-09 | 3 | f | Pig in Guangzhou gives birth to strange animal like elephant. | http://trove.nla.gov.au/newspaper/page/24102056 | 24102056 | ||
136 | 136 | 1898-07-09 | 2 | f | Yang Guancai, a philanthropist, in Chinese community. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
137 | 137 | 1898-07-09 | 2 | f | French soldiers in gunboat near Guangzhou whip Chinese for allegedly failing to deliver goods. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 | ||
138 | 138 | 1898-07-09 | 2 | f | Several Chinese sentenced for six months imprisonment crossing WA, QLD border. | http://trove.nla.gov.au/newspaper/page/24102055 | 24102055 |
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]);