Web design and hosting, database, cloud and social media solutions that deliver business results
  • Business Solutions
    • Robotic Process Automation
    • Bespoke Software
    • Database Services
      • Data Integration
      • Datawarehouse Services
      • Power BI
      • Server Upgrade and DBA Services
    • Web Services
      • Logo Design
      • Payment Gateways
      • Web Localisation and Translation
      • Web Site Optimisation
      • Web Site Security
      • Technical Tools
    • Cloud Services
      • Amazon Web Services
      • Google Cloud Services
      • Microsoft Azure
    • Microsoft 365
      • Enabling the Multi Factor Authentication Application
      • Office 365 DNS Settings Generator
    • IT Hardware
    • Social Media Services
  • Academy
    • Our Test Environment
    • Learning Databases
      • The Basics
      • Get Open Query
      • SQL Server Data
      • SQL Server Maintenance
      • Using SQL Server Dates
      • Using SQL Server Functions
      • Using SQL Server Pivot-Unpivot
      • Technical Tools
    • Learning Web Design
      • Building Ousia Content Management System
      • Using ASP-NET
      • Using CSS
      • Using JavaScript
    • Learning Cloud and IT Services
      • Task Scheduler Error 2147943645
      • Blocking Blank Senders
      • Requesting SSL and Generation of PFX file in OpenSSL Simple Steps
    • Using Social Media
      • Asking for a Google Review
      • Changing a Facebook account from personal to business
      • Choosing where to focus Social Media effort
      • Social Media Image Sizes
      • Using Meta Data to set Social Media Images
  • About
    • Blog
      • Building an entry level gaming machine
      • Google Core Update Jan 2020
      • Hot Chilli Internet Closure
      • How To Choose Content For Your Website Adverts Leaflets
      • Preventing Online Scam
      • Skimmers of the gig economy
      • The most annoying things about websites on the Internet
      • Top 5 websites for free Vector Graphics
    • Careers
      • Translator English-Japanese
      • Translator English-Portuguese
      • Translator English-Spanish
      • Translator English-Turkish
    • Portfolio
    • Regulatory
    • Team
      • Chester Copperpot
      • Gavin Clayton
      • Sai Gangu
      • Suneel Kumar
      • Surya Mukkamala
عربى (AR)čeština (CS)Deutsch (DE)English (EN-US)English (EN-GB)Español (ES)فارسی (FA)Français (FR)हिंदी (HI)italiano (IT)日本語 (JA)polski (PL)Português (PT)русский (RU)Türk (TR)中国的 (ZH)

Calculate the distance between two latitude/longitude coordinates in SQL Server

Create an SQL function that calculates the distance between latitude/longitude coordinates in either miles or kilometers, and tested with football club stadiums

Context

Using SQL Server Distance.png

Calculating the distance between two places can be quite tricky, there are some good articles out there, however this page will only go into the code. 

For more information on how it distances are calculated on a sphere, have a look at Haversine Formula on Wikipedia, it's a bit complex, hence us not wanting to duplicate the content.

We found some of this code online and have adapted it to an SQL Function, with the ability to ask for miles or kilometres.

This only calculates "as the crow flies", however it was tested as part of an app we'd built on an IPhone and the distances were spot on.

We've also included an example for English football team distances at the bottom.

SQL Server

CREATE FUNCTION CoordinateDistanceMiles(@Latitude1 float,@Longitude1 float,@Latitude2 float,@Longitude2 float,@Distance NVARCHAR(10))RETURNS FLOATAS BEGIN-- CONSTANTSDECLARE @EarthRadiusInMiles FLOAT=(CASE @Distance WHEN 'Miles' THEN 3959 WHEN 'Kilometers' THEN 6371 ELSE 0 END);DECLARE @PI FLOAT=PI();DECLARE @lat1Radians FLOAT=@Latitude1 * @PI / 180DECLARE @long1Radians FLOAT=@Longitude1 * @PI / 180;DECLARE @lat2Radians FLOAT=@Latitude2 * @PI / 180;DECLARE @long2Radians FLOAT=@Longitude2 * @PI / 180;RETURN Acos(Cos(@lat1Radians)*Cos(@long1Radians)*Cos(@lat2Radians)*Cos(@long2Radians)+Cos(@lat1Radians)*Sin(@long1Radians)*Cos(@lat2Radians)*Sin(@long2Radians)+Sin(@lat1Radians)*Sin(@lat2Radians)) * @EarthRadiusInMiles;END

Practical Example

It's always easier to visualise data with an example we can comprehend, so I've taken all of the English league football clubs for 2022-2023, and sourced their ground locations (if they haven't moved in a couple of seasons).

What we will do is then use this data to work out how far each club has to travel (as the crow flies).

Create Data Set

CREATE TABLE Club(ClubName NVARCHAR(100),ClubStadium NVARCHAR(100),ClubLeague NVARCHAR(100),ClubLon float,ClubLat float)GO--Season 22/23INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Arsenal','Emirates Stadium','EPL',-0.108436,51.554901INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Aston Villa','Villa Park','EPL',-1.88508,52.509201INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Bournemouth','Seward Stadium','EPL',-1.83839,50.735199INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Brentford','Griffin Park','EPL',-0.302621,51.488201INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Brighton and Hove Albion','Amex Stadium','EPL',-0.08014,50.860901INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Chelsea','Stamford Bridge','EPL',-0.191034,51.481602INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Crystal Palace','Selhurst Park','EPL',-0.085455,51.3983INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Everton','Goodison Park','EPL',-2.96619,53.438702INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Fulham','Craven Cottage','EPL',-0.221619,51.474899INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Leeds United','Elland Road','EPL',-1.57212,53.7775INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Leicester City','King Power Stadium','EPL',-1.14217,52.6203INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Liverpool','Anfield','EPL',-2.96096,53.430801INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Manchester City','Etihad Stadium','EPL',-2.20024,53.483002INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Manchester United','Old Trafford','EPL',-2.29139,53.4631INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Newcastle United','St James Park','EPL',-1.62179,54.975601INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Nottingham Forest','The City Ground','EPL',-1.13258,52.939899INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Southampton','St Mary''s Stadium','EPL',-1.39114,50.9058INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Tottenham Hotspur','Tottenham Hotspur Stadium','EPL',-0.066389,51.604401INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'West Ham','London Stadium','EPL',-0.016587,51.5383INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Wolverhampton Wanderers','Molineux','EPL',-2.13061,52.590401INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Birmingham City','St Andrews','CHP',-1.86824,52.475601INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Blackburn Rovers','Ewood Park','CHP',-2.48937,53.7286INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Blackpool','Bloomfield Road','CHP',-3.04834,53.8046INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Bristol City','Ashton Gate','CHP',-2.62021,51.439999INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Cardiff City','Cardiff City Stadium','CHP',-3.20413,51.4729INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Coventry City','Ricoh Arena','CHP',-1.49563,52.448101INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Huddersfield Town','The Galpharm Stadium','CHP',-1.76837,53.654301INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Hull City','KC Stadium','CHP',-0.368009,53.746498INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Luton Town','Kenilworth Road','CHP',-0.43155,51.884201INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Middlesbrough','Riverside','CHP',-1.21776,54.578098INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Millwall','The Den','CHP',-0.050743,51.485901INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Norwich City','Carrow Road','CHP',1.30912,52.622101INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Preston North End','Deepdale','CHP',-2.68832,53.771999INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Queens Park Rangers','Loftus Road','CHP',-0.232204,51.5093INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Reading','Madjeski Stadium','CHP',-0.982777,51.422199INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Rotherham United','New York Stadium','CHP',-1.36172,53.428101INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Sheffield United','Bramall Lane','CHP',-1.47083,53.3703INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Stoke City','Britannia Stadium','CHP',-2.17542,52.9884INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Sunderland','Stadium of Light','CHP',-1.38837,54.9146INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Swansea City','Liberty Stadium','CHP',-3.93473,51.642799INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Watford','Vicarage Road','CHP',-0.401569,51.649799INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'West Bromwich Albion','The Hawthorns','CHP',-1.96418,52.508999INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Wigan Athletic','DW Stadium','CHP',-2.65415,53.547699INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Burnley','Turf Moor','CHP',-2.23018,53.788799INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Accrington Stanley','Crown Ground','L1',-2.37106,53.7654INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Barnsley','Oakwell','L1',-1.46756,53.552399INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Bolton Wanderers','University of Bolton Stadium','L1',-2.53571,53.580502INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Bristol Rovers','Memorial Stadium','L1',-2.58315,51.486198INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Burton Albion','Pirelli Stadium','L1',-1.62708,52.821899INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Cambridge United','Abbey Stadium','L1',0.154298,52.212799INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Charlton Athletic','The Valley','L1',0.036757,51.4865INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Cheltenham Town','Whaddon Road','L1',-2.06021,51.9062INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Derby County','Pride Park','L1',-1.44727,52.914902INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Exeter City','St James Park, Exeter','L1',-3.52109,50.730701INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Fleetwood Town','Highbury Stadium','L1',-3.02484,53.9165INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Ipswich Town','Portman Road','L1',1.14554,52.054401INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'MK Dons','Stadiummk','L1',-0.733507,52.009602INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Morecambe','Globe Arena','L1',-2.84707,54.067501INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Oxford United','Kassam Stadium','L1',-1.20775,51.7164INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Peterborough United','London Road','L1',-0.240434,52.5648INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Plymouth Argyle','Home Park','L1',-4.15076,50.388199INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Port Vale','Vale Park','L1',-2.1926,53.049999INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Portsmouth','Fratton Park','L1',-1.06389,50.796398INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Sheffield Wednesday','Hillsborough','L1',-1.50075,53.411499INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Shrewsbury Town','New Meadow','L1',-2.74931,52.688599INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Wycombe Wanderers','Adams Park','L1',-0.800299,51.6306INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Lincoln City FC','Sincil Bank','L1',-0.540811,53.218289INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Forrest Green Rovers','The New Lawn','L1',-2.237892,51.698975INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'AFC Wimbledon','Plough Lane','L2',-0.186736,51.4314INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Bradford City','Valley Parade','L2',-1.75902,53.804199INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Carlisle United','Brunton Park','L2',-2.91365,54.8955INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Colchester United','Weston Homes Community Stadium','L2',0.897861,51.923401INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Crawley Town','Broadfield Stadium','L2',-0.194579,51.099602INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Crewe Alexandra','Alexandra Stadium','L2',-2.43569,53.087502INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Doncaster Rovers','Keepmoat Stadium','L2',-1.11382,53.509899INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Gillingham','Priestfield Stadium','L2',0.560367,51.384399INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Hartlepool United','Victoria Park','L2',-1.21274,54.689098INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Leyton Orient','Brisbane Road','L2',-0.012551,51.560101INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Mansfield Town','Field Mill','L2',-1.2013,53.137798INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Newport County','Rodney Parade','L2',-2.98902,51.588902INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Northampton Town','Sixfields Stadium','L2',-0.933485,52.235199INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Rochdale','Spotland Stadium','L2',-2.17993,53.620899INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Stevenage Borough','The Lamex Stadium','L2',-0.193664,51.889801INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Swindon Town','The County Ground','L2',-1.77107,51.564499INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Tranmere Rovers','Prenton Park','L2',-3.03269,53.373798INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Walsall','Bescot Stadium','L2',-1.99053,52.565498INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Stockport County','Edgeley Park','L2',-2.166389,53.399722INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Salford City','The Peninsula Stadium','L2',-2.276775,53.513631INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Barrow','Holker Street','L2',-3.235,54.123333INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Grimsby Town','Blundell Park','L2',-0.046497,53.570225INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Sutton Utd','Gander Green Lane','L2',-0.204444,51.3675INSERT INTO Club(ClubName,ClubStadium,ClubLeague,ClubLon,ClubLat) SELECT 'Harrogate Town','Wetherby Road','L2',-1.514444,53.991667

Get the data

To compare all of the data, we will need to use a full outer join where the clubs are in the same league, but not the same team as being tested.

There are two examples below, one with all of the data, the second ordered by distance.

SQL Statement

SELECT *,dbo.CoordinateDistanceMiles(Home.ClubLat,Home.ClubLon,Away.ClubLat,Away.ClubLon,'Miles') DistanceFROM Club HomeFULL OUTER JOIN Club Away ON Away.ClubLeague=Home.ClubLeague AND Away.ClubName<>Home.ClubNameGOSELECT Home.ClubName,Home.ClubLeague,SUM(dbo.CoordinateDistanceMiles(Home.ClubLat,Home.ClubLon,Away.ClubLat,Away.ClubLon,'Miles')) DistanceFROM Club HomeFULL OUTER JOIN Club Away ON Away.ClubLeague=Home.ClubLeague AND Away.ClubName<>Home.ClubNameGROUP BY Home.ClubName,Home.ClubLeagueORDER BY Distance DESCGO

Results

ClubNameClubLeagueDistance
Plymouth ArgyleL14453.891898
Carlisle UnitedL23920.227433
Newcastle UnitedEPL3776.541427
Exeter CityL13715.99945
SunderlandCHP3644.164045
Swansea CityCHP3475.832002
Norwich CityCHP3442.73664
Hartlepool UnitedL23412.083145
Ipswich TownL13286.248793
GillinghamL23256.55143
Crawley TownL23255.519895
Newport CountyL23246.542226
MorecambeL13214.327594
MiddlesbroughCHP3195.794382
Cardiff CityCHP3194.984001
BarrowL23169.301103
PortsmouthL13164.602876
Colchester UnitedL23108.978503
Fleetwood TownL13107.92468
MillwallCHP3068.132637
Bristol CityCHP2993.14002
Queens Park RangersCHP2953.272006
Sutton UtdL22919.397634
AFC WimbledonL22857.466638
ReadingCHP2851.657641
Charlton AthleticL12804.304527
Leyton OrientL22803.121651
Swindon TownL22777.087032
WatfordCHP2751.641527
Accrington StanleyL12706.621788
Grimsby TownL22653.709805
Hull CityCHP2626.05698
BlackpoolCHP2603.613716
Tranmere RoversL22571.050739
Bolton WanderersL12570.104312
Luton TownCHP2569.24322
Bristol RoversL12552.672957
BournemouthEPL2545.352842
Stevenage BoroughL22532.233764
Harrogate TownL22525.401762
Cambridge UnitedL12503.262907
BarnsleyL12424.322492
Lincoln City FCL12414.584664
EvertonEPL2413.638857
LiverpoolEPL2406.098352
Leeds UnitedEPL2388.966341
Preston North EndCHP2388.594402
Brighton and Hove AlbionEPL2353.597824
Bradford CityL22345.305022
Wycombe WanderersL12319.525351
Sheffield WednesdayL12285.827092
Blackburn RoversCHP2279.946168
Peterborough UnitedL12275.129343
Forrest Green RoversL12272.180646
RochdaleL22269.709171
BurnleyCHP2269.154887
SouthamptonEPL2267.113675
Wigan AthleticCHP2239.711761
Salford CityL22236.227994
Shrewsbury TownL12231.568891
Northampton TownL22225.119602
Crewe AlexandraL22214.580466
Doncaster RoversL22205.59141
Manchester UnitedEPL2180.361561
Oxford UnitedL12176.359243
WalsallL22176.074434
Manchester CityEPL2174.695176
Stockport CountyL22159.802133
Huddersfield TownCHP2135.335073
MK DonsL12125.685235
Cheltenham TownL12110.792339
Port ValeL12110.332034
Mansfield TownL22064.237747
Rotherham UnitedCHP2049.048018
Coventry CityCHP2021.327189
West Bromwich AlbionCHP2008.167317
Birmingham CityCHP2007.252312
Sheffield UnitedCHP2005.506378
Derby CountyL11980.135074
Stoke CityCHP1975.299586
Burton AlbionL11944.681918
Crystal PalaceEPL1835.178138
Nottingham ForestEPL1801.300209
Wolverhampton WanderersEPL1799.949048
West HamEPL1785.365723
Tottenham HotspurEPL1750.095838
ChelseaEPL1744.793609
FulhamEPL1742.072913
ArsenalEPL1741.906394
BrentfordEPL1727.724925
Aston VillaEPL1723.783674
Leicester CityEPL1678.459261

Author

Was this helpful?

Please note, this commenting system is still in final testing.
Copyright Claytabase Ltd 2020

Registered in England and Wales 08985867

Site Links

RSSLoginLink Cookie PolicySitemap

Social Media

facebook.com/Claytabaseinstagram.com/claytabase/twitter.com/Claytabaselinkedin.com/company/claytabase-ltd

Get in Touch

+442392064871info@claytabase.co.ukClaytabase Ltd, Unit 3d, Rink Road Industrial Estate, PO33 2LT, United Kingdom

Partnered With

The settings on this site are set to allow all cookies. These can be changed on our Cookie Policy & Settings page.
By continuing to use this site you agree to the use of cookies.
Ousia Logo
Logout
Ousia CMS Loader