About this Dataset

School Admissions

This dataset shows school admissions, number of places offered for a given intake year at each school at annual National Offer Day (01 March - Secondary, and 16 April - Primary/Junior - these dates may vary slightly if occuring on a weekend). The dataset shows: - the total number of school places offered by preference (1 to 4) for each school - the school's Pupil Admission Number (PAN), the maximum number of places available at the school for the intake year - the total number of remaining free places, which is school places left after National Offer Day (that is, the school's PAN minus the total number of offers). This data is updated annually. Data source: Lincolnshire County Council School Admissions. For any enquiries about this publication contact schooladmissions@lincolnshire.gov.uk .
Publisher name: Lincolnshire County Council
Last updated: 2024-09-14T03:03:38Z

Tables

School Admissions

@ukgov.school_admissions.school_admissions

49.69 KB
2671 rows
20 columns


CREATE TABLE school_admissions (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" VARCHAR,
  "offersoradmissions" VARCHAR,
  "intakedescription" VARCHAR,
  "month" TIMESTAMP,
  "year" BIGINT,
  "schooltype" VARCHAR,
  "dfecode" BIGINT,
  "schoolname" VARCHAR,
  "preference1" BIGINT,
  "preference2" BIGINT,
  "preference3" BIGINT,
  "preference4" BIGINT,
  "totalpreferences" BIGINT,
  "pupiladmissionnumber_pan" BIGINT,
  "freeplaces" BIGINT
);

Table 1

@ukgov.school_admissions.table_1

11.08 KB
20 rows
12 columns


CREATE TABLE table_1 (
  "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
);