2020 Yellow Taxi Trip Data (January - June)
- base
- fhv
- high volume
- lyft
- trip
- And 4 more...
2020 Yellow Taxi Trip Data (January - June)
These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi in 2020. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
VendorID | vendorid | vendorid | number | |
tpep_pickup_datetime | tpep_pickup_datetime | tpep_pickup_datetime | calendar_date | |
tpep_dropoff_datetime | tpep_dropoff_datetime | tpep_dropoff_datetime | calendar_date | |
passenger_count | passenger_count | passenger_count | number | |
trip_distance | trip_distance | trip_distance | number | |
RatecodeID | ratecodeid | ratecodeid | number | |
store_and_fwd_flag | store_and_fwd_flag | store_and_fwd_flag | text | |
PULocationID | pulocationid | pulocationid | number | |
DOLocationID | dolocationid | dolocationid | number | |
payment_type | payment_type | payment_type | number | |
fare_amount | fare_amount | fare_amount | number | |
extra | extra | extra | number | |
mta_tax | mta_tax | mta_tax | number | |
tip_amount | tip_amount | tip_amount | number | |
tolls_amount | tolls_amount | tolls_amount | number | |
improvement_surcharge | improvement_surcharge | improvement_surcharge | number | |
total_amount | total_amount | total_amount | number | |
congestion_surcharge | congestion_surcharge | congestion_surcharge | number |