glam-datasets

1 row where "file_created" is on date 2016-07-25, file_description = "This CSV contains title, publication dates, area of publication and notes about former/later titles for Newspapers published in Western Australia from 1830 onwards to present day. The data has been harvested and reformatted from the State Library of Western Australia Catalogue." and format = "CSV"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dataset_issued (date), dataset_modified (date), file_modified (date)

source

format

file_description ✖

  • This CSV contains title, publication dates, area of publication and notes about former/later titles for Newspapers published in Western Australia from 1830 onwards to present day. The data has been harvested and reformatted from the State Library of Western Australia Catalogue. · 1 ✖

file_created (date) ✖

  • 2016-07-25 · 1 ✖
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
981 981 Newspaper Titles at State Library of WA State Library of Western Australia Author Not Specified 2016-07-25T01:01:24.493264 2022-05-25T18:46:15.354572 Nearly 900 Western Australian newspaper titles are held by the State Library. These range from the m… data.wa.gov.au https://catalogue.data.wa.gov.au/dataset/c8d68516-0eb8-445d-913a-c2f692366150     WA_newspapers_2016 https://catalogue.data.wa.gov.au/dataset/c8d68516-0eb8-445d-913a-c2f692366150/resource/09f32d84-6c5c-46c3-bba7-a05a33f3d48f/download/newspapers-wa.csv CSV This CSV contains title, publication dates, area of publication and notes about former/later titles … 2016-07-25T01:05:00.703381 2016-07-25T01:05:00.670260   Creative Commons Attribution 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]);