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 |
---|---|---|---|---|---|---|---|---|---|
3268 | 3268 | 1899-08-09 | 3 | a | Chinese church in Melbourne organises a big party to celebrate its 27th anniversary. | http://trove.nla.gov.au/newspaper/page/24102492 | 24102492 | ||
3269 | 3269 | 1899-08-09 | 3 | a | A scientist from the USA discovers a hard gas. | http://trove.nla.gov.au/newspaper/page/24102492 | 24102492 | ||
3270 | 3270 | 1899-08-09 | 3 | a | Collins Street of Melbourne is a very busy street. | http://trove.nla.gov.au/newspaper/page/24102492 | 24102492 | ||
3278 | 3278 | 1899-08-09 | 4 | a | Several Chinese in New Castle detained for gambling. | http://trove.nla.gov.au/newspaper/page/24102495 | 24102495 | ||
3279 | 3279 | 1899-08-09 | 4 | a | Sugar exports from Queensland. | http://trove.nla.gov.au/newspaper/page/24102495 | 24102495 | ||
3280 | 3280 | 1899-08-09 | 4 | a | Two bank branches close in Canada. | http://trove.nla.gov.au/newspaper/page/24102495 | 24102495 |
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]);