This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11045 | 11045 | 1902-10-04 | 2 | a | Attempted assassination of the Tsar of Russia; casualties of a fire in Russia; aftermath of the Boer war. | Other... | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11046 | 11046 | 1902-10-04 | 2 | a | Bandits in Sichuan province have retreated. | China | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11047 | 11047 | 1902-10-04 | 2 | a | Further report on rebels in Venezuela. | Britain | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11048 | 11048 | 1902-10-04 | 2 | a | Twenty-five Japanese teachers work in the schools of Zhili province. More are coming. | China | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11049 | 11049 | 1902-10-04 | 2 | a | Russia and issues surrounding the railway in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11050 | 11050 | 1902-10-04 | 2 | a | Earthquake in central Asia. | Australia | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11051 | 11051 | 1902-10-04 | 2 | a | A Chinese gardener in Townsville, Queensland, died recently of epidemic disease; a White man was brought to court in North Sydney for beating Chinese Ya Guang; a Chinese in Perth, Western Australia, was punished for buying and selling stolen goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11052 | 11052 | 1902-10-04 | 2 | b | The Dandenong woman of Melbourne has been sentenced to death for murdering her husband. | Australia | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 | |
11053 | 11053 | 1902-10-04 | 2 | b | General Ma fell in a battle with bandits in Guangxi province, China. | China | http://trove.nla.gov.au/newspaper/page/24100504 | 24100504 |
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]);