About this Dataset

Electric Vehicle Chargepoints Operated By Leeds City Council.

Usage data for Electric Vehicle chargepoints in Council car parks in Leeds including how often they are used, duration of charge, electricity consumed and type of vehicle.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:31Z

Tables

2014 EVCP Use Q2

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2014_evcp_use_q2

8.89 kB
12 rows
11 columns

CREATE TABLE n_2014_evcp_use_q2 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2015 EVCP Use Q1 And Q2

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2015_evcp_use_q1_and_q2

15.39 kB
218 rows
11 columns

CREATE TABLE n_2015_evcp_use_q1_and_q2 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2015 EVCP Use Q3 And Q4

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2015_evcp_use_q3_and_q4

16.33 kB
269 rows
11 columns

CREATE TABLE n_2015_evcp_use_q3_and_q4 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2016 EVCP Use Q1 And Q2

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2016_evcp_use_q1_and_q2

27.26 kB
847 rows
11 columns

CREATE TABLE n_2016_evcp_use_q1_and_q2 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2016 EVCP Use Q3 And Q4

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2016_evcp_use_q3_and_q4

45.21 kB
1,936 rows
11 columns

CREATE TABLE n_2016_evcp_use_q3_and_q4 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2017 EVCP Use Q3 And Q4

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2017_evcp_use_q3_and_q4

46.5 kB
1,979 rows
11 columns

CREATE TABLE n_2017_evcp_use_q3_and_q4 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2019 EVCP Use Q3 And Q4

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2019_evcp_use_q3_and_q4

82.98 kB
4,215 rows
11 columns

CREATE TABLE n_2019_evcp_use_q3_and_q4 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2020 EVCP Use Q1 And Q2

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2020_evcp_use_q1_and_q2

59.17 kB
2,589 rows
11 columns

CREATE TABLE n_2020_evcp_use_q1_and_q2 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2020 EVCP Use Q3

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2020_evcp_use_q3

28.43 kB
945 rows
11 columns

CREATE TABLE n_2020_evcp_use_q3 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2020 EVCP Use Q4

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2020_evcp_use_q4

31.3 kB
1,098 rows
11 columns

CREATE TABLE n_2020_evcp_use_q4 (
  "charging_event" BIGINT,
  "user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR
);

2021 EVCP Use Q1

@ukgov.electric_vehicle_chargepoints_operated_by_leeds_city_council1.n_2021_evcp_use_q1

31.5 kB
1,011 rows
14 columns

CREATE TABLE n_2021_evcp_use_q1 (
  "charging_event" BIGINT,
  "unique_user_id" VARCHAR,
  "cp_id" BIGINT,
  "connector" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "total_kwh" DOUBLE,
  "site" VARCHAR,
  "model" VARCHAR,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);