elo_record
68 rows where team_id = 235
This data as json, CSV (advanced)
Suggested facets: is_tournament, competition_id, date (date), created_at (date), updated_at (date)
| elo_id ▼ | team_id | date | rating | k_factor | delta | source_match_id | is_tournament | competition_id | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34421 | Saint Martin 235 | 1990-03-24 | 1520.8565764864145 | 40.0 | 20.856576486414497 | 17211 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:38 | 2026-06-07 07:00:38 | 1 | International Results CSV 1 | elo://17211/home | |
| 34519 | Saint Martin 235 | 1990-05-06 | 1539.5876509996365 | 40.0 | 18.731074513221984 | 17260 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:38 | 2026-06-07 07:00:38 | 1 | International Results CSV 1 | elo://17260/home | |
| 34562 | Saint Martin 235 | 1990-05-20 | 1513.2563899303643 | 40.0 | -26.33126106927216 | 17281 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:38 | 2026-06-07 07:00:38 | 1 | International Results CSV 1 | elo://17281/away | |
| 43824 | Saint Martin 235 | 1997-04-28 | 1488.6782015732786 | 40.0 | -24.578188357085764 | 21912 | 0 | Friendly 8 | 2026-06-07 07:00:45 | 2026-06-07 07:00:45 | 1 | International Results CSV 1 | elo://21912/away | |
| 50371 | Saint Martin 235 | 2001-02-06 | 1500.0873591500595 | 40.0 | 11.409157576780899 | 25186 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:50 | 2026-06-07 07:00:50 | 1 | International Results CSV 1 | elo://25186/home | |
| 50395 | Saint Martin 235 | 2001-02-10 | 1506.9863665815526 | 40.0 | 6.899007431493146 | 25198 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:50 | 2026-06-07 07:00:50 | 1 | International Results CSV 1 | elo://25198/home | |
| 50792 | Saint Martin 235 | 2001-04-04 | 1476.5967875789781 | 40.0 | -30.389579002574465 | 25396 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:51 | 2026-06-07 07:00:51 | 1 | International Results CSV 1 | elo://25396/away | |
| 50802 | Saint Martin 235 | 2001-04-06 | 1459.245218530516 | 40.0 | -17.351569048462125 | 25401 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:51 | 2026-06-07 07:00:51 | 1 | International Results CSV 1 | elo://25401/away | |
| 50826 | Saint Martin 235 | 2001-04-08 | 1470.3896101638788 | 40.0 | 11.14439163336283 | 25413 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:51 | 2026-06-07 07:00:51 | 1 | International Results CSV 1 | elo://25413/away | |
| 52911 | Saint Martin 235 | 2002-06-06 | 1478.070361512135 | 40.0 | 7.680751348256081 | 26456 | 0 | Friendly 8 | 2026-06-07 07:00:52 | 2026-06-07 07:00:52 | 1 | International Results CSV 1 | elo://26456/home | |
| 53001 | Saint Martin 235 | 2002-06-23 | 1485.2172256041856 | 40.0 | 7.146864092050691 | 26501 | 0 | Friendly 8 | 2026-06-07 07:00:53 | 2026-06-07 07:00:53 | 1 | International Results CSV 1 | elo://26501/home | |
| 53028 | Saint Martin 235 | 2002-07-06 | 1463.5204380440798 | 40.0 | -21.696787560105804 | 26514 | 1 | Gold Cup qualification 129 | 2026-06-07 07:00:53 | 2026-06-07 07:00:53 | 1 | International Results CSV 1 | elo://26514/away | |
| 53113 | Saint Martin 235 | 2002-08-04 | 1443.735147823337 | 40.0 | -19.78529022074281 | 26557 | 1 | Gold Cup qualification 129 | 2026-06-07 07:00:53 | 2026-06-07 07:00:53 | 1 | International Results CSV 1 | elo://26557/home | |
| 57644 | Saint Martin 235 | 2004-11-24 | 1434.225783836674 | 40.0 | -9.509363986662947 | 28822 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:56 | 2026-06-07 07:00:56 | 1 | International Results CSV 1 | elo://28822/away | |
| 57653 | Saint Martin 235 | 2004-11-26 | 1419.8854889231345 | 40.0 | -14.340294913539537 | 28827 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:56 | 2026-06-07 07:00:56 | 1 | International Results CSV 1 | elo://28827/home | |
| 57670 | Saint Martin 235 | 2004-11-28 | 1409.5495991259968 | 40.0 | -10.335889797137725 | 28835 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:56 | 2026-06-07 07:00:56 | 1 | International Results CSV 1 | elo://28835/away | |
| 59656 | Saint Martin 235 | 2006-02-25 | 1391.5402374623152 | 40.0 | -18.009361663681602 | 29828 | 0 | Friendly 8 | 2026-06-07 07:00:58 | 2026-06-07 07:00:58 | 1 | International Results CSV 1 | elo://29828/away | |
| 60604 | Saint Martin 235 | 2006-09-20 | 1377.1702700561777 | 40.0 | -14.369967406137448 | 30302 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:59 | 2026-06-07 07:00:59 | 1 | International Results CSV 1 | elo://30302/away | |
| 60612 | Saint Martin 235 | 2006-09-22 | 1364.307102743356 | 40.0 | -12.863167312821815 | 30306 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:59 | 2026-06-07 07:00:59 | 1 | International Results CSV 1 | elo://30306/away | |
| 60618 | Saint Martin 235 | 2006-09-24 | 1356.4519706334524 | 40.0 | -7.855132109903479 | 30309 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:00:59 | 2026-06-07 07:00:59 | 1 | International Results CSV 1 | elo://30309/away | |
| 62849 | Saint Martin 235 | 2007-11-11 | 1331.0977521422353 | 40.0 | -25.354218491217125 | 31425 | 0 | Friendly 8 | 2026-06-07 07:01:00 | 2026-06-07 07:01:00 | 1 | International Results CSV 1 | elo://31425/home | |
| 64528 | Saint Martin 235 | 2008-08-27 | 1307.8520258079102 | 40.0 | -23.245726334325127 | 32264 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:02 | 2026-06-07 07:01:02 | 1 | International Results CSV 1 | elo://32264/away | |
| 64541 | Saint Martin 235 | 2008-08-30 | 1291.74976677971 | 40.0 | -16.10225902820025 | 32271 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:02 | 2026-06-07 07:01:02 | 1 | International Results CSV 1 | elo://32271/home | |
| 64546 | Saint Martin 235 | 2008-08-31 | 1276.5323835489733 | 40.0 | -15.217383230736687 | 32273 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:02 | 2026-06-07 07:01:02 | 1 | International Results CSV 1 | elo://32273/away | |
| 67865 | Saint Martin 235 | 2010-07-03 | 1307.8737573983158 | 40.0 | 31.341373849342517 | 33933 | 0 | Friendly 8 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://33933/home | |
| 67882 | Saint Martin 235 | 2010-08-08 | 1319.300757859242 | 40.0 | 11.427000460926138 | 33941 | 0 | Friendly 8 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://33941/away | |
| 68225 | Saint Martin 235 | 2010-09-19 | 1335.2927770362387 | 40.0 | 15.992019176996791 | 34113 | 0 | Friendly 8 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://34113/home | |
| 68285 | Saint Martin 235 | 2010-10-01 | 1331.6617812736379 | 40.0 | -3.6309957626008327 | 34143 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://34143/home | |
| 68300 | Saint Martin 235 | 2010-10-04 | 1309.3837998206527 | 40.0 | -22.27798145298516 | 34150 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://34150/away | |
| 68302 | Saint Martin 235 | 2010-10-06 | 1278.6040617871513 | 40.0 | -30.779738033501417 | 34151 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:05 | 2026-06-07 07:01:05 | 1 | International Results CSV 1 | elo://34151/away | |
| 72290 | Saint Martin 235 | 2012-09-07 | 1269.661726501234 | 40.0 | -8.942335285917352 | 36145 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:08 | 2026-06-07 07:01:08 | 1 | International Results CSV 1 | elo://36145/away | |
| 72366 | Saint Martin 235 | 2012-09-09 | 1254.1134571083967 | 40.0 | -15.548269392837256 | 36183 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:08 | 2026-06-07 07:01:08 | 1 | International Results CSV 1 | elo://36183/away | |
| 72465 | Saint Martin 235 | 2012-09-11 | 1241.7273039850584 | 40.0 | -12.386153123338318 | 36233 | 1 | CFU Caribbean Cup qualification 80 | 2026-06-07 07:01:08 | 2026-06-07 07:01:08 | 1 | International Results CSV 1 | elo://36233/home | |
| 75930 | Saint Martin 235 | 2014-08-16 | 1254.5077186741291 | 40.0 | 12.780414689070767 | 37965 | 0 | Friendly 8 | 2026-06-07 07:02:58.235963 | 2026-06-07 07:02:58.235963 | 1 | International Results CSV 1 | elo://37965/away | |
| 82918 | Saint Martin 235 | 2018-04-29 | 1244.8256813838666 | 40.0 | -9.682037290262542 | 41459 | 0 | Friendly 8 | 2026-06-07 07:02:59.134670 | 2026-06-07 07:02:59.134671 | 1 | International Results CSV 1 | elo://41459/away | |
| 83430 | Saint Martin 235 | 2018-08-25 | 1256.830977657964 | 40.0 | 12.005296274097418 | 41715 | 0 | Friendly 8 | 2026-06-07 07:02:59.184207 | 2026-06-07 07:02:59.184207 | 1 | International Results CSV 1 | elo://41715/away | |
| 83735 | Saint Martin 235 | 2018-09-11 | 1245.1628639570247 | 40.0 | -11.66811370093933 | 41868 | 0 | CONCACAF Nations League qualification 175 | 2026-06-07 07:02:59.213821 | 2026-06-07 07:02:59.213821 | 1 | International Results CSV 1 | elo://41868/home | |
| 83933 | Saint Martin 235 | 2018-10-14 | 1234.8484262385089 | 40.0 | -10.31443771851582 | 41967 | 0 | CONCACAF Nations League qualification 175 | 2026-06-07 07:02:59.232951 | 2026-06-07 07:02:59.232951 | 1 | International Results CSV 1 | elo://41967/home | |
| 84182 | Saint Martin 235 | 2018-11-16 | 1216.0233936567558 | 40.0 | -18.82503258175302 | 42091 | 0 | CONCACAF Nations League qualification 175 | 2026-06-07 07:02:59.256944 | 2026-06-07 07:02:59.256944 | 1 | International Results CSV 1 | elo://42091/away | |
| 84584 | Saint Martin 235 | 2019-03-17 | 1205.6511246127604 | 40.0 | -10.372269043995402 | 42292 | 0 | Friendly 8 | 2026-06-07 07:02:59.567727 | 2026-06-07 07:02:59.567727 | 1 | International Results CSV 1 | elo://42292/away | |
| 84712 | Saint Martin 235 | 2019-03-23 | 1190.88207638677 | 40.0 | -14.769048225990446 | 42356 | 0 | CONCACAF Nations League qualification 175 | 2026-06-07 07:02:59.579575 | 2026-06-07 07:02:59.579576 | 1 | International Results CSV 1 | elo://42356/away | |
| 85690 | Saint Martin 235 | 2019-09-05 | 1176.9493615022504 | 40.0 | -13.932714884519555 | 42845 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.670517 | 2026-06-07 07:02:59.670518 | 1 | International Results CSV 1 | elo://42845/away | |
| 85831 | Saint Martin 235 | 2019-09-08 | 1154.7008528110343 | 40.0 | -22.248508691216102 | 42916 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.683648 | 2026-06-07 07:02:59.683648 | 1 | International Results CSV 1 | elo://42916/home | |
| 86147 | Saint Martin 235 | 2019-10-12 | 1179.7999799553681 | 40.0 | 25.099127144333806 | 43074 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.713015 | 2026-06-07 07:02:59.713016 | 1 | International Results CSV 1 | elo://43074/home | |
| 86284 | Saint Martin 235 | 2019-10-15 | 1162.1140586889462 | 40.0 | -17.68592126642193 | 43142 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.725732 | 2026-06-07 07:02:59.725732 | 1 | International Results CSV 1 | elo://43142/away | |
| 86513 | Saint Martin 235 | 2019-11-16 | 1190.2902870517826 | 40.0 | 28.176228362836355 | 43257 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.747118 | 2026-06-07 07:02:59.747119 | 1 | International Results CSV 1 | elo://43257/home | |
| 86654 | Saint Martin 235 | 2019-11-19 | 1206.3601458223468 | 40.0 | 16.069858770564224 | 43327 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:02:59.760162 | 2026-06-07 07:02:59.760162 | 1 | International Results CSV 1 | elo://43327/away | |
| 90391 | Saint Martin 235 | 2022-06-03 | 1205.7431200176973 | 40.0 | -0.6170258046495292 | 45196 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.379562 | 2026-06-07 07:03:00.379563 | 1 | International Results CSV 1 | elo://45196/home | |
| 90514 | Saint Martin 235 | 2022-06-06 | 1185.1970717994452 | 40.0 | -20.546048218252054 | 45257 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.390876 | 2026-06-07 07:03:00.390876 | 1 | International Results CSV 1 | elo://45257/away | |
| 90758 | Saint Martin 235 | 2022-06-12 | 1194.944292198679 | 40.0 | 9.747220399233811 | 45379 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.413594 | 2026-06-07 07:03:00.413594 | 1 | International Results CSV 1 | elo://45379/away | |
| 91683 | Saint Martin 235 | 2023-03-10 | 1226.3180474039148 | 40.0 | 31.37375520523574 | 45842 | 0 | Friendly 8 | 2026-06-07 07:03:00.500104 | 2026-06-07 07:03:00.500104 | 1 | International Results CSV 1 | elo://45842/home | |
| 91763 | Saint Martin 235 | 2023-03-23 | 1213.6793465463252 | 40.0 | -12.638700857589583 | 45882 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.507548 | 2026-06-07 07:03:00.507549 | 1 | International Results CSV 1 | elo://45882/home | |
| 92644 | Saint Martin 235 | 2023-09-07 | 1223.8997059492744 | 40.0 | 10.22035940294927 | 46322 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.589611 | 2026-06-07 07:03:00.589611 | 1 | International Results CSV 1 | elo://46322/away | |
| 92835 | Saint Martin 235 | 2023-09-11 | 1247.7323297121072 | 40.0 | 23.83262376283278 | 46418 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.607507 | 2026-06-07 07:03:00.607507 | 1 | International Results CSV 1 | elo://46418/home | |
| 93159 | Saint Martin 235 | 2023-10-16 | 1255.8469631296298 | 40.0 | 8.114633417522555 | 46580 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.637502 | 2026-06-07 07:03:00.637502 | 1 | International Results CSV 1 | elo://46580/home | |
| 93580 | Saint Martin 235 | 2023-11-21 | 1277.3510853337161 | 40.0 | 21.504122204086343 | 46790 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:00.676498 | 2026-06-07 07:03:00.676498 | 1 | International Results CSV 1 | elo://46790/away | |
| 95082 | Saint Martin 235 | 2024-09-06 | 1256.9836752481397 | 40.0 | -20.367410085576466 | 47541 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.093576 | 2026-06-07 07:03:01.093576 | 1 | International Results CSV 1 | elo://47541/away | |
| 95206 | Saint Martin 235 | 2024-09-09 | 1246.7552305418453 | 40.0 | -10.22844470629434 | 47603 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.105098 | 2026-06-07 07:03:01.105098 | 1 | International Results CSV 1 | elo://47603/away | |
| 95464 | Saint Martin 235 | 2024-10-11 | 1233.216788290496 | 40.0 | -13.538442251349352 | 47732 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.129093 | 2026-06-07 07:03:01.129093 | 1 | International Results CSV 1 | elo://47732/away | |
| 95578 | Saint Martin 235 | 2024-10-14 | 1261.0373555831075 | 40.0 | 27.820567292611486 | 47789 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.139746 | 2026-06-07 07:03:01.139747 | 1 | International Results CSV 1 | elo://47789/away | |
| 95820 | Saint Martin 235 | 2024-11-15 | 1251.161579577408 | 40.0 | -9.875776005699436 | 47910 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.162330 | 2026-06-07 07:03:01.162330 | 1 | International Results CSV 1 | elo://47910/away | |
| 95946 | Saint Martin 235 | 2024-11-18 | 1273.7757127511413 | 40.0 | 22.614133173733308 | 47973 | 0 | CONCACAF Nations League 178 | 2026-06-07 07:03:01.174164 | 2026-06-07 07:03:01.174164 | 1 | International Results CSV 1 | elo://47973/away | |
| 97358 | Saint Martin 235 | 2025-10-04 | 1254.0722928924288 | 40.0 | -19.70341985871255 | 48679 | 0 | Friendly 8 | 2026-06-07 07:03:01.306371 | 2026-06-07 07:03:01.306371 | 1 | International Results CSV 1 | elo://48679/away | |
| 97360 | Saint Martin 235 | 2025-10-05 | 1236.6233629550334 | 40.0 | -17.448929937395405 | 48680 | 0 | Friendly 8 | 2026-06-07 07:03:01.306556 | 2026-06-07 07:03:01.306556 | 1 | International Results CSV 1 | elo://48680/away | |
| 97720 | Saint Martin 235 | 2025-11-12 | 1256.1993108075587 | 40.0 | 19.57594785252536 | 48860 | 0 | CONCACAF Series 201 | 2026-06-07 07:03:01.339947 | 2026-06-07 07:03:01.339947 | 1 | International Results CSV 1 | elo://48860/away | |
| 97867 | Saint Martin 235 | 2025-11-15 | 1239.0512355714584 | 40.0 | -17.14807523610034 | 48934 | 0 | CONCACAF Series 201 | 2026-06-07 07:03:01.353684 | 2026-06-07 07:03:01.353684 | 1 | International Results CSV 1 | elo://48934/home | |
| 98281 | Saint Martin 235 | 2026-03-26 | 1256.3147239969453 | 40.0 | 17.263488425486912 | 49141 | 0 | CONCACAF Series 201 | 2026-06-07 07:03:01.392085 | 2026-06-07 07:03:01.392086 | 1 | International Results CSV 1 | elo://49141/home | |
| 98398 | Saint Martin 235 | 2026-03-29 | 1274.7265860041496 | 40.0 | 18.411862007204263 | 49199 | 0 | CONCACAF Series 201 | 2026-06-07 07:03:01.402881 | 2026-06-07 07:03:01.402882 | 1 | International Results CSV 1 | elo://49199/away |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE elo_record (
elo_id INTEGER NOT NULL,
team_id INTEGER NOT NULL,
date DATE NOT NULL,
rating FLOAT NOT NULL,
k_factor FLOAT NOT NULL,
delta FLOAT,
source_match_id INTEGER,
is_tournament BOOLEAN NOT NULL,
competition_id INTEGER,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL,
created_by_run_id INTEGER,
updated_by_run_id INTEGER,
source_id INTEGER NOT NULL,
source_raw_key VARCHAR(512),
CONSTRAINT pk_elo_record PRIMARY KEY (elo_id),
CONSTRAINT fk_elo_record_team FOREIGN KEY(team_id) REFERENCES team (team_id),
CONSTRAINT fk_elo_record_match FOREIGN KEY(source_match_id) REFERENCES match (match_id),
CONSTRAINT fk_elo_record_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
CONSTRAINT fk_elo_record_competition FOREIGN KEY(competition_id) REFERENCES competition (competition_id)
);