This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, 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 | |
11054 | 11054 | 1902-10-04 | 3 | a | A judge ordered Chinese businessman Zheng Dingchen to leave Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100505 | 24100505 | |
11055 | 11055 | 1902-10-04 | 3 | a | A court trial in Glen Innes, Queensland, on fighting between a man and his girlfriend. | Australia | http://trove.nla.gov.au/newspaper/page/24100505 | 24100505 | |
11056 | 11056 | 1902-10-04 | 3 | a | A further report on the earthquake in central Asia. | Australia | http://trove.nla.gov.au/newspaper/page/24100505 | 24100505 | |
11057 | 11057 | 1902-10-04 | 3 | a | Japan encourages China and Korea to visit the international fair in Osaka, Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100505 | 24100505 | |
11058 | 11058 | 1902-10-04 | 5-6 | a-b | A further report on how Cai Jun, Chinese ambassador to Japan, helps Japanese police arrest Chinese students in his embassy. | Japan | http://trove.nla.gov.au/newspaper/page/24100503 | 24100503 | |
11059 | 11059 | 1902-10-04 | 6 | b-c | The Chinese Empire Reform Association in Sydney held a celebration on the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100506 | 24100506 | |
11060 | 11060 | 1902-10-04 | 6 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100506 | 24100506 | |
11061 | 11061 | 1902-10-04 | 6 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100506 | 24100506 | |
11062 | 11062 | 1902-10-04 | 6 | c | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100506 | 24100506 |
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]);