2 rows where "file_created" is on date 2014-01-05 and publisher = "Queensland State Archives"

View and edit SQL

source

publisher

  • Queensland State Archives · 2

format

file_created (date)

  • 2014-01-05 · 2

dataset_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
435 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 https://www.data.qld.gov.au/dataset/6503746b-18e0-48d7-a9a3-a42ee9b3152e/resource/e1afdc88-d43a-4c30-bfa3-5f02cd2862ec/download/register-of-lands-1861-1868.csv CSV This open data file lists the names of people and businesses who purchased Crown Land in Queensland … 2014-01-05T23:22:58.160572 2022-05-03T00:07:26.121852 4823449.0 Creative Commons Attribution 4.0
437 Register of land sold 1842 to 1859 Queensland State Archives web@archives.qld.gov.au 2014-01-05T23:17:03.022613 2022-06-22T02:04:00.474402 This index was compiled from the [Lists of Land Sold - Colony of Queensland](https://www.archivessea… data.qld.gov.au https://data.qld.gov.au/dataset/926b2ea1-78c1-4f0a-a1a9-83da92b2fc6d     Register of land sold 1842 to 1859 https://www.data.qld.gov.au/dataset/926b2ea1-78c1-4f0a-a1a9-83da92b2fc6d/resource/f53dfd13-970a-45ac-9567-d7c8fc2652b6/download/register-of-land-sold-1842-to-1859.csv CSV This open data file lists the names of people who purchased land sold in what became the Colony of Q… 2014-01-05T23:18:10.853568 2022-04-28T22:37:49.852528 2831155.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]);