Please don’t wash your car, I am hungry
Most Popular Automobile Make
Often you hear people bemoaning the death of American Automobile industry, and that everybody drives foreign cars these days, but outside of Eastern Seaboard and West Coast, the most popular cars and trucks are by far domestic makers. Also, GM probably is the most popular make of cars in most of Upstate NY, if not for the fact that their brand is split between Chevrolet and GMC.
I Test Drove a Chinese EV. Now I Don’t Want to Buy American Cars Anymore. – WSJ
Imagine if Americans could buy reliable new cars without blown gasser engines, that could make it to 100,000 miles like it used to be before everything went to hell over past two decades.
Model Year of Registered Motor Vehicles in New York, December 2025
There are fewer and fewer motor vehicles from 2011 and earlier left on the roads at this point..
It's good one for one's brain to practice window functions in SQL, lest I get rusty at such things. And yes, the first thing I did with all big data I get is put into a parquet and query it with duckdb. This turns the 12.5 million records into a much smaller table and calculates the percents using a SQL window function:
SELECT County, "Model Year", count(*) as Count,
count(*)/sum(count(*)) OVER (PARTITION BY County) AS Percent
FROM '~/Downloads/vehregdec25.parquet'
WHERE "Record Type"='VEH' AND County != 'OUT-OF-STATE'
GROUP BY County, "Model Year";
And here is the R script to making the graph in ggplot: Model Year of Registered Vehicles.R
