Baselight

Cambridge City Car Park Usage Data By Length Of Stay

Cambridgeshire Insight

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay

Loading...
Loading...

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

Grafton East Car Park Usage Data

@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay.grafton_east_car_park_usage_data
  • 80 KB
  • 2832 rows
  • 14 columns
Loading...

CREATE TABLE grafton_east_car_park_usage_data (
  "date" TIMESTAMP,
  "day" VARCHAR,
  "week_locator" VARCHAR,
  "n__up_to_1_hr" VARCHAR,
  "n__1_to_2_hrs" VARCHAR,
  "n__2_to_3_hrs" VARCHAR,
  "n__3_to_4_hrs" VARCHAR,
  "n__4_to_5_hrs" VARCHAR,
  "n__5_to_6_hrs" VARCHAR,
  "n__6_to_24_hours" VARCHAR,
  "n__24_hours" VARCHAR,
  "n__subscribers" VARCHAR,
  "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
  • 17.86 KB
  • 93 rows
  • 16 columns
Loading...

CREATE TABLE surface_car_park_usage_data (
  "month" VARCHAR,
  "year" BIGINT,
  "fy" VARCHAR,
  "month_year" VARCHAR,
  "adam_eve_metric" BIGINT,
  "adam_eve_justpark" DOUBLE,
  "adam_eve_total" BIGINT,
  "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
);

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.15 KB
  • 9 rows
  • 4 columns
Loading...

CREATE TABLE car_park_locations_inc_surface_car_parks (
  "car_park" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "address" 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
  • 78.9 KB
  • 2832 rows
  • 14 columns
Loading...

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,
  "n_2_to_3_hrs" BIGINT,
  "n_3_to_4_hrs" BIGINT,
  "n_4_to_5_hrs" BIGINT,
  "n_5_to_6_hrs" BIGINT,
  "n_6_to_24_hours" BIGINT,
  "n_24_hours" BIGINT,
  "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
  • 89.68 KB
  • 2832 rows
  • 14 columns
Loading...

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,
  "n_2_to_3_hrs" BIGINT,
  "n_3_to_4_hrs" BIGINT,
  "n_4_to_5_hrs" BIGINT,
  "n_5_to_6_hrs" BIGINT,
  "n_6_to_24_hours" BIGINT,
  "n_24_hours" BIGINT,
  "subscribers" BIGINT,
  "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
  • 71.77 KB
  • 2832 rows
  • 14 columns
Loading...

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,
  "n_2_to_3_hrs" BIGINT,
  "n_3_to_4_hrs" BIGINT,
  "n_4_to_5_hrs" BIGINT,
  "n_5_to_6_hrs" BIGINT,
  "n_6_to_24_hours" BIGINT,
  "n_24_hours" BIGINT,
  "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
  • 68.51 KB
  • 2470 rows
  • 14 columns
Loading...

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,
  "n_2_to_3_hrs" DOUBLE,
  "n_3_to_4_hrs" DOUBLE,
  "n_4_to_5_hrs" DOUBLE,
  "n_5_to_6_hrs" BIGINT,
  "n_6_to_24_hours" DOUBLE,
  "n_24_hours" DOUBLE,
  "subscribers" DOUBLE,
  "total_exc_sub" DOUBLE,
  "comments" VARCHAR
);

Share link

Anyone who has the link will be able to view this.