Dentist And Surgery List
OpenDataNI
@ukgov.dental_list_march_2018
OpenDataNI
@ukgov.dental_list_march_2018
CREATE TABLE dental_contractor_list_december_2024 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_contractor_list_june_2024 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_contractor_list_march_2024 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_contractor_list_september_2024 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_surgery_list_december_2023 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
CREATE TABLE dental_surgery_list_december_2024 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_surgery_list_june_2019 (
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"postcode" VARCHAR,
"telephone_no" BIGINT,
"dentisttype" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
CREATE TABLE dental_surgery_list_june_2024 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_surgery_list_march_2024 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dental_surgery_list_september_2023 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
CREATE TABLE dental_surgery_list_september_2024 (
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR,
"assembly_area" VARCHAR
);
CREATE TABLE dentist_contractor_list_december_2023 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
CREATE TABLE dentist_contractor_list_september_2023 (
"gdc_no" BIGINT,
"dentist_name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"telephone_no" VARCHAR,
"dentist_type" VARCHAR,
"languages" VARCHAR,
"gdc_lookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
CREATE TABLE dentist_list_june_2019 (
"gdc_no" BIGINT,
"dentistname" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"postcode" VARCHAR,
"telephone_no" BIGINT,
"dentisttype" VARCHAR,
"languages" VARCHAR,
"gdclookup" VARCHAR,
"lcg" VARCHAR,
"lgd" VARCHAR
);
Anyone who has the link will be able to view this.