This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20147 | 20147 | 1908-10-24 | 2 | b-d | Second part of the report from the Constitutional Research Institution (xian zheng bian cha guan) on necessary preparation in the next few years for constitutional reform, establishment of parliament and the draft of new constitution of China. | China | http://trove.nla.gov.au/newspaper/page/26801923 | 26801923 | |
20151 | 20151 | 1908-10-24 | 3 | b-d | Guangdong news/ Governor Zhang Renjun replies to self-government society in Guangzhou on the effort of disaster relief. Guangdong authority is planning to dredge some rivers to avoid future flood. New governor of Guangzhou to take his office soon. Guangdong authority to ban rice export at the moment. New chemical fertilizer has been manufactured in Foshan. Guangzhou to use warning balloon for future strong wind. Auditing conducted for all charity institutions in Guangzhou. Telephone operator and the corruption in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801922 | 26801922 |
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]);