1 row where "dataset_modified" is on date 2022-06-28, file_description = "Note: JSON data set is experimenta. Use CSV resource in case of errors. This open data file alphabetically lists the names of individual settlers from Coominya, Cecil Plains, Maria Creek and Mount Gravatt as recorded in the Soldier Settlement ledgers kept by the Lands Department during the period 1917 to 1929. Information also includes the locality, parish, block and sheet number, date and Queensland State Archives' catalogue details." and source = "data.qld.gov.au"

View and edit SQL

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

source

  • data.qld.gov.au · 1

format

file_description

  • Note: JSON data set is experimenta. Use CSV resource in case of errors. This open data file alphabetically lists the names of individual settlers from Coominya, Cecil Plains, Maria Creek and Mount Gravatt as recorded in the Soldier Settlement ledgers kept by the Lands Department during the period 1917 to 1929. Information also includes the locality, parish, block and sheet number, date and Queensland State Archives' catalogue details. · 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
398 Soldier Settlement ledgers 1917 to 1929 Queensland State Archives web@archives.qld.gov.au 2016-11-02T04:00:05.643774 2022-06-28T07:10:47.103037 This index was compiled from [Soldier Settlement ledgers for individual settlers from Coominya, Ceci… data.qld.gov.au https://data.qld.gov.au/dataset/6a356f9d-5088-4969-81e6-1fab7c677917     Soldier Settlement ledgers 1917 to 1929 JSON https://www.data.qld.gov.au/dataset/6a356f9d-5088-4969-81e6-1fab7c677917/resource/d1509f35-bf7f-4e10-9fde-3ec3b05ccbb0/download/soldier-settlement-1917-1929.json JSON Note: JSON data set is experimenta. Use CSV resource in case of errors. This open data file alphabe… 2018-09-03T00:55:30.111279 2018-09-03T00:55:29.996872 151552.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]);