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 |
|---|---|---|---|---|---|---|---|---|---|
| 11954 | 11954 | 1903-06-20 | 2 | a-b | An article, selected from a Shanghai newspaper, on Chinese students in Japan and their achievements. | China | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11955 | 11955 | 1903-06-20 | 2 | b | Qin Chunxuan, new governor of Guangdong and Guangxi, has arrived Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11956 | 11956 | 1903-06-20 | 2 | b | Kang Youwei has returned to China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11957 | 11957 | 1903-06-20 | 2 | b | Secret imperial edicts from Emperor Guangxu on resistance to Russia, and political reform. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11958 | 11958 | 1903-06-20 | 2 | b | Prince Su is seeking talents. | China | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11959 | 11959 | 1903-06-20 | 2 | b | Imperial commissioner of Guangxi Wang Zhichun is to invite French troops to suppress bandits. Protest from Guangzhou, Hangzhou, Dongguan, and Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11960 | 11960 | 1903-06-20 | 2 | c | Russia put forward to China another copy of the Manchuria treaty. | China | http://trove.nla.gov.au/newspaper/page/26800244 | 26800244 | |
| 11961 | 11961 | 1903-06-20 | 3 | a | Chaos in Macedonia and Turkey; gold mine in south Africa employs Japanese workers; Board of Revenue and Rites in Beijing were burned down; Prince Su talks with Russian ambassador to Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 | |
| 11962 | 11962 | 1903-06-20 | 3 | b | The Chinese community in Sydney sent a telegram to Chinese government asking 1) Empress Dowager to return power to Emperor Guangxu; 2) to refuse the Manchuria treaty suggested by Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 | |
| 11963 | 11963 | 1903-06-20 | 3 | b | Emperor of Serbia has been overthrown. | Britain | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 | |
| 11964 | 11964 | 1903-06-20 | 3 | c | A Chinese man Tang Wanzhai was crushed to pieces by a train. | Australia | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 | |
| 11965 | 11965 | 1903-06-20 | 3 | c | Japan is preparing for war in Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 | |
| 11966 | 11966 | 1903-06-20 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800243 | 26800243 |
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]);