Website
Research
Faculty
Taxi
Search
↓
↑
Entities : 2 Attributes : 25
Entities
+
SRC_Fare Data
Attributes
Attribute Name
Data Type
Not Null
Unique
Check
Comments
medallion
varchar(50)
NO
NO
NO
A permit to operate a yellow taxi cab in New York City, it is effectively a (randomly assigned) car ID
hack_license
varchar(50)
NO
NO
NO
A license to drive the vehicle, it is effectively a (randomly assigned) driver ID.
vendor_id
varchar(50)
NO
NO
NO
Verifone Transportation Systems (VTS), or Mobile Knowledge Systems Inc (CMT), implemented as part of the Technology Passenger Enhancements Project.
pickup_datetime
varchar(50)
NO
NO
NO
Start time of the trip, mm-dd-yyyy hh24:mm:ss EDT
payment_type
varchar(50)
NO
NO
NO
Cash or credit card.
fare_amount
varchar(50)
NO
NO
NO
The meter fare, in USD
surcharge
varchar(50)
NO
NO
NO
Extra fees, such as rush hour and overnight surcharges, in USD
mta_tax
varchar(50)
NO
NO
NO
Metropolitan commuter transportation mobility tax, in USD.
tip_amount
varchar(50)
NO
NO
NO
Tip amount, in USD.
tolls_amount
varchar(50)
NO
NO
NO
Total price paid for tolls, summed across all tolls for the trip, in USD.
total_amount
varchar(50)
NO
NO
NO
All charges that are presented to the passenger at time of fare payment (includes tip for non-cash trips), in USD.
+
SRC_TripData
Attributes
Attribute Name
Data Type
Not Null
Unique
Check
Comments
medallion
varchar(50)
NO
NO
NO
A permit to operate a yellow taxi cab in New York City, it is effectively a (randomly assigned) car ID
hack_license
varchar(50)
NO
NO
NO
A license to drive the vehicle, it is effectively a (randomly assigned) driver ID.
vendor_id
varchar(50)
NO
NO
NO
Verifone Transportation Systems (VTS), or Mobile Knowledge Systems Inc (CMT), implemented as part of the Technology Passenger Enhancements Project.
rate_code
varchar(50)
NO
NO
NO
Taximeter rate
store_and_fwd_flag
varchar(50)
NO
NO
NO
Unknown Attribute
pickup_datetime
varchar(50)
NO
NO
NO
Start time of the trip, mm-dd-yyyy hh24:mm:ss EDT
dropoff_datetime
varchar(50)
NO
NO
NO
End time of the trip, mm-dd-yyyy hh24:mm:ss EDT
passenger_count
varchar(50)
NO
NO
NO
Number of passengers on the trip, default value is one.
trip_time_in_secs
varchar(50)
NO
NO
NO
Trip time measured by the taximeter in seconds.
trip_distance
varchar(50)
NO
NO
NO
Trip distance measured by the taximeter in miles.
pickup_longitude
varchar(50)
NO
NO
NO
GPS coordinate for longitude at the start of the trip
pickup_latitude
varchar(50)
NO
NO
NO
GPS coordinate for latitude at the start of the trip
dropoff_longitude
varchar(50)
NO
NO
NO
GPS coordinate for longitude at the end of the trip
dropoff_latitude
varchar(50)
NO
NO
NO
GPS coordinate for latitude at the end of the trip