This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21587 | 21587 | 1909-09-04 | 3 | a-b | Beijing news/ Wong Tonghe has been rehabilitated. Lushun to be opened for international trade. Both German and British governments are keen to set up university in China and the response from Chinese government. German miner in Zichuan county, Shandong, kills a Chinese boy and injures his father. Dispute between German and Chinese businessmen on mining in Shandong. Jiangxi province on alert for possible banditry. Na Tong and his management of the Li Deshun case. Most government officials support to ban political parties. Emperor of Japan, ambassadors from Britain and Russia inquires the drought in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/26802311 | 26802311 | |
21594 | 21594 | 1909-09-04 | 6 | a-b | A report, submitted by imperial commissioner of Shandong province Yuan Shuxun, suggests to build a temple for Wu Xun, a beggar who built local schools. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802316 | 26802316 | |
21602 | 21602 | 1909-09-04 | 7 | a-b | A public notice issued by Chinese consul general in New Zealand Huang Rongliang on the application for Chinese passport when returning home. And a letter to the Tung Wah Times from Chinese consul general in New Zealand Huang Rongliang (The Hon. Y. L. Hwang, M.A. Imperial Chinese Consulate, 135a Thorndon Quay, Wellington, New Zealand). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802315 | 26802315 | |
21609 | 21609 | 1909-09-04 | 8 | a-b | British writer on Macao (territory, household, city wall), part IX. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802318 | 26802318 |
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]);