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

69.71 KB
1924 rows
22 columns


CREATE TABLE fleet_list_2020 (
  "n_14_10_2020" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" DOUBLE,
  "unnamed_21" VARCHAR
);

07/12/2017

@ukgov.fleet_vehicles.n_07_12_2017

60.86 KB
1410 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

55.82 KB
1126 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

52.59 KB
1165 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

44 KB
1149 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

45.15 KB
1157 rows
11 columns


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

25/02/2015

@ukgov.fleet_vehicles.n_25_02_2015

52.25 KB
1107 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
);