This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40311 | 40311 | 1923-09-01 | 2 | b-c | Second and final part of a report on that the Chinese communities in California welcome education delegation from China to the world education conference (zhong hua hui guan, Chinese Chamber of Commerce, Chenzhong Chinese school, Chinese Students Association in California, Chinese Students Association in Stanford University, Chinese Youth Club, St Mary School, and other Chinese associations). | America | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40322 | 40322 | 1923-09-01 | 3 | b-c | Campaign for presidential election in China. | China | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 | |
40332 | 40332 | 1923-09-01 | 6 | b-c | Chinese businessman Liang Chuang celebrates his 60th birthday in Shanghai and congratulations from Liang Qichao, Xiong Xiling, Wang Daxie, Lin Changmin, Wang Chonghui, Li Zhongyue, Li Hanfen, Yang Hao, Wang Tiduan, Wang Zhaoji, Kang Youwei, Zhang Qian, and many others. Liang is major shareholder of Wing On companies in Hong Kong, Shanghai and Sydney, of Wing On textile company in Shanghai and Guangming electronics company in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 |
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]);