This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
241 | 241 | 1898-07-20 | 4 | a | Court case, man attempts to kill girlfriend. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
242 | 242 | 1898-07-20 | 4 | a | Guangzhou, businessman heavily in debt caught trying to escape. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
243 | 243 | 1898-07-20 | 4 | a-b | Letter from a reader in Sydney. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
244 | 244 | 1898-07-20 | 4 | b-c | American troops, local forces clash in Luzon. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
245 | 245 | 1898-07-20 | 4 | c | Geralton, WA, Chinese man goes to hospital after doctor incorrectly disagnosed his condition as leprosy. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
246 | 246 | 1898-07-20 | 4 | c-d | Abundant harvest ot lichees in both Guangdong and Fujian this year. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
247 | 247 | 1898-07-20 | 4 | d | Melbourne, two Chinese arrivals with allegedly forged documenation to be sent back to Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
248 | 248 | 1898-07-20 | 4 | d | Timetable of ocean liners arrivals in Asian ports | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
249 | 249 | 1898-07-20 | 4 | d | Price list of products in Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 | ||
250 | 250 | 1898-07-20 | 4 | e | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102065 | 24102065 |
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]);