Traffic Commissioners: Local Bus Service Registration
Driver and Vehicle Standards Agency
@ukgov.local_bus_service_registration
Driver and Vehicle Standards Agency
@ukgov.local_bus_service_registration
CREATE TABLE bus_registeredonly_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_london_and_the_south_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_north_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_north_west_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_scotland (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_wales (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_west_midlands (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_registeredonly_west_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"registration_code" BIGINT
);
CREATE TABLE bus_variation_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_london_and_the_south_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_north_east_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_north_west_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_scotland (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_wales (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_west_midlands (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" DOUBLE,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
CREATE TABLE bus_variation_west_of_england (
"reg_no" VARCHAR,
"variation_number" BIGINT,
"service_number" VARCHAR,
"current_traffic_area" VARCHAR,
"lic_no" VARCHAR,
"discs_in_possession" BIGINT,
"authdiscs" BIGINT,
"granted_date" VARCHAR,
"exp_date" VARCHAR,
"description" VARCHAR,
"op_id" BIGINT,
"op_name" VARCHAR,
"trading_name" VARCHAR,
"address" VARCHAR,
"start_point" VARCHAR,
"finish_point" VARCHAR,
"via" VARCHAR,
"effective_date" VARCHAR,
"received_date" VARCHAR,
"end_date" VARCHAR,
"service_type_other_details" VARCHAR,
"licence_status" VARCHAR,
"registration_status" VARCHAR,
"pub_text" VARCHAR,
"service_type_description" VARCHAR,
"short_notice" VARCHAR,
"subsidies_description" VARCHAR,
"subsidies_details" VARCHAR,
"auth_description" VARCHAR,
"tao_covered_by_area" VARCHAR,
"reg_code" BIGINT
);
Anyone who has the link will be able to view this.