1 row where "dataset_issued" is on date 2017-07-21, "dataset_modified" is on date 2022-06-28 and file_description = "Index to the [Loan Register]( https://www.archivessearch.qld.gov.au/series/S3960) for discharged soldiers' loans recording financial assistance to applicants for the purposes of erecting or purchasing dwelling houses under the Discharged Soldiers Settlement Act of 1917."

View and edit SQL

Suggested facets: dataset_modified (date)

source

format

file_modified (date)

file_created (date)

dataset_issued (date)

  • 2017-07-21 · 1
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
405 Discharged Soldier Settler Loans 1917-1919 Queensland State Archives web@archives.qld.gov.au 2017-07-21T04:20:24.267159 2022-06-28T03:58:29.189179 The [Loan Register](https://www.archivessearch.qld.gov.au/series/S3960) for discharged soldiers' loa… data.qld.gov.au https://data.qld.gov.au/dataset/14ce20b8-cc04-4cdc-9f72-e7c9f47682ce     Discharged Soldier Settler Loans 1917-1919 https://www.data.qld.gov.au/dataset/14ce20b8-cc04-4cdc-9f72-e7c9f47682ce/resource/4f6f5bdc-c48d-4d52-8ac7-228be082acf6/download/discharged-soldier-settler-loans-1917-1919-.csv CSV Index to the [Loan Register]( https://www.archivessearch.qld.gov.au/series/S3960) for discharged sol… 2017-07-21T14:29:38.897835 2021-08-19T02:14:02.860381 704512.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]);