This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17976 | 17976 | 1907-08-24 | 2 | a-b | Report prepared by Huang Kuanzhuo on the history and city of Ciudad Juarez, Mexico. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 | |
17977 | 17977 | 1907-08-24 | 2 | b-c | Tung Wah Times comments on the treaty signed between Japan and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 | |
17978 | 17978 | 1907-08-24 | 2 | c | Important news. Chinese government bans its soldiers from opium smoking. | Britain | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 | |
17979 | 17979 | 1907-08-24 | 2 | c-d | Imperial commissioner of Anhui province En Ming is assassinated by Xu Xilin, revolutionary follower of Sun Yatsen, and a further report on the case. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 | |
17980 | 17980 | 1907-08-24 | 2-3 | d-a | China news. Zhao Binglin impeaches Yuan Shikai. Yuan Shikai in crisis following impeachment of two imperial scholars. Yuan Shikai's strategy to suppress revolutionary activist. Two revolutionaries are arrested in Baoding, Zhili province. Local gentry in Shaanxi and Gansu provinces are determined to build railway themselves. Liang Dunyan, on behalf of Chinese government, in negotiation with British and Germany missions on the cancellation of railway treaty from Tianjin to Zhenjiang. Yuan Shikai intends to organise new cabinet. Sha Zhenbing talks his new policy to rejuvenate Chinese navy. China to set up a headquarters of naval forces. | China | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 |
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]);