Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

1. Step 1

   • Publication: Children looked after in England including adoptions

2. Step 2

   • Data set: National - Duration of placements by type ceasing during the year

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2018 to 2020

5. Step 5

   • Indicators:
     • Number
     • Percent
   • Duration of placements:
     • 1. 1 to 7 days
     • 2. From 8 days to under 1 month
     • 3. From 1 month to under 3 months
     • 4. From 3 months to under 6 months
     • 5. From 6 months to under 1 year
   • Placement type:
     • All Placements
     • Foster placements
     • Other placements
     • Other residential settings
     • Placed for adoption

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   'National - Duration of placements by type ceasing during the year' for 1. 1 to 7 days, 2. From 8 days to under 1 month, 3. From 1 month to under 3 months, 4. From 3 months to under 6 months, 5. From 6 months to under 1 year and 15 other filters in England between 2018 and 2020

   		2018											2019											2020
   		All Placements	1. 1 to 7 days	2. From 8 days to under 1 month	3. From 1 month to under 3 months	4. From 3 months to under 6 months	5. From 6 months to under 1 year	6. From 1 years to under 2 years	7. From 2 years to under 5 years	8. From 5 years and over	Average duration (days)	Median duration (days)	All Placements	1. 1 to 7 days	2. From 8 days to under 1 month	3. From 1 month to under 3 months	4. From 3 months to under 6 months	5. From 6 months to under 1 year	6. From 1 years to under 2 years	7. From 2 years to under 5 years	8. From 5 years and over	Average duration (days)	Median duration (days)	All Placements	1. 1 to 7 days	2. From 8 days to under 1 month	3. From 1 month to under 3 months	4. From 3 months to under 6 months	5. From 6 months to under 1 year	6. From 1 years to under 2 years	7. From 2 years to under 5 years	8. From 5 years and over	Average duration (days)	Median duration (days)
   Number	All Placements	93,000	9,670	9,890	13,420	15,200	18,310	14,080	10,110	2,340	350	173	95,210	9,170	10,170	13,510	15,200	19,120	16,940	8,670	2,420	345	180	85,170	9,150	9,680	13,570	14,780	17,200	11,970	6,630	2,180	317	153
   	Foster placements	59,460	6,770	6,020	7,000	8,410	11,300	9,810	8,020	2,140	412	201	60,220	6,340	5,930	6,930	8,330	11,570	12,090	6,800	2,240	408	214	49,790	6,150	5,590	6,530	7,500	9,410	7,560	5,030	2,010	386	172
   	Placed for adoption	4,050	40	30	180	1,150	2,060	510	80	10	257	218	3,740	30	20	160	1,000	1,980	500	60	c	255	220	3,600	30	30	190	1,040	1,840	430	50	c	246	215
   	Placed with parents	5,900	330	590	1,120	1,260	880	910	730	70	324	155	6,360	300	700	1,190	1,190	1,080	1,170	660	70	318	166	6,380	320	670	1,300	1,270	1,190	990	590	60	290	154
   	Placed in the community	6,810	520	960	1,520	1,470	1,460	870	20	0	166	111	6,820	540	980	1,500	1,450	1,560	780	10	0	162	112	6,030	350	730	1,310	1,320	1,490	830	10	0	178	130
   	Secure units, childrens homes and semi-independent living accomodation	11,960	950	1,290	2,370	2,160	2,120	1,790	1,160	120	287	144	12,580	760	1,400	2,420	2,290	2,410	2,150	1,050	110	284	156	13,590	970	1,460	2,870	2,610	2,700	1,990	890	100	253	138
   	Other residential settings	3,840	830	750	1,050	620	400	130	70	0	101	48	4,030	890	800	1,020	710	380	170	60	c	105	49	3,860	880	780	950	720	360	120	50	c	96	46
   	Residential schools	110	10	10	10	c	30	30	30	c	537	438	100	c	c	10	10	20	20	20	c	485	336	90	10	c	10	10	20	10	10	10	475	226
   	Other placements	880	230	250	180	130	70	30	c	c	85	26	1,360	310	360	290	210	130	60	c	0	84	31	1,840	440	430	410	320	190	50	10	c	86	35
   Percent	All Placements	100%	10%	11%	14%	16%	20%	15%	11%	3%	z	z	100%	10%	11%	14%	16%	20%	18%	9%	3%	z	z	100%	11%	11%	16%	17%	20%	14%	8%	3%	z	z
   	Foster placements	64%	11%	10%	12%	14%	19%	16%	13%	4%	z	z	63%	11%	10%	11%	14%	19%	20%	11%	4%	z	z	58%	12%	11%	13%	15%	19%	15%	10%	4%	z	z
   	Placed for adoption	4%	1%	1%	4%	28%	51%	12%	2%	~	z	z	4%	1%	1%	4%	27%	53%	13%	2%	c	z	z	4%	1%	1%	5%	29%	51%	12%	1%	c	z	z
   	Placed with parents	6%	6%	10%	19%	21%	15%	15%	12%	1%	z	z	7%	5%	11%	19%	19%	17%	18%	10%	1%	z	z	7%	5%	10%	20%	20%	19%	15%	9%	1%	z	z
   	Placed in the community	7%	8%	14%	22%	22%	21%	13%	~	0%	z	z	7%	8%	14%	22%	21%	23%	12%	~	0%	z	z	7%	6%	12%	22%	22%	25%	14%	~	0%	z	z
   	Secure units, childrens homes and semi-independent living accomodation	13%	8%	11%	20%	18%	18%	15%	10%	1%	z	z	13%	6%	11%	19%	18%	19%	17%	8%	1%	z	z	16%	7%	11%	21%	19%	20%	15%	7%	1%	z	z
   	Other residential settings	4%	22%	19%	27%	16%	10%	3%	2%	0%	z	z	4%	22%	20%	25%	18%	9%	4%	2%	c	z	z	5%	23%	20%	25%	19%	9%	3%	1%	c	z	z
   	Residential schools	~	6%	6%	7%	c	23%	25%	26%	c	z	z	~	c	c	13%	11%	22%	22%	21%	c	z	z	~	13%	c	15%	13%	18%	14%	15%	7%	z	z
   	Other placements	1%	26%	28%	20%	14%	8%	3%	c	c	z	z	1%	23%	26%	22%	16%	9%	4%	c	0%	z	z	2%	24%	23%	22%	17%	10%	3%	~	c	z	z

   Footnotes

   1. Numbers have been rounded to the nearest 10. Percentages and averages rounded to the nearest whole number. See the methodology document for further information. Figures exclude children looked after under a series of short-term placements. Historical data may differ from older publications which is mainly due to amendments made by local authorities after the previous publication.
   2. A placement may cease but the child will continue to be looked after if a new placement begins immediately. This table gives counts of placements, not children. If a child has more than one placement in the year then each will be included.

   Save table

   Related information

   • Release type:
   • Publication: Children looked after in England including adoptions, Reporting year 2023

   Our statistical practice is regulated by the Office for Statistics Regulation (OSR)