data: glam-datasets: 1 row where where "dataset_issued" is on date 2014-06-24, file_description = "This open data file lists the names of non-British subjects in Queensland as recorded in the correspondence of the Chief Secretary’s Office in 1913. Information also includes birth place, naturalization, age, occupation, year of arrival, residence and police district and subdistrict. NOTE: Terms found in the records reflect the period in which they were created. As such, some words and descriptions may be culturally insensitive." and source = "data.qld.gov.au"

1 row where "dataset_issued" is on date 2014-06-24, file_description = "This open data file lists the names of non-British subjects in Queensland as recorded in the correspondence of the Chief Secretary’s Office in 1913. Information also includes birth place, naturalization, age, occupation, year of arrival, residence and police district and subdistrict. NOTE: Terms found in the records reflect the period in which they were created. As such, some words and descriptions may be culturally insensitive." and source = "data.qld.gov.au"

Search:

descending

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
348	348	Coloured and asiatic aliens in Queensland 1913	Queensland State Archives	web@archives.qld.gov.au	2014-06-24T03:26:06.579166	2022-08-09T05:37:05.975388	This index was compiled from the [correspondence](https://www.archivessearch.qld.gov.au/items/ITM862…	data.qld.gov.au	https://data.qld.gov.au/dataset/614cfd9c-3240-4f38-ac94-d2718143430f			Coloured labour and asiatic aliens in Queensland 1913	https://www.data.qld.gov.au/dataset/614cfd9c-3240-4f38-ac94-d2718143430f/resource/34eed2da-aa3f-4cca-9e14-a4a770f3ade6/download/index-to-coloured-labour-and-asiatic-aliens-in-queensland-1913.csv	CSV	This open data file lists the names of non-British subjects in Queensland as recorded in the corresp…	2014-06-24T03:38:23.182468	2022-05-31T04:52:42.070567	1048576.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]);