This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6829 | 6829 | 1901-01-12 | 2 | a-b | The second and final part of Kang Youwei's memorial report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6830 | 6830 | 1901-01-12 | 2 | b-c | Western media comments on current China affairs. | China | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6831 | 6831 | 1901-01-12 | 2 | c-d | The second part of the record on the grand ceremony held to celebrate the Australian Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6832 | 6832 | 1901-01-12 | 2 | d | Storm in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6833 | 6833 | 1901-01-12 | 2 | d | British general returns home in triumph. | China | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6834 | 6834 | 1901-01-12 | 2 | d | Sugar production and exports of Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6835 | 6835 | 1901-01-12 | 2 | d | Wheat production in Albury, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6836 | 6836 | 1901-01-12 | 2 | d | Three men were murdered in Poatina, Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6837 | 6837 | 1901-01-12 | 2 | e | Gambling has been approved in Zhaoqing, Guangdong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6838 | 6838 | 1901-01-12 | 2 | e | Fu army, commanded by General Liu Yongfu, captured some bandits and took them back to Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6839 | 6839 | 1901-01-12 | 2 | e | A man and a woman were arrested and tried for murdering local scholar Liu Shengsan and his whole family in Xiangshan county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6840 | 6840 | 1901-01-12 | 2 | f | Empress Dowager orders the execution of Yu Xian, imperial commissioner of Shanxi; German troops seized weapons from northwest Tianjin; French newspaper comments on Russia's occupation of Manchuria; Zhang Zhidong suggested to suspend the peace agreements with foreign governments; Britain and Germany signed a memorandum on China issues; French newspaper comments on China's attitude towards Russia's occupation of Manchuria; the agreement Li Hongzhang signed with Russia on Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6841 | 6841 | 1901-01-12 | 2 | f | A letter from Xi'an to Hangzhou about the Emperor in Xi'an. | China | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 | |
6842 | 6842 | 1901-01-12 | 2 | a | The imperial examination this year will be postponed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099914 | 24099914 |
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]);