This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5704 | 5704 | 1900-07-18 | 3 | a | Clashes between Boxers and Chinese government forces. | Other... | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5705 | 5705 | 1900-07-18 | 3 | a | Patriotic people from 14 provinces send a petition to British, American and Japanese governments asking for their help not to carve up China, and helping the Emperor return to power. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5706 | 5706 | 1900-07-18 | 3 | a | A letter sent to Li Hongzhang by gentry and merchants in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5707 | 5707 | 1900-07-18 | 3 | a | Kang Youwei and his personality. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5708 | 5708 | 1900-07-18 | 3 | b | Two Chinese were killed in the Philippines for trying to escape inspection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5709 | 5709 | 1900-07-18 | 3 | b | Ministries in Beijing considering reviewing their old regulations. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5710 | 5710 | 1900-07-18 | 3 | b | Li Jinbang and Sun Wen (alias Sun Yatsen), of Gaomi county, Shandong province, led local residents in dismantling the railway. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5711 | 5711 | 1900-07-18 | 3 | b | Germany has secured a part of Congo in Africa. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5712 | 5712 | 1900-07-18 | 3 | b | Mr Huang, a returnee from Australia, has found gold in Xingning county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5713 | 5713 | 1900-07-18 | 3 | b | Liu Yuanting, commander of the Fu army, inspected the coastline after suppressing bandits in Guangning county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5714 | 5714 | 1900-07-18 | 3 | b | Zhang Zhidong, Governor of Hubei and Hunan provinces, ordered to translate and publish foreign military books. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5715 | 5715 | 1900-07-18 | 3 | c | The price of tea in Sydney is increasing. | Australia | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5716 | 5716 | 1900-07-18 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 | |
5717 | 5717 | 1900-07-18 | 3 | c | Arrivals and departures of liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102877 | 24102877 |
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]);