About this Dataset

School Pupils With Special Educational Needs (SEN)

This dataset shows numbers and percentages of pupils on roll in Lincolnshire schools who have Special Educational Needs (SEN). Indicators are included to show whether the outcome is in the form of Support (SEN-K) or an Education, Health and Care Plan (SEN-E). The dataset covers current and main pupils on the roll of schools in Lincolnshire, and includes Gender breakouts. Pupils are allocated to geographical areas (such as Wards and NHS Clinical Commissioning Groups) based on home address. Figures shown in the data as ‘Out of County’ represent pupils not resident within the Lincolnshire administrative boundary. Those are included in the Lincolnshire total. Data is suppressed where appropriate 5 persons and below (which may be shown as zero or by missing data). That and any unmatched postcodes may mean numbers for small areas might not add up exactly to figures shown for larger areas. Data is from the Schools Census and shows a snapshot in January and is updated annually. Data source: Lincolnshire County Council Children's Services. For any enquiries about this publication contact: schoolcensus@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2024-06-14T04:01:48Z

Tables

School Pupils Special Educational Needs

@ukgov.school_pupils_special_educational_needs.school_pupils_special_educational_needs

36.65 kB
160 rows
27 columns

CREATE TABLE school_pupils_special_educational_needs (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" BOOLEAN,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "year" BIGINT,
  "month" TIMESTAMP,
  "pupilstotalnumberonroll" BIGINT,
  "boystotalnumberonroll" BIGINT,
  "girlstotalnumberonroll" BIGINT,
  "pupils_sen_k_support_number" BIGINT  -- Pupils SEN(K) Support Number,
  "pupils_sen_k_support_percent" DOUBLE  -- Pupils SEN(K) Support Percent,
  "boys_sen_k_support_number" BIGINT  -- Boys SEN(K) Support Number,
  "boys_sen_k_support_percent" DOUBLE  -- Boys SEN(K) Support Percent,
  "girls_sen_k_support_number" BIGINT  -- Girls SEN(K) Support Number,
  "girls_sen_k_support_percent" DOUBLE  -- Girls SEN(K) Support Percent,
  "pupils_sen_e_ehcplan_number" BIGINT  -- Pupils SEN(E) EHCPlan Number,
  "pupils_sen_e_ehcplan_percent" DOUBLE  -- Pupils SEN(E) EHCPlan Percent,
  "boys_sen_e_ehcplan_number" BIGINT  -- Boys SEN(E) EHCPlan Number,
  "boys_sen_e_ehcplan_percent" DOUBLE  -- Boys SEN(E) EHCPlan Percent,
  "girls_sen_e_ehcplan_number" BIGINT  -- Girls SEN(E) EHCPlan Number,
  "girls_sen_e_ehcplan_percent" DOUBLE  -- Girls SEN(E) EHCPlan Percent
);

Table 2

@ukgov.school_pupils_special_educational_needs.table_2

12.04 kB
27 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);