From a 500-row sample across 19 columns.
tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | pickup_longitude | pickup_latitude | ratecodeid | store_and_fwd_flag | dropoff_longitude | dropoff_latitude | payment_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2016-02-19T19:26:14.000 | 2016-02-19T19:49:33.000 | 1 | 9.36 | -73.98419189453125 | 40.767009735107422 | 1 | N | -73.926651000976562 | 40.868301391601563 | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 0% | 213of 3 |
tpep_pickup_datetime | datetime | — | 0% | 213of 3 |
tpep_dropoff_datetime | datetime | — | 0% | 2016-09-02T00:00:00.0002016-04-30T00:00:00.0002016-03-26T00:00:00.000 |
passenger_count | categorical | — | 0% | 125of 10 |
GET /api/datasets/uacg-pexx GET /api/datasets/uacg-pexx/quality GET /api/datasets/uacg-pexx/related GET /api/columns?dataset=uacg-pexx
tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14payment_typedolocationidpickup_longitude+16payment_typepickup_longitudedropoff_longitude+14tpep_pickup_datetimepayment_typetpep_dropoff_datetime+14| 1 | 2016-02-05T18:00:30.000 | 2016-02-05T18:05:47.000 | 2 | 0.8 | -73.964889526367187 | 40.769828796386719 | 1 | N | -73.954902648925781 | 40.769577026367188 | 1 |
| 2 | 2016-02-21T01:16:58.000 | 2016-02-21T01:25:32.000 | 1 | 2.12 | -73.921470642089844 | 40.755966186523438 | 1 | N | -73.886528015136719 | 40.755386352539063 | 1 |
| 2 | 2016-02-27T13:50:17.000 | 2016-02-27T13:56:02.000 | 1 | 0.5 | -73.991737365722656 | 40.729568481445313 | 1 | N | -73.9874267578125 | 40.733741760253906 | 1 |
| 2 | 2016-02-05T21:01:45.000 | 2016-02-05T21:27:48.000 | 1 | 4.78 | -73.951576232910156 | 40.778469085693359 | 1 | N | -73.998527526855469 | 40.729530334472656 | 1 |
| 1 | 2016-02-25T20:33:15.000 | 2016-02-25T21:07:43.000 | 1 | 18.4 | -73.782394409179688 | 40.644275665283203 | 2 | N | -73.9952392578125 | 40.740669250488281 | 1 |
| 2 | 2016-02-11T15:20:27.000 | 2016-02-11T15:31:53.000 | 1 | 1.46 | -73.979698181152344 | 40.748970031738281 | 1 | N | -73.9810791015625 | 40.733890533447266 | 1 |
| 2 | 2016-02-05T09:46:00.000 | 2016-02-05T09:57:00.000 | 1 | 1.32 | -73.972648620605469 | 40.7598876953125 | 1 | N | -73.984031677246094 | 40.743160247802734 | 1 |
| 1 | 2016-02-04T07:55:04.000 | 2016-02-04T08:06:49.000 | 1 | 1.7 | -73.959556579589844 | 40.771530151367188 | 1 | N | -73.975563049316406 | 40.751739501953125 | 1 |
| 1 | 2016-02-01T12:05:34.000 | 2016-02-01T12:13:26.000 | 1 | 1.1 | -74.005630493164062 | 40.740421295166016 | 1 | N | -73.989677429199219 | 40.74212646484375 | 1 |
Showing 12 of 19 columns. All of them are listed below.
trip_distance |
| float |
| — |
| 0% |
0.910.8 |
pickup_longitude | float | — | 47% | 0-73.982223510742188-73.982139587402344 |
pickup_latitude | float | — | 47% | 040.7741088867187540.774120330810547 |
ratecodeid | categorical | — | 0% | 125of 7 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
dropoff_longitude | float | — | 47% | 0-73.982330322265625-73.982223510742188 |
dropoff_latitude | float | — | 47% | 040.77434158325195340.750148773193359 |
payment_type | categorical | — | 0% | 123of 5 |
fare_amount | float | — | 0% | 66.57 |
extra | float | — | 0% | 00.51 |
mta_tax | float | — | 0% | 0.50-0.5 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 05.5410.5 |
improvement_surcharge | float | — | 0% | 0.3-0.30 |
total_amount | float | — | 0% | 7.87.38.3 |
pulocationid | text | — | 53% | 237161186 |
dolocationid | text | — | 53% | 161236237 |