This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30238 | 30238 | 1915-07-03 | 7 | a-b | Australia news/ Australian Defense Minister expresses his concerns on current war situation and praises support of Australian people and soldiers in the war. Statistics of Australian soldiers killed and wounded in the war. A Japanese training warship comes to Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30239 | 30239 | 1915-07-03 | 7 | b | Statistics show that France spends 2,000 pounds of money every minute in the war. | France | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30240 | 30240 | 1915-07-03 | 7 | b | New Zealand government plans to levy tax for war expenses. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30241 | 30241 | 1915-07-03 | 7 | b | Statistics of soldiers killed and warships lost in the war from all warring nations. | Canada | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30242 | 30242 | 1915-07-03 | 7 | b | The anniversary ceremony for memorising Austrian prince murdered is held both in Austria and Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30243 | 30243 | 1915-07-03 | 7 | b-c | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 |
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]);