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 |
---|---|---|---|---|---|---|---|---|---|
42831 | 42831 | 1925-03-14 | 2 | b-c | The southwestern provinces in China may unite themselves together. | China | http://trove.nla.gov.au/newspaper/page/24101062 | 24101062 | |
42832 | 42832 | 1925-03-14 | 2 | c | Radical Nationalist Party (Guomindang) members in Guangzhou and their anti-foreign sentiment. | China | http://trove.nla.gov.au/newspaper/page/24101062 | 24101062 | |
42834 | 42834 | 1925-03-14 | 2 | c-d | Sun Yatsen's envoy to Hunan province Chen Shou is besieged in the capital Changsha | China | http://trove.nla.gov.au/newspaper/page/24101062 | 24101062 | |
42835 | 42835 | 1925-03-14 | 2-3 | d-a | Guangdong legislature assembly supports the united provincial government. | China | http://trove.nla.gov.au/newspaper/page/24101062 | 24101062 | |
42836 | 42836 | 1925-03-14 | 3 | a-b | Chamber of commerce in Shanghai contact Zhang Zongchang and others for peace effort. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42837 | 42837 | 1925-03-14 | 3 | b | People in Shanghai are afraid of possible conflict between Zhang Zongchang and Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42838 | 42838 | 1925-03-14 | 3 | b-c | Banks in Shanghai and their profit in 1924. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42839 | 42839 | 1925-03-14 | 3 | c | Programme for the national congress in Beijing to deal with the aftermath (shan hou hui yi). | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42840 | 42840 | 1925-03-14 | 3 | c | News in brief/ The national congress in Beijing in order to deal with the aftermath (shan hou hui yi), and involvement of Duan Qirui, Xu Shiying and others. Sun Chuanfang and Zhang Zongchang in Shanghai. Bandits in Enping county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42842 | 42842 | 1925-03-14 | 3 | d | American ambassador demands China to return the ship detained in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42844 | 42844 | 1925-03-14 | 3 | e | Japanese ambassador in Beijing reassure their privileges in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42847 | 42847 | 1925-03-14 | 3 | f | Why the American ship is detained in Guangdong and the report. | China | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42850 | 42850 | 1925-03-14 | 6 | a-b | Second and final part of a telegram from Kang Youwei to Duan Qirui in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101066 | 24101066 | |
42862 | 42862 | 1925-03-14 | 7 | c | Soviet Russian government withdraws their Red Army from outer Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 |
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]);