nba-elo/nbaallelo

126,314 rows sorted by game_location

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
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  
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  
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  
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  
14 7 194611040PIT NBA 1 1947 11/4/1946 2 0 WSC Capitols 71 1320.3811 1337.7448 44.946995 PIT Ironmen 56 1295.3092 1277.9456 A W 0.39381099  
16 8 194611050BOS NBA 1 1947 11/5/1946 2 0 CHS Stags 57 1309.6521 1316.0839999999998 42.686188 BOS Celtics 55 1294.8458 1288.4139 A W 0.37979591  
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  
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  
24 12 194611070STB NBA 1 1947 11/7/1946 3 0 NYK Knicks 68 1297.0712 1307.3197 41.767715 STB Bombers 63 1312.8473 1302.5988 A W 0.33928972  
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  
37 19 194611110NYK NBA 1 1947 11/11/1946 5 0 CHS Stags 78 1315.2522 1329.3558 44.073521 NYK Knicks 68 1307.3197 1293.2161 A W 0.37052083  
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  
44 22 194611130DTF NBA 1 1947 11/13/1946 5 0 PRO Steamrollers 70 1307.223 1313.4436 42.409618 DTF Falcons 68 1281.5839999999998 1275.3634 A W 0.39459062  
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  
53 27 194611160CHS NBA 1 1947 11/16/1946 6 0 WSC Capitols 73 1316.6356 1329.9454 44.13501 CHS Stags 65 1334.7465 1321.4366 A W 0.3362835  
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  
57 29 194611160PRO NBA 1 1947 11/16/1946 6 0 DTF Falcons 70 1275.3634 1291.9098 40.151493 PRO Steamrollers 59 1302.3401 1285.7937 A W 0.32498926  
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  
62 31 194611170CLR NBA 1 1947 11/17/1946 8 0 CHS Stags 78 1321.4366 1328.0181 43.933949 CLR Rebels 76 1314.2461 1307.6647 A W 0.36952525  
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  
68 34 194611190GSW NBA 1 1947 11/19/1946 7 0 STB Bombers 66 1315.3256 1322.9524 43.404839 PHW Warriors 63 1308.6625 1301.0356 A W 0.3688181  
69 35 194611190TRH NBA 1 1947 11/19/1946 5 0 CLR Rebels 74 1307.6647 1313.9331 42.460903 TRH Huskies 72 1284.491 1278.2225 A W 0.39120549  
71 36 194611200DTF NBA 1 1947 11/20/1946 8 0 PIT Ironmen 54 1280.0704 1285.8223 39.51347 DTF Falcons 53 1287.7742 1282.0223 A W 0.34978312  
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  
78 39 194611210BOS NBA 1 1947 11/21/1946 9 0 STB Bombers 65 1319.3402 1333.3109 44.485733 BOS Celtics 53 1271.9004 1257.9297 A W 0.42493159  
80 40 194611210GSW NBA 1 1947 11/21/1946 10 0 CHS Stags 65 1323.818 1330.0941 44.150517 PHW Warriors 63 1301.0356 1294.7595 A W 0.39066911  
81 41 194611210PRO NBA 1 1947 11/21/1946 8 0 WSC Capitols 66 1333.5576 1344.4468 45.642277 PRO Steamrollers 58 1285.7937 1274.9045 A W 0.42538756  
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  
90 45 194611230PRO NBA 1 1947 11/23/1946 10 0 STB Bombers 65 1333.3109 1342.2628 45.415985 PRO Steamrollers 59 1274.9045 1265.9526 A W 0.44042629  
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  
94 47 194611240CHS NBA 1 1947 11/24/1946 10 0 DTF Falcons 68 1287.39 1306.6039 41.692654 CHS Stags 55 1330.0941 1310.8802 A W 0.30545151  
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  
97 49 194611250BOS NBA 1 1947 11/25/1946 10 0 PRO Steamrollers 71 1265.9526 1281.3928 39.049664 BOS Celtics 59 1250.1028 1234.6626 A W 0.381212  
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  
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  
106 53 194611260TRH NBA 1 1947 11/26/1946 10 0 WSC Capitols 78 1353.6788 1364.744 47.729919 TRH Huskies 68 1271.4497 1260.3845 A W 0.47444791  
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  
115 58 194611280CHS NBA 1 1947 11/28/1946 12 0 STB Bombers 75 1336.293 1343.3895 45.532764 CHS Stags 72 1306.1592 1299.0626 A W 0.40078813  
118 59 194611280GSW NBA 1 1947 11/28/1946 12 0 DTF Falcons 68 1317.7588 1333.9537 44.552662 PHW Warriors 55 1300.6316 1284.4366 A W 0.38294798  
120 60 194611280PRO NBA 1 1947 11/28/1946 11 0 NYK Knicks 60 1333.9167 1339.6215 45.141937 PRO Steamrollers 58 1281.3928 1275.6881 A W 0.43209857  
122 61 194611290TRH NBA 1 1947 11/29/1946 10 0 CLR Rebels 87 1296.5641 1313.3292 42.397633 TRH Huskies 72 1260.3845 1243.6194 A W 0.40917426  
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  
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  
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  
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  
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  
146 73 194612050BOS NBA 1 1947 12/5/1946 16 0 DTF Falcons 65 1319.3087 1326.027 43.726085999999995 BOS Celtics 61 1236.0254 1229.3071 A W 0.47596133  
148 74 194612050CHS NBA 1 1947 12/5/1946 14 0 TRH Huskies 65 1236.2073 1247.1405 35.488831 CHS Stags 61 1317.2023 1306.269 A W 0.26078528  
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  
154 77 194612070BOS NBA 1 1947 12/7/1946 15 0 NYK Knicks 90 1340.9235 1359.2839 47.171368 BOS Celtics 65 1229.3071 1210.9467 A W 0.5167109999999999  
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  
158 79 194612070PRO NBA 1 1947 12/7/1946 15 0 TRH Huskies 68 1247.1405 1261.624 36.987415000000006 PRO Steamrollers 59 1270.5713 1256.0878 A W 0.32948291  
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  
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  
168 84 194612090PIT NBA 1 1947 12/9/1946 18 0 DTF Falcons 66 1320.2988 1329.8735 44.127514 PIT Ironmen 58 1234.9664 1225.3917 A W 0.47890413  
169 85 194612100CLR NBA 1 1947 12/10/1946 16 0 STB Bombers 62 1334.5652 1339.8789 45.168663 CLR Rebels 61 1315.6875 1310.3738 A W 0.38533187  
171 86 194612100TRH NBA 1 1947 12/10/1946 12 0 PHW Warriors 85 1308.3997 1322.4008 43.347172 TRH Huskies 73 1261.624 1247.6229 A W 0.42399758  
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  
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  
183 92 194612120STB NBA 1 1947 12/12/1946 19 0 CHS Stags 88 1319.0311 1343.2291 45.516144 STB Bombers 68 1339.8789 1315.6809 A W 0.33277613  
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  
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  
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  
200 100 194612160PIT NBA 1 1947 12/16/1946 19 0 STB Bombers 66 1304.6824 1317.0259 42.784809 PIT Ironmen 55 1236.7992 1224.4557 A W 0.45391136  

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