This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7733 | 7733 | 1901-05-22 | 2 | a | A report from the Board of Punishments. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7734 | 7734 | 1901-05-22 | 2 | a-b | A notice from Gu Sirong, a fourteen year old boy living in Wuhu, Anhui province, calling for relevant officials to refuse to sign the treaty with Russia. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7735 | 7735 | 1901-05-22 | 2 | b-c | A letter from Tao Mo, governor of Guangdong and Guangxi provinces, to the Chinese consul in Singapore in regards to Qiu Shuyuan and Lin Wenqing. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7736 | 7736 | 1901-05-22 | 2 | c | People who speak a foreign language find it easy to get a job in Beijing; gamblers detained by international troops; France plans to build a railway from Shanxi to Beijing; business in Beijing were influenced by international troops. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7737 | 7737 | 1901-05-22 | 2 | c | News from Xi'an about the Empress, Emperor and the Prince. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7738 | 7738 | 1901-05-22 | 2 | c | Notice from Zeng Qi; Russian troops in Shenyang. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7739 | 7739 | 1901-05-22 | 2 | d | China and Russia are still negotiating the suggested treaty. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7740 | 7740 | 1901-05-22 | 2 | d | Russia set a deadline by which China must sign the treaty. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7741 | 7741 | 1901-05-22 | 2 | d | A man in Melbourne was charged with assaulting a woman. | Australia | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7742 | 7742 | 1901-05-22 | 2 | d | A female scientist in New York looks like a man. | America | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7743 | 7743 | 1901-05-22 | 2 | e | France assists Canada in building an ocean liner to travel between the two countries. | Canada | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7744 | 7744 | 1901-05-22 | 2 | e | Korean purchased weapons from Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7745 | 7745 | 1901-05-22 | 2 | e | Amount of compensation demanded by foreign governments, and responses of the Chinese government; British and Australian soldiers in China; Liu Yi's army and Boxers clash in the south of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7746 | 7746 | 1901-05-22 | 2 | e | Why Yuan Chang and Xu Jingcheng were executed. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7747 | 7747 | 1901-05-22 | 2 | f | British navy to build new gunboats. | Britain | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7748 | 7748 | 1901-05-22 | 2 | f | American President tours the country; a newspaper in New York was ordered to pay compensation for defamation. | America | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7749 | 7749 | 1901-05-22 | 2 | f | Summer Palace has been changed since the arrival of international troops. | China | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7750 | 7750 | 1901-05-22 | 2 | f | Huang Fucheng and Li Ai'sheng, both from Fujian province, cultivate wasteland with hundreds of peasants coming from Fujian, China. Deng Gongshu and Zheng Zaoshang, both from Guangdong, are keen to follow. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 |
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]);