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 |
|---|---|---|---|---|---|---|---|---|---|
| 7491 | 7491 | 1901-04-20 | 2 | a-b | Imperial edicts on December 26. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7492 | 7492 | 1901-04-20 | 2 | c | The second and final part of an article, selected from a Shanghai newspaper, claiming that a new school is needed if China is to embark on new social policies. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7493 | 7493 | 1901-04-20 | 2 | d | Empress on the peace protocol; Li Hongzhang and the peace negotiations; Liu Kunyi and Zhang Zhidong were impeached; foreign governments demand the execution of Gang Yi; Zhang Peilun is re-appointed; proposal for the restructuring of court officialdom. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7494 | 7494 | 1901-04-20 | 2 | d | Compensation from China; Chinese officials to be punished for their collusion with Boxers; Reformer Xu Zhijing has been released. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7495 | 7495 | 1901-04-20 | 2 | d | Japanese in Beijing punish a rapist; robbery in the American-controlled area; charity institutions in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7496 | 7496 | 1901-04-20 | 2 | e | Zhang Zhidong is consulting others about a reform policy. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7497 | 7497 | 1901-04-20 | 2 | e | The officials Wang Peiyou and He Naiying have been added to the list of Chinese officials who colluded with Boxers. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7498 | 7498 | 1901-04-20 | 2 | e | A secret society has been founded in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7499 | 7499 | 1901-04-20 | 2 | e | A further report on the missionary case of Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7500 | 7500 | 1901-04-20 | 2 | e | Yu Liansan is keen to return to the old system. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7501 | 7501 | 1901-04-20 | 2 | e | Anhui province is going to train government troops by using foreign drilling methods. | China | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7502 | 7502 | 1901-04-20 | 2 | e | Zhang Zhidong trains his troops with foreign methods; Liu Kunyi receives a letter from British government; Russia demands more compensation from China. | Other... | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7503 | 7503 | 1901-04-20 | 2 | f | A Chinese in Sydney was poisoned to death by opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7504 | 7504 | 1901-04-20 | 2 | f | Gold that was lost on board of a liner from Weber Lohmann & Co has been recovered. | Australia | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7505 | 7505 | 1901-04-20 | 2 | f | The third and final part of stories about an upstart in Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100012 | 24100012 | |
| 7506 | 7506 | 1901-04-20 | 3 | a | A welcome ceremony is being prepared in Singapore for the visit of a British prince. | Singapore | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7507 | 7507 | 1901-04-20 | 3 | a | Amount of compensation demanded by foreign governments. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7508 | 7508 | 1901-04-20 | 3 | a | Russian foreign minister has been promoted for his contributions to the nation. | Russia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7509 | 7509 | 1901-04-20 | 3 | b | Zhao Shuqiao, a minister, asks for a long period of leave from the court in order to avoid a power struggle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7510 | 7510 | 1901-04-20 | 3 | b | New governor of Guangdong, Tao Mo, starts his rearrangement plan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7511 | 7511 | 1901-04-20 | 3 | b | A big fire in Zhaoqing and donations to the victims. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7512 | 7512 | 1901-04-20 | 3 | b | A complicated case in Panyu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7513 | 7513 | 1901-04-20 | 3 | b | A gambling house in Guangzhou, the difficulties surrounding it. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7514 | 7514 | 1901-04-20 | 3 | c | Japan urges China to sent troops to Manchuria; Liu Kunyi and Li Hongzhang talk to British diplomats; cabinet prepares to move to Xiangyang of Hubei province; people who murdered a German soldier have been captured. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7515 | 7515 | 1901-04-20 | 3 | c | A report on Gang Yi's son. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7516 | 7516 | 1901-04-20 | 3 | c | Gentry in Shanghai hold a meeting to debate the pros and cons of China's treaty with Russia. Attendants include Wang Yunzhong, Wang Zhiqing, Wen Qinfu, Jiang Zhiyou, and hundreds of others. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7517 | 7517 | 1901-04-20 | 3 | d | Chong Wenshan and his whole family committed suicide after the entry of international troops into Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7518 | 7518 | 1901-04-20 | 3 | d | International troops in Beijing provided Zhao Shuqiao's crime. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7519 | 7519 | 1901-04-20 | 3 | d | A court hearing in Tamarama, Sydney, on a rape case. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7520 | 7520 | 1901-04-20 | 3 | d | A man in Sydney was sentenced to prison for rudeness. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7521 | 7521 | 1901-04-20 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
| 7522 | 7522 | 1901-04-20 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 |
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]);