1 row where "dataset_modified" is on date 2022-06-28, file_description = "The Loan Register for discharged soldiers' loans records financial assistance to applicants for the purposes of erecting or purchasing dwelling houses under the Discharged Soldiers Settlement Act of 1917." and publisher = "Queensland State Archives"

View and edit SQL

Suggested facets: dataset_issued (date), file_created (date), file_modified (date)

source

publisher

  • Queensland State Archives · 1

format

file_description

  • The Loan Register for discharged soldiers' loans records financial assistance to applicants for the purposes of erecting or purchasing dwelling houses under the Discharged Soldiers Settlement Act of 1917. · 1

dataset_modified (date)

  • 2022-06-28 · 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
406 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 JSON https://www.data.qld.gov.au/dataset/14ce20b8-cc04-4cdc-9f72-e7c9f47682ce/resource/cd13d11b-3026-465a-bd61-72ea81ec8cb6/download/discharged-soldier-settler-loans-1917-1919.json JSON The Loan Register for discharged soldiers' loans records financial assistance to applicants for the … 2018-09-04T04:39:27.891490 2018-09-04T04:39:27.797779 769024.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]);