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 |
|---|---|---|---|---|---|---|---|---|---|
| 7664 | 7664 | 1901-05-15 | 2 | a-b | Imperial edicts on January 25 and 12. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7665 | 7665 | 1901-05-15 | 2 | b-c | A public letter prepared by gentry in Shanghai to governors of Jiangsu, Hubei, Guangdong, and Shandong provinces. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7666 | 7666 | 1901-05-15 | 2 | c-d | Yuan Shikai wrote to Liu Kunyi; Sun Jialai is on leave; Zhang Zhidong wants to resign; Yu Yinlin in court; Zeng Qi signs an agreement with Russia; China sent representative to Japan to apologise; Yan Xiu was arrested. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7667 | 7667 | 1901-05-15 | 2 | d | A report on the international troops in China. | Britain | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7668 | 7668 | 1901-05-15 | 2 | d | Sydney will penalise those who spit on the sidewalk. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7669 | 7669 | 1901-05-15 | 2 | d | A young man in Sydney was punished for selling the bike he borrowed from his friend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7670 | 7670 | 1901-05-15 | 2 | d | Sun Jialai and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7671 | 7671 | 1901-05-15 | 2 | e | Female hero Xue Jinqin's speech at the rally in Purity Garden of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7672 | 7672 | 1901-05-15 | 2 | e | A boy was poisoned to death in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7673 | 7673 | 1901-05-15 | 2 | e | An old maid in Prestons, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7674 | 7674 | 1901-05-15 | 2 | e | A husband in Charters Towers, Queensland, shot and killed his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7675 | 7675 | 1901-05-15 | 2 | f | Railway workers in the Philippines are on strike. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7676 | 7676 | 1901-05-15 | 2 | f | Disputes between Germany, America and Portugal. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7677 | 7677 | 1901-05-15 | 2 | f | Emperor Guangxu is to punish officials whocolluded with the Boxers. | Australia | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7678 | 7678 | 1901-05-15 | 2 | f | Poems written by a Japanese author on the situations in China. | Japan | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7679 | 7679 | 1901-05-15 | 2 | f | Business regulations issued for Wuchang. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
| 7680 | 7680 | 1901-05-15 | 3 | a | A letter from Xi'an about situation there. | China | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7681 | 7681 | 1901-05-15 | 3 | a | Liu Ruxing, Chinese businessman in Sydney, talks with Australian soldiers who just came back from China. Australian troops in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7682 | 7682 | 1901-05-15 | 3 | b | Jing Liansan has been released from Macao and has now returned to Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7683 | 7683 | 1901-05-15 | 3 | b | Magistrate of Xiangshan rewards civil corps for their efforts in maintaining social security. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7684 | 7684 | 1901-05-15 | 3 | b | A German businessman was murdered in Goulburn, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7685 | 7685 | 1901-05-15 | 3 | b | Tsar of Russia is to visit Britain in August. | Britain | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7686 | 7686 | 1901-05-15 | 3 | c | Korean prime minister resigns after disagreements with the Emperor. | Other... | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7687 | 7687 | 1901-05-15 | 3 | c | French bank agrees to provide loans to Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7688 | 7688 | 1901-05-15 | 3 | c | Japan warns China on the peace protocol. | Japan | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7689 | 7689 | 1901-05-15 | 3 | c | German soldiers in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7690 | 7690 | 1901-05-15 | 3 | c | Clashes between Chinese and French soldiers in Vietnam. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7691 | 7691 | 1901-05-15 | 3 | c | Population of Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7692 | 7692 | 1901-05-15 | 3 | c | China is to establish a foreign ministry. | China | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7693 | 7693 | 1901-05-15 | 3 | c | Empress Dowager miscalculated the treaty with Russia; Emperor is furious over the agreement Zeng Qi signed with Russia; the Prince would be deposed; bandits in Mongolia. | Other... | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7694 | 7694 | 1901-05-15 | 3 | d | Chinese government is seeking foreign help to refuse the treaty with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7695 | 7695 | 1901-05-15 | 3 | d | Somebody purchased munitions in Yokohama and tried to send them into China. | China | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7696 | 7696 | 1901-05-15 | 3 | d | Liang Qichao is now on the way to Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7697 | 7697 | 1901-05-15 | 3 | d | A German newspaper on the Siberia railway. | China | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 | |
| 7698 | 7698 | 1901-05-15 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100038 | 24100038 |
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]);