This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17906 | 17906 | 1907-08-10 | 2 | a | A notice from Tung Wah Times to its subscribers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801428 | 26801428 | |
17907 | 17907 | 1907-08-10 | 2 | a-b | Chinese communities in Nanyang (southeast Asia) welcome visiting cruisers from China, and a detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801428 | 26801428 | |
17908 | 17908 | 1907-08-10 | 2 | b-c | Imperial edicts on opium ban, selection of imperial scholars from provinces and the constitutional reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801428 | 26801428 | |
17909 | 17909 | 1907-08-10 | 2 | c | British government agrees to reduce opium exporting to China. | Britain | http://trove.nla.gov.au/newspaper/page/26801428 | 26801428 | |
17911 | 17911 | 1907-08-10 | 2-3 | d-a | China news. The railway from Hankou to Guangzhou will change its name. Chinese government ranks its ambassadors overseas (first class ambassadorship includes Britain, America, Germany, France, Russia and Japan while the second class includes those to Austria, Italy and the Netherlands). Qin Chunxuan recommends Zhao Qilin, Jiang Shixing and three others. Proposal to cancel the military parade this coming autumn. Nobody knows when Qin Chunxuan comes to take his office as Guangdong governor. Former Manchurian governor Zhao Er'tuan might be promoted. Zhoushan islands in Zhejiang province might be turned into Chinese naval base. Qu Hongji returns to his hometown, Shanhua county, Hunan province. Zhang Zhidong might be promoted. | China | http://trove.nla.gov.au/newspaper/page/26801428 | 26801428 |
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]);