glam-datasets

1 row where "dataset_modified" is on date 2022-07-18, file_description = "This open data file lists the names of applicants (sometimes the applicant was a company) for mineral leases and licences created by the Mines Department in the localities including Bowen, Bundaberg, Cairns, Charleville, Charters Towers, Childers, Clermont, Cloncurry, Cooktown, Etheridge, Gladstone, Gympie, Ingham, Longreach, Mackay, Mareeba, Mount Morgan, Palmer, Rockhampton, Sellheim, Stanthorpe, and Warwick. The leases and licences include those for gold (GML), mineral (ML), coal (CML) and water race (WRL)." and publisher = "Queensland State Archives"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), file_created (date), file_modified (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]);