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 |
---|---|---|---|---|---|---|---|---|---|
30261 | 30261 | 1915-07-10 | 6 | b | Overseas Miscellany/ Firemen's Training Tower: Towers are built in American major cities for training firemen. Failure of International Famous Boxer: Zhang Chen (nnn), Indian international famous boxer, is defeated by a white boxer. | Other... | http://trove.nla.gov.au/newspaper/page/24094909 | 24094909 | |
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 | |
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]);