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 |
|---|---|---|---|---|---|---|---|---|---|
| 10839 | 10839 | 1902-06-14 | 2 | a | Imperial edicts on March 16 and 20. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10840 | 10840 | 1902-06-14 | 2 | a-b | Full contents of the Manchuria treaty between China and Russia. | Japan | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10841 | 10841 | 1902-06-14 | 2 | b-c | Travel notes on Manchuria, written by a British writer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10842 | 10842 | 1902-06-14 | 2 | c | Rong Lu talks with Japanese ambassador to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10843 | 10843 | 1902-06-14 | 2 | c | Daily necessities are in short supply on Beijing market; Yuan Shikai reports on the aftermath of the Boxer rebellion in Zhili province; telephone lines to be set up in Beijing; Chinese delegation to Britain for the crowning ceremony. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10844 | 10844 | 1902-06-14 | 2 | d | Several lamas were murdered near Beijing during the Boxer chaos. The case is now being investigated. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10845 | 10845 | 1902-06-14 | 2 | d | Some conservative officials are still very powerful. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10846 | 10846 | 1902-06-14 | 2 | d | Whereabouts of Prince Duan and Dong Fuxiang. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10847 | 10847 | 1902-06-14 | 2 | d | Wucheng school opened in Beijing but no visitors allowed; fights in Hubei school between students of different backgrounds; an army school in Hangzhou, Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10848 | 10848 | 1902-06-14 | 2 | e | Building of a railway in Manchuria to be completed soon. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10849 | 10849 | 1902-06-14 | 2 | e | Germany will not withdraw their troops from China but move them from Tianjin to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10850 | 10850 | 1902-06-14 | 2 | e | Traitors in Mongolia who colluded with Russian. | Japan | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10851 | 10851 | 1902-06-14 | 2 | e | A school in Suzhou, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10852 | 10852 | 1902-06-14 | 2 | e | Chinese ambassador Cai Jun in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10853 | 10853 | 1902-06-14 | 2 | e | Chinese ambassador to Washington, Wu Tingfang, resigns in protest of American immigration discrimination policy. | America | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10854 | 10854 | 1902-06-14 | 2 | e | Government of New South Wales offers rewards for clues in two cases. | Australia | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10855 | 10855 | 1902-06-14 | 2 | f | A Chinese carpenter's shop on George Street, Sydney, was destroyed in a fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10856 | 10856 | 1902-06-14 | 2 | f | A cook on a British liner committed suicide in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10857 | 10857 | 1902-06-14 | 2 | f | The war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10858 | 10858 | 1902-06-14 | 2 | f | Prayers of thanks offered for the truce between Britain and Transvaal; the end of the Boer War. | Other... | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
| 10859 | 10859 | 1902-06-14 | 3 | a | More reports on the volcano eruption in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10860 | 10860 | 1902-06-14 | 3 | a | Two state ministers in Italy are fighting. | Australia | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10861 | 10861 | 1902-06-14 | 3 | a-b | Popular party in south China, their anti-Manchurian slogans and the possibility of riots. | America | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10862 | 10862 | 1902-06-14 | 3 | b | The China-Russia treaty stipulates number of Chinese troops in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10863 | 10863 | 1902-06-14 | 3 | b | Railway building from Pingxiang to Liling. | China | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10864 | 10864 | 1902-06-14 | 3 | b | Hubei draws lottery publicly. The lottery will raise money for the government. | China | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10865 | 10865 | 1902-06-14 | 3 | b | Officials in Beijing claim that modern education forgets the teaching of Confucianism. | China | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10866 | 10866 | 1902-06-14 | 3 | c | Security arrangements for Emperor Guangxu. | China | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10867 | 10867 | 1902-06-14 | 3 | c-d | A Sydney man committed suicide; a robbery in Sydney; a couple in Sydney died on the same day. | Australia | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10868 | 10868 | 1902-06-14 | 3 | d | A lawsuit in Sydney between Chinese gardener, Mo Chong, and a Chinese shop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10869 | 10869 | 1902-06-14 | 3 | d | A fighting in the French president's palace; agreement between China and Britain over the inland navigation in Guangdong. | Britain | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10870 | 10870 | 1902-06-14 | 3 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10871 | 10871 | 1902-06-14 | 3 | e | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10872 | 10872 | 1902-06-14 | 3 | e | Five Chinese return home with gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
| 10873 | 10873 | 1902-06-14 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 |
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]);