glam-datasets
2 rows 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 source = "data.qld.gov.au"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 485 | 485 | 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 | https://www.data.qld.gov.au/dataset/eea439b1-f2c9-4ee3-858f-e4583b52f344/resource/fbdbc235-45c3-4f55-96c4-29acfdd04c86/download/oronsay-immigration-1925-1972.csv | CSV | This open data file lists the names of nominated and assisted immigrants who sailed for Queensland o… | 2015-05-28T05:32:02.763698 | 2022-06-20T04:03:09.350371 | 2097152.0 | Creative Commons Attribution 4.0 | ||
| 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
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]);