glam-datasets

1 row where "dataset_issued" is on date 2013-06-26 and file_description = "This open data file lists the names of passengers bound for Queensland between 1922 and 1940. Information includes the age, ship, ship number, date of arrival and Queensland State Archives' catalogue details."

✎ 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

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
490 490 Immigration 1922 to 1940 Queensland State Archives web@archives.qld.gov.au 2013-06-26T01:45:19.980511 2022-06-20T03:16:37.573290 This index was compiled from the Registers of passenger lists of immigrant ships as created by the I… data.qld.gov.au https://data.qld.gov.au/dataset/34e0e222-b4da-4d8d-9512-a1d7ed80ffcd     Immigration 1922 to 1940 JSON https://www.data.qld.gov.au/dataset/34e0e222-b4da-4d8d-9512-a1d7ed80ffcd/resource/4d29094c-ae65-464b-ae6b-3e40cc458106/download/immigration-1922-1940.json JSON This open data file lists the names of passengers bound for Queensland between 1922 and 1940. Inform… 2018-09-04T04:33:18.189526 2018-09-04T00:00:00 5767168.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]);