2018 Yellow Taxi Trip Data

t29m-gskqTransportation17 columns

These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

View on NYC Open Data

Quality

C73.8 / 100

From a 500-row sample across 17 columns.

completeness100/ 25% weight

consistency53/ 20% weight

accuracy92/ 20% weight

timeliness6/ 15% weight

usability95/ 20% weight

Related datasets

2017 Yellow Taxi Trip Data0.94
joins ontpep_dropoff_datetimedolocationidtolls_amount+14
2020 Yellow Taxi Trip Data0.93
joins ontpep_dropoff_datetimedolocationidtolls_amount+14
2021 Yellow Taxi Trip Data0.92
joins ontpep_dropoff_datetimedolocationidtolls_amount+14
2019 Yellow Taxi Trip Data

Sample rows

vendorid	tpep_pickup_datetime	tpep_dropoff_datetime	passenger_count	trip_distance	ratecodeid	store_and_fwd_flag	pulocationid	dolocationid	payment_type	fare_amount	extra
2	2084-11-04T12:32:24.000	2084-11-04T12:47:41.000	1	1.34	1	N	238	236	2	10	0
2

Columns

17 queryable · 17 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`vendorid`	categorical	—	0%	`214`of 3
`tpep_pickup_datetime`	datetime	—	0%	`2018-03-25T15:15:21.0002018-03-24T15:15:17.0002018-03-27T15:15:17.000`
`tpep_dropoff_datetime`	datetime	—	0%	`2018-03-18T00:00:00.0002018-03-17T00:00:00.0002018-03-28T00:00:00.000`
`passenger_count`	categorical	—	0%	`125`

Query this from your own app

GET /api/datasets/t29m-gskq
GET /api/datasets/t29m-gskq/quality
GET /api/datasets/t29m-gskq/related
GET /api/columns?dataset=t29m-gskq