This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29141 | 29141 | 1914-08-08 | 3 | a-b | The Progressive Party (jin bu dang) meets in Beijing and their discussion on political affairs. | China | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29142 | 29142 | 1914-08-08 | 3 | b-c | The coming large-scale war (World War I) in Europe and different response of various countries (Austria, Russia, Italy, Germany, France, Britain,), market in panic and other social & political influence. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29143 | 29143 | 1914-08-08 | 3 | c | Local residents in Java and a Chinese magistrate is murdered. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29144 | 29144 | 1914-08-08 | 3 | c | Deposed Mexican president Victoriano Huerta is on the way to Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29145 | 29145 | 1914-08-08 | 3 | c | China is afraid of possible invasion of Japan during the European crisis. | Britain | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29146 | 29146 | 1914-08-08 | 3 | c | German people in Jiaozhou peninsula on high alert due to the crisis in Europe. | Britain | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29147 | 29147 | 1914-08-08 | 3 | d | Beijing news/ Seven revolutionary rebels are arrested in Qingdao and escorted to Beijing. Photograph of the chieftain of the bailang bandits. Flood in Nan'an, of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 |
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]);