The Local Council Report / Temporary accommodation / TA B&B mean stay days · markdown view

TA B&B mean stay days

days · extracted · local authority (England)

How long, on average, a household placed in a bed and breakfast stays there before moving somewhere better, measured in days. B&Bs are meant to be a few nights' emergency stopgap, not a home. A high average means people — including families — are stuck in single rooms for weeks or months; a low average means the council genuinely uses B&Bs only briefly.

councils
284
median
87.5
q1
42
q3
236.75
min
0
max
2,944

Distribution

01,458

Worst 10

CouncilClassValueIn its class
Redcar and Clevelandunitary2,9441st worst of 60
Croydonlondon2,1931st worst of 32
Lambethlondon1,8392nd worst of 32
Readingunitary1,3802nd worst of 60
Enfieldlondon1,3553rd worst of 32
Lewishamlondon8514th worst of 32
Westminsterlondon8485th worst of 32
Ealinglondon8106th worst of 32
Bexleylondon8007th worst of 32
Haringeylondon7808th worst of 32

Best 10

CouncilClassValueIn its class
Bromleylondon01st best of 32
Blackburn with Darwenunitary06th best of 60
Yorkunitary06th best of 60
Wokinghamunitary06th best of 60
Isles of Scillyunitary06th best of 60
Wiltshireunitary06th best of 60
Northumberlandunitary06th best of 60
Bolsoverdistrict014th best of 156
North East Derbyshiredistrict014th best of 156
Teignbridgedistrict014th best of 156

Definition

nameta_bnb_mean_stay_days
dataset06-hclic-temporary-accommodation
kindextracted
typecontinuous
unitdays
grainlocal authority (England)
roleoutcome
sourcedata/Statutory_Homelessness_Detailed_Local_Authority_Data_202603.ods, sheet TA7, col 3 'B&B or shared annexMean (days)' (median in col 2)
periodAnnual-style analysis in the quarterly file (Jan–Mar 2026 edition)
missingnessSmall counts rounded and some values suppressed; some LAs miss or partially complete H-CLIC returns and are imputed/flagged by MHCLG (see Notes sheet); previous-quarter figures routinely revised.
score_noteDirect duration-in-worst-TA measure; TA7 quirks and mean skew temper it.
calculatedcalculated/ta-bnb-mean-stay-days.csv
calculated_rows573
calculated_periods2025-26-Q3 to 2025-26-Q4
calculated_date2026-08-13
peer_groupdistricts (n=164), unitaries (n=62), metropolitan boroughs (n=36), London boroughs (n=33) — scored within each class against its median/IQR

Mean length of B&B stays in days; long stays indicate the council cannot move households on from the worst TA type. Means are skewed by a few very long stays — the median (col 2) is more robust. TA7 exists only in the quarterly files' verified sheet list and has no England row (starts directly at LAs).