glam-datasets

1 row where dataset_description = "This series comprises District Inspectors' reports on schools, copies of which were kept by the Department of Public Instruction (after 1957 known as the Department of Education), and the schools: a copy of each Inspection Report was sent to the school and to the Department. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). Each pro - forma Inspection Report includes the school name, the school number, the class being assessed, the date of the inspection in full, and the total number of male and female students present. There is also an assessment of the school according to the following categories: 1. school administrative records; 2. school 'government ' or discipline; 3. organization, which includes sufficient accommodation, classification of pupils, teaching standard and experience; 5. proficiency and progress of pupils; 6. care of grounds; 7. school, games and physical exercise; 8. general conditions; and 9. general remarks. Education Regional Districts are: Brisbane South, Brisbane North, Brisbane West, Central Queensland, Darling Downs, Wide Bay, South West, North West and Northern [this includes the Islands of the Torres Strait].", "file_created" is on date 2018-09-04, format = "JSON" 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]);