This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26118 | 26118 | 1912-05-11 | 3 | a | Italy-Turkey war | Turkey claims its victory on Italian troops in a battle and Italy says it's navy use balloon to attack Turkish troops. | Other... | http://trove.nla.gov.au/newspaper/page/24092231 | 24092231 |
26208 | 26208 | 1912-06-01 | 3 | a | Italy-Turkey war | Italian troops occupied almost all Turkish islands and Turkish troops retreated inland, | Russia | http://trove.nla.gov.au/newspaper/page/24092255 | 24092255 |
26284 | 26284 | 1912-06-15 | 3 | a | Italy-Turkey war | Italian air force bombed Turkish army camps. | Other... | http://trove.nla.gov.au/newspaper/page/24092271 | 24092271 |
26292 | 26292 | 1912-06-15 | 3 | b | Italy-Turkey war | Italian troops have another attack on Turkish army. | Britain | http://trove.nla.gov.au/newspaper/page/24092271 | 24092271 |
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]);