This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28860 | 28860 | 1914-05-23 | 3 | c-d | Guangdong news/ Rebels Li Liejun, Chen Jiongming and Zhu Zijing prepare for another uprising from the Nanyang (Southeast Asian) area. Salary levels set for county magistrate. The Guangzhou-Hankou railway company repays loans. Government troops suppress bandits in Xiangshan county. A case of adultery in Xingning county and the solution. Orders from the central government in Beijing for government department redundancy. Provincial authority to dispatch more spies to Hong Kong and Macao. | China | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 |
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]);