This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30552 | 30552 | 1915-10-09 | 3 | b | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095010 | 24095010 | |
30553 | 30553 | 1915-10-09 | 3 | b | Battle situation in west Europe between German, British and French troops. | Germany | http://trove.nla.gov.au/newspaper/page/24095010 | 24095010 | |
30562 | 30562 | 1915-10-09 | 6 | b | Beijing news (continued)/ Liang Qicao is to publish an article to oppose the act of the Imperial System Restoring Preparation Association on changing Chinese political system. Vice president Li Yuanhong is assumed to resign due to issue of restoring imperial system. Duan Qirei, general commander of ground troops in China, determines to resign due to his objection to restoring imperial system. Tornado in Shanghai has led to huge loss. | China | http://trove.nla.gov.au/newspaper/page/24095015 | 24095015 | |
30564 | 30564 | 1915-10-09 | 7 | b | Europe War/ Russia sends an Ultimate letter to Bulgaria, demanding it reply within 24 hours. | Britain | http://trove.nla.gov.au/newspaper/page/24095014 | 24095014 |
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]);