This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18019 | 18019 | 1907-08-31 | 3 | b | British navy to build the biggest shipyard in Portsmouth. | Britain | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18020 | 18020 | 1907-08-31 | 3 | b | Attempt to assassinate King of Portugal and the prime minister in Lisbon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18021 | 18021 | 1907-08-31 | 3 | b | Russia purchases warship from Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18022 | 18022 | 1907-08-31 | 3 | b | South African authority requests British government to send gunboats there to protect white men. Transvaal governor seeks to reduce the unemployment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18023 | 18023 | 1907-08-31 | 3 | b | Casualty statistics in South African mines (death of Chinese and local residents). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18024 | 18024 | 1907-08-31 | 3 | b | More than 38,000 political offenders were banished to Siberia by the Russian authority in Warsaw, Poland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18025 | 18025 | 1907-08-31 | 3 | b | New York has a new law for divorce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18026 | 18026 | 1907-08-31 | 3 | c | Report from Africa. New South Wales commercial representative, on return, talks recent situations in South Africa (area of British colony, gold production, influence of the Boer War or Anglo-boer War (Oct. 11, 1899-May 31, 1902), Chinese labourer in the South Africa, export statistics of Transvaal). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18027 | 18027 | 1907-08-31 | 3 | c-d | Survey on Hong Kong. Survey and report on real estate, births and deaths of foreigners and Chinese residents in 1906, cargo liner, boat people, foreigners and their original countries, epidemics and the casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18028 | 18028 | 1907-08-31 | 3 | d | Correspondence from Singapore. A report prepared by Chinese consul in Singapore Sun Shiding on its territory, history, resident, Chinese immigrant, business activities, taxation system, import and export, mining resources, Chinese community and Chines school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 | |
18029 | 18029 | 1907-08-31 | 3 | d | Statistics of China's opium importing (from India). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801451 | 26801451 |
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]);