nba-elo/nbaallelo

126,314 rows sorted by fran_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
702 351 194711120WSC NBA 1 1948 11/12/1947 1 0 BLB Baltimore 55 1419.0 1414.4618 42.867378 WSC Capitols 63 1481.0703 1485.6085 A L 0.28232628  
703 352 194711130BLB NBA 0 1948 11/13/1947 2 0 BLB Baltimore 85 1414.4618 1418.4851 43.288319 BOS Celtics 74 1289.9966 1285.9733 H W 0.78450674  
715 358 194711150CHS NBA 1 1948 11/15/1947 3 0 BLB Baltimore 67 1418.4851 1427.8206 44.263027 CHS Stags 63 1439.0546 1429.7191 A W 0.33313191  
730 365 194711200BLB NBA 0 1948 11/20/1947 4 0 BLB Baltimore 68 1427.8206 1434.0065 44.906929 NYK Knicks 56 1378.5894 1372.4034 H W 0.70246083  
738 369 194711210BOS NBA 1 1948 11/21/1947 5 0 BLB Baltimore 89 1434.0065 1446.2875 46.179226 BOS Celtics 73 1298.5594 1286.2784 A W 0.55083609  
740 370 194711220BLB NBA 0 1948 11/22/1947 6 0 BLB Baltimore 75 1446.2875 1450.1345 46.575817 CHS Stags 72 1453.5292 1449.6821 H W 0.6304062  
756 378 194711270PRO NBA 1 1948 11/27/1947 7 0 BLB Baltimore 76 1450.1345 1461.2076 47.711178000000004 PRO Steamrollers 61 1299.6395 1288.5664 A W 0.57216078  
762 381 194711290STB NBA 1 1948 11/29/1947 8 0 BLB Baltimore 71 1461.2076 1468.4745 48.45068 STB Bombers 67 1400.5768 1393.3099 A W 0.44358450000000005  
768 384 194712020BOS NBA 1 1948 12/2/1947 9 0 BLB Baltimore 77 1468.4745 1475.3063 49.141373 BOS Celtics 69 1296.5094 1289.6776 A W 0.60210991  
774 387 194712030GSW NBA 1 1948 12/3/1947 10 0 BLB Baltimore 73 1475.3063 1491.0424 50.713516 PHW Warriors 58 1419.7545 1404.0184 A W 0.43638057  
776 388 194712040BLB NBA 0 1948 12/4/1947 11 0 BLB Baltimore 51 1491.0424 1468.8303 48.486767 STB Bombers 65 1410.4642 1432.6763 H L 0.73875183  
780 390 194712060CHS NBA 1 1948 12/6/1947 12 0 BLB Baltimore 65 1468.8303 1462.519 47.844978000000005 CHS Stags 73 1459.2689 1465.5802 A L 0.37271047  
790 395 194712110BLB NBA 0 1948 12/11/1947 13 0 BLB Baltimore 69 1462.519 1455.3406 47.110809 WSC Capitols 71 1439.6432 1446.8217 H L 0.66981095  
798 399 194712130BLB NBA 0 1948 12/13/1947 14 0 BLB Baltimore 66 1455.3406 1435.9226 45.106003 NYK Knicks 80 1426.656 1446.0739999999998 H L 0.67716378  
805 403 194712170WSC NBA 1 1948 12/17/1947 15 0 BLB Baltimore 64 1435.9226 1432.9059 44.7925 WSC Capitols 66 1450.5361 1453.5529 A L 0.34079164  
808 404 194712180BLB NBA 0 1948 12/18/1947 16 0 BLB Baltimore 74 1432.9059 1438.896 45.414528000000004 STB Bombers 67 1448.0066 1442.0165 H W 0.61980474  
821 411 194712210CHS NBA 1 1948 12/21/1947 17 0 BLB Baltimore 83 1438.896 1431.9843 44.696632 CHS Stags 93 1439.0692 1445.981 A L 0.35970533  
828 414 194712250BLB NBA 0 1948 12/25/1947 18 0 BLB Baltimore 87 1431.9843 1442.7125 45.809795 CHS Stags 70 1453.6643 1442.9360000000001 H W 0.61084032  
841 421 194712280STB NBA 1 1948 12/28/1947 19 0 BLB Baltimore 63 1442.7125 1438.0684 45.328701 STB Bombers 67 1420.4274 1425.0715 A L 0.38998801  
847 424 194801010BLB NBA 0 1948 1/1/1948 20 0 BLB Baltimore 60 1438.0684 1419.0874 43.351292 PHW Warriors 72 1380.2854 1399.2664 H L 0.71264637  
853 427 194801030NYK NBA 1 1948 1/3/1948 21 0 BLB Baltimore 79 1419.0874 1433.5667 44.861206 NYK Knicks 70 1442.4113 1427.932 A W 0.32961893  
862 431 194801060BLB NBA 0 1948 1/6/1948 22 0 BLB Baltimore 82 1433.5667 1437.2885 45.247787 PRO Steamrollers 64 1234.1946 1230.4728 H W 0.84855652  
865 433 194801080BLB NBA 0 1948 1/8/1948 23 0 BLB Baltimore 78 1437.2885 1441.6934 45.70433 CHS Stags 75 1476.3317 1471.9268 H W 0.58683473  
879 440 194801110STB NBA 1 1948 1/11/1948 24 0 BLB Baltimore 54 1441.6934 1432.7007 44.771159999999995 STB Bombers 69 1441.2224 1450.2151 A L 0.36055982  
884 442 194801150PRO NBA 1 1948 1/15/1948 25 0 BLB Baltimore 98 1432.7007 1444.0375 45.946812 PRO Steamrollers 78 1241.2612 1229.9244 A W 0.62863553  
889 445 194801160GSW NBA 1 1948 1/16/1948 26 0 BLB Baltimore 63 1444.0375 1435.5679 45.069164 PHW Warriors 72 1380.4819 1388.9515 A L 0.44774371  
892 446 194801170BLB NBA 0 1948 1/17/1948 27 0 BLB Baltimore 77 1435.5679 1427.912 44.27256 PHW Warriors 79 1388.9515 1396.6074 H L 0.69930518  
905 453 194801220BLB NBA 0 1948 1/22/1948 28 0 BLB Baltimore 68 1427.912 1420.0409 43.450965999999994 STB Bombers 71 1423.8926 1431.7637 H L 0.64537799  
914 457 194801240NYK NBA 1 1948 1/24/1948 29 0 BLB Baltimore 72 1420.0409 1437.9136 45.312645 NYK Knicks 58 1419.5917 1401.719 A W 0.36053097  
921 461 194801270CHS NBA 1 1948 1/27/1948 30 0 BLB Baltimore 74 1437.9136 1434.0548 44.911953000000004 CHS Stags 78 1457.5872 1461.4459 A L 0.33427858  
932 466 194801300BLB NBA 0 1948 1/30/1948 31 0 BLB Baltimore 95 1434.0548 1448.5005 46.40749 WSC Capitols 71 1469.3469 1454.9012 H W 0.59206015 at Baltimore's Fifth Regiment Armory
938 469 194801310PRO NBA 1 1948 1/31/1948 32 0 BLB Baltimore 68 1448.5005 1453.5741 46.929508 PRO Steamrollers 62 1244.9475 1239.8739 A W 0.64476329  
950 475 194802040WSC NBA 1 1948 2/4/1948 33 0 BLB Baltimore 72 1453.5741 1449.0182 46.460842 WSC Capitols 77 1460.1292 1464.6851 A L 0.3512885  
952 476 194802050BLB NBA 0 1948 2/5/1948 34 0 BLB Baltimore 100 1449.0182 1453.1688 46.887882 PRO Steamrollers 74 1222.915 1218.7644 H W 0.86728925  
974 487 194802120BLB NBA 0 1948 2/12/1948 35 0 BLB Baltimore 96 1453.1688 1459.9668 47.584441999999996 NYK Knicks 86 1449.2552 1442.4573 H W 0.64523858  
988 494 194802150STB NBA 1 1948 2/15/1948 36 0 BLB Baltimore 63 1459.9668 1454.2886 47.002869 STB Bombers 69 1437.6875 1443.3657 A L 0.38998002  
992 496 194802190BOS NBA 1 1948 2/19/1948 37 0 BLB Baltimore 79 1454.2886 1458.3218 47.416225 BOS Celtics 76 1272.4315 1268.3983 A W 0.61566943  
1002 501 194802210WSC NBA 1 1948 2/21/1948 38 0 BLB Baltimore 72 1458.3218 1450.7421 46.638355 WSC Capitols 85 1474.9669 1482.5466 A L 0.33816922  
1008 504 194802240GSW NBA 1 1948 2/24/1948 39 0 BLB Baltimore 71 1450.7421 1441.2798 45.661514000000004 PHW Warriors 83 1404.0222 1413.4845 A L 0.42391914  
1011 506 194802260BLB NBA 0 1948 2/26/1948 40 0 BLB Baltimore 97 1441.2798 1456.5886 47.238754 WSC Capitols 70 1470.3102 1455.0013 H W 0.60073626  
1020 510 194802280NYK NBA 1 1948 2/28/1948 41 0 BLB Baltimore 78 1456.5886 1480.5824 49.671539 NYK Knicks 56 1451.4072 1427.4135 A W 0.36683482  
1025 513 194802290BOS NBA 1 1948 2/29/1948 42 0 BLB Baltimore 62 1480.5824 1472.9095 48.89959 BOS Celtics 65 1285.2273 1292.9001 A L 0.63388222  
1031 516 194803040BLB NBA 0 1948 3/4/1948 43 0 BLB Baltimore 84 1472.9095 1479.1697 49.529872999999995 STB Bombers 75 1464.8804 1458.6202 H W 0.65064281  
1038 519 194803060BLB NBA 0 1948 3/6/1948 44 0 BLB Baltimore 81 1479.1697 1482.4155 49.855042 BOS Celtics 68 1294.4719 1291.2261 H W 0.83737868  
1051 526 194803110BLB NBA 0 1948 3/11/1948 45 0 BLB Baltimore 86 1482.4155 1486.1351 50.226238 CHS Stags 83 1482.0037 1478.2841 H W 0.64061105  
1055 528 194803130BLB NBA 0 1948 3/13/1948 46 0 BLB Baltimore 64 1486.1351 1488.6462 50.475941 PHW Warriors 62 1432.152 1429.6409 H W 0.70814633  
1069 535 194803180BLB NBA 0 1948 3/18/1948 47 0 BLB Baltimore 64 1488.6462 1475.3416 49.144928 WSC Capitols 71 1442.7393 1456.0439 H L 0.69844586  
1078 539 194803200BLB NBA 0 1948 3/20/1948 48 0 BLB Baltimore 75 1475.3416 1477.2552 49.337555 PRO Steamrollers 58 1166.3071 1164.3934 H W 0.91329849  
1089 545 194803250CHS NBA 1 1948 3/25/1948 49 1 BLB Baltimore 75 1477.2552 1484.3137 50.044666 CHS Stags 72 1445.4203 1438.3618 A W 0.40314221 Tiebreaker
1093 547 194803270BLB NBA 0 1948 3/27/1948 50 1 BLB Baltimore 85 1484.3137 1487.3818 50.3503 NYK Knicks 81 1416.0919 1413.0238 H W 0.72479302  
1099 550 194803280NYK NBA 1 1948 3/28/1948 51 1 BLB Baltimore 69 1487.3818 1477.9620000000002 49.408604 NYK Knicks 79 1413.0238 1422.4436 A L 0.4631651  
1106 553 194804010BLB NBA 0 1948 4/1/1948 52 1 BLB Baltimore 84 1477.9620000000002 1482.3020000000001 49.843689000000005 NYK Knicks 77 1422.4436 1418.1036 H W 0.70996952  
1115 558 194804070CHS NBA 1 1948 4/7/1948 53 1 BLB Baltimore 73 1482.3020000000001 1491.9365 50.801998 CHS Stags 67 1446.3 1436.6655 A W 0.40892714  
1118 559 194804080BLB NBA 0 1948 4/8/1948 54 1 BLB Baltimore 89 1491.9365 1499.5018 51.546669 CHS Stags 72 1436.6655 1429.1002 H W 0.70967615  
1120 560 194804100GSW NBA 1 1948 4/10/1948 55 1 BLB Baltimore 60 1499.5018 1491.8923 50.797626 PHW Warriors 71 1491.2869 1498.8964 A L 0.37090015  
1122 561 194804130GSW NBA 1 1948 4/13/1948 56 1 BLB Baltimore 66 1491.8923 1499.8319 51.578995 PHW Warriors 63 1498.8964 1490.9568 A W 0.35069978  
1123 562 194804150BLB NBA 0 1948 4/15/1948 57 1 BLB Baltimore 72 1499.8319 1502.9276 51.881477000000004 PHW Warriors 70 1490.9568 1487.8611 H W 0.6517489000000001  
1125 563 194804170BLB NBA 0 1948 4/17/1948 58 1 BLB Baltimore 78 1502.9276 1506.4109 52.22031 PHW Warriors 75 1487.8611 1484.3778 H W 0.65979397  
1128 564 194804200GSW NBA 1 1948 4/20/1948 59 1 BLB Baltimore 82 1506.4109 1499.2708 51.524029 PHW Warriors 91 1484.3778 1491.5179 A L 0.38964289  
1130 565 194804210BLB NBA 0 1948 4/21/1948 60 1 BLB Baltimore 88 1499.2708 1507.9403 52.368565000000004 PHW Warriors 73 1491.5179 1482.8484 H W 0.65028107  
1138 569 194811040BLB NBA 0 1949 11/4/1948 1 0 BLB Baltimore 72 1507.2052 1491.9507 46.134853 MNL Lakers 84 1527.0 1542.2545 H L 0.61341697  
1145 573 194811060CHS NBA 1 1949 11/6/1948 2 0 BLB Baltimore 69 1491.9507 1482.1023 45.115002000000004 CHS Stags 82 1448.0752 1457.9236 A L 0.41992563  
1157 579 194811070FTW NBA 1 1949 11/7/1948 3 0 BLB Baltimore 78 1482.1023 1487.6229 45.687408000000005 FTW Pistons 77 1475.8389 1470.3182 A W 0.36828274  
1162 581 194811090INJ NBA 1 1949 11/9/1948 4 0 BLB Baltimore 65 1487.6229 1491.1696 46.054184 INJ Jets 64 1353.3118 1349.7651 A W 0.54921782  
1170 585 194811110BLB NBA 0 1949 11/11/1948 5 0 BLB Baltimore 68 1491.1696 1484.519 45.365795 WSC Capitols 70 1494.8546 1501.5051 H L 0.63516355  
1182 591 194811130NYK NBA 1 1949 11/13/1948 6 0 BLB Baltimore 87 1484.519 1479.6074 44.855778 NYK Knicks 91 1448.9517 1453.8633 A L 0.40832263  
1207 604 194811180BLB NBA 0 1949 11/18/1948 7 0 BLB Baltimore 55 1479.6074 1461.3345 42.948982 NYK Knicks 67 1436.3691 1454.6421 H L 0.69520044  
1214 607 194811190BLB NBA 0 1949 11/19/1948 8 0 BLB Baltimore 72 1461.3345 1446.1954 41.362427000000004 STB Bombers 82 1444.9471 1460.0862 H L 0.66149855 at Chicago IL
1224 612 194811200STB NBA 1 1949 11/20/1948 9 0 BLB Baltimore 85 1446.1954 1470.7444 43.932495 STB Bombers 64 1460.0862 1435.5372 A W 0.34172696  
1229 615 194811210LAL NBA 1 1949 11/21/1948 10 0 BLB Baltimore 81 1470.7444 1464.2931 43.258511 MNL Lakers 94 1521.9955 1528.4468 A L 0.29511464  
1239 620 194811230ROC NBA 1 1949 11/23/1948 11 0 BLB Baltimore 90 1464.2931 1457.912 42.590649 ROC Kings 108 1562.0442 1568.4253 A L 0.24262398  
1243 622 194811250BLB NBA 0 1949 11/25/1948 12 0 BLB Baltimore 69 1457.912 1462.799 43.102226 FTW Pistons 64 1467.2434 1462.3564 H W 0.627599  
1253 627 194811270PRO NBA 1 1949 11/27/1948 13 0 BLB Baltimore 91 1462.799 1471.7952 44.042133 PRO Steamrollers 71 1220.4431 1211.4469 A W 0.69412303  
1281 641 194812020BLB NBA 0 1949 12/2/1948 14 0 BLB Baltimore 90 1471.7952 1475.5448 44.432995 INJ Jets 78 1323.4193 1319.6697 H W 0.80686492  
1298 649 194812040WSC NBA 1 1949 12/4/1948 15 0 BLB Baltimore 82 1475.5448 1473.6854 44.239246 WSC Capitols 83 1554.5892 1556.4486 A L 0.26295567  
1316 658 194812080GSW NBA 1 1949 12/8/1948 16 0 BLB Baltimore 83 1473.6854 1482.1414 45.119061 PHW Warriors 78 1426.4895 1418.0336 A W 0.42458856  
1317 659 194812090BLB NBA 0 1949 12/9/1948 17 0 BLB Baltimore 92 1482.1414 1484.1418 45.326675 PHW Warriors 91 1418.0336 1416.0331 H W 0.72004408  
1328 664 194812110NYK NBA 1 1949 12/11/1948 18 0 BLB Baltimore 71 1484.1418 1481.418 45.043929999999996 NYK Knicks 72 1481.652 1484.3759 A L 0.36324358  
1336 668 194812130BLB NBA 0 1949 12/13/1948 19 0 BLB Baltimore 70 1481.418 1471.5775 44.019424 CHS Stags 75 1479.7391 1489.5796 H L 0.64228839 at Indianapolis IN
1342 671 194812140BLB NBA 0 1949 12/14/1948 20 0 BLB Baltimore 88 1471.5775 1475.7483 44.454189 INJ Jets 75 1333.5692 1329.3984 H W 0.79739404 at Chicago IL
1352 676 194812160BLB NBA 0 1949 12/16/1948 21 0 BLB Baltimore 82 1475.7483 1466.6144 43.501183000000005 STB Bombers 85 1417.3445 1426.4784 H L 0.71337771  
1356 678 194812170BOS NBA 1 1949 12/17/1948 22 0 BLB Baltimore 74 1466.6144 1477.9425 44.68261 BOS Celtics 63 1374.3876 1363.0594 A W 0.48881537  
1383 692 194812230BLB NBA 0 1949 12/23/1948 23 0 BLB Baltimore 96 1477.9425 1483.6027 45.270740999999994 CHS Stags 89 1480.0592 1474.399 H W 0.63725311  
1393 697 194812250PRO NBA 1 1949 12/25/1948 24 0 BLB Baltimore 88 1483.6027 1486.4458 45.565506 PRO Steamrollers 83 1178.6781 1175.835 A W 0.76488316  
1409 705 194812290BLB NBA 0 1949 12/29/1948 25 0 BLB Baltimore 88 1486.4458 1458.1956 42.62035 PRO Steamrollers 98 1175.835 1204.0852 H L 0.91401434  
1416 708 194812300BLB NBA 0 1949 12/30/1948 26 0 BLB Baltimore 100 1458.1956 1469.2614 43.777687 ROC Kings 89 1559.5376 1548.4718 H W 0.49806866  
1425 713 194901010BLB NBA 0 1949 1/1/1949 27 0 BLB Baltimore 72 1469.2614 1471.9954 44.063015 BOS Celtics 67 1356.6797 1353.9457 H W 0.77271724  
1443 722 194901040BOS NBA 1 1949 1/4/1949 28 0 BLB Baltimore 69 1471.9954 1464.5746 43.287945 BOS Celtics 75 1383.0637 1390.4845 A L 0.48407674  
1453 727 194901050WSC NBA 1 1949 1/5/1949 29 0 BLB Baltimore 88 1464.5746 1493.6505 46.310265 WSC Capitols 68 1556.5536 1527.4777 A W 0.24878179999999997  
1455 728 194901060BLB NBA 0 1949 1/6/1949 30 0 BLB Baltimore 93 1493.6505 1497.2458 46.680622 PHW Warriors 88 1436.1073 1432.5120000000002 H W 0.71236366  
1464 732 194901080NYK NBA 1 1949 1/8/1949 31 0 BLB Baltimore 83 1497.2458 1503.9906 47.37281 NYK Knicks 81 1498.3282 1491.5835 A W 0.35850078  
1488 744 194901120BLB NBA 0 1949 1/12/1949 32 0 BLB Baltimore 106 1503.9906 1513.9349 48.386497 WSC Capitols 92 1538.493 1528.5487 H W 0.59315759  
1496 748 194901130BLB NBA 0 1949 1/13/1949 33 0 BLB Baltimore 85 1513.9349 1496.6301 46.617259999999995 ROC Kings 102 1566.2607 1583.5656 H L 0.56818128  
1504 752 194901150GSW NBA 1 1949 1/15/1949 34 0 BLB Baltimore 87 1496.6301 1489.4679999999998 45.878319 PHW Warriors 94 1438.5624 1445.7245 A L 0.43994594  
1529 765 194901200BLB NBA 0 1949 1/20/1949 35 0 BLB Baltimore 82 1489.4679999999998 1497.5818 46.715179 NYK Knicks 68 1477.1486 1469.0348 H W 0.65623546  
1542 771 194901220PRO NBA 1 1949 1/22/1949 36 0 BLB Baltimore 86 1497.5818 1487.2418 45.647953 PRO Steamrollers 89 1187.9786 1198.3186 A L 0.76969194  
1562 781 194901260BLB NBA 0 1949 1/26/1949 37 0 BLB Baltimore 96 1487.2418 1495.7163 46.523174 WSC Capitols 86 1534.9955 1526.521 H W 0.57462686  
1569 785 194901270BLB NBA 0 1949 1/27/1949 38 0 BLB Baltimore 89 1495.7163 1475.9066 44.47068 PRO Steamrollers 95 1220.6166 1240.4263 H L 0.89652979  
1586 793 194901290ROC NBA 1 1949 1/29/1949 39 0 BLB Baltimore 86 1475.9066 1473.6287 44.23333 ROC Kings 90 1603.1184 1605.3964 A L 0.21283239  
1590 795 194901300FTW NBA 1 1949 1/30/1949 40 0 BLB Baltimore 93 1473.6287 1489.0626 45.836391 FTW Pistons 78 1412.3123 1396.8783 A W 0.44455874  

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