british_local_authorities_database_seeder.php

<?php

use Illuminate\Database\Seeder;
use App\Models\LocalAuthority;

class LocalAuthoritiesSeeder extends Seeder
{
    /**
     * This is a database seeder for UK local authorities.
     * The file is a laravel database seeder but the arrays could be used for anything.
     * See comments for more info.
     * 
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $metropolitan_districts = [
            'Barnsley Borough Council',
            'Rochdale Borough Council',
            'Birmingham City Council ',
            'Rotherham Borough Council',
            'Bolton Borough Council 21',
            'South Tyneside Borough Council',
            'Bradford City Council ',
            'Salford City Council',
            'Bury Borough Council ',
            'Sandwell Borough Council',
            'Calderdale Borough Council ',
            'Sefton Borough Council',
            'Coventry City Council ',
            'Sheffield City Council',
            'Doncaster Borough Council ',
            'Solihull Borough Council',
            'Dudley Borough Council ',
            'St Helens Borough Council',
            'Gateshead Borough Council',
            'Stockport Borough Council',
            'Kirklees Borough Council ',
            'Sunderland City Council',
            'Knowsley Borough Council',
            'Tameside Borough Council',
            'Leeds City Council ',
            'Trafford Borough Council',
            'Liverpool City Council ',
            'Wakefield City Council',
            'Manchester City Council ',
            'Walsall Borough Council',
            'North Tyneside Borough Council ',
            'Wigan Borough Council',
            'Newcastle Upon Tyne City Council ',
            'Wirral Borough Council',
            'Oldham Borough Council ',
            'Wolverhampton City Council'
        ];
        $london_boroughs = [
            'Barking and Dagenham ',
            'Hounslow',
            'Barnet ',
            'Islington',
            'Bexley ',
            'Kensington and Chelsea',
            'Brent ',
            'Kingston upon Thames',
            'Bromley ',
            'Lambeth',
            'Camden ',
            'Lewisham',
            'Croydon ',
            'Merton',
            'Ealing ',
            'Newham',
            'Enfield ',
            'Redbridge',
            'Greenwich ',
            'Richmond upon Thames',
            'Hackney ',
            'Southwark',
            'Hammersmith and Fulham ',
            'Sutton',
            'Haringey ',
            'Tower Hamlets',
            'Harrow ',
            'Waltham Forest',
            'Havering ',
            'Wandsworth',
            'Hillingdon ',
            'Westminster'
        ];

        $unitary_authorities = [
            'Bath and North East Somerset',
            'Council',
            'North Somerset Council',
            'Bedford Borough Council',
            'Northumberland County Council',
            'Blackburn with Darwen Borough Council',
            'Nottingham City Council',
            'Blackpool Council',
            'Peterborough City Council',
            'Bournemouth Borough Council',
            'Plymouth City Council',
            'Bracknell Forest Borough Council',
            'Poole Borough Council',
            'Brighton and Hove City Council',
            'Portsmouth City Council',
            'Bristol City Council',
            'Reading Borough Council',
            'Central Bedfordshire Council',
            'Redcar and Cleveland Borough Council',
            'Cheshire East Council',
            'Rutland County Council',
            'Cheshire West and Chester Council',
            'Shropshire Council',
            'Cornwall Council',
            'Slough Borough Council',
            'Durham County Council',
            'Southampton City Council',
            'Darlington Borough Council',
            'Southend-on-Sea Borough Council',
            'Derby City Council',
            'South Gloucestershire Council',
            'East Riding of Yorkshire Council',
            'Stockton-on-Tees Borough Council',
            'Halton Borough Council',
            'Stoke-on-Trent City Council',
            'Hartlepool Borough Council',
            'Swindon Borough Council',
            'Herefordshire Council',
            'Telford and Wrekin Borough Council',
            'Isle of Wight Council',
            'Thurrock Council',
            'Hull City Council',
            'Torbay Council',
            'Leicester City Council',
            'Warrington Borough Council',
            'Luton Borough Council',
            'West Berkshire Council',
            'Medway Council',
            'Wiltshire Council',
            'Middlesbrough Borough Council',
            'Windsor and Maidenhead Borough Council',
            'Milton Keynes Council',
            'Wokingham Borough Council',
            'North East Lincolnshire Council',
            'City of York Council',
            'North Lincolnshire Council'
        ];

        $county_councils = [
            'Buckinghamshire County Council',
            'Lincolnshire County Council',
            'Cambridgeshire County Council',
            'Norfolk County Council',
            'Cumbria County Council',
            'North Yorkshire County Council',
            'Derbyshire County Council',
            'Northamptonshire County Council',
            'Devon County Council',
            'Nottinghamshire County Council',
            'Dorset County Council',
            'Oxfordshire County Council',
            'East Sussex County Council',
            'Somerset County Council',
            'Essex County Council',
            'Staffordshire County Council',
            'Gloucestershire County Council',
            'Suffolk County Council',
            'Hampshire County Council',
            'Surrey County Council',
            'Hertfordshire County Council',
            'Warwickshire County Council',
            'Kent County Council',
            'West Sussex County Council',
            'Lancashire County Council',
            'Worcestershire County Council',
            'Leicestershire County Council'
        ];
        
        $district_councils = [
            'Adur District Council',
            'Charnwood Borough Council',
            'Allerdale District Council',
            'Chelmsford City Council',
            'Amber Valley Borough Council',
            'Cheltenham Borough Council',
            'Arun District Council',
            'Cherwell District Council',
            'Ashfield District Council',
            'Chesterfield Borough Council',
            'Ashford Borough Council',
            'Chichester District Council',
            'Aylesbury Vale District Council',
            'Chiltern District Council',
            'Babergh District Council',
            'Chorley Borough Council',
            'Barrow-in-Furness Borough Council',
            'Christchurch Borough Council',
            'Basildon Borough Council',
            'Colchester Borough Council',
            'Basingstoke & Deane Borough Council',
            'Copeland Borough Council',
            'Bassetlaw District Council',
            'Corby Borough Council',
            'Blaby District Council',
            'Cotswold District Council',
            'Bolsover District Council',
            'Craven District Council',
            'Boston Borough Council',
            'Crawley Borough Council',
            'Braintree District Council',
            'Dacorum Borough Council',
            'Breckland District Council',
            'Dartford Borough Council',
            'Brentwood Borough Council',
            'Daventry District Council',
            'Broadland District Council',
            'Derbyshire Dales District Council',
            'Bromsgrove District Council',
            'Dover District Council',
            'Broxbourne Borough Council',
            'East Cambridgeshire District Council',
            'Broxtowe Borough Council',
            'East Devon District Council',
            'Burnley Borough Council',
            'East Dorset District Council',
            'Cambridge City Council',
            'East Hampshire District Council',
            'Cannock Chase District Council',
            'East Hertfordshire District Council',
            'Canterbury City Council',
            'East Lindsey District Council',
            'Carlisle City Council',
            'East Northamptonshire District Council',
            'Castle Point District Council',
            'East Staffordshire Borough Council',
            'Eastbourne Borough Council',
            'Hinckley and Bosworth Borough Council',
            'Eastleigh Borough Council',
            'Horsham District Council',
            'Eden District Council',
            'Huntingdonshire District Council',
            'Elmbridge Borough Council',
            'Hyndburn Borough Council',
            'Epping Forest District Council',
            'Ipswich Borough Council',
            'Epsom & Ewell Borough Council',
            'Kettering Borough Council',
            'Erewash Borough Council',
            'Kings Lynn & West Norfolk Borough Council',
            'Exeter City Council',
            'Lancaster City Council',
            'Fareham Borough Council',
            'Lewes District Council',
            'Fenland District Council',
            'Lichfield City Council',
            'Forest Heath District Council',
            'Lincoln City Council',
            'Forest of Dean District Council',
            'Maidstone Borough Council',
            'Fylde Borough Council',
            'Maldon District Council',
            'Gedling Borough Council',
            'Malvern Hills District Council',
            'Gloucester City Council',
            'Mansfield District Council',
            'Gosport Borough Council',
            'Melton Borough Council',
            'Gravesham Borough Council',
            'Mendip District Council',
            'Great Yarmouth Borough Council',
            'Mid Devon District Council',
            'Guildford Borough Council',
            'Mid Suffolk District Council',
            'Hambleton District Council',
            'Mid Sussex District Council',
            'Harborough District Council',
            'Mole Valley District Council',
            'Harlow District Council',
            'North Devon District Council',
            'Harrogate Borough Council',
            'North Dorset District Council',
            'Hart District Council',
            'North East Derbyshire District Council',
            'Hastings Borough Council',
            'North Hertfordshire District Council',
            'Havant Borough Council',
            'North Kesteven District Council',
            'Hertsmere Borough Council',
            'North Norfolk District Council',
            'High Peak Borough Council',
            'North West Leicestershire District Council',
            'North Warwickshire Borough Council ',
            'South Holland District Council',
            'New Forest District Council ',
            'South Kesteven District Council',
            'Newark & Sherwood District Council ',
            'South Lakeland District Council',
            'Newcastle-Under-Lyme Borough Council ',
            'South Norfolk District Council',
            'Northampton Borough Council ',
            'South Northamptonshire District Council',
            'Norwich City Council ',
            'South Oxfordshire District Council',
            'Nuneaton & Bedworth Borough Council ',
            'South Ribble Borough Council',
            'Oadby & Wigston Borough Council ',
            'South Somerset District Council',
            'Oxford City Council ',
            'South Staffordshire District Council',
            'Pendle Borough Council ',
            'Scarborough Borough Council',
            'Preston City Council ',
            'Sedgemoor District Council',
            'Purbeck District Council ',
            'Selby District Council',
            'Redditch Borough Council ',
            'Sevenoaks District Council',
            'Reigate & Banstead Borough Council ',
            'Shepway District Council',
            'Ribble Valley Borough Council ',
            'Spelthorne Borough Council',
            'Richmondshire District Council ',
            'St Albans City Council',
            'Rochford District Council ',
            'St Edmundsbury Borough Council',
            'Rossendale Borough Council ',
            'Stafford Borough Council',
            'Rother District Council ',
            'Staffordshire Moorlands District Council',
            'Rugby Borough Council ',
            'Stevenage Borough Council',
            'Runnymede Borough Council ',
            'Stratford on Avon District Council',
            'Rushcliffe Borough Council ',
            'Stroud District Council',
            'Rushmoor Borough Council ',
            'Suffolk Coastal District Council',
            'Ryedale District Council ',
            'Surrey Heath Borough Council',
            'South Buckinghamshire District Council ',
            'Swale Borough Council',
            'South Cambridgeshire District Council ',
            'Tamworth Borough Council',
            'South Derbyshire District Council ',
            'Tandridge District Council',
            'South Hams District Council ',
            'Taunton Deane Borough Council',
            'Teignbridge District Council ',
            'Warwick District Council',
            'Tendring District Council ',
            'Watford Borough Council',
            'Test Valley Borough Council ',
            'Waveney District Council',
            'Tewkesbury Borough Council ',
            'Waverley Borough Council',
            'Thanet District Council ',
            'Wealden District Council',
            'Three Rivers District Council ',
            'Wellingborough Borough Council',
            'Tonbridge & Malling Borough Council ',
            'Welwyn Hatfield Borough Council',
            'Torridge District Council ',
            'Weymouth & Portland Borough Council',
            'Tunbridge Wells Borough Council ',
            'Winchester City Council',
            'Uttlesford District Council ',
            'Woking Borough Council',
            'Vale of White Horse District Council ',
            'Worcester City Council',
            'West Devon Borough Council ',
            'Worthing Borough Council',
            'West Dorset District Council ',
            'Wychavon District Council',
            'West Lancashire District Council ',
            'Wycombe District Council',
            'West Lindsey District Council ',
            'Wyre Borough Council',
            'West Oxfordshire District Council ',
            'Wyre Forest District Council',
            'West Somerset District Council'
        ];

        collect(array_merge($metropolitan_districts, $london_boroughs, $unitary_authorities, $county_councils, $district_councils))->each(function ($authority) {
            $localAuthority = new LocalAuthority();
            $localAuthority->name = $authority;
            $localAuthority->save();
        });
    }
}

The source data for this list:

https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/491463/List_of_councils_in_England.pdf