Vehicle Fuel Economy

State of California

@usgov.ca_gov_vehicle_fuel_economy

Table List

1 table(1.35 MB)

Vehicle Fuel Economy

@usgov.ca_gov_vehicle_fuel_economy.vehicle_fuel_economy

Fuel economy data are the result of vehicle testing done at the Environmental Protection Agency's National Vehicle and Fuel Emissions Laboratory in Ann Arbor, Michigan, and by vehicle manufacturers with oversight by EPA. This data was downloaded from https://www.fueleconomy.gov/feg/download.shtml.

1.35 MB
40704 rows
83 columns

barrels08 Barrels08	city08 City08	co2 Co2	co2a Co2A	co2tailpipegpm Co2TailpipeGpm	comb08 Comb08	cylinders Cylinders	displ Displ	engid EngId	eng_dscr Eng Dscr	fescore FeScore	fuelcost08 FuelCost08	fueltype FuelType	fueltype1 FuelType1	ghgscore GhgScore	ghgscorea GhgScoreA	highway08 Highway08	hlv Hlv	hpv Hpv	id Id	make Make	model Model	mpgdata MpgData	trany Trany	ucity UCity	uhighway UHighway	vclass VClass	year Year	yousavespend YouSaveSpend	tcharger TCharger	createdon CreatedOn	modifiedon ModifiedOn
15.69571429	18	-1	-1	423.1904762	21	4	2	9002	(FFS)	-1	1900	Regular	Regular Gasoline	-1	-1	25			26561	Alfa Romeo	Spider Veloce 2000	N	Manual 5-spd	23	35	Two Seaters	1984	-2000		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
14.98227273	20	-1	-1	403.9545455	22	4	1.5	12710	(FFS)	-1	1850	Regular	Regular Gasoline	-1	-1	26			26562	Bertone	X1/9	N	Manual 5-spd	25	36	Two Seaters	1984	-1750		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
21.974	13	-1	-1	592.4666667	15	8	5.7	4180	(350 V8) (FFS)	-1	2700	Regular	Regular Gasoline	-1	-1	20			26563	Chevrolet	Corvette	Y	Automatic 4-spd	16	28	Two Seaters	1984	-6000		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
21.974	13	-1	-1	592.4666667	15	8	5.7	4161	(350 V8) (FFS)	-1	2700	Regular	Regular Gasoline	-1	-1	20			26564	Chevrolet	Corvette	Y	Manual 4-spd	16	28	Two Seaters	1984	-6000		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
19.38882353	15	-1	-1	522.7647059	17	6	3	38061	(FFS,TRBO)	-1	2350	Regular	Regular Gasoline	-1	-1	20	22	50	26565	Nissan	300ZX	N	Automatic 4-spd	19	28	Two Seaters	1984	-4250	T	Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
18.31166667	16	-1	-1	493.7222222	18	6	3	38060	(FFS)	-1	2250	Regular	Regular Gasoline	-1	-1	20	22	50	26566	Nissan	300ZX	N	Automatic 4-spd	20	28	Two Seaters	1984	-3750		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
18.31166667	16	-1	-1	493.7222222	18	6	3	38061	(FFS,TRBO)	-1	2250	Regular	Regular Gasoline	-1	-1	22	22	50	26567	Nissan	300ZX	N	Manual 5-spd	20	30	Two Seaters	1984	-3750	T	Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
16.4805	18	-1	-1	444.35	20	6	3	38060	(FFS)	-1	2000	Regular	Regular Gasoline	-1	-1	24	22	50	26568	Nissan	300ZX	N	Manual 5-spd	22	33	Two Seaters	1984	-2500		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
14.33086957	21	-1	-1	386.3913043	23	4	1.6	3100		-1	1750	Regular	Regular Gasoline	-1	-1	26			26569	Ford	EXP	N	Automatic 3-spd	27	37	Two Seaters	1984	-1250		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013
13.73375	21	-1	-1	370.2916667	24	4	1.6	3101		-1	1700	Regular	Regular Gasoline	-1	-1	29			26570	Ford	EXP	N	Manual 5-spd	27	41	Two Seaters	1984	-1000		Tue Jan 01 00:00:00 EST 2013	Tue Jan 01 00:00:00 EST 2013


CREATE TABLE vehicle_fuel_economy (
  "barrels08" DOUBLE,
  "barrelsa08" DOUBLE,
  "charge120" BIGINT,
  "charge240" DOUBLE,
  "city08" BIGINT,
  "city08u" DOUBLE,
  "citya08" BIGINT,
  "citya08u" DOUBLE,
  "citycd" DOUBLE,
  "citye" DOUBLE,
  "cityuf" DOUBLE,
  "co2" BIGINT,
  "co2a" BIGINT,
  "co2tailpipeagpm" DOUBLE,
  "co2tailpipegpm" DOUBLE,
  "comb08" BIGINT,
  "comb08u" DOUBLE,
  "comba08" BIGINT,
  "comba08u" DOUBLE,
  "combe" DOUBLE,
  "combinedcd" DOUBLE,
  "combineduf" DOUBLE,
  "cylinders" VARCHAR,
  "displ" VARCHAR,
  "drive" VARCHAR,
  "engid" BIGINT,
  "eng_dscr" VARCHAR,
  "fescore" BIGINT,
  "fuelcost08" BIGINT,
  "fuelcosta08" BIGINT,
  "fueltype" VARCHAR,
  "fueltype1" VARCHAR,
  "ghgscore" BIGINT,
  "ghgscorea" BIGINT,
  "highway08" BIGINT,
  "highway08u" DOUBLE,
  "highwaya08" BIGINT,
  "highwaya08u" DOUBLE,
  "highwaycd" DOUBLE,
  "highwaye" DOUBLE,
  "highwayuf" DOUBLE,
  "hlv" BIGINT,
  "hpv" BIGINT,
  "id" BIGINT,
  "lv2" BIGINT,
  "lv4" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "mpgdata" VARCHAR,
  "phevblended" BOOLEAN,
  "pv2" BIGINT,
  "pv4" BIGINT,
  "range" BIGINT,
  "rangecity" DOUBLE,
  "rangecitya" DOUBLE,
  "rangehwy" DOUBLE,
  "rangehwya" DOUBLE,
  "trany" VARCHAR,
  "ucity" DOUBLE,
  "ucitya" DOUBLE,
  "uhighway" DOUBLE,
  "uhighwaya" DOUBLE,
  "vclass" VARCHAR,
  "year" BIGINT,
  "yousavespend" BIGINT,
  "guzzler" VARCHAR,
  "trans_dscr" VARCHAR,
  "tcharger" VARCHAR,
  "scharger" VARCHAR,
  "atvtype" VARCHAR,
  "fueltype2" VARCHAR,
  "rangea" VARCHAR,
  "evmotor" VARCHAR,
  "mfrcode" VARCHAR,
  "c240dscr" VARCHAR,
  "charge240b" DOUBLE,
  "c240bdscr" VARCHAR,
  "createdon" VARCHAR,
  "modifiedon" VARCHAR,
  "startstop" VARCHAR,
  "phevcity" BIGINT,
  "phevhwy" BIGINT,
  "phevcomb" BIGINT
);