glam-datasets

2 rows where dataset_description = "This open data file contains the text strings searched in the State Library’s online catalogue each month with the total number of times each text string was searched during the month. The State Library’s online catalogue is openly available at http://onesearch.slq.qld.gov.au. Users search the catalogue remotely and onsite in the library to find digital and physical collection materials and access subscription databases. State Library collections include photographs, newspapers, video, audio, books, online training, music, maps, 3D objects, journals, websites and more. At the end of the month, the raw search data from the catalogue is exported and analysed to count recurring searches." and file_size = "1048576.0"

✎ View and edit SQL

This data as json, CSV (advanced)

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