I Went Car-Free in the Suburbs. I’m Happier and Healthier. – Business Insider
Urban Life 📍
🖼️ Photos
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
NPR
That news came in the middle of a press conference about the Trump administration relaxing fuel economy rules — a change that will make it easier for Americans to buy more of the big, fuel-guzzling trucks and SUVs that car buyers love.
Trump's endorsement surprised, delighted and somewhat confused American kei car enthusiasts.
It is not actually illegal to build tiny cars for the U.S. auto market. The problem is that kei cars built for foreign countries don't meet U.S. safety standards, so you can't import them unless you're willing to buy an antique. And companies could build tiny cars to U.S. standards, but given the American preference for big vehicles, they simply don't.
