glam-datasets

6 rows where dataset_description = "365 catalogue records including material that has been collected from Local, State and Federal elections related to South Australian candidates. Also includes State and Federal referendums; Local elections 1879 – 2010; State elections 1893 – 2014; Federal elections 1901 – 2010; Referendums 1911 – 1999; State referendums 1965, 1970, 1982. Includes details of candidates, electorates, dates of elections, slogans. Ephemera are everyday items such as theatre posters and advertising flyers, not produced for sale. Their intrinsic value is in the information they provide about social life, the development of industries (for example, printing or paper making), and the provision of services or aspects of cultural change. Ephemera may be the only printed record of an organisation, event or activity. ", format = "CSV" and publisher = "State Library of South Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: file_title, file_modified, file_size, 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]);