This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29007 | 29007 | 1914-07-04 | 3 | a-b | The Political Consulting Committee (zheng shi tang) in Beijing discusses political reform in China. | China | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29008 | 29008 | 1914-07-04 | 3 | b | Report in Hong Kong newspaper on the flood in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29009 | 29009 | 1914-07-04 | 3 | b | Funeral of an Austrian pilot in Vienna. Another flying test in Vienna. | Other... | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29010 | 29010 | 1914-07-04 | 3 | b | George Morrison, adviser to the Chinese President, talks Chinese politics in London. | Britain | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29011 | 29011 | 1914-07-04 | 3 | c | Mutiny troops in Jurongguan, northwest of Beijing, commit looting and rape. | China | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29012 | 29012 | 1914-07-04 | 3 | c | French is declining and the signs. Budget for French navy. | Britain | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29013 | 29013 | 1914-07-04 | 3 | c | British naval fleet comes to visit Russia and the welcome. | Britain | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29014 | 29014 | 1914-07-04 | 3 | c | Earthquake in Sumatra. | Other... | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29015 | 29015 | 1914-07-04 | 3 | c-d | Beijing news/ Yuan Shikai and Xu Shichang reach agreement on the presidential government system. Obstacles to the currency reform in China. President Yuan Shikai invites Chinese and foreign guests to see the portraits of the past emperors in the Forbidden City. Russian ambassador demands railway from China. Britain demands oil resources in Sichuan province. Bandits in Shaanxi province. Russian authority deports yellow-race labourers. | China | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 | |
29028 | 29028 | 1914-07-04 | 3 | b | King of Serbia abdicates the throne to his son. | Other... | http://trove.nla.gov.au/newspaper/page/24093163 | 24093163 |
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]);