This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31791 | 31791 | 1916-12-09 | 2 | c-d | First part of the draft of China's constitution. | China | http://trove.nla.gov.au/newspaper/page/24095507 | 24095507 | |
31796 | 31796 | 1916-12-09 | 3 | c-d | Gentry and army in Sichuan province oppose Luo Peijin and their circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24095506 | 24095506 | |
31803 | 31803 | 1916-12-09 | 7 | c-d | Correspondence from Guangzhou/ Li Liejun, Zhu Qinglan, Tan Haoming, Yan Jiachi, Mo Rongxin and others offer their sacrifices to the Huanghuagang and the report. Yunnan troops in Guangzhou. Governor Zhu Qinglan after his arrival in Guangzhou. Youth association in Guangzhou. Welcome ceremony for Li Liejun. | China | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 | |
31807 | 31807 | 1916-12-09 | 8 | c-d | Guangdong news/ Governor Zhu Qinglan maintains the postal services. Ferries are hijacked in Nanhai county. Police in Qingyuan county are urged to smash gambling dens. A Guangdong man Chen Jishan invents new weapons. Preparation for the celebration of inaugural ceremony for Vice-President. Zhu Qinglan on the foreign loans. Tang Jiyao sends envoys to Guangdong. Huang Zhiheng in Hainan island is charged. Police hospital in consideration in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24095513 | 24095513 |
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]);