This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31172 | 31172 | 1916-04-29 | 3 | a | Report in the Western newspaper on Generals Feng Yuxiang and Zhang Zongchang. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31173 | 31173 | 1916-04-29 | 3 | a-b | Public opinion denounces Yuan Shikai and a report from Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31174 | 31174 | 1916-04-29 | 3 | b | Salt tax in Yunnan and Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31175 | 31175 | 1916-04-29 | 3 | b-c | Yuan Shikai's troops in Chongqing, Sichuan, harass local residents. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31176 | 31176 | 1916-04-29 | 3 | c-d | The Nanhu (South Lake) Uprising in Hubei province and the report from Wuchang on the uprising. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31177 | 31177 | 1916-04-29 | 3 | e | China has another new cabinet in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31178 | 31178 | 1916-04-29 | 3 | e-f | The World War I (Portugal deports German people. Turkish army commander is killed. Triumph of the Italian army. Britain to start compulsory military service. The battles in Eastern Europe. Japan rebuffs American government on the immigration dispute. Italian troops can not go to Western Europe). | Other... | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 |
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]);