playground explore freely · no grades

SQL Playground

Explore any Runtime dataset with SQL. Nothing here affects course progress.

dataset

A 1-in-87 sample of New York City yellow taxi trips from January–March 2025: pickup and drop-off zones, distances, fares, tips, fees and payment types.

129,001 rows7 tables2025-01 – 2025-03

tables

Open a table to see what one row means, its columns and keys, and a preview. Start from trips: it is the dataset's central table.

boroughs8 rows · 2 columns

One New York City borough, plus labels for unknown and outside-NYC locations.

borough_idINTEGERPK
Borough key
borough_nameTEXT
Borough label as published by TLC

zones265 rows · 5 columns

One taxi pickup/dropoff zone in New York City.

zone_idINTEGERPK
Taxi zone ID
zone_nameTEXT
Zone name
borough_idINTEGER→ boroughs
Borough containing the zone
service_zoneTEXT
Yellow Zone, Boro Zone, Airports, EWR or N/A
is_airportINTEGER
1 for airport zones (service_zone Airports or EWR)

vendors4 rows · 2 columns

One system that recorded the trip data.

vendor_idINTEGERPK
Vendor ID
vendor_nameTEXT
Provider name

payment_types7 rows · 3 columns

One way a trip can be paid (for example card or cash).

payment_type_idINTEGERPK
Payment type code
descriptionTEXT
Meaning of the code
tip_recordedINTEGER
1 when tips are captured in tip_amount (card payments only; cash tips are not recorded)

rate_codes7 rows · 2 columns

One taxi fare type (for example standard, JFK, or negotiated).

rate_code_idINTEGERPK
Rate code
descriptionTEXT
Meaning of the code

calendar90 rows · 7 columns

One calendar date in the first quarter of 2025.

dateTEXTPK
Calendar date (YYYY-MM-DD)
monthINTEGER
Month number
day_of_weekINTEGER
0 = Sunday … 6 = Saturday
day_nameTEXT
Day name
is_weekendINTEGER
1 on Saturday and Sunday
holiday_nameTEXT · nullable
U.S. federal holiday, NULL otherwise
day_of_monthINTEGER
Day of the month, 1–31

trips128,620 rows · 19 columns

One yellow taxi trip from January–March 2025.

trip_idINTEGERPK
Trip key
vendor_idINTEGER→ vendors
Recording vendor
pickup_atTEXT
Meter engaged, NYC local time
dropoff_atTEXT
Meter disengaged, NYC local time
passenger_countINTEGER · nullable
Driver-entered passengers; NULL when not reported
trip_distance_milesREAL
Taximeter distance in miles; can be 0
rate_code_idINTEGER · nullable→ rate_codes
Final rate code; NULL when not reported
store_and_fwd_flagTEXT · nullable
Y when the record was held in the vehicle before sending
pickup_zone_idINTEGER→ zones
Pickup taxi zone
dropoff_zone_idINTEGER→ zones
Drop-off taxi zone
payment_type_idINTEGER→ payment_types
How the passenger paid
fare_amountREAL
Time-and-distance fare in USD; negative on reversals
tip_amountREAL
Tip in USD; card tips only (cash tips are not recorded)
tolls_amountREAL
Tolls in USD
surcharge_amountREAL
Extra + MTA tax + improvement surcharge, USD
congestion_surchargeREAL · nullable
NYS congestion surcharge, USD
airport_feeREAL · nullable
LaGuardia/JFK pickup fee, USD
cbd_congestion_feeREAL · nullable
MTA Congestion Relief Zone toll (from 2025-01-05), USD
total_amountREAL
Total charged to the passenger excluding cash tips, USD

relationships

How to join these tables. Left column matches the right column.

zones.borough_id joins to boroughs.borough_id
trips.vendor_id joins to vendors.vendor_id
trips.rate_code_id joins to rate_codes.rate_code_id
trips.pickup_zone_id joins to zones.zone_id
trips.dropoff_zone_id joins to zones.zone_id
trips.payment_type_id joins to payment_types.payment_type_id