Historical NBA Elo: nbaallelo.csv

Table actions

This directory contains the data behind the Complete History Of The NBA interactive. Data updated periodically. Game information is from Basketball-Reference.com.

In the data file nbaallelo.csv are the following variables:

Header Definition
gameorder Play order of game in NBA history
game_id Unique ID for each game
lg_id Which league the game was played in
_iscopy Each row of data is tied to a single team for a single game, so _iscopy flags if this game_id has already occured for the opposing team in the same matchup
year_id Season id, named based on year in which the season ended
date_game Game date
is_playoffs Flag for playoff games
team_id Three letter code for team name, from Basketball Reference
fran_id Franchise id. Multiple team_ids can fall under the same fran_id due to name changes or moves. Interactive is grouped by fran_id.
pts Points scored by team
elo_i Team elo entering the game
elo_n Team elo following the game
win_equiv Equivalent number of wins in a 82-game season for a team of elo_n quality
opp_id Team id of opponent
opp_fran Franchise id of opponent
opp_pts Points scored by opponent
opp_elo_i Opponent elo entering the game
opp_elo_n Opponent elo following the game
game_location Home (H), away (A), or neutral (N)
game_result Win or loss for team in the team_id column
forecast Elo-based chances of winning for the team in the team_id column, based on elo ratings and game location
notes Additional information

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

8,066 rows where is_playoffs = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: lg_id, _iscopy, game_location, game_result, notes

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
663 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.5812912  
664 664 332 194704020CLR NBA 1 1947 4/2/1947 61 1 NYK Knicks 51 1332.156 1316.364 42.715511 CLR Rebels 77 1289.1487 1304.9407 A L 0.4187088  
665 665 333 194704020GSW NBA 1 1947 4/2/1947 62 1 STB Bombers 68 1369.4114 1365.1349 47.76981 PHW Warriors 73 1389.9673 1394.2438 A L 0.33314925  
666 666 333 194704020GSW NBA 0 1947 4/2/1947 61 1 PHW Warriors 73 1389.9673 1394.2438 50.698528 STB Bombers 68 1369.4114 1365.1349 H W 0.66685075  
667 667 334 194704020WSC NBA 0 1947 4/2/1947 61 1 WSC Capitols 65 1518.7253 1491.3843 59.611252 CHS Stags 81 1386.6256 1413.9667 H L 0.79184347  
668 668 334 194704020WSC NBA 1 1947 4/2/1947 62 1 CHS Stags 81 1386.6256 1413.9667 52.626957 WSC Capitols 65 1518.7253 1491.3843 A W 0.20815653  
669 669 335 194704030WSC NBA 1 1947 4/3/1947 63 1 CHS Stags 69 1413.9667 1438.0586 54.908096 WSC Capitols 53 1491.3843 1467.2924 A W 0.26477468  
670 670 335 194704030WSC NBA 0 1947 4/3/1947 62 1 WSC Capitols 53 1491.3843 1467.2924 57.549774 CHS Stags 69 1413.9667 1438.0586 H L 0.73522532  
671 671 336 194704050NYK NBA 0 1947 4/5/1947 62 1 NYK Knicks 86 1316.364 1323.7344 43.486576 CLR Rebels 74 1304.9407 1297.5703 H W 0.65507084  
672 672 336 194704050NYK NBA 1 1947 4/5/1947 62 1 CLR Rebels 74 1304.9407 1297.5703 40.74514 NYK Knicks 86 1316.364 1323.7344 A L 0.34492916  
673 673 337 194704050STB NBA 1 1947 4/5/1947 62 1 PHW Warriors 51 1394.2438 1381.0083 49.377796 STB Bombers 73 1365.1349 1378.3704 A L 0.3993721  
674 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  
675 675 338 194704060STB NBA 1 1947 4/6/1947 63 1 PHW Warriors 75 1381.0083 1400.4183 51.307644 STB Bombers 59 1378.3704 1358.9603 A W 0.36344081  
676 676 338 194704060STB NBA 0 1947 4/6/1947 64 1 STB Bombers 59 1378.3704 1358.9603 47.138187 PHW Warriors 75 1381.0083 1400.4183 H L 0.63655919  
677 677 339 194704080CHS NBA 0 1947 4/8/1947 64 1 CHS Stags 67 1438.0586 1446.8588 55.718647 WSC Capitols 55 1467.2924 1458.4922 H W 0.60045546  
678 678 339 194704080CHS NBA 1 1947 4/8/1947 63 1 WSC Capitols 55 1467.2924 1458.4922 56.77013 CHS Stags 67 1438.0586 1446.8588 A L 0.39954454  
679 679 340 194704090NYK NBA 0 1947 4/9/1947 63 1 NYK Knicks 93 1323.7344 1334.1049 44.568398 CLR Rebels 71 1297.5703 1287.1998 H W 0.67398375  
680 680 340 194704090NYK NBA 1 1947 4/9/1947 63 1 CLR Rebels 71 1297.5703 1287.1998 39.657799 NYK Knicks 93 1323.7344 1334.1049 A L 0.32601625  
681 681 341 194704100WSC NBA 1 1947 4/10/1947 65 1 CHS Stags 69 1446.8588 1441.5352 55.229828 WSC Capitols 76 1458.4922 1463.8158 A L 0.34465599  
682 682 341 194704100WSC NBA 0 1947 4/10/1947 64 1 WSC Capitols 76 1458.4922 1463.8158 57.243427 CHS Stags 69 1446.8588 1441.5352 H W 0.65534401  
683 683 342 194704120CHS NBA 1 1947 4/12/1947 65 1 WSC Capitols 67 1463.8158 1478.9536 58.561203 CHS Stags 55 1441.5352 1426.3973 A W 0.38998181  
684 684 342 194704120CHS NBA 0 1947 4/12/1947 66 1 CHS Stags 55 1441.5352 1426.3973 53.814899 WSC Capitols 67 1463.8158 1478.9536 H L 0.61001819  
685 685 343 194704120GSW NBA 1 1947 4/12/1947 64 1 NYK Knicks 70 1334.1049 1328.4071 43.974545 PHW Warriors 82 1400.4183 1406.1161 A L 0.27740359  
686 686 343 194704120GSW NBA 0 1947 4/12/1947 64 1 PHW Warriors 82 1400.4183 1406.1161 51.865456 NYK Knicks 70 1334.1049 1328.4071 H W 0.72259641  
687 687 344 194704130CHS NBA 0 1947 4/13/1947 67 1 CHS Stags 66 1426.3973 1432.2572 54.366898 WSC Capitols 61 1478.9536 1473.0938 H W 0.56785578  
688 688 344 194704130CHS NBA 1 1947 4/13/1947 66 1 WSC Capitols 61 1478.9536 1473.0938 58.056091 CHS Stags 66 1426.3973 1432.2572 A L 0.43214422  
689 689 345 194704140NYK NBA 1 1947 4/14/1947 65 1 PHW Warriors 72 1406.1161 1423.2423 53.515533 NYK Knicks 53 1328.4071 1311.2809 A W 0.46796459  
690 690 345 194704140NYK NBA 0 1947 4/14/1947 65 1 NYK Knicks 53 1328.4071 1311.2809 42.182987 PHW Warriors 72 1406.1161 1423.2423 H L 0.53203541  
691 691 346 194704160GSW NBA 0 1947 4/16/1947 66 1 PHW Warriors 84 1423.2423 1431.7393 54.318321 CHS Stags 71 1432.2572 1423.7603 H W 0.62802476  
692 692 346 194704160GSW NBA 1 1947 4/16/1947 68 1 CHS Stags 71 1432.2572 1423.7603 53.564781 PHW Warriors 84 1423.2423 1431.7393 A L 0.37197524  
693 693 347 194704170GSW NBA 0 1947 4/17/1947 67 1 PHW Warriors 85 1431.7393 1438.8226 54.978973 CHS Stags 74 1423.7603 1416.6769 H W 0.65057713  
694 694 347 194704170GSW NBA 1 1947 4/17/1947 69 1 CHS Stags 74 1423.7603 1416.6769 52.887863 PHW Warriors 85 1431.7393 1438.8226 A L 0.34942287  
695 695 348 194704190CHS NBA 0 1947 4/19/1947 70 1 CHS Stags 72 1416.6769 1409.4009 52.185097 PHW Warriors 75 1438.8226 1446.0986 H L 0.61020285  
696 696 348 194704190CHS NBA 1 1947 4/19/1947 68 1 PHW Warriors 75 1438.8226 1446.0986 55.649139 CHS Stags 72 1416.6769 1409.4009 A W 0.38979715  
697 697 349 194704200CHS NBA 1 1947 4/20/1947 69 1 PHW Warriors 73 1446.0986 1442.9448 55.359722 CHS Stags 74 1409.4009 1412.5547 A L 0.4098956  
698 698 349 194704200CHS NBA 0 1947 4/20/1947 71 1 CHS Stags 74 1409.4009 1412.5547 52.490616 PHW Warriors 73 1446.0986 1442.9448 H W 0.5901044  
699 699 350 194704220GSW NBA 1 1947 4/22/1947 72 1 CHS Stags 80 1412.5547 1409.3076 52.176041 PHW Warriors 83 1442.9448 1446.1919 A L 0.32069361  
700 700 350 194704220GSW NBA 0 1947 4/22/1947 70 1 PHW Warriors 83 1442.9448 1446.1919 55.657673 CHS Stags 80 1412.5547 1409.3076 H W 0.67930639  
1085 1085 543 194803230CHS NBA 1 1948 3/23/1948 49 1 WSC Capitols 70 1465.9006 1461.199 47.710297 CHS Stags 74 1440.7186 1445.4203 A L 0.39396232 Tiebreaker
1086 1086 543 194803230CHS NBA 0 1948 3/23/1948 49 1 CHS Stags 74 1440.7186 1445.4203 46.089687 WSC Capitols 70 1465.9006 1461.199 H W 0.60603768 Tiebreaker
1087 1087 544 194803230STB NBA 0 1948 3/23/1948 49 1 STB Bombers 60 1453.5326 1456.6012 47.240044 PHW Warriors 58 1442.6938 1439.6252 H W 0.65431005  
1088 1088 544 194803230STB NBA 1 1948 3/23/1948 49 1 PHW Warriors 58 1442.6938 1439.6252 45.490124 STB Bombers 60 1453.5326 1456.6012 A L 0.34568995  
1089 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
1090 1090 545 194803250CHS NBA 0 1948 3/25/1948 50 1 CHS Stags 72 1445.4203 1438.3618 45.359138 BLB Baltimore 75 1477.2552 1484.3137 H L 0.59685779 Tiebreaker
1091 1091 546 194803250STB NBA 0 1948 3/25/1948 50 1 STB Bombers 64 1456.6012 1450.6949 46.633507 PHW Warriors 65 1439.6252 1445.5315 H L 0.66225684  
1092 1092 546 194803250STB NBA 1 1948 3/25/1948 50 1 PHW Warriors 65 1439.6252 1445.5315 46.101173 STB Bombers 64 1456.6012 1450.6949 A W 0.33774316  
1093 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  
1094 1094 547 194803270BLB NBA 1 1948 3/27/1948 49 1 NYK Knicks 81 1416.0919 1413.0238 42.716827 BLB Baltimore 85 1484.3137 1487.3818 A L 0.27520698  
1095 1095 548 194803270GSW NBA 0 1948 3/27/1948 51 1 PHW Warriors 84 1445.5315 1459.7136 47.558567 STB Bombers 56 1450.6949 1436.5128 H W 0.6331892  
1096 1096 548 194803270GSW NBA 1 1948 3/27/1948 51 1 STB Bombers 56 1450.6949 1436.5128 45.167282 PHW Warriors 84 1445.5315 1459.7136 A L 0.3668108  
1097 1097 549 194803280BOS NBA 1 1948 3/28/1948 51 1 CHS Stags 79 1438.3618 1445.9944 46.148972 BOS Celtics 72 1312.5914 1304.9589 A W 0.53701872  
1098 1098 549 194803280BOS NBA 0 1948 3/28/1948 49 1 BOS Celtics 72 1312.5914 1304.9589 31.554913 CHS Stags 79 1438.3618 1445.9944 H L 0.46298128  
1099 1099 550 194803280NYK NBA 1 1948 3/28/1948 51 1 BLB Baltimore 69 1487.3818 1477.962 49.408604 NYK Knicks 79 1413.0238 1422.4436 A L 0.4631651  
1100 1100 550 194803280NYK NBA 0 1948 3/28/1948 50 1 NYK Knicks 79 1413.0238 1422.4436 43.702003 BLB Baltimore 69 1487.3818 1477.962 H W 0.5368349  
1101 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  
1102 1102 551 194803300GSW NBA 0 1948 3/30/1948 52 1 PHW Warriors 51 1459.7136 1449.249 46.484623 STB Bombers 56 1436.5128 1446.9774 H L 0.67022455  
1103 1103 552 194803310BOS NBA 0 1948 3/31/1948 50 1 BOS Celtics 81 1304.9589 1312.2666 32.283836 CHS Stags 77 1445.9944 1438.6866 H W 0.44121823  
1104 1104 552 194803310BOS NBA 1 1948 3/31/1948 52 1 CHS Stags 77 1445.9944 1438.6866 45.392822 BOS Celtics 81 1304.9589 1312.2666 A L 0.55878174  
1105 1105 553 194804010BLB NBA 1 1948 4/1/1948 51 1 NYK Knicks 77 1422.4436 1418.1036 43.248425 BLB Baltimore 84 1477.962 1482.302 A L 0.29003048  
1106 1106 553 194804010BLB NBA 0 1948 4/1/1948 52 1 BLB Baltimore 84 1477.962 1482.302 49.843689 NYK Knicks 77 1422.4436 1418.1036 H W 0.70996952  
1107 1107 554 194804010STB NBA 0 1948 4/1/1948 53 1 STB Bombers 69 1446.9774 1452.6415 46.833694 PHW Warriors 62 1449.249 1443.585 H W 0.63704693  
1108 1108 554 194804010STB NBA 1 1948 4/1/1948 53 1 PHW Warriors 62 1449.249 1443.585 45.900028 STB Bombers 69 1446.9774 1452.6415 A L 0.36295307  
1109 1109 555 194804020BOS NBA 0 1948 4/2/1948 51 1 BOS Celtics 74 1312.2666 1304.6532 31.524557 CHS Stags 81 1438.6866 1446.3 H L 0.46205163  
1110 1110 555 194804020BOS NBA 1 1948 4/2/1948 53 1 CHS Stags 81 1438.6866 1446.3 46.180523 BOS Celtics 74 1312.2666 1304.6532 A W 0.53794837  
1111 1111 556 194804030GSW NBA 0 1948 4/3/1948 54 1 PHW Warriors 84 1443.585 1456.1172 47.190441 STB Bombers 61 1452.6415 1440.1093 H W 0.62796879  
1112 1112 556 194804030GSW NBA 1 1948 4/3/1948 54 1 STB Bombers 61 1452.6415 1440.1093 45.540276 PHW Warriors 84 1443.585 1456.1172 A L 0.37203121  
1113 1113 557 194804060STB NBA 0 1948 4/6/1948 55 1 STB Bombers 46 1440.1093 1404.9396 41.869701 PHW Warriors 85 1456.1172 1491.2869 H L 0.61857337  
1114 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  
1115 1115 558 194804070CHS NBA 1 1948 4/7/1948 53 1 BLB Baltimore 73 1482.302 1491.9365 50.801998 CHS Stags 67 1446.3 1436.6655 A W 0.40892714  
1116 1116 558 194804070CHS NBA 0 1948 4/7/1948 54 1 CHS Stags 67 1446.3 1436.6655 45.183136 BLB Baltimore 73 1482.302 1491.9365 H L 0.59107286  
1117 1117 559 194804080BLB NBA 1 1948 4/8/1948 55 1 CHS Stags 72 1436.6655 1429.1002 44.396374 BLB Baltimore 89 1491.9365 1499.5018 A L 0.29032385  
1118 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  
1119 1119 560 194804100GSW NBA 0 1948 4/10/1948 56 1 PHW Warriors 71 1491.2869 1498.8964 51.487339 BLB Baltimore 60 1499.5018 1491.8923 H W 0.62909985  
1120 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  
1121 1121 561 194804130GSW NBA 0 1948 4/13/1948 57 1 PHW Warriors 63 1498.8964 1490.9568 50.705044 BLB Baltimore 66 1491.8923 1499.8319 H L 0.64930022  
1122 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 1123 562 194804150BLB NBA 0 1948 4/15/1948 57 1 BLB Baltimore 72 1499.8319 1502.9276 51.881477 PHW Warriors 70 1490.9568 1487.8611 H W 0.6517489  
1124 1124 562 194804150BLB NBA 1 1948 4/15/1948 58 1 PHW Warriors 70 1490.9568 1487.8611 50.397945 BLB Baltimore 72 1499.8319 1502.9276 A L 0.3482511  
1125 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  
1126 1126 563 194804170BLB NBA 1 1948 4/17/1948 59 1 PHW Warriors 75 1487.8611 1484.3778 50.051064 BLB Baltimore 78 1502.9276 1506.4109 A L 0.34020603  
1127 1127 564 194804200GSW NBA 0 1948 4/20/1948 60 1 PHW Warriors 91 1484.3778 1491.5179 50.76059 BLB Baltimore 82 1506.4109 1499.2708 H W 0.61035711  
1128 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  
1129 1129 565 194804210BLB NBA 1 1948 4/21/1948 61 1 PHW Warriors 73 1491.5179 1482.8484 49.898319 BLB Baltimore 88 1499.2708 1507.9403 A L 0.34971893  
1130 1130 565 194804210BLB NBA 0 1948 4/21/1948 60 1 BLB Baltimore 88 1499.2708 1507.9403 52.368565 PHW Warriors 73 1491.5179 1482.8484 H W 0.65028107  
1851 1851 926 194903220ROC NBA 0 1949 3/22/1949 61 1 ROC Kings 93 1604.3776 1609.6759 57.518444 STB Bombers 64 1407.9425 1402.6442 H W 0.846371  
1852 1852 926 194903220ROC NBA 1 1949 3/22/1949 61 1 STB Bombers 64 1407.9425 1402.6442 36.808792 ROC Kings 93 1604.3776 1609.6759 A L 0.153629  
1853 1853 927 194903230BLB NBA 0 1949 3/23/1949 61 1 BLB Baltimore 82 1469.6973 1472.2782 44.092518 NYK Knicks 81 1460.0726 1457.4917 H W 0.65272754  
1854 1854 927 194903230BLB NBA 1 1949 3/23/1949 61 1 NYK Knicks 81 1460.0726 1457.4917 42.546627 BLB Baltimore 82 1469.6973 1472.2782 A L 0.34727246  
1855 1855 928 194903230LAL NBA 1 1949 3/23/1949 61 1 CHS Stags 77 1558.5707 1553.6992 52.336205 MNL Lakers 84 1589.61 1594.4814 A L 0.31988007  
1856 1856 928 194903230LAL NBA 0 1949 3/23/1949 61 1 MNL Lakers 84 1589.61 1594.4814 56.162773 CHS Stags 77 1558.5707 1553.6992 H W 0.68011993  
1857 1857 929 194903230GSW NBA 0 1949 3/23/1949 61 1 PHW Warriors 70 1461.3064 1436.5133 40.346878 WSC Capitols 92 1455.3372 1480.1302 H L 0.6479426  
1858 1858 929 194903230GSW NBA 1 1949 3/23/1949 61 1 WSC Capitols 92 1455.3372 1480.1302 44.910126 PHW Warriors 70 1461.3064 1436.5133 A W 0.3520574  
1859 1859 930 194903230STB NBA 0 1949 3/23/1949 62 1 STB Bombers 64 1402.6442 1399.5227 36.485058 ROC Kings 66 1609.6759 1612.7974 H L 0.35066345  
1860 1860 930 194903230STB NBA 1 1949 3/23/1949 62 1 ROC Kings 66 1609.6759 1612.7974 57.79184 STB Bombers 64 1402.6442 1399.5227 A W 0.64933658  
1861 1861 931 194903240CHS NBA 0 1949 3/24/1949 62 1 CHS Stags 85 1553.6992 1536.4502 50.645649 MNL Lakers 101 1594.4814 1611.7305 H L 0.58440548  
1862 1862 931 194903240CHS NBA 1 1949 3/24/1949 62 1 MNL Lakers 101 1594.4814 1611.7305 57.698593 CHS Stags 85 1553.6992 1536.4502 A W 0.41559452  
1863 1863 932 194903240NYK NBA 0 1949 3/24/1949 62 1 NYK Knicks 84 1457.4917 1464.8707 43.318913 BLB Baltimore 74 1472.2782 1464.8992 H W 0.62023091  
1864 1864 932 194903240NYK NBA 1 1949 3/24/1949 62 1 BLB Baltimore 74 1472.2782 1464.8992 43.321888 NYK Knicks 84 1457.4917 1464.8707 A L 0.37976909  
1865 1865 933 194903240WSC NBA 1 1949 3/24/1949 62 1 PHW Warriors 78 1436.5133 1433.8754 40.070274 WSC Capitols 80 1480.1302 1482.7682 A L 0.30433786  
1866 1866 933 194903240WSC NBA 0 1949 3/24/1949 62 1 WSC Capitols 80 1480.1302 1482.7682 45.184135 PHW Warriors 78 1436.5133 1433.8754 H W 0.69566214  

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" TEXT
);