data: glam-datasets: 1 row where where file_description = "This series comprises correspondence files relating to requests, lodged by various State Schools, for supplies, requisitions, equipment and building facilities (including furniture, teaching materials, lighting, teacher accommodation, etc). The files also include correspondence relating to the acquisition of land for the establishment or extension of schools, the opening or closure of state schools, etc. Other items attached to the correspondence include rough development plans, costings and briefs, notices of permanent road closures, letters of complaint, etc. The files contain correspondence between various authorities, namely: the Director-General of Education, Teachers and Principles of the schools concerned, the Department of Administrative Services, the Minister for Education, the Minister for Land Management, the Resources Management Directorate, Shire Councils, Crown Solicitor and the Parliamentary Commission for Administrative Investigations.", "file_modified" is on date 2018-09-04 and source = "data.qld.gov.au"

1 row where file_description = "This series comprises correspondence files relating to requests, lodged by various State Schools, for supplies, requisitions, equipment and building facilities (including furniture, teaching materials, lighting, teacher accommodation, etc). The files also include correspondence relating to the acquisition of land for the establishment or extension of schools, the opening or closure of state schools, etc. Other items attached to the correspondence include rough development plans, costings and briefs, notices of permanent road closures, letters of complaint, etc. The files contain correspondence between various authorities, namely: the Director-General of Education, Teachers and Principles of the schools concerned, the Department of Administrative Services, the Minister for Education, the Minister for Land Management, the Resources Management Directorate, Shire Councils, Crown Solicitor and the Parliamentary Commission for Administrative Investigations.", "file_modified" is on date 2018-09-04 and source = "data.qld.gov.au"

Search:

descending

Link	rowid ▼	dataset_title	publisher	author	dataset_issued	dataset_modified	dataset_description	source	info_url	start_date	end_date	file_title	download_url	format	file_description	file_created	file_modified	file_size	licence
386	386	Corporate School Files - Works/Facilities (Works Establishment Files) 1871-1998	Queensland State Archives	web@archives.qld.gov.au	2018-02-23T04:52:49.138137	2022-06-28T22:57:56.916661	This series comprises correspondence [files](https://www.archivessearch.qld.gov.au/series/S53) relat…	data.qld.gov.au	https://data.qld.gov.au/dataset/c1d5bf09-e06d-49ab-9d84-290840574971			Corporate School Files - Works/Facilities (Works Establishment Files) 1871-1998 JSON	https://www.data.qld.gov.au/dataset/c1d5bf09-e06d-49ab-9d84-290840574971/resource/625b5c8f-53a3-4499-ae7b-75d80b6d2ff4/download/corporate-school-files-works-estblishment-1871-1998.json	JSON	This series comprises correspondence files relating to requests, lodged by various State Schools, fo…	2018-09-04T04:21:03.553191	2018-09-04T04:21:03.453273	2202009.0	Creative Commons Attribution 4.0

Advanced export

JSON shape: default, array, newline-delimited

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