API Raw Data for Teams:

DEBUG: Forced Brighton correction: BRIGHTON HOVE ALBION -> BRIGHTON
API TeamNormalizedAfter CorrectionIn team_colors
ArsenalARSENALARSENALYes
Manchester CityMANCHESTER CITYMAN CITYYes
Aston VillaASTON VILLAASTON VILLAYes
ChelseaCHELSEACHELSEAYes
Crystal PalaceCRYSTAL PALACECRYSTAL PALYes
Manchester UnitedMANCHESTER UNITEDMAN UNITEDYes
LiverpoolLIVERPOOLLIVERPOOLYes
SunderlandSUNDERLANDSUNDERLANDYes
EvertonEVERTONEVERTONYes
Brighton & Hove AlbionBRIGHTON HOVE ALBIONBRIGHTONYes
Tottenham HotspurTOTTENHAM HOTSPURTOTTENHAMYes
Newcastle UnitedNEWCASTLE UNITEDNEWCASTLEYes
AFC BournemouthAFC BOURNEMOUTHBOURNEMOUTHYes
FulhamFULHAMFULHAMYes
BrentfordBRENTFORDBRENTFORDYes
Nottingham ForestNOTTINGHAM FORESTNOTTM FORESTYes
Leeds UnitedLEEDS UNITEDLEEDS UNITEDYes
West Ham UnitedWEST HAM UNITEDWEST HAMYes
BurnleyBURNLEYBURNLEYYes
Wolverhampton WanderersWOLVERHAMPTON WANDERERSWOLVESYes

All teams successfully matched!

Teams Successfully Matched from API:

Normalized NameRecordRank
ARSENAL11-3-21
MAN CITY11-1-42
ASTON VILLA10-3-33
CHELSEA8-4-44
CRYSTAL PAL7-5-45
MAN UNITED7-5-46
LIVERPOOL8-2-67
SUNDERLAND7-5-48
EVERTON7-3-69
BRIGHTON6-5-510
TOTTENHAM6-4-611
NEWCASTLE6-4-612
BOURNEMOUTH5-6-513
FULHAM6-2-814
BRENTFORD6-2-815
NOTTM FOREST5-3-816
LEEDS UNITED4-4-817
WEST HAM3-4-918
BURNLEY3-1-1219
WOLVES0-2-1420

Database Updates:

Team NameRecord (W-D-L)RankRedGreenBlueSQL QueryStatus
LIVERPOOL8-2-67200016046UPDATE leader_board SET current_team = 'LIVERPOOL', winLossRecord = '8-2-6', Abbrev = 'LIV', Red = 200, Green = 16, Blue = 46, team_rank = 7 WHERE unique_count = 6000;Query executed successfully. (unique_count: 6000)
ARSENAL11-3-21239001007UPDATE leader_board SET current_team = 'ARSENAL', winLossRecord = '11-3-2', Abbrev = 'ARS', Red = 239, Green = 1, Blue = 7, team_rank = 1 WHERE unique_count = 6001;Query executed successfully. (unique_count: 6001)
NOTTM FOREST5-3-816229039039UPDATE leader_board SET current_team = 'NOTTM FOREST', winLossRecord = '5-3-8', Abbrev = 'NFO', Red = 229, Green = 39, Blue = 39, team_rank = 16 WHERE unique_count = 6002;Query executed successfully. (unique_count: 6002)
MAN CITY11-1-42108171221UPDATE leader_board SET current_team = 'MAN CITY', winLossRecord = '11-1-4', Abbrev = 'MNC', Red = 108, Green = 171, Blue = 221, team_rank = 2 WHERE unique_count = 6003;Query executed successfully. (unique_count: 6003)
CHELSEA8-4-44003070148UPDATE leader_board SET current_team = 'CHELSEA', winLossRecord = '8-4-4', Abbrev = 'CHE', Red = 3, Green = 70, Blue = 148, team_rank = 4 WHERE unique_count = 6004;Query executed successfully. (unique_count: 6004)
NEWCASTLE6-4-612000000000UPDATE leader_board SET current_team = 'NEWCASTLE', winLossRecord = '6-4-6', Abbrev = 'NEW', Red = 0, Green = 0, Blue = 0, team_rank = 12 WHERE unique_count = 6005;Query executed successfully. (unique_count: 6005)
BOURNEMOUTH5-6-513218041028UPDATE leader_board SET current_team = 'BOURNEMOUTH', winLossRecord = '5-6-5', Abbrev = 'BOU', Red = 218, Green = 41, Blue = 28, team_rank = 13 WHERE unique_count = 6006;Query executed successfully. (unique_count: 6006)
BRIGHTON6-5-510000087184UPDATE leader_board SET current_team = 'BRIGHTON', winLossRecord = '6-5-5', Abbrev = 'BHA', Red = 0, Green = 87, Blue = 184, team_rank = 10 WHERE unique_count = 6007;Query executed successfully. (unique_count: 6007)
FULHAM6-2-814255255255UPDATE leader_board SET current_team = 'FULHAM', winLossRecord = '6-2-8', Abbrev = 'FUL', Red = 255, Green = 255, Blue = 255, team_rank = 14 WHERE unique_count = 6008;Query executed successfully. (unique_count: 6008)
ASTON VILLA10-3-33149191229UPDATE leader_board SET current_team = 'ASTON VILLA', winLossRecord = '10-3-3', Abbrev = 'AVL', Red = 149, Green = 191, Blue = 229, team_rank = 3 WHERE unique_count = 6009;Query executed successfully. (unique_count: 6009)
BRENTFORD6-2-815227006019UPDATE leader_board SET current_team = 'BRENTFORD', winLossRecord = '6-2-8', Abbrev = 'BRE', Red = 227, Green = 6, Blue = 19, team_rank = 15 WHERE unique_count = 6010;Query executed successfully. (unique_count: 6010)
CRYSTAL PAL7-5-45026013171UPDATE leader_board SET current_team = 'CRYSTAL PAL', winLossRecord = '7-5-4', Abbrev = 'CRY', Red = 26, Green = 13, Blue = 171, team_rank = 5 WHERE unique_count = 6011;Query executed successfully. (unique_count: 6011)
TOTTENHAM6-4-611019034087UPDATE leader_board SET current_team = 'TOTTENHAM', winLossRecord = '6-4-6', Abbrev = 'TOT', Red = 19, Green = 34, Blue = 87, team_rank = 11 WHERE unique_count = 6012;Query executed successfully. (unique_count: 6012)
MAN UNITED7-5-46218041028UPDATE leader_board SET current_team = 'MAN UNITED', winLossRecord = '7-5-4', Abbrev = 'MAN', Red = 218, Green = 41, Blue = 28, team_rank = 6 WHERE unique_count = 6013;Query executed successfully. (unique_count: 6013)
WEST HAM3-4-918122038058UPDATE leader_board SET current_team = 'WEST HAM', winLossRecord = '3-4-9', Abbrev = 'WHU', Red = 122, Green = 38, Blue = 58, team_rank = 18 WHERE unique_count = 6014;Query executed successfully. (unique_count: 6014)
EVERTON7-3-69039068136UPDATE leader_board SET current_team = 'EVERTON', winLossRecord = '7-3-6', Abbrev = 'EVE', Red = 39, Green = 68, Blue = 136, team_rank = 9 WHERE unique_count = 6015;Query executed successfully. (unique_count: 6015)
WOLVES0-2-1420253185019UPDATE leader_board SET current_team = 'WOLVES', winLossRecord = '0-2-14', Abbrev = 'WOL', Red = 253, Green = 185, Blue = 19, team_rank = 20 WHERE unique_count = 6016;Query executed successfully. (unique_count: 6016)
BURNLEY3-1-1219108035069UPDATE leader_board SET current_team = 'BURNLEY', winLossRecord = '3-1-12', Abbrev = 'BUR', Red = 108, Green = 35, Blue = 69, team_rank = 19 WHERE unique_count = 6020;Query executed successfully. (unique_count: 6020)
LEEDS UNITED4-4-817255205000UPDATE leader_board SET current_team = 'LEEDS UNITED', winLossRecord = '4-4-8', Abbrev = 'LEE', Red = 255, Green = 205, Blue = 0, team_rank = 17 WHERE unique_count = 6021;Query executed successfully. (unique_count: 6021)
SUNDERLAND7-5-48211008023UPDATE leader_board SET current_team = 'SUNDERLAND', winLossRecord = '7-5-4', Abbrev = 'SUN', Red = 211, Green = 8, Blue = 23, team_rank = 8 WHERE unique_count = 6022;Query executed successfully. (unique_count: 6022)