nba-elo/nbaallelo

126,314 rows sorted by team_id

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
15164 7582 196710130OAK ABA 1 1968 10/13/1967 1 0 ANA Stars 129 1300.0 1295.3092 40.507979999999996 OAK Squires 134 1300.0 1304.6908 A L 0.35993499  
15173 7587 196710150DNR ABA 1 1968 10/15/1967 2 0 ANA Stars 105 1295.3092 1290.7152 40.026249 DNR Nuggets 110 1300.0 1304.594 A L 0.35373795  
15176 7588 196710160DLC ABA 1 1968 10/16/1967 3 0 ANA Stars 125 1290.7152 1286.6707 39.602352 DLC Spurs 129 1300.0 1304.0446 A L 0.34771603  
15194 7597 196710180INA ABA 1 1968 10/18/1967 4 0 ANA Stars 103 1286.6707 1283.3418 39.253685 INA Pacers 106 1311.6714 1315.0002 A L 0.32748944  
15245 7623 196710240KEN ABA 1 1968 10/24/1967 5 0 ANA Stars 127 1283.3418 1280.738 38.98114 KEN Colonels 128 1291.0062 1293.61 A L 0.34983462  
15263 7632 196710260MNM ABA 1 1968 10/26/1967 6 0 ANA Stars 115 1280.738 1301.3052 41.136906 MNM Floridians 99 1298.1259 1277.5587 A W 0.33721304  
15301 7651 196710290ANA ABA 0 1968 10/29/1967 7 0 ANA Stars 120 1301.3052 1293.1298 40.279415 OAK Squires 123 1284.0656 1292.241 H L 0.66259623  
15315 7658 196710310ANA ABA 0 1968 10/31/1967 8 0 ANA Stars 126 1293.1298 1296.8416 40.668701 OAK Squires 123 1292.241 1288.5292 H W 0.64124286  
15350 7675 196711030ANA ABA 0 1968 11/3/1967 9 0 ANA Stars 101 1296.8416 1302.8945 41.303619 PTP Condors 94 1314.3656 1308.3126 H W 0.61651206  
15362 7681 196711040KEN ABA 1 1968 11/4/1967 10 0 ANA Stars 103 1302.8945 1299.8959 40.989079 KEN Colonels 104 1278.2001 1281.1987 A L 0.39329243  
15368 7684 196711050MNM ABA 1 1968 11/5/1967 11 0 ANA Stars 92 1299.8959 1287.1482 39.652390000000004 MNM Floridians 119 1312.7910000000002 1325.5387 A L 0.34301734  
15369 7685 196711060DNR ABA 1 1968 11/6/1967 12 0 ANA Stars 100 1287.1482 1276.1624 38.502632 DNR Nuggets 121 1293.4159 1304.4017 A L 0.35166556  
15395 7698 196711080ANA ABA 0 1968 11/8/1967 13 0 ANA Stars 104 1276.1624 1280.1251 38.917007 HSM Spirits 100 1262.3458 1258.3831 H W 0.65817696  
15454 7727 196711130NOB ABA 1 1968 11/13/1967 14 0 ANA Stars 98 1280.1251 1275.9995 38.485615 NOB Sounds 106 1361.6558 1365.7814 A L 0.26019132  
15466 7733 196711140HSM ABA 1 1968 11/14/1967 15 0 ANA Stars 106 1275.9995 1269.8097 37.839455 HSM Spirits 113 1253.2532 1259.443 A L 0.39061975  
15480 7740 196711150DLC ABA 1 1968 11/15/1967 16 0 ANA Stars 116 1269.8097 1285.7997 39.511105 DLC Spurs 105 1284.5745 1268.5845 A W 0.34059608  
15521 7761 196711190ANA ABA 0 1968 11/19/1967 17 0 ANA Stars 100 1285.7997 1278.5458 38.751804 OAK Squires 102 1259.1611 1266.415 H L 0.67458361  
15543 7772 196711210ANA ABA 0 1968 11/21/1967 18 0 ANA Stars 101 1278.5458 1268.3243 37.68462 MNM Floridians 110 1365.0682 1375.2897 H L 0.51938599  
15578 7789 196711230OAK ABA 1 1968 11/23/1967 19 0 ANA Stars 107 1268.3243 1284.8024 39.406639 OAK Squires 95 1274.3357 1257.8577 A W 0.35200208  
15605 7803 196711250ANA ABA 0 1968 11/25/1967 20 0 ANA Stars 98 1284.8024 1267.7312 37.622814 NOB Sounds 118 1373.4373 1390.5084 H L 0.51634985 at Memphis TN
15613 7807 196711260DLC ABA 1 1968 11/26/1967 21 0 ANA Stars 102 1267.7312 1260.4603 36.866554 DLC Spurs 114 1282.1656 1289.4365 A L 0.34102327  
15638 7819 196711280NJA ABA 1 1968 11/28/1967 22 0 ANA Stars 110 1260.4603 1271.2555 37.990253 NJA Nets 104 1261.5808 1250.7856 A W 0.35845035  
15651 7826 196711290NJA ABA 1 1968 11/29/1967 23 0 ANA Stars 101 1271.2555 1266.1277 37.455814000000004 NJA Nets 106 1250.7856 1255.9135 A L 0.38750494  
15682 7841 196712020INA ABA 1 1968 12/2/1967 24 0 ANA Stars 117 1266.1277 1260.1046 36.829624 INA Pacers 132 1350.7988 1356.8219 A L 0.25672656  
15686 7843 196712030DNR ABA 1 1968 12/3/1967 25 0 ANA Stars 87 1260.1046 1253.8209 36.178432 DNR Nuggets 100 1316.8529 1323.1366 A L 0.28857487  
15723 7862 196712060HSM ABA 1 1968 12/6/1967 26 0 ANA Stars 124 1253.8209 1279.4147 38.842686 HSM Spirits 100 1249.6437 1224.0499 A W 0.36549324  
15747 7874 196712080DLC ABA 1 1968 12/8/1967 27 0 ANA Stars 110 1279.4147 1270.507 37.91217 DLC Spurs 123 1259.4767 1268.3844 A L 0.38677853  
15761 7881 196712090DNR ABA 1 1968 12/9/1967 28 0 ANA Stars 96 1270.507 1260.808 36.902653 DNR Nuggets 116 1296.7234 1306.4224 A L 0.32595003  
15787 7894 196712120ANA ABA 0 1968 12/12/1967 29 0 ANA Stars 98 1260.808 1237.9097 34.541237 NJA Nets 117 1246.9158 1269.8142 H L 0.65827495  
15810 7905 196712140ANA ABA 0 1968 12/14/1967 30 0 ANA Stars 96 1237.9097 1243.0449 35.067593 DNR Nuggets 93 1315.3417 1310.2064 H W 0.53243238 at Fresno CA
15841 7921 196712160ANA ABA 0 1968 12/16/1967 31 0 ANA Stars 107 1243.0449 1254.105 36.207821 NOB Sounds 100 1424.1737 1413.1136 H W 0.38532305 at Fullerton CA
15888 7944 196712200ANA ABA 0 1968 12/20/1967 32 0 ANA Stars 142 1254.105 1248.1107 35.588799 INA Pacers 144 1291.4552 1297.4495 H L 0.58919561 at Fresno CA
15913 7957 196712220ANA ABA 0 1968 12/22/1967 33 0 ANA Stars 108 1248.1107 1254.5182 36.250576 DNR Nuggets 102 1299.4559 1293.0485 H W 0.56956571 at Fullerton CA
15926 7963 196712230OAK ABA 1 1968 12/23/1967 34 0 ANA Stars 126 1254.5182 1281.4427 39.05489 OAK Squires 103 1278.4775 1251.553 A W 0.32881105 at Fullerton CA
15949 7975 196712260ANA ABA 0 1968 12/26/1967 35 0 ANA Stars 93 1281.4427 1264.0281 37.237324 NOB Sounds 120 1420.9617 1438.3763 H L 0.44337171 at Indianapolis IN
15972 7986 196712280HSM ABA 1 1968 12/28/1967 36 0 ANA Stars 93 1264.0281 1255.0552 36.306156 HSM Spirits 104 1216.7957 1225.7686 A L 0.42463988  
15987 7994 196712290ANA ABA 0 1968 12/29/1967 37 0 ANA Stars 122 1255.0552 1262.631 37.092056 NJA Nets 109 1238.2958 1230.72 H W 0.66197795 at Fullerton CA
16031 8016 196801020OAK ABA 1 1968 1/2/1968 38 0 ANA Stars 121 1262.631 1249.8999 35.773315000000004 OAK Squires 141 1226.8772 1239.6083 A L 0.40858185 at Richmond CA
16043 8022 196801030ANA ABA 0 1968 1/3/1968 39 0 ANA Stars 122 1249.8999 1258.6732 36.681087 INA Pacers 111 1291.646 1282.8727 H W 0.58305722  
16065 8033 196801050ANA ABA 0 1968 1/5/1968 40 0 ANA Stars 124 1258.6732 1262.8121 37.110886 INA Pacers 121 1282.8727 1278.7338 H W 0.6073873000000001  
16091 8046 196801070ANA ABA 0 1968 1/7/1968 41 0 ANA Stars 102 1262.8121 1238.5471 34.606460999999996 NJA Nets 121 1228.0592 1252.3242 H L 0.6847526999999999  
16127 8064 196801100HSM ABA 1 1968 1/10/1968 42 0 ANA Stars 120 1238.5471 1235.1085 34.255028 HSM Spirits 122 1223.5713 1227.0099 A L 0.38002586  
16140 8070 196801110NOB ABA 1 1968 1/11/1968 43 0 ANA Stars 124 1235.1085 1232.2118 33.959763 NOB Sounds 131 1370.9309 1373.8276 A L 0.20464647 at Monroe LA
16154 8077 196801120ANA ABA 0 1968 1/12/1968 44 0 ANA Stars 108 1232.2118 1218.4058 32.563324 KEN Colonels 117 1225.6501 1239.4562 H L 0.64872015  
16171 8086 196801140ANA ABA 0 1968 1/14/1968 45 0 ANA Stars 123 1218.4058 1210.1785 31.740545 DLC Spurs 130 1324.4298 1332.6571 H L 0.49133158  
16208 8104 196801170ANA ABA 0 1968 1/17/1968 46 0 ANA Stars 115 1210.1785 1205.2581 31.252153000000003 MNM Floridians 119 1374.1781 1379.0985 H L 0.40892491  
16231 8116 196801190ANA ABA 0 1968 1/19/1968 47 0 ANA Stars 110 1205.2581 1199.1129 30.646307 DNR Nuggets 117 1384.2107 1390.3558 H L 0.38829425  
16259 8130 196801210ANA ABA 0 1968 1/21/1968 48 0 ANA Stars 85 1199.1129 1185.0791 29.281065 DNR Nuggets 112 1390.3558 1404.3896 H L 0.37162858  
16275 8138 196801240ANA ABA 0 1968 1/24/1968 49 0 ANA Stars 106 1185.0791 1192.1238 29.963089 HSM Spirits 96 1189.2222 1182.1775 H W 0.63455236  
16298 8149 196801250OAK ABA 1 1968 1/25/1968 50 0 ANA Stars 124 1192.1238 1206.5997 31.385042 OAK Squires 115 1215.3651 1200.8892 A W 0.32972389  
16307 8154 196801260ANA ABA 0 1968 1/26/1968 51 0 ANA Stars 93 1206.5997 1199.9192 30.725531 KEN Colonels 96 1255.479 1262.1595 H L 0.57304227  
16334 8167 196801280ANA ABA 0 1968 1/28/1968 52 0 ANA Stars 115 1199.9192 1195.0713 30.250443 DLC Spurs 118 1337.2277 1342.0756 H L 0.44651422  
16370 8185 196801310ANA ABA 0 1968 1/31/1968 53 0 ANA Stars 112 1195.0713 1207.7314 31.497301 DNR Nuggets 105 1422.5819 1409.9218 H W 0.32431534  
16398 8199 196802020ANA ABA 0 1968 2/2/1968 54 0 ANA Stars 101 1207.7314 1190.989 29.852767999999998 NOB Sounds 128 1357.0505 1373.793 H L 0.42949703  
16426 8213 196802040ANA ABA 0 1968 2/4/1968 55 0 ANA Stars 132 1190.989 1198.1317 30.550009000000003 HSM Spirits 120 1172.6403 1165.4976 H W 0.66402215  
16478 8239 196802080ANA ABA 0 1968 2/8/1968 56 0 ANA Stars 122 1198.1317 1206.5432 31.379440000000002 NOB Sounds 118 1383.0504 1374.6389 H W 0.38016891  
16504 8252 196802100ANA ABA 0 1968 2/10/1968 57 0 ANA Stars 112 1206.5432 1199.5371 30.687977000000004 PTP Condors 120 1372.5114 1379.5175 H L 0.40618885 at Los Angeles CA
16528 8264 196802120ANA ABA 0 1968 2/12/1968 58 0 ANA Stars 145 1199.5371 1203.4292 31.071362 HSM Spirits 142 1209.4457 1205.5536 H W 0.62682223  
16546 8273 196802130ANA ABA 0 1968 2/13/1968 59 0 ANA Stars 100 1203.4292 1197.3235 30.470778999999997 KEN Colonels 104 1312.8994 1319.0051 H L 0.48637465  
16572 8286 196802150DNR ABA 1 1968 2/15/1968 60 0 ANA Stars 108 1197.3235 1191.0834 29.861937 DNR Nuggets 142 1385.1335 1391.3737 A L 0.16019636  
16589 8295 196802160NJA ABA 1 1968 2/16/1968 61 0 ANA Stars 119 1191.0834 1186.6123 29.428917 NJA Nets 130 1295.0179 1299.489 A L 0.23614323  
16602 8301 196802170DLC ABA 1 1968 2/17/1968 62 0 ANA Stars 100 1186.6123 1183.9836 29.175628999999997 DLC Spurs 107 1340.7725 1343.4011 A L 0.18799925  
16643 8322 196802200PTP ABA 1 1968 2/20/1968 63 0 ANA Stars 114 1183.9836 1181.9911 28.984284999999996 PTP Condors 121 1388.9968 1390.9894 A L 0.14731753  
16659 8330 196802220MNM ABA 1 1968 2/22/1968 64 0 ANA Stars 112 1181.9911 1178.1559 28.617607 MNM Floridians 128 1361.3143 1365.1495 A L 0.16687846  
16693 8347 196802250ANA ABA 0 1968 2/25/1968 65 0 ANA Stars 114 1178.1559 1184.0159 29.178728000000003 HSM Spirits 109 1230.7148 1224.8549 H W 0.56785196 at Los Angeles CA
16713 8357 196802270ANA ABA 0 1968 2/27/1968 66 0 ANA Stars 132 1184.0159 1204.144 31.141979 DLC Spurs 110 1323.5118 1303.3837 H W 0.44340432  
16745 8373 196803010NOB ABA 1 1968 3/1/1968 67 0 ANA Stars 114 1204.144 1202.2831 30.958269 NOB Sounds 118 1369.5006 1371.3616 A L 0.17835754  
16754 8377 196803020INA ABA 1 1968 3/2/1968 68 0 ANA Stars 119 1202.2831 1199.1216 30.647159999999996 INA Pacers 124 1286.1082 1289.2697 A L 0.25765699  
16767 8384 196803030ANA ABA 0 1968 3/3/1968 69 0 ANA Stars 114 1199.1216 1187.5048 29.515131 DLC Spurs 126 1299.5743 1311.1912 H L 0.49934843  
16793 8397 196803050ANA ABA 0 1968 3/5/1968 70 0 ANA Stars 110 1187.5048 1180.3604 28.828112 PTP Condors 123 1417.0476 1424.192 H L 0.32175711  
16819 8410 196803070ANA ABA 0 1968 3/7/1968 71 0 ANA Stars 115 1180.3604 1173.6699 28.191465 MNM Floridians 124 1373.3782 1380.0686 H L 0.36924583  
16864 8432 196803100ANA ABA 0 1968 3/10/1968 72 0 ANA Stars 110 1173.6699 1169.7904 27.825384000000003 DLC Spurs 112 1330.0583 1333.9379 H L 0.4195556  
16927 8464 196803150OAK ABA 1 1968 3/15/1968 73 0 ANA Stars 116 1169.7904 1176.4884 28.458857000000002 OAK Squires 113 1121.7024 1115.0044 A W 0.42584366  
16948 8474 196803170KEN ABA 1 1968 3/17/1968 74 0 ANA Stars 107 1176.4884 1173.7772 28.201624 KEN Colonels 115 1339.1093 1341.8204 A L 0.18067706  
16959 8480 196803180ANA ABA 0 1968 3/18/1968 75 0 ANA Stars 118 1173.7772 1164.9524 27.372126 PTP Condors 135 1396.2147 1405.0396 H L 0.33074734 at Steubenville OH
16976 8488 196803190PTP ABA 1 1968 3/19/1968 76 0 ANA Stars 122 1164.9524 1160.9069 26.995958 PTP Condors 150 1405.0396 1409.0851 A L 0.12371629  
16990 8495 196803210ANA ABA 0 1968 3/21/1968 77 0 ANA Stars 89 1160.9069 1151.8086 26.159731 NOB Sounds 105 1367.5394 1376.6377 H L 0.35118684  
17016 8508 196803240ANA ABA 0 1968 3/24/1968 78 0 ANA Stars 147 1151.8086 1157.6787 26.697693 OAK Squires 135 1091.6445 1085.7744 H W 0.71544504  
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  
1939 970 194911080AND NBA 0 1950 11/8/1949 2 0 AND Packers 70 1568.0695 1571.3346 53.210838 STB Bombers 62 1440.5537 1437.2886 H W 0.78746057 at Richmond IN
1946 973 194911090AND NBA 0 1950 11/9/1949 3 0 AND Packers 102 1571.3346 1572.9993 53.369766000000006 TRI Hawks 99 1408.1772 1406.5126 H W 0.81977969 at Chicago IL
1971 986 194911120AND NBA 0 1950 11/12/1949 4 0 AND Packers 69 1572.9993 1549.3115 51.071995 SYR Sixers 84 1484.7279999999998 1508.4158 H L 0.74720794  
1996 998 194911130WAT NBA 1 1950 11/13/1949 5 0 AND Packers 81 1549.3115 1557.7991 51.904007 WAT Waterloo 69 1370.0243 1361.5367 A W 0.61216313  
2001 1001 194911150INO NBA 1 1950 11/15/1949 6 0 AND Packers 83 1557.7991 1564.4818 52.552402 INO Olympians 72 1336.9576 1330.2749 A W 0.66721576  
2032 1016 194911190AND NBA 0 1950 11/19/1949 7 0 AND Packers 83 1564.4818 1568.9064 52.97829399999999 MNL Lakers 80 1604.5997 1600.1752 H W 0.58533394  
2058 1029 194911210AND NBA 0 1950 11/21/1949 8 0 AND Packers 85 1568.9064 1541.9463 50.342751 BOS Celtics 99 1401.1996 1428.1597 H L 0.82361645  
2083 1042 194911240SYR NBA 1 1950 11/24/1949 9 0 AND Packers 123 1541.9463 1538.5710000000001 50.006432000000004 SYR Sixers 125 1531.2618 1534.6371 A L 0.37422311  
2087 1044 194911260AND NBA 0 1950 11/26/1949 10 0 AND Packers 73 1538.5710000000001 1542.7506 50.422703000000006 STB Bombers 63 1433.0371 1428.8575 H W 0.76551342  
2105 1053 194911270SHE NBA 1 1950 11/27/1949 11 0 AND Packers 111 1542.7506 1557.4713 51.872046999999995 SHE Redskins 91 1414.535 1399.8143 A W 0.54051644  
2113 1057 194911280AND NBA 0 1950 11/28/1949 12 0 AND Packers 101 1557.4713 1560.1324 52.131091999999995 WAT Waterloo 87 1328.3079 1325.6467 H W 0.86930382  
2132 1066 194912010AND NBA 0 1950 12/1/1949 13 0 AND Packers 81 1560.1324 1562.7521 52.385159 TRI Hawks 72 1378.3243 1375.7047 H W 0.83510077  
2170 1085 194912050AND NBA 0 1950 12/5/1949 14 0 AND Packers 88 1562.7521 1565.1198 52.613979 SHE Redskins 81 1389.1616 1386.7939 H W 0.82848293  
2185 1093 194912080AND NBA 0 1950 12/8/1949 15 0 AND Packers 69 1565.1198 1553.181 51.452457 INO Olympians 72 1388.1912 1400.1299 H L 0.83119625  
2210 1105 194912100WAT NBA 1 1950 12/10/1949 16 0 AND Packers 87 1553.181 1557.036 51.829586 WAT Waterloo 83 1333.2892 1329.4342 A W 0.66600096  
2221 1111 194912120AND NBA 0 1950 12/12/1949 17 0 AND Packers 105 1557.036 1560.9803 52.213428 FTW Pistons 97 1466.4883 1462.5439 H W 0.74967521  
2239 1120 194912150AND NBA 0 1950 12/15/1949 18 0 AND Packers 100 1560.9803 1569.1229 52.99906899999999 SYR Sixers 88 1572.0679 1563.9253 H W 0.62523335  
2264 1132 194912170SHE NBA 1 1950 12/17/1949 19 0 AND Packers 91 1569.1229 1547.1969 50.863293 SHE Redskins 110 1370.2045 1392.1305 A L 0.63862944  
2275 1138 194912180TRI NBA 1 1950 12/18/1949 20 0 AND Packers 78 1547.1969 1554.3915 51.571083 TRI Hawks 69 1371.0132 1363.8186 A W 0.60791314  
2278 1139 194912190AND NBA 0 1950 12/19/1949 21 0 AND Packers 83 1554.3915 1546.9841 50.842262 NYK Knicks 86 1570.7195 1578.1268 H L 0.61813855  
2298 1149 194912220AND NBA 0 1950 12/22/1949 22 0 AND Packers 101 1546.9841 1549.9586 51.13575 WAT Waterloo 84 1314.5013 1311.5269 H W 0.87145942  

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