From a 500-row sample across 19 columns.
mta_taxpassenger_counttpep_dropoff_datetime+15mta_taxpassenger_counttpep_dropoff_datetime+15mta_taxpassenger_counttpep_dropoff_datetime+14| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | ratecodeid | store_and_fwd_flag | pulocationid | dolocationid | payment_type | fare_amount | extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2022-01-01T00:35:40.000 | 2022-01-01T00:53:29.000 | 2.0 | 3.8 | 1.0 | N | 142 | 236 | 1 | 14.5 | 3.0 |
| 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% | 216of 4 |
tpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2022-05-06T19:22:00.0002022-02-13T18:27:00.0002022-04-30T23:05:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2022-12-30T00:00:00.0002022-07-30T00:00:00.0002022-06-19T00:00:00.000 |
passenger_count | categorical | The number of passengers in the vehicle. | 3% |
GET /api/datasets/qp3b-zxtp GET /api/datasets/qp3b-zxtp/quality GET /api/datasets/qp3b-zxtp/related GET /api/columns?dataset=qp3b-zxtp
mta_taxpassenger_counttpep_dropoff_datetime+15mta_taxpassenger_counttpep_dropoff_datetime+14mta_taxpassenger_counttpep_dropoff_datetime+16mta_taxpassenger_counttpep_dropoff_datetime+14mta_taxpassenger_countpayment_type+7| 2022-01-01T00:33:43.000 |
| 2022-01-01T00:42:07.000 |
| 1.0 |
| 2.1 |
| 1.0 |
| N |
| 236 |
| 42 |
| 1 |
| 8.0 |
| 0.5 |
| 2 | 2022-01-01T00:53:21.000 | 2022-01-01T01:02:19.000 | 1.0 | 0.97 | 1.0 | N | 166 | 166 | 1 | 7.5 | 0.5 |
| 2 | 2022-01-01T00:25:21.000 | 2022-01-01T00:35:23.000 | 1.0 | 1.09 | 1.0 | N | 114 | 68 | 2 | 8.0 | 0.5 |
| 2 | 2022-01-01T00:36:48.000 | 2022-01-01T01:14:20.000 | 1.0 | 4.3 | 1.0 | N | 68 | 163 | 1 | 23.5 | 0.5 |
| 1 | 2022-01-01T00:40:15.000 | 2022-01-01T01:09:48.000 | 1.0 | 10.3 | 1.0 | N | 138 | 161 | 1 | 33.0 | 3.0 |
| 2 | 2022-01-01T00:20:50.000 | 2022-01-01T00:34:58.000 | 1.0 | 5.07 | 1.0 | N | 233 | 87 | 1 | 17.0 | 0.5 |
| 2 | 2022-01-01T00:13:04.000 | 2022-01-01T00:22:45.000 | 1.0 | 2.02 | 1.0 | N | 238 | 152 | 2 | 9.0 | 0.5 |
| 2 | 2022-01-01T00:30:02.000 | 2022-01-01T00:44:49.000 | 1.0 | 2.71 | 1.0 | N | 166 | 236 | 1 | 12.0 | 0.5 |
| 2 | 2022-01-01T00:48:52.000 | 2022-01-01T00:53:28.000 | 1.0 | 0.78 | 1.0 | N | 236 | 141 | 2 | 5.0 | 0.5 |
Showing 12 of 19 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.01.00.9 |
ratecodeid | categorical | The final rate code in effect at the end of the trip. | 3% | 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. | 3% | NYof 2 |
pulocationid | integer | TLC Taxi Zone in which the taximeter was engaged | 0% | 132237236 |
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% | 120of 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% | 6.57.07.5 |
extra | float | Miscellaneous extras and surcharges. | 0% | 0.00.52.5 |
mta_tax | float | Tax that is automatically triggered based on the metered rate in use. | 0% | 0.50.0-0.5 |
tip_amount | float | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0% | 0.01.02.0 |
tolls_amount | float | Total amount of all tolls paid in trip. | 0% | 0.06.5511.75 |
improvement_surcharge | categorical | Improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0% | 0.31.0-0.3of 5 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 10.811.311.8 |
congestion_surcharge | categorical | Total amount collected in trip for NYS congestion surcharge. | 3% | 2.50.0-2.5of 10 |
airport_fee | categorical | For pick up only at LaGuardia and John F. Kennedy Airports. | 3% | 0.01.25-1.25of 4 |