home / football

elo_record

899 rows where team_id = 387

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_tournament, competition_id, created_by_run_id, source_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
49234 AS Monaco 387 2000-06-11 1477.4136080957785 40.0 -22.5863919042215 24617 0 Friendly 8 2026-06-07 07:00:50 2026-06-07 07:00:50 1   International Results CSV 1 elo://24617/away
51579 AS Monaco 387 2001-07-14 1497.1430992218654 40.0 19.72949112608694 25790 0 Friendly 8 2026-06-07 07:00:52 2026-06-07 07:00:52 1   International Results CSV 1 elo://25790/home
52550 AS Monaco 387 2002-02-18 1498.9692948093864 40.0 1.8261955875209424 26275 0 Friendly 8 2026-06-07 07:00:52 2026-06-07 07:00:52 1   International Results CSV 1 elo://26275/away
53613 AS Monaco 387 2002-11-23 1499.0286267955103 40.0 0.05933198612387969 26807 0 Friendly 8 2026-06-07 07:00:53 2026-06-07 07:00:53 1   International Results CSV 1 elo://26807/home
58018 AS Monaco 387 2005-02-12 1499.0845433863258 40.0 0.0559165908155137 29009 0 Friendly 8 2026-06-07 07:00:57 2026-06-07 07:00:57 1   International Results CSV 1 elo://29009/away
58311 AS Monaco 387 2005-05-17 1500.2840589550735 40.0 1.1995155687477563 29156 0 Friendly 8 2026-06-07 07:00:57 2026-06-07 07:00:57 1   International Results CSV 1 elo://29156/home
58328 AS Monaco 387 2005-05-27 1482.3718760806285 40.0 -17.91218287444508 29164 0 Friendly 8 2026-06-07 07:00:57 2026-06-07 07:00:57 1   International Results CSV 1 elo://29164/away
59430 AS Monaco 387 2005-12-17 1504.4582240532104 40.0 22.08634797258196 29715 0 Friendly 8 2026-06-07 07:00:58 2026-06-07 07:00:58 1   International Results CSV 1 elo://29715/away
59619 AS Monaco 387 2006-02-18 1523.1183314813964 40.0 18.66010742818594 29810 0 Friendly 8 2026-06-07 07:00:58 2026-06-07 07:00:58 1   International Results CSV 1 elo://29810/home
59832 AS Monaco 387 2006-04-22 1501.789493935628 40.0 -21.328837545768465 29916 0 Friendly 8 2026-06-07 07:00:58 2026-06-07 07:00:58 1   International Results CSV 1 elo://29916/away
60993 AS Monaco 387 2006-11-20 1521.6202751715646 40.0 19.830781235936684 30497 1 Viva World Cup 146 2026-06-07 07:00:59 2026-06-07 07:00:59 1   International Results CSV 1 elo://30497/home
61010 AS Monaco 387 2006-11-21 1539.0574660340048 40.0 17.437190862440275 30505 1 Viva World Cup 146 2026-06-07 07:00:59 2026-06-07 07:00:59 1   International Results CSV 1 elo://30505/away
61024 AS Monaco 387 2006-11-23 1518.9661169122592 40.0 -20.09134912174568 30512 1 Viva World Cup 146 2026-06-07 07:00:59 2026-06-07 07:00:59 1   International Results CSV 1 elo://30512/away
61036 AS Monaco 387 2006-11-24 1501.1787749458194 40.0 -17.787341966439726 30518 1 Viva World Cup 146 2026-06-07 07:00:59 2026-06-07 07:00:59 1   International Results CSV 1 elo://30518/away
65096 AS Monaco 387 2008-11-08 1500.9574144543276 40.0 -0.22136049149185055 32548 0 Friendly 8 2026-06-07 07:01:02 2026-06-07 07:01:02 1   International Results CSV 1 elo://32548/away
65297 AS Monaco 387 2008-12-20 1474.9880222353966 40.0 -25.969392218931034 32649 0 Friendly 8 2026-06-07 07:01:02 2026-06-07 07:01:02 1   International Results CSV 1 elo://32649/home
67486 AS Monaco 387 2010-04-03 1455.4369425137675 40.0 -19.551079721629094 33743 0 Friendly 8 2026-06-07 07:01:04 2026-06-07 07:01:04 1   International Results CSV 1 elo://33743/away
69415 AS Monaco 387 2011-05-07 1477.9848630481938 40.0 22.54792053442634 34708 0 Friendly 8 2026-06-07 07:01:06 2026-06-07 07:01:06 1   International Results CSV 1 elo://34708/home
71933 AS Monaco 387 2012-06-10 1454.7298057646124 40.0 -23.255057283581436 35967 0 Friendly 8 2026-06-07 07:01:08 2026-06-07 07:01:08 1   International Results CSV 1 elo://35967/home
73480 AS Monaco 387 2013-02-13 1434.0125141032868 40.0 -20.71729166132559 36740 0 Friendly 8 2026-06-07 07:01:09 2026-06-07 07:01:09 1   International Results CSV 1 elo://36740/away
74111 AS Monaco 387 2013-06-22 1454.8995545533282 40.0 20.887040450041468 37056 0 Friendly 8 2026-06-07 07:01:10 2026-06-07 07:01:10 1   International Results CSV 1 elo://37056/home
75304 AS Monaco 387 2014-04-06 1437.4812601324227 40.0 -17.418294420905568 37652 0 Friendly 8 2026-06-07 07:02:58.233478 2026-06-07 07:02:58.233479 1   International Results CSV 1 elo://37652/away
75326 AS Monaco 387 2014-05-10 1456.9669645353174 40.0 19.485704402894726 37663 0 Friendly 8 2026-06-07 07:02:58.233585 2026-06-07 07:02:58.233585 1   International Results CSV 1 elo://37663/away
81152 AS Monaco 387 2017-04-29 1454.2265273011342 40.0 -2.7404372341832186 40576 0 Friendly 8 2026-06-07 07:02:58.964564 2026-06-07 07:02:58.964564 1   International Results CSV 1 elo://40576/away
109074 AS Monaco 387 1998-08-07 1520.0 40.0 20.0 55410 0   2026-06-11 10:23:54.596008 2026-06-11 10:23:54.596008     International Results CSV 1 elo://55410/away
109103 AS Monaco 387 1998-08-15 1538.8499774443092 40.0 18.84997744430916 55423 0   2026-06-11 10:23:54.601456 2026-06-11 10:23:54.601456     International Results CSV 1 elo://55423/home
109166 AS Monaco 387 1998-08-22 1536.5575120938174 40.0 -2.2924653504917387 55435 0   2026-06-11 10:23:54.611044 2026-06-11 10:23:54.611044     International Results CSV 1 elo://55435/away
109206 AS Monaco 387 1998-08-29 1536.6861522538416 40.0 0.12864016002413337 55438 0   2026-06-11 10:23:54.616516 2026-06-11 10:23:54.616516     International Results CSV 1 elo://55438/away
109315 AS Monaco 387 1998-09-12 1555.7303772504365 40.0 19.04422499659495 55453 0   2026-06-11 10:23:54.637085 2026-06-11 10:23:54.637085     International Results CSV 1 elo://55453/home
109438 AS Monaco 387 1998-09-20 1532.3054174150166 40.0 -23.42495983541994 55462 0   2026-06-11 10:23:54.649767 2026-06-11 10:23:54.649767     International Results CSV 1 elo://55462/away
109493 AS Monaco 387 1998-09-25 1546.5263078119665 40.0 14.220890396949926 55467 0   2026-06-11 10:23:54.656281 2026-06-11 10:23:54.656282     International Results CSV 1 elo://55467/home
109593 AS Monaco 387 1998-10-03 1524.9168504364338 40.0 -21.609457375532656 55478 0   2026-06-11 10:23:54.668681 2026-06-11 10:23:54.668682     International Results CSV 1 elo://55478/away
109682 AS Monaco 387 1998-10-17 1543.6291011447656 40.0 18.712250708331794 55485 0   2026-06-11 10:23:54.686326 2026-06-11 10:23:54.686327     International Results CSV 1 elo://55485/home
109777 AS Monaco 387 1998-10-24 1517.4008780913325 40.0 -26.228223053433112 55494 0   2026-06-11 10:23:54.695750 2026-06-11 10:23:54.695750     International Results CSV 1 elo://55494/away
109862 AS Monaco 387 1998-10-29 1538.3315907788915 40.0 20.93071268755898 55501 0   2026-06-11 10:23:54.703462 2026-06-11 10:23:54.703463     International Results CSV 1 elo://55501/home
109951 AS Monaco 387 1998-11-06 1522.889892837854 40.0 -15.441697941037546 55509 0   2026-06-11 10:23:54.713051 2026-06-11 10:23:54.713051     International Results CSV 1 elo://55509/away
110056 AS Monaco 387 1998-11-11 1543.154435803821 40.0 20.26454296596694 55522 0   2026-06-11 10:23:54.723505 2026-06-11 10:23:54.723506     International Results CSV 1 elo://55522/home
110079 AS Monaco 387 1998-11-14 1519.604851501116 40.0 -23.549584302704943 55526 0   2026-06-11 10:23:54.725783 2026-06-11 10:23:54.725784     International Results CSV 1 elo://55526/away
110170 AS Monaco 387 1998-11-19 1503.9498024979584 40.0 -15.655049003157501 55536 0   2026-06-11 10:23:54.737591 2026-06-11 10:23:54.737591     International Results CSV 1 elo://55536/home
110281 AS Monaco 387 1998-11-28 1503.9946095998434 40.0 0.0448071018849987 55549 0   2026-06-11 10:23:54.748417 2026-06-11 10:23:54.748417     International Results CSV 1 elo://55549/away
110362 AS Monaco 387 1998-12-03 1523.618946210019 40.0 19.624336610175533 55555 0   2026-06-11 10:23:54.758333 2026-06-11 10:23:54.758334     International Results CSV 1 elo://55555/home
110554 AS Monaco 387 1998-12-16 1517.944544725849 40.0 -5.674401484169948 55575 0   2026-06-11 10:23:54.781950 2026-06-11 10:23:54.781950     International Results CSV 1 elo://55575/home
110580 AS Monaco 387 1998-12-19 1498.7228492455615 40.0 -19.221695480287508 55583 0   2026-06-11 10:23:54.784604 2026-06-11 10:23:54.784604     International Results CSV 1 elo://55583/home
110803 AS Monaco 387 1999-01-16 1499.8806401275067 40.0 1.157790881945175 55590 0   2026-06-11 10:23:54.806270 2026-06-11 10:23:54.806271     International Results CSV 1 elo://55590/away
110915 AS Monaco 387 1999-01-29 1517.2897600801336 40.0 17.409119952626952 55598 0   2026-06-11 10:23:54.819611 2026-06-11 10:23:54.819611     International Results CSV 1 elo://55598/home
110990 AS Monaco 387 1999-02-06 1534.3906725288864 40.0 17.10091244875275 55605 0   2026-06-11 10:23:54.827957 2026-06-11 10:23:54.827957     International Results CSV 1 elo://55605/away
111072 AS Monaco 387 1999-02-13 1554.8076634141137 40.0 20.41699088522728 55618 0   2026-06-11 10:23:54.838924 2026-06-11 10:23:54.838924     International Results CSV 1 elo://55618/home
111205 AS Monaco 387 1999-02-25 1571.7555034829018 40.0 16.947840068788082 55621 0   2026-06-11 10:23:54.853066 2026-06-11 10:23:54.853066     International Results CSV 1 elo://55621/away
111374 AS Monaco 387 1999-03-10 1567.265773833093 40.0 -4.489729649808851 55634 0   2026-06-11 10:23:54.873482 2026-06-11 10:23:54.873482     International Results CSV 1 elo://55634/home
111441 AS Monaco 387 1999-03-14 1560.1945179439917 40.0 -7.071255889101167 55638 0   2026-06-11 10:23:54.880620 2026-06-11 10:23:54.880621     International Results CSV 1 elo://55638/away
111475 AS Monaco 387 1999-03-19 1579.1864849744138 40.0 18.991967030422074 55641 0   2026-06-11 10:23:54.885165 2026-06-11 10:23:54.885165     International Results CSV 1 elo://55641/away
111562 AS Monaco 387 1999-04-02 1561.3718574919717 40.0 -17.81462748244212 55649 0   2026-06-11 10:23:54.901960 2026-06-11 10:23:54.901961     International Results CSV 1 elo://55649/home
111761 AS Monaco 387 1999-04-14 1573.545715379346 40.0 12.173857887374197 55662 0   2026-06-11 10:23:54.922067 2026-06-11 10:23:54.922067     International Results CSV 1 elo://55662/away
111876 AS Monaco 387 1999-04-24 1565.1508223823353 40.0 -8.39489299701063 55672 0   2026-06-11 10:23:54.934184 2026-06-11 10:23:54.934184     International Results CSV 1 elo://55672/home
111961 AS Monaco 387 1999-04-30 1587.6935029967144 40.0 22.54268061437915 55678 0   2026-06-11 10:23:54.945450 2026-06-11 10:23:54.945450     International Results CSV 1 elo://55678/away
112070 AS Monaco 387 1999-05-05 1602.0594051788423 40.0 14.365902182127911 55692 0   2026-06-11 10:23:54.956293 2026-06-11 10:23:54.956293     International Results CSV 1 elo://55692/home
112265 AS Monaco 387 1999-05-22 1615.5698084000733 40.0 13.510403221230945 55702 0   2026-06-11 10:23:54.976428 2026-06-11 10:23:54.976429     International Results CSV 1 elo://55702/away
112336 AS Monaco 387 1999-05-29 1627.8561653136753 40.0 12.286356913602049 55710 0   2026-06-11 10:23:54.983909 2026-06-11 10:23:54.983909     International Results CSV 1 elo://55710/home
112425 AS Monaco 387 1999-07-30 1620.8113499632125 40.0 -7.044815350462841 55716 0   2026-06-11 10:23:55.029521 2026-06-11 10:23:55.029521     International Results CSV 1 elo://55716/home
112448 AS Monaco 387 1999-08-06 1594.3116399416742 40.0 -26.49971002153825 55727 0   2026-06-11 10:23:55.036078 2026-06-11 10:23:55.036078     International Results CSV 1 elo://55727/away
112503 AS Monaco 387 1999-08-14 1606.1184908617163 40.0 11.806850920042052 55735 0   2026-06-11 10:23:55.043490 2026-06-11 10:23:55.043491     International Results CSV 1 elo://55735/home
112556 AS Monaco 387 1999-08-20 1619.3570267273317 40.0 13.238535865615404 55744 0   2026-06-11 10:23:55.052306 2026-06-11 10:23:55.052307     International Results CSV 1 elo://55744/away
112691 AS Monaco 387 1999-08-29 1631.4327011879614 40.0 12.07567446062967 55759 0   2026-06-11 10:23:55.064870 2026-06-11 10:23:55.064870     International Results CSV 1 elo://55759/home
112798 AS Monaco 387 1999-09-12 1606.4839485192983 40.0 -24.94875266866302 55768 0   2026-06-11 10:23:55.084030 2026-06-11 10:23:55.084030     International Results CSV 1 elo://55768/away
112879 AS Monaco 387 1999-09-19 1599.031431942353 40.0 -7.4525165769453 55773 0   2026-06-11 10:23:55.091417 2026-06-11 10:23:55.091418     International Results CSV 1 elo://55773/home
112940 AS Monaco 387 1999-09-25 1614.3769058751266 40.0 15.34547393277353 55783 0   2026-06-11 10:23:55.096996 2026-06-11 10:23:55.096996     International Results CSV 1 elo://55783/away
113063 AS Monaco 387 1999-10-03 1634.973736840523 40.0 20.59683096539652 55794 0   2026-06-11 10:23:55.110218 2026-06-11 10:23:55.110218     International Results CSV 1 elo://55794/home
113128 AS Monaco 387 1999-10-13 1611.7911119298926 40.0 -23.182624910630466 55799 0   2026-06-11 10:23:55.122625 2026-06-11 10:23:55.122625     International Results CSV 1 elo://55799/away
113163 AS Monaco 387 1999-10-16 1624.6498800363324 40.0 12.858768106439811 55809 0   2026-06-11 10:23:55.126159 2026-06-11 10:23:55.126159     International Results CSV 1 elo://55809/home
113246 AS Monaco 387 1999-10-20 1635.059179016384 40.0 10.409298980051517 55814 0   2026-06-11 10:23:55.133659 2026-06-11 10:23:55.133659     International Results CSV 1 elo://55814/away
113476 AS Monaco 387 1999-11-07 1632.43667348894 40.0 -2.622505527443991 55837 0   2026-06-11 10:23:55.157046 2026-06-11 10:23:55.157046     International Results CSV 1 elo://55837/home
113541 AS Monaco 387 1999-11-10 1643.9082513711758 40.0 11.471577882235806 55847 0   2026-06-11 10:23:55.163509 2026-06-11 10:23:55.163509     International Results CSV 1 elo://55847/away
113560 AS Monaco 387 1999-11-20 1657.2634389563066 40.0 13.355187585130807 55856 0   2026-06-11 10:23:55.171406 2026-06-11 10:23:55.171406     International Results CSV 1 elo://55856/home
113639 AS Monaco 387 1999-11-27 1667.3449110314048 40.0 10.08147207509819 55858 0   2026-06-11 10:23:55.180995 2026-06-11 10:23:55.180995     International Results CSV 1 elo://55858/away
113726 AS Monaco 387 1999-12-01 1678.7512296083432 40.0 11.406318576938475 55867 0   2026-06-11 10:23:55.567574 2026-06-11 10:23:55.567575     International Results CSV 1 elo://55867/home
113748 AS Monaco 387 1999-12-04 1689.1612009394662 40.0 10.40997133112296 55875 0   2026-06-11 10:23:55.569865 2026-06-11 10:23:55.569865     International Results CSV 1 elo://55875/home
113855 AS Monaco 387 1999-12-12 1657.779424327065 40.0 -31.381776612401154 55882 0   2026-06-11 10:23:55.580211 2026-06-11 10:23:55.580211     International Results CSV 1 elo://55882/away
113930 AS Monaco 387 1999-12-18 1664.4264356173728 40.0 6.647011290307773 55890 0   2026-06-11 10:23:55.588752 2026-06-11 10:23:55.588752     International Results CSV 1 elo://55890/home
114175 AS Monaco 387 2000-01-12 1677.0305538925709 40.0 12.604118275198061 55901 0   2026-06-11 10:23:55.614898 2026-06-11 10:23:55.614898     International Results CSV 1 elo://55901/away
114182 AS Monaco 387 2000-01-15 1689.0281876207878 40.0 11.997633728216897 55904 0   2026-06-11 10:23:55.615983 2026-06-11 10:23:55.615983     International Results CSV 1 elo://55904/home
114315 AS Monaco 387 2000-01-25 1678.8297121675796 40.0 -10.198475453208175 55913 0   2026-06-11 10:23:55.631899 2026-06-11 10:23:55.631900     International Results CSV 1 elo://55913/away
114376 AS Monaco 387 2000-02-01 1692.399415818122 40.0 13.569703650542351 55923 0   2026-06-11 10:23:55.642410 2026-06-11 10:23:55.642410     International Results CSV 1 elo://55923/home
114447 AS Monaco 387 2000-02-06 1664.8132623533984 40.0 -27.586153464723566 55938 0   2026-06-11 10:23:55.653536 2026-06-11 10:23:55.653537     International Results CSV 1 elo://55938/away
114594 AS Monaco 387 2000-02-16 1677.8958638830404 40.0 13.082601529642034 55945 0   2026-06-11 10:23:55.675901 2026-06-11 10:23:55.675901     International Results CSV 1 elo://55945/home
114717 AS Monaco 387 2000-02-27 1647.8581821336054 40.0 -30.037681749435023 55957 0   2026-06-11 10:23:55.695521 2026-06-11 10:23:55.695521     International Results CSV 1 elo://55957/away
114885 AS Monaco 387 2000-03-12 1659.3842814923105 40.0 11.526099358705096 55964 0   2026-06-11 10:23:55.715949 2026-06-11 10:23:55.715949     International Results CSV 1 elo://55964/away
115081 AS Monaco 387 2000-03-26 1670.6089854289771 40.0 11.224703936666629 55974 0   2026-06-11 10:23:55.740466 2026-06-11 10:23:55.740467     International Results CSV 1 elo://55974/home
115176 AS Monaco 387 2000-04-07 1640.358043401948 40.0 -30.25094202702917 55976 0   2026-06-11 10:23:55.759485 2026-06-11 10:23:55.759485     International Results CSV 1 elo://55976/away
115299 AS Monaco 387 2000-04-15 1630.5614499102371 40.0 -9.796593491710837 55989 0   2026-06-11 10:23:55.779099 2026-06-11 10:23:55.779099     International Results CSV 1 elo://55989/home
115480 AS Monaco 387 2000-04-29 1603.8550011721757 40.0 -26.706448738061454 55998 0   2026-06-11 10:23:55.808897 2026-06-11 10:23:55.808897     International Results CSV 1 elo://55998/away
115577 AS Monaco 387 2000-05-04 1614.3505154389127 40.0 10.495514266737018 56008 0   2026-06-11 10:23:55.818735 2026-06-11 10:23:55.818735     International Results CSV 1 elo://56008/home
115660 AS Monaco 387 2000-05-13 1589.021333304318 40.0 -25.329182134594703 56019 0   2026-06-11 10:23:55.829681 2026-06-11 10:23:55.829682     International Results CSV 1 elo://56019/away
115788 AS Monaco 387 2000-07-29 1558.1459483593771 40.0 -3.5125501255492964 56026 0   2026-06-11 10:23:55.887548 2026-06-11 10:23:55.887548     International Results CSV 1 elo://56026/away
115797 AS Monaco 387 2000-08-04 1534.0877094155483 40.0 -24.058238943828883 56031 0   2026-06-11 10:23:55.888432 2026-06-11 10:23:55.888432     International Results CSV 1 elo://56031/home
115824 AS Monaco 387 2000-08-12 1550.3817351445637 40.0 16.294025729015402 56044 0   2026-06-11 10:23:55.892427 2026-06-11 10:23:55.892427     International Results CSV 1 elo://56044/away
115865 AS Monaco 387 2000-08-20 1565.7563122268925 40.0 15.37457708232887 56056 0   2026-06-11 10:23:55.902766 2026-06-11 10:23:55.902767     International Results CSV 1 elo://56056/home
115896 AS Monaco 387 2000-08-26 1560.9624482423535 40.0 -4.79386398453903 56061 0   2026-06-11 10:23:55.905740 2026-06-11 10:23:55.905741     International Results CSV 1 elo://56061/away
115925 AS Monaco 387 2000-09-05 1537.7743191857699 40.0 -23.188129056583648 56066 0   2026-06-11 10:23:55.918647 2026-06-11 10:23:55.918647     International Results CSV 1 elo://56066/home
115974 AS Monaco 387 2000-09-09 1516.0831602300889 40.0 -21.691158955680976 56080 0   2026-06-11 10:23:55.923038 2026-06-11 10:23:55.923038     International Results CSV 1 elo://56080/away
116029 AS Monaco 387 2000-09-16 1529.5740053580535 40.0 13.490845127964576 56088 0   2026-06-11 10:23:55.928333 2026-06-11 10:23:55.928333     International Results CSV 1 elo://56088/home

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Queries took 1220.312ms