glam-datasets

1 row where "dataset_modified" is on date 2022-06-22, file_description = "The open data file lists the names of patients admitted to the Brisbane Hospital for the period 1872 to 1887. Information includes the date of admission, page number and Queensland State Archives' [catalogue](https://www.archivessearch.qld.gov.au/) details." and publisher = "Queensland State Archives"

✎ 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]);