Freedom Of Information (FOI) - Cambridgeshire County Council
Cambridgeshire Insight
@ukgov.freedom_of_information_foi_cambridgeshire_county_council1
Cambridgeshire Insight
@ukgov.freedom_of_information_foi_cambridgeshire_county_council1
CREATE TABLE freedom_of_information_statistics_2010_2011 (
"body" VARCHAR,
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2011_2012 (
"body" VARCHAR,
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2012_2013 (
"body" VARCHAR,
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2013_2014 (
"body" VARCHAR,
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2014_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2015_2016 (
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2016_2017 (
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2017_2018 (
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2018_2019 (
"body" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass" BIGINT,
"fail" BIGINT,
"pass_f29dff" VARCHAR
);
CREATE TABLE freedom_of_information_statistics_2019_2020 (
"body_name" VARCHAR,
"month" VARCHAR,
"foi_requests_due" BIGINT,
"pass_closed_in_20_working_days_or_fewer" BIGINT,
"fail_closed_in_over_20_working_days" BIGINT,
"n__pass" VARCHAR
);
Anyone who has the link will be able to view this.