glam-datasets

2 rows where dataset_description = "This index was created from the [Register of immigrants by ship and destination](https://www.archivessearch.qld.gov.au/series/S7455), by the Immigration Agent Toowoomba, 1880 to 1888 held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). The register contains names of immigrants, date of admittance at Toowoomba, name of ship upon which they made the passage to Australia, destination from Toowoomba and date of leaving. Note many of the immigrants listed in this register originate from Ireland. " and publisher = "Queensland State Archives"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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]);