1 row where "file_modified" is on date 2018-09-05 and file_size = "2097152.0"

View and edit SQL

Suggested facets: dataset_issued (date), dataset_modified (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
436 Register of lands 1861 to 1868 Queensland State Archives web@archives.qld.gov.au 2014-01-05T23:21:57.845903 2022-06-22T02:14:05.889263 This index was created from the [Register of Lands, 1861-1867](https://www.archivessearch.qld.gov.au… data.qld.gov.au https://data.qld.gov.au/dataset/6503746b-18e0-48d7-a9a3-a42ee9b3152e     Register of lands 1861 to 1868 JSON https://www.data.qld.gov.au/dataset/6503746b-18e0-48d7-a9a3-a42ee9b3152e/resource/3efedd96-744a-4838-82cb-40122d65b134/download/register-of-lands-1861-1868.json JSON This open data file lists the names of people and businesses who purchased Crown Land in Queensland … 2018-09-05T01:36:59.143162 2018-09-05T01:36:59.059232 2097152.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]);