toddwschneider/nyc-taxi-data resource

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

2081 stars · 563 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A collection of R and shell scripts to download, process, and import 3+ billion NYC taxi and for-hire vehicle (Uber, Lyft) trip records into PostgreSQL or ClickHouse. It handles the TLC's Parquet data format and includes schema setup for analysis.

Use cases

• import nyc taxi trip data into postgres
• load uber and lyft trip records into clickhouse
• analyze billions of taxi trips
• build a taxi dataset for sql practice
• convert tlc parquet files for database import
• reproduce nyc taxi data analysis

When to choose

• you want the full NYC TLC taxi/FHV trip history in your own PostgreSQL or ClickHouse database
• you need a large real-world dataset for SQL or analytics experimentation

When to avoid

• you need real-time taxi data feeds
• you want a prebuilt hosted dataset rather than running your own import pipeline
• you rely on the old TLC CSV files, which are no longer supported

Facets

dataset · maturity active

etl database data-science analytics big-data analytics cli nyc-taxi parquet uber lyft trip-data r-scripts shell-scripts open-data data-engineering transportation postgresql clickhouse macos linux

Member repositories

For agents

markdown · JSON · MCP: product_card(name="toddwschneider/nyc-taxi-data")