nba-elo/nbaallelo

126,314 rows sorted by game_result

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  
4 2 194611020CHS NBA 1 1947 11/2/1946 2 0 NYK Knicks 47 1306.7233 1297.0712 40.692783 CHS Stags 63 1300.0 1309.6521 A L 0.36889875  
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  
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  
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  
11 6 194611030CLR NBA 1 1947 11/3/1946 2 0 TRH Huskies 60 1293.2767 1286.1534 39.548164 CLR Rebels 71 1300.0 1307.1233 A L 0.3510679  
13 7 194611040PIT NBA 0 1947 11/4/1946 2 0 PIT Ironmen 56 1295.3092 1277.9456 38.689037 WSC Capitols 71 1320.3811 1337.7448 H L 0.60618901  
15 8 194611050BOS NBA 0 1947 11/5/1946 2 0 BOS Celtics 55 1294.8458 1288.4139 39.78503 CHS Stags 57 1309.6521 1316.0839999999998 H L 0.62020409  
18 9 194611050DTF NBA 0 1947 11/5/1946 2 0 DTF Falcons 49 1279.6189 1271.4624 38.011841 STB Bombers 53 1304.6908 1312.8473 H L 0.60618901  
19 10 194611070GSW NBA 1 1947 11/7/1946 3 0 PIT Ironmen 75 1277.9456 1273.2786 38.201401000000004 PHW Warriors 81 1300.0 1304.667 A L 0.33123559  
22 11 194611070PRO NBA 1 1947 11/7/1946 3 0 CHS Stags 65 1316.0839999999998 1309.735 42.020947 PRO Steamrollers 73 1305.1542 1311.5032 A L 0.37455392  
23 12 194611070STB NBA 0 1947 11/7/1946 3 0 STB Bombers 63 1312.8473 1302.5988 41.272594 NYK Knicks 68 1297.0712 1307.3197 H L 0.66071028  
26 13 194611080TRH NBA 1 1947 11/8/1946 3 0 DTF Falcons 71 1271.4624 1268.4468 37.697379999999995 TRH Huskies 73 1286.1534 1289.1691 A L 0.34069139  
27 14 194611090CHS NBA 1 1947 11/9/1946 4 0 TRH Huskies 54 1289.1691 1283.6519 39.286152 CHS Stags 62 1309.735 1315.2522 A L 0.33313644  
29 15 194611090DTF NBA 1 1947 11/9/1946 3 0 BOS Celtics 46 1288.4139 1275.2767 38.410090999999994 DTF Falcons 69 1268.4468 1281.5839999999998 A L 0.38681835  
32 16 194611090PRO NBA 1 1947 11/9/1946 4 0 PIT Ironmen 66 1273.2786 1267.4674 37.595333000000004 PRO Steamrollers 76 1311.5032 1317.3143 A L 0.31094933  
34 17 194611090STB NBA 1 1947 11/9/1946 3 0 WSC Capitols 69 1337.7448 1334.6112 44.621101 STB Bombers 70 1302.5988 1305.7323 A L 0.40773672  
36 18 194611100CLR NBA 1 1947 11/10/1946 4 0 WSC Capitols 68 1334.6112 1320.6311 43.162102000000004 CLR Rebels 92 1307.1233 1321.1034 A L 0.39713591  
38 19 194611110NYK NBA 0 1947 11/11/1946 4 0 NYK Knicks 68 1307.3197 1293.2161 40.288467 CHS Stags 78 1315.2522 1329.3558 H L 0.62947917  
40 20 194611110PIT NBA 1 1947 11/11/1946 4 0 PRO Steamrollers 71 1317.3143 1307.223 41.757576 PIT Ironmen 84 1267.4674 1277.5587 A L 0.42832112  
41 21 194611130CHS NBA 1 1947 11/13/1946 4 0 BOS Celtics 61 1275.2767 1269.8861 37.847424 CHS Stags 71 1329.3558 1334.7465 A L 0.29173952  
43 22 194611130DTF NBA 0 1947 11/13/1946 5 0 DTF Falcons 68 1281.5839999999998 1275.3634 38.419146999999995 PRO Steamrollers 70 1307.223 1313.4436 H L 0.60540938  
46 23 194611140GSW NBA 1 1947 11/14/1946 5 0 WSC Capitols 65 1320.6311 1316.6356 42.74395 PHW Warriors 68 1304.667 1308.6625 A L 0.38136715  
47 24 194611140STB NBA 1 1947 11/14/1946 5 0 BOS Celtics 62 1269.8861 1267.1501 37.562286 STB Bombers 64 1305.7323 1308.4683 A L 0.31389040000000007  
49 25 194611150TRH NBA 1 1947 11/15/1946 6 0 PRO Steamrollers 68 1313.4436 1302.3401 41.245461 TRH Huskies 85 1283.6519 1294.7554 A L 0.40031540000000004  
51 26 194611160BOS NBA 1 1947 11/16/1946 6 0 TRH Huskies 49 1294.7554 1290.0051 39.951809000000004 BOS Celtics 53 1267.1501 1271.9004 A L 0.39729762  
54 27 194611160CHS NBA 0 1947 11/16/1946 7 0 CHS Stags 65 1334.7465 1321.4366 43.246357 WSC Capitols 73 1316.6356 1329.9454 H L 0.6637165  
56 28 194611160NYK NBA 1 1947 11/16/1946 6 0 PIT Ironmen 62 1277.5587 1274.5563 38.334831 NYK Knicks 64 1293.2161 1296.2185 A L 0.33944303  
58 29 194611160PRO NBA 0 1947 11/16/1946 7 0 PRO Steamrollers 59 1302.3401 1285.7937 39.510479 DTF Falcons 70 1275.3634 1291.9098 H L 0.67501074  
60 30 194611160STB NBA 1 1947 11/16/1946 3 0 CLR Rebels 74 1321.1034 1314.2461 42.49369 STB Bombers 83 1308.4683 1315.3256 A L 0.37685645  
61 31 194611170CLR NBA 0 1947 11/17/1946 4 0 CLR Rebels 76 1314.2461 1307.6647 41.803886 CHS Stags 78 1321.4366 1328.0181 H L 0.63047475  
64 32 194611180NYK NBA 1 1947 11/18/1946 7 0 DTF Falcons 57 1291.9098 1287.7742 39.717983000000004 NYK Knicks 61 1296.2185 1300.3541 A L 0.35424089  
65 33 194611180PIT NBA 1 1947 11/18/1946 7 0 TRH Huskies 48 1290.0051 1284.491 39.374023 PIT Ironmen 54 1274.5563 1280.0704 A L 0.38066763  
67 34 194611190GSW NBA 0 1947 11/19/1946 3 0 PHW Warriors 63 1308.6625 1301.0356 41.108635 STB Bombers 66 1315.3256 1322.9524 H L 0.6311819000000001  
70 35 194611190TRH NBA 0 1947 11/19/1946 8 0 TRH Huskies 72 1284.491 1278.2225 38.718002 CLR Rebels 74 1307.6647 1313.9331 H L 0.60879451  
72 36 194611200DTF NBA 0 1947 11/20/1946 8 0 DTF Falcons 53 1287.7742 1282.0223 39.115551 PIT Ironmen 54 1280.0704 1285.8223 H L 0.65021688  
74 37 194611200NYK NBA 1 1947 11/20/1946 9 0 CHS Stags 69 1328.0181 1323.818 43.495312 NYK Knicks 72 1300.3541 1304.5542 A L 0.39737856  
76 38 194611200WSC NBA 1 1947 11/20/1946 8 0 STB Bombers 51 1322.9524 1319.3402 43.027046 WSC Capitols 54 1329.9454 1333.5576 A L 0.35071415  
77 39 194611210BOS NBA 0 1947 11/21/1946 7 0 BOS Celtics 53 1271.9004 1257.9297 36.603972999999996 STB Bombers 65 1319.3402 1333.3109 H L 0.57506841  
79 40 194611210GSW NBA 0 1947 11/21/1946 4 0 PHW Warriors 63 1301.0356 1294.7595 40.450328999999996 CHS Stags 65 1323.818 1330.0941 H L 0.60933089  
82 41 194611210PRO NBA 0 1947 11/21/1946 8 0 PRO Steamrollers 58 1285.7937 1274.9045 38.371208 WSC Capitols 66 1333.5576 1344.4468 H L 0.57461244  
83 42 194611220TRH NBA 1 1947 11/22/1946 8 0 BOS Celtics 82 1257.9297 1255.4705 36.349152000000004 TRH Huskies 83 1278.2225 1280.6818 A L 0.33348578  
85 43 194611230DTF NBA 1 1947 11/23/1946 9 0 BOS Celtics 46 1255.4705 1250.1028 35.794253999999995 DTF Falcons 54 1282.0223 1287.39 A L 0.32552594  
87 44 194611230NYK NBA 1 1947 11/23/1946 6 0 CLR Rebels 76 1313.9331 1308.5621 41.897987 NYK Knicks 82 1304.5542 1309.9252 A L 0.37246484  
89 45 194611230PRO NBA 0 1947 11/23/1946 9 0 PRO Steamrollers 59 1274.9045 1265.9526 37.437588 STB Bombers 65 1333.3109 1342.2628 H L 0.55957371  
92 46 194611230WSC NBA 1 1947 11/23/1946 10 0 TRH Huskies 50 1280.6818 1271.4497 38.010517 WSC Capitols 74 1344.4468 1353.6788 A L 0.28035384  
93 47 194611240CHS NBA 0 1947 11/24/1946 11 0 CHS Stags 55 1330.0941 1310.8802 42.140995000000004 DTF Falcons 68 1287.39 1306.6039 H L 0.69454849  
95 48 194611240CLR NBA 1 1947 11/24/1946 9 0 PIT Ironmen 60 1285.8223 1282.9152 39.209019 CLR Rebels 62 1308.5621 1311.4692 A L 0.33036214  
98 49 194611250BOS NBA 0 1947 11/25/1946 10 0 BOS Celtics 59 1250.1028 1234.6626 34.20953 PRO Steamrollers 71 1265.9526 1281.3928 H L 0.618788  
100 50 194611250PIT NBA 0 1947 11/25/1946 10 0 PIT Ironmen 46 1282.9152 1264.8934 37.327346999999996 NYK Knicks 62 1309.9252 1327.9469 H L 0.60352254  
102 51 194611260DTF NBA 1 1947 11/26/1946 8 0 CLR Rebels 46 1311.4692 1300.3143 41.03297 DTF Falcons 66 1306.6039 1317.7588 A L 0.36641234  
104 52 194611260GSW NBA 1 1947 11/26/1946 11 0 BOS Celtics 54 1234.6626 1228.7905 33.612003 PHW Warriors 66 1294.7595 1300.6316 A L 0.28463364  
105 53 194611260TRH NBA 0 1947 11/26/1946 11 0 TRH Huskies 68 1271.4497 1260.3845 36.858684999999994 WSC Capitols 78 1353.6788 1364.744 H L 0.52555209  
107 54 194611270NYK NBA 1 1947 11/27/1946 11 0 STB Bombers 60 1342.2628 1336.293 44.796065999999996 NYK Knicks 67 1327.9469 1333.9167 A L 0.37913126  
109 55 194611270PIT NBA 1 1947 11/27/1946 9 0 CLR Rebels 60 1300.3143 1296.5641 40.639599 PIT Ironmen 62 1264.8934 1268.6437 A L 0.4081189  
112 56 194611270WSC NBA 1 1947 11/27/1946 12 0 CHS Stags 67 1310.8802 1306.1592 41.646015000000006 WSC Capitols 75 1364.744 1369.4651 A L 0.2919957  
113 57 194611280BOS NBA 1 1947 11/28/1946 12 0 PIT Ironmen 55 1268.6437 1263.6439 37.197369 BOS Celtics 59 1228.7905 1233.7903 A L 0.41429621  
116 58 194611280CHS NBA 0 1947 11/28/1946 13 0 CHS Stags 72 1306.1592 1299.0626 40.901672 STB Bombers 75 1336.293 1343.3895 H L 0.59921187  
117 59 194611280GSW NBA 0 1947 11/28/1946 6 0 PHW Warriors 55 1300.6316 1284.4366 39.368336 DTF Falcons 68 1317.7588 1333.9537 H L 0.61705202  
119 60 194611280PRO NBA 0 1947 11/28/1946 11 0 PRO Steamrollers 58 1281.3928 1275.6881 38.453075 NYK Knicks 60 1333.9167 1339.6215 H L 0.56790143  
121 61 194611290TRH NBA 0 1947 11/29/1946 12 0 TRH Huskies 72 1260.3845 1243.6194 35.126602 CLR Rebels 87 1296.5641 1313.3292 H L 0.59082574  
124 62 194611300NYK NBA 1 1947 11/30/1946 7 0 PHW Warriors 60 1284.4366 1281.1688 39.026222 NYK Knicks 64 1339.6215 1342.8893 A L 0.29042608  
125 63 194611300PRO NBA 1 1947 11/30/1946 13 0 TRH Huskies 65 1243.6194 1236.2073 34.367218 PRO Steamrollers 79 1275.6881 1283.1002 A L 0.31859225  
128 64 194611300STB NBA 1 1947 11/30/1946 13 0 DTF Falcons 57 1333.9537 1330.3809 44.180415999999994 STB Bombers 60 1343.3895 1346.9624 A L 0.34751892  
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  
131 66 194612010CHS NBA 1 1947 12/1/1946 13 0 BOS Celtics 56 1233.7903 1228.6831 33.601101 CHS Stags 66 1299.0626 1304.1698 A L 0.27860653  
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  
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  
137 69 194612030GSW NBA 1 1947 12/3/1946 13 0 PRO Steamrollers 68 1283.1002 1276.9966 38.589825 PHW Warriors 76 1281.1688 1287.2725 A L 0.36250037  
139 70 194612040NYK NBA 1 1947 12/4/1946 15 0 DTF Falcons 57 1326.9114 1319.3087 43.023754 NYK Knicks 70 1342.8893 1350.4919 A L 0.33902943  
142 71 194612040PIT NBA 0 1947 12/4/1946 15 0 PIT Ironmen 46 1252.3871 1239.3546 34.689129 CHS Stags 57 1304.1698 1317.2023 H L 0.56894815  
144 72 194612040WSC NBA 1 1947 12/4/1946 14 0 PRO Steamrollers 62 1276.9966 1270.5713 37.91888 WSC Capitols 80 1373.3796 1379.8049 A L 0.24407405  
145 73 194612050BOS NBA 0 1947 12/5/1946 15 0 BOS Celtics 61 1236.0254 1229.3071 33.664444 DTF Falcons 65 1319.3087 1326.027 H L 0.52403867  
147 74 194612050CHS NBA 0 1947 12/5/1946 16 0 CHS Stags 61 1317.2023 1306.269 41.657539 TRH Huskies 65 1236.2073 1247.1405 H L 0.73921472  
149 75 194612050GSW NBA 1 1947 12/5/1946 14 0 NYK Knicks 51 1350.4919 1340.9235 45.277073 PHW Warriors 62 1287.2725 1296.8409 A L 0.44726545  
151 76 194612050STB NBA 1 1947 12/5/1946 16 0 PIT Ironmen 55 1239.3546 1234.9664 34.240528000000005 STB Bombers 66 1346.9624 1351.3506 A L 0.23235047  
153 77 194612070BOS NBA 0 1947 12/7/1946 16 0 BOS Celtics 65 1229.3071 1210.9467 31.817047 NYK Knicks 90 1340.9235 1359.2839 H L 0.48328897  
156 78 194612070CHS NBA 1 1947 12/7/1946 12 0 CLR Rebels 78 1316.7987 1310.4608 42.097031 CHS Stags 86 1306.269 1312.6069 A L 0.37401449999999997  
157 79 194612070PRO NBA 0 1947 12/7/1946 15 0 PRO Steamrollers 59 1270.5713 1256.0878 36.413086 TRH Huskies 68 1247.1405 1261.624 H L 0.67051709  
159 80 194612070STB NBA 0 1947 12/7/1946 15 0 STB Bombers 47 1351.3506 1334.5652 44.61631 PHW Warriors 57 1296.8409 1313.6263 H L 0.7087723000000001  
161 81 194612070WSC NBA 1 1947 12/7/1946 17 0 DTF Falcons 64 1326.027 1320.2988 43.127346 WSC Capitols 75 1379.8049 1385.5331 A L 0.29209787  
163 82 194612080CLR NBA 1 1947 12/8/1946 11 0 PHW Warriors 66 1313.6263 1308.3997 41.880951 CLR Rebels 72 1310.4608 1315.6875 A L 0.36414367  
165 83 194612080NYK NBA 1 1947 12/8/1946 17 0 BOS Celtics 44 1210.9467 1206.0377 31.329351000000003 NYK Knicks 62 1359.2839 1364.1929 A L 0.19316971  
167 84 194612090PIT NBA 0 1947 12/9/1946 17 0 PIT Ironmen 58 1234.9664 1225.3917 33.267609 DTF Falcons 66 1320.2988 1329.8735 H L 0.52109587  
170 85 194612100CLR NBA 0 1947 12/10/1946 14 0 CLR Rebels 61 1315.6875 1310.3738 42.087906 STB Bombers 62 1334.5652 1339.8789 H L 0.61466813  
172 86 194612100TRH NBA 0 1947 12/10/1946 16 0 TRH Huskies 73 1261.624 1247.6229 35.538528 PHW Warriors 85 1308.3997 1322.4008 H L 0.57600242  
173 87 194612110CHS NBA 1 1947 12/11/1946 15 0 CLR Rebels 79 1310.3738 1303.9496 41.41428 CHS Stags 88 1312.6069 1319.0311 A L 0.35697877  
175 88 194612110NYK NBA 1 1947 12/11/1946 16 0 PRO Steamrollers 68 1256.0878 1250.736 35.859612 NYK Knicks 83 1364.1929 1369.5447 A L 0.23184025  
177 89 194612110WSC NBA 1 1947 12/11/1946 19 0 DTF Falcons 66 1329.8735 1322.9327 43.402786 WSC Capitols 81 1385.5331 1392.4739 A L 0.28986323  
179 90 194612120BOS NBA 1 1947 12/12/1946 20 0 DTF Falcons 66 1322.9327 1313.9904 42.4669 BOS Celtics 73 1206.0377 1214.9801 A L 0.52429473  
182 91 194612120GSW NBA 0 1947 12/12/1946 13 0 PHW Warriors 49 1322.4008 1307.4219 41.778427 WSC Capitols 64 1392.4739 1407.4528 H L 0.54296201  
184 92 194612120STB NBA 0 1947 12/12/1946 17 0 STB Bombers 68 1339.8789 1315.6809 42.643974 CHS Stags 88 1319.0311 1343.2291 H L 0.66722387  
186 93 194612130TRH NBA 0 1947 12/13/1946 17 0 TRH Huskies 52 1247.6229 1232.2332 33.961940999999996 PIT Ironmen 62 1225.3917 1240.7815 H L 0.66898972  
188 94 194612140BOS NBA 1 1947 12/14/1946 14 0 PHW Warriors 65 1307.4219 1296.1072 40.591675 BOS Celtics 77 1214.9801 1226.2948 A L 0.48912454  
190 95 194612140PRO NBA 1 1947 12/14/1946 21 0 DTF Falcons 66 1313.9904 1302.2896 41.240162 PRO Steamrollers 81 1250.736 1262.4368 A L 0.44731509999999997  
191 96 194612140WSC NBA 1 1947 12/14/1946 16 0 CLR Rebels 52 1303.9496 1297.2839 40.715103000000006 WSC Capitols 72 1407.4528 1414.1184 A L 0.23659146  
194 97 194612150CHS NBA 1 1947 12/15/1946 19 0 PIT Ironmen 75 1240.7815 1236.7992 34.427696000000005 CHS Stags 84 1343.2291 1347.2114 A L 0.23769069  
195 98 194612150CLR NBA 1 1947 12/15/1946 18 0 NYK Knicks 52 1369.5447 1355.8319 46.817009000000006 CLR Rebels 70 1297.2839 1310.9967 A L 0.46016461  
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  
199 100 194612160PIT NBA 0 1947 12/16/1946 20 0 PIT Ironmen 55 1236.7992 1224.4557 33.172958 STB Bombers 66 1304.6824 1317.0259 H L 0.54608864  

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