nba-elo/nbaallelo

126,314 rows sorted by seasongame

View and edit SQL

Link rowid gameorder game_id lg_id _iscopy year_id date_game seasongame ▼ is_playoffs team_id fran_id pts elo_i elo_n win_equiv opp_id opp_fran opp_pts opp_elo_i opp_elo_n game_location game_result forecast notes
1 1 194611010TRH NBA 0 1947 11/1/1946 1 0 TRH Huskies 66 1300.0 1293.2767 40.29483 NYK Knicks 68 1300.0 1306.7233 H L 0.64006501  
2 1 194611010TRH NBA 1 1947 11/1/1946 1 0 NYK Knicks 68 1300.0 1306.7233 41.70517 TRH Huskies 66 1300.0 1293.2767 A W 0.35993499  
3 2 194611020CHS NBA 0 1947 11/2/1946 1 0 CHS Stags 63 1300.0 1309.6521 42.012257 NYK Knicks 47 1306.7233 1297.0712 H W 0.63110125  
5 3 194611020DTF NBA 0 1947 11/2/1946 1 0 DTF Falcons 33 1300.0 1279.6189 38.864048 WSC Capitols 50 1300.0 1320.3811 H L 0.64006501  
6 3 194611020DTF NBA 1 1947 11/2/1946 1 0 WSC Capitols 50 1300.0 1320.3811 43.135952 DTF Falcons 33 1300.0 1279.6189 A W 0.35993499  
7 4 194611020PRO NBA 1 1947 11/2/1946 1 0 BOS Celtics 53 1300.0 1294.8458 40.459381 PRO Steamrollers 59 1300.0 1305.1542 A L 0.35993499  
8 4 194611020PRO NBA 0 1947 11/2/1946 1 0 PRO Steamrollers 59 1300.0 1305.1542 41.540619 BOS Celtics 53 1300.0 1294.8458 H W 0.64006501  
9 5 194611020STB NBA 1 1947 11/2/1946 1 0 PIT Ironmen 51 1300.0 1295.3092 40.507979999999996 STB Bombers 56 1300.0 1304.6908 A L 0.35993499  
10 5 194611020STB NBA 0 1947 11/2/1946 1 0 STB Bombers 56 1300.0 1304.6908 41.492020000000004 PIT Ironmen 51 1300.0 1295.3092 H W 0.64006501  
12 6 194611030CLR NBA 0 1947 11/3/1946 1 0 CLR Rebels 71 1300.0 1307.1233 41.74712 TRH Huskies 60 1293.2767 1286.1534 H W 0.6489321  
20 10 194611070GSW NBA 0 1947 11/7/1946 1 0 PHW Warriors 81 1300.0 1304.667 41.489525 PIT Ironmen 75 1277.9456 1273.2786 H W 0.66876441  
701 351 194711120WSC NBA 0 1948 11/12/1947 1 0 WSC Capitols 63 1481.0703 1485.6085 50.173782 BLB Baltimore 55 1419.0 1414.4618 H W 0.71767372  
702 351 194711120WSC NBA 1 1948 11/12/1947 1 0 BLB Baltimore 55 1419.0 1414.4618 42.867378 WSC Capitols 63 1481.0703 1485.6085 A L 0.28232628  
704 352 194711130BLB NBA 1 1948 11/13/1947 1 0 BOS Celtics 74 1289.9966 1285.9733 29.691414 BLB Baltimore 85 1414.4618 1418.4851 A L 0.21549326  
705 353 194711130CHS NBA 0 1948 11/13/1947 1 0 CHS Stags 80 1433.2307 1439.0546 45.430969 STB Bombers 70 1395.4702 1389.6464 H W 0.68847793  
706 353 194711130CHS NBA 1 1948 11/13/1947 1 0 STB Bombers 70 1395.4702 1389.6464 40.26572 CHS Stags 80 1433.2307 1439.0546 A L 0.31152207  
708 354 194711130NYK NBA 0 1948 11/13/1947 1 0 NYK Knicks 80 1359.7107 1374.4819 38.677448 WSC Capitols 65 1485.6085 1470.8373 H W 0.46279889  
709 355 194711130GSW NBA 1 1948 11/13/1947 1 0 PRO Steamrollers 64 1333.8054 1328.9529 33.969322 PHW Warriors 79 1460.8939 1465.7465 A L 0.21295129999999998  
710 355 194711130GSW NBA 0 1948 11/13/1947 1 0 PHW Warriors 79 1460.8939 1465.7465 48.173626 PRO Steamrollers 64 1333.8054 1328.9529 H W 0.7870486999999999  
1131 566 194811010INJ NBA 1 1949 11/1/1948 1 0 STB Bombers 80 1429.9547 1424.4431 39.082115 INJ Jets 84 1366.0 1371.5116 A L 0.44831198  
1132 566 194811010INJ NBA 0 1949 11/1/1948 1 0 INJ Jets 84 1366.0 1371.5116 33.610058 STB Bombers 80 1429.9547 1424.4431 H W 0.55168802  
1133 567 194811030FTW NBA 0 1949 11/3/1948 1 0 FTW Pistons 76 1495.0 1484.7529 45.390053 NYK Knicks 80 1439.8278 1450.0748 H L 0.70955902  
1134 567 194811030FTW NBA 1 1949 11/3/1948 1 0 NYK Knicks 80 1439.8278 1450.0748 41.769276 FTW Pistons 76 1495.0 1484.7529 A W 0.29044098  
1135 568 194811030WSC NBA 1 1949 11/3/1948 1 0 PHW Warriors 70 1488.3862 1482.3667 45.142456 WSC Capitols 77 1472.1492 1478.1687 A L 0.38173789  
1136 568 194811030WSC NBA 0 1949 11/3/1948 1 0 WSC Capitols 77 1472.1492 1478.1687 44.706142 PHW Warriors 70 1488.3862 1482.3667 H W 0.61826211  
1137 569 194811040BLB NBA 1 1949 11/4/1948 1 0 MNL Lakers 84 1527.0 1542.2545 51.218754 BLB Baltimore 72 1507.2052 1491.9507 A W 0.38658303  
1138 569 194811040BLB NBA 0 1949 11/4/1948 1 0 BLB Baltimore 72 1507.2052 1491.9507 46.134853 MNL Lakers 84 1527.0 1542.2545 H L 0.61341697  
1139 570 194811040GSW NBA 1 1949 11/4/1948 1 0 BOS Celtics 73 1354.7399 1348.6487 31.316545 PHW Warriors 94 1482.3667 1488.4579 A L 0.21243238  
1141 571 194811040PRO NBA 0 1949 11/4/1948 1 0 PRO Steamrollers 95 1249.545 1245.8417 21.932465 WSC Capitols 99 1478.1687 1481.8721 H L 0.32291290000000006  
1146 573 194811060CHS NBA 0 1949 11/6/1948 1 0 CHS Stags 82 1448.0752 1457.9236 42.591865999999996 BLB Baltimore 69 1491.9507 1482.1023 H W 0.58007437  
1150 575 194811060ROC NBA 0 1949 11/6/1948 1 0 ROC Kings 69 1535.0 1538.0145 50.800514 INJ Jets 58 1356.3263 1353.3118 H W 0.83260107  
1891 946 194910290TRI NBA 0 1950 10/29/1949 1 0 TRI Hawks 93 1430.0 1433.1398 39.09774 DNN Denver 85 1295.0 1291.8602 H W 0.79458189  
1892 946 194910290TRI NBA 1 1950 10/29/1949 1 0 DNN Denver 85 1295.0 1291.8602 25.146364000000002 TRI Hawks 93 1430.0 1433.1398 A L 0.20541811  
1893 947 194911010CHS NBA 1 1950 11/1/1949 1 0 NYK Knicks 89 1472.8823 1480.7219 44.081707 CHS Stags 87 1528.5876 1520.7479999999998 A W 0.28980899  
1894 947 194911010CHS NBA 0 1950 11/1/1949 1 0 CHS Stags 87 1528.5876 1520.7479999999998 48.21035 NYK Knicks 89 1472.8823 1480.7219 H L 0.71019101  
1896 948 194911010INO NBA 0 1950 11/1/1949 1 0 INO Olympians 71 1300.0 1305.4078 26.370893 DNN Denver 64 1291.8602 1286.4524 H W 0.65078747  
1897 949 194911010ROC NBA 0 1950 11/1/1949 1 0 ROC Kings 108 1576.0588 1582.7472 54.292076 SHE Redskins 75 1405.0 1398.3116 H W 0.82640213  
1898 949 194911010ROC NBA 1 1950 11/1/1949 1 0 SHE Redskins 75 1405.0 1398.3116 35.476836999999996 ROC Kings 108 1576.0588 1582.7472 A L 0.17359787  
1900 950 194911010STB NBA 0 1950 11/1/1949 1 0 STB Bombers 72 1425.8921 1437.5544 39.560047 TRI Hawks 51 1433.1398 1421.4774 H W 0.63039815 at Chicago IL
1901 951 194911020GSW NBA 0 1950 11/2/1949 1 0 PHW Warriors 69 1451.6565 1441.7981 40.004787 MNL Lakers 81 1594.7988 1604.6572 H L 0.43823034  
1902 951 194911020GSW NBA 1 1950 11/2/1949 1 0 MNL Lakers 81 1594.7988 1604.6572 56.309998 PHW Warriors 69 1451.6565 1441.7981 A W 0.56176966  
1903 952 194911020WAT NBA 0 1950 11/2/1949 1 0 WAT Waterloo 60 1382.0 1372.8779 32.883759000000005 NYK Knicks 68 1480.7219 1489.844 H L 0.50183928  
1905 953 194911020WSC NBA 1 1950 11/2/1949 1 0 BLB Baltimore 61 1471.7623 1467.5098 42.700657 WSC Capitols 66 1493.5471 1497.7997 A L 0.33157957  
1906 953 194911020WSC NBA 0 1950 11/2/1949 1 0 WSC Capitols 66 1493.5471 1497.7997 45.85601 BLB Baltimore 61 1471.7623 1467.5098 H W 0.66842043  
1907 954 194911030AND NBA 0 1950 11/3/1949 1 0 AND Packers 110 1562.0 1568.0695 52.897949 TRI Hawks 87 1421.4774 1415.408 H W 0.79972225  
1911 956 194911030FTW NBA 0 1950 11/3/1949 1 0 FTW Pistons 87 1413.1147 1425.4482 38.293507 NYK Knicks 72 1489.844 1477.5105 H W 0.53343934  
1914 957 194911030SHE NBA 1 1950 11/3/1949 1 0 BOS Celtics 83 1411.5895 1402.0784 35.865272999999995 SHE Redskins 98 1398.3116 1407.8228 A L 0.37772566  
1916 958 194911030SYR NBA 0 1950 11/3/1949 1 0 SYR Sixers 78 1458.0 1462.6614 42.192721999999996 DNN Denver 58 1286.4524 1281.7910000000002 H W 0.82680541  
3077 1539 195010310ROC NBA 1 1951 10/31/1950 1 0 WSC Capitols 70 1441.0997 1438.463 34.702881 ROC Kings 78 1608.8955 1611.5322 A L 0.17630911  
3078 1539 195010310ROC NBA 0 1951 10/31/1950 1 0 ROC Kings 78 1608.8955 1611.5322 52.490947999999996 WSC Capitols 70 1441.0997 1438.463 H W 0.82369089  
3079 1540 195011010BLB NBA 1 1951 11/1/1950 1 0 MNL Lakers 71 1670.8335 1653.1713 56.384640000000005 BLB Baltimore 81 1396.1971 1413.8594 A L 0.73209691  
3080 1540 195011010BLB NBA 0 1951 11/1/1950 1 0 BLB Baltimore 81 1396.1971 1413.8594 32.210339000000005 MNL Lakers 71 1670.8335 1653.1713 H W 0.26790309  
3081 1541 195011010FTW NBA 1 1951 11/1/1950 1 0 BOS Celtics 84 1390.1046 1383.7520000000002 29.25205 FTW Pistons 107 1521.9481 1528.3008 A L 0.20839971  
3082 1541 195011010FTW NBA 0 1951 11/1/1950 1 0 FTW Pistons 107 1521.9481 1528.3008 44.070477000000004 BOS Celtics 84 1390.1046 1383.7520000000002 H W 0.79160029  
3083 1542 195011010WSC NBA 1 1951 11/1/1950 1 0 INO Olympians 84 1488.2722 1476.6953 38.665581 WSC Capitols 100 1438.463 1450.0398 A L 0.42826796  
3085 1543 195011020SYR NBA 0 1951 11/2/1950 1 0 SYR Sixers 92 1574.5078 1581.7687 49.557175 FTW Pistons 77 1528.3008 1521.0399 H W 0.6988095  
3088 1544 195011020TRI NBA 0 1951 11/2/1950 1 0 TRI Hawks 79 1443.1272 1449.6403 35.852406 BOS Celtics 65 1383.7520000000002 1377.2389 H W 0.71451974  
3092 1546 195011040GSW NBA 0 1951 11/4/1950 1 0 PHW Warriors 77 1441.1871 1446.0084 35.477894 BOS Celtics 68 1377.2389 1372.4176 H W 0.71985894  
3096 1548 195011040TRI NBA 1 1951 11/4/1950 1 0 NYK Knicks 76 1512.5427 1502.9863 41.420849 TRI Hawks 87 1449.6403 1459.1967 A L 0.4468143  
3837 1919 195111010ROC NBA 0 1952 11/1/1951 1 0 ROC Kings 101 1586.5313 1588.6106 49.126564 BLB Baltimore 97 1441.9478 1439.8684 H W 0.80344015  
3838 1919 195111010ROC NBA 1 1952 11/1/1951 1 0 BLB Baltimore 97 1441.9478 1439.8684 33.711441 ROC Kings 101 1586.5313 1588.6106 A L 0.19655985  
3839 1920 195111010SYR NBA 1 1952 11/1/1951 1 0 FTW Pistons 75 1476.9070000000002 1469.6881 36.776169 SYR Sixers 90 1524.3375 1531.5564 A L 0.29971015  
3840 1920 195111010SYR NBA 0 1952 11/1/1951 1 0 SYR Sixers 90 1524.3375 1531.5564 43.248577000000004 FTW Pistons 75 1476.9070000000002 1469.6881 H W 0.70028985  
3841 1921 195111030BLB NBA 1 1952 11/3/1951 1 0 INO Olympians 90 1496.0835 1503.4589999999998 40.303612 BLB Baltimore 86 1439.8684 1432.4929 A W 0.43731993  
3843 1922 195111030MLH NBA 1 1952 11/3/1951 1 0 NYK Knicks 68 1525.4413 1530.2721 43.114243 MLH Hawks 66 1425.3796 1420.5488 A W 0.50008869  
3844 1922 195111030MLH NBA 0 1952 11/3/1951 1 0 MLH Hawks 66 1425.3796 1420.5488 31.767611 NYK Knicks 68 1525.4413 1530.2721 H L 0.49991128  
3846 1923 195111030GSW NBA 0 1952 11/3/1951 1 0 PHW Warriors 70 1560.6174 1562.37 46.450592 FTW Pistons 69 1469.6881 1467.9355 H W 0.7500872  
3848 1924 195111030ROC NBA 1 1952 11/3/1951 1 0 MNL Lakers 93 1576.1448 1598.9502 50.162857 ROC Kings 74 1588.6106 1565.8052 A W 0.34357446  
3850 1925 195111040BOS NBA 0 1952 11/4/1951 1 0 BOS Celtics 97 1487.595 1503.9678 40.356964000000005 INO Olympians 65 1503.4589999999998 1487.0862 H W 0.61876881  
4547 2274 195210310INO NBA 1 1953 10/31/1952 1 0 BOS Celtics 83 1555.5466 1570.59 47.425594 INO Olympians 68 1486.719 1471.6757 A W 0.45525932  
4548 2274 195210310INO NBA 0 1953 10/31/1952 1 0 INO Olympians 68 1486.719 1471.6757 37.115009 BOS Celtics 83 1555.5466 1570.59 H L 0.54474068  
4549 2275 195211010MLH NBA 0 1953 11/1/1952 1 0 MLH Hawks 73 1378.7267 1383.434 28.280528999999998 INO Olympians 71 1471.6757 1466.9684 H W 0.51014584  
4552 2276 195211010LAL NBA 0 1953 11/1/1952 1 0 MNL Lakers 94 1612.1746 1615.2561 51.896282 BOS Celtics 91 1570.59 1567.5084 H W 0.69317955  
4553 2277 195211010NYK NBA 0 1953 11/1/1952 1 0 NYK Knicks 69 1570.6726 1574.1165 47.7859 BLB Baltimore 53 1371.7444 1368.3005 H W 0.84822786  
4554 2277 195211010NYK NBA 1 1953 11/1/1952 1 0 BLB Baltimore 53 1371.7444 1368.3005 26.863607000000002 NYK Knicks 69 1570.6726 1574.1165 A L 0.15177214  
4555 2278 195211010GSW NBA 0 1953 11/1/1952 1 0 PHW Warriors 86 1518.1163 1522.0605 42.387939 SYR Sixers 84 1565.7715 1561.8273 H W 0.57476544  
4556 2278 195211010GSW NBA 1 1953 11/1/1952 1 0 SYR Sixers 84 1565.7715 1561.8273 46.525993 PHW Warriors 86 1518.1163 1522.0605 A L 0.42523456  
4557 2279 195211010ROC NBA 0 1953 11/1/1952 1 0 ROC Kings 94 1561.0394 1566.0249 46.957664 FTW Pistons 82 1467.7277 1462.7422 H W 0.75264925  
4558 2279 195211010ROC NBA 1 1953 11/1/1952 1 0 FTW Pistons 82 1467.7277 1462.7422 36.188511 ROC Kings 94 1561.0394 1566.0249 A L 0.24735075  
5295 2648 195310300MLH NBA 0 1954 10/30/1953 1 0 MLH Hawks 69 1462.8175 1475.5382 37.012553999999994 MNL Lakers 59 1621.7465 1609.0258 H W 0.41599840000000005  
5296 2648 195310300MLH NBA 1 1954 10/30/1953 1 0 MNL Lakers 59 1621.7465 1609.0258 50.80835 MLH Hawks 69 1462.8175 1475.5382 A L 0.5840016  
5297 2649 195310310BLB NBA 0 1954 10/31/1953 1 0 BLB Baltimore 68 1343.9944 1339.9094 23.885912 ROC Kings 72 1551.0639999999999 1555.1489 H L 0.35061386 at New York NY
5298 2649 195310310BLB NBA 1 1954 10/31/1953 1 0 ROC Kings 72 1551.0639999999999 1555.1489 45.334461 BLB Baltimore 68 1343.9944 1339.9094 A W 0.64938617 at New York NY
5300 2650 195310310NYK NBA 0 1954 10/31/1953 1 0 NYK Knicks 91 1585.6575 1599.3954 49.850525 MNL Lakers 67 1609.0258 1595.2878 H W 0.60852766  
5301 2651 195310310GSW NBA 0 1954 10/31/1953 1 0 PHW Warriors 79 1375.87 1387.3020000000001 28.187664 SYR Sixers 73 1596.9908 1585.5588 H W 0.33242717  
5302 2651 195310310GSW NBA 1 1954 10/31/1953 1 0 SYR Sixers 73 1596.9908 1585.5588 48.456699 PHW Warriors 79 1375.87 1387.3020000000001 A L 0.66757286  
5306 2653 195311010BOS NBA 0 1954 11/1/1953 1 0 BOS Celtics 79 1568.1497 1559.1321 45.74715 MNL Lakers 84 1595.2878 1604.3054 H L 0.60334599  
5307 2654 195311010FTW NBA 0 1954 11/1/1953 1 0 FTW Pistons 77 1516.7598 1522.4897 41.924759 MLH Hawks 67 1475.5382 1469.8082 H W 0.69273496  
5989 2995 195410300MLH NBA 0 1955 10/30/1954 1 0 MLH Hawks 72 1433.0106 1415.1171 28.850603000000003 FTW Pistons 91 1498.0529999999999 1515.9465 H L 0.55013901  
5990 2995 195410300MLH NBA 1 1955 10/30/1954 1 0 FTW Pistons 91 1498.0529999999999 1515.9465 39.053024 MLH Hawks 72 1433.0106 1415.1171 A W 0.44986099  
5991 2996 195410300NYK NBA 1 1955 10/30/1954 1 0 MNL Lakers 83 1605.8107 1594.6711 47.260078 NYK Knicks 94 1502.6542 1513.7937 A L 0.50454247  
5992 2996 195410300NYK NBA 0 1955 10/30/1954 1 0 NYK Knicks 94 1502.6542 1513.7937 38.82777 MNL Lakers 83 1605.8107 1594.6711 H W 0.49545756  
5993 2997 195410300ROC NBA 0 1955 10/30/1954 1 0 ROC Kings 98 1579.9783 1583.5283 46.113815 BOS Celtics 95 1569.1133 1565.5632 H W 0.65434426  
5994 2997 195410300ROC NBA 1 1955 10/30/1954 1 0 BOS Celtics 95 1569.1133 1565.5632 44.249297999999996 ROC Kings 98 1579.9783 1583.5283 A L 0.34565574  
5997 2999 195410310SYR NBA 0 1955 10/31/1954 1 0 SYR Sixers 94 1601.1667 1593.2388 47.113251 MNL Lakers 97 1594.6711 1602.5991 H L 0.64863348  
6024 3012 195411130GSW NBA 0 1955 11/13/1954 1 0 PHW Warriors 87 1486.3865 1489.7424 36.323307 NYK Knicks 86 1538.2349 1534.8789 H W 0.56885546  
6607 3304 195511050BOS NBA 1 1956 11/5/1955 1 0 PHW Warriors 87 1523.7709 1515.4177 39.770626 BOS Celtics 98 1493.8099 1502.1631 A L 0.40054923  
6608 3304 195511050BOS NBA 0 1956 11/5/1955 1 0 BOS Celtics 98 1493.8099 1502.1631 38.383465 PHW Warriors 87 1523.7709 1515.4177 H W 0.59945077  
6609 3305 195511050ROC NBA 1 1956 11/5/1955 1 0 NYK Knicks 100 1529.5782 1535.8473 41.913074 ROC Kings 98 1506.4336 1500.1646 A W 0.39116567  
6610 3305 195511050ROC NBA 0 1956 11/5/1955 1 0 ROC Kings 98 1506.4336 1500.1646 38.174751 NYK Knicks 100 1529.5782 1535.8473 H L 0.60883433  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "nba-elo/nbaallelo" (
"gameorder" INTEGER,
  "game_id" TEXT,
  "lg_id" TEXT,
  "_iscopy" INTEGER,
  "year_id" INTEGER,
  "date_game" TEXT,
  "seasongame" INTEGER,
  "is_playoffs" INTEGER,
  "team_id" TEXT,
  "fran_id" TEXT,
  "pts" INTEGER,
  "elo_i" REAL,
  "elo_n" REAL,
  "win_equiv" REAL,
  "opp_id" TEXT,
  "opp_fran" TEXT,
  "opp_pts" INTEGER,
  "opp_elo_i" REAL,
  "opp_elo_n" REAL,
  "game_location" TEXT,
  "game_result" TEXT,
  "forecast" REAL,
  "notes" REAL
);
Powered by Datasette · Query took 3604.18ms