Electric Vehicle Registration Data

State of Connecticut

@usgov.state_of_connecticut_electric_vehicle_registration_data

Table List

1 table(1.13 MB)

Table 1

@usgov.state_of_connecticut_electric_vehicle_registration_data.table_1

1.13 MB
60489 rows
20 columns

id ID	plate_type Plate Type	primary_customer_city Primary Customer City	primary_customer_state Primary Customer State	registration_start_date Registration Start Date	registration_expiration_date Registration Expiration Date	registration_usage Registration Usage	vehicle_type Vehicle Type	vehicle_year Vehicle Year	vehicle_make Vehicle Make	vehicle_model Vehicle Model	vehicle_body Vehicle Body	primary_color Primary Color	vehicle_declared_gross_weight Vehicle Declared Gross Weight	fuel_code Fuel Code	vehicle_recorded_gvwr Vehicle Recorded GVWR	vehicle_name Vehicle Name	type Type	vehicle_category Vehicle Category
13	Passenger	GLASTONBURY	CT	Fri Feb 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 16 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Tesla	Model Y	SU	Black		E00		Tesla Model Y	BEV	Light-Duty (Class 1-2)
19	Passenger	ORANGE	CT	Thu Feb 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 22 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Jeep	Wrangler Sahara 4xe	4W	White		H04		Jeep Wrangler Plug In	PHEV	Light-Duty (Class 1-2)
21	Passenger	LITCHFIELD	CT	Thu Feb 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 22 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Tesla	Model Y	SU	Gray		E00		Tesla Model Y	BEV	Light-Duty (Class 1-2)
73	Passenger	NORWALK	CT	Mon Feb 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 19 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Hyundai	Ioniq 5 Limited	SU	Green		E00		Hyundai Ioniq EV	BEV	Light-Duty (Class 1-2)
126	Passenger	SOUTHINGTON	CT	Sat Feb 18 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 17 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	Passenger	2023	Hyundai	Ioniq 5 Sel	4D	Blue	4222937	E00		Hyundai Ioniq EV	BEV	Light-Duty (Class 1-2)
164	Passenger	MANCHESTER	CT	Thu Feb 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 15 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Toyota	Rav4 Prime Xse	SU	Gray		H04		Toyota RAV4 Prime	PHEV	Light-Duty (Class 1-2)
205	Passenger	GUILFORD	CT	Fri Feb 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 09 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2016	Tesla	Model X	4W	Black		E00	6646	Tesla Model X	BEV	Light-Duty (Class 1-2)
218	Passenger	BROOKFIELD	CT	Thu Feb 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 15 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Hyundai	Ioniq 5 Limited	SU	Green		E00		Hyundai Ioniq EV	BEV	Light-Duty (Class 1-2)
258	Passenger	RIDGEFIELD	CT	Fri Feb 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 09 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Hyundai	Ioniq 5 Sel	SU	Blue		E00		Hyundai Ioniq EV	BEV	Light-Duty (Class 1-2)
259	Passenger	NORWALK	CT	Fri Feb 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 09 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Regular	SUV	2023	Toyota	Rav4 Prime Xse	SU	Silver		H04		Toyota RAV4 Prime	PHEV	Light-Duty (Class 1-2)


CREATE TABLE table_1 (
  "id" BIGINT,
  "plate_type" VARCHAR,
  "primary_customer_city" VARCHAR,
  "primary_customer_state" VARCHAR,
  "registration_start_date" TIMESTAMP,
  "registration_expiration_date" TIMESTAMP,
  "registration_usage" VARCHAR,
  "vehicle_type" VARCHAR,
  "vehicle_weight" BIGINT,
  "vehicle_year" BIGINT,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_body" VARCHAR,
  "primary_color" VARCHAR,
  "vehicle_declared_gross_weight" BIGINT,
  "fuel_code" VARCHAR,
  "vehicle_recorded_gvwr" BIGINT,
  "vehicle_name" VARCHAR,
  "type" VARCHAR,
  "vehicle_category" VARCHAR
);