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.68 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.03 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

15.95 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

26.62 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

44.15 KB
1936 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

45.41 KB
1979 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

81.04 KB
4215 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

57.78 KB
2589 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

27.77 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

30.56 KB
1098 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

30.76 KB
1011 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_12" VARCHAR,
  "unnamed_13" VARCHAR
);