About this Dataset

Fleet Vehicles Fuel Consumption

Dataset showing how much fuel each council vehicle has consumed, by year and by fuel type. Dataset guidance ---------------- The following information refers to the columns in the data: * Fleet = fleet number (specific number used to identify a vehicle) * Vehicle = vehicle type * Fuel = fuel used in litres * Dist.Run = Total mileage for the reporting period * MPG = Miles Per Gallon * Type = D: Diesel, G: Gas Oil Due to problems and changes with the fuel system software this data is not available for 2017/18. Data for 2018/19 will be published.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:48:12Z

Tables

2014

@ukgov.fleet_vehicles_fuel_consumption.n_2014

42.17 KB
1300 rows
11 columns


CREATE TABLE n_2014 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "fleet" VARCHAR,
  "vehicle" VARCHAR,
  "fuel" DOUBLE,
  "dist_run" VARCHAR,
  "mpg" VARCHAR,
  "type" VARCHAR
);

2016/17

@ukgov.fleet_vehicles_fuel_consumption.n_2016_17

59.47 KB
1325 rows
8 columns


CREATE TABLE n_2016_17 (
  "reference" VARCHAR,
  "fleet" VARCHAR,
  "vehicle" VARCHAR,
  "fuel" DOUBLE,
  "typ" VARCHAR,
  "odo" VARCHAR,
  "dist_run" VARCHAR,
  "mpg" VARCHAR
);