From a 500-row sample across 19 columns.
tolls_amountmta_taxratecodeid+17tolls_amountmta_taxratecodeid+17tolls_amountmta_taxratecodeid+9| vendorid | lpep_pickup_datetime | lpep_dropoff_datetime | store_and_fwd_flag | ratecodeid | dropoff_latitude | passenger_count | trip_distance | fare_amount | extra | mta_tax | tip_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2013-09-23T10:52:00.000 | 2013-09-23T10:52:00.000 | N | 1 | 0 | 1 | 0 | 1.8 | 0 | 0 | 0.25 |
| 1 | 2013-11-09T00:55:29.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 0% | 21of 2 |
lpep_pickup_datetime | datetime | — | 0% | 2013-10-22T12:40:36.0002013-10-02T23:08:00.0002013-10-02T23:17:00.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2013-10-22T12:43:33.0002013-10-02T23:08:09.0002013-10-02T23:22:54.000 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
GET /api/datasets/ghpb-fpea GET /api/datasets/ghpb-fpea/quality GET /api/datasets/ghpb-fpea/related GET /api/columns?dataset=ghpb-fpea
tolls_amountmta_taxratecodeid+9tolls_amountmta_taxratecodeid+9tolls_amountmta_taxratecodeid+9tolls_amountmta_taxratecodeid+9tolls_amountmta_taxratecodeid+9| 2013-11-09T00:55:29.000 |
| N |
| 1 |
| 0 |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 | 2013-09-17T21:45:09.000 | 2013-09-17T21:52:20.000 | N | 4 | 0 | 1 | 0 | 8.5 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
| 2 | 2013-10-02T23:17:00.000 | 2013-10-02T23:22:54.000 | N | 1 | 0 | 1 | 0 | 2.8 | 0 | 0.5 | 0 |
Showing 12 of 19 columns. All of them are listed below.
ratecodeid | categorical | — | 0% | 152of 7 |
dropoff_latitude | float | — | 0% | 040.75807571411132840.758186340332031 |
passenger_count | categorical | — | 0% | 152of 10 |
trip_distance | float | — | 0% | 010.9 |
fare_amount | float | — | 0% | 66.55.5 |
extra | float | — | 0% | 00.51 |
mta_tax | categorical | — | 0% | 0.500.25of 10 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 05.332.44 |
ehail_fee | numeric | — | 100% | — |
total_amount | float | — | 0% | 786.5 |
payment_type | categorical | — | 0% | 213of 4 |
trip_type | integer | — | 99% | 1of 1 |
pickup_longitude | float | — | 0% | 0-73.844268798828125-73.844276428222656 |
pickup_latitude | float | — | 0% | 040.72133636474609440.721328735351562 |
dropoff_longitude | float | — | 0% | 0-73.937301635742188-73.939071655273437 |