1 row where dataset_description = "These files held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives) record the particulars of travel of nominated/sponsored immigrants who came to Queensland between 1947 and 1976. Each file may include: a nominal roll of assisted passage migrants (passenger list), luggage lists, notes of passenger travel arrangements after arrival, correspondence on payment of rail fares, and welfare officers report on meeting ship. The passenger lists include: name of passenger (nominated immigrants), age, religion, occupation, country / place of origin, name of ship or flight number of aircraft, date of arrival, and name and address of nominator. For the majority of the aircraft files only the passenger list for the flight is included on the file. The files are arranged in chronological order by the date of arrival of the ship or aircraft. While each ship has a separate file for each voyage, the aircraft files include passenger lists for several months or a period of one year.", "dataset_modified" is on date 2022-06-29, format = "JSON", licence = "Creative Commons Attribution 4.0", publisher = "Queensland State Archives" and source = "data.qld.gov.au"

View and edit SQL

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

source

  • data.qld.gov.au · 1

publisher

  • Queensland State Archives · 1

licence

  • Creative Commons Attribution 4.0 · 1

format

  • JSON · 1

dataset_modified (date)

  • 2022-06-29 · 1
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
378 Migrant Ship and Aircraft files 1947-1976 Queensland State Archives web@archives.qld.gov.au 2018-02-23T04:47:50.201505 2022-06-29T01:27:11.646654 These files held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/arc… data.qld.gov.au https://data.qld.gov.au/dataset/c3746e58-0ba7-4b18-888c-dab4840937f2     Migrant Ship and Aircraft files 1947-1976 JSON https://www.data.qld.gov.au/dataset/c3746e58-0ba7-4b18-888c-dab4840937f2/resource/c8ea29b4-ff72-4340-bca7-3ba0ad406c77/download/migrant-ship-and-aircraft-files-1947-1976.json JSON Note: JSON data set is experimental. Use CSV resource in case of errors. These files record the par… 2018-09-03T23:44:27.247409 2018-09-03T23:44:27.159580 408576.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]);