1 row where "dataset_issued" is on date 2015-07-01, file_description = "This open data file alphabetically lists the names of teachers registered by the Boards of Education and subsequently the Public Instruction Department from 1860 to 1905. Information also includes volume, page number and Queensland State Archives’ catalogue details. " and source = "data.qld.gov.au"

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)

source

  • data.qld.gov.au · 1

format

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
369 Teachers 1860 to 1905 Queensland State Archives web@archives.qld.gov.au 2015-07-01T04:19:08.161316 2022-06-29T02:19:11.161781 This index was compiled from the registers of teachers, admitted to service in schools, as kept by t… data.qld.gov.au https://data.qld.gov.au/dataset/ca2bf49a-6f27-47b9-8be8-7f09649b97a7     Teachers 1860 to 1905 https://www.data.qld.gov.au/dataset/ca2bf49a-6f27-47b9-8be8-7f09649b97a7/resource/89c60504-76f5-4a71-98e6-9179c87b1a91/download/combined-teachers-1860-1905.csv CSV This open data file alphabetically lists the names of teachers registered by the Boards of Education… 2015-07-01T04:21:24.083543 2022-04-19T01:30:05.249200 7654604.0 Creative Commons Attribution 4.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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