About this Dataset

Cambridge City Car Park Usage Data By Length Of Stay

The dataset provided below shows the daily car park usage of the Grand Arcade (GA), Park Street Terrace (PST), Grafton East (GRE), Grafton West (GW) and Queen Anne's Terrace (QAT). The data is available from 1st April 2015 and shows the Car Park usage by length of stay in hours.

The data is available as CSV files, with one file for each car park.

In addition, there is a CSV file for surface car parks, which displays monthly totals only - going back to April 2014.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:15Z

Tables

Car Park Locations Inc. Surface Car Parks

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.car_park_locations_inc_surface_car_parks

4.25 kB
9 rows
4 columns

CREATE TABLE car_park_locations_inc_surface_car_parks (
  "car_park" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "address" VARCHAR
);

Grafton East Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.grafton_east_car_park_usage_data

81.92 kB
2,832 rows
14 columns

CREATE TABLE grafton_east_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "n__up_to_1_hr" VARCHAR  -- Up To 1 Hr,
  "n__1_to_2_hrs" VARCHAR  -- 1 To 2 Hrs,
  "n__2_to_3_hrs" VARCHAR  -- 2 To 3 Hrs,
  "n__3_to_4_hrs" VARCHAR  -- 3 To 4 Hrs,
  "n__4_to_5_hrs" VARCHAR  -- 4 To 5 Hrs,
  "n__5_to_6_hrs" VARCHAR  -- 5 To 6 Hrs,
  "n__6_to_24_hours" VARCHAR  -- 6 To <24 Hours,
  "n__24_hours" VARCHAR  -- 24 Hours +,
  "n__subscribers" VARCHAR  -- Subscribers,
  "total_exc_sub" BIGINT,
  "comments" VARCHAR
);

Grafton West Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.grafton_west_car_park_usage_data

73.49 kB
2,832 rows
14 columns

CREATE TABLE grafton_west_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "up_to_1_hr" BIGINT,
  "n_1_to_2_hrs" BIGINT  -- 1 To 2 Hrs,
  "n_2_to_3_hrs" BIGINT  -- 2 To 3 Hrs,
  "n_3_to_4_hrs" BIGINT  -- 3 To 4 Hrs,
  "n_4_to_5_hrs" BIGINT  -- 4 To 5 Hrs,
  "n_5_to_6_hrs" BIGINT  -- 5 To 6 Hrs,
  "n_6_to_24_hours" BIGINT  -- 6 To <24 Hours,
  "n_24_hours" BIGINT  -- 24 Hours +,
  "subscribers" BIGINT,
  "total_exc_sub" BIGINT,
  "comments" VARCHAR
);

Grand Arcade Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.grand_arcade_car_park_usage_data

91.84 kB
2,832 rows
14 columns

CREATE TABLE grand_arcade_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "up_to_1_hr" BIGINT,
  "n_1_to_2_hrs" BIGINT  -- 1 To 2 Hrs,
  "n_2_to_3_hrs" BIGINT  -- 2 To 3 Hrs,
  "n_3_to_4_hrs" BIGINT  -- 3 To 4 Hrs,
  "n_4_to_5_hrs" BIGINT  -- 4 To 5 Hrs,
  "n_5_to_6_hrs" BIGINT  -- 5 To 6 Hrs,
  "n_6_to_24_hours" BIGINT  -- 6 To <24 Hours,
  "n_24_hours" BIGINT  -- 24 Hours +,
  "subscribers" BIGINT,
  "total_exc_sub" BIGINT,
  "comments" VARCHAR
);

Park Street Terrace Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.park_street_terrace_car_park_usage_data

70.16 kB
2,470 rows
14 columns

CREATE TABLE park_street_terrace_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "up_to_1_hr" DOUBLE,
  "n_1_to_2_hrs" DOUBLE  -- 1 To 2 Hrs,
  "n_2_to_3_hrs" DOUBLE  -- 2 To 3 Hrs,
  "n_3_to_4_hrs" DOUBLE  -- 3 To 4 Hrs,
  "n_4_to_5_hrs" DOUBLE  -- 4 To 5 Hrs,
  "n_5_to_6_hrs" BIGINT  -- 5 To 6 Hrs,
  "n_6_to_24_hours" DOUBLE  -- 6 To <24 Hours,
  "n_24_hours" DOUBLE  -- 24 Hours +,
  "subscribers" DOUBLE,
  "total_exc_sub" DOUBLE,
  "comments" VARCHAR
);

Queen Annes Terrace Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.queen_annes_terrace_car_park_usage_data

80.8 kB
2,832 rows
14 columns

CREATE TABLE queen_annes_terrace_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "up_to_1_hr" BIGINT,
  "n_1_to_2_hrs" BIGINT  -- 1 To 2 Hrs,
  "n_2_to_3_hrs" BIGINT  -- 2 To 3 Hrs,
  "n_3_to_4_hrs" BIGINT  -- 3 To 4 Hrs,
  "n_4_to_5_hrs" BIGINT  -- 4 To 5 Hrs,
  "n_5_to_6_hrs" BIGINT  -- 5 To 6 Hrs,
  "n_6_to_24_hours" BIGINT  -- 6 To <24 Hours,
  "n_24_hours" BIGINT  -- 24 Hours +,
  "subscribers" BIGINT,
  "total_exc_sub" BIGINT,
  "comments" VARCHAR
);

Surface Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.surface_car_park_usage_data

18.29 kB
93 rows
16 columns

CREATE TABLE surface_car_park_usage_data (
  "month" VARCHAR,
  "year" BIGINT,
  "fy" VARCHAR,
  "month_year" VARCHAR,
  "adam_eve_metric" BIGINT  -- Adam & Eve Metric,
  "adam_eve_justpark" DOUBLE  -- Adam & Eve JustPark,
  "adam_eve_total" BIGINT  -- Adam & Eve Total,
  "castle_hill_metric" BIGINT,
  "catle_hill_justpark" DOUBLE,
  "castle_hill_total" BIGINT,
  "gwydir_street_metric" BIGINT,
  "gwydir_street_justpark" DOUBLE,
  "gwydir_street_total" BIGINT,
  "riverside_metric" DOUBLE,
  "riverside_justpark" DOUBLE,
  "riverside_total" BIGINT
);