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 Library Events

@ukgov.library_data.cambridgeshire_library_events

25.87 kB
7,194 rows
5 columns

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

Cambridgeshire Library Loans

@ukgov.library_data.cambridgeshire_library_loans

9.38 kB
1,633 rows
5 columns

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

Cambridgeshire Library Location And Opening Hours

@ukgov.library_data.cambridgeshire_library_location_and_opening_hours

37.2 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: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50
);

Cambridgeshire Library Physical Visits

@ukgov.library_data.cambridgeshire_library_physical_visits

5.58 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 Mobile Libraries

@ukgov.library_data.cambridgeshire_mobile_libraries

31.9 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
);