This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
472 | 472 | 1898-08-13 | 3 | a | Sugarcane growers in Queensland refuse to employ Chinese labourers except at busiest point of harvest. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
473 | 473 | 1898-08-13 | 3 | a | Young white boy caught stealing beans from Chinese garden. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
474 | 474 | 1898-08-13 | 3 | a-b | Woman in Victoria hangs herself at home. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
475 | 475 | 1898-08-13 | 3 | b-c | Stories of Mr Ghost. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
476 | 476 | 1898-08-13 | 3 | c-d | Crime, illegal gambling, Westerners found gambling on horse races. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
477 | 477 | 1898-08-13 | 3 | d | Eagle bites dog in Victoria | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
478 | 478 | 1898-08-13 | 3 | d-e | Crime, two children, aged 13 and 12, charged with burglary. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
479 | 479 | 1898-08-13 | 3 | e | Drunk man rests on streets and loses all things in his pockets. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
480 | 480 | 1898-08-13 | 3 | e | Baby boy abandoned in Waterloo. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
481 | 481 | 1898-08-13 | 3 | e-f | Court case, woman takes her former boyfriend to court. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
482 | 482 | 1898-08-13 | 3 | f | New Zealand is to place quality labels on all export meat products. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 |
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]);