glam-datasets

10 rows where dataset_description = "Directory of names, addresses, opening hours, contacts, and geographic coordinates for all the public library branches in Queensland. Public library branches in Queensland keep their directory details up to date on the Public Libraries Connect Directory. This data populates a map and a searchable directory for users to find their local library. The dates of creation and last update are included to assess currency of information. https://plconnect.slq.qld.gov.au/directory The Public Libraries Connect website provides more information about public library services in Queensland. http://plconnect.slq.qld.gov.au/"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: file_description, dataset_issued (date), dataset_modified (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]);