This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
378 | 378 | 1898-08-03 | 2 | a | Bismarck, who united Germany and led Germany's deafeat of France, is ill. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
379 | 379 | 1898-08-03 | 2 | a-b | Chinese man, living in Sydney, helped Western girl but caused unexpected disaster. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
380 | 380 | 1898-08-03 | 2 | b | Melbourne man loses five of his family members within few days. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
381 | 381 | 1898-08-03 | 2 | b-c | Six mad men, one White, two Aboriginal and three Chinese, saved by ship after escaping from madhouse and fishing in sailboat. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
382 | 382 | 1898-08-03 | 2 | c | Circus tiger injures boy in Western Australia. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
383 | 383 | 1898-08-03 | 2 | c | Western Australia is to allow women to participate in politics. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
384 | 384 | 1898-08-03 | 2 | c-d | Man in Melbourne in trouble because of own actions. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
385 | 385 | 1898-08-03 | 2 | d | Britain plans to make a detailed world map. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
386 | 386 | 1898-08-03 | 2 | d | Man in London became rich selling paintings. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
387 | 387 | 1898-08-03 | 2 | d-e | War, Philippines, USA. More news on American clashes in Luzon | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
388 | 388 | 1898-08-03 | 2 | e | Skilled thief operating in Sydney. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
389 | 389 | 1898-08-03 | 2 | e-f | Court case, Sydney. Cart driver guilty of injuring boy passenger who got in his way. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
390 | 390 | 1898-08-03 | 2 | f | New born baby waiting to be claimed in Sydney. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 | ||
391 | 391 | 1898-08-03 | 2 | f | Woman thief in Sydney. | http://trove.nla.gov.au/newspaper/page/24102083 | 24102083 |
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]);