This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29632 | 29632 | 1915-01-30 | 2 | a-b | Comment: China's diplomacy is in dilemma. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29633 | 29633 | 1915-01-30 | 2 | b | President's orders/ The penalty regulations on bandits are approved. | China | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29634 | 29634 | 1915-01-30 | 2 | c | Mirror on theories of restoring imperial system (continued)/ Nao Neixuan's letter to Zhou Yushan and Xu Shichang on restoring imperial system. | China | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29637 | 29637 | 1915-01-30 | 2 | b | Russian troops defeat German troops several times in Jia Li Sa (ppp), Portland. Austrian troops suffered a great loss. | Russia | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29638 | 29638 | 1915-01-30 | 2 | b-c | Defeated Turkish troops are stricken by heavy snow and suffered huge loss. | Russia | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29639 | 29639 | 1915-01-30 | 2 | c | Large Turkish troops are attacking Egypt. | Britain | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29640 | 29640 | 1915-01-30 | 2 | c | Some German airships and planes are attacking British cities resulting in casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29641 | 29641 | 1915-01-30 | 2 | c | Paris is in dark by light control in enemy planes' attack. | France | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29642 | 29642 | 1915-01-30 | 2 | c | German military minister and financial minister resign. | Other... | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29643 | 29643 | 1915-01-30 | 2 | c-d | German-Austrian troops attack Servile. | Other... | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29644 | 29644 | 1915-01-30 | 2 | d | German troops start another attack in Belgium against British troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29645 | 29645 | 1915-01-30 | 2 | d | Rumours spread that more German airships come to attack Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 | |
29646 | 29646 | 1915-01-30 | 2 | d | French troops are fighting against German troops in West Europe, winning a number of battles. | France | http://trove.nla.gov.au/newspaper/page/24094704 | 24094704 |
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]);