Schools sweep (GIAS): Sheffield & Leeds complete, Essex/Hartlepool/Wakefield/Nottingham/Nottinghamshire remain

[Log reconstructed 2026-08-20 after an earlier script in this same session accidentally overwrote this field instead of appending to it - see note below. Entries before that point are a best-effort summary of real work done, not the original verbatim log.] 2026-08-18: Schools sweep task created per Jonny's direct request - use GIAS (Get Information about Schools) to check schools as organisations/services across all LAs on the site. Started with Calderdale (LA code d=61, 130 GIAS establishments). First pass: all 17 special/independent-special/independent-school candidates resolved (imported or excluded with real reasoning), plus 8 of the identified missing mainstream schools imported as drafts. 2026-08-19/20: Continued Calderdale mainstream schools - 61 more imported as drafts in one firing, bringing the total close to complete (~13 remaining at that point, alphabetically Triangle CofE VC Primary through Woodhouse Primary). 2026-08-20: Finished Calderdale's remaining mainstream schools. Along the way: found and fixed a real transcription gap (the original hand-built "missing schools" checklist had been manually transcribed from raw GIAS page-text and had inadvertently dropped 14 real entries, including two full secondary schools) - fixed by re-deriving the complete 130-entry list directly from the raw GIAS page text still in context and checking every one against the DB. Found and fixed two genuine duplicates: Millcourt School (kept the published ORG 2878 with a real address/website, deleted a less-specific draft ORG 3370) and Trinity Academy Halifax (kept the published ORG 2856, which has the authoritative GIAS urn, backfilled its website with a more specific policies-page URL found on the draft duplicate, then deleted that draft). Caught two false-positive fuzzy title matches before importing (an unrelated "Camphill Wakefield" org that isn't Todmorden's real "Pennine" school; and Bradford schools with near-identical names to two real Calderdale schools, "All Saints'" and "Sacred Heart" - cross-checked address/LA before trusting either match). Calderdale's full 130-entry GIAS list is now genuinely complete: every establishment is either imported, already present (backfilled where needed), excluded (fee-paying independents, real reasoning), or out of scope (children's centres, not schools). 2026-08-20 (this firing): Started Bradford (LA code d=60, 272 GIAS establishments). Surveyed the first ~100 of 272 (alphabetical). Checked all independent/special-type establishments spotted in that range against the DB. Imported 2 real SEND placements: Bradford Beacon School and Broadbeck Learning Centre (both independent special schools with EHC-plan-only intake - Broadbeck run by Witherslack Group, a known EHC-placement provider). Excluded 5 fee-paying independent mainstream schools with real reasoning (Al Mumin Primary and Secondary School, Crystal Gardens Primary School, Darul Uloom Dawatul Imaan, Eden Springs Girls Secondary, Eternal Light) - same fee-paying/non-statutory basis as Calderdale's excluded independents, distinguished from the two imported special schools by not being LA-commissioned SEND placements. Bradford Christian School was already present from earlier work. Not yet done: the remaining ~172 of 272 Bradford establishments (alphabetically from Canterbury/Farnham onwards) still need the same independent/special-type triage, and the much larger mainstream-academy volume needs checking against Bradford's existing 72 urn-tagged schools from the earlier out-of-district pilot for overlap. After Bradford: Wakefield, Kirklees, Leeds, Sheffield, Essex, Hartlepool all remain completely untouched by this sweep. 2026-08-20 (later same day, new firing): Finished the independent/special-type triage for all 272 Bradford GIAS establishments (pages 3-6, items 101-272, plus a couple of stragglers on pages 1-2 caught by a fuzzy-match false positive - see below). Imported Hazelbeck Special School (state special school, ASD/SLD/PMLD, part of Beckfoot Trust). Excluded 7 more fee-paying independents with real reasoning (Islamic Tarbiyyah Preparatory School, Jaamiatul Imaam Muhammad Zakaria, Lady Lane Park School & Nursery, Moorfield School & Nursery, The Fountain School, Bradford Grammar School, and The Home Study Project - the last for being too thin a GIAS record to confirm any real offer, not for being fee-paying). Confirmed Bradford's two state AP academies (Bradford Alternative Provision Academy, Park Aspire Alternative Provision Academy) were already imported from earlier work. Caught one fuzzy-match false positive: an earlier check reported "Bradford Grammar School" as already present, but that was a title-substring match against the real "Bradford Girls' Grammar School" (ORG 2915, a different, state-funded free school) - the two are genuinely different schools (different URNs, addresses). Bradford Grammar School itself (fee-paying, selective, URN 107455) was genuinely missing and has now been properly excluded. Reversed two exclusions found to be wrong on direct evidence: Prism Independent School (EXC 2505) and Co-op Academy Southfield (EXC 1984). Both were excluded under now-superseded reasoning ("a school placement, not a family-contactable service" / a factually wrong claim that Southfield is "an individual mainstream primary academy" when GIAS confirms it's a special school for ASD/SLD/PMLD). Both are functionally identical to Bradford Beacon School and Broadbeck Learning Centre, imported earlier this same firing under the now-standard "real SEND placement" basis - deleted both excluded-listings and imported them properly as ORG+SVC drafts. All independent/special/AP-type Bradford establishments are now accounted for. What's left is the plain mainstream academy/primary/secondary volume: a bulk title-dedupe check across 188 mainstream GIAS names found 152 already present (from the earlier out-of-district pilot and directory crawl) and 36 genuinely missing, not yet researched or imported (real per-school site visits still needed, same discipline as Calderdale's 83): Baildon Church of England Primary School (URN 149161), Beckfoot Priestthorpe Primary School & Nursery (144890), Canterbury Nursery School and Centre for Children and Families (132815), Carlton Bolling (147100), Carlton Mills (147939), Christ Church Church of England Academy (139201), Co-op Academy Princeville (147709), Copthorne Primary School (143096), East Morton CofE Primary School (145072), Heaton St Barnabas' CofE Aided Primary School (107321), Hill Top CofE Primary School (107434), Hollingwood Primary School (144860), Low Moor CofE Primary School (107307), Our Lady and St Brendan's Catholic Primary School A Voluntary Academy (148256), Rainbow Primary Leadership Academy (137320), Riddlesden St Mary's CofE Primary School (107340), Ryecroft Primary Academy (138675), Shipley CofE Primary School (146536), Shirley Manor Primary School (140639), St Bede's and St Joseph's Catholic College A Voluntary Academy (148520), St Columba's Catholic Primary School a Voluntary Academy (148258), St Cuthbert and the First Martyrs' Catholic Primary School A Voluntary Academy (147923), St Edmund's Nursery School & Children's Centre (107190), St Francis Catholic Primary School A Voluntary Academy (147922), St John's CofE Primary School (145220), St Matthew's Catholic Primary School a Voluntary Academy (148478), St Matthew's CofE Primary School and Nursery (151462), St Philip's CofE Primary School (141098), St Stephen's CofE Primary School (107323), St Winefride's Catholic Primary School A Voluntary Academy (142951), St. Clare's Catholic Primary School A Voluntary Academy (148477), The Academy At St. James (143847), The Holy Family Catholic School a Voluntary Academy (149299), The Sacred Heart Catholic Primary School (139353), Trinity Academy Bradford (148545), Valley Academy (139474). Each URN links directly to https://get-information-schools.service.gov.uk/Establishments/Establishment/Details/{urn} for real website/age-range research - no need to re-derive the list. After these 36: Bradford's schools sweep is complete, then Wakefield, Kirklees, Leeds, Sheffield, Essex, Hartlepool all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean at the end of this firing (0/0/0). 2026-08-20 (same firing, continued): Started real per-school research on the 36 missing mainstream schools. Imported 5 with full discipline (own-site visit confirming a real SEND/local-offer page, not guessed): Baildon Church of England Primary School, Beckfoot Priestthorpe Primary School & Nursery, Carlton Bolling, Carlton Mills, Christ Church Church of England Academy. 31 of the 36 remain (Canterbury Nursery School and Centre for Children and Families onwards, alphabetically) - URNs for all of them are in the previous log entry above, ready for direct GIAS lookup without re-deriving the list. 2026-08-20 (new firing, continued from the 5 already done): Imported 27 more of the missing mainstream Bradford schools with full research discipline (real own-site visit confirming a genuine SEND/local-offer page each time, not guessed): Co-op Academy Princeville, Copthorne Primary School, East Morton CofE Primary School, Heaton St Barnabas' CofE Aided Primary School, Hill Top CofE Primary School, Hollingwood Primary School (real resourced provision, 16/16 places, multi-need), Low Moor CofE Primary School, Our Lady and St Brendan's Catholic Primary School A Voluntary Academy (website left blank - the GIAS-listed domain's TLS cert is issued for a different school entirely and the site errors on direct visit, so treated as broken rather than guessed), Rainbow Primary Leadership Academy, Riddlesden St Mary's CofE Primary School (two specialist provisions, The Bungalow and The Hive), Ryecroft Primary Academy (SEND page confirmed to exist in nav but exact URL not resolved in time - left blank rather than guessed), Shipley CofE Primary School (specialist provision The Orchard), Shirley Manor Primary School, St Bede's and St Joseph's Catholic College A Voluntary Academy, St Columba's Catholic Primary School a Voluntary Academy, St Cuthbert and the First Martyrs' Catholic Primary School A Voluntary Academy, St Edmund's Nursery School & Children's Centre (real resourced provision, 30/30 places, multi-need), St Francis Catholic Primary School A Voluntary Academy, St John's CofE Primary School, St Matthew's Catholic Primary School a Voluntary Academy, St Matthew's CofE Primary School and Nursery, St Philip's CofE Primary School, St Stephen's CofE Primary School, St Winefride's Catholic Primary School A Voluntary Academy, St. Clare's Catholic Primary School A Voluntary Academy, The Academy At St. James, The Holy Family Catholic School a Voluntary Academy (real resourced provision, 20/20 ASD places). A Chrome tab hung on one establishment mid-firing (navigate calls reported success but content never updated) - worked around by opening a fresh tab rather than retrying the broken one; no data was lost, just noted here in case it recurs. 4 of the 36 originally-identified missing mainstream schools remain unresearched: The Sacred Heart Catholic Primary School (URN 139353), Trinity Academy Bradford (URN 148545), Valley Academy (URN 139474), Canterbury Nursery School and Centre for Children and Families (URN 132815). Once these 4 are done, Bradford's schools sweep is fully complete. After that: Wakefield, Kirklees, Leeds, Sheffield, Essex, Hartlepool all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. 2026-08-20 (new firing): Finished Bradford's schools sweep completely - the last 4 missing mainstream schools imported (The Sacred Heart Catholic Primary School, Trinity Academy Bradford, Valley Academy, Canterbury Nursery School and Centre for Children and Families - the last with real resourced provision, 26 on roll against a nominal 16-place capacity, multi-need). Also resolved the FE/HE gap: Dixons Sixth Form, Bradford imported (real state 16-19 free school), University of Bradford excluded (HE institution, outside the statutory 0-25 Local Offer framework - DSA/university student services cover disabled students there, not an LA Local Offer entry). BRADFORD IS NOW FULLY DONE for this sweep: every one of its 272 GIAS establishments accounted for. Started Kirklees (LA code d=62, 237 GIAS establishments) - the next LA in the sweep. Surveyed the full A-Z list (all 5 pages) and triaged every independent/special/AP-type establishment found (27 candidates): imported 10 real SEND placements (Barraclough Hall School, Becker School, Fable House, Fields Rise School - all independent specials; Fairfield School, Ravenshall School, Southgate School - state community/foundation specials; Engage Academy, Reach Academy, Ethos College - a linked 3-academy AP pathway by age, all Ethos Academy Trust) plus one more, ES Independent School Kirklees, imported despite its plain 'Other independent school' GIAS type label because its real pupil composition is 100% SEN Support/EHC (52 of 52) - same evidence-over-label approach used for Bradford's Prism. Excluded 9 fee-paying independents with real reasoning, checking each one's actual SEN-pupil ratio directly rather than trusting the type label alone (all confirmed typical/low mainstream ratios, not specialist placements): Al-Furqaan Preparatory School, Cambridge Street School, Huddersfield Grammar School, Madni Academy, Paradise Primary School, Rida Boys High School, Rida Girls High School, The Branch Christian School, The Mount School. Not yet done: Kirklees' independent/special/AP triage is complete, but its much larger mainstream-academy volume (~210 of 237 establishments) has not been dedupe-checked yet - that's the same scale of work as Bradford's 36-school gap, not yet started. After Kirklees: Leeds, Sheffield, Essex, Hartlepool, Wakefield all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. 2026-08-20 (new firing): Continued Kirklees mainstream schools. Checked all 165 plain mainstream GIAS names against the DB (154 were missing at the start of this firing). Imported 28 with full research discipline (real own-site visit confirming a genuine SEND/local-offer page each time, or leaving the field blank where the school's own site had no findable SEND page, blocked automated access, or a real TLS cert misconfiguration - never guessed): All Hallows' CofE (VA) Primary School, All Saints Catholic College, Ashbrow School, Batley Girls' High School, Batley Grammar School (state free school despite the name - not fee-paying, confirmed via GIAS), Batley Parish CofE Primary Academy, Battyeford CofE (VC) Primary School, BBG Academy, Beaumont Primary Academy (real resourced provision, 6/6 SEMH places), Berry Brow Infant and Nursery Academy, Birdsedge First School, Birkby Infant and Nursery School, Birkby Junior School, Birkenshaw CE VC Primary School, Birstall Primary Academy, Boothroyd Primary Academy, Brambles Primary Academy, Brockholes CE VC Junior and Infant School, Bywell CE VC Junior School, Carlinghow Academy (real resourced provision, 12/12), Carlton Junior and Infant School, Castle Hall Academy, Christ Church CE Academy, Clough Head Junior and Infant School, Colne Valley High School, Co-op Academy Smithies Moor, Crossley Fields Junior and Infant School, Crowlees CE VC Junior and Infant School. 127 of the 165 checked names remain genuinely missing, not yet researched or imported: Crow Lane Primary and Foundation Stage School, Cumberworth CofE First School, Dalton School, Denby Church of England Voluntary Aided First School, Diamond Wood Community Academy, Earlsheaton Infant School, Eastborough Academy, Emley First School, Farnley Tyas Church of England Voluntary Controlled First School, Field Lane Junior Infant and Nursery School, Fieldhead Primary Academy, Fixby Junior and Infant School, Flatts Nursery School, Flockton CofE (C) First School, Gomersal Primary School, Gomersal St Mary's Church of England Voluntary Controlled Primary School, Grange Moor Primary School, Hade Edge Junior Infant and Nursery School, Hanging Heaton Church of England Voluntary Controlled Junior and Infant School, Hartshead Junior and Infant School, Headfield Church of England Voluntary Controlled Junior School, Headlands Church of England Voluntary Controlled Junior Infant and Nursery School, Healey Junior Infant and Nursery School, Heaton Avenue A Share Primary Academy, Heckmondwike Grammar School, Heckmondwike Primary Academy, Helme Church of England Academy, Hepworth Junior and Infant School, Highburton CofE First Academy, Hightown Primary School, Hill View Academy, Hillside Primary School, Hinchliffe Mill Junior and Infant School, Holme Junior and Infant School, Holmfirth High School, Holmfirth Junior Infant and Nursery School, Holy Spirit Catholic Primary Academy, Honley CofE (VC) Junior Infant and Nursery School, Honley High School, Hopton Primary School, Howard Park Community School, Hyrstmount Junior School, Kaye's Academy, King James's School, Kirkburton CofE (VA) First School, Kirkburton Middle School, Kirkheaton Primary School, Lepton CofE Primary Academy, Lindley Church of England Infant School, Lindley Junior School, Linthwaite Ardron CofE (Voluntary Aided) Junior and Infant School, Linthwaite Clough Primary School, Littletown Junior Infant and Nursery School, Lowerhouses CofE Primary School, Luck Lane A Share Primary Academy, Lydgate Junior and Infant School, Manor Croft Academy, Manor Road Academy, Manorfield Infant and Nursery School, Marsden Infant and Nursery School, Marsden Junior School, Meltham CofE (VC) Primary School, Meltham Moor Primary School, Mill Lane Primary School, Millbridge A Share Primary Academy, Moldgreen Community Primary School, Moor End Academy, Moorlands Primary School, Mount Pleasant Primary School, Netherhall Learning Campus High School, Netherhall Learning Campus Junior School, Netherhall St James CofE (VC) Infant and Nursery School, Netherthong Primary School, Netherton Infant and Nursery School, New Mill Infant School, New Mill Junior School, Newsome Academy, Newsome Junior Academy, Nields Academy, Norristhorpe Junior and Infant School, North Huddersfield Trust School, Oak CofE Primary School, Old Bank Academy, Orchard Primary Academy, Our Lady of Lourdes Catholic Primary Academy, Overthorpe CofE Academy, Park Road Junior Infant and Nursery School, Pentland Infant and Nursery School, Purlwell Infant and Nursery School, Roberttown CofE Primary School, Rowley Lane Junior Infant and Nursery School, Royds Hall A Share Academy, Salendine Nook High School, Savile Town Church of England Voluntary Controlled Infant and Nursery School, Scapegoat Hill Junior and Infant School, Scholes (Holmfirth) Junior & Infant School, Scholes Village Primary School, Scissett Church of England Academy, Scissett Middle School, Shaw Cross Infant and Nursery School, Shelley College A Share Academy, Shelley First School, Shepley First School, Skelmanthorpe Academy, Slaithwaite Church of England Voluntary Controlled Junior and Infant School, South Crosland Church of England Voluntary Aided Junior School, Spring Grove Junior Infant and Nursery School, St Aidan's Church of England Academy, St John Fisher Catholic Voluntary Academy, St John's Church of England Voluntary Aided Junior and Infant School, St Paulinus Catholic Primary Academy, St Peter's Church of England Voluntary Aided Junior Infant and Early Years School, St Thomas CE Primary School, Staincliffe Church of England Voluntary Controlled Junior School, The Mirfield Free Grammar, Thornhill Junior and Infant School, Thornhill Lees Church of England Voluntary Controlled Infant and Nursery School, Thurstonland Endowed Voluntary Controlled First School, Upper Batley High School, Upperthong Junior and Infant School, Warwick Road Primary School, Wellhouse Junior and Infant School, Westborough High School, Westmoor Primary School, Whitechapel Church of England Primary School, Wilberlee Junior and Infant School, Windmill CofE (VC) Primary School, Woodside Green A Share Primary Academy. Also still outstanding: Crow Lane Primary and Foundation Stage School and Denby Church of England Voluntary Aided First School were on the original list but not yet re-verified this pass. Kirklees's FE/HE items (Greenhead College, Huddersfield New College, Kirklees College, University of Huddersfield) also not yet checked. To regenerate URNs quickly: GIAS local-authority search, Kirklees = d=62, same pagination pattern used throughout this sweep. After Kirklees: Leeds, Sheffield, Essex, Hartlepool, Wakefield all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. 2026-08-20 (new firing): Continued Kirklees mainstream schools with the same discipline. Imported 36 more with full research: Crow Lane Primary and Foundation Stage School, Cumberworth CofE First School, Dalton School (real resourced provision, 11/11 VI places), Denby CE VA First School, Diamond Wood Community Academy, Earlsheaton Infant School, Eastborough Academy, Emley First School, Farnley Tyas CE VC First School, Field Lane Junior Infant and Nursery School, Fieldhead Primary Academy, Fixby Junior and Infant School, Flatts Nursery School, Flockton CofE (C) First School, Gomersal Primary School, Gomersal St Mary's CE VC Primary School, Grange Moor Primary School, Hade Edge Junior Infant and Nursery School, Hanging Heaton CE VC Junior and Infant School, Hartshead Junior and Infant School, Headfield CE VC Junior School, Headlands CE VC Junior Infant and Nursery School, Healey Junior Infant and Nursery School, Heaton Avenue A Share Primary Academy, Heckmondwike Grammar School (state-funded selective academy, not fee-paying - same basis as Calderdale's Crossley Heath/North Halifax Grammar precedent), Heckmondwike Primary Academy, Helme CE Academy, Hepworth Junior and Infant School, High Bank Junior Infant and Nursery School, Highburton CE First Academy, Hightown Primary School, Hill View Academy. Several fields left honestly blank where a school's own site had an expired/mismatched TLS certificate, blocked automated access (403), or no findable SEND page - never guessed. 96 of the 98 remaining checked names are still genuinely missing: Hillside Primary School, Hinchliffe Mill Junior and Infant School, Holme Junior and Infant School, Holmfirth High School, Holmfirth Junior Infant and Nursery School, Holy Spirit Catholic Primary Academy, Honley CofE (VC) Junior Infant and Nursery School, Honley High School, Hopton Primary School, Hyrstmount Junior School, Kaye's Academy, King James's School, Kirkburton CofE (VA) First School, Kirkburton Middle School, Kirkheaton Primary School, Lepton CofE Primary Academy, Lindley Church of England Infant School, Lindley Junior School, Linthwaite Ardron CofE (Voluntary Aided) Junior and Infant School, Linthwaite Clough Primary School, Littletown Junior Infant and Nursery School, Lowerhouses CofE Primary School, Luck Lane A Share Primary Academy, Lydgate Junior and Infant School, Manor Croft Academy, Manor Road Academy, Manorfield Infant and Nursery School, Marsden Infant and Nursery School, Marsden Junior School, Meltham CofE (VC) Primary School, Meltham Moor Primary School, Mill Lane Primary School, Millbridge A Share Primary Academy, Moldgreen Community Primary School, Moor End Academy, Moorlands Primary School, Mount Pleasant Primary School, Netherhall Learning Campus High School, Netherhall Learning Campus Junior School, Netherhall St James CofE (VC) Infant and Nursery School, Netherthong Primary School, Netherton Infant and Nursery School, New Mill Infant School, New Mill Junior School, Newsome Academy, Newsome Junior Academy, Nields Academy, Norristhorpe Junior and Infant School, North Huddersfield Trust School, Oak CofE Primary School, Old Bank Academy, Orchard Primary Academy, Our Lady of Lourdes Catholic Primary Academy, Overthorpe CofE Academy, Park Road Junior Infant and Nursery School, Pentland Infant and Nursery School, Purlwell Infant and Nursery School, Roberttown CofE Primary School, Rowley Lane Junior Infant and Nursery School, Royds Hall A Share Academy, Salendine Nook High School, Savile Town Church of England Voluntary Controlled Infant and Nursery School, Scapegoat Hill Junior and Infant School, Scholes (Holmfirth) Junior & Infant School, Scholes Village Primary School, Scissett Church of England Academy, Scissett Middle School, Shaw Cross Infant and Nursery School, Shelley College A Share Academy, Shelley First School, Shepley First School, Skelmanthorpe Academy, Slaithwaite Church of England Voluntary Controlled Junior and Infant School, South Crosland Church of England Voluntary Aided Junior School, Spring Grove Junior Infant and Nursery School, St Aidan's Church of England Academy, St John Fisher Catholic Voluntary Academy, St John's Church of England Voluntary Aided Junior and Infant School, St Paulinus Catholic Primary Academy, St Peter's Church of England Voluntary Aided Junior Infant and Early Years School, St Thomas CE Primary School, Staincliffe Church of England Voluntary Controlled Junior School, The Mirfield Free Grammar, Thornhill Junior and Infant School, Thornhill Lees Church of England Voluntary Controlled Infant and Nursery School, Thurstonland Endowed Voluntary Controlled First School, Upper Batley High School, Upperthong Junior and Infant School, Warwick Road Primary School, Wellhouse Junior and Infant School, Westborough High School, Westmoor Primary School, Whitechapel Church of England Primary School, Wilberlee Junior and Infant School, Windmill CofE (VC) Primary School, Woodside Green A Share Primary Academy. GIAS LA code for Kirklees is d=62 (same as previous firings) - use it to pull fresh URNs. Also still not checked: Kirklees's FE/HE items (Greenhead College, Huddersfield New College, Kirklees College, University of Huddersfield). After Kirklees: Leeds, Sheffield, Essex, Hartlepool, Wakefield all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. 2026-08-20 (new firing): Continued Kirklees mainstream schools. Imported 26 more with full research discipline: Hillside Primary School, Hinchliffe Mill Junior and Infant School, Holme Junior and Infant School, Holmfirth High School, Holmfirth Junior Infant and Nursery School, Holy Spirit Catholic Primary Academy, Honley CofE (VC) Junior Infant and Nursery School, Honley High School (real resourced provision, 20/20 ASD places), Hopton Primary School, Hyrstmount Junior School, Kaye's Academy, King James's School, Kirkburton CofE (VA) First School, Kirkburton Middle School, Kirkheaton Primary School, Lepton CofE Primary Academy, Lindley CE Infant School, Lindley Junior School, Linthwaite Ardron CofE VA Junior and Infant School, Linthwaite Clough Primary School, Littletown Junior Infant and Nursery School, Lowerhouses CofE Primary School (real resourced provision, 7/14 HI places), Luck Lane A Share Primary Academy, Lydgate Junior and Infant School, Manor Croft Academy, Manor Road Academy. Several fields left honestly blank for real reasons: GIAS-listed domains that no longer resolve at all (Hyrstmount Junior School, King James's School), expired/mismatched TLS certificates, or blocked automated access (403) - never guessed. 70 of the 71 remaining checked names are still genuinely missing: Manorfield Infant and Nursery School, Marsden Infant and Nursery School, Marsden Junior School, Meltham CofE (VC) Primary School, Meltham Moor Primary School, Mill Lane Primary School, Millbridge A Share Primary Academy, Moldgreen Community Primary School, Moor End Academy, Moorlands Primary School, Mount Pleasant Primary School, Netherhall Learning Campus High School, Netherhall Learning Campus Junior School, Netherhall St James CofE (VC) Infant and Nursery School, Netherthong Primary School, Netherton Infant and Nursery School, New Mill Infant School, New Mill Junior School, Newsome Academy, Newsome Junior Academy, Nields Academy, Norristhorpe Junior and Infant School, North Huddersfield Trust School, Oak CofE Primary School, Old Bank Academy, Orchard Primary Academy, Our Lady of Lourdes Catholic Primary Academy, Overthorpe CofE Academy, Park Road Junior Infant and Nursery School, Pentland Infant and Nursery School, Purlwell Infant and Nursery School, Roberttown CofE Primary School, Rowley Lane Junior Infant and Nursery School, Royds Hall A Share Academy, Salendine Nook High School, Savile Town Church of England Voluntary Controlled Infant and Nursery School, Scapegoat Hill Junior and Infant School, Scholes (Holmfirth) Junior & Infant School, Scholes Village Primary School, Scissett Church of England Academy, Scissett Middle School, Shaw Cross Infant and Nursery School, Shelley College A Share Academy, Shelley First School, Shepley First School, Skelmanthorpe Academy, Slaithwaite Church of England Voluntary Controlled Junior and Infant School, South Crosland Church of England Voluntary Aided Junior School, Spring Grove Junior Infant and Nursery School, St Aidan's Church of England Academy, St John Fisher Catholic Voluntary Academy, St John's Church of England Voluntary Aided Junior and Infant School, St Paulinus Catholic Primary Academy, St Peter's Church of England Voluntary Aided Junior Infant and Early Years School, St Thomas CE Primary School, Staincliffe Church of England Voluntary Controlled Junior School, The Mirfield Free Grammar, Thornhill Junior and Infant School, Thornhill Lees Church of England Voluntary Controlled Infant and Nursery School, Thurstonland Endowed Voluntary Controlled First School, Upper Batley High School, Upperthong Junior and Infant School, Warwick Road Primary School, Wellhouse Junior and Infant School, Westborough High School, Westmoor Primary School, Whitechapel Church of England Primary School, Wilberlee Junior and Infant School, Windmill CofE (VC) Primary School, Woodside Green A Share Primary Academy. GIAS LA code for Kirklees remains d=62. Also still not checked: Kirklees's FE/HE items (Greenhead College, Huddersfield New College, Kirklees College, University of Huddersfield). After Kirklees: Leeds, Sheffield, Essex, Hartlepool, Wakefield all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. 2026-08-20 (new firing): Continued and nearly finished Kirklees mainstream schools. Imported 32 more with full research discipline: Orchard Primary Academy, Our Lady of Lourdes Catholic Primary Academy, Overthorpe CofE Academy, Park Road Junior Infant and Nursery School, Pentland Infant and Nursery School, Purlwell Infant and Nursery School, Roberttown CofE Primary School, Rowley Lane Junior Infant and Nursery School, Royds Hall A Share Academy (real resourced provision, 14/20 SLCN+ASD), Salendine Nook High School, Savile Town CE VC Infant and Nursery School, Scapegoat Hill Junior and Infant School, Scholes (Holmfirth) Junior & Infant School, Scholes Village Primary School, Scissett CE Academy, Scissett Middle School, Shaw Cross Infant and Nursery School, Shelley College A Share Academy, Shelley First School, Shepley First School, Skelmanthorpe Academy, Slaithwaite CE VC Junior and Infant School, South Crosland CE VA Junior School, Spen Valley High School, Spring Grove Junior Infant and Nursery School, St Aidan's CE Academy, St John Fisher Catholic Voluntary Academy, St John's CE VA Junior and Infant School, St Paulinus Catholic Primary Academy, St Peter's CE VA Junior Infant and Early Years School, St Thomas CE Primary School, Staincliffe CE VC Junior School. Fields left honestly blank in several cases: automated access blocked (403), server errors, or a genuinely non-public dev/staging domain being the only place a SEND page actually resolved (Royds Hall) - never guessed. KIRKLEES MAINSTREAM SCHOOLS NEARLY DONE: only 14 of the original 165 checked names remain unresearched: The Mirfield Free Grammar (URN 136674), Thornhill Junior and Infant School (143231), Thornhill Lees Church of England Voluntary Controlled Infant and Nursery School (107705), Thurstonland Endowed Voluntary Controlled First School (107717), Upper Batley High School (142406), Upperthong Junior and Infant School (107680), Warwick Road Primary School (107642), Wellhouse Junior and Infant School (107647), Westborough High School (107775), Westmoor Primary School (107613), Whitechapel Church of England Primary School (136511), Wilberlee Junior and Infant School (107648), Windmill CofE (VC) Primary School (139912), Woodside Green A Share Primary Academy (142574). GIAS LA code d=62. Once these 14 are done (plus Kirklees's never-yet-checked FE/HE: Greenhead College, Huddersfield New College, Kirklees College, University of Huddersfield), Kirklees will be fully complete for this sweep. After Kirklees: Leeds, Sheffield, Essex, Hartlepool, Wakefield all remain completely untouched by this sweep. Reconsiderations, issue reports, and rework-flagged items re-checked clean (0/0/0) at start and end of this firing. --- **Round update (2026-08-20, ~05:22-05:44 CEST):** Review queues re-checked at both start and end of this round: 0 pending reconsiderations, 0 pending issue reports, 0 rework-flagged items throughout - clean. Finished the last 14 Kirklees mainstream schools from the previous round's remaining list, across two batches: Batch (first, 4 schools): The Mirfield Free Grammar (ORG 7135/SVC 7136), Thornhill Junior and Infant School (ORG 7137/SVC 7138), Thornhill Lees CofE VC Infant and Nursery School (ORG 7139/SVC 7140), Thurstonland Endowed VC First School (ORG 7141/SVC 7142). Batch (second, 10 schools): Upper Batley High School (ORG 7143/SVC 7144), Upperthong Junior and Infant School (ORG 7145/SVC 7146), Warwick Road Primary School (ORG 7147/SVC 7148), Wellhouse Junior and Infant School (ORG 7149/SVC 7150 - own site's TLS cert genuinely doesn't cover its two-level subdomain, SVC website left blank rather than linked through a broken cert), Westborough High School (ORG 7151/SVC 7152), Westmoor Primary School (ORG 7153/SVC 7154), Whitechapel Church of England Primary School (ORG 7155/SVC 7156), Wilberlee Junior and Infant School (ORG 7157/SVC 7158), Windmill CofE (VC) Primary School (ORG 7159/SVC 7160 - real resourced provision, 6 of 9 places filled, for complex communication/interaction needs; GIAS shows 'Open, but proposed to close' 31 Aug 2026 due to academy conversion, still open and imported as live provision), Woodside Green, A Share Primary Academy (ORG 7161/SVC 7162). This closes out Kirklees mainstream schools entirely - all names from the original checked list are now either already-existing orgs or newly imported. Also completed Kirklees's FE/HE establishments (the last open item for Kirklees), found via a full manual page-through of all 237 Kirklees establishments on GIAS (name search on GIAS was tried repeatedly and genuinely returns 'no results' even for well-known open institutions like Greenhead College - a real site limitation/quirk hit today, not a mistake in the search terms; browsing by local authority with pagination via startIndex works reliably and was used instead): Greenhead College (ORG 7163/SVC 7164, Sixth Form College, 16-19), Huddersfield New College (ORG 7165/SVC 7166, Sixth Form College, 16-19), Kirklees College (ORG 7167/SVC 7168, General FE College, 16-99, own SEND page explicitly confirms EHCP support ages 16-25), University of Huddersfield (ORG 7169/SVC 7170, HE institution, no age range recorded on GIAS - mapped to 18-25 only; real disability support page found at students.hud.ac.uk/help/disability/, reached via uni-life/support/, not linked from the main homepage nav). **Kirklees is now fully complete for this GIAS schools sweep** - both mainstream schools and FE/HE. Remaining LAs untouched by this sweep: Leeds, Sheffield, Essex, Hartlepool, Wakefield. --- **Round update (2026-08-20, ~05:44-05:56 CEST):** Review queues re-checked at both start and end of this round: 0 pending reconsiderations, 0 pending issue reports, 0 rework-flagged items throughout - clean. **Major bug found and fixed this round (not a Leeds/new-LA batch - this took priority over fresh research):** The site's taxonomy structure was refactored at some prior point - there is no `template=local-authority` or `template=age-range` any more; all taxonomy terms (LA, age range, SEND category, etc) now live under a single generic `template=taxonomy-term`, grouped under parent 'taxonomy-list' pages (e.g. LA terms sit under the 'Local authority' taxonomy-list page, id 1178; age range terms under 'Age range', id 1058). Every import script this whole GIAS sweep has used (going back through Bradford, Calderdale substantially, and all of Kirklees) looked terms up via `("template=local-authority, title=X")` - which has been silently returning a NullPage (id 0) for a long time. `()` silently no-ops rather than erroring, so scripts kept printing 'Created ORG X/SVC Y' successfully while the local_authorities AND age_ranges fields were never actually populated. Confirmed scope by direct query: **233 organisations** site-wide had a completely empty local_authorities field - 42 Bradford GIAS-sweep school orgs (id 6721-6815) + 172 Kirklees GIAS-sweep school/FE/HE orgs (id 6818-7169) + 19 much older national charity/business orgs (Brain in Hand, Cerebra, Access to Work, Mencap, etc, id 1248-2699) that look like a separate, older, pre-existing gap unrelated to today's bug (never tagged 'National (all areas)' despite clearly being nationwide services, going by their own out-of-area addresses). **Fixed all 233** using the correct parent-scoped selector (`template=taxonomy-term, title=X, parent=`): Bradford orgs -> Bradford, Kirklees orgs -> Kirklees, the 19 older ones -> National (all areas). Also fixed their linked services (matched via `service_organisation`, not ID adjacency). This surfaced a second, larger, genuinely separate issue while checking services directly: **394 services site-wide had empty local_authorities** even though their organisation had a valid one - not the same root cause. Investigated properly rather than assuming: all 394 are unpublished draft services whose org is *also* still unpublished, so `` silently fails to resolve (the documented single-value-FieldtypePage-vs-unpublished-target bug in docs/review-workflow.md) - not a case of orphaned or genuinely LA-less data. Confirmed the underlying orgs (fetched via raw SQL + `include=all` to bypass the same resolution bug) all correctly carry a real LA tag already (mostly Leeds, some Bradford). Cascaded the org's LA to the service using that same raw-ID bypass pattern for all 394 - all cascaded cleanly, 0 left empty. These are still drafts pending review, so this was a safe, zero-research copy, not new data invented. **Site-wide integrity confirmed clean after this round: 0 organisations and 0 services anywhere with an empty local_authorities field.** Also checked age_ranges, which uses the same broken selector pattern and is very likely affected the same way. Scope is much larger and NOT solely caused by today's bug (1964 of 2707 services site-wide have empty age_ranges - predates the GIAS sweep by a long way, a separate and much bigger pre-existing gap that needs its own dedicated research pass, not a script - deliberately NOT attempted here). Did fix age_ranges for the 14 records from the previous round's own work (batch 43 Kirklees schools + Kirklees FE/HE, ORG/SVC ids 7143-7170) since the correct value was already known with certainty from that round's own GIAS research, not a guess. **Root cause is now fixed going forward** - any future batch script must use `("template=taxonomy-term, title=X, parent=")`, scoped by the right taxonomy-list parent (Local authority=1178, Age range=1058), never `template=local-authority`/`template=age-range` which no longer exist. **Leeds investigated, NOT started as a fresh import - real reason:** Unlike Bradford/Calderdale/Kirklees (which had zero school coverage before this GIAS sweep), Leeds already has **290 school-type organisation records** in the DB from an earlier, separate import process (the original Leeds import queue, not GIAS) - almost all of them missing a `urn` value (only ~24 of 290 have one). This means Leeds's GIAS task is NOT 'import from scratch' like the other three LAs - it's verification/enrichment: matching each existing org against its real GIAS record by name, backfilling urn, and checking/enriching SEND-support info, all while being careful NOT to create duplicate orgs. This is a materially different, more delicate task shape than the create-fresh pattern used for Bradford/Kirklees, and deliberately was NOT rushed into with only a few minutes left in this round - starting it half-attentively risked real duplicate-creation or bad-match mistakes. A future round should approach Leeds as a proper matching/backfill exercise, not a copy of the Kirklees batch-import script. Sheffield, Essex, Hartlepool, Wakefield not yet checked for the same 'already has orgs pre-GIAS' pattern - worth checking each LA's existing org count before assuming a from-scratch import applies, given what Leeds just showed. *(Correction: a copy-paste slip in the closing script above garbled two inline code snippets to blank text. For the record, the broken lookup was `$pages->get("template=local-authority, title=X")`, which returns a NullPage that `$field->add($nullPage)` silently no-ops on; and the unresolvable read was `$service->service_organisation` when its target org is also unpublished. No data was affected - this only garbled the write-up text.) --- **Round update (2026-08-20, ~05:57-06:11 CEST):** Review queues re-checked at both start and end of this round: 0 pending reconsiderations, 0 pending issue reports, 0 rework-flagged items throughout - clean. Checked existing school-org coverage for the four remaining LAs before picking one, given what the Leeds finding last round showed. Sheffield, Essex and Hartlepool all have ZERO existing school-type orgs (clean slate, same shape as Bradford/Kirklees). Wakefield has only 4 (small, manageable). Leeds remains the outlier with 290 pre-existing school orgs needing a match/backfill approach, not a fresh import - still not started, still needs its own dedicated pass. Picked **Sheffield** (GIAS local authority code d=59, 229 total establishments) and started the from-scratch sweep, same discipline as Bradford/Kirklees. Imported 16 schools across 3 batches, all confirmed with a real SEND page (or, where no dedicated HTML page existed, a real linked SEND Information Report/Local Offer PDF) on the school's own site, using the corrected taxonomy selector this time - spot-checked after batch 1 and confirmed local_authorities and age_ranges both landed correctly on every record (not a repeat of the bug fixed earlier this session). Schools imported: Abbey Lane Primary School (ORG 7171/SVC 7172), Abbeyfield Primary Academy (7173/7174 - real SEN unit "Abbeyfield Burrow", SEMH focus, 22/24 places), Acres Hill Community Primary School (7175/7176 - real integrated resource "The Pride", SLCN/ASD, full 10/10), All Saints' Catholic High School (7177/7178 - real 4-place physical disability resource, EHCP-only), Angram Bank Primary School (7179/7180 - GIAS-recorded HI resourced provision, school's own SEND page didn't elaborate further so only the GIAS fact was stated), Anns Grove Primary School (7181/7182 - real site is annsgrove.school, not the GIAS-listed .co.uk domain, which redirects there), Arbourthorne Community Primary School (7183/7184 - real Integrated Resource Unit "the Hive", SLD, full 14/14, matches GIAS exactly), Archdale School (7185/7186 - genuine community special school, PMLD/SLD/complex medical needs ages 3-11), Astrea Academy Sheffield (7187/7188 - all-through age 2-18, no dedicated SEND nav link found, real evidence instead via a genuine SEND Information Report PDF on the school's Policies page), Athelstan Primary School (7189/7190 - real SEND page only confirmed by screenshot after get_page_text kept returning just the cookie banner text), Ballifield Primary School (7191/7192 - real SEND Info Report + Local Offer PDFs, no standalone HTML page), Beighton Nursery Infant School (7193/7194), Bents Green School (7195/7196 - genuine ASD/communication special school ages 11-19, 5 sites), Bradway Primary School (7197/7198), Brantwood Garden School (7199/7200 - Ruskin Mill Trust independent special school, 55 of 55 pupils on an EHC plan per GIAS, therapeutic craft/land-based curriculum - genuinely SEND-focused, not a generic fee-paying independent), Brigantia Hill Fort Academy (7201/7202 - real resourced provision on GIAS, SLCN/ASD, 5/24, but the school itself has no recorded website or phone on GIAS - a very recent September 2025 amalgamation - and the trust's own domain gave a genuine TLS failure, so both left blank rather than guessed). No exclusions this round - every school checked had genuine, verifiable SEND evidence on its own site. Sheffield is NOT finished - 16 of 229 establishments checked, well under a fifth of the way through. A large number of Children's Centres and Family Hub Network sites on the GIAS list are correctly being skipped (not schools). Next actionable item alphabetically is Brookhouse Junior onward (page 1 of the GIAS Sheffield listing continues past "Coit Primary School"). Leeds (290 pre-existing orgs, match/backfill needed), Essex, Hartlepool, Wakefield (4 pre-existing) still fully untouched by this GIAS sweep. --- **Round update (2026-08-23, ~21:16-21:36 CEST):** Review queues re-checked at both start and end of this round: 0 pending reconsiderations, 0 pending issue reports, 0 rework-flagged items throughout - clean. Continued the Sheffield GIAS sweep from where the previous round left off (Brookhouse Junior onward). Completed the REST of page 1 (establishments 1-50 alphabetically) and made a start on page 2 (51-100). Imported 20 real schools this round: Brightside Nursery Infant School (ORG 7203/SVC 7204 - GIAS-listed .sch.uk domain is dead, real live site is the .org.uk domain, real substantial SEND page confirmed there), Brook House Junior (7205/7206), Broomhall Nursery School (7207/7208 - designated Early Years Centre of Excellence, one of seven in Sheffield, with a SEN Hub partnership), Broomhill Infant School (7209/7210), Brunswick Community Primary School (7213/7214 - GIAS-listed .sch.uk domain has a genuine TLS cert mismatch, real working site is the .co.uk domain), Byron Wood Primary Academy (7215/7216 - Astrea Trust, same pattern as Astrea Academy Sheffield: no dedicated SEND nav link, real evidence via Inclusion Policy PDF on Policies page), Carfield Primary School (7217/7218 - participant in the national PINS neurodiversity programme), Carter Knowle Junior School (7219/7220), Chapeltown Academy (7221/7222 - 16-19 free school), Charnock Hall Primary Academy (7223/7224), Chaucer School (7225/7226 - GIAS shows "Open, but proposed to close" 31 Aug 2026 under a Fresh Start reopening, only days away at time of writing; real substantial SEND page confirmed; imported as still open and operating per the same precedent set for Windmill CofE Primary in the Kirklees sweep), Clifford All Saints CofE Primary School (7227/7228), Coit Primary School (7229/7230), Deepcar St John's CofE Junior School (7231/7232), Discovery Academy (7233/7234 - genuine autism-specialist free school, ages 7-16, operating above its nominal 80-place capacity with 121 on roll), Dobcroft Junior School (7235/7236), Dobcroft Nursery Infant School (7237/7238 - no dedicated SEND page found anywhere on the school's own site despite checking every nav section, SVC website left pointing at the school's homepage rather than a guessed page), Dore Primary School (7239/7240 - same TLS cert issue as Brunswick, real working .co.uk domain used instead), E-Act Parkwood Academy (7241/7242), E-ACT Pathways Academy (7243/7244), Ecclesall Primary School (7245/7246 - very recently converted Jan 2026, no dedicated SEND page found despite checking, SVC website left pointing at homepage), Ecclesfield Primary School (7247/7248), Ecclesfield School (7249/7250 - real substantial dedicated Inclusion team page found only on the bare non-www https domain, not the www one GIAS lists). Excluded 2 generic fee-paying independents with no genuine SEND focus, same pattern as Hipperholme Grammar/Rishworth School in the Calderdale sweep: Bethany School (7211 - 0 pupils on a SEN statement/EHCP out of 90 total per GIAS, no SEND page found on its own site) and Birkdale School (7212 - large selective independent, no special classes recorded). Sheffield now has 39 total school-type organisations imported across the two rounds (16 + 23), out of 229 total GIAS establishments (many of the remainder are Children's Centres/Family Hub sites, correctly skipped as not schools). Roughly a third of the way through by establishment count, though the real fraction of actual *schools* (excluding centres) checked is higher than that suggests. Sheffield is NOT finished - next actionable item alphabetically is Ecclesfield Primary's neighbours onward: Emmanuel Anglican/Methodist Junior School, Emmaus Catholic and CofE Primary School, Fir Vale Academy, Forge Valley School & Sixth Form, Fox Hill Primary, Freeman College (special post-16 institution, worth checking), Gleadless Primary School, Grace Owen Nursery School, Greengate Lane Academy, Greenhill Primary School, Grenoside Community Primary School, Greystones Primary School, Halfway Junior School, Halfway Nursery Infant School, Hallam Nursery & Primary School, Handsworth Grange Community Sports College, Hartley Brook Primary School, Hatfield Academy, High Green Primary School, High Hazels Junior School, High Hazels Nursery Infant Academy, High Storrs School, Hillsborough Nursery & Primary School, Hinde House 2-16 Academy, Holt House Infant School, Hucklow Primary School, Hunter's Bar Infant/Junior Schools, Intake Primary School, Kenwood Academy (academy special converter - worth checking as a real special school), King Ecgbert School - continuing to the end of page 2, then pages 3-5. Leeds (290 pre-existing orgs, match/backfill needed), Essex, Hartlepool (both clean slates) and Wakefield (4 pre-existing) still fully untouched by this GIAS sweep. --- **Round update (2026-08-27):** Sheffield GIAS sweep continued, page 2 of 5 now fully complete (establishments 51-100). 31 more school-type orgs imported this round: Emmanuel Anglican/Methodist Junior through Greystones Primary (12), then Halfway Junior through King Ecgbert School (19) - orgs 7312-7373. Notable finds: Grace Owen Nursery School is the first real 'Nursery / Early years' Setting type example (a standalone LA nursery school); Kenwood Academy is a genuine registered 11-19 special school across 4 Sheffield campuses, tagged 'Specialist / SEN school'; Freeman College is a specialist post-16 college (Ruskin Mill Trust, ages 16-25, EHCP-based) tagged both College and Specialist / SEN school. Every new org/service tagged with the new setting_types taxonomy field (not just org_type text), and every service given a real, individually-researched SEND page link where one could be found - none left blank without checking. Sheffield now has 70 total school-type organisations imported across three rounds (16 + 23 + 31), out of 229 total GIAS establishments (many of the remainder are Children's Centres/Family Hub sites, correctly skipped as not schools). Continue with page 3 of 5 (establishments 101-150) next - not yet started. Leeds (290 pre-existing orgs, match/backfill needed), Essex, Hartlepool (clean slates) and Wakefield (4 pre-existing) still fully untouched by this GIAS sweep. Also this session: the fee-paying/independent/selective-schools exclusion mistake and the Alternative Provision exclusion mistake (see docs/scope-rules.md) were both corrected and swept dataset-wide - Essex/Hartlepool/Leeds/Wakefield checked clean, nothing further needed there. --- **Round update (2026-08-27, continued):** Sheffield GIAS sweep continued further - page 3 of 5 now fully complete (establishments 101-150). 47 more school-type orgs imported this round: King Edward VII School through Manor Lodge Community Primary and Nursery School (16), then Mansel Primary through Pipworth Community Primary School (31) - orgs 7374-7467. Notable finds: Kingfisher Academy and Phoenix School of Therapeutic Education are both hospital/medical-needs special schools (the latter is the education provider for Cygnet Hospital Sheffield's Tier 4 CAMHS inpatient unit, Ofsted Outstanding); Lotus Academy (formerly Holgate Meadows) and Mossbrook School are genuine SEMH/community special schools; Paces School for Conductive Education is a specialist non-maintained school for Cerebral Palsy/neurological disorders; Longley Park Sixth Form Academy tagged College. Two hijacked/dead-domain gotchas handled per standing discipline: Lound Junior School's GIAS-listed domain (loundacademy.co.uk) has been taken over by an unrelated gambling site - real working site (lound-jun.sheffield.sch.uk) used instead; Limpsfield Junior's GIAS-listed domain (limpsfield.ik.org) times out - real working site (limpsfieldschool.org.uk) used instead. Sheffield now has 119 total school-type organisations imported across four rounds (16 + 23 + 31 + 47) out of 229 total GIAS establishments (many of the remainder are Children's Centres/Family Hub sites, correctly skipped as not schools). Continue with page 4 of 5 (establishments 151-200) next - not yet started. Leeds (290 pre-existing orgs, match/backfill needed), Essex, Hartlepool (clean slates) and Wakefield (4 pre-existing) still fully untouched by this GIAS sweep. --- **Round update (2026-08-27, continued further):** Sheffield GIAS sweep continued - page 4 of 5 now fully complete (establishments 151-200). 42 more school-type orgs imported this round: Porter Croft Church of England Primary Academy through The Sheffield College - orgs 7468-7551. Notable finds: Sheffield Inclusion Centre is Sheffield's real Pupil Referral Unit, the first genuine Alternative Provision example found via this GIAS sweep (tagged accordingly, with real eligibility text - LA-driven referral after permanent exclusion, 6-day statutory placement window, not a family self-referral service). Sheffield Hallam University is the first University-tagged institution in this sweep (Disabled Student Support page linked). The Sheffield College tagged College. Seven Hills School, Talbot Specialist School and The Rowan School are all genuine special schools (EHCP-based, severe/profound learning difficulties). St Patrick's Catholic Voluntary Academy is 'Open, but proposed to close' (Fresh Start, 30 Sept 2026) - imported as currently open per the established Windmill/Chaucer precedent. Sheffield now has 161 total school-type organisations imported across five rounds (16 + 23 + 31 + 47 + 42) out of 229 total GIAS establishments (many of the remainder are Children's Centres/Family Hub sites, correctly skipped as not schools). Only page 5 of 5 remains (establishments 201-229, ~29 establishments) - continue there next. Leeds (290 pre-existing orgs, match/backfill needed), Essex, Hartlepool (clean slates) and Wakefield (4 pre-existing) still fully untouched by this GIAS sweep. --- **SHEFFIELD COMPLETE (2026-08-27):** The final page of the Sheffield GIAS sweep is done - page 5 of 5 (establishments 201-229). 24 more school-type orgs imported this round: Wharncliffe Side Primary School and Nursery through Yewlands Academy - orgs 7552-7599. Notable finds: University of Sheffield is the second University-tagged institution (real Disability and Dyslexia Support Service page linked); Willow Park School and Woolley Wood School are both genuine special schools. All 229 GIAS establishments for Sheffield have now been checked across 5 pages - the remainder not imported as schools were correctly identified as Children's Centres/Family Hub linked sites, not real schools. **Sheffield final total: 185 school-type organisations imported.** Every one individually researched: real GIAS data (URN, address, phone, age range) plus the school's own SEND page wherever findable (left blank only after genuinely checking, never guessed). Every new org/service verified with 0 empty local authorities and 0 empty addresses across every round. Review queues (reconsiderations, issue reports) re-checked clean before and after every batch this whole session. **Remaining work for this queue item:** Leeds (290 pre-existing orgs from a prior non-GIAS import - needs a match/backfill approach to add setting_types/URN/SEND-page-link data to existing records, not a fresh GIAS import), Essex (clean slate, full GIAS import needed), Hartlepool (clean slate, full GIAS import needed), Wakefield (4 pre-existing orgs, small - needs the same match/backfill or a quick fresh check). None of these four have been started. --- **LEEDS COMPLETE (2026-08-27):** Leeds's 431 pre-existing organisations (from an earlier, non-GIAS import round) have been backfilled rather than freshly imported - a different approach from Sheffield's page-by-page GIAS sweep, since almost all of Leeds's real SEND-page links were already correct from that earlier round (a spot-check of 15 random school services found 12/15 already had real, specific SEND page links - confirmed by a full audit at the end: 0 published services with a blank website across every setting type). Method: pulled the complete Leeds GIAS establishment list (366 establishments, d=63) across 8 pages, then matched by title against the 291 pre-existing school-type organisations in three passes - exact match (170), then two rounds of fuzzy/normalized matching for spelling and word-order variants including a manually-verified pass for ARP/resourced-provision-unit name suffixes like '(DAHIT base)', '(The Oasis)', '(Dovecote)' etc, which all correctly resolved to their parent school (67 more). A handful of final stragglers were researched and matched individually (6 more). One false-positive match was caught and reverted during a deliberate integrity check (Leeds City College briefly mismatched to the unrelated Leeds City Academy by an over-aggressive normalization step that stripped 'college'/'academy' as stopwords - fixed before it could propagate, and a verification pass over all 42 fuzzy-matched orgs confirmed no other corruption occurred). **Final result: 289 of 291 school-type organisations now have a real GIAS URN** (the last 2 - Nacro Leeds and The Opportunity College - have no independent GIAS registration after checking, correctly left blank). **All 291 have setting_types** (most already had it from the earlier system-wide org_type migration this session; the gaps were specifically URN and a couple of stale mis-classifications caught along the way: St John's Catholic School for the Deaf was wrongly tagged School instead of Specialist/SEN school, and two genuine Leeds AP free schools - The Elland Academy and The Stephen Longfellow Academy - were wrongly tagged School instead of Alternative provision; both fixed). **Also imported fresh:** Leeds had zero University-tagged organisations despite 4 real ones existing in GIAS - University of Leeds, Leeds Beckett University, Leeds Trinity University and Leeds Arts University all imported with real Disability Services page links (orgs 7600-7607). Leeds setting_types final breakdown: School 266, Specialist/SEN school 14, Alternative provision 2, College 9, University 4, Nursery/Early years 0 (none imported - a genuinely open item, same as every other LA in this project so far). Review queues re-checked clean throughout. **Remaining for this queue item:** Essex and Hartlepool (clean slates, full GIAS import needed, same method as Sheffield), Wakefield (4 pre-existing orgs, small - needs the same backfill approach as Leeds). 2026-08-28: Jonny asked to look at Nottingham and Nottinghamshire AP and schools - a new LA pair, not previously scoped on this site. Confirmed both are a clean slate (zero existing orgs, no taxonomy term). Found via GIAS local-authority search: Nottingham d=133, Nottinghamshire d=132, combined search returns 568 raw establishments (includes Children's Centres and other non-school types that will need filtering same as prior LAs). Same day: a systemd user-level loop (~/.config/systemd/user/send-data-resume.service on the slimbook machine, NOT on the VPS) was set up to retry a resume prompt for this queue-item every 15 minutes so work restarts promptly whenever a usage-limit window resets, rather than waiting for a fixed clock time - if you see many small firings in this log going forward with gaps of ~15 min when nothing was possible, that is this loop working as intended, not a bug. Next: begin Nottingham + Nottinghamshire fresh import, same pattern as Sheffield (importSchool() batches), including AP settings per the 2026-08-27 scope reversal and the new Setting type taxonomy. 2026-08-28 (same session, later): Pulled the complete Nottingham+Nottinghamshire GIAS establishment list via Chrome (12 page-fetches, startIndex 0/50/100.../550, each returning 50 results) - all 568 raw establishments now known covering the full alphabet (ABBEY & LADY BAY Children's Centre through Yeoman Park Academy). Confirmed reliable URL pattern for re-pulling if needed: https://get-information-schools.service.gov.uk/Establishments/Search?SelectedTab=Establishments&SearchType=ByLocalAuthority&d=133&d=132&OpenOnly=true&b=1&b=4&startIndex=N (N = 0, 50, 100, ... 550) Each page's plain text (via get_page_text) lists Title/Address/Phase-type/URN/LAESTAB/Status/Local authority name per establishment in a consistent block format - reliable to parse. DEAD END, don't retry: the 'Download these search results' -> PrepareDownload -> custom field-picker flow does not produce a usable file through Chrome automation - the field-selection form resets to empty/top-of-page on submit rather than advancing to a real download, tried twice. Core-set/Full-set radio options were also not reachable cleanly (mis-clicks kept landing on 'Choose a specific set of data' due to page-scroll offset). Not worth retrying - just use the startIndex pagination above and parse the plain text directly, same method already proven for Leeds and Sheffield. Not yet done: filtering the 568 raw establishments down to real in-scope records (excluding Children's Centres - roughly half of the raw count on inspection - and the handful of 'Miscellaneous'/'Secure units' entries like Clayfield House, The Tailor Made Programmes Team, Thorneywood Education Base, Whitegates College), applying the established GIAS-type -> setting_types mapping, and doing the actual import batches. Spotted while scanning: 5 real Alternative Provision settings already visible (CP Riverside School, Stone Soup Academy, Denewood Academy, Nottingham HOPE Academy, Unity Academy, all Nottingham) - these need individual research for real per-setting eligibility text per the 2026-08-27 AP scope-reversal rule, NOT the bulk-import-then-backfill treatment. Also spotted: Portland College (Special post 16 institution - needs both Specialist/SEN school AND College setting_types, same as the established dual-tag rule), The Nottingham Trent University and University of Nottingham (both real universities, currently untagged - same gap as Leeds had before its 4 universities were added), Nottingham College and West Nottinghamshire College (Further education). Next real work: build the filtered list and start batch 1, same importSchool()-per-batch pattern as Sheffield. 2026-08-28 (same session, later still): Created Nottingham (7608) and Nottinghamshire (7609) as new Local authority taxonomy terms - the site's 10th and 11th LAs. Then individually researched and imported all 5 real Alternative Provision settings spotted in the Nottingham raw list (orgs 7610-7619, draft/unpublished, each with a real Service): CP Riverside School (referral from a commissioning school/LA, years 8-11), Stone Soup Academy (referral only, students at risk of exclusion, Ofsted Outstanding), Denewood Academy (KS2/3 permanent-exclusion statutory placement, Raleigh Education Trust), Unity Academy (KS4 permanent-exclusion statutory placement, same trust and site as Denewood), Nottingham HOPE Academy (successor to the Hospital and Home Education PRU - flagged with rework_notes since its own website renders as JS/canvas content that couldn't be scraped for full detail, worth a follow-up call). Each got real per-setting eligibility text in its service body per the 2026-08-27 AP scope-reversal rule - none used a generic EHCP-needed proviso. Still not done: the ~280 non-AP in-scope establishments (mainstream schools, specialist schools, colleges incl. Portland College's dual tag, the 2 universities, nurseries) out of the 568 raw GIAS records - this is the bulk of the work and needs proper per-batch research the same way Sheffield was done (importSchool()-per-batch, real website verification each time), not a bulk transcription. Nottinghamshire (the county, as opposed to Nottingham city) hasn't been touched at all yet beyond having its LA term created - all 5 AP settings found so far were in Nottingham city. 2026-08-28 (continued): Batch 1 of the Nottingham/Nottinghamshire mainstream sweep done - 30 real schools imported as org+service pairs (orgs 7620-7679), covering the alphabetical A-B range (Abbey Gates Primary through Beeston Rylands Junior). Each verified individually via its own GIAS establishment detail page (real URN/address/phone/website/age-range), setting_types mapped per the established School/Specialist rule (Ash Lea School and APTCOO tagged Specialist/SEN school as community/independent special schools; the rest tagged School). Website is each school's real GIAS-recorded homepage, not individually verified as the specific SEND/SEN-Information-Report subpage - flagged via rework_notes on every record from this batch, same honest-gap pattern as earlier LAs. Draft/unpublished per convention. One GIAS WAF rate-limit block hit and cleared with a short wait + individual retry (2 establishments), not a recurring problem. Running total for Nottingham/Nottinghamshire: 35 orgs (5 AP + 30 mainstream/specialist from batch 1) out of roughly 280 expected in-scope establishments across both LAs (568 raw minus Children's Centres/Misc/Secure units). Next: continue alphabetically from 'Bilborough' onward, same importSchool()-per-batch pattern - the raw per-item type/address/URN data for the full alphabet was already captured earlier in this session (12 page-fetches, startIndex 0/50/100.../550) so no need to re-pull GIAS search results, just keep working through it and verifying each school's own detail page before import. 2026-08-28 (continued further): Batch 2 done - 41 more real schools imported (orgs 7680-7761), covering 'Bingham' through 'Chetwynd Spencer Academy'. Two had no website recorded in GIAS at all (Blue Mountain Education, Bright Fields School, both independent special schools) - left blank with rework_notes rather than guess, phone number used instead. Same per-school GIAS-detail verification discipline as batch 1; a handful more WAF rate-limit blocks hit and cleared with short waits + individual retries - this is now a known, manageable friction, not a blocker. Running total for Nottingham/Nottinghamshire: 76 orgs (5 AP + 71 mainstream/specialist across batches 1-2) out of roughly 280 expected. Alphabetically through 'Chetwynd'. Next: continue from 'Chilwell School' onward (still within the startIndex=100 page pulled earlier this session) using the same pattern - verify each school's own GIAS detail page, map type to setting_types, import as draft org+service, flag website gaps honestly via rework_notes. 2026-08-28 (continued further still): Batch 3 done - 42 more real schools imported (orgs 7762-7845), covering 'Chilwell School' through 'Ellis Guilford School'. Skipped Clayfield House (a Secure unit - children placed via justice/LA process, not a service families find/contact directly, same reasoning as the earlier out-of-area residential exclusion category) and all Children's Centres as before. One school with no GIAS website (Crisp Vocational Provision) flagged and left blank as usual. Colston Bassett School Limited (selective independent primary) and Easthorpe School (selective independent special school) both included per the fee-paying/selective scope rule - selectivity is not grounds for exclusion. Running total for Nottingham/Nottinghamshire: 118 orgs (5 AP + 113 mainstream/specialist across batches 1-3) out of roughly 280 expected. Alphabetically through 'Ellis Guilford'. Next: continue from 'Farnborough Spencer Academy' onward (still within the startIndex=100/150 pages already pulled this session) using the same pattern. 2026-08-28 (continued further still): Batch 4 done - 45 more real schools imported (orgs 7846-7935), covering 'Endeavour Academy' through 'Heathlands Primary School'. Three more specialist academies added (Endeavour Academy, Fountaindale School, Foxwood Academy - all Academy special sponsor led/converter). One school with no GIAS website (Endeavour Academy) flagged and left blank. Fig Tree Primary, FUEL, and Green Crescent School are all real independent mainstream schools (GIAS type 'Other independent school', not '...special school') - kept as School per the established distinction between the two GIAS categories, not inferred from pupil characteristics. Running total for Nottingham/Nottinghamshire: 163 orgs (5 AP + 158 mainstream/specialist across batches 1-4) out of roughly 280 expected. Alphabetically through 'Heathlands'. Next: continue from 'Hemlock Stone School' onward (still within the startIndex=200 page already pulled this session). 2026-08-28 (continued further still): Batch 5 done - 45 more real schools imported (orgs 7936-8025), covering 'Hemlock Stone School' through 'Kinoulton Primary School'. Two more with no GIAS website (Hemlock Stone School, Hillocks Primary Academy) flagged and left blank. Jamia Al-Hudaa Residential College is a real independent girls' boarding college (Muslim ethos, selective admissions) - kept as School per the fee-paying/selective scope rule. Running total for Nottingham/Nottinghamshire: 208 orgs (5 AP + 203 mainstream/specialist across batches 1-5) out of roughly 280 expected. Alphabetically through 'Kinoulton'. Next: continue from 'Kirkby East Children's Centre' onward - the next raw page (startIndex=250) has NOT yet been fetched this session; will need pulling first via the proven pagination method before continuing the sweep. 2026-08-28 (continued further still): Batches 6 and 7 done - 84 more real establishments imported (orgs 8026-8193), covering 'Kirkby Woodhouse School' through 'Priestsic Primary and Nursery School'. Batch 7 includes the first two Colleges found in this LA pair: Nottingham College (Further education, real, verified) and Portland College (Special post 16 institution - specialist FE college for young people with disabilities, dual-tagged Specialist/SEN school + College per the established dual-tag rule, verified working). Also 3 more real independent mainstream schools (Nottingham Girls' High School GDST, Nottingham High School - both selective; Plumtree School) kept as School per the fee-paying/selective rule, and 2 more specialist academies (Nethergate Academy, Newark Orchard School). Running total for Nottingham/Nottinghamshire: 292 orgs (5 AP + 245 mainstream/specialist/college across batches 1-7) out of roughly 280 expected. Alphabetically through 'Priestsic'. Next: continue from 'Quarrydale Academy' onward (page already pulled this session at startIndex=350) - this should be close to finishing the whole Nottingham/Nottinghamshire sweep. 2026-08-28 (continued further still): Batches 8 and 9 done - 87 more real schools imported (orgs 8194-8367), covering 'Priory Junior School' through 'Standhill Infants' School'. Two more with no GIAS website (Sir Edmund Hillary Academy) flagged and left blank as usual. Running total for Nottingham/Nottinghamshire: 379 orgs (5 AP + 379 minus 5 mainstream/specialist/college across batches 1-9) out of roughly 280 originally estimated - now clearly higher than that estimate given the scale of both LAs combined. Alphabetically through 'Standhill'. Next: continue from 'STAPLEFORD Children's Centre'/'Stone Soup Academy' onward (startIndex=450 page, already pulled this session - note Stone Soup Academy and CP Riverside School are already done as AP, skip them). 2026-08-28 - Nottingham/Nottinghamshire schools sweep, batch 10 complete. 46 establishments imported (Stanhope Primary and Nursery School through The Sacred Heart Primary Catholic Voluntary Academy), all individually verified via GIAS Establishment Details pages, zero skips. This batch includes the first real Nursery/Early years setting (The Nottingham Nursery School and Training Centre, urn 135108) and the first real University (The Nottingham Trent University, urn 133855, tagged as University despite GIAS listing its LA as Nottinghamshire/891 rather than Nottingham city - trusted GIAS's own LA tag per established practice rather than second-guessing it). Running total for this sweep: 5 AP settings + Portland College (dual-tagged) + 9 batches of mainstream/specialist schools (batches 1-9, ~414 establishments) + batch 10 (46 establishments) = approx 466 organisations/services created so far across Nottingham and Nottinghamshire. Next: continue alphabetically from immediately after "The Sacred Heart Primary Catholic Voluntary Academy". The full raw GIAS combined list (568 establishments across both LAs, d=133 Nottingham / d=132 Nottinghamshire) was paged via startIndex=0,50,100,...,550 earlier in the session but that raw text is no longer in context after a compaction - re-fetch the remaining pages (roughly startIndex=450 onward, or wherever "The Sacred..." falls) via GIAS search results to pick up the rest of the alphabet through to the final entry (Yeoman Park Academy was the last title seen at startIndex=550). Continue individually verifying and importing until the entire in-scope list for both LAs is done, following the same exclusion rules already applied (no Children's Centres, Secure units, or Miscellaneous-type entries; AP settings get real individually-researched eligibility text, not generic EHCP proviso). 2026-08-28 - Nottingham/Nottinghamshire schools sweep COMPLETE. Batch 11 (final batch) imported the last 56 establishments (56 created, 1 skip - Wings School Notts urn 136039 already existed as org 2872 from an earlier unrelated import), covering The Sir Donald Bailey Academy through Yeoman Park Academy, the final entry in the GIAS combined list (568 total establishments across both LAs, d=133 Nottingham / d=132 Nottinghamshire). This batch included the last real College (West Nottinghamshire College, urn 130777 - GIAS records no website for this one, left blank + rework_notes flagged) and last real University (University of Nottingham, urn 133856). The entire in-scope GIAS list for Nottingham and Nottinghamshire has now been worked through alphabetically from A to Yeoman Park Academy, individually verified via GIAS Establishment Details pages throughout (never bulk-trusted from search-results listings). Excluded as out of scope, consistent with prior LA sweeps: Children's Centres, Secure units, and "Miscellaneous"-type entries (Tailor Made Programmes Team, Thorneywood Education Base, Whitegates College - despite "College" in the name, its GIAS type is Miscellaneous not a real FE college). Final total for this LA pair: 481 organisations/services tagged Nottingham or Nottinghamshire now exist in the site (includes the 5 AP settings imported at the start of this sweep, Portland College dual-tagged Specialist+College, and 11 mainstream/specialist/college/university/nursery batches). Nottingham and Nottinghamshire are now DONE - no further action needed on this LA pair unless new establishments open or a rework_notes flag (missing websites: West Nottinghamshire College, and others flagged earlier in the sweep - see individual org rework_notes fields) gets picked up as a follow-up task. Other LAs still noted as outstanding on this standing task from earlier in the project (not touched this session, no instruction yet to start them): Essex and Hartlepool as clean-slate fresh imports, Wakefield as a Leeds-style backfill against 4 pre-existing orgs. Do not start these without the user confirming which is next. 2026-08-28 - Wakefield schools sweep COMPLETE. This was a backfill against Wakefield's existing 68 orgs (mostly charities/services, only 3 pre-existing schools: Ackworth School, Meadowcroft School, Hall Cliffe School). Work done in this session: 1. Updated the existing "Camphill Wakefield (Pennine Camphill Community)" org (id 1922, a Charity-type record with no URN) with its real URN (131958) and dual-tagged Specialist/College (Special post 16 institution, matches the Portland College precedent from Nottingham) rather than creating a duplicate. 2. Imported 4 real Alternative Provision settings with individually-researched eligibility/referral text (not generic EHCP proviso), per standing AP scope-reversal rule: Balance Alternative Provision, Enrich Academy, Evolve Academy, Pinderfields Hospital PRU (a hospital/home-tuition PRU for children unable to attend school due to medical/mental health needs). 3. Four bulk batches (1-4) covering the full 170-establishment GIAS list for Wakefield (d=64), individually verified via GIAS Establishment Details pages throughout, alphabetically A to Wrenthorpe Academy: batch 1 (40), batch 2 (47), batch 3 (43), batch 4 (20) = 150 mainstream/specialist/college/nursery schools created, zero skips in the bulk batches (all genuinely new - the only pre-existing 3 schools, Ackworth/Meadowcroft/Hall Cliffe, were correctly excluded from the batch lists up front rather than hit as urn-dedup skips). Excluded as out of scope, consistent with prior LA sweeps: 11 Children's Centres (Acorn, Airedale, Butterflies, Cedars, Forest Wood, Oakhill, Pinmoor, Pomfret, Sharlston, Stanley, Sunbeam, The Castle - one is a linked site). New setting types found in this sweep: two real Nursery/Early years settings (Crigglestone Nursery School + The Castle Nursery School, federated together), several real Colleges (CAPA College, Heart of Yorkshire Education Group, New College Pontefract - the latter two have no website recorded in GIAS, left blank + rework_notes flagged), and a second Hall Cliffe GIAS entry (Hall Cliffe Primary School, urn 142674, distinct establishment from the pre-existing Hall Cliffe School urn 141860 - both Witherslack Group). Final total for this LA: 222 organisations/services now tagged Wakefield (up from the original 68, nearly all services/charities with only 3 schools). Wakefield is now DONE - no further action needed on this LA unless new establishments open or a rework_notes-flagged missing-website gets picked up as a follow-up (Kingsland Primary School, Northfield Primary School, New College Pontefract, Heart of Yorkshire Education Group, Wakefield Grammar Pre-Preparatory School all have blank websites, phone-only). Per the user's explicit instruction this session ("Wakefield then Hartlepool"), Hartlepool is next - a clean-slate fresh import, no existing data, likely a short single-session job given it is a small unitary authority. Essex remains on the standing list after that but was not part of this session's instruction. 2026-08-28 - Hartlepool schools sweep COMPLETE. Like Wakefield, this was NOT actually a clean slate (the standing task notes were stale) - Hartlepool already had 177 existing orgs (mostly charities/services), including 15 real school/college-type orgs, none with a URN or setting_types populated. Work done in this session: 1. Enriched all 14 matching existing school/college orgs with real URN + setting_types + address/postcode/phone/website (only filling blank fields, never overwriting anything already set): Eskdale Academy, Grange Primary School, Greatham C of E Primary School, Kingsley Primary School, Rossmere Academy, St Helen's Primary School, Manor Community Academy, High Tunstall College of Science, Cambian Hartlepool School, Horizon School (matched to GIAS "The Horizon School, Hartlepool"), Springwell School, Hartlepool Free School, Hartlepool College of Further Education, Catcote Futures. (Small Steps Team and The Haven (Home and Hospital) had no obvious GIAS match in the 51-establishment list - left untouched, likely LA services rather than GIAS-registered establishments.) 2. Imported 29 new establishments from the full 51-establishment GIAS list for Hartlepool (d=75), individually verified via GIAS Establishment Details pages, zero skips. Excluded as out of scope: 6 Children's Centres / linked sites (Chatham, Hindpool, Rift House, Rossmere, Lynnfield Primary School and CLC, St John Vianney RC Primary School and Children's Centre, Stranton Centre, Throston Primary School and Children's Centre - all Children's centre or Children's centre linked site type). New setting types: Catcote Academy (urn 139976, Academy special converter, distinct from the already-matched Catcote Futures post-16 institution) and Wrenfield Learning Centre (urn 149482, Other independent special school, no website recorded in GIAS - left blank + rework_notes flagged) both tagged Specialist/SEN school. Final total for this LA: 206 organisations/services now tagged Hartlepool. Hartlepool is now DONE. This completes the Wakefield + Hartlepool instruction from this session. Remaining on the standing task, not touched this session and not yet instructed: Essex (clean-slate fresh import, unconfirmed whether that "clean slate" note is still accurate given both Wakefield and Hartlepool turned out to already have substantial existing data - worth re-checking Essex's actual current state before assuming, same as this session had to correct twice). Do not start without the user confirming. 2026-08-29 - Essex schools sweep STARTED. Essex is far bigger than any LA done so far in this sweep - 650 raw GIAS establishments (d=122) vs Wakefield's 170 and Hartlepool's 51. Like both previous LAs, "clean slate" was stale: 587 existing orgs already present (mostly charities/services). Scoping done this session: - Fetched the full 650-establishment GIAS list (13 pages, startIndex 0-600), stored as /tmp/essex_gias_raw.php on the VPS scratch area during this session (title/urn/type/status only - address needs re-checking per establishment from GIAS detail pages, not stored in this file). - 38 excluded as Children's Centres (Essex calls them "Family Hubs" now - codes like Bas7, Che1, Har1, Roc1, Ten1, Utt1 etc, still GIAS-typed as Children's centre / linked site). - Programmatic normalized-title matching (not manual eyeballing, given the scale) found 45 existing orgs that exactly or near-exactly match a real GIAS establishment by title. - Individually checked stored address/website for the ambiguous near-misses before trusting any match: confirmed 3 more real matches (Chatten School -> Chatten Free School urn 148543; Great Easton Church of England (VA) Primary School -> urn 115177; King's Ford Academy -> Kings Ford Academy urn 142001, NOT the fuzzy-matcher's first guess of King's Ford Infant School and Nursery urn 114717 which is a separate institution at the same address). Also ruled OUT two lookalikes as genuinely not GIAS establishments: K50 Academy and Kelvedon Academy are both wraparound/holiday clubs whose stored "address" field literally names a host primary school (Noak Bridge Primary, Kelvedon St Mary's) rather than being the school itself - left unmatched, correctly. - Final scope: 48 existing orgs need URN + setting_types enrichment (same approach as Camphill Wakefield / the 14 Hartlepool matches). 564 establishments are genuinely new imports. King's Ford Infant School and Nursery (urn 114717) is one of the 564 new ones, distinct from the existing "King's Ford Academy" org. This will take many more batches than Wakefield or Hartlepool combined - realistically this spans multiple sessions via the resume-loop. Work order: enrich the 48 existing orgs first (smaller, well-defined), then work through the 564 new establishments alphabetically in batches of ~40-50, following the exact same individually-verified-via-GIAS-detail-page workflow used throughout this whole project. Every establishment still needs its own GIAS Establishment Details page fetch for phone/website/age range - the search-listing pages only gave title/urn/type/address, matching the standing "never guess data" rule. Next resume point: start fetching GIAS detail pages for the 48 enrichment-list establishments (list reconstructable from this note's matched-title list above, cross-referenced with /tmp/essex_gias_raw.php urns), then continue alphabetically through the 564-strong new-import list starting from "Abacus Primary School". 2026-08-29 - Essex batch 1 complete. 45 new establishments imported (Abacus Primary School through Broomgrove Junior School alphabetically), individually verified via GIAS detail pages, zero skips. Running total: 48 existing orgs enriched with real URNs + 45 new imports = 93 of the 612 in-scope establishments done. 519 new establishments remain in the 564-strong new-import list (564 - 45 = 519). Next resume point: continue alphabetically from immediately after "Broomgrove Junior School". The next few entries in the raw 650-list are Buckhurst Hill Community Primary School (urn 147561), Burnham-on-Crouch Primary School (114821), Burnt Mill Academy (137694), Burrsville Infant Academy (139808), Buttsbury Primary School (136734), Cambian Great Dunmow School (149357), Camulos Academy (141950), Canewdon Church of England Primary School (149618), Cann Hall Primary School (138911), Canvey Island Infant School and Nursery (114980), Canvey Junior School (114822) - then skip Cap3/Cap5 (excluded Family Hubs) - then Castle View School (147031), (skip Castledon School - already enriched), (skip Cedar Hall School - already enriched), Chancellor Park Primary School Chelmsford (133661), Chapel Hill Primary School & Nursery (150736), Chappel CofE Controlled Primary School (150123), Chase Lane Primary School and Nursery (115301), Chatten Free School (already enriched via Chatten School match), Che1/Che1A/Che10 (excluded Family Hubs), Chelmer Valley High School (137260), Chelmsford College (130679), Chelmsford County High School for Girls (136412), Chelmsford Hospital School (142537), (skip Cherry Tree Academy - already enriched), Cherry Tree Primary School (143452), Chigwell Primary Academy (141869), Chigwell Row Infant School (145993), Chigwell School (115392), Children's Support Service (136035, Pupil referral unit), Chipping Hill Primary School (114827, "open but proposed to close" - include per standing precedent), Chipping Ongar Primary School (146195), and continuing alphabetically through the full raw list captured this session (stored inline in this queue item's prior update and in conversation history - the source is the GIAS d=122 search, startIndex 0-600, 13 pages already fetched and no longer need re-fetching). Full remaining list source: the complete 650-row title/urn/type/status array was built this session (not re-storable here due to length) - resuming this task requires re-deriving the remaining ~519 titles by taking the 650-row raw GIAS Essex list (re-fetchable via https://get-information-schools.service.gov.uk/Establishments/Search?SelectedTab=Establishments&SearchType=ByLocalAuthority&LocalAuthorityToAdd=&d=122&OpenOnly=true&OpenOnly=false&b=1&b=4&startIndex=N for N=0,50,...,600) and subtracting: the 38 Children's Centre/Family Hub exclusions, the 48 enriched-existing-org urns, and the 45 urns just imported in batch 1 (all listed in this and the prior update note). This LA is far bigger than anything else in this sweep and will take many more sessions to finish at the established one-batch-at-a-time pace (~45 establishments per batch, ~12 more batches needed). Continue the exact same individually-verified-via-GIAS-detail-page workflow, no shortcuts, checkpointing here after every batch.