glam-datasets

2 rows where dataset_description = "A historical index of the Queensland Police Gazette Inquests records from 1875-1885. Inquests were conducted by the coroner to gather information about the cause and circumstances of a death. Reports relating to deaths were compiled by police officers and forwarded to the coroner, who decided whether an inquest was necessary. This dataset was created from an index of those reports of deaths about which an inquest was held, corrected and enhanced in 2021. The reports include name or surname and given names of the deceased, location of death, a note of other details (i.e. cause of death, date of death, age at death, occupation, etc.), and the date and page of gazette in which it was reported, and the citation of any other published resources consulted. Search the index at the State Library of Queensland in the Family History Indexes on One Search, the library catalogue: http://onesearch.slq.qld.gov.au/", dataset_issued = "2020-04-03T05:08:36.402383", format = "CSV", licence = "Creative Commons Attribution 4.0" and source = "data.qld.gov.au"

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