glam-datasets

1 row where dataset_description = "This index was compiled from the registers of teachers, admitted to service in schools, as kept by the Boards of Education and subsequently the Public Instruction Department from 1860 to 1905 and held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). Note: the resource has been updated with an additional 18,400 entries (August 2016).", format = "CSV", publisher = "Queensland State Archives" and source = "data.qld.gov.au"

✎ View and edit SQL

This data as json, CSV (advanced)

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