glam-datasets

3 rows where dataset_description = "Section 12 of the Public Records Act 1973 (Vic) requires the Keeper of Public Records to establish standards for the efficient management of public records and assist public offices in the application of those standards to records under their control. The Act requires public offices to implement records management programs in accordance with the standards established by the Keeper. All standards are available on the PROV website: www.prov.vic.gov.au/recordkeeping-government/standards-policies-rdas.", "file_created" is on date 2020-11-05, format = "CSV" and licence = "Creative Commons Attribution 4.0 International"

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