This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22827 | 22827 | 1910-05-21 | 2 | a-b | Second and final part of an editorial on opium smuggling by the Chinese community in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22828 | 22828 | 1910-05-21 | 2 | b | Imperial edict on March 2 and 5 on appointment of Chen Baoshen, Li Jiaju and others. | China | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22829 | 22829 | 1910-05-21 | 2 | b | News in brief/ Four foreign countries insist to lend China for the railway construction in Sichuan and Hubei province. Duan Fang and Qin Chunxuan in the court. Jing Yuanshan (Liansan) is rehabilitated. Both America and Germany want to sell gunboat to China. Chen Zhaochang is promoted. Funeral of Dai Hongci. | China | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22830 | 22830 | 1910-05-21 | 2 | b | Government officials in Beijing on opium ban and its relation to the establishment of national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22831 | 22831 | 1910-05-21 | 2 | b-c | Higher security for Prince Regent since bomb found in his yard and the investigation. | China | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22832 | 22832 | 1910-05-21 | 2 | c | Lu Naixiang, representative of Chinese community in Australasia, arrives Nanjing for the petition of national parliament, and the welcome ceremony. | China | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 | |
22833 | 22833 | 1910-05-21 | 2 | c-d | The murder of Liu Shiji and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802633 | 26802633 |
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]);