Name: Vehicle Fuel Economy
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Vehicle Fuel Economy

Vehicle fuel economy and other emissions statistics, fuel/engine/drivetrain types, and other vehicle and costing information.
Organization: State of California
Last updated: 2021-09-08T16:15:52.821720
Tags: emissions, fuel, fuel-economy, vehicles

Tables

Vehicle Fuel Economy

@usgov.ca_gov_vehicle_fuel_economy.vehicle_fuel_economy

1.42 MB
40,704 rows
83 columns

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
);