API Raw Data for Teams:

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

All teams successfully matched!

Teams Successfully Matched from API:

Normalized NameRecordRank
ARSENAL6-1-11
SUNDERLAND5-2-22
MAN CITY5-1-23
MAN UNITED5-1-34
BOURNEMOUTH4-3-15
LIVERPOOL5-0-46
TOTTENHAM4-2-27
CHELSEA4-2-38
CRYSTAL PAL3-4-19
BRENTFORD4-1-410
NEWCASTLE3-3-311
ASTON VILLA3-3-212
BRIGHTON3-3-313
EVERTON3-2-314
LEEDS UNITED3-2-415
FULHAM2-2-516
BURNLEY2-1-517
NOTTM FOREST1-2-518
WEST HAM1-1-719
WOLVES0-2-620

Database Updates:

Team NameRecord (W-D-L)RankRedGreenBlueSQL QueryStatus
LIVERPOOL5-0-46200016046UPDATE leader_board SET current_team = 'LIVERPOOL', winLossRecord = '5-0-4', Abbrev = 'LIV', Red = 200, Green = 16, Blue = 46, team_rank = 6 WHERE unique_count = 6000;Query executed successfully. (unique_count: 6000)
ARSENAL6-1-11239001007UPDATE leader_board SET current_team = 'ARSENAL', winLossRecord = '6-1-1', Abbrev = 'ARS', Red = 239, Green = 1, Blue = 7, team_rank = 1 WHERE unique_count = 6001;Query executed successfully. (unique_count: 6001)
NOTTM FOREST1-2-518229039039UPDATE leader_board SET current_team = 'NOTTM FOREST', winLossRecord = '1-2-5', Abbrev = 'NFO', Red = 229, Green = 39, Blue = 39, team_rank = 18 WHERE unique_count = 6002;Query executed successfully. (unique_count: 6002)
MAN CITY5-1-23108171221UPDATE leader_board SET current_team = 'MAN CITY', winLossRecord = '5-1-2', Abbrev = 'MNC', Red = 108, Green = 171, Blue = 221, team_rank = 3 WHERE unique_count = 6003;Query executed successfully. (unique_count: 6003)
CHELSEA4-2-38003070148UPDATE leader_board SET current_team = 'CHELSEA', winLossRecord = '4-2-3', Abbrev = 'CHE', Red = 3, Green = 70, Blue = 148, team_rank = 8 WHERE unique_count = 6004;Query executed successfully. (unique_count: 6004)
NEWCASTLE3-3-311000000000UPDATE leader_board SET current_team = 'NEWCASTLE', winLossRecord = '3-3-3', Abbrev = 'NEW', Red = 0, Green = 0, Blue = 0, team_rank = 11 WHERE unique_count = 6005;Query executed successfully. (unique_count: 6005)
BOURNEMOUTH4-3-15218041028UPDATE leader_board SET current_team = 'BOURNEMOUTH', winLossRecord = '4-3-1', Abbrev = 'BOU', Red = 218, Green = 41, Blue = 28, team_rank = 5 WHERE unique_count = 6006;Query executed successfully. (unique_count: 6006)
BRIGHTON3-3-313000087184UPDATE leader_board SET current_team = 'BRIGHTON', winLossRecord = '3-3-3', Abbrev = 'BHA', Red = 0, Green = 87, Blue = 184, team_rank = 13 WHERE unique_count = 6007;Query executed successfully. (unique_count: 6007)
FULHAM2-2-516255255255UPDATE leader_board SET current_team = 'FULHAM', winLossRecord = '2-2-5', Abbrev = 'FUL', Red = 255, Green = 255, Blue = 255, team_rank = 16 WHERE unique_count = 6008;Query executed successfully. (unique_count: 6008)
ASTON VILLA3-3-212149191229UPDATE leader_board SET current_team = 'ASTON VILLA', winLossRecord = '3-3-2', Abbrev = 'AVL', Red = 149, Green = 191, Blue = 229, team_rank = 12 WHERE unique_count = 6009;Query executed successfully. (unique_count: 6009)
BRENTFORD4-1-410227006019UPDATE leader_board SET current_team = 'BRENTFORD', winLossRecord = '4-1-4', Abbrev = 'BRE', Red = 227, Green = 6, Blue = 19, team_rank = 10 WHERE unique_count = 6010;Query executed successfully. (unique_count: 6010)
CRYSTAL PAL3-4-19026013171UPDATE leader_board SET current_team = 'CRYSTAL PAL', winLossRecord = '3-4-1', Abbrev = 'CRY', Red = 26, Green = 13, Blue = 171, team_rank = 9 WHERE unique_count = 6011;Query executed successfully. (unique_count: 6011)
TOTTENHAM4-2-27019034087UPDATE leader_board SET current_team = 'TOTTENHAM', winLossRecord = '4-2-2', Abbrev = 'TOT', Red = 19, Green = 34, Blue = 87, team_rank = 7 WHERE unique_count = 6012;Query executed successfully. (unique_count: 6012)
MAN UNITED5-1-34218041028UPDATE leader_board SET current_team = 'MAN UNITED', winLossRecord = '5-1-3', Abbrev = 'MAN', Red = 218, Green = 41, Blue = 28, team_rank = 4 WHERE unique_count = 6013;Query executed successfully. (unique_count: 6013)
WEST HAM1-1-719122038058UPDATE leader_board SET current_team = 'WEST HAM', winLossRecord = '1-1-7', Abbrev = 'WHU', Red = 122, Green = 38, Blue = 58, team_rank = 19 WHERE unique_count = 6014;Query executed successfully. (unique_count: 6014)
EVERTON3-2-314039068136UPDATE leader_board SET current_team = 'EVERTON', winLossRecord = '3-2-3', Abbrev = 'EVE', Red = 39, Green = 68, Blue = 136, team_rank = 14 WHERE unique_count = 6015;Query executed successfully. (unique_count: 6015)
WOLVES0-2-620253185019UPDATE leader_board SET current_team = 'WOLVES', winLossRecord = '0-2-6', Abbrev = 'WOL', Red = 253, Green = 185, Blue = 19, team_rank = 20 WHERE unique_count = 6016;Query executed successfully. (unique_count: 6016)
BURNLEY2-1-517108035069UPDATE leader_board SET current_team = 'BURNLEY', winLossRecord = '2-1-5', Abbrev = 'BUR', Red = 108, Green = 35, Blue = 69, team_rank = 17 WHERE unique_count = 6020;Query executed successfully. (unique_count: 6020)
LEEDS UNITED3-2-415255205000UPDATE leader_board SET current_team = 'LEEDS UNITED', winLossRecord = '3-2-4', Abbrev = 'LEE', Red = 255, Green = 205, Blue = 0, team_rank = 15 WHERE unique_count = 6021;Query executed successfully. (unique_count: 6021)
SUNDERLAND5-2-22211008023UPDATE leader_board SET current_team = 'SUNDERLAND', winLossRecord = '5-2-2', Abbrev = 'SUN', Red = 211, Green = 8, Blue = 23, team_rank = 2 WHERE unique_count = 6022;Query executed successfully. (unique_count: 6022)