This data as json, CSV (advanced)
Suggested facets: page, column, description, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40212 | 40212 | 1923-08-11 | 2 | b-c | Orders issued by Chinese President Li Yuanhong before his leaving for Tianjin. And some other orders issued by Li Yuanhong after his arriving in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24094504 | 24094504 | |
40213 | 40213 | 1923-08-11 | 2 | c-e | Members of national parliament Peng Zhanyuan and others issue circular telegram which drives out Li Yuanhong. City residents and students hired by some politicians besiege Li Yuanhong's residence.` | China | http://trove.nla.gov.au/newspaper/page/24094504 | 24094504 | |
40214 | 40214 | 1923-08-11 | 2 | e | Sun Yatsen urges members of the national parliament to go south. | China | http://trove.nla.gov.au/newspaper/page/24094504 | 24094504 | |
40215 | 40215 | 1923-08-11 | 2 | e-f | Governor of Zhejiang province Lu Yongxiang supports to move the national parliament to the south. | China | http://trove.nla.gov.au/newspaper/page/24094504 | 24094504 | |
40216 | 40216 | 1923-08-11 | 2-3 | f-b | Japanese in Changsha, capital of Hunan province, kill Chinese residents and the following protest movement nationwide. Demonstrations in Shanghai and some protest telegrams. | China | http://trove.nla.gov.au/newspaper/page/24094504 | 24094504 | |
40218 | 40218 | 1923-08-11 | 3 | c | Boycott to Japanese goods in China. | China | http://trove.nla.gov.au/newspaper/page/24094503 | 24094503 | |
40220 | 40220 | 1923-08-11 | 3 | d | Chinese soldier shoots on board of American ship in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24094503 | 24094503 | |
40225 | 40225 | 1923-08-11 | 6 | b-c | A circular telegram issued by members of the Jiangsu provincial legislature assembly on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24094508 | 24094508 | |
40226 | 40226 | 1923-08-11 | 6 | c | Students association in Anhui province issues a circular telegram on the fighting for presidency in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094508 | 24094508 | |
40227 | 40227 | 1923-08-11 | 6 | c-d | Second and final part of an investigation on economic activities in China conducted by the Beijing government (the making and export of hairnet). | China | http://trove.nla.gov.au/newspaper/page/24094508 | 24094508 | |
40228 | 40228 | 1923-08-11 | 6 | d | American businessmen in Shanghai write to their Secretary of State and the request. | China | http://trove.nla.gov.au/newspaper/page/24094508 | 24094508 | |
40241 | 40241 | 1923-08-11 | 7 | d-e | Boycott to Japanese goods in China. | China | http://trove.nla.gov.au/newspaper/page/24094507 | 24094507 |
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]);