This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31178 | 31178 | 1916-04-29 | 3 | e-f | The World War I (Portugal deports German people. Turkish army commander is killed. Triumph of the Italian army. Britain to start compulsory military service. The battles in Eastern Europe. Japan rebuffs American government on the immigration dispute. Italian troops can not go to Western Europe). | Other... | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31183 | 31183 | 1916-04-29 | 7 | c | More report on the World War I (arms smuggling in Ireland. Chaos in Ireland. Population in Russia and its components). | Other... | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 |
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]);