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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 45189 | 45189 | 1926-10-02 | 3 | d | The Beijing cabinet might be reorganised again. | China | http://trove.nla.gov.au/newspaper/page/24101727 | 24101727 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 45199 | 45199 | 1926-10-02 | 7 | d | Storm in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
| 45200 | 45200 | 1926-10-02 | 7 | d | The war in Sichuan and Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101731 | 24101731 | |
| 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 |
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]);