glam-datasets
1 row where dataset_description = "Nearly 900 Western Australian newspaper titles are held by the State Library. These range from the manuscript newspapers of the early 1830s up to currently published titles. Selected Western Australian newspaper titles are available digitally through Trove, a service provided by National Library of Australia in partnership with state libraries, including the State Library of Western Australia. Currently, there are 110 Western Australian newspaper titles available. This file includes the title, dates of publication, other titles (former and later) area of publication and some notes about individual publications.", dataset_modified = "2022-05-25T18:46:15.354572" and publisher = "State Library of Western Australia"
This data as json, CSV (advanced)
Suggested facets: dataset_issued (date), dataset_modified (date), file_created (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]);