This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22084 | 22084 | 1909-12-11 | 2 | a-b | Imperial edict on September 15 on opium smoking in the officialdom. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802424 | 26802424 | |
22088 | 22088 | 1909-12-11 | 3 | a-b | Guangdong news/ Two legislature members in Kaiping county are charged with corruption. Security commander Li cuts budget. Chen Yixi is appointed advisor to the agriculture department. New building for the legislature assembly. Industrial investment encouraged. Yuan Shuxun prepares for further constitutional reform. Yuan Shuxun cuts government budget. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802423 | 26802423 | |
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 | |
22120 | 22120 | 1909-12-11 | 8 | a-b | Second part of the report, prepared by Wu Xianzi, saying that Chinese communities in Nanyang mourn over the national doom of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802430 | 26802430 |
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]);