The State of New York is one of the only states that publishes vehicle registration data. The file, hosted on Data.gov (great site!) is a whopping 1.2 gigabyte CSV file that contains a litany of vehicles registered with the state – from boats and trailers, to passenger cars and snowmobiles.

Rather than trying to conduct some exploratory data analysis on the over 10 million records – I decided to focus in on a low-volume, well-known automaker – Tesla Motors.

Tesla-1

Tesla, unlike other automakers, doesn’t report monthly sales. The fact that we don’t know how many, let alone where Teslas are being sold it made them the perfect brand candidate for this exploration. The downside to this data adventure is the lack of comparable data. To make this post really interesting (and more informative) would have been to do a comparison between two states on things like volume, mix, color choices, EV market share…and other incredibly nerdy insights.

I was able to come up with a few nifty charts and data points. The charts are self-explanatory.

The big takeaway – Tesla vehicles make up 51% of all electric passenger vehicles registered in the State of New York.

Enjoy the charts! If you have any questions – come and find me on Twitter at @DCCarGeek.

Tesla-2First we take a look at the breakout of colors for Tesla vehicles in New York. My first inclination – black or silver would be the most common color but as you can see blue takes the cake here.

Tesla-4To come up with this number I used some rough math. I took the total number of 2015 Tesla vehicles registered divided by the number of total selling days between the high and low date where a 2015 Tesla was registered. The data indicated that on average Tesla registers 3.4 new vehicles everyday with the State of New York.

 

Tesla-6 NEW

Another neat data point, and one I highlighted earlier; Tesla dominates the passenger vehicle EV market in New York. The only luxury branded EV competitor in the market is BMW and there product offerings don’t really compete well with a full size sedan. At this point I don’t see any automakers gaining market share from Tesla in the near-term in New York.

 

Tesla-3

Here we see the breakout of Tesla vehicles by Model Year.

Lack of State Data

This was a fun exercise and made me realize how much value there is in vehicle registration data. While there are means to get this data from third party vendors, it tends to be very expensive. My hope is New York will start a trend where more and more states will open up their vehicle registration data to the public.