nba-elo/nbaallelo

126,314 rows

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
201 101 194612170CLR NBA 0 1947 12/17/1946 18 0 CLR Rebels 78 1310.9967 1317.8322 42.869217 TRH Huskies 62 1243.2317 1236.3962 H W 0.7242682  
202 101 194612170CLR NBA 1 1947 12/17/1946 19 0 TRH Huskies 62 1243.2317 1236.3962 34.386520000000004 CLR Rebels 78 1310.9967 1317.8322 A L 0.27573179999999997  
203 102 194612170GSW NBA 1 1947 12/17/1946 22 0 DTF Falcons 49 1302.2896 1296.0708 40.58786 PHW Warriors 57 1296.1072 1302.3259 A L 0.3681742  
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  
205 103 194612180NYK NBA 1 1947 12/18/1946 19 0 CLR Rebels 56 1317.8322 1326.4893 43.774361 NYK Knicks 53 1355.8319 1347.1748 A W 0.31122673  
206 103 194612180NYK NBA 0 1947 12/18/1946 19 0 NYK Knicks 53 1355.8319 1347.1748 45.924538 CLR Rebels 56 1317.8322 1326.4893 H L 0.68877327  
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  
208 104 194612180WSC NBA 1 1947 12/18/1946 20 0 STB Bombers 47 1317.0259 1309.9017 42.038425 WSC Capitols 68 1414.1184 1421.2426 A L 0.24332129999999996  
209 105 194612190BOS NBA 0 1947 12/19/1946 20 0 BOS Celtics 74 1226.2948 1221.1678 32.841187 STB Bombers 76 1309.9017 1315.0287 H L 0.52357405  
210 105 194612190BOS NBA 1 1947 12/19/1946 21 0 STB Bombers 76 1309.9017 1315.0287 42.575665 BOS Celtics 74 1226.2948 1221.1678 A W 0.47642595  
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  
212 106 194612190GSW NBA 1 1947 12/19/1946 20 0 CLR Rebels 44 1326.4893 1316.9688 42.778828000000004 PHW Warriors 58 1302.3259 1311.8464 A L 0.3925631  
213 107 194612190PRO NBA 0 1947 12/19/1946 18 0 PRO Steamrollers 81 1262.4368 1268.4114 37.693690999999994 CHS Stags 77 1347.2114 1341.2368 H W 0.52189702  
214 107 194612190PRO NBA 1 1947 12/19/1946 21 0 CHS Stags 77 1347.2114 1341.2368 45.309582 PRO Steamrollers 81 1262.4368 1268.4114 A L 0.47810298  
215 108 194612200TRH NBA 1 1947 12/20/1946 20 0 NYK Knicks 70 1347.1748 1340.5975 45.243252000000005 TRH Huskies 74 1236.3962 1242.9735 A L 0.51550663  
216 108 194612200TRH NBA 0 1947 12/20/1946 20 0 TRH Huskies 74 1236.3962 1242.9735 35.060261 NYK Knicks 70 1347.1748 1340.5975 H W 0.48449337  
217 109 194612210PRO NBA 0 1947 12/21/1946 19 0 PRO Steamrollers 63 1268.4114 1272.7605 38.147316 NYK Knicks 61 1340.5975 1336.2484 H W 0.53994203  
218 109 194612210PRO NBA 1 1947 12/21/1946 21 0 NYK Knicks 61 1340.5975 1336.2484 44.791435 PRO Steamrollers 63 1268.4114 1272.7605 A L 0.46005797  
219 110 194612210WSC NBA 0 1947 12/21/1946 19 0 WSC Capitols 68 1421.2426 1425.8375 53.76189 PHW Warriors 56 1311.8464 1307.2515 H W 0.76948065  
220 110 194612210WSC NBA 1 1947 12/21/1946 17 0 PHW Warriors 56 1311.8464 1307.2515 41.760559 WSC Capitols 68 1421.2426 1425.8375 A L 0.23051935  
221 111 194612220CHS NBA 0 1947 12/22/1946 22 0 CHS Stags 95 1341.2368 1344.2667 45.623631 DTF Falcons 92 1296.0708 1293.0409 H W 0.69754672  
222 111 194612220CHS NBA 1 1947 12/22/1946 23 0 DTF Falcons 92 1296.0708 1293.0409 40.2701 CHS Stags 95 1341.2368 1344.2667 A L 0.30245328  
223 112 194612220CLR NBA 1 1947 12/22/1946 21 0 PIT Ironmen 78 1224.4557 1235.6960000000001 34.315006 CLR Rebels 74 1316.9688 1305.7284 A W 0.24820769  
224 112 194612220CLR NBA 0 1947 12/22/1946 21 0 CLR Rebels 74 1316.9688 1305.7284 41.600842 PIT Ironmen 78 1224.4557 1235.6960000000001 H L 0.75179231  
225 113 194612220STB NBA 1 1947 12/22/1946 21 0 BOS Celtics 53 1221.1678 1216.1962 32.341621 STB Bombers 65 1315.0287 1320.0004 A L 0.24676281  
226 113 194612220STB NBA 0 1947 12/22/1946 22 0 STB Bombers 65 1315.0287 1320.0004 43.096119 BOS Celtics 53 1221.1678 1216.1962 H W 0.75323719  
227 114 194612230PIT NBA 1 1947 12/23/1946 22 0 BOS Celtics 54 1216.1962 1209.8594 31.708786 PIT Ironmen 64 1235.6960000000001 1242.0328 A L 0.33450115  
228 114 194612230PIT NBA 0 1947 12/23/1946 22 0 PIT Ironmen 64 1235.6960000000001 1242.0328 34.963692 BOS Celtics 54 1216.1962 1209.8594 H W 0.66549885  
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  
230 115 194612260GSW NBA 1 1947 12/26/1946 23 0 PIT Ironmen 46 1242.0328 1237.8915 34.539375 PHW Warriors 53 1307.2515 1311.3928 A L 0.2786687  
231 116 194612260PRO NBA 0 1947 12/26/1946 20 0 PRO Steamrollers 66 1272.7605 1263.2903 37.160595 WSC Capitols 78 1425.8375 1435.3077 H L 0.42420474  
232 116 194612260PRO NBA 1 1947 12/26/1946 20 0 WSC Capitols 78 1425.8375 1435.3077 54.652142000000005 PRO Steamrollers 66 1272.7605 1263.2903 A W 0.57579529  
233 117 194612260STB NBA 1 1947 12/26/1946 24 0 DTF Falcons 51 1293.0409 1289.309 39.878838 STB Bombers 55 1320.0004 1323.7323 A L 0.32501096  
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  
235 118 194612270BOS NBA 0 1947 12/27/1946 23 0 BOS Celtics 60 1209.8594 1204.3003 31.157422999999998 PHW Warriors 63 1311.3928 1316.9519 H L 0.4977932  
236 118 194612270BOS NBA 1 1947 12/27/1946 19 0 PHW Warriors 63 1311.3928 1316.9519 42.777065 BOS Celtics 60 1209.8594 1204.3003 A W 0.5022068000000001  
237 119 194612270TRH NBA 0 1947 12/27/1946 21 0 TRH Huskies 80 1242.9735 1233.9374 34.135567 CHS Stags 88 1344.2667 1353.3029 H L 0.49813893  
238 119 194612270TRH NBA 1 1947 12/27/1946 23 0 CHS Stags 88 1344.2667 1353.3029 46.556828 TRH Huskies 80 1242.9735 1233.9374 A W 0.5018611  
239 120 194612280PRO NBA 1 1947 12/28/1946 24 0 BOS Celtics 68 1204.3003 1198.3969 30.576016999999997 PRO Steamrollers 80 1263.2903 1269.1937 A L 0.28593284  
240 120 194612280PRO NBA 0 1947 12/28/1946 21 0 PRO Steamrollers 80 1263.2903 1269.1937 37.775234000000005 BOS Celtics 68 1204.3003 1198.3969 H W 0.71406716  
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  
242 121 194612280WSC NBA 1 1947 12/28/1946 22 0 NYK Knicks 49 1336.2484 1329.1947 44.056713 WSC Capitols 70 1435.3077 1442.3615 A L 0.24124289  
243 122 194612290CLR NBA 1 1947 12/29/1946 24 0 CHS Stags 87 1353.3029 1364.1989 47.674263 CLR Rebels 79 1305.7284 1294.8324 A W 0.42512101  
244 122 194612290CLR NBA 0 1947 12/29/1946 22 0 CLR Rebels 79 1305.7284 1294.8324 40.457972999999996 CHS Stags 87 1353.3029 1364.1989 H L 0.57487899  
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  
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  
247 124 194612290STB NBA 1 1947 12/29/1946 20 0 PHW Warriors 68 1316.9519 1311.511 42.207104 STB Bombers 75 1323.7323 1329.1732 A L 0.35099298  
248 124 194612290STB NBA 0 1947 12/29/1946 24 0 STB Bombers 75 1323.7323 1329.1732 44.05447 PHW Warriors 68 1316.9519 1311.511 H W 0.64900702  
249 125 194612300BOS NBA 1 1947 12/30/1946 22 0 WSC Capitols 70 1442.3615 1448.0177 55.824431999999995 BOS Celtics 60 1198.3969 1192.7406 A W 0.69608569  
250 125 194612300BOS NBA 0 1947 12/30/1946 25 0 BOS Celtics 60 1198.3969 1192.7406 30.023127000000002 WSC Capitols 70 1442.3615 1448.0177 H L 0.30391434  
251 126 194612300PIT NBA 1 1947 12/30/1946 21 0 PHW Warriors 62 1311.511 1316.8210000000001 42.763363 PIT Ironmen 60 1237.8915 1232.5814 A W 0.46210819  
252 126 194612300PIT NBA 0 1947 12/30/1946 24 0 PIT Ironmen 60 1237.8915 1232.5814 33.997398 PHW Warriors 62 1311.511 1316.8210000000001 H L 0.53789181  
253 127 194612310CLR NBA 0 1947 12/31/1946 23 0 CLR Rebels 59 1294.8324 1282.6403 39.180237 STB Bombers 68 1329.1732 1341.3654 H L 0.59338212  
254 127 194612310CLR NBA 1 1947 12/31/1946 25 0 STB Bombers 68 1329.1732 1341.3654 45.322914000000004 CLR Rebels 59 1294.8324 1282.6403 A W 0.40661788  
255 128 194612310TRH NBA 0 1947 12/31/1946 23 0 TRH Huskies 86 1244.1897 1255.3428 36.335934 CHS Stags 76 1364.1989 1353.0458 H W 0.47123632  
256 128 194612310TRH NBA 1 1947 12/31/1946 25 0 CHS Stags 76 1364.1989 1353.0458 46.530353999999996 TRH Huskies 86 1244.1897 1255.3428 A L 0.52876365  
257 129 194701010CHS NBA 1 1947 1/1/1947 26 0 STB Bombers 103 1341.3654 1359.0022 47.142483 CHS Stags 90 1353.0458 1335.4089 A W 0.34459484  
258 129 194701010CHS NBA 0 1947 1/1/1947 26 0 CHS Stags 90 1353.0458 1335.4089 44.704113 STB Bombers 103 1341.3654 1359.0022 H L 0.65540516  
259 130 194701010DTF NBA 0 1947 1/1/1947 26 0 DTF Falcons 62 1279.0566 1287.9642 39.7379 WSC Capitols 57 1448.0177 1439.1101 H W 0.40204012  
260 130 194701010DTF NBA 1 1947 1/1/1947 23 0 WSC Capitols 57 1448.0177 1439.1101 55.005615 DTF Falcons 62 1279.0566 1287.9642 A L 0.59795988  
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  
262 131 194701010PIT NBA 0 1947 1/1/1947 25 0 PIT Ironmen 48 1232.5814 1217.9967 32.522240000000004 CLR Rebels 61 1282.6403 1297.225 H L 0.5713802  
263 132 194701020GSW NBA 1 1947 1/2/1947 22 0 PRO Steamrollers 72 1269.1937 1262.9604 37.126305 PHW Warriors 84 1316.8210000000001 1323.0543 A L 0.29947245  
264 132 194701020GSW NBA 0 1947 1/2/1947 22 0 PHW Warriors 84 1316.8210000000001 1323.0543 43.415496999999995 PRO Steamrollers 72 1269.1937 1262.9604 H W 0.70052755  
265 133 194701020STB NBA 0 1947 1/2/1947 27 0 STB Bombers 66 1359.0022 1368.0355 48.065411 WSC Capitols 57 1439.1101 1430.0768 H W 0.52859581  
266 133 194701020STB NBA 1 1947 1/2/1947 24 0 WSC Capitols 57 1439.1101 1430.0768 54.162121 STB Bombers 66 1359.0022 1368.0355 A L 0.47140419  
267 134 194701030TRH NBA 1 1947 1/3/1947 26 0 BOS Celtics 58 1192.7406 1204.3622 31.163542 TRH Huskies 53 1255.3428 1243.7212 A W 0.28170633  
268 134 194701030TRH NBA 0 1947 1/3/1947 24 0 TRH Huskies 53 1255.3428 1243.7212 35.137066 BOS Celtics 58 1192.7406 1204.3622 H L 0.71829367  
269 135 194701040DTF NBA 0 1947 1/4/1947 27 0 DTF Falcons 50 1287.9642 1273.708 38.246239 NYK Knicks 62 1329.1947 1343.4509 H L 0.58377862  
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  
271 136 194701040PRO NBA 1 1947 1/4/1947 23 0 PHW Warriors 74 1323.0543 1317.6265 42.847687 PRO Steamrollers 78 1262.9604 1268.3883 A L 0.44282168  
272 136 194701040PRO NBA 0 1947 1/4/1947 23 0 PRO Steamrollers 78 1262.9604 1268.3883 37.691284 PHW Warriors 74 1323.0543 1317.6265 H W 0.55717832  
273 137 194701040WSC NBA 1 1947 1/4/1947 25 0 CLR Rebels 64 1297.225 1292.7268 40.237164 WSC Capitols 78 1430.0768 1434.575 A L 0.20744383  
274 137 194701040WSC NBA 0 1947 1/4/1947 25 0 WSC Capitols 78 1430.0768 1434.575 54.583755000000004 CLR Rebels 64 1297.225 1292.7268 H W 0.79255617  
275 138 194701050STB NBA 0 1947 1/5/1947 28 0 STB Bombers 57 1368.0355 1360.8228 47.329033 NYK Knicks 59 1343.4509 1350.6637 H L 0.67198277  
276 138 194701050STB NBA 1 1947 1/5/1947 24 0 NYK Knicks 59 1343.4509 1350.6637 46.284832 STB Bombers 57 1368.0355 1360.8228 A W 0.32801723  
277 139 194701060BOS NBA 1 1947 1/6/1947 26 0 CLR Rebels 64 1292.7268 1304.2137 41.441986 BOS Celtics 53 1204.3622 1192.8752 A W 0.48326159  
278 139 194701060BOS NBA 0 1947 1/6/1947 27 0 BOS Celtics 53 1204.3622 1192.8752 30.036240000000003 CLR Rebels 64 1292.7268 1304.2137 H L 0.51673841  
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  
280 140 194701060PIT NBA 0 1947 1/6/1947 26 0 PIT Ironmen 49 1217.9967 1210.0378 31.726546999999997 WSC Capitols 63 1434.575 1442.5338 H L 0.33825544  
281 141 194701060TRH NBA 1 1947 1/6/1947 28 0 DTF Falcons 61 1273.708 1263.4937 37.181744 TRH Huskies 76 1243.7212 1253.9355 A L 0.40058499999999997  
282 141 194701060TRH NBA 0 1947 1/6/1947 25 0 TRH Huskies 76 1243.7212 1253.9355 36.190292 DTF Falcons 61 1273.708 1263.4937 H W 0.5994149999999999  
283 142 194701080DTF NBA 0 1947 1/8/1947 29 0 DTF Falcons 80 1263.4937 1257.3132 36.540065999999996 CHS Stags 83 1335.4089 1341.5894 H L 0.54032934  
284 142 194701080DTF NBA 1 1947 1/8/1947 27 0 CHS Stags 83 1335.4089 1341.5894 45.346149 DTF Falcons 80 1263.4937 1257.3132 A W 0.45967066  
285 143 194701080NYK NBA 1 1947 1/8/1947 26 0 TRH Huskies 76 1253.9355 1275.9305 38.478409 NYK Knicks 63 1350.6637 1328.6687 A W 0.24370772  
286 143 194701080NYK NBA 0 1947 1/8/1947 25 0 NYK Knicks 63 1350.6637 1328.6687 44.001839000000004 TRH Huskies 76 1253.9355 1275.9305 H L 0.75629228  
287 144 194701080PIT NBA 1 1947 1/8/1947 24 0 PHW Warriors 63 1317.6265 1311.1245 42.166595 PIT Ironmen 67 1210.0378 1216.5398 A L 0.51091921  
288 144 194701080PIT NBA 0 1947 1/8/1947 27 0 PIT Ironmen 67 1210.0378 1216.5398 32.376064 PHW Warriors 63 1317.6265 1311.1245 H W 0.48908082  
289 145 194701080WSC NBA 0 1947 1/8/1947 27 0 WSC Capitols 77 1442.5338 1445.0814 55.555973 PRO Steamrollers 69 1268.3883 1265.8407 H W 0.82893646  
290 145 194701080WSC NBA 1 1947 1/8/1947 24 0 PRO Steamrollers 69 1268.3883 1265.8407 37.425938 WSC Capitols 77 1442.5338 1445.0814 A L 0.17106354  
291 146 194701090GSW NBA 0 1947 1/9/1947 25 0 PHW Warriors 74 1311.1245 1320.1029999999998 43.106861 TRH Huskies 55 1275.9305 1266.952 H W 0.68530047  
292 146 194701090GSW NBA 1 1947 1/9/1947 27 0 TRH Huskies 55 1275.9305 1266.952 37.541653000000004 PHW Warriors 74 1311.1245 1320.1029999999998 A L 0.31469953  
293 147 194701090PRO NBA 0 1947 1/9/1947 25 0 PRO Steamrollers 91 1265.8407 1280.0374 38.907825 CLR Rebels 68 1304.2137 1290.0171 H W 0.58776975  
294 147 194701090PRO NBA 1 1947 1/9/1947 27 0 CLR Rebels 68 1304.2137 1290.0171 39.953064000000005 PRO Steamrollers 91 1265.8407 1280.0374 A L 0.41223025  
295 148 194701090STB NBA 0 1947 1/9/1947 29 0 STB Bombers 84 1360.8228 1364.2407 47.678539 CHS Stags 81 1341.5894 1338.1714 H W 0.66515726  
296 148 194701090STB NBA 1 1947 1/9/1947 28 0 CHS Stags 81 1341.5894 1338.1714 44.991329 STB Bombers 84 1360.8228 1364.2407 A L 0.33484274  
297 149 194701100BOS NBA 1 1947 1/10/1947 26 0 NYK Knicks 62 1328.6687 1321.4895 43.251884000000004 BOS Celtics 66 1192.8752 1200.0544 A L 0.55132949  
298 149 194701100BOS NBA 0 1947 1/10/1947 28 0 BOS Celtics 66 1192.8752 1200.0544 30.738827 NYK Knicks 62 1328.6687 1321.4895 H W 0.44867054  
299 150 194701110DTF NBA 0 1947 1/11/1947 30 0 DTF Falcons 58 1257.3132 1261.5048 36.975025 PHW Warriors 56 1320.1029999999998 1315.9115 H W 0.55334598  
300 150 194701110DTF NBA 1 1947 1/11/1947 26 0 PHW Warriors 56 1320.1029999999998 1315.9115 42.668125 DTF Falcons 58 1257.3132 1261.5048 A L 0.44665402  

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