glam-datasets

1 row where dataset_description = "Our assets include both community and operating assets in the following four categories: Community assets These assets are the State’s archival collection. The physical collection was valued at $299.9m. The digital collection is valued at $16.7m. Building assets Records repositories for storage of the State Archives and the State Government’s non-current records are located at North Melbourne and Ballarat. The Victorian Archives Centre in North Melbourne, including land, is valued at $88.3m. Motor vehicles PROV operates one vehicle: a station wagon. Plant and operating equipment Operating assets are used for the upkeep of the physical and digital repositories so that public records can be stored safely and made available for public inspection." and publisher = "Public Records Office Victoria"

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