This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27602 | 27602 | 1913-07-12 | 8 | a | Public statement issued by the Chinese community in Yokohama and the Overseas Chinese Association in Shanghai on the assassination of Song Jiaoren and others. | China | http://trove.nla.gov.au/newspaper/page/24092751 | 24092751 | |
27603 | 27603 | 1913-07-12 | 8 | a-c | Sun Yatsen appoints Japanese man to set up and manage the Central Bank of China and proof of his betrayal, a further report. | China | http://trove.nla.gov.au/newspaper/page/24092751 | 24092751 | |
27604 | 27604 | 1913-07-12 | 8 | c-d | Further report on the investigation over the assassination of Song Jiaoren. | China | http://trove.nla.gov.au/newspaper/page/24092751 | 24092751 | |
27605 | 27605 | 1913-07-12 | 8 | d | News in brief/ Parliamentarians request to remove Sun Yatsen. Bomb found in opium in Beijing. Long Jiguang is advised to resist the central government. Yuan Shikai urges Kang Youwei to return from Japan. Attempt to overthrow Yuan Shikai. Yuan Shikai list crimes committed by Li Liejun. Yuan Shikai under question in the parliament. Huang Xing writes to Yuan Shikai. Li Liejun is removed from his governorship of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24092751 | 24092751 |
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]);