This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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]);