This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26576 | 26576 | 1912-08-17 | 3 | a | Two Americans killed in Mexico's riot. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26577 | 26577 | 1912-08-17 | 3 | a | Woman assassin of British prime minister sentenced. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26578 | 26578 | 1912-08-17 | 3 | a | Train accident in Ireland, 20 wounded. | Britain | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26579 | 26579 | 1912-08-17 | 3 | a | Epidemic widely spread in Canada, more than 200 died. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26580 | 26580 | 1912-08-17 | 3 | a | Wood factory burned down, causes damage to St. Peterburg's Palace. | Russia | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26581 | 26581 | 1912-08-17 | 3 | a | British people suffer cold weather due to snowing. | Britain | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26582 | 26582 | 1912-08-17 | 3 | a | American government agrees to revise regulations of limits on Chinese. | China | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26583 | 26583 | 1912-08-17 | 3 | b | Famous French writer kills her husband's lover in Shanghai. | France | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26584 | 26584 | 1912-08-17 | 3 | b | Different views on president's appointment of British journalist as political adviser. | China | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26585 | 26585 | 1912-08-17 | 3 | b | Italy and Turkey reopen their peace talk. | France | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26586 | 26586 | 1912-08-17 | 3 | b | Revolution spread to Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26587 | 26587 | 1912-08-17 | 3 | b | Riots in Turkey result in more than 50 killed and 100 wounded. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26588 | 26588 | 1912-08-17 | 3 | b-c | Beijing news/ President Yuan talks with Premier Lu. Premier Lu issues policy for protecting overseas Chinese. Liu Shixun left Beijing avoiding being recommended minister for foreign affairs. Jiangsu man asks president to sack army chief in Shanghai as he has his own troops there. Premier Lu reveals his policies. Chen Chunxuan might be appointed Gansu governor. Shandong governor is to return to his Guangdong hometown. Former premier rumoured to be in Shanghai planning with Sun Yat-sen and others about launching second revolution. Several Hong Kong businessmen angry of Guangdong education chief's intention of ripping off Confucius. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26589 | 26589 | 1912-08-17 | 3 | c-d | Guangdong news/Several Sun Yat-sen's supporters executed in Guangdong. Flood in Boluo, kills more than 100 people. Flood situation in various places, Guangdong. Provincial acting parliament member Su wanted by police for corruption. Acting parliament member Su defends himself, but detained for further investigation. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 |
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]);