2022 Fuel Consumption Ratings

Fuel consumption dataset containing Co2 emissions, CO2 ratings and smog ratings

@kaggle.rinichristy_2022_fuel_consumption_ratings

Table List

1 table(29.36 KB)

My2022 Fuel Consumption Ratings

My2022 Fuel Consumption Ratings

@kaggle.rinichristy_2022_fuel_consumption_ratings.my2022_fuel_consumption_ratings

29.36 KB
946 rows
15 columns

model_year Model Year	make Make	model Model	vehicle_class Vehicle Class	engine_size_l Engine Size(L)	cylinders Cylinders	transmission Transmission	fuel_type Fuel Type	fuel_consumption_city_l_100_km Fuel Consumption (City (L/100 Km)	fuel_consumption_hwy_l_100_km Fuel Consumption(Hwy (L/100 Km))	fuel_consumption_comb_l_100_km Fuel Consumption(Comb (L/100 Km))	fuel_consumption_comb_mpg Fuel Consumption(Comb (mpg))	co2_emissions_g_km CO2 Emissions(g/km)	co2_rating CO2 Rating	smog_rating Smog Rating
2022	Acura	ILX	Compact	2.4	4	AM8	Z	9.9	7	8.6	33	200	6	3
2022	Acura	MDX SH-AWD	SUV: Small	3.5	6	AS10	Z	12.6	9.4	11.2	25	263	4	5
2022	Acura	RDX SH-AWD	SUV: Small	2	4	AS10	Z	11	8.6	9.9	29	232	5	6
2022	Acura	RDX SH-AWD A-SPEC	SUV: Small	2	4	AS10	Z	11.3	9.1	10.3	27	242	5	6
2022	Acura	TLX SH-AWD	Compact	2	4	AS10	Z	11.2	8	9.8	29	230	5	7
2022	Acura	TLX SH-AWD A-SPEC	Compact	2	4	AS10	Z	11.3	8.1	9.8	29	231	5	7
2022	Acura	TLX Type S	Compact	3	6	AS10	Z	12.3	9.4	11	26	256	5	5
2022	Acura	TLX Type S (Performance Tire)	Compact	3	6	AS10	Z	12.3	9.8	11.2	25	261	4	5
2022	Alfa Romeo	Giulia	Mid-size	2	4	A8	Z	10	7.2	8.7	32	205	6	3
2022	Alfa Romeo	Giulia AWD	Mid-size	2	4	A8	Z	10.5	7.7	9.2	31	217	5	3


CREATE TABLE my2022_fuel_consumption_ratings (
  "model_year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "vehicle_class" VARCHAR,
  "engine_size_l" DOUBLE,
  "cylinders" BIGINT,
  "transmission" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_consumption_city_l_100_km" DOUBLE,
  "fuel_consumption_hwy_l_100_km" DOUBLE,
  "fuel_consumption_comb_l_100_km" DOUBLE,
  "fuel_consumption_comb_mpg" BIGINT,
  "co2_emissions_g_km" BIGINT,
  "co2_rating" BIGINT,
  "smog_rating" BIGINT
);