glam-datasets

15 rows where dataset_description = "This open data file contains usage data from the State Library of Queensland’s Unstacked interface at https://unstacked.slq.qld.gov.au/ . This includes bibliographic information about viewed items and activity details for each ‘view’ on Unstacked. Unstacked is a real-time visualisation of resources users are accessing from the State Library of Queensland’s online catalogue. As onsite and offsite users select items in the catalogue, the cover or preview image for the item appears in Unstacked. So, when an image appears, it means someone just looked at that item. Users on Unstacked can select the image to view more details about the item and click through to the item’s record in the State Library catalogue. The Unstacked database stores information about each item and ‘view’ interaction that it visualises. This includes bibliographic information about the item (title, publisher, date, description, subject, ISBN, etc.) and activity details for each view (date/time, onsite/offsite, display image URL, etc.). Additional background information can be found at: https://www.slq.qld.gov.au/blogs/slq-today/slq-unstacked " and "file_created" is on date 2019-05-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: file_modified, file_size, dataset_issued (date), dataset_modified (date), file_created (date), file_modified (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]);