glam-datasets

1 row where dataset_description = "This index of nominated and assisted immigrants was compiled from various records created by the Immigration Department and the State Migration Office relating to voyages of the Oronsay between 1925 and 1972. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). ", "dataset_modified" is on date 2022-06-20 and format = "JSON"

✎ 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

  • JSON · 1 ✖

dataset_description ✖

  • This index of nominated and assisted immigrants was compiled from various records created by the Immigration Department and the State Migration Office relating to voyages of the Oronsay between 1925 and 1972. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives). · 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
486 486 Oronsay immigration 1925 to 1972 Queensland State Archives web@archives.qld.gov.au 2015-05-28T05:28:02.659648 2022-06-20T04:03:14.679628 This index of nominated and assisted immigrants was compiled from various records created by the Imm… data.qld.gov.au https://data.qld.gov.au/dataset/eea439b1-f2c9-4ee3-858f-e4583b52f344     Oronsay immigration 1925 to 1972 JSON https://www.data.qld.gov.au/dataset/eea439b1-f2c9-4ee3-858f-e4583b52f344/resource/e590bab9-6417-4843-b4c1-a9b4f29a91ce/download/oronsay-immigration-1925-1972.json JSON NOTE: JSON data set is experimental. Use CSV resource in case of errors. This open data file lists … 2018-08-30T02:11:58.505089 2018-08-30T02:14:02.414858 2621440.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]);