Name: Libraries Information
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Libraries Information

Information on Plymouth’s libraries including location, opening times and facilities.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:07Z

Tables

Libraries Information 2018

@ukgov.librariesinfomation.libraries_information_2018

24.13 KB
12 rows
36 columns


CREATE TABLE libraries_information_2018 (
  "libraryname" VARCHAR,
  "addressline1" VARCHAR,
  "addressline2" VARCHAR,
  "addressline3" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mondayopen" VARCHAR,
  "mondayclose" VARCHAR,
  "tuesdayopen" VARCHAR,
  "tuesdayclose" VARCHAR,
  "wednesdayopen" VARCHAR,
  "wednesdayclose" VARCHAR,
  "thursdayopen" VARCHAR,
  "thursdayclose" VARCHAR,
  "fridayopen" VARCHAR,
  "fridayclosed" VARCHAR,
  "saturdayopen" VARCHAR,
  "saturdayclosed" VARCHAR,
  "sunday" VARCHAR,
  "computers" VARCHAR,
  "wifi" VARCHAR,
  "printers" VARCHAR,
  "photocopiers" VARCHAR,
  "scanners" VARCHAR,
  "meetingrooms" VARCHAR,
  "localandfamilyhistory" VARCHAR,
  "navalhistory" VARCHAR,
  "microfilmscanners" VARCHAR,
  "roofterrace" VARCHAR,
  "books" VARCHAR,
  "dvds" VARCHAR,
  "audiobooks" VARCHAR,
  "requestservice" VARCHAR,
  "cafe" VARCHAR,
  "website" VARCHAR
);

Libraries Information 2019

@ukgov.librariesinfomation.libraries_information_2019

24.07 KB
11 rows
36 columns


CREATE TABLE libraries_information_2019 (
  "libraryname" VARCHAR,
  "addressline1" VARCHAR,
  "addressline2" VARCHAR,
  "addressline3" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mondayopen" VARCHAR,
  "mondayclose" VARCHAR,
  "tuesdayopen" VARCHAR,
  "tuesdayclose" VARCHAR,
  "wednesdayopen" VARCHAR,
  "wednesdayclose" VARCHAR,
  "thursdayopen" VARCHAR,
  "thursdayclose" VARCHAR,
  "fridayopen" VARCHAR,
  "fridayclose" VARCHAR,
  "saturdayopen" VARCHAR,
  "saturdayclose" VARCHAR,
  "sunday" VARCHAR,
  "computers" VARCHAR,
  "wifi" VARCHAR,
  "printers" VARCHAR,
  "photocopiers" VARCHAR,
  "scanners" VARCHAR,
  "meetingrooms" VARCHAR,
  "localandfamilyhistory" VARCHAR,
  "navalhistory" VARCHAR,
  "microfilmscanners" VARCHAR,
  "roofterrace" VARCHAR,
  "books" VARCHAR,
  "dvds" VARCHAR,
  "audiobooks" VARCHAR,
  "requestservice" VARCHAR,
  "cafe" VARCHAR,
  "website" VARCHAR
);