Young People's Situation Post-School Age
Lincolnshire County Council
@ukgov.young_people_school_situation_post_school_age
Lincolnshire County Council
@ukgov.young_people_school_situation_post_school_age
CREATE TABLE metadata_activity_description (
"dataset_id_dsid" BIGINT,
"dataset_name" VARCHAR,
"activity_definition" VARCHAR,
"activitydescription" VARCHAR
);
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
);
CREATE TABLE table_3 (
"dataset_id_dsid" 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
);
Anyone who has the link will be able to view this.