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]);