About this Dataset

FOI And EIR Statistics

A dataset to show the statistics of FOIs/EIRs received by Leeds City Council since 1st April 2010. Due to a change in systems, from 1st October 2018 the report has different column headers from previous data sets.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:45:07Z

Tables

01/04/2014 - 31/03/2015

@ukgov.foi_and_eir_statistics.n_01_04_2014_31_03_2015

57.9 KB
1986 rows
29 columns


CREATE TABLE n_01_04_2014_31_03_2015 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "period" VARCHAR,
  "clockmonth" VARCHAR,
  "ref" BIGINT,
  "intime" VARCHAR,
  "department" VARCHAR,
  "service" VARCHAR,
  "division_section" VARCHAR,
  "clockstarts" TIMESTAMP,
  "targetdate" TIMESTAMP,
  "date_received" TIMESTAMP,
  "full_response_date" VARCHAR,
  "further_info_letter" VARCHAR,
  "request_type" VARCHAR,
  "response_type" VARCHAR,
  "exemption1" VARCHAR,
  "exemption2" VARCHAR,
  "exemption3" VARCHAR,
  "exemption4" VARCHAR,
  "exemption5" VARCHAR,
  "exemption6" VARCHAR,
  "cancelled_date" VARCHAR,
  "count" BIGINT,
  "from" VARCHAR,
  "category" VARCHAR
);

01/04/2015 - 31/03/2016

@ukgov.foi_and_eir_statistics.n_01_04_2015_31_03_2016

51.33 KB
2017 rows
24 columns


CREATE TABLE n_01_04_2015_31_03_2016 (
  "period" VARCHAR,
  "clockmonth" VARCHAR,
  "ref" BIGINT,
  "intime" VARCHAR,
  "department" VARCHAR,
  "service" VARCHAR,
  "division_section" VARCHAR,
  "clockstarts" BIGINT,
  "targetdate" BIGINT,
  "date_received" BIGINT,
  "full_response_date" DOUBLE,
  "further_info_letter" DOUBLE,
  "request_type" VARCHAR,
  "response_type" VARCHAR,
  "exemption1" VARCHAR,
  "exemption2" VARCHAR,
  "exemption3" VARCHAR,
  "exemption4" VARCHAR,
  "exemption5" VARCHAR,
  "exemption6" VARCHAR,
  "cancelled_date" DOUBLE,
  "count" BIGINT,
  "from" VARCHAR,
  "category" VARCHAR
);

01/04/2016 - 31/03/2017

@ukgov.foi_and_eir_statistics.n_01_04_2016_31_03_2017

56.83 KB
2137 rows
24 columns


CREATE TABLE n_01_04_2016_31_03_2017 (
  "period" VARCHAR,
  "clockmonth" VARCHAR,
  "ref" BIGINT,
  "department" VARCHAR,
  "division_section" VARCHAR,
  "date_received" TIMESTAMP,
  "request_type" VARCHAR,
  "response_type" VARCHAR,
  "exemption1" VARCHAR,
  "exemption2" VARCHAR,
  "exemption3" VARCHAR,
  "exemption4" VARCHAR,
  "exemption5" VARCHAR,
  "exemption6" VARCHAR,
  "count" BIGINT,
  "from" VARCHAR,
  "category" VARCHAR,
  "cancelled_date" VARCHAR,
  "further_info_letter" TIMESTAMP,
  "clockstarts" TIMESTAMP,
  "targetdate" TIMESTAMP,
  "full_response_date" TIMESTAMP,
  "intime" VARCHAR,
  "service" VARCHAR
);

01/04/2017 - 31/03/2018

@ukgov.foi_and_eir_statistics.n_01_04_2017_31_03_2018

49.25 KB
2010 rows
24 columns


CREATE TABLE n_01_04_2017_31_03_2018 (
  "period" VARCHAR,
  "clockmonth" VARCHAR,
  "ref" BIGINT,
  "department" VARCHAR,
  "division_section" VARCHAR,
  "date_received" VARCHAR,
  "request_type" VARCHAR,
  "response_type" VARCHAR,
  "exemption1" VARCHAR,
  "exemption2" VARCHAR,
  "exemption3" VARCHAR,
  "exemption4" VARCHAR,
  "exemption5" VARCHAR,
  "exemption6" VARCHAR,
  "count" BIGINT,
  "from" VARCHAR,
  "category" VARCHAR,
  "cancelled_date" VARCHAR,
  "further_info_letter" VARCHAR,
  "clockstarts" VARCHAR,
  "targetdate" VARCHAR,
  "full_response_date" VARCHAR,
  "intime" VARCHAR,
  "service" VARCHAR
);

01/04/2018 - 30/09/2018

@ukgov.foi_and_eir_statistics.n_01_04_2018_30_09_2018

36.62 KB
1282 rows
23 columns


CREATE TABLE n_01_04_2018_30_09_2018 (
  "period" VARCHAR,
  "clockmonth" VARCHAR,
  "ref" BIGINT,
  "department" VARCHAR,
  "division_section" VARCHAR,
  "date_received" TIMESTAMP,
  "request_type" VARCHAR,
  "response_type" VARCHAR,
  "exemption1" VARCHAR,
  "exemption2" VARCHAR,
  "exemption3" VARCHAR,
  "exemption4" VARCHAR,
  "exemption5" VARCHAR,
  "exemption6" VARCHAR,
  "count" BIGINT,
  "from" VARCHAR,
  "category" VARCHAR,
  "cancelled_date" VARCHAR,
  "further_info_letter" TIMESTAMP,
  "clockstarts" TIMESTAMP,
  "targetdate" TIMESTAMP,
  "full_response_date" TIMESTAMP,
  "intime" VARCHAR
);

01/04/2019 - 01/06/2019

@ukgov.foi_and_eir_statistics.n_01_04_2019_01_06_2019

24.31 KB
407 rows
14 columns


CREATE TABLE n_01_04_2019_01_06_2019 (
  "period_quarter" BIGINT,
  "month" VARCHAR,
  "caseid" BIGINT,
  "opened" TIMESTAMP,
  "closed" TIMESTAMP,
  "casetype" VARCHAR,
  "requestfrom" VARCHAR,
  "directoratename" VARCHAR,
  "requestsummary" VARCHAR,
  "taskduedate" TIMESTAMP,
  "responsedate" TIMESTAMP,
  "statusname" VARCHAR,
  "responsetype" VARCHAR,
  "exemptionsused" VARCHAR
);

01/06/2019 - 01/10/2019

@ukgov.foi_and_eir_statistics.n_01_06_2019_01_10_2019

37.02 KB
1010 rows
13 columns


CREATE TABLE n_01_06_2019_01_10_2019 (
  "period_quarter" BIGINT,
  "month" VARCHAR,
  "opened" TIMESTAMP,
  "closed" TIMESTAMP,
  "casetype" VARCHAR,
  "requestfrom" VARCHAR,
  "directoratename" VARCHAR,
  "requestsummary" VARCHAR,
  "responsedate" TIMESTAMP,
  "statusname" TIMESTAMP,
  "responsetype" VARCHAR,
  "exemptionsused" VARCHAR,
  "unnamed_12" VARCHAR
);

01/10/2018 - 31/03/2019

@ukgov.foi_and_eir_statistics.n_01_10_2018_31_03_2019

49.07 KB
1085 rows
14 columns


CREATE TABLE n_01_10_2018_31_03_2019 (
  "period_quarter" BIGINT,
  "month" VARCHAR,
  "caseid" BIGINT,
  "opened" TIMESTAMP,
  "closed" TIMESTAMP,
  "casetype" VARCHAR,
  "requestfrom" VARCHAR,
  "directoratename" VARCHAR,
  "requestsummary" VARCHAR,
  "taskduedate" TIMESTAMP,
  "responsedate" TIMESTAMP,
  "statusname" VARCHAR,
  "responsetype" VARCHAR,
  "exemptionsused" VARCHAR
);