Childrens Centres

Lincolnshire County Council

@ukgov.childrens_centres2

Table List

2 tables(41.29 KB)

Lincolnshire Childrens Centres

Table 2

Lincolnshire Childrens Centres

@ukgov.childrens_centres2.lincolnshire_childrens_centres

Dataset of Lincolnshire Childrens Centres

28.87 KB
50 rows
31 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	publisheddate PublishedDate	durationfrom DurationFrom	durationto DurationTo	latestdata LatestData	uniqueassetidentity UniqueAssetIdentity	urn URN	establishmentstatus EstablishmentStatus	opendate OpenDate	areaname AreaName	mainsite MainSite	establishmentname EstablishmentName	propertyname PropertyName	propertynumber PropertyNumber	streetname StreetName	locality Locality	posttown PostTown	postcode PostCode	telephonenumber TelephoneNumber	coordinatereferencesystem CoordinateReferenceSystem	geox GeoX	geoy GeoY	geopointlicensingurl GeoPointLicensingURL	latitude Latitude	longtitude Longtitude	geoentityname GeoEntityName	geocode GeoCode	geoname GeoName	geouri GeoURI
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	E1912	20060	Open		East Lindsey Coastal		Alford Children's Centre	Alford Primary School		Farlesthorpe Road		Alford	LN13 9PS	01507 463218	EPSG:27700/OSGB36	545692	375582	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	53.257245	0.18255973	District Council	E07000137	East Lindsey	http://statistics.data.gov.uk/doc/statistical-geography/E07000137
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	N1906	20301	Open		North Kesteven South		Billinghay Children's Centre			Fen Road	Billinghay	Lincoln	LN4 4HU	01526 869248	EPSG:27700/OSGB36	515214	355176	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	53.081386	-0.28141155	District Council	E07000139	North Kesteven	http://statistics.data.gov.uk/doc/statistical-geography/E07000139
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	W1914	20304	Open		East Lindsey North		Binbrook Children's Centre	Binbrook CE Primary School		Orford Road	Binbrook	Lincoln	LN8 6DU	01472 398889	EPSG:27700/OSGB36	520643	394221	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	53.430981	-0.18561863	District Council	E07000137	East Lindsey	http://statistics.data.gov.uk/doc/statistical-geography/E07000137
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	B0506	20367	Open		Boston North		Boston Carlton Road Children's Centre	Boston Carlton Road Academy		Carlton Road		Boston	PE21 8QX	01205 364137	EPSG:27700/OSGB36	532113	344213	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	52.978988	-0.033762686	District Council	E07000136	Boston	http://statistics.data.gov.uk/doc/statistical-geography/E07000136
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	B0505	20368	Open	Mon Mar 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Boston North	Yes	Boston Norfolk Lodge Children's Centre	Norfolk Lodge	27	Norfolk Street		Boston	PE21 6PW	01522 843135	EPSG:27700/OSGB36	532526	344554	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	52.98195	-0.027475905	District Council	E07000136	Boston	http://statistics.data.gov.uk/doc/statistical-geography/E07000136
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true			Open		Boston North	Yes	Boston Fishtoft Road Childrens Centre		3	Fishtoft Road		Boston	PE21 0AA	01205 356410	EPSG:27700/OSGB36	533545	343272	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	52.97018	-0.01284	District Council	E07000136	Boston	http://statistics.data.gov.uk/doc/statistical-geography/E07000136
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	B1917		Closed		Boston North	Yes	Boston St Christophers Childrens Centre			Fenside Road		Boston	PE21 8HY	01205 357608	EPSG:27700/OSGB36	531602	344612	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	52.98303	-0.04241	District Council	E07000136	Boston	http://statistics.data.gov.uk/doc/statistical-geography/E07000136
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	S0511	20376	Open		South Kesteven South		Bourne Children's Centre			Queen`s Road		Bourne	PE10 9DX	01778 395895	EPSG:27700/OSGB36	509862	320810	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	52.773713	-0.37289676	District Council	E07000141	South Kesteven	http://statistics.data.gov.uk/doc/statistical-geography/E07000141
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	E0013	20539	Open		West Lindsey Rural		Caistor Childrens Centre	Town Hall		High Street	Caistor	Market Rasen	LN7 6TJ	01673 844703	EPSG:27700/OSGB36	520643	394221	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	53.430981	-0.18561863	District Council	E07000137	East Lindsey	http://statistics.data.gov.uk/doc/statistical-geography/E07000137
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	true	S1922	20600	Open		North Kesteven South		Caythorpe Children's Centre	Caythorpe Primary School		High Street	Caythorpe	Grantham	NG32 3DR	01400 279285	EPSG:27700/OSGB36	493806	348241	https://www.ordnancesurvey.co.uk/about/governance/policies/addressbase-uprn.html	53.02325	-0.6029147	District Council	E07000141	South Kesteven	http://statistics.data.gov.uk/doc/statistical-geography/E07000141


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
);