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 |
---|---|---|---|---|---|---|---|---|---|
43752 | 43752 | 1925-09-05 | 2 | a-b | Second and final part of the declaration issued by Liang Qichao to friendly Western countries on the clash between British troops and Chinese people in the international settlement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101266 | 24101266 | |
43754 | 43754 | 1925-09-05 | 2 | c-d | A meeting of the Political Consultation Assembly (can zheng yuan) in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101266 | 24101266 | |
43755 | 43755 | 1925-09-05 | 2 | d | Orders issued by the provisional government in Beijing on the establishment of a campus of Paris University, and appointment of other officials. | China | http://trove.nla.gov.au/newspaper/page/24101266 | 24101266 | |
43756 | 43756 | 1925-09-05 | 3 | a-b | A new proposal for united government of nine provinces in China (Sichuan, Guizhou, Hubei, Jiangxi, Anhui, Henan, Shanxi, Shaanxi and Gansu). | China | http://trove.nla.gov.au/newspaper/page/24101265 | 24101265 | |
43757 | 43757 | 1925-09-05 | 3 | b | Governments in Guangzhou and Beijing coordinate their foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24101265 | 24101265 | |
43759 | 43759 | 1925-09-05 | 3 | c-d | British policy on the solution to the May 30 Massacre in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101265 | 24101265 | |
43762 | 43762 | 1925-09-05 | 5 | c | British missionary is kidnapped in Mianzhu county, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101267 | 24101267 | |
43765 | 43765 | 1925-09-05 | 5 | c | Textile workers on strike in Tianjin. Protest gathering in the Chinese police office in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101267 | 24101267 | |
43769 | 43769 | 1925-09-05 | 6 | b | Typhoon in Lyukyu Islands and the damages. | China | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43770 | 43770 | 1925-09-05 | 6 | b | British and Indian soldiers in Guangzhou are involved in the battle. | China | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43771 | 43771 | 1925-09-05 | 6 | b | Guangzhou authority apologise to Japan for accidentally shooting at Japanese soldiers. | China | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43773 | 43773 | 1925-09-05 | 6 | c | Strike in Shanghai has closed two newspapers in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43774 | 43774 | 1925-09-05 | 6 | c | Students in Beijing to resume their class. | China | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43789 | 43789 | 1925-09-05 | 7 | d | British and Chinese businessmen have a joint meeting in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101269 | 24101269 | |
43790 | 43790 | 1925-09-05 | 7 | d | Japanese ambassador lodges protest to the Chinese authority for the case of shooting in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101269 | 24101269 |
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]);