Baselight
Sign In

Children In Care

Lincolnshire County Council

@ukgov.children_looked_after

Children In Care
@ukgov.children_looked_after.children_in_care

Dataset for Children in Care

  • 13.47 KB
  • 72 rows
  • 15 columns
organisation_name

Organisation Name

organisation_code

Organisation Code

publisheddate

PublishedDate

latestdata

LatestData

durationfrom

DurationFrom

durationto

DurationTo

reportingperiodtype

ReportingPeriodType

geoentityname

GeoEntityName

geouri

GeoURI

geocode

GeoCode

geoname

GeoName

reportingperiod

ReportingPeriod

childrenincarebyhomeaddress

ChildrenInCareByHomeAddress

childrenincarebyplacementaddress

ChildrenInCareByPlacementAddress

childreninneedbyhomeaddress

ChildrenInNeedByHomeAddress

Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearCountyhttp://statistics.data.gov.uk/doc/statistical-geography/E10000019E10000019Lincolnshire2023-20246575532928
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000136E07000136Boston2023-20247660302
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000137E07000137East Lindsey2023-2024126129628
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000138E07000138Lincoln2023-202416174520
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000139E07000139North Kesteven2023-20244881323
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000140E07000140South Holland2023-20246254292
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000141E07000141South Kesteven2023-20249768455
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearDistrict Councilhttp://statistics.data.gov.uk/doc/statistical-geography/E07000142E07000142West Lindsey2023-20248787408
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)TRUESat Apr 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)2024-03-31T23:59:59Financial YearOut of County2023-202497201209
Lincolnshirehttp://opendatacommunities.org/id/county-council/lincolnshireThu Feb 13 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)2023-03-31T23:59:59Financial YearCountyhttp://statistics.data.gov.uk/doc/statistical-geography/E10000019E10000019Lincolnshire2022-20236545702857

CREATE TABLE children_in_care (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "geoentityname" VARCHAR,
  "geouri" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "reportingperiod" VARCHAR,
  "childrenincarebyhomeaddress" BIGINT,
  "childrenincarebyplacementaddress" BIGINT,
  "childreninneedbyhomeaddress" BIGINT
);

Share link

Anyone who has the link will be able to view this.