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 |
---|---|---|---|---|---|---|---|---|---|
45201 | 45201 | 1926-10-02 | 8 | a-d | Guangdong news/ Guangzhou residents gather in protest against taxes. Bandits hijack a train near Guangzhou. Road construction in Guangdong. Rice price going down in Boluo and Zengcheng county. Treasury protects the petrol transportation. | China | http://trove.nla.gov.au/newspaper/page/24101734 | 24101734 | |
45200 | 45200 | 1926-10-02 | 7 | d | The war in Sichuan and Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45199 | 45199 | 1926-10-02 | 7 | d | Storm in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45198 | 45198 | 1926-10-02 | 7 | c | Anti-foreign movement in Sichuan province and the attitude towards Britons. | China | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45197 | 45197 | 1926-10-02 | 7 | c | The China-Russia Bank closes down in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45196 | 45196 | 1926-10-02 | 7 | c | Northern Expedition troops take over Nanchang, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45195 | 45195 | 1926-10-02 | 7 | a-c | Australia news/ Foreign missions in Melbourne have a party chaired by Wei Zijing, Chinese Consul-General. Chinese fighting in Footscray, Melbourne. Tourist in Sydney is stolen. Russian refugees speak in Sydney. Sydney police raid Chinese gambling dens. Passengers on board of liner Taiping. Price of tap water increased for the Chinese gardens in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
45194 | 45194 | 1926-10-02 | 6 | b | Chinese community in Sydney prepares for the birthday celebration of Confucius and the detailed report. Photograph of Mrs Wu Yangshou (Mrs U. Young Show), honorary organiser, Ladies' Committee of the Confucius Commemoration picnic under the auspices of the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 | |
45193 | 45193 | 1926-10-02 | 6 | b | Commercial Bank of Australia makes huge profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 | |
45192 | 45192 | 1926-10-02 | 6 | a-b | A survey on the Guangdong business in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 | |
45191 | 45191 | 1926-10-02 | 5 | a-c | Miscellaneous report on war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101729 | 24101729 | |
45190 | 45190 | 1926-10-02 | 3 | e | The Northern Expedition in China and report on the war. | China | http://trove.nla.gov.au/newspaper/page/24101727 | 24101727 | |
45189 | 45189 | 1926-10-02 | 3 | d | The Beijing cabinet might be reorganised again. | China | http://trove.nla.gov.au/newspaper/page/24101727 | 24101727 | |
45188 | 45188 | 1926-10-02 | 2 | f | Number of troops in China from Britain, America, France, Italy and Japan. | China | http://trove.nla.gov.au/newspaper/page/24101728 | 24101728 | |
45187 | 45187 | 1926-10-02 | 2 | e | Twenty-one associations in Shanghai fight for the tariff autonomy of China. | China | http://trove.nla.gov.au/newspaper/page/24101728 | 24101728 | |
45186 | 45186 | 1926-10-02 | 2 | c-d | An article written by Luo Fuquan on the birthday celebration for Confucius in Sydney and its relations to the Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101728 | 24101728 |
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]);