From a 500-row sample across 20 columns.
ehail_feeratecodeidtotal_amount+17ehail_feeratecodeidtotal_amount+16ehail_feeratecodeidtotal_amount+16| vendorid | lpep_pickup_datetime | lpep_dropoff_datetime | store_and_fwd_flag | ratecodeid | pulocationid | dolocationid | passenger_count | trip_distance | fare_amount | extra | mta_tax |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2025-01-01T00:03:01.000 | 2025-01-01T00:17:12.000 | N | 1.0 | 75 | 235 | 1.0 | 5.93 | 24.7 | 1.0 | 0.5 |
| 2 |
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% | 216of 3 |
lpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2025-02-09T22:48:00.0002025-01-07T17:07:00.0002025-09-03T15:36:36.000 |
lpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2025-11-21T00:00:00.0002025-03-19T00:00:00.0002025-05-18T00:00:00.000 |
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. |
GET /api/datasets/nkud-f3se GET /api/datasets/nkud-f3se/quality GET /api/datasets/nkud-f3se/related GET /api/columns?dataset=nkud-f3se
ehail_feeratecodeidtotal_amount+14ehail_feeratecodeidtotal_amount+13ehail_feeratecodeidtotal_amount+13ratecodeidtotal_amounttolls_amount+13ratecodeidtotal_amounttolls_amount+13| 2025-01-01T00:19:59.000 |
| 2025-01-01T00:25:52.000 |
| N |
| 1.0 |
| 166 |
| 75 |
| 1.0 |
| 1.32 |
| 8.6 |
| 1.0 |
| 0.5 |
| 2 | 2025-01-01T00:05:29.000 | 2025-01-01T00:07:21.000 | N | 5.0 | 171 | 73 | 1.0 | 0.41 | 25.55 | 0.0 | 0.0 |
| 2 | 2025-01-01T00:52:24.000 | 2025-01-01T01:07:52.000 | N | 1.0 | 74 | 223 | 1.0 | 4.12 | 21.2 | 1.0 | 0.5 |
| 2 | 2025-01-01T00:25:05.000 | 2025-01-01T01:01:10.000 | N | 1.0 | 66 | 158 | 1.0 | 4.71 | 33.8 | 1.0 | 0.5 |
| 2 | 2025-01-01T01:03:45.000 | 2025-01-01T01:42:09.000 | N | 1.0 | 260 | 260 | 1.0 | 4.26 | 31.0 | 1.0 | 0.5 |
| 2 | 2025-01-01T00:28:12.000 | 2025-01-01T00:37:53.000 | N | 1.0 | 7 | 202 | 1.0 | 2.0 | 11.4 | 1.0 | 0.5 |
| 2 | 2025-01-01T00:25:38.000 | 2025-01-01T00:36:47.000 | N | 1.0 | 166 | 244 | 1.0 | 2.09 | 13.5 | 1.0 | 0.5 |
| 2 | 2025-01-01T00:52:04.000 | 2025-01-01T00:58:36.000 | N | 1.0 | 166 | 151 | 1.0 | 0.95 | 7.9 | 1.0 | 0.5 |
| 2 | 2024-12-31T22:42:13.000 | 2024-12-31T22:42:31.000 | N | 3.0 | 74 | 74 | 1.0 | 0.06 | 23.0 | 1.0 | 0.0 |
Showing 12 of 20 columns. All of them are listed below.
| 8% |
NYof 2 |
ratecodeid | categorical | The final rate code in effect at the end of the trip. | 8% | 1.05.02.0of 7 |
pulocationid | integer | TLC Taxi Zone in which the taximeter was engaged | 0% | 747543 |
dolocationid | integer | TLC Taxi Zone in which the taximeter was disengaged | 0% | 7523674 |
passenger_count | categorical | The number of passengers in the vehicle. | 8% | 1.02.05.0of 10 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 0.01.41.3 |
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% | 10.010.79.3 |
extra | float | Miscellaneous extras and surcharges. | 0% | 0.02.51.0 |
mta_tax | categorical | Tax that is automatically triggered based on the metered rate in use. | 0% | 0.51.50.0of 8 |
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.943.18 |
ehail_fee | text | Currently unused | 100% | — |
improvement_surcharge | categorical | Improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0% | 1.00.30.0of 5 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 16.010.815.0 |
payment_type | categorical | A numeric code signifying how the passenger paid for the trip. | 8% | 1.02.03.0of 5 |
trip_type | categorical | A code indicating whether the trip was a street-hail or a dispatch that is automatically assigned based on the metered rate in use but can be altered by the driver. | 8% | 1.02.0of 2 |
congestion_surcharge | categorical | Total amount collected in trip for NYS congestion surcharge. | 8% | 0.02.752.5of 5 |
cbd_congestion_fee | categorical | Per-trip charge for MTA's Congestion Relief Zone starting Jan. 5, 2025. | 1% | 0.00.75-0.75of 3 |
request_source | categorical | Origin of e-hail request | 95% | ACCof 2 |