This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21097 | 21097 | 1909-06-05 | 2 | d | Beijing news/ Research institute for constitutional reform in Beijing. Chronology edited for the period of Emperor Guangxu. Proposal to reform current civil service system. Li Dianlin reports the construction of railway from Beijing to Zhangjiakou. Effort to build Chinese navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802206 | 26802206 | |
21108 | 21108 | 1909-06-05 | 3 | d | Weird stories from Shanghai. Newspapers flatter government officials. Magistrate of Shanghai Cai Naihuang can do nothing but catch a few revolutionaries. Rumours everywhere in Shanghai. Qin Chunxuan is under close surveillance. Some prominent people in Shanghai are actually playing mahjong everyday. Number of Chinese and foreign residents in Shanghai. Foreign missionaries in Shanghai feel shame to have contact with Chinese. Chinese and foreign parks in Shanghai. Tram company in Shanghai and the passengers. British, French and American settlement in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802205 | 26802205 | |
21109 | 21109 | 1909-06-05 | 3 | d | Report on opium trade in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802205 | 26802205 | |
21124 | 21124 | 1909-06-05 | 7 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802209 | 26802209 | |
21125 | 21125 | 1909-06-05 | 7 | d | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802209 | 26802209 | |
21126 | 21126 | 1909-06-05 | 7 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802209 | 26802209 |
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]);