LPS Call Handling Stats And LPS Offices In-person Visits
OpenDataNI
@ukgov.lps_call_handling_stats
OpenDataNI
@ukgov.lps_call_handling_stats
CREATE TABLE lps_call_handling_stats_18_19 (
"calendar_year" BIGINT,
"month" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT,
"handled" BIGINT,
"abandoned" BIGINT
);
CREATE TABLE lps_call_handling_stats_19_20 (
"calendar_year" BIGINT,
"month" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT,
"handled" BIGINT,
"abandoned" BIGINT
);
CREATE TABLE lps_call_handling_stats_2020_2021 (
"calendar_year" BIGINT,
"month" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT,
"handled" BIGINT,
"abandoned" BIGINT
);
CREATE TABLE lps_call_handling_stats_2021_22 (
"calendar_year" BIGINT,
"month" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT,
"handled" BIGINT,
"abandoned" BIGINT
);
CREATE TABLE lps_call_handling_stats_2022_23 (
"calendar_year" BIGINT,
"month" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" VARCHAR,
"handled" VARCHAR,
"abandoned" VARCHAR,
"route_failure_mapping_only" DOUBLE
);
CREATE TABLE lps_customer_information_centre_transactions_18_19 (
"calendar_year" BIGINT,
"month" VARCHAR,
"cic" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT
);
CREATE TABLE lps_customer_information_centre_transactions_2020_2021 (
"calendar_year" BIGINT,
"month" VARCHAR,
"cic" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT
);
CREATE TABLE lps_customer_information_centre_transactions_2021_22 (
"calendar_year" BIGINT,
"month" VARCHAR,
"cic" VARCHAR,
"business_area" VARCHAR,
"data_measure" VARCHAR,
"count" BIGINT
);
Anyone who has the link will be able to view this.