From a 500-row sample across 18 columns.
vendoridpayment_typeratecodeid+14vendoridpayment_typeratecodeid+15vendoridpayment_typeratecodeid+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 | 2021-01-01T00:30:10.000 | 2021-01-01T00:36:12.000 | 1 | 2.10 | 1 | N | 142 | 43 | 2 | 8 | 3 |
| 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. | 3% | 216of 4 |
tpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2021-09-15T17:22:00.0002021-08-21T12:49:00.0002021-12-17T17:38:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2021-12-08T00:00:00.0002021-12-14T00:00:00.0002021-12-22T00:00:00.000 |
passenger_count | categorical | The number of passengers in the vehicle | 5% |
GET /api/datasets/m6nq-qud6 GET /api/datasets/m6nq-qud6/quality GET /api/datasets/m6nq-qud6/related GET /api/columns?dataset=m6nq-qud6
vendoridpayment_typeratecodeid+14vendoridpayment_typeratecodeid+15vendoridpayment_typeratecodeid+15vendoridpayment_typeratecodeid+14vendoridpayment_typeratecodeid+15| 2021-01-01T00:51:20.000 |
| 2021-01-01T00:52:19.000 |
| 1 |
| 0.20 |
| 1 |
| N |
| 238 |
| 151 |
| 2 |
| 3 |
| 0.5 |
| 1 | 2021-01-01T00:43:30.000 | 2021-01-01T01:11:06.000 | 1 | 14.70 | 1 | N | 132 | 165 | 1 | 42 | 0.5 |
| 1 | 2021-01-01T00:15:48.000 | 2021-01-01T00:31:01.000 | 0 | 10.60 | 1 | N | 138 | 132 | 1 | 29 | 0.5 |
| 2 | 2021-01-01T00:31:49.000 | 2021-01-01T00:48:21.000 | 1 | 4.94 | 1 | N | 68 | 33 | 1 | 16.5 | 0.5 |
| 1 | 2021-01-01T00:16:29.000 | 2021-01-01T00:24:30.000 | 1 | 1.60 | 1 | N | 224 | 68 | 1 | 8 | 3 |
| 1 | 2021-01-01T00:00:28.000 | 2021-01-01T00:17:28.000 | 1 | 4.10 | 1 | N | 95 | 157 | 2 | 16 | 0.5 |
| 1 | 2021-01-01T00:12:29.000 | 2021-01-01T00:30:34.000 | 1 | 5.70 | 1 | N | 90 | 40 | 2 | 18 | 3 |
| 1 | 2021-01-01T00:39:16.000 | 2021-01-01T01:00:13.000 | 1 | 9.10 | 1 | N | 97 | 129 | 4 | 27.5 | 0.5 |
| 1 | 2021-01-01T00:26:12.000 | 2021-01-01T00:39:46.000 | 2 | 2.70 | 1 | N | 263 | 142 | 1 | 12 | 3 |
Showing 12 of 18 columns. All of them are listed below.
123of 12 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 1.000.901.10 |
ratecodeid | categorical | The final rate code in effect at the end of the trip. | 5% | 125of 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. | 5% | NYof 2 |
pulocationid | integer | TLC Taxi Zone in which the taximeter was engaged | 0% | 237236161 |
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. | 3% | 120of 6 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 6.576 |
extra | float | Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges. | 0% | 00.52.5 |
mta_tax | float | $0.50 MTA tax that is automatically triggered based on the metered rate in use. | 0% | 0.50-0.5 |
tip_amount | float | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0% | 012 |
tolls_amount | float | Total amount of all tolls paid in trip. | 0% | 06.556.12 |
improvement_surcharge | categorical | $0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0% | 0.3-0.30of 3 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 10.310.89.8 |
congestion_surcharge | categorical | — | 2% | 2.50-2.5of 13 |