glam-datasets

2 rows where dataset_description = "In the period October 1866 to June 1876, the appointments and removals of employees of the Traffic Branch of Queensland Southern and Western Railway were published in the 1876 (vol. 3) edition of the Queensland Legislative Assembly Votes & Proceedings. These indexes collect the names of those employees and present them in two alphabetical listings, one for appointments and one for removals.", format = "CSV" and licence = "Creative Commons Attribution 3.0"

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