1 row where file_description = "Contains: Library control number, collection number, Author (where available), Title, published date,description, notes, summary, subject headings (People, Corporate entities, meeting, topic and geographical headings), Series Entries, Captions for URLs and the URLS for the photographs.", "file_modified" is on date 2018-04-04, format = "CSV", licence = "Creative Commons Attribution Share-Alike 4.0" and source = "data.wa.gov.au"

View and edit SQL

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

source

  • data.wa.gov.au · 1

licence

  • Creative Commons Attribution Share-Alike 4.0 · 1

format

file_modified (date)

  • 2018-04-04 · 1

dataset_modified (date)

Link rowid ▼ dataset_title publisher author dataset_issued dataset_modified dataset_description source info_url start_date end_date file_title download_url format file_description file_created file_modified file_size licence
988 SLWA Commonwealth Games photographs State Library of Western Australia Author Not Specified 2018-04-04T03:33:45.801947 2022-05-25T18:46:17.450244 Photographs from the SLWA collection featuring the Commonwealth Games. Most if not all of the photog… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/45357ec0-dd39-4d08-b051-6b7d820cb954     SLWA Commonwealth Games metadata https://catalogue.data.wa.gov.au/dataset/45357ec0-dd39-4d08-b051-6b7d820cb954/resource/8143068d-3786-4a25-ad41-99ae2bdc5e43/download/slwa-commonwealth-games-photographs.csv CSV Contains: Library control number, collection number, Author (where available), Title, published date… 2018-04-04T03:35:28.210817 2018-04-04T03:35:28.103971   Creative Commons Attribution Share-Alike 4.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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