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 |
---|---|---|---|---|---|---|---|---|---|
30910 | 30910 | 1916-01-22 | 3 | b | Yuan Shikai is to come to throne despite the revolution in Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30911 | 30911 | 1916-01-22 | 3 | b | An assassination on Japanese premier failed. | Japan | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30912 | 30912 | 1916-01-22 | 3 | b | Mexican riot people killed Americans and American ex-president Roosevelt demands to send troops to Mexico. | America | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30913 | 30913 | 1916-01-22 | 3 | b | Turkish people claim that the Ally troops suffer heavy loss during retreating. | Other... | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30914 | 30914 | 1916-01-22 | 3 | b | A British warship is sunken by a sea-bomb without personnel loss. | Britain | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30915 | 30915 | 1916-01-22 | 3 | b | Turkish troops invade Persia. | Britain | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30916 | 30916 | 1916-01-22 | 3 | b | German emperor is said to suffer serious illness. | Other... | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30923 | 30923 | 1916-01-22 | 6 | b | News miscellany/Liang Qichao is to go to America for treatment. Li Yuanhong decides to resign. Beijing hangs flags celebrating Yuan Shikai's coming to throne. Yuan Shikai claims to save China by sacrificing his life and his offspring. | China | http://trove.nla.gov.au/newspaper/page/24095122 | 24095122 | |
30924 | 30924 | 1916-01-22 | 6 | b | A satire story on the new emperor in China. | Other... | http://trove.nla.gov.au/newspaper/page/24095122 | 24095122 | |
30926 | 30926 | 1916-01-22 | 7 | b | America Trade Association advocates all trade associations in the world to promote peace process. | America | http://trove.nla.gov.au/newspaper/page/24095121 | 24095121 | |
30927 | 30927 | 1916-01-22 | 7 | b | American businessmen are allowed to manage railways in China by Chinese government. | Other... | http://trove.nla.gov.au/newspaper/page/24095121 | 24095121 |
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]);