From a 500-row sample across 17 columns.
extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+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 | 2017-01-09T11:13:28.000 | 2017-01-09T11:25:45.000 | 1 | 3.30 | 1 | N | 263 | 161 | 1 | 12.5 | 0 |
| 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 0% | 21of 2 |
tpep_pickup_datetime | datetime | — | 0% | 2017-12-05T15:15:13.0002017-02-11T15:15:50.0002017-11-05T01:12:35.000 |
tpep_dropoff_datetime | datetime | — | 0% | 2017-10-08T00:00:00.0002017-07-22T00:00:00.0002017-06-25T00:00:00.000 |
passenger_count | categorical | — | 0% | 125of 11 |
GET /api/datasets/biws-g3hs GET /api/datasets/biws-g3hs/quality GET /api/datasets/biws-g3hs/related GET /api/columns?dataset=biws-g3hs
extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+14extratpep_dropoff_datetimetrip_distance+11| 2017-01-09T11:32:27.000 |
| 2017-01-09T11:36:01.000 |
| 1 |
| 0.90 |
| 1 |
| N |
| 186 |
| 234 |
| 1 |
| 5 |
| 0 |
| 1 | 2017-01-09T11:38:20.000 | 2017-01-09T11:42:05.000 | 1 | 1.10 | 1 | N | 164 | 161 | 1 | 5.5 | 0 |
| 1 | 2017-01-09T11:52:13.000 | 2017-01-09T11:57:36.000 | 1 | 1.10 | 1 | N | 236 | 75 | 1 | 6 | 0 |
| 2 | 2017-01-01T00:00:00.000 | 2017-01-01T00:00:00.000 | 1 | 0.02 | 2 | N | 249 | 234 | 2 | 52 | 0 |
| 1 | 2017-01-01T00:00:02.000 | 2017-01-01T00:03:50.000 | 1 | 0.50 | 1 | N | 48 | 48 | 2 | 4 | 0.5 |
| 2 | 2017-01-01T00:00:02.000 | 2017-01-01T00:39:22.000 | 4 | 7.75 | 1 | N | 186 | 36 | 1 | 22 | 0.5 |
| 1 | 2017-01-01T00:00:03.000 | 2017-01-01T00:06:58.000 | 1 | 0.80 | 1 | N | 162 | 161 | 1 | 6 | 0.5 |
| 1 | 2017-01-01T00:00:05.000 | 2017-01-01T00:08:33.000 | 2 | 0.90 | 1 | N | 48 | 50 | 1 | 7 | 0.5 |
| 2 | 2017-01-01T00:00:05.000 | 2017-01-01T00:05:04.000 | 5 | 1.76 | 1 | N | 140 | 74 | 2 | 7 | 0.5 |
Showing 12 of 17 columns. All of them are listed below.
trip_distance | float | — | 0% | 0.900.801.00 |
ratecodeid | categorical | — | 0% | 125of 7 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
pulocationid | integer | — | 0% | 237161236 |
dolocationid | integer | — | 0% | 161236237 |
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.765.54 |
improvement_surcharge | categorical | — | 0% | 0.3-0.30of 14 |
total_amount | float | — | 0% | 7.87.38.3 |