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.
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
50 years later, Americans are finally learn to appreciate the Malaise era, and learning things from that era are actually collectable.
Areas with non attainment have emissions inspections but other areas often emissions equipment is clunky and works rather poorly. Automakers lobby for one standard but the problem is that one standard wastes fuel, reliability and performance in areas when the equipment is not neccesary.
![Untitled [Expires December 19 2024]](https://andyarthur.org//data/photo_015270_large.jpg)
