home / football

elo_record

1,658 rows where competition_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
8435 Philippines 32 1956-02-25 1359.0424359253752 40.0 -12.121037049737652 4218 1 AFC Asian Cup qualification 40 2026-06-07 07:00:17 2026-06-07 07:00:17 1   International Results CSV 1 elo://4218/home
8436 South Korea 114 1956-02-25 1527.9792444237362 40.0 12.121037049737652 4218 1 AFC Asian Cup qualification 40 2026-06-07 07:00:17 2026-06-07 07:00:17 1   International Results CSV 1 elo://4218/away
8481 Malaysia 136 1956-03-17 1502.5327389104116 40.0 22.277992417762107 4241 1 AFC Asian Cup qualification 40 2026-06-07 07:00:17 2026-06-07 07:00:17 1   International Results CSV 1 elo://4241/home
8482 Cambodia 142 1956-03-17 1497.722007582238 40.0 -22.277992417762107 4241 1 AFC Asian Cup qualification 40 2026-06-07 07:00:17 2026-06-07 07:00:17 1   International Results CSV 1 elo://4241/away
8509 South Korea 114 1956-04-21 1538.9547152966188 40.0 10.975470872882624 4255 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4255/home
8510 Philippines 32 1956-04-21 1348.0669650524926 40.0 -10.975470872882624 4255 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4255/away
8513 Cambodia 142 1956-04-24 1517.9989178418666 40.0 20.27691025962872 4257 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4257/home
8514 Malaysia 136 1956-04-24 1482.2558286507829 40.0 -20.27691025962872 4257 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4257/away
8527 Vietnam Republic 144 1956-05-03 1518.9794505453965 40.0 18.979450545396503 4264 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4264/home
8528 Malaysia 136 1956-05-03 1463.2763781053864 40.0 -18.979450545396503 4264 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4264/away
8547 Malaysia 136 1956-05-24 1466.4557101971827 40.0 3.1793320917963683 4274 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4274/home
8548 Vietnam Republic 144 1956-05-24 1515.8001184536001 40.0 -3.1793320917963683 4274 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4274/away
8637 South Korea 114 1956-08-26 1560.701076392124 40.0 21.746361095505108 4319 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4319/home
8638 Taiwan 123 1956-08-26 1547.6232102577696 40.0 -21.746361095505108 4319 1 AFC Asian Cup qualification 40 2026-06-07 07:00:18 2026-06-07 07:00:18 1   International Results CSV 1 elo://4319/away
9671 Philippines 32 1959-03-29 1313.2072892921428 40.0 -7.786771255563508 4836 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4836/home
9672 Hong Kong 134 1959-03-29 1575.4515675915968 40.0 7.786771255563508 4836 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4836/away
9675 Philippines 32 1959-03-31 1307.3815880997627 40.0 -5.825701192380166 4838 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4838/home
9676 Taiwan 123 1959-03-31 1626.3735533156973 40.0 5.825701192380166 4838 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4838/away
9711 Singapore 135 1959-05-09 1401.1196787693295 40.0 -16.367281369914963 4856 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4856/home
9712 Vietnam Republic 144 1959-05-09 1497.6690958602203 40.0 16.367281369914963 4856 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4856/away
9717 Singapore 135 1959-05-11 1388.3014702366693 40.0 -12.818208532660265 4859 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4859/home
9718 Malaysia 136 1959-05-11 1544.518184792175 40.0 12.818208532660265 4859 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4859/away
9723 Malaysia 136 1959-05-13 1521.837561601856 40.0 -22.68062319031901 4862 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4862/home
9724 Vietnam Republic 144 1959-05-13 1520.3497190505393 40.0 22.68062319031901 4862 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4862/away
9919 Iran 99 1959-12-05 1490.833595267333 40.0 16.392948324730696 4960 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4960/home
9920 Israel 82 1959-12-05 1394.6938262860874 40.0 -16.392948324730696 4960 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4960/away
9925 India 92 1959-12-06 1576.9014809586852 40.0 16.85462286095708 4963 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4963/home
9926 Pakistan 129 1959-12-06 1488.0941462233436 40.0 -16.85462286095708 4963 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4963/away
9927 India 92 1959-12-08 1547.279154898995 40.0 -29.622326059690067 4964 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4964/home
9928 Israel 82 1959-12-08 1424.3161523457775 40.0 29.622326059690067 4964 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4964/away
9931 Israel 82 1959-12-10 1447.9468190804716 40.0 23.63066673469416 4966 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4966/home
9932 Pakistan 129 1959-12-10 1464.4634794886495 40.0 -23.63066673469416 4966 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4966/away
9937 Israel 82 1959-12-12 1450.4031175195114 40.0 2.456298439039756 4969 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4969/home
9938 Iran 99 1959-12-12 1488.3772968282933 40.0 -2.456298439039756 4969 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4969/away
9961 Pakistan 129 1959-12-17 1463.6545415530802 40.0 -0.8089379355692472 4981 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4981/home
9962 Israel 82 1959-12-17 1451.2120554550806 40.0 0.8089379355692472 4981 1 AFC Asian Cup qualification 40 2026-06-07 07:00:19 2026-06-07 07:00:19 1   International Results CSV 1 elo://4981/away
11965 Hong Kong 134 1963-12-07 1519.2845451501698 40.0 -8.64175125953625 5983 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5983/home
11966 Thailand 143 1963-12-07 1375.8927702814483 40.0 8.64175125953625 5983 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5983/away
11969 Vietnam Republic 144 1963-12-07 1551.4112162855013 40.0 18.006931427056315 5985 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5985/home
11970 Malaysia 136 1963-12-07 1480.6589063869578 40.0 -18.006931427056315 5985 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5985/away
11975 Malaysia 136 1963-12-11 1494.8044590204352 40.0 14.145552633477337 5988 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5988/home
11976 Thailand 143 1963-12-11 1361.747217647971 40.0 -14.145552633477337 5988 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5988/away
11977 Vietnam Republic 144 1963-12-11 1529.5671093482688 40.0 -21.844106937232482 5989 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5989/home
11978 Hong Kong 134 1963-12-11 1541.1286520874023 40.0 21.844106937232482 5989 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5989/away
11981 Hong Kong 134 1963-12-14 1558.4777075182953 40.0 17.34905543089303 5991 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5991/home
11982 Malaysia 136 1963-12-14 1477.4554035895421 40.0 -17.34905543089303 5991 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5991/away
11985 Vietnam Republic 144 1963-12-14 1540.5938585437377 40.0 11.026749195468938 5993 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5993/home
11986 Thailand 143 1963-12-14 1350.720468452502 40.0 -11.026749195468938 5993 1 AFC Asian Cup qualification 40 2026-06-07 07:00:20 2026-06-07 07:00:20 1   International Results CSV 1 elo://5993/away
14009 Hong Kong 134 1967-03-22 1397.6631143245984 40.0 29.464418432464754 7005 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7005/home
14010 Vietnam Republic 144 1967-03-22 1517.3900213099091 40.0 -29.464418432464754 7005 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7005/away
14013 Thailand 143 1967-03-24 1383.1368163767263 40.0 -13.305959591123838 7007 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7007/home
14014 Vietnam Republic 144 1967-03-24 1530.695980901033 40.0 13.305959591123838 7007 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7007/away
14019 Vietnam Republic 144 1967-03-29 1502.35793540432 40.0 -28.338045496712994 7010 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7010/home
14020 Malaysia 136 1967-03-29 1404.794606220738 40.0 28.338045496712994 7010 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7010/away
14027 Vietnam Republic 144 1967-04-02 1518.3018566216608 40.0 15.943921217340858 7014 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7014/home
14028 Singapore 135 1967-04-02 1414.962135129187 40.0 -15.943921217340858 7014 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7014/away
14151 South Korea 114 1967-07-29 1566.0098315563507 40.0 -1.6246243714326738 7076 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7076/home
14152 Indonesia 83 1967-07-29 1540.9741416371244 40.0 1.6246243714326738 7076 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7076/away
14161 Japan 36 1967-08-01 1588.5598108949614 40.0 19.844248777278608 7081 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7081/home
14162 South Korea 114 1967-08-01 1546.165582779072 40.0 -19.844248777278608 7081 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7081/away
14173 Japan 36 1967-08-03 1593.6979579475742 40.0 5.138147052612794 7087 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7087/home
14174 Philippines 32 1967-08-03 1250.8040889952742 40.0 -5.138147052612794 7087 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7087/away
14175 Japan 36 1967-08-05 1610.686015832723 40.0 16.98805788514869 7088 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7088/home
14176 Indonesia 83 1967-08-05 1523.9860837519757 40.0 -16.98805788514869 7088 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7088/away
14177 South Korea 114 1967-08-05 1552.3429530870326 40.0 6.177370307960473 7089 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7089/home
14178 Philippines 32 1967-08-05 1244.6267186873138 40.0 -6.177370307960473 7089 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7089/away
14179 Indonesia 83 1967-08-07 1530.6600655071911 40.0 6.673981755215436 7090 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7090/home
14180 Philippines 32 1967-08-07 1237.9527369320983 40.0 -6.673981755215436 7090 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7090/away
14423 Myanmar 125 1967-11-12 1621.7124691347658 40.0 16.56602608121011 7212 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7212/home
14424 India 92 1967-11-12 1528.3293763868019 40.0 -16.56602608121011 7212 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7212/away
14439 India 92 1967-11-15 1523.0241069935307 40.0 -5.305269393271146 7220 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7220/home
14440 Pakistan 129 1967-11-15 1439.214911244296 40.0 5.305269393271146 7220 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7220/away
14443 Myanmar 125 1967-11-16 1629.3716536564978 40.0 7.659184521731959 7222 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7222/home
14444 Cambodia 142 1967-11-16 1363.8259110040226 40.0 -7.659184521731959 7222 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7222/away
14449 Myanmar 125 1967-11-19 1639.40154903581 40.0 10.029895379312165 7225 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7225/home
14450 Pakistan 129 1967-11-19 1429.1850158649838 40.0 -10.029895379312165 7225 1 AFC Asian Cup qualification 40 2026-06-07 07:00:22 2026-06-07 07:00:22 1   International Results CSV 1 elo://7225/away
16793 Thailand 143 1971-05-21 1501.180040598721 40.0 -8.648683345576046 8397 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8397/home
16794 Cambodia 142 1971-05-21 1357.6540359577689 40.0 8.648683345576046 8397 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8397/away
16797 Indonesia 83 1971-05-22 1544.0385248004322 40.0 11.215651263953305 8399 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8399/home
16798 Hong Kong 134 1971-05-22 1357.874457990509 40.0 -11.215651263953305 8399 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8399/away
16799 Malaysia 136 1971-05-22 1479.7180437438826 40.0 22.44737117274576 8400 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8400/home
16800 Brunei 193 1971-05-22 1477.5526288272542 40.0 -22.44737117274576 8400 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8400/away
16803 Cambodia 142 1971-05-24 1377.6667244682353 40.0 20.012688510466432 8402 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8402/home
16804 Hong Kong 134 1971-05-24 1337.8617694800425 40.0 -20.012688510466432 8402 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8402/away
16805 Thailand 143 1971-05-24 1519.822030264416 40.0 18.641989665695064 8403 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8403/home
16806 Brunei 193 1971-05-24 1458.9106391615592 40.0 -18.641989665695064 8403 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8403/away
16813 Malaysia 136 1971-05-26 1494.0068076009802 40.0 14.288763857097592 8407 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8407/home
16814 Cambodia 142 1971-05-26 1363.3779606111377 40.0 -14.288763857097592 8407 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8407/away
16819 Thailand 143 1971-05-26 1501.2137906677558 40.0 -18.60823959666027 8410 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8410/home
16820 Indonesia 83 1971-05-26 1562.6467643970925 40.0 18.60823959666027 8410 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8410/away
16821 Indonesia 83 1971-05-28 1576.8465756159171 40.0 14.199811218824607 8411 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8411/home
16822 Brunei 193 1971-05-28 1444.7108279427346 40.0 -14.199811218824607 8411 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8411/away
16823 Malaysia 136 1971-05-28 1505.5783396077006 40.0 11.571532006720417 8412 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8412/home
16824 Hong Kong 134 1971-05-28 1326.2902374733221 40.0 -11.571532006720417 8412 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8412/away
16825 Cambodia 142 1971-05-30 1394.3224687191778 40.0 30.944508108040054 8413 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8413/home
16826 Indonesia 83 1971-05-30 1545.902067507877 40.0 -30.944508108040054 8413 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8413/away
16831 Thailand 143 1971-05-30 1521.4650210856398 40.0 20.251230417884017 8416 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8416/home
16832 Malaysia 136 1971-05-30 1485.3271091898166 40.0 -20.251230417884017 8416 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8416/away
16833 Malaysia 136 1971-06-01 1508.7791767122346 40.0 23.45206752241802 8417 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8417/home
16834 Indonesia 83 1971-06-01 1522.449999985459 40.0 -23.45206752241802 8417 1 AFC Asian Cup qualification 40 2026-06-07 07:00:24 2026-06-07 07:00:24 1   International Results CSV 1 elo://8417/away

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 1077.621ms