This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22102 | 22102 | 1909-12-11 | 6 | a-b | Xu Qin writes publicly to Liao Shouhua (on Zhenhua company, murder of Liu Shiji, and overseas investment in Guangxi province). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22103 | 22103 | 1909-12-11 | 6 | b | Provincial governments in China are proposed to appoint foreign financial supervisor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22104 | 22104 | 1909-12-11 | 6 | b | Revenue of the Beijing-Hankou railway. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22105 | 22105 | 1909-12-11 | 6 | b | Korean students in China. | China | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22106 | 22106 | 1909-12-11 | 6 | b-c | Gentry in Hubei and Hunan province protest against possible involvement of foreign loans in the railway construction. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22107 | 22107 | 1909-12-11 | 6 | c | Telegram from the Guangzhou-Hankou railway company on the shares of the company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 | |
22108 | 22108 | 1909-12-11 | 6 | c | Tung Wah Times comments on Chinese diplomacy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802428 | 26802428 |
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]);