About this Dataset

Real-World Fuel Efficiency

This is a report of city vehicles and actual MPG compared to EPA estimated MPG. Each line of data is a combination of all the active vehicles on the city’s telematics system broken down into year/make/model/standard type with fueling and usage data. The intent is for each line to represent the sticker MPG and the real-world MPG and how these compare to each other. The report can be found at https://www1.nyc.gov/assets/dcas/downloads/pdf/fleet/NYC-Fleet-Newsletter-306-May-27-2020-Hybrids-Work-Even-Better-in-Reality-Than-in-Theory.pdf.
Organization: City of New York
Last updated: 2021-12-03T10:30:00.572073
Tags: cars, dcas, department-of-citywide-administrative-services, efficiency, fleet, fleet-management, fuel, hybrid, make, miles, model, mpg, non-hybrid, vehicle

Tables

Table 1

@usgov.city_of_new_york_real_world_fuel_efficiency.table_1

16.49 kB
106 rows
14 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "hybrid_non_hybrid" VARCHAR,
  "standard_type" VARCHAR,
  "epa_rating_city" BIGINT  -- EPA RATING (CITY),
  "vehicle_count" BIGINT,
  "total_actual_miles" BIGINT,
  "total_actual_fuel" DOUBLE,
  "epa_expected_fuel" DOUBLE,
  "actual_fuel_economy_geotab" DOUBLE,
  "percent_difference_actual_to_epa" DOUBLE  -- PERCENT % DIFFERENCE ACTUAL TO EPA,
  "estimated_fuel_costs_per_gallon" VARCHAR,
  "fuel_costs_per_mile" VARCHAR
);