This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21552 | 21552 | 1909-08-28 | 2 | a-b | An essay from anonymous author in Nanyang claims that only constitutional reform could save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802304 | 26802304 | |
21553 | 21553 | 1909-08-28 | 2 | b-c | An article written by former Chinese ambassador to Britain Wang Daxie for advice to overseas Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802304 | 26802304 | |
21554 | 21554 | 1909-08-28 | 2 | c-d | Beijing news/ Proposal to appoint government official for trade management in the port cities. Shandong authority surveys Tianheng island. Negotiation between China and foreign governments on mining resources. Prince Regent talks on revision of criminal law. Hubei governor Chen Kuilong appoints woman spy for secret investigation on opium smoking. Yuan Shikai in his hometown Weihui, of Henan province. Prince Regent on the selection on legislature members. Government officials in Henan province accept bribery from British businessmen. The Beijing-Hankou railway after taking over by the ministry of communications. | China | http://trove.nla.gov.au/newspaper/page/26802304 | 26802304 | |
21555 | 21555 | 1909-08-28 | 2-3 | d-a | Guangdong news/ Newly appointed Guangdong governor Yuan Shuxun inquires social and economic situations of the province. Yuan Shuxun is interested in communication between Guangdong and Hunan province. Xiangzhou town prepares for inland navigation. Tourists to Hong Kong. Hong Kong - Shanghai Bank Corporation sets up a branch in Shamian. A calf in Guangzhou has eight legs. Feng Pinguang in Nanhai county is entitled to vote as he has property. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802304 | 26802304 |
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]);