This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29166 | 29166 | 1914-08-15 | 7 | a | Australia news/ Fewer merchant ships are arriving in Australia due to the war in Europe. Many young Australians are recruited. Australian federal government commandeer ships in Sydney. Passenger liner St Albans of Gibbs Bright & Co, is stuck in Townsville, Queensland, on its way from Sydney to Hong Kong. German warships in Samoa island. | Australia | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 |
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]);