School Term Dates
Lincolnshire County Council
@ukgov.school_term_dates
Lincolnshire County Council
@ukgov.school_term_dates
CREATE TABLE school_term_dates (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"publisheddate" TIMESTAMP,
"latestdata" BOOLEAN,
"durationfrom" TIMESTAMP,
"durationto" TIMESTAMP,
"geoentityname" VARCHAR,
"geocode" VARCHAR,
"geoname" VARCHAR,
"geouri" VARCHAR,
"reportingperiod" VARCHAR,
"academicyear" VARCHAR,
"termseasonname" VARCHAR,
"termnumberorhalftermnumber" VARCHAR,
"termdayscount" DOUBLE,
"startday" VARCHAR,
"startdate" VARCHAR,
"endday" VARCHAR,
"enddate" TIMESTAMP,
"bankholiday1day" VARCHAR,
"bankholiday1date" TIMESTAMP,
"bankholiday2day" VARCHAR,
"bankholiday2date" TIMESTAMP,
"trainingdatesuggested" TIMESTAMP,
"trainingdateguidance" VARCHAR
);
CREATE TABLE table_2 (
"dataset_id" VARCHAR,
"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.