Updated EV Dashboard
The EV Interactive Dashboard is now updated. There are now 2 years of data represented in the model: February 2018 and March 2018. The data are a snapshot from these two points in time.
This comes to us from the CT Department of Motor Vehicles. Club President Bruce Becker filed a Freedom of Information Act to obtain it. The file includes every vehicle registered in the state of Connecticut.
A few words about the dataset.
There is no personal information. The fields that are given to us are make, model, model year, city, and fuel type. There is no plug-in hybrid (PHEV) fuel type in the file. We build that from the vehicle model. We then overlay census data that allows us to consolidate cities to counties, incorporate median household income by city, and calculate per capita stats.
To reinforce a couple of key points, the data in the file are not vehicle sales; it is the current vehicle fleet in the state of CT. It doesn’t matter if someone owns, leases, bought new or used. The year is the model year of the registered vehicle and should not be interpreted to be sales by year.
The model is interactive. The checkboxes are “slicers.” Checking a box will cross-filter all of the charts on that page. Similarly, clicking into a chart element will also cross-filter. You can click on more than one check box. If you are on a Mac, depress the command key while clicking. For PC, use the CTRL key. Hovering over a chart element will cause the value to display.
This model has multiple pages. The page bar is at the bottom of the screen.
Click here to spawn a web browser version of the dashboard
The browser version is a little balky, but such is life. If anyone has a PBI subscription and wants to see a PBI.com dash, send an email to WestportEVClub@gmail.com.
Look to upcoming posts to see our take on the highlights from the data set.