• close

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