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 |
---|---|---|---|---|---|---|---|---|---|
45212 | 45212 | 1926-10-09 | 6 | a | A notice by the Chinese Chamber of Commerce in Sydney on the birthday celebration for Confucius and the National Day celebration on October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101740 | 24101740 | |
45211 | 45211 | 1926-10-09 | 5 | a-c | Miscellaneous report on the war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101737 | 24101737 | |
45215 | 45215 | 1926-10-09 | 7 | a-d | Australia news/ The Young Chinese Association of Australia (li zhi hui) celebrates the birthday of Confucius and speakers include Liu Bingshu, Wu Zhaoquan, Ling Ying, Lei Ji, Yu Kun and Luo Run. Picnic organised by the New South Wales Chinese Chamber of Commerce on the birthday of Confucius and speakers include Chen Zanhua, Pan Yonghan, Guo Jianying, Liu Guangfu, Liang Lanxin, Liu Yunxin and others. The Chinese Chamber of Commerce in Sydney to celebrate the National Day on October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101739 | 24101739 | |
45217 | 45217 | 1926-10-09 | 8 | a-d | Guangdong news/ Government authority discusses with commercial chambers on issue of social security. Wang Jingwei in Guangzhou. Martial law enforced in Guangzhou. Chen Jiongming's army retreat to Heping county. Telegram from Zhou Yinren to He Yingqin. Peasants in Heshan county on riots for tax. Women detained in Guangzhou for weapon smuggling. Bandits hijack passenger liner. The Qiguang Hospital opened in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101742 | 24101742 | |
45213 | 45213 | 1926-10-09 | 6 | b | A survey on the life of workers in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101740 | 24101740 | |
45214 | 45214 | 1926-10-09 | 6 | c | Doctor on the health issues during hot summer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101740 | 24101740 | |
45202 | 45202 | 1926-10-09 | 2 | c-d | Editorial on the National Day celebration on October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101736 | 24101736 | |
45203 | 45203 | 1926-10-09 | 2 | d | A meeting of the Beijing cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101736 | 24101736 | |
45204 | 45204 | 1926-10-09 | 2 | d | Zhang Zongchang recommends Sun Baoqi to organise a cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101736 | 24101736 | |
45207 | 45207 | 1926-10-09 | 3 | d | Appointments by the Chinese Premier Du Xigui. | China | http://trove.nla.gov.au/newspaper/page/24101735 | 24101735 | |
45208 | 45208 | 1926-10-09 | 3 | d | Foreign military attach? observe the battle in Nankou. | China | http://trove.nla.gov.au/newspaper/page/24101735 | 24101735 | |
45216 | 45216 | 1926-10-09 | 7 | d | Chinese ambassador to Britain Zhu Zhaoxin and his recent activities. | Britain | http://trove.nla.gov.au/newspaper/page/24101739 | 24101739 | |
45205 | 45205 | 1926-10-09 | 2 | e | Wu Peifu reports the battles in the Northwest. | China | http://trove.nla.gov.au/newspaper/page/24101736 | 24101736 | |
45209 | 45209 | 1926-10-09 | 3 | e | Feng Yuxiang's army retreat to Suiyuan and Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24101735 | 24101735 | |
45218 | 45218 | 1926-10-09 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101742 | 24101742 | |
45206 | 45206 | 1926-10-09 | 2 | f | Troops from Jiangsu province to help Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/24101736 | 24101736 | |
45210 | 45210 | 1926-10-09 | 3 | f | The Communists in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101735 | 24101735 |
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]);