2 rows where dataset_description = "This index was created from various records detailing the names of those who took oaths of allegiance to be naturalised as created by the Supreme Court across Queensland as well as the Colonial Secretary's Office and the Government Residents Office and the Queensland Government Gazette. The records are held at [Queensland State Archives](https://www.qld.gov.au/recreation/arts/heritage/archives).", "dataset_issued" is on date 2013-03-04 and format = "CSV"

View and edit SQL

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
354 Naturalisations Queensland State Archives web@archives.qld.gov.au 2013-03-04T04:49:28.828542 2022-08-09T05:34:57.545449 This index was created from various records detailing the names of those who took oaths of allegianc… data.qld.gov.au https://data.qld.gov.au/dataset/91970fa7-d3c3-4171-a89d-410481cb90e9     Naturalisations 1880-1885 https://www.data.qld.gov.au/dataset/91970fa7-d3c3-4171-a89d-410481cb90e9/resource/dd7cd070-c807-49a2-9962-76f603ad3587/download/naturalisations-1880-1885-.csv CSV This resource records the entries from the Queensland Government Gazette relating to nationalisati… 2021-01-19T04:38:21.632406 2021-01-19T04:38:21.550691 1048576.0 Creative Commons Attribution 4.0
355 Naturalisations Queensland State Archives web@archives.qld.gov.au 2013-03-04T04:49:28.828542 2022-08-09T05:34:57.545449 This index was created from various records detailing the names of those who took oaths of allegianc… data.qld.gov.au https://data.qld.gov.au/dataset/91970fa7-d3c3-4171-a89d-410481cb90e9     Naturalisations 1851 to 1908 https://www.data.qld.gov.au/dataset/91970fa7-d3c3-4171-a89d-410481cb90e9/resource/7b5ddae5-78ef-4d8e-b800-56e6f30d26d5/download/naturalisations-1851-1908-.csv CSV This open data file lists the names of those who took oaths of allegiance to be naturalised as Briti… 2013-03-03T23:42:56.433493 2022-05-17T04:23:53.559707 9017753.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]);