data: glam-datasets: 1 row where where "dataset_modified" is on date 2022-06-20, "file_created" is on date 2018-09-03, licence = "Creative Commons Attribution 4.0" and publisher = "Queensland State Archives"

1 row where "dataset_modified" is on date 2022-06-20, "file_created" is on date 2018-09-03, licence = "Creative Commons Attribution 4.0" and publisher = "Queensland State Archives"

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
454	454	Australian South Sea Islanders 1867 to 1908	Queensland State Archives	web@archives.qld.gov.au	2014-06-25T04:29:57.438596	2022-06-20T13:07:35.777233	This index was compiled from a wide variety of government records detailing the administration of th…	data.qld.gov.au	https://data.qld.gov.au/dataset/eae0afa9-681c-4bda-b335-fa0c53ddec96			South Sea Islanders 1867 to 1908 combined JSON	https://www.data.qld.gov.au/dataset/eae0afa9-681c-4bda-b335-fa0c53ddec96/resource/97a637a1-2d63-462f-ae8b-d95cf6f5bd04/download/south-sea-islanders-1867-1908.json	JSON	Note: JSON data set is experimental. Use CSV resource in case of errors. This open data file lists …	2018-09-03T00:56:54.266593	2018-09-03T00:56:54.165782	24641536.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]);