glam-datasets

1 row where author = "info@archives.qld.gov.au", file_description = "This open data file lists the names of patients who died at the Brisbane Hospital during the period 1899 to 1913. Information also includes the age, number, date of death and is taken from Queensland State Archives' S10817 [Registers of Deaths and Special Removals](https://www.archivessearch.qld.gov.au/series/S10817) " and publisher = "Queensland State Archives"

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