Lincolnshire Libraries
Lincolnshire County Council
@ukgov.lincolnshire_libraries
Lincolnshire County Council
@ukgov.lincolnshire_libraries
CREATE TABLE lincolnshire_libraries (
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"publisheddate" TIMESTAMP,
"latestdata" BOOLEAN,
"durationfrom" TIMESTAMP,
"durationto" TIMESTAMP,
"reportingperiodtype" VARCHAR,
"reportingperiod" VARCHAR,
"geoentityname" VARCHAR,
"geocode" VARCHAR,
"geoname" VARCHAR,
"geouri" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"latitude" DOUBLE,
"longtitude" DOUBLE,
"geopointlicensingurl" VARCHAR,
"attribution" VARCHAR,
"uniquepropertyreferencenumber" DOUBLE,
"uniqueassetidentity" VARCHAR,
"librarycode" VARCHAR,
"librarytier" VARCHAR,
"servicetype" VARCHAR,
"provider" VARCHAR,
"running_staffing" VARCHAR,
"districtcouncilcommunityaccesspoint" VARCHAR,
"libraryname" VARCHAR,
"propertyname" VARCHAR,
"propertynumber" VARCHAR,
"streetname" VARCHAR,
"locality" VARCHAR,
"posttown" VARCHAR,
"postcode" VARCHAR,
"telephonenumber" VARCHAR,
"customerservicecentre_telephonenumber" VARCHAR,
"faxnumber" VARCHAR,
"email" VARCHAR,
"openingtimes_comments" VARCHAR,
"openingtime_1_monday" VARCHAR,
"closingtime_1_monday" VARCHAR,
"openingtime_2_monday" VARCHAR,
"closingtime_2_monday" VARCHAR,
"openingtime_1_tuesday" VARCHAR,
"closingtime_1_tuesday" VARCHAR,
"openingtime_2_tuesday" VARCHAR,
"closingtime_2_tuesday" VARCHAR,
"openingtime_1_wednesday" VARCHAR,
"closingtime_1_wednesday" VARCHAR,
"openingtime_2_wednesday" VARCHAR,
"closingtime_2_wednesday" VARCHAR,
"openingtime_1_thursday" VARCHAR,
"closingtime_1_thursday" VARCHAR,
"openingtime_2_thursday" VARCHAR,
"closingtime_2_thursday" VARCHAR,
"openingtime_1_friday" VARCHAR,
"closingtime_1_friday" VARCHAR,
"openingtime_2_friday" VARCHAR,
"closingtime_2_friday" VARCHAR,
"openingtime_1_saturday" VARCHAR,
"closingtime_1_saturday" VARCHAR,
"openingtime_2_saturday" VARCHAR,
"closingtime_2_saturday" VARCHAR,
"openingtime_1_sunday" VARCHAR,
"closingtime_1_sunday" VARCHAR,
"openingtime_2_sunday" VARCHAR,
"closingtime_2_sunday" VARCHAR
);
CREATE TABLE table_1 (
"dataset_id_dsid" BIGINT,
"dataset_name" VARCHAR,
"fieldname" 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.