glam-datasets

3 rows where dataset_description = "Newspaper articles relating to Sir Ross Smith and the 1919 Epic Flight from England to Australia. Datasets are divided into themes of prelude to the epic flight, the epic flight and death and funeral of Sir Ross Smith. Articles are sourced from South Australian newspapers *The Advertiser*, *Daily Herald*, *The Observer* and *The Register*.", format = "CSV" and publisher = "State Library of South Australia" sorted by info_url

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), start_date (date), end_date (date), file_created (date), file_modified (date)

CREATE TABLE [glam-datasets] (
   [dataset_title] TEXT,
   [publisher] TEXT,
   [author] TEXT,
   [dataset_issued] TEXT,
   [dataset_modified] TEXT,
   [dataset_description] TEXT,
   [source] TEXT,
   [info_url] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [file_title] TEXT,
   [download_url] TEXT,
   [format] TEXT,
   [file_description] TEXT,
   [file_created] TEXT,
   [file_modified] TEXT,
   [file_size] TEXT,
   [licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
    ON [glam-datasets] ([source], [publisher], [format], [licence]);