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 |
|---|---|---|---|---|---|---|---|---|---|
| 6808 | 6808 | 1901-01-09 | 2 | a-b | The first part of Kang Youwei's memorial report. | China | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6809 | 6809 | 1901-01-09 | 2 | b-c | Imperial edicts | China | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6810 | 6810 | 1901-01-09 | 2 | c-d | The first part of a record, prepared by editor Zheng Lu, on the grand ceremony held to celebrate the Australian commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6811 | 6811 | 1901-01-09 | 2 | d | A man killed by a shark in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6812 | 6812 | 1901-01-09 | 2 | d | A boy was stabbed to death during a duel in Luzon. | Australia | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6813 | 6813 | 1901-01-09 | 2 | d | Report on the mausoleum of Indian kings. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6814 | 6814 | 1901-01-09 | 2 | e | German troops capture and execute the man who murdered German ambassador to China; China notifies foreign missions in Beijing of the agreement signed with Russia; many people who led Boxers to attack foreigners have been sent to Xinjiang, northwest of China; Russia leaves some troops in Manchuria; Russia broke its promise to return Manchuria to China; soldiers from New South Wales and Victoria are returning from China. | Other... | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6815 | 6815 | 1901-01-09 | 2 | e | Bandits in Xiangshan, Nanhai, Panyu and Shunde counties, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6816 | 6816 | 1901-01-09 | 2 | e | Liu Shengsan, a local scholar in Xiangshan county, was murdered, together with all his family members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6817 | 6817 | 1901-01-09 | 2 | f | A smart Chinese in America invented a new typesetting machine. | America | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6818 | 6818 | 1901-01-09 | 2-3 | f-a | The Beijing court is ruled by the Empress, with input from the ministers. | China | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
| 6819 | 6819 | 1901-01-09 | 3 | a | The ban on gambling in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6820 | 6820 | 1901-01-09 | 3 | b | The Emperor in Xi'an | China | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6821 | 6821 | 1901-01-09 | 3 | b | Report on the arrival of Emperor Guangxu in Xi'an. | China | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6822 | 6822 | 1901-01-09 | 3 | c | Three men in Britain died together of drinking beer; a British gunboat near China; a foreign soldier stole some silk from Tianjin to sell in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6823 | 6823 | 1901-01-09 | 3 | c | An Austrian astronomer studies Mars. | Other... | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6824 | 6824 | 1901-01-09 | 3 | c | Further report on the war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6825 | 6825 | 1901-01-09 | 3 | d | Hundreds of Chinese women in Zhuozhou, Zhili province, committed suicide to maintain their chastity. | China | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6826 | 6826 | 1901-01-09 | 3 | d | Timely rain in northwestern Queensland; gold exported from New Zealand; wheat transported from Melbourne to Britain; exports from Tasmania; New Zealand was impressed by Australian Commonwealth ceremony; a Queensland bank made huge profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6827 | 6827 | 1901-01-09 | 3 | d | The craftsman association in New South Wales asks the government not to purchase products from Chinese carpenters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 | |
| 6828 | 6828 | 1901-01-09 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099909 | 24099909 |
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]);