About this Dataset

Fleet Vehicles

Dataset showing all council owned vehicles. Information ----------- The following information refers to the columns in the data: * Fleet = fleet number (specific number used to identify a vehicle) * Date of Reg = The date the vehicle was first registered * Dispose Date = Date the vehicle is or was scheduled to be replaced, services sometimes decide to extend this date * Dept = The service within the council who operate the vehicle * Depot = The location where the vehicle is stored * Fuel used = type of fuel the vehicle is powered by * Total distance = Total mileage of the vehicle since Date of Reg * Cameras = Vehicles fitted with cameras. Please note this information is still being collated therefore is not yet complete * Workshop = vehicles fixed in-house and those maintained by private garages From 2019 we also include a column which indicates if the vehicle is owned/hired/leased. Further Information ------------------- * If you have any further queries you can contact the Head of Fleet Services, Terry Pycroft, by emailing terry.pycroft@leeds.gov.uk or calling 0113 378 1440.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:52:06Z

Tables

Fleet List 2020

@ukgov.fleet_vehicles.fleet_list_2020

71.39 kB
1,924 rows
22 columns

CREATE TABLE fleet_list_2020 (
  "n_14_10_2020" VARCHAR  -- 14/10/2020,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" DOUBLE  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

07/12/2017

@ukgov.fleet_vehicles.n_07_12_2017

62.32 kB
1,410 rows
13 columns

CREATE TABLE n_07_12_2017 (
  "fleet_number" VARCHAR,
  "reg_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "date_of_reg" TIMESTAMP,
  "date_due_disposal" TIMESTAMP,
  "description" VARCHAR,
  "depot" VARCHAR,
  "fuel_used" VARCHAR,
  "odo_reading" BIGINT,
  "cameras_fitted" VARCHAR,
  "where_maintained" VARCHAR
);

10/01/2017

@ukgov.fleet_vehicles.n_10_01_2017

57.16 kB
1,126 rows
14 columns

CREATE TABLE n_10_01_2017 (
  "fleet_number" BIGINT,
  "reg_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "date_or_registration" TIMESTAMP,
  "estimated_disposal_date" TIMESTAMP,
  "description" VARCHAR,
  "department" VARCHAR,
  "depot" VARCHAR,
  "fuel" VARCHAR,
  "odo_to_date" BIGINT,
  "cameras_fitted" VARCHAR,
  "where_maintained" VARCHAR
);

13/07/2016

@ukgov.fleet_vehicles.n_13_07_2016

53.86 kB
1,165 rows
19 columns

CREATE TABLE n_13_07_2016 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "fleet_number" BIGINT,
  "vehicle_type" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "date_of_1st_registration" TIMESTAMP,
  "estimated_disposal" TIMESTAMP,
  "description" VARCHAR,
  "dept" VARCHAR,
  "depot" VARCHAR,
  "fuel_used" VARCHAR,
  "total_distance" BIGINT,
  "unit_of_dist" VARCHAR,
  "cameras" VARCHAR,
  "workshop" VARCHAR
);

20/11/2018

@ukgov.fleet_vehicles.n_20_11_2018

45.05 kB
1,149 rows
10 columns

CREATE TABLE n_20_11_2018 (
  "reg_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "build_mmyy" TIMESTAMP,
  "date_dispose" TIMESTAMP,
  "description" VARCHAR,
  "fuel_used" VARCHAR,
  "odometer_dis" BIGINT,
  "workshop" VARCHAR
);

23/09/2019

@ukgov.fleet_vehicles.n_23_09_2019

46.23 kB
1,157 rows
11 columns

CREATE TABLE n_23_09_2019 (
  "number" VARCHAR,
  "registration" VARCHAR,
  "vehicle_type" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "build_mmyy" TIMESTAMP  -- Build - Mmyy,
  "date_disposal" TIMESTAMP  -- Date - Disposal,
  "fuel_used" VARCHAR,
  "odometer_dis" DOUBLE,
  "groups" VARCHAR,
  "owned_hired_leased" VARCHAR
);

25/02/2015

@ukgov.fleet_vehicles.n_25_02_2015

53.5 kB
1,107 rows
19 columns

CREATE TABLE n_25_02_2015 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "fleet_number" BIGINT,
  "vehicle_type" VARCHAR,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "date_of_reg" TIMESTAMP,
  "dispose_date" TIMESTAMP,
  "description" VARCHAR,
  "dept" VARCHAR,
  "depot" VARCHAR,
  "fuel_used" VARCHAR,
  "total_distance" BIGINT,
  "unit_of_dist" VARCHAR,
  "camera_s" VARCHAR,
  "workshop" VARCHAR
);