Dataset: Library Data

About this Dataset

Library Data

Open Data release of Library Data for Cambridgeshire. Dataset includes: Events, Loans, Mobile Library Routes, Library Opening Times and Physical Visits.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:15Z

Tables

Cambridgeshire Mobile Libraries

@ukgov.library_data.cambridgeshire_mobile_libraries

31.15 KB
385 rows
17 columns


CREATE TABLE cambridgeshire_mobile_libraries (
  "vehicle" VARCHAR,
  "route" VARCHAR,
  "b" VARCHAR,
  "day" VARCHAR,
  "stop_no" BIGINT,
  "main_location" VARCHAR,
  "secondary_location" VARCHAR,
  "postcode" VARCHAR,
  "freq" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "arrive" VARCHAR,
  "depart" VARCHAR,
  "stop_duration" BIGINT,
  "stop_time" BIGINT,
  "stop_time_dec" DOUBLE,
  "id" BIGINT
);

Cambridgeshire Library Events

@ukgov.library_data.cambridgeshire_library_events

25.26 KB
7194 rows
5 columns


CREATE TABLE cambridgeshire_library_events (
  "local_authority" VARCHAR,
  "library" VARCHAR,
  "date" TIMESTAMP,
  "name" VARCHAR,
  "attendees" BIGINT
);

Cambridgeshire Library Physical Visits

@ukgov.library_data.cambridgeshire_library_physical_visits

5.45 KB
37 rows
6 columns


CREATE TABLE cambridgeshire_library_physical_visits (
  "local_authority" VARCHAR,
  "library" VARCHAR,
  "count_start" VARCHAR,
  "count_end" VARCHAR,
  "count_type" VARCHAR,
  "visits" BIGINT
);

Cambridgeshire Library Location And Opening Hours

@ukgov.library_data.cambridgeshire_library_location_and_opening_hours

36.33 KB
61 rows
51 columns


CREATE TABLE cambridgeshire_library_location_and_opening_hours (
  "local_authority" VARCHAR,
  "library_name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "postcode" VARCHAR,
  "statutory" VARCHAR,
  "type_of_library" VARCHAR,
  "year_opened" DOUBLE,
  "year_closed" VARCHAR,
  "monday_staffed_hours" VARCHAR,
  "tuesday_staffed_hours" VARCHAR,
  "wednesday_staffed_hours" VARCHAR,
  "thursday_staffed_hours" VARCHAR,
  "friday_staffed_hours" VARCHAR,
  "saturday_staffed_hours" VARCHAR,
  "sunday_staffed_hours" VARCHAR,
  "monday_unstaffed_hours" VARCHAR,
  "tuesday_unstaffed_hours" VARCHAR,
  "wednesday_unstaffed_hours" VARCHAR,
  "thursday_unstaffed_hours" VARCHAR,
  "friday_unstaffed_hours" VARCHAR,
  "saturday_unstaffed_hours" VARCHAR,
  "sunday_unstaffed_hours" VARCHAR,
  "special_hours" VARCHAR,
  "co_located" VARCHAR,
  "co_located_with" VARCHAR,
  "notes" VARCHAR,
  "url" VARCHAR,
  "email_address" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR
);

Cambridgeshire Library Loans

@ukgov.library_data.cambridgeshire_library_loans

9.16 KB
1633 rows
5 columns


CREATE TABLE cambridgeshire_library_loans (
  "local_authority" VARCHAR,
  "library" VARCHAR,
  "month" TIMESTAMP,
  "type" VARCHAR,
  "loans" BIGINT
);