This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
42841 | 42841 | 1925-03-14 | 3 | d | Japanese parliament debates the disarmament proposal and their Russia policy. | Japan | 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 | |
42843 | 42843 | 1925-03-14 | 3 | d | Election of Chancellor in Germany. Funeral of the late German Chancellor. | Germany | 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 | |
42845 | 42845 | 1925-03-14 | 3 | e | Religious riots in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
42846 | 42846 | 1925-03-14 | 3 | f | A Russian farmer organises secret society. | Britain | 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 | |
42848 | 42848 | 1925-03-14 | 3 | f | American naval fleet on the way to visit Australia. | America | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 |
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]);