This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30262 | 30262 | 1915-07-10 | 7 | b | Australia news/Australian Defense Ministry decides to get the sunken German warship out of sea. Australian government designates donation dates for injured soldiers. Statistics of Australian soldiers killed and wounded in the war. | Australia | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 | |
30263 | 30263 | 1915-07-10 | 7 | a | Current news from New Zealand/ A Moli (race) lady in New Zealand passed away at age of 110. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 | |
30264 | 30264 | 1915-07-10 | 7 | a-b | Battle situation in west Europe between French, British and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 | |
30265 | 30265 | 1915-07-10 | 7 | b | Battle situation in east Europe between Austrian, German and Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 | |
30266 | 30266 | 1915-07-10 | 7 | b | Thanks for donations to this newpaper, names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094908 | 24094908 |
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]);