From a 500-row sample across 18 columns.
store_and_fwd_flagfare_amountpayment_type+16store_and_fwd_flagfare_amountpayment_type+16store_and_fwd_flagfare_amountpayment_type+14| vendorid | lpep_pickup_datetime | lpep_dropoff_datetime | store_and_fwd_flag | ratecodeid | pulocationid | dolocationid | passenger_count | trip_distance | fare_amount | extra | mta_tax |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2018-01-01T00:18:50.000 | 2018-01-01T00:24:39.000 | N | 1 | 236 | 236 | 5 | 0.70 | 6 | 0.5 | 0.5 |
| 2 |
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% | 2018-04-18T11:11:39.0002018-04-18T11:18:53.0002018-02-03T15:15:19.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2018-01-08T00:00:00.0002018-01-07T00:00:00.0002018-01-11T00:00:00.000 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
GET /api/datasets/w7fs-fd9i GET /api/datasets/w7fs-fd9i/quality GET /api/datasets/w7fs-fd9i/related GET /api/columns?dataset=w7fs-fd9i
store_and_fwd_flagfare_amountpayment_type+16store_and_fwd_flagfare_amountpayment_type+12store_and_fwd_flagfare_amountpayment_type+12store_and_fwd_flagfare_amountpayment_type+12store_and_fwd_flagfare_amountpayment_type+8| 2018-01-01T00:30:26.000 |
| 2018-01-01T00:46:42.000 |
| N |
| 1 |
| 43 |
| 42 |
| 5 |
| 3.50 |
| 14.5 |
| 0.5 |
| 0.5 |
| 2 | 2018-01-01T00:07:25.000 | 2018-01-01T00:19:45.000 | N | 1 | 74 | 152 | 1 | 2.14 | 10 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:32:40.000 | 2018-01-01T00:33:41.000 | N | 1 | 255 | 255 | 1 | 0.03 | -3 | -0.5 | -0.5 |
| 2 | 2018-01-01T00:32:40.000 | 2018-01-01T00:33:41.000 | N | 1 | 255 | 255 | 1 | 0.03 | 3 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:38:35.000 | 2018-01-01T01:08:50.000 | N | 1 | 255 | 161 | 1 | 5.63 | 21 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:18:41.000 | 2018-01-01T00:28:22.000 | N | 1 | 189 | 65 | 5 | 1.71 | 8.5 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:38:02.000 | 2018-01-01T00:55:02.000 | N | 1 | 189 | 225 | 5 | 3.45 | 14.5 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:05:02.000 | 2018-01-01T00:18:35.000 | N | 1 | 129 | 82 | 1 | 1.61 | 10 | 0.5 | 0.5 |
| 2 | 2018-01-01T00:35:23.000 | 2018-01-01T00:42:07.000 | N | 1 | 226 | 7 | 1 | 1.87 | 7.5 | 0.5 | 0.5 |
Showing 12 of 18 columns. All of them are listed below.
ratecodeid | categorical | — | 0% | 152of 7 |
pulocationid | integer | — | 0% | 747541 |
dolocationid | integer | — | 0% | 744241 |
passenger_count | categorical | — | 0% | 125of 10 |
trip_distance | float | — | 0% | 0.000.901.00 |
fare_amount | float | — | 0% | 66.55.5 |
extra | categorical | — | 0% | 00.51of 14 |
mta_tax | categorical | — | 0% | 0.50-0.5of 7 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 05.762.64 |
ehail_fee | text | — | 100% | — |
improvement_surcharge | categorical | — | 0% | 0.30-0.3of 4 |
total_amount | float | — | 0% | 7.86.87.3 |
payment_type | categorical | — | 0% | 123of 5 |
trip_type | categorical | — | 0% | 12of 2 |