About this Dataset

Traffic Commissioners: Goods And Public Service Vehicle Operator Licence Records

These records are updated on a weekly basis, every Sunday. Register of all goods and public service vehicle operator licence holders in Great Britain as recorded on the Vehicle Operator Licensing database (VOL).
Publisher name: Driver and Vehicle Standards Agency
Last updated: 2025-02-20T04:00:03Z

Tables

OLBSLicenceReport East Of England

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_east_of_england

2.41 MB
33440 rows
16 columns


CREATE TABLE olbslicencereport_east_of_england (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport London And The South East Of England

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_london_and_the_south_east_of_england

1.4 MB
20086 rows
16 columns


CREATE TABLE olbslicencereport_london_and_the_south_east_of_england (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport North East Of England

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_north_east_of_england

1.81 MB
27232 rows
16 columns


CREATE TABLE olbslicencereport_north_east_of_england (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport North West Of England

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_north_west_of_england

1.64 MB
24974 rows
16 columns


CREATE TABLE olbslicencereport_north_west_of_england (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport Scotland

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_scotland

1.01 MB
15629 rows
16 columns


CREATE TABLE olbslicencereport_scotland (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport Wales

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_wales

832.64 KB
11703 rows
16 columns


CREATE TABLE olbslicencereport_wales (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport West Midlands

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_west_midlands

1.37 MB
20554 rows
16 columns


CREATE TABLE olbslicencereport_west_midlands (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);

OLBSLicenceReport West Of England

@ukgov.traffic_commissioners_goods_and_public_service_vehicle_81671850.olbslicencereport_west_of_england

1.81 MB
26999 rows
16 columns


CREATE TABLE olbslicencereport_west_of_england (
  "geographicregion" VARCHAR,
  "licencenumber" VARCHAR,
  "licencetype" VARCHAR,
  "operatorname" VARCHAR,
  "operatortype" VARCHAR,
  "correspondenceaddress" VARCHAR,
  "ocaddress" VARCHAR,
  "transportmanager" VARCHAR,
  "numberofvehiclesauthorised" BIGINT,
  "numberoftrailersauthorised" DOUBLE,
  "vehiclesspecified" BIGINT,
  "trailersspecified" BIGINT,
  "directororpartner" VARCHAR,
  "licencestatus" VARCHAR,
  "continuationdate" TIMESTAMP,
  "companyregnumber" VARCHAR
);