This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5393 | 5393 | 1900-06-02 | 3 | a | A Chinese attacked other passengers in a boat with a sharp knife and injured many. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 | |
5394 | 5394 | 1900-06-02 | 3 | a | London raises money for martyrs' families. | Britain | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 | |
5395 | 5395 | 1900-06-02 | 3 | a | Epidemics in Cairo, Egypt. | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 | ||
5396 | 5396 | 1900-06-02 | 3 | a | Melbourne authority offers reward for paintings for Flinders Street Station. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 | |
5397 | 5397 | 1900-06-02 | 3 | a | Reports on the war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 | |
5398 | 5398 | 1900-06-02 | 3 | a | Japan places torpedoes in all of their ports; American military attache in Beijing moves to Tokyo in preparation for the possible Russia-Japan conflicts; Boxers are looting near Beijing; Japanese navy lands in Tianjin; Boxers destroy railway and factories near Beijing; foreign missionaries and engineers attacked by Boxers. | China | http://trove.nla.gov.au/newspaper/page/24102823 | 24102823 |
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]);