This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25909 | 25909 | 1912-03-23 | 3 | b | A terrifying news of shooting the judges | A convict with his partner shot three judges in one of the American courts and escaped. | America | http://trove.nla.gov.au/newspaper/page/24092173 | 24092173 |
25910 | 25910 | 1912-03-23 | 3 | b | A military riot in Shanxi | A troop in Datong, Shanxi province, rebelled; no details provided. | Japan | http://trove.nla.gov.au/newspaper/page/24092173 | 24092173 |
25911 | 25911 | 1912-03-23 | 3 | b | The Qing prince appears again | The abdicated Qing prince in Shanxi declared to be the emperor of China and issued imperial edicts to various places. | China | http://trove.nla.gov.au/newspaper/page/24092173 | 24092173 |
25912 | 25912 | 1912-03-23 | 3 | b | Record of strikes in Britain | The coal miners' strike in Britain is still on, leading to heavy loss of railways and exports. Negotiations between the capital and the labour party failed. | Britain | http://trove.nla.gov.au/newspaper/page/24092173 | 24092173 |
25918 | 25918 | 1912-03-23 | 7 | b | Interesting overseas news | Statistics show that India ranks the first in the world in number of people killed by furious animals and snakes. Four Chinese women got lost in Paris and police there offerred helps to them. A Japanese went to America to investigate the way of raising chichen. | Other... | http://trove.nla.gov.au/newspaper/page/24092177 | 24092177 |
25922 | 25922 | 1912-03-23 | 8 | b | Businessmen in Hankou demand compensation for loss in wars | Businessmen in Hankou wrote a letter to presidents of the Republic , which urges Qing government to compensate for their loss in wars. | China | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
25923 | 25923 | 1912-03-23 | 8 | b | Prices in Japan | Deflation in Japan widespead since the revolution of China as its exports to China decreased sharply. | Japan | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
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]);