glam-datasets

6 rows where dataset_description = "The passage of the Returned Soldiers Settlement Act 1916, (Act No 21 1916) allowed the settlement of returned soldiers on Crown and Closer Settlement lands. When applying for land, an ex-serviceman was required to complete a Qualification Certificate which was a declaration of his or her status as an ex-service person and eligibility for land. These indexes were created by the [State Records NSW Volunteer program](http://www.records.nsw.gov.au/about-us/volunteers/volunteers)." and source = "data.nsw.gov.au"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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]);