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)

Carrentaldata

@kaggle.kushleshkumar_cornell_car_rental_dataset.carrentaldata

211.86 KB
5851 rows
15 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
ELECTRIC	5	13	12	Seattle	US	47.449107	-122.308841	WA	12847615	135	Tesla	Model X	suv	2019
ELECTRIC	5	2	1	Tijeras	US	35.11106	-106.276551	NM	15621242	190	Tesla	Model X	suv	2018
HYBRID	4.92	28	24	Albuquerque	US	35.127163	-106.566681	NM	10199256	35	Toyota	Prius	car	2012
GASOLINE	5	21	20	Albuquerque	US	35.149726	-106.711425	NM	9365496	75	Ford	Mustang	car	2018
GASOLINE	5	3	1	Albuquerque	US	35.208659	-106.601008	NM	3553565	47	Chrysler	Sebring	car	2010
GASOLINE	5	13	12	Albuquerque	US	35.068834	-106.576111	NM	7815747	58	Mercedes-Benz	GL-Class	suv	2012
GASOLINE	4.42	13	12	Albuquerque	US	35.045552	-106.633815	NM	3112016	42	GMC	Yukon XL	suv	2005
GASOLINE	4.9	12	10	Albuquerque	US	35.186542	-106.686481	NM	9536762	117	Ford	Expedition	suv	2018
GASOLINE	5	1	1	Albuquerque	US	35.061213	-106.629406	NM	14893743	102	Ford	Focus RS	car	2016
GASOLINE	4.76	22	17	Albuquerque	US	35.115363	-106.556911	NM	11389136	49	Ford	EcoSport	suv	2018


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