nba-elo/nbaallelo

126,314 rows sorted by opp_pts

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
26686 13343 197210260VIR ABA 0 1973 10/26/1972 8 0 VIR Squires 2 1484.1907 1487.0829999999999 43.514412 DNR Nuggets 0 1460.3387 1457.4464 H W 0.67105246 at Richmond VA; forfeit to VIR
26685 13343 197210260VIR ABA 1 1973 10/26/1972 7 0 DNR Nuggets 0 1460.3387 1457.4464 40.408863000000004 VIR Squires 2 1484.1907 1487.0829999999999 A L 0.32894754 at Richmond VA; forfeit to VIR
3192 1596 195011220LAL NBA 1 1951 11/22/1950 12 0 FTW Pistons 19 1487.9486 1496.4873 40.739146999999996 MNL Lakers 18 1659.4946 1650.9559 A W 0.17319589999999999  
3191 1596 195011220LAL NBA 0 1951 11/22/1950 10 0 MNL Lakers 18 1659.4946 1650.9559 56.184555 FTW Pistons 19 1487.9486 1496.4873 H L 0.8268040999999999  
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  
322 161 194701160BOS NBA 0 1947 1/16/1947 30 0 BOS Celtics 47 1207.0247 1222.4307 32.968486999999996 WSC Capitols 38 1453.2283 1437.8223 H W 0.30119461  
129 65 194611300WSC NBA 0 1947 11/30/1946 12 0 WSC Capitols 49 1369.4651 1373.3796 48.608025 PIT Ironmen 40 1263.6439 1259.7294 H W 0.76581007  
630 315 194703230STB NBA 0 1947 3/23/1947 58 0 STB Bombers 60 1363.1570000000002 1368.1692 48.079014 TRH Huskies 40 1205.0825 1200.0703 H W 0.81541634  
342 171 194701210GSW NBA 0 1947 1/21/1947 30 0 PHW Warriors 59 1327.6796 1333.3901 44.49398 BOS Celtics 43 1223.8215 1218.111 H W 0.76377726  
351 176 194701230BOS NBA 0 1947 1/23/1947 34 0 BOS Celtics 48 1218.111 1222.9237 33.018229999999996 PIT Ironmen 43 1223.941 1219.1283 H W 0.63229746  
136 68 194612020PIT NBA 1 1947 12/2/1946 14 0 BOS Celtics 46 1228.6831 1236.0254 34.348637 PIT Ironmen 44 1259.7294 1252.3871 A W 0.31987137  
166 83 194612080NYK NBA 0 1947 12/8/1946 16 0 NYK Knicks 62 1359.2839 1364.1929 47.673653 BOS Celtics 44 1210.9467 1206.0377 H W 0.80683029  
211 106 194612190GSW NBA 0 1947 12/19/1946 16 0 PHW Warriors 58 1302.3259 1311.8464 42.242256 CLR Rebels 44 1326.4893 1316.9688 H W 0.6074369000000001  
330 165 194701180NYK NBA 1 1947 1/18/1947 31 0 BOS Celtics 58 1222.4307 1244.5959 35.226974 NYK Knicks 45 1322.4481 1300.2828 A W 0.24023473  
30 15 194611090DTF NBA 0 1947 11/9/1946 4 0 DTF Falcons 69 1268.4468 1281.5839999999998 39.069672 BOS Celtics 46 1288.4139 1275.2767 H W 0.61318165  
86 43 194611230DTF NBA 0 1947 11/23/1946 9 0 DTF Falcons 54 1282.0223 1287.39 39.677727000000004 BOS Celtics 46 1255.4705 1250.1028 H W 0.67447406  
99 50 194611250PIT NBA 1 1947 11/25/1946 9 0 NYK Knicks 62 1309.9252 1327.9469 43.926521 PIT Ironmen 46 1282.9152 1264.8934 A W 0.39647746  
101 51 194611260DTF NBA 0 1947 11/26/1946 11 0 DTF Falcons 66 1306.6039 1317.7588 42.861538 CLR Rebels 46 1311.4692 1300.3143 H W 0.63358766  
135 68 194612020PIT NBA 0 1947 12/2/1946 14 0 PIT Ironmen 44 1259.7294 1252.3871 36.030174 BOS Celtics 46 1228.6831 1236.0254 H L 0.68012863  
141 71 194612040PIT NBA 1 1947 12/4/1946 15 0 CHS Stags 57 1304.1698 1317.2023 42.803276000000004 PIT Ironmen 46 1252.3871 1239.3546 A W 0.43105185  
198 99 194612150STB NBA 1 1947 12/15/1946 18 0 TRH Huskies 50 1232.2332 1243.2317 35.086777000000005 STB Bombers 46 1315.6809 1304.6824 A W 0.25807267  
229 115 194612260GSW NBA 0 1947 12/26/1946 18 0 PHW Warriors 53 1307.2515 1311.3928 42.194717 PIT Ironmen 46 1242.0328 1237.8915 H W 0.7213313  
362 181 194701250NYK NBA 1 1947 1/25/1947 35 0 BOS Celtics 52 1222.9237 1236.2783 34.374474 NYK Knicks 46 1303.5112 1290.1566 A W 0.26123774  
409 205 194702050DTF NBA 1 1947 2/5/1947 38 0 WSC Capitols 67 1463.4370000000001 1473.5576 58.096309999999995 DTF Falcons 46 1239.0707 1228.9501 A W 0.67170578  
412 206 194702050NYK NBA 1 1947 2/5/1947 38 0 STB Bombers 71 1344.474 1365.7910000000002 47.836739 NYK Knicks 46 1274.2264 1252.9094 A W 0.45728713  
425 213 194702080NYK NBA 0 1947 2/8/1947 39 0 NYK Knicks 69 1249.8612 1260.5216 36.872917 TRH Huskies 46 1222.8718 1212.2114 H W 0.67502677  
1114 557 194804060STB NBA 1 1948 4/6/1948 55 1 PHW Warriors 85 1456.1172 1491.2869 50.73772 STB Bombers 46 1440.1093 1404.9396 A W 0.38142663  
4649 2325 195211230MLH NBA 1 1953 11/23/1952 12 0 MNL Lakers 62 1649.5146 1655.5995 55.711048 MLH Hawks 46 1358.2266 1352.1417 A W 0.75047415  
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  
134 67 194612010CLR NBA 0 1947 12/1/1946 11 0 CLR Rebels 49 1313.3292 1316.7987 42.761024 DTF Falcons 47 1330.3809 1326.9114 H W 0.61715478  
160 80 194612070STB NBA 1 1947 12/7/1946 10 0 PHW Warriors 57 1296.8409 1313.6263 42.428764 STB Bombers 47 1351.3506 1334.5652 A W 0.2912277  
207 104 194612180WSC NBA 0 1947 12/18/1946 18 0 WSC Capitols 68 1414.1184 1421.2426 53.325019999999995 STB Bombers 47 1317.0259 1309.9017 H W 0.7566786999999999  
321 161 194701160BOS NBA 1 1947 1/16/1947 30 0 WSC Capitols 38 1453.2283 1437.8223 54.886154000000005 BOS Celtics 47 1207.0247 1222.4307 A L 0.69880539  
345 173 194701220DTF NBA 1 1947 1/22/1947 31 0 CLR Rebels 61 1297.6993 1314.5339 42.523842 DTF Falcons 47 1277.3961 1260.5615 A W 0.38727731  
981 491 194802140NYK NBA 0 1948 2/14/1948 38 0 NYK Knicks 78 1442.4573 1455.2257 47.09903 PHW Warriors 47 1408.0973 1395.3289 H W 0.68426418  
2552 1276 195001220STB NBA 0 1950 1/22/1950 39 0 STB Bombers 71 1427.5410000000002 1440.4321 39.861603 BOS Celtics 47 1436.1504 1423.2593 H W 0.62856996  
66 33 194611180PIT NBA 0 1947 11/18/1946 7 0 PIT Ironmen 54 1274.5563 1280.0704 38.911285 TRH Huskies 48 1290.0051 1284.491 H W 0.61933237  
246 123 194612290DTF NBA 1 1947 12/29/1946 22 0 TRH Huskies 52 1233.9374 1244.1897 35.185210999999995 DTF Falcons 48 1289.309 1279.0566 A W 0.29020458  
261 131 194701010PIT NBA 1 1947 1/1/1947 24 0 CLR Rebels 61 1282.6403 1297.225 40.708915999999995 PIT Ironmen 48 1232.5814 1217.9967 A W 0.42861980000000005  
352 176 194701230BOS NBA 1 1947 1/23/1947 32 0 PIT Ironmen 43 1223.941 1219.1283 32.635933 BOS Celtics 48 1218.111 1222.9237 A L 0.36770254  
396 198 194702010STB NBA 0 1947 2/1/1947 36 0 STB Bombers 70 1342.0918 1352.7769 46.502655 CLR Rebels 48 1322.4463 1311.7612 H W 0.66568542  
415 208 194702060BOS NBA 0 1947 2/6/1947 40 0 BOS Celtics 49 1224.339 1227.3872 33.469673 NYK Knicks 48 1252.9094 1249.8612 H W 0.60137117  
451 226 194702130GSW NBA 0 1947 2/13/1947 42 0 PHW Warriors 61 1371.4485 1377.009 48.974979 CLR Rebels 48 1289.6622 1284.1017 H W 0.7400918000000001  
530 265 194703010NYK NBA 0 1947 3/1/1947 48 0 NYK Knicks 63 1266.6016 1274.8856 38.369232000000004 TRH Huskies 48 1248.7762 1240.4922 H W 0.66334957  
849 425 194801010STB NBA 0 1948 1/1/1948 18 0 STB Bombers 58 1425.0715 1429.0157 44.387572999999996 BOS Celtics 48 1308.2306 1304.2864 H W 0.77699447  
895 448 194801180CHS NBA 0 1948 1/18/1948 23 0 CHS Stags 72 1470.2111 1476.4993 49.261505 BOS Celtics 48 1330.6771 1324.3889 H W 0.79880917  
941 471 194801310WSC NBA 0 1948 1/31/1948 29 0 WSC Capitols 54 1454.9012 1460.1292 47.601032000000004 CHS Stags 48 1458.1167 1452.8888 H W 0.63578975  
17 9 194611050DTF NBA 1 1947 11/5/1946 2 0 STB Bombers 53 1304.6908 1312.8473 42.347137 DTF Falcons 49 1279.6189 1271.4624 A W 0.39381099  
52 26 194611160BOS NBA 0 1947 11/16/1946 6 0 BOS Celtics 53 1267.1501 1271.9004 38.057545000000005 TRH Huskies 49 1294.7554 1290.0051 H W 0.60270238  
130 65 194611300WSC NBA 1 1947 11/30/1946 13 0 PIT Ironmen 40 1263.6439 1259.7294 36.790672 WSC Capitols 49 1369.4651 1373.3796 A L 0.23418993  
133 67 194612010CLR NBA 1 1947 12/1/1946 14 0 DTF Falcons 47 1330.3809 1326.9114 43.818432 CLR Rebels 49 1313.3292 1316.7987 A L 0.38284522  
181 91 194612120GSW NBA 1 1947 12/12/1946 16 0 WSC Capitols 64 1392.4739 1407.4528 51.995701000000004 PHW Warriors 49 1322.4008 1307.4219 A W 0.45703799  
204 102 194612170GSW NBA 0 1947 12/17/1946 15 0 PHW Warriors 57 1296.1072 1302.3259 41.243977 DTF Falcons 49 1302.2896 1296.0708 H W 0.6318258000000001  
241 121 194612280WSC NBA 0 1947 12/28/1946 21 0 WSC Capitols 70 1435.3077 1442.3615 55.306006999999994 NYK Knicks 49 1336.2484 1329.1947 H W 0.75875711  
279 140 194701060PIT NBA 1 1947 1/6/1947 26 0 WSC Capitols 63 1434.575 1442.5338 55.321884 PIT Ironmen 49 1217.9967 1210.0378 A W 0.66174459  
416 208 194702060BOS NBA 1 1947 2/6/1947 38 0 NYK Knicks 48 1252.9094 1249.8612 35.769321000000005 BOS Celtics 49 1224.339 1227.3872 A L 0.39862883  
487 244 194702210NYK NBA 0 1947 2/21/1947 44 0 NYK Knicks 77 1259.8351 1269.7465 37.832859 PIT Ironmen 49 1187.9629 1178.0515 H W 0.72896463  
616 308 194703200STB NBA 0 1947 3/20/1947 57 0 STB Bombers 51 1360.4539 1363.1570000000002 47.567825 NYK Knicks 49 1322.0216 1319.3185 H W 0.68930674  
1566 783 194901260LAL NBA 0 1949 1/26/1949 36 0 MNL Lakers 84 1599.819 1610.0941 57.55518000000001 CHS Stags 49 1502.4517 1492.1765 H W 0.75696981  
4753 2377 195212120INO NBA 0 1953 12/12/1952 23 0 INO Olympians 63 1458.0431 1464.5857 36.379326 MLH Hawks 49 1399.6044 1393.0618 H W 0.71341878  
84664 42332 199904100CHI NBA 1 1999 4/10/1999 34 0 MIA Heat 82 1614.4731 1630.3802 54.459480000000006 CHI Bulls 49 1418.535 1402.6279 A W 0.63466072  
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  
91 46 194611230WSC NBA 0 1947 11/23/1946 9 0 WSC Capitols 74 1344.4468 1353.6788 46.595535 TRH Huskies 50 1280.6818 1271.4497 H W 0.71964616  
197 99 194612150STB NBA 0 1947 12/15/1946 18 0 STB Bombers 46 1315.6809 1304.6824 41.491138 TRH Huskies 50 1232.2332 1243.2317 H L 0.74192733  
270 135 194701040DTF NBA 1 1947 1/4/1947 23 0 NYK Knicks 62 1329.1947 1343.4509 45.539127 DTF Falcons 50 1287.9642 1273.708 A W 0.41622138  
309 155 194701130PIT NBA 1 1947 1/13/1947 27 0 NYK Knicks 53 1321.4895 1326.8982 43.817054999999996 PIT Ironmen 50 1212.5773 1207.1686 A W 0.51282293  
722 361 194711180BOS NBA 1 1948 11/18/1947 3 0 STB Bombers 65 1384.1389 1397.8636 41.127598 BOS Celtics 50 1289.3925 1275.6677 A W 0.4924401  
908 454 194801220CHS NBA 1 1948 1/22/1948 25 0 PRO Steamrollers 56 1227.6887 1246.6008 25.990934 CHS Stags 50 1476.4993 1457.5872 A W 0.11837441  
1738 869 194902270FTW NBA 0 1949 2/27/1949 51 0 FTW Pistons 74 1389.8838 1419.7006 38.586037 MNL Lakers 50 1640.4923 1610.6755 H W 0.2958847  
2121 1061 194911300CHS NBA 0 1950 11/30/1949 15 0 CHS Stags 57 1568.3347 1571.1171 53.190041 BLB Baltimore 50 1424.8654 1422.0829999999999 H W 0.80242532  
3061 1531 195004050LAL NBA 0 1950 4/5/1950 74 1 MNL Lakers 75 1710.1169 1715.6886 65.157501 AND Packers 50 1542.4562 1536.8845 H W 0.823578  
5223 2612 195303130INO NBA 0 1953 3/13/1953 67 0 INO Olympians 52 1420.5378 1424.0957 32.249035 MLH Hawks 50 1443.4641 1439.9063 H W 0.60913366  
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  
75 38 194611200WSC NBA 0 1947 11/20/1946 7 0 WSC Capitols 54 1329.9454 1333.5576 44.511421 STB Bombers 51 1322.9524 1319.3402 H W 0.64928585  
150 75 194612050GSW NBA 0 1947 12/5/1946 9 0 PHW Warriors 62 1287.2725 1296.8409 40.668636 NYK Knicks 51 1350.4919 1340.9235 H W 0.55273455  
234 117 194612260STB NBA 0 1947 12/26/1946 23 0 STB Bombers 55 1320.0004 1323.7323 43.486359 DTF Falcons 51 1293.0409 1289.309 H W 0.67498904  
384 192 194701300BOS NBA 0 1947 1/30/1947 38 0 BOS Celtics 66 1222.5165 1231.4259 33.879787 PIT Ironmen 51 1220.8876 1211.9781 H W 0.6422224  
476 238 194702190DTF NBA 1 1947 2/19/1947 44 0 BOS Celtics 57 1231.0762 1242.1201 34.972649 DTF Falcons 51 1240.0331 1228.9891 A W 0.34814423  
615 308 194703200STB NBA 1 1947 3/20/1947 55 0 NYK Knicks 49 1322.0216 1319.3185 43.024772999999996 STB Bombers 51 1360.4539 1363.1570000000002 A L 0.31069326  
633 317 194703240PIT NBA 1 1947 3/24/1947 57 0 NYK Knicks 65 1335.1791 1343.6949 45.564407 PIT Ironmen 51 1133.6729 1125.157 A W 0.6420600999999999  
663 332 194704020CLR NBA 0 1947 4/2/1947 61 1 CLR Rebels 77 1289.1487 1304.9407 41.518227 NYK Knicks 51 1332.156 1316.364 H W 0.5812911999999999  
674 337 194704050STB NBA 0 1947 4/5/1947 63 1 STB Bombers 73 1365.1349 1378.3704 49.112282 PHW Warriors 51 1394.2438 1381.0083 H W 0.6006279  
775 388 194712040BLB NBA 1 1948 12/4/1947 9 0 STB Bombers 65 1410.4642 1432.6763 44.76862 BLB Baltimore 51 1491.0424 1468.8303 A W 0.26124817  
1057 529 194803130CHS NBA 0 1948 3/13/1948 45 0 CHS Stags 58 1478.2841 1482.4277 49.856262 NYK Knicks 51 1413.1799 1409.0363 H W 0.7211988  
1101 551 194803300GSW NBA 1 1948 3/30/1948 52 1 STB Bombers 56 1436.5128 1446.9774 46.250427 PHW Warriors 51 1459.7136 1449.249 A W 0.32977545  
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
1923 962 194911050DNN NBA 1 1950 11/5/1949 2 0 SYR Sixers 84 1462.6614 1479.644 43.969257 DNN Denver 51 1281.7910000000002 1264.8083 A W 0.61432457 at Auburn NY
2606 1303 195001290STB NBA 1 1950 1/29/1950 41 0 CHS Stags 66 1531.1692 1543.8048 50.527378000000006 STB Bombers 51 1414.2157 1401.5801 A W 0.52437866  
4616 2308 195211160LAL NBA 0 1953 11/16/1952 9 0 MNL Lakers 87 1636.7214 1641.0066 54.359917 MLH Hawks 51 1374.5371 1370.2520000000002 H W 0.88942689  
5417 2709 195311270MLH NBA 0 1954 11/27/1953 14 0 MLH Hawks 55 1390.6563 1395.5641 28.97477 PHW Warriors 51 1426.0424 1421.1345 H W 0.5919295 at Chicago IL
185 93 194612130TRH NBA 1 1947 12/13/1946 18 0 PIT Ironmen 62 1225.3917 1240.7815 34.835339000000005 TRH Huskies 52 1247.6229 1232.2332 A W 0.33101028  
192 96 194612140WSC NBA 0 1947 12/14/1946 17 0 WSC Capitols 72 1407.4528 1414.1184 52.64159 CLR Rebels 52 1303.9496 1297.2839 H W 0.76340854  
196 98 194612150CLR NBA 0 1947 12/15/1946 17 0 CLR Rebels 70 1297.2839 1310.9967 42.153202 NYK Knicks 52 1369.5447 1355.8319 H W 0.53983539  
245 123 194612290DTF NBA 0 1947 12/29/1946 25 0 DTF Falcons 48 1289.309 1279.0566 38.805237 TRH Huskies 52 1233.9374 1244.1897 H L 0.70979542  
361 181 194701250NYK NBA 0 1947 1/25/1947 32 0 NYK Knicks 46 1303.5112 1290.1566 39.967690000000005 BOS Celtics 52 1222.9237 1236.2783 H L 0.73876226  
504 252 194702230DTF NBA 0 1947 2/23/1947 47 0 DTF Falcons 61 1239.26 1245.4276 35.312508 TRH Huskies 52 1227.9174 1221.7498 H W 0.65496588  
534 267 194703010WSC NBA 0 1947 3/1/1947 50 0 WSC Capitols 75 1482.8972 1486.1029 59.168724 BOS Celtics 52 1226.672 1223.4663 H W 0.88600796  
819 410 194712200WSC NBA 1 1948 12/20/1947 15 0 STB Bombers 55 1431.3295 1439.8669 45.515171 WSC Capitols 52 1464.1909 1455.6534 A W 0.31760246  
2292 1146 194912210STB NBA 0 1950 12/21/1949 25 0 STB Bombers 75 1443.3508 1463.5332 42.284088 NYK Knicks 52 1574.4336 1554.2512 H W 0.45538726  
4042 2021 195112160LAL NBA 0 1952 12/16/1951 20 0 MNL Lakers 99 1599.1761 1605.9578 50.858345 MLH Hawks 52 1382.9049 1376.1233 H W 0.86063856  

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