From a 500-row sample across 20 columns.
tpep_dropoff_datetimeairport_feeimprovement_surcharge+16tpep_dropoff_datetimeairport_feeimprovement_surcharge+16tpep_dropoff_datetimeimprovement_surchargepassenger_count+15| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | ratecodeid | store_and_fwd_flag | pulocationid | dolocationid | payment_type | fare_amount | extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2025-01-01T00:18:38.000 | 2025-01-01T00:26:59.000 | 1.0 | 1.6 | 1.0 | N | 229 | 237 | 1 | 10.0 | 3.5 |
| 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | A code indicating the TPEP provider that provided the record. | 0% | 217of 4 |
tpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2025-12-15T17:38:00.0002025-03-20T21:59:00.0002025-04-05T23:24:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2025-12-15T17:38:00.0002025-01-19T00:00:00.0002025-02-14T20:25:00.000 |
passenger_count | categorical | The number of passengers in the vehicle. | 24% |
GET /api/datasets/irx2-vgm4 GET /api/datasets/irx2-vgm4/quality GET /api/datasets/irx2-vgm4/related GET /api/columns?dataset=irx2-vgm4
tpep_dropoff_datetimeimprovement_surchargepassenger_count+15tpep_dropoff_datetimeimprovement_surchargepassenger_count+15tpep_dropoff_datetimeimprovement_surchargepassenger_count+14tpep_dropoff_datetimeimprovement_surchargepassenger_count+14improvement_surchargepassenger_counttip_amount+12| 2025-01-01T00:32:40.000 |
| 2025-01-01T00:35:13.000 |
| 1.0 |
| 0.5 |
| 1.0 |
| N |
| 236 |
| 237 |
| 1 |
| 5.1 |
| 3.5 |
| 1 | 2025-01-01T00:44:04.000 | 2025-01-01T00:46:01.000 | 1.0 | 0.6 | 1.0 | N | 141 | 141 | 1 | 5.1 | 3.5 |
| 2 | 2025-01-01T00:14:27.000 | 2025-01-01T00:20:01.000 | 3.0 | 0.52 | 1.0 | N | 244 | 244 | 2 | 7.2 | 1.0 |
| 2 | 2025-01-01T00:21:34.000 | 2025-01-01T00:25:06.000 | 3.0 | 0.66 | 1.0 | N | 244 | 116 | 2 | 5.8 | 1.0 |
| 2 | 2025-01-01T00:48:24.000 | 2025-01-01T01:08:26.000 | 2.0 | 2.63 | 1.0 | N | 239 | 68 | 2 | 19.1 | 1.0 |
| 1 | 2025-01-01T00:14:47.000 | 2025-01-01T00:16:15.000 | 0.0 | 0.4 | 1.0 | N | 170 | 170 | 1 | 4.4 | 3.5 |
| 1 | 2025-01-01T00:39:27.000 | 2025-01-01T00:51:51.000 | 0.0 | 1.6 | 1.0 | N | 234 | 148 | 1 | 12.1 | 3.5 |
| 1 | 2025-01-01T00:53:43.000 | 2025-01-01T01:13:23.000 | 0.0 | 2.8 | 1.0 | N | 148 | 170 | 1 | 19.1 | 3.5 |
| 2 | 2025-01-01T00:00:02.000 | 2025-01-01T00:09:36.000 | 1.0 | 1.71 | 1.0 | N | 237 | 262 | 2 | 11.4 | 1.0 |
Showing 12 of 20 columns. All of them are listed below.
1.02.03.0of 10 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 0.00.91.0 |
ratecodeid | categorical | The final rate code in effect at the end of the trip. | 24% | 1.02.05.0of 7 |
store_and_fwd_flag | categorical | This flag indicates whether the trip record was held in vehicle memory before sending to the vendor, aka “store and forward,” because the vehicle did not have a connection to the server. | 24% | NYof 2 |
pulocationid | integer | TLC Taxi Zone in which the taximeter was engaged | 0% | 237161132 |
dolocationid | integer | TLC Taxi Zone in which the taximeter was disengaged | 0% | 236237161 |
payment_type | categorical | A numeric code signifying how the passenger paid for the trip. | 0% | 102of 6 |
fare_amount | float | The time-and-distance fare calculated by the meter. For additional information on the following columns, see https://www.nyc.gov/site/tlc/passengers/taxi-fare.page | 0% | 8.69.37.9 |
extra | float | Miscellaneous extras and surcharges. | 0% | 0.01.02.5 |
mta_tax | float | Tax that is automatically triggered based on the metered rate in use. | 0% | 0.5-0.50.0 |
tip_amount | float | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0% | 0.02.01.0 |
tolls_amount | float | Total amount of all tolls paid in trip. | 0% | 0.06.94-6.94 |
improvement_surcharge | categorical | Improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0% | 1.0-1.00.0of 6 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 17.721.919.38 |
congestion_surcharge | categorical | Total amount collected in trip for NYS congestion surcharge. | 24% | 2.50.0-2.5of 6 |
airport_fee | categorical | For pick up only at LaGuardia and John F. Kennedy Airports. | 24% | 0.01.75-1.75of 8 |
cbd_congestion_fee | categorical | Per-trip charge for MTA's Congestion Relief Zone starting Jan. 5, 2025 | 0% | 0.750.0-0.75of 6 |
request_source | categorical | Origin of e-hail request | 87% | HV0003AEH0004of 5 |