About this Dataset

Young People's Situation Post-School Age

This dataset shows Young People's Situation Post-School Age in Lincolnshire. The data shows numbers of Young People of academic Ages 16 and 17 by their situation group. Total numbers at quarter-end are shown by District (based on home postcode). This data is provided by the Lincolnshire County Council Children's Services - Post 16 Team. It is updated Quarterly at the end of June, September, December and March. For any enquiries about this dataset please contact Post16@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2025-04-13T04:00:02Z

Tables

Metadata - Activity Description

@ukgov.young_people_school_situation_post_school_age.metadata_activity_description

4.32 kB
7 rows
4 columns

CREATE TABLE metadata_activity_description (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "activity_definition" VARCHAR,
  "activitydescription" VARCHAR
);

Table 3

@ukgov.young_people_school_situation_post_school_age.table_3

11.75 kB
16 rows
12 columns

CREATE TABLE table_3 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "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
);

Young Peoples Situation Post-School Age

@ukgov.young_people_school_situation_post_school_age.young_peoples_situation_post_school_age

42.6 kB
8,963 rows
16 columns

CREATE TABLE young_peoples_situation_post_school_age (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" VARCHAR,
  "latestdata" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "period" VARCHAR,
  "activity" VARCHAR,
  "activitydescription" VARCHAR,
  "clientacademicage" VARCHAR,
  "numberofpersons" BIGINT
);