This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29122 | 29122 | 1914-08-01 | 3 | b-c | Beijing news/ Chinese President Yuan Shikai talks his major policy. Chinese government to revise the etiquette. The Progressive Party (jin bu dang) and their anniversary celebration. Japanese authority might deport Sun Yatsen. Japan changes its policy towards the Chinese rebels. Town is flooded in Pingxiang, of Hubei province and the report. Rebels arrested in Shandong province and their confession. | China | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
29126 | 29126 | 1914-08-01 | 6 | b-c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093200 | 24093200 | |
29132 | 29132 | 1914-08-01 | 7 | b-c | Austrian archduke Francis Ferdinand and his wife, Sophie, are shot dead in the Bosnian capital, Sarajevo. Austrians send ultimate to Serbs. Austrian and Serbs suspend their diplomatic relations. The ultimate are refused. A large-scale war (World War I) breaks out in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24093199 | 24093199 |
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]);