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

35.79 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_percent" DOUBLE,
  "boys_sen_k_support_number" BIGINT,
  "boys_sen_k_support_percent" DOUBLE,
  "girls_sen_k_support_number" BIGINT,
  "girls_sen_k_support_percent" DOUBLE,
  "pupils_sen_e_ehcplan_number" BIGINT,
  "pupils_sen_e_ehcplan_percent" DOUBLE,
  "boys_sen_e_ehcplan_number" BIGINT,
  "boys_sen_e_ehcplan_percent" DOUBLE,
  "girls_sen_e_ehcplan_number" BIGINT,
  "girls_sen_e_ehcplan_percent" DOUBLE
);

Table 2

@ukgov.school_pupils_special_educational_needs.table_2

11.75 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,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);