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 |
|---|---|---|---|---|---|---|---|---|---|
| 8548 | 8548 | 1901-09-18 | 2 | a | Imperial edicts on May 30, June 3, 4, and 6. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8549 | 8549 | 1901-09-18 | 2 | b-c | The second part of a memorial report from Xu Junshuai, governor of Fujian province, on new policies. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8550 | 8550 | 1901-09-18 | 2 | c-d | An article claims that Prince Chun's visit to Germany will benefit the reform ambition of China. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8551 | 8551 | 1901-09-18 | 2 | d | Return of the Emperor to Beijing has been rescheduled. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8552 | 8552 | 1901-09-18 | 2 | d | The route for the Emperor to return. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8553 | 8553 | 1901-09-18 | 2 | d | Rong Lu was scolded by the Empress. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8554 | 8554 | 1901-09-18 | 2 | d | A coal mine accident in Britain. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8555 | 8555 | 1901-09-18 | 2 | d | Famine in Russia. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8556 | 8556 | 1901-09-18 | 2 | d | More than 30 sheep were found dead near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8557 | 8557 | 1901-09-18 | 2 | e | The war between Britain and Transvaal and casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8558 | 8558 | 1901-09-18 | 2 | e | A French man found a way to transmit more news in a phone line and faster. | Australia | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8559 | 8559 | 1901-09-18 | 2 | e | The man who shot American President, William McKinley, has been captured. | America | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8560 | 8560 | 1901-09-18 | 2 | e | Italian government is trying to wipe out secret parties. | Other... | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8561 | 8561 | 1901-09-18 | 2 | e | Gunpowder were found smuggled into Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8562 | 8562 | 1901-09-18 | 2 | e | A man in Guangzhou is preparing for fortune of next life. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8563 | 8563 | 1901-09-18 | 2 | f | Bandits in Fangcheng county, Guangdong, headed by Liang Yunting, were arrested. Other bandits in Qinxian and Lianzhou counties are still on the run. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8564 | 8564 | 1901-09-18 | 2 | f | A rehabilitation factory was established in the north of Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8565 | 8565 | 1901-09-18 | 2 | f | The second part of a public notice, issued by Guangdong authorities, regarding new taxes on house, land and other similar properties. | China | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
| 8566 | 8566 | 1901-09-18 | 3 | a | Quit-smoking Association of Shanghai has set up a branch association in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8567 | 8567 | 1901-09-18 | 3 | a | A local court in Britain held a hearing on murder case committed by a French man. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8568 | 8568 | 1901-09-18 | 3 | a | Sydney tram on the way again after a fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8569 | 8569 | 1901-09-18 | 3 | a | A Sydney man was punished for being rude to a girl. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8570 | 8570 | 1901-09-18 | 3 | b | An American man was found swindling. | America | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8571 | 8571 | 1901-09-18 | 3 | b | Canadian government requires that all Chinese and Japanese immigrants must pass English test before being permitted to land. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8572 | 8572 | 1901-09-18 | 3 | b | Prince of Britain is now in Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8573 | 8573 | 1901-09-18 | 3 | b | Several men in Sydney were detained for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8574 | 8574 | 1901-09-18 | 3 | b | Singapore is going to issue a new regulation in order to limit the entry of Chinese. | Singapore | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8575 | 8575 | 1901-09-18 | 3 | c | Flooding in Jingxian and Qingyang counties, central Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8576 | 8576 | 1901-09-18 | 3 | c | An incident during an imperial examination in Huangzhou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8577 | 8577 | 1901-09-18 | 3 | c | Crown prince was deposed by the Empress; Prince Duan and Dong Fuxiang and their army; Lu Chuanlin in the court; Li Hongzhang and peace negotiations. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8578 | 8578 | 1901-09-18 | 3 | d | Li Hongzhang and Prince Qing notified foreign missions in Beijing that no fortifications should be built in their embassies. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8579 | 8579 | 1901-09-18 | 3 | d | Chinese businessmen in Seoul had clashes with Korean soldiers and the two governments are now in negotiation for solution. | Japan | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8580 | 8580 | 1901-09-18 | 3 | d | Prince Chun arrived in Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8581 | 8581 | 1901-09-18 | 3 | d | Changes to imperial examination in some provinces. | China | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8582 | 8582 | 1901-09-18 | 3 | d | Rabbit hunting in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8583 | 8583 | 1901-09-18 | 3 | e | President of the United States of America, William McKinley, passed away. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8584 | 8584 | 1901-09-18 | 3 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
| 8585 | 8585 | 1901-09-18 | 3 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 |
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]);