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 |
---|---|---|---|---|---|---|---|---|---|
12075 | 12075 | 1903-08-01 | 2 | b | Zhenbeizi reports to Empress Dowager on his tour to Japan, and the visit to Chinese students there. | China | http://trove.nla.gov.au/newspaper/page/26800265 | 26800265 | |
12076 | 12076 | 1903-08-01 | 2 | b | Chinese students in Japan organise an association. | Japan | http://trove.nla.gov.au/newspaper/page/26800265 | 26800265 | |
12077 | 12077 | 1903-08-01 | 2 | b | Yuan Shikai is preparing new policy for Manchuria after withdrawal of Russian troops. | China | http://trove.nla.gov.au/newspaper/page/26800265 | 26800265 | |
12086 | 12086 | 1903-08-01 | 3 | b | More Chinese businessmen in Sydney become shareholders of the proposed China Commercial Company. They are Zhu Zhaozhang, Zheng Linhao, Li Dong, Huang Long, Hu Xiang, Mai Mei, Yang Huiting, Pang Zijun, Chen Weixun, Zhang Zhaoyue, Lei Xuequan, Xia Congzhou, Jian Zhangrui, Lu Taiping, Yang Dong, Wang Rongfu, Yao Bingguang, Liu Shuqiu, Chen Jianzhi, Fang Ling, Ye Wusheng, Peng Zhanlin, Ma Ba, Li Jiayu, Wang Shuxi, Liu Guiqing, Liu Kezhai, Liang Huayong, Sun Ganting, Liang Yaonan, Wu Pushan, Wu E'lou and Xiao Bao. More than 30 names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 | |
12087 | 12087 | 1903-08-01 | 3 | b | Four Chinese in New Castle were baptised at the Presbyterian church. They are Huang Yongxi, Chen Diquan, Li Guanxiang, and Zheng Lu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 | |
12088 | 12088 | 1903-08-01 | 3 | b | Chinese in New York set up a Society of East Asia, and involvement of Chinese Consul General. | America | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 |
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]);