NYC Taxi Query Templates
Representative SQL and DataFrame renderings for each of the 25 NYC Taxi queries. Every page also shows how to extract the exact query for a given platform and scale.
| Query | Name |
|---|---|
| trips-per-hour | Trips per Hour |
| trips-per-day | Trips per Day |
| trips-per-month | Trips per Month |
| trips-by-day-of-week | Trips by Day of Week |
| top-pickup-zones | Top Pickup Zones |
| top-dropoff-zones | Top Dropoff Zones |
| top-routes | Top Routes |
| borough-summary | Borough Summary |
| revenue-by-payment-type | Revenue by Payment Type |
| fare-distribution | Fare Distribution |
| tip-analysis | Tip Analysis |
| surcharge-revenue | Surcharge Revenue |
| distance-distribution | Distance Distribution |
| passenger-count-analysis | Passenger Count Analysis |
| trip-duration-analysis | Trip Duration Analysis |
| rate-code-summary | Rate Code Summary |
| airport-trips | Airport Trips |
| vendor-comparison | Vendor Comparison |
| hourly-zone-heatmap | Hourly Zone Heatmap |
| weekday-weekend-comparison | Weekday vs Weekend |
| rush-hour-analysis | Rush Hour Analysis |
| monthly-year-over-year | Monthly Year-over-Year |
| single-day-summary | Single Day Summary |
| zone-detail | Zone Detail |
| full-scan-count | Full Scan Count |