glam-datasets

1 row where file_description = "Online catalogue for the Western Australian State Archive collection. Items can be identified by searching on terms in the file or item title or series (archival description), by organisation or people, or by government function. The catalogue uses Boolean search term to refine searches, such as AND, OR, NOT. " and publisher = "State Records Office of Western Australia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (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]);