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 |
---|---|---|---|---|---|---|---|---|---|
3536 | 3536 | 1899-09-13 | 2 | e | An Adelaide woman working in post office charged with embezzlement. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3569 | 3569 | 1899-09-13 | 3 | e | The first trip of the tram on Gorge St, Sydney, has been postponed. | http://trove.nla.gov.au/newspaper/page/24102529 | 24102529 | ||
3570 | 3570 | 1899-09-13 | 3 | e | Italy demands too much of China. | http://trove.nla.gov.au/newspaper/page/24102529 | 24102529 | ||
3571 | 3571 | 1899-09-13 | 3 | e | Catholic and Anglican churches in Guangdong are in conflict. | http://trove.nla.gov.au/newspaper/page/24102529 | 24102529 | ||
3572 | 3572 | 1899-09-13 | 3 | e | Immigration regulations, Singapore is to ban the entry of Chinese. | http://trove.nla.gov.au/newspaper/page/24102529 | 24102529 |
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]);