This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43051 | 43051 | 1925-04-25 | 2 | b-d | Second part of the declaration issued by Duan Qirui on national construction. | China | http://trove.nla.gov.au/newspaper/page/24101110 | 24101110 | |
43052 | 43052 | 1925-04-25 | 2 | d | Women's association set up in Beijing with a purpose to promote national unification. | China | http://trove.nla.gov.au/newspaper/page/24101110 | 24101110 | |
43053 | 43053 | 1925-04-25 | 2-3 | d-a | Duan Qirui and the national conference (shan hou hui yi) in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101110 | 24101110 | |
43054 | 43054 | 1925-04-25 | 3 | a-b | Zhang Zuolin is preparing for the war with Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24101109 | 24101109 | |
43055 | 43055 | 1925-04-25 | 3 | b | Zhao Hengti prepares to entertain Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101109 | 24101109 | |
43056 | 43056 | 1925-04-25 | 3 | b-c | Guangdong situation and its possible change after the death of Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24101109 | 24101109 | |
43057 | 43057 | 1925-04-25 | 3 | c-d | Anarchist party in Guangzhou and their relation with the communists. | China | http://trove.nla.gov.au/newspaper/page/24101109 | 24101109 | |
43067 | 43067 | 1925-04-25 | 5 | c | Panchen Lama is ill in Beijing and the report. | China | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43072 | 43072 | 1925-04-25 | 6 | c | Union representatives in Beijing plead for expulsion of communist members. | China | http://trove.nla.gov.au/newspaper/page/24101114 | 24101114 | |
43080 | 43080 | 1925-04-25 | 7 | b | Bandits in Guangdong. Hotel accommodation in Hong Kong is not safe. Feng Yuxiang's troops in Beijing. Long Jiguang dies in Beijing. Duan Zhigui dies in Tianjin. State funeral prepared for Sun Yatsen. Zhongshan Park in Beijing where Sun Yatsen's coffin lies. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43081 | 43081 | 1925-04-25 | 7 | b-c | Military news from Dongjiang area, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43082 | 43082 | 1925-04-25 | 7 | c | Lin Hu's troops arrive Wongyuan county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 |
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]);