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 |
|---|---|---|---|---|---|---|---|---|---|
| 10008 | 10008 | 1902-03-15 | 2 | a-b | Imperial edicts on December 4 | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10009 | 10009 | 1902-03-15 | 2 | b-c | A report from Yi Kuang on student selection. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10010 | 10010 | 1902-03-15 | 2 | c-d | An article, probably written by the editor, on self-respect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10011 | 10011 | 1902-03-15 | 2 | d | New and modern school in Huizhou, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10012 | 10012 | 1902-03-15 | 2 | d | A report on the modern school and their influence in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10013 | 10013 | 1902-03-15 | 2 | e | A meeting in San Francisco discussed the proposal to increasing immigration regulations and ban the entry of Chinese into the state. | America | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10014 | 10014 | 1902-03-15 | 2 | e | A report on the international troops looting in Beijing. | Britain | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10015 | 10015 | 1902-03-15 | 2 | f | Hubei province has no memorial ceremony on the death of Li Hongzhang. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10016 | 10016 | 1902-03-15 | 2 | f | Suggestions from Hu Jufen on road construction, police system and others to the court. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10017 | 10017 | 1902-03-15 | 2 | f | Su Yuanchun has moved from Guangxi to Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10018 | 10018 | 1902-03-15 | 2 | f | Tang Jingsong, imperial commissioner to Taiwan, came to visit Guangdong on his way to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10019 | 10019 | 1902-03-15 | 2 | f | Guangdong is making speedboats in order to increase navigational security. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10020 | 10020 | 1902-03-15 | 2 | f | Qinxian county, Guangdong, has begun to use silver coins which were previously rejected in the province. | China | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10021 | 10021 | 1902-03-15 | 2 | f | Poems in praise of Lin Zhiyi, a Chinese businessman and philanthropist in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
| 10022 | 10022 | 1902-03-15 | 3 | a | The current activities of Magistrate Liang Dingfen. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10023 | 10023 | 1902-03-15 | 3 | a | A letter from Russian ambassador in Beijing to Rong Lu. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10024 | 10024 | 1902-03-15 | 3 | b | Emperor Guangxu, after return, has met many government officials for reform. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10025 | 10025 | 1902-03-15 | 3 | b | A local scholar (xiucai) in Henan province submitted advice on reforms to the Emperor. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10026 | 10026 | 1902-03-15 | 3 | b | Reform in Shandong province, China. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10027 | 10027 | 1902-03-15 | 3 | b | Number of British troops injured in China during the Boxer chaos. | Australia | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10028 | 10028 | 1902-03-15 | 3 | b | The war between Britain and Transvaal in South Africa. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10029 | 10029 | 1902-03-15 | 3 | c | A Chinese in America found a worm in the rotten fish he bought from a shop. | America | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10030 | 10030 | 1902-03-15 | 3 | c | Experts from Sweden are investigating the effects of beriberi and epidemics in Thailand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10031 | 10031 | 1902-03-15 | 3 | c | Bandits in Nanning, Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10032 | 10032 | 1902-03-15 | 3 | c | A shop in Panyu county, Guangdong, was burned to ashes. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10033 | 10033 | 1902-03-15 | 3 | c-d | Local authorities in Xinning county, Guangdong, encourages agriculture and forestry. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10034 | 10034 | 1902-03-15 | 3 | d | Expenditure of German troops in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10035 | 10035 | 1902-03-15 | 3 | d | An American army ship in storm. | America | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10036 | 10036 | 1902-03-15 | 3 | d | A train accident in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10037 | 10037 | 1902-03-15 | 3 | d | Railway building and operation in Siberia. | China | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10038 | 10038 | 1902-03-15 | 3 | e | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10039 | 10039 | 1902-03-15 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 |
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]);