This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40330 | 40330 | 1923-09-01 | 6 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
40331 | 40331 | 1923-09-01 | 6 | a-b | Shareholders of the Xinning railway line issue an open letter. | China | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
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 | |
40333 | 40333 | 1923-09-01 | 6 | c-d | Chinese Association in New Zealand gathers in protest against auction of charity properties in Guangzhou. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
40334 | 40334 | 1923-09-01 | 6 | d | A man talks with a ghost in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094532 | 24094532 | |
40335 | 40335 | 1923-09-01 | 6 | d | A pray for rain in a Beijing village. | Tung Wah | 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]);