Education Attainment: Key Stage 4
Lincolnshire County Council
@ukgov.education_attainment_key_stage_4
Lincolnshire County Council
@ukgov.education_attainment_key_stage_4
CREATE TABLE key_stage_4 (
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"publisheddate" TIMESTAMP,
"latestdata" VARCHAR,
"durationfrom" TIMESTAMP,
"durationto" TIMESTAMP,
"reportingperiodtype" VARCHAR,
"reportingperiod" VARCHAR,
"geoentityname" VARCHAR,
"geocode" VARCHAR,
"geoname" VARCHAR,
"geouri" VARCHAR,
"year" BIGINT,
"polarity" VARCHAR,
"keystage4pupilsnumber" DOUBLE,
"keystage4boysnumber" DOUBLE,
"keystage4girlsnumber" DOUBLE,
"keystage4grade5oraboveinenglishandmathspupilsnumber" DOUBLE,
"keystage4grade5oraboveinenglishandmathsboysnumber" DOUBLE,
"keystage4grade5oraboveinenglishandmathsgirlsnumber" DOUBLE,
"keystage4grade5oraboveinenglishandmathspupilspercentage" DOUBLE,
"keystage4grade5oraboveinenglishandmathsboyspercentage" DOUBLE,
"keystage4grade5oraboveinenglishandmathsgirlspercentage" DOUBLE,
"keystage4achievingebaccatgrade5orabovepupilsnumber" DOUBLE,
"keystage4achievingebaccatgrade5oraboveboysnumber" DOUBLE,
"keystage4achievingebaccatgrade5orabovegirlsnumber" DOUBLE,
"keystage4achievingebaccatgrade5orabovepupilspercentage" DOUBLE,
"keystage4achievingebaccatgrade5oraboveboyspercentage" DOUBLE,
"keystage4achievingebaccatgrade5orabovegirlspercentage" DOUBLE,
"keystage4grade4oraboveinenglishandmathspupilsnumber" DOUBLE,
"keystage4grade4oraboveinenglishandmathsboysnumber" DOUBLE,
"keystage4grade4oraboveinenglishandmathsgirlsnumber" DOUBLE,
"keystage4grade4oraboveinenglishandmathspupilspercentage" DOUBLE,
"keystage4grade4oraboveinenglishandmathsboyspercentage" DOUBLE,
"keystage4grade4oraboveinenglishandmathsgirlspercentage" DOUBLE,
"keystage4achievingebaccatgrade4orabovepupilsnumber" DOUBLE,
"keystage4achievingebaccatgrade4oraboveboysnumber" DOUBLE,
"keystage4achievingebaccatgrade4orabovegirlsnumber" DOUBLE,
"keystage4achievingebaccatgrade4orabovepupilspercentage" DOUBLE,
"keystage4achievingebaccatgrade4oraboveboyspercentage" DOUBLE,
"keystage4achievingebaccatgrade4orabovegirlspercentage" DOUBLE
);
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
);
Anyone who has the link will be able to view this.