glam-datasets

1 row where author = "web@archives.qld.gov.a", file_description = "This open data file lists the names of immigrants and nominators as recorded in the registers for nominated passage kept by the Assistant Immigration Agent, Maryborough. It also includes the names of immigrants from Europe as recorded in the correspondence and papers for nominated passage kept by the Assistant Immigration Agent, Maryborough. Details include the type of nomination, the certificate number, the date and Queensland State Archives' catalogue details." and source = "data.qld.gov.au"

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