About this Dataset

Consistent Financial Reporting - Leeds Schools

Dataset showing total expediture and income for schools using Consistent Financial Reporting (CFR) framework.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:18Z

Tables

CFR Codes Guidance

@ukgov.consistent_financial_reporting_leeds_schools.cfr_codes_guidance

4.68 kB
63 rows
3 columns

CREATE TABLE cfr_codes_guidance (
  "columncode" VARCHAR,
  "columndescription" VARCHAR,
  "columncategory" VARCHAR
);

2013/14

@ukgov.consistent_financial_reporting_leeds_schools.n_2013_14

110.01 kB
239 rows
67 columns

CREATE TABLE n_2013_14 (
  "dcsf_no" BIGINT,
  "school" VARCHAR,
  "type" VARCHAR,
  "i01" BIGINT,
  "i02" BIGINT,
  "i03" BIGINT,
  "i04" BIGINT,
  "i05" BIGINT,
  "i06" BIGINT,
  "i07" BIGINT,
  "i08" BIGINT,
  "i09" BIGINT,
  "i10" BIGINT,
  "i11" BIGINT,
  "i12" BIGINT,
  "i13" BIGINT,
  "i15" BIGINT,
  "i16" BIGINT,
  "i17" BIGINT,
  "i18" BIGINT,
  "e01" BIGINT,
  "e02" BIGINT,
  "e03" BIGINT,
  "e04" BIGINT,
  "e05" BIGINT,
  "e06" BIGINT,
  "e07" BIGINT,
  "e08" BIGINT,
  "e09" BIGINT,
  "e10" BIGINT,
  "e11" BIGINT,
  "e12" BIGINT,
  "e13" BIGINT,
  "e14" BIGINT,
  "e15" BIGINT,
  "e16" BIGINT,
  "e17" BIGINT,
  "e18" BIGINT,
  "e19" BIGINT,
  "e20" BIGINT,
  "e21" BIGINT,
  "e22" BIGINT,
  "e23" BIGINT,
  "e24" BIGINT,
  "e25" BIGINT,
  "e26" BIGINT,
  "e27" BIGINT,
  "e28" BIGINT,
  "e29" BIGINT,
  "e30" BIGINT,
  "e31" BIGINT,
  "e32" BIGINT,
  "ci01" BIGINT,
  "ci03" BIGINT,
  "ci04" BIGINT,
  "ce01" BIGINT,
  "ce02" BIGINT,
  "ce03" BIGINT,
  "ce04" BIGINT,
  "ob01" BIGINT,
  "ob02" BIGINT,
  "ob03" BIGINT,
  "b01" BIGINT,
  "b02" BIGINT,
  "b03" BIGINT,
  "b05" BIGINT,
  "b06" BIGINT
);

2014/15

@ukgov.consistent_financial_reporting_leeds_schools.n_2014_15

110.23 kB
234 rows
67 columns

CREATE TABLE n_2014_15 (
  "dfe_no" BIGINT,
  "school" VARCHAR,
  "type" VARCHAR,
  "i01" BIGINT,
  "i02" BIGINT,
  "i03" BIGINT,
  "i04" BIGINT,
  "i05" BIGINT,
  "i06" BIGINT,
  "i07" BIGINT,
  "i08" BIGINT,
  "i09" BIGINT,
  "i10" BIGINT,
  "i11" BIGINT,
  "i12" BIGINT,
  "i13" BIGINT,
  "i15" BIGINT,
  "i16" BIGINT,
  "i17" BIGINT,
  "i18" BIGINT,
  "e01" BIGINT,
  "e02" BIGINT,
  "e03" BIGINT,
  "e04" BIGINT,
  "e05" BIGINT,
  "e06" BIGINT,
  "e07" BIGINT,
  "e08" BIGINT,
  "e09" BIGINT,
  "e10" BIGINT,
  "e11" BIGINT,
  "e12" BIGINT,
  "e13" BIGINT,
  "e14" BIGINT,
  "e15" BIGINT,
  "e16" BIGINT,
  "e17" BIGINT,
  "e18" BIGINT,
  "e19" BIGINT,
  "e20" BIGINT,
  "e21" BIGINT,
  "e22" BIGINT,
  "e23" BIGINT,
  "e24" BIGINT,
  "e25" BIGINT,
  "e26" BIGINT,
  "e27" BIGINT,
  "e28" BIGINT,
  "e29" BIGINT,
  "e30" BIGINT,
  "e31" BIGINT,
  "e32" BIGINT,
  "ci01" BIGINT,
  "ci03" BIGINT,
  "ci04" BIGINT,
  "ce01" BIGINT,
  "ce02" BIGINT,
  "ce03" BIGINT,
  "ce04" BIGINT,
  "ob01" BIGINT,
  "ob02" BIGINT,
  "ob03" BIGINT,
  "b01" BIGINT,
  "b02" BIGINT,
  "b03" BIGINT,
  "b05" BIGINT,
  "b06" BIGINT
);

2015/16

@ukgov.consistent_financial_reporting_leeds_schools.n_2015_16

110.2 kB
230 rows
67 columns

CREATE TABLE n_2015_16 (
  "dfe_no" BIGINT  -- DFE NO.,
  "school" VARCHAR,
  "type" VARCHAR,
  "i01" BIGINT,
  "i02" BIGINT,
  "i03" BIGINT,
  "i04" BIGINT,
  "i05" BIGINT,
  "i06" BIGINT,
  "i07" BIGINT,
  "i08" BIGINT,
  "i09" BIGINT,
  "i10" BIGINT,
  "i11" BIGINT,
  "i12" BIGINT,
  "i13" BIGINT,
  "i15" BIGINT,
  "i16" BIGINT,
  "i17" BIGINT,
  "i18" BIGINT,
  "e01" BIGINT,
  "e02" BIGINT,
  "e03" BIGINT,
  "e04" BIGINT,
  "e05" BIGINT,
  "e06" BIGINT,
  "e07" BIGINT,
  "e08" BIGINT,
  "e09" BIGINT,
  "e10" BIGINT,
  "e11" BIGINT,
  "e12" BIGINT,
  "e13" BIGINT,
  "e14" BIGINT,
  "e15" BIGINT,
  "e16" BIGINT,
  "e17" BIGINT,
  "e18" BIGINT,
  "e19" BIGINT,
  "e20" BIGINT,
  "e21" BIGINT,
  "e22" BIGINT,
  "e23" BIGINT,
  "e24" BIGINT,
  "e25" BIGINT,
  "e26" BIGINT,
  "e27" BIGINT,
  "e28" BIGINT,
  "e29" BIGINT,
  "e30" BIGINT,
  "e31" BIGINT,
  "e32" BIGINT,
  "ci01" BIGINT,
  "ci03" BIGINT,
  "ci04" BIGINT,
  "ce01" BIGINT,
  "ce02" BIGINT,
  "ce03" BIGINT,
  "ce04" BIGINT,
  "ob01" BIGINT,
  "ob02" BIGINT,
  "ob03" BIGINT,
  "b01" BIGINT,
  "b02" BIGINT,
  "b03" BIGINT,
  "b05" BIGINT,
  "b06" BIGINT
);

2018/19

@ukgov.consistent_financial_reporting_leeds_schools.n_2018_19

103.14 kB
205 rows
68 columns

CREATE TABLE n_2018_19 (
  "dfe_number" BIGINT,
  "school_name" VARCHAR,
  "type" VARCHAR,
  "i01" BIGINT,
  "i02" BIGINT,
  "i03" BIGINT,
  "i04" BIGINT,
  "i05" BIGINT,
  "i06" BIGINT,
  "i07" BIGINT,
  "i08" BIGINT,
  "i09" BIGINT,
  "i10" BIGINT,
  "i11" BIGINT,
  "i12" BIGINT,
  "i13" BIGINT,
  "i15" BIGINT,
  "i16" BIGINT,
  "i17" BIGINT,
  "i18" BIGINT,
  "e01" BIGINT,
  "e02" BIGINT,
  "e03" BIGINT,
  "e04" BIGINT,
  "e05" BIGINT,
  "e06" BIGINT,
  "e07" BIGINT,
  "e08" BIGINT,
  "e09" BIGINT,
  "e10" BIGINT,
  "e11" BIGINT,
  "e12" BIGINT,
  "e13" BIGINT,
  "e14" BIGINT,
  "e15" BIGINT,
  "e16" BIGINT,
  "e17" BIGINT,
  "e18" BIGINT,
  "e19" BIGINT,
  "e20" BIGINT,
  "e21" BIGINT,
  "e22" BIGINT,
  "e23" BIGINT,
  "e24" BIGINT,
  "e25" BIGINT,
  "e26" BIGINT,
  "e27" BIGINT,
  "e28a" BIGINT,
  "e28b" BIGINT,
  "e29" BIGINT,
  "e30" BIGINT,
  "e31" BIGINT,
  "e32" BIGINT,
  "ci01" BIGINT,
  "ci03" BIGINT,
  "ci04" BIGINT,
  "ce01" BIGINT,
  "ce02" BIGINT,
  "ce03" BIGINT,
  "ce04" BIGINT,
  "ob01" BIGINT,
  "ob02" BIGINT,
  "ob03" BIGINT,
  "b01" BIGINT,
  "b02" BIGINT,
  "b03" BIGINT,
  "b05" BIGINT,
  "b06" BIGINT
);