glam-datasets

1 row where file_description = "This open data file lists the names of immigrants nominated or sponsored to immigrate to Queensland between 1908 and 1922. Information includes the age, year, ship, source card name and Queensland State Archives' catalogue details.", "file_modified" is on date 2018-09-04 and publisher = "Queensland State Archives"

✎ View and edit SQL

This data as json, CSV (advanced)

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

source

publisher

  • Queensland State Archives · 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
449 449 Card index to nominated immigrants 1908 to 1922 Queensland State Archives web@archives.qld.gov.au 2013-06-26T01:03:31.341446 2022-06-20T16:24:56.754087 This index was compiled from the [Card index](https://www.archivessearch.qld.gov.au/series/S5611) to… data.qld.gov.au https://data.qld.gov.au/dataset/74de1b90-7a77-48ec-b8ef-05cd0eff1e23     Nominated immigrants 1908 to 1922 JSON https://www.data.qld.gov.au/dataset/74de1b90-7a77-48ec-b8ef-05cd0eff1e23/resource/2243a54a-2cd4-4afd-8532-68acecbd683a/download/nominated-immigrants-1908-1922.json JSON This open data file lists the names of immigrants nominated or sponsored to immigrate to Queensland … 2018-09-04T05:44:43.139850 2018-09-04T05:44:43.051816 39845888.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]);