This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38287 | 38287 | 1922-02-18 | 2 | b-c | Chinese President Xu Shichang orders to pardon Duan Zhigui, to promote local self-government, and to encourage industrial development. | China | http://trove.nla.gov.au/newspaper/page/24093872 | 24093872 | |
38296 | 38296 | 1922-02-18 | 3 | b-c | Foreign diplomatic envoys in Beijing visit President Xu Shichang on the New Year's Day. | China | http://trove.nla.gov.au/newspaper/page/24093871 | 24093871 | |
38302 | 38302 | 1922-02-18 | 6 | b-c | Poems on a tour to the West Lake in Hangzhou, written by Xiaozhen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093876 | 24093876 | |
38315 | 38315 | 1922-02-18 | 8 | b-c | Guangdong news/ Governor Chen Jiongming forbids to devaluate the bank notes issued by provincial bank. Businessmen in Guangzhou protest against new business regulation and a brief introduction to the regulation. Solution to the property dispute of Ming Lun Tang in Dongguan. A barge from Dongguan to Guangzhou narrowly escapes an accident. A robbery in Guangzhou. Dispute in Gaoyao county on the election of magistrate. Political chaos in Xiangshan county on magistrate election. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093878 | 24093878 |
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]);