Cornell Car Rental Dataset

Dataset of 5,851 Rental Cars: Make, Model, Year, Fare, Location and Fuel Type

@kaggle.kushleshkumar_cornell_car_rental_dataset

Table List

2 tables(427.56 KB)

Carrentaldatav1

@kaggle.kushleshkumar_cornell_car_rental_dataset.carrentaldatav1

215.7 KB
5851 rows
16 columns

fueltype FuelType	rating Rating	rentertripstaken RenterTripsTaken	reviewcount ReviewCount	location_city Location.city	location_country Location.country	location_latitude Location.latitude	location_longitude Location.longitude	location_state Location.state	owner_id Owner.id	rate_daily Rate.daily	vehicle_make Vehicle.make	vehicle_model Vehicle.model	vehicle_type Vehicle.type	vehicle_year Vehicle.year	airportcity Airportcity
ELECTRIC	5	13	12	Seattle	US	47.449107	-122.308841	WA	12847615	135	Tesla	Model X	suv	2019	Albuquerque
ELECTRIC	5	2	1	Tijeras	US	35.111059999999995	-106.276551	NM	15621242	190	Tesla	Model X	suv	2018	Albuquerque
HYBRID	4.92	28	24	Albuquerque	US	35.127163	-106.566681	NM	10199256	35	Toyota	Prius	car	2012	Albuquerque
GASOLINE	5	21	20	Albuquerque	US	35.149726	-106.711425	NM	9365496	75	Ford	Mustang	car	2018	Albuquerque
GASOLINE	5	3	1	Albuquerque	US	35.208659000000004	-106.601008	NM	3553565	47	Chrysler	Sebring	car	2010	Albuquerque
GASOLINE	5	13	12	Albuquerque	US	35.068834	-106.576111	NM	7815747	58	Mercedes-Benz	GL-Class	suv	2012	Albuquerque
GASOLINE	4.42	13	12	Albuquerque	US	35.045552	-106.63381499999998	NM	3112016	42	GMC	Yukon XL	suv	2005	Albuquerque
GASOLINE	4.9	12	10	Albuquerque	US	35.186542	-106.686481	NM	9536762	117	Ford	Expedition	suv	2018	Albuquerque
GASOLINE	5	1	1	Albuquerque	US	35.061213	-106.629406	NM	14893743	102	Ford	Focus RS	car	2016	Albuquerque
GASOLINE	4.76	22	17	Albuquerque	US	35.115363	-106.556911	NM	11389136	49	Ford	EcoSport	suv	2018	Albuquerque


CREATE TABLE carrentaldatav1 (
  "fueltype" VARCHAR,
  "rating" DOUBLE,
  "rentertripstaken" DOUBLE,
  "reviewcount" DOUBLE,
  "location_city" VARCHAR,
  "location_country" VARCHAR,
  "location_latitude" DOUBLE,
  "location_longitude" DOUBLE,
  "location_state" VARCHAR,
  "owner_id" DOUBLE,
  "rate_daily" DOUBLE,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_type" VARCHAR,
  "vehicle_year" DOUBLE,
  "airportcity" VARCHAR
);