This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29425 | 29425 | 1914-11-28 | 3 | c-d | Miscellaneous report on the World War I (German submarine fires at British warship, French bulletin on the war, British victory in the Persia Gulf, German celebrate their victory, loss of German troops, Italy may be involved in the war, religion in the war, battles between German and Russian troops). | Other... | http://trove.nla.gov.au/newspaper/page/24093337 | 24093337 | |
29429 | 29429 | 1914-11-28 | 6 | c | Revolutionary army in Mexico seeks truce in force | Other... | http://trove.nla.gov.au/newspaper/page/24093342 | 24093342 | |
29431 | 29431 | 1914-11-28 | 7 | b-c | Miscellaneous report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24093341 | 24093341 |
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]);