This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18421 | 18421 | 1907-11-09 | 3 | b | A woman in St Petersburg kills a prison officer. | Britain | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18422 | 18422 | 1907-11-09 | 3 | b | Report on the election in the Russian parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18423 | 18423 | 1907-11-09 | 3 | b | Canada starts soon to talk with Italy and Germany on trade issues. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18424 | 18424 | 1907-11-09 | 3 | b | China purchases copper from the United States. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18425 | 18425 | 1907-11-09 | 3 | b | Russian soldiers in Hunchun start rebel against their government. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18426 | 18426 | 1907-11-09 | 3 | b | Earthquake in central Asia. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18427 | 18427 | 1907-11-09 | 3 | b | Flooding in north Italy. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18428 | 18428 | 1907-11-09 | 3 | b | Emperor of Germany is ill and cannot visit Britain at the moment. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18429 | 18429 | 1907-11-09 | 3 | b | American fleet on the way to the Pacific region. | Australia | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18430 | 18430 | 1907-11-09 | 3 | b | Norway gains independence following the agreement between Britain, France, Germany and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18431 | 18431 | 1907-11-09 | 3 | b | More than 2,000 Chinese labourers are returning from South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801531 | 26801531 | |
18436 | 18436 | 1907-11-09 | 6 | b | Duan Fang is advised to help Chinese entrepreneur going to the international fair that to be held in Tokyo in 1912. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801536 | 26801536 | |
18448 | 18448 | 1907-11-09 | 7 | b | Melbourne Chinese fight each other in Chinatown over the disputes on the lawyers' defending speech in the Commonwealth House of Representatives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801535 | 26801535 | |
18449 | 18449 | 1907-11-09 | 7 | b | Advertisement for gun shop Ageuts Dalgety & Co Ltd in Bent Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801535 | 26801535 | |
18450 | 18450 | 1907-11-09 | 7 | b | Advertisement for Carter the Magician in Palace Theatre in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801535 | 26801535 | |
18451 | 18451 | 1907-11-09 | 7 | b | Advertisement for A Life's Revenge in Criterion Theatre. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801535 | 26801535 | |
18452 | 18452 | 1907-11-09 | 7 | b | Advertisement for The White Rose Refreshment Room in Wonderland City and The White Rose Confectionery on the corner of Pitt & King streets and at all the leading theatres in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801535 | 26801535 |
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]);