This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20208 | 20208 | 1908-11-07 | 2 | c-d | Beijing news. Opium smokers to be registered. American government returns some Boxer Indemnity and subsidises Chinese students in American university. Foreign missions in Beijing agree to move their arsenal out of the city. Salt price to be higher. Technical university to be established in Beijing. Japanese ambassador defames Wu Tingfang. German in Jimo county of Shandong province plant trees. China starts negotiation with Russia over the Manchuria treaty. China requests Britain to deport Sun Yatsen but has been refused. China asks French consulate in Guangzhou to hand over Chinese criminals. Zhang Zhidong urges speedup of the railway construction from Guangzhou to Hankou. A proposal to send warship to tour Europe and America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801940 | 26801940 | |
20213 | 20213 | 1908-11-07 | 3 | c-d | Solution to the family feud and fighting in Gujing town of Xinhui county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801939 | 26801939 | |
20234 | 20234 | 1908-11-07 | 7 | c-d | Jokes. New explanation of two Chinese phrases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801943 | 26801943 |
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]);