glam-datasets

1 row where dataset_description = "A unique collection of original maps and plans created by real estate firms from 1850s to mid 1900s from the State Library of Queensland. The first version of this dataset includes descriptive information and links for 165 digitised maps. The February 2018 version includes descriptions, geographic coordinates and links for 798 digitised maps. Estate maps can give information about land subdivisions, including how the land was subdivided, when it was first auctioned, who the surveyors were and who sold the land. They are useful for investigating the history of urban land areas. The maps are predominantly from Brisbane but also cover some regional areas of Queensland such as the Gold and Sunshine Coasts.", format = "XML", publisher = "State Library of Queensland" and source = "data.qld.gov.au" sorted by file_size

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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]);