Education Attainment: Key Stage 2
Lincolnshire County Council
@ukgov.education_attainment_key_stage_2
Lincolnshire County Council
@ukgov.education_attainment_key_stage_2
CREATE TABLE key_stage_2 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"published_date" TIMESTAMP,
"latestdata" VARCHAR,
"duration_from" TIMESTAMP,
"duration_to" TIMESTAMP,
"reporting_period_type" VARCHAR,
"reporting_period" VARCHAR,
"geo_entity_name" VARCHAR,
"geo_code" VARCHAR,
"geo_name" VARCHAR,
"geo_uri" VARCHAR,
"year" BIGINT,
"polarity" VARCHAR,
"keystage2pupilsnumber" DOUBLE,
"keystage2boysnumber" DOUBLE,
"keystage2girlsnumber" DOUBLE,
"keystage2attainmentpupilsnumber" DOUBLE,
"keystage2attainmentboysnumber" DOUBLE,
"keystage2attainmentgirlsnumber" DOUBLE,
"keystage2attainmentpupilspercentage" DOUBLE,
"keystage2attainmentboyspercentage" DOUBLE,
"keystage2attainmentgirlspercentage" 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.