2 rows where "dataset_issued" is on date 2014-01-05, "dataset_modified" is on date 2022-06-22, format = "JSON" and publisher = "Queensland State Archives"

View and edit SQL

Suggested facets: file_modified (date)

source

publisher

  • Queensland State Archives · 2

format

  • JSON · 2

dataset_modified (date)

  • 2022-06-22 · 2

dataset_issued (date)

  • 2014-01-05 · 2
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
438 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 JSON https://www.data.qld.gov.au/dataset/926b2ea1-78c1-4f0a-a1a9-83da92b2fc6d/resource/af823c77-0882-4182-bcb2-5ba1bf54a275/download/register-of-land-sold-1842-1859.json JSON This open data file lists the names of people who purchased land sold in what became the Colony of Q… 2018-09-05T01:53:12.181759 2018-09-05T01:53:12.095758 2621440.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]);