This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40121 | 40121 | 1923-07-21 | 2 | b-f | Miscellaneous report on the hijack of train in Shandong province. Bandits seek peace talks with the government authorities. Chinese government mishandles the hijack incident and the report. | China | http://trove.nla.gov.au/newspaper/page/24094480 | 24094480 | |
40122 | 40122 | 1923-07-21 | 3 | a | Members of the Chinese parliament demand payment of their overdue salary. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40123 | 40123 | 1923-07-21 | 3 | a-b | Businessmen in Shanghai are keen to promote uniform for Chinese officials. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40124 | 40124 | 1923-07-21 | 3 | b | Bandit chieftain Sun Meiyao in Shandong province, who hijacked a train and kidnapped some foreigners, issues a public notice and his explanation. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40125 | 40125 | 1923-07-21 | 3 | c | Textile industry in Shanghai and the crisis. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40126 | 40126 | 1923-07-21 | 3 | c | King of Ryukyu Islands (Nansei Shoto) visits Suzhou, Nanjing, Hankou, Beijing and Korea. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40127 | 40127 | 1923-07-21 | 3 | c | Bandits in Shandong province have killed more than 80 hostages. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40129 | 40129 | 1923-07-21 | 3 | d | Wang Chonghui is leaving Shanghai for Hague as judge of the international court, and his comments on Sun Yatsen and Guangdong, and notes by the Tung Wah Times. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40130 | 40130 | 1923-07-21 | 3 | d-e | Sun Yatsen, Zhang Zuolin and Wu Peifu talk about the national unification in China. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40131 | 40131 | 1923-07-21 | 3 | e | Chinese government opens Bengbu, of Anhui province, for international trade. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40132 | 40132 | 1923-07-21 | 3 | e | Returned students from Europe and America organise an association to promote industrial development in China. Textile industry in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094479 | 24094479 | |
40134 | 40134 | 1923-07-21 | 6 | b-c | An open letter from Guangdong commercial chamber to the army commanders. | China | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40135 | 40135 | 1923-07-21 | 6 | c-d | Competition of international shipping industry in China. | China | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40144 | 40144 | 1923-07-21 | 7 | b | Japanese businessmen in Shanghai meet and discuss the boycott to Japanese goods in China. | China | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 | |
40145 | 40145 | 1923-07-21 | 7 | b-c | Imperial Qing family in the Forbidden City dismisses eunuchs. | China | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 |
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]);