Name: Childrens Centres
Creator: UK Government
License: https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

About this Dataset

Childrens Centres

Dataset showing details of Childrens Centres in Lincolnshire. This dataset is published by Lincolnshire County Council.
Publisher name: Lincolnshire County Council
Last updated: 2025-03-13T04:00:02Z

Tables

Lincolnshire Childrens Centres

@ukgov.childrens_centres2.lincolnshire_childrens_centres

29.57 kB
50 rows
31 columns

CREATE TABLE lincolnshire_childrens_centres (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" BOOLEAN,
  "uniqueassetidentity" VARCHAR,
  "urn" DOUBLE,
  "establishmentstatus" VARCHAR,
  "opendate" TIMESTAMP,
  "closedate" VARCHAR,
  "areaname" VARCHAR,
  "mainsite" VARCHAR,
  "establishmentname" VARCHAR,
  "propertyname" VARCHAR,
  "propertynumber" DOUBLE,
  "streetname" VARCHAR,
  "locality" VARCHAR,
  "posttown" VARCHAR,
  "postcode" VARCHAR,
  "telephonenumber" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "latitude" DOUBLE,
  "longtitude" DOUBLE,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR
);

Table 2

@ukgov.childrens_centres2.table_2

12.72 kB
29 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);