This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28343 | 28343 | 1913-12-27 | 8 | a | The project of Panama Canal has been completed. | Other... | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 | |
28344 | 28344 | 1913-12-27 | 8 | a-b | Chinese President Yuan Shikai appoints Chen Qi chief supervisor for the Panama Exhibition. | China | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 | |
28345 | 28345 | 1913-12-27 | 8 | b | Construction of a railway in the Far East of Russia and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 | |
28346 | 28346 | 1913-12-27 | 8 | c | Guangdong news/ Confucianism Promotion Society in Guangzhou and their meeting with provincial governor. Long Jiguang welcomes Kang Youwei and the ceremony. Guangdong and Guangxi to swap their governors. Hong Kong businessmen request provincial authority to repay public debt. The Nationalist Party and their new roles. Stamp duty to be collected. Three female convicts to be executed in Guangzhou for weapon smuggling. Bandits robbery in Xiangshan county. Luo Pu arrives Guangzhou as new industrial commissioner. | China | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 |
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]);