This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21484 | 21484 | 1909-08-14 | 3 | d | News in brief/ Embezzlement in Zhili province and the governors Yuan Shikai and Yang Shixiang. Henan people fight for mining rights and have conflict with the department of foreign affairs. Tang Shaoyi reports to Prince Regent China's relationship with America. Wong Tonghe is rehabilitated. Negotiation between China and Britain over the return of Weihaiwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 | |
21485 | 21485 | 1909-08-14 | 3 | d | Tung Wah Times comments that the government is unpatriotic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 | |
21492 | 21492 | 1909-08-14 | 6 | d | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21506 | 21506 | 1909-08-14 | 8 | d | Bronze cannon owned by Taiping rebellions are found in Anhui province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802294 | 26802294 |
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]);