glam-datasets

1 row where "dataset_modified" is on date 2022-06-22 and file_description = "This open data file lists the names of Queensland dentists as taken from the correspondence of the Dental Board relating to registration from 1903 to 1932. Information also includes the letter number and Queensland State Archives' catalogue details."

✎ View and edit SQL

This data as json, CSV (advanced)

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