Hi, this is the author (formerly u/drivenbydata). I downloaded trip data from TLC and used DuckDB to analyse it. Here’s the full blog post of my analysis and the queries I used. For visualization I used Datawrapper, a tool I helped building over the past 11 years.