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,298 rows where lg_id = "ABA"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: _iscopy, year_id, is_playoffs, team_id, fran_id, opp_id, opp_fran, game_location, game_result

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
15163 15163 7582 196710130OAK ABA 0 1968 10/13/1967 1 0 OAK Squires 134 1300.0 1304.6908 41.49202 ANA Stars 129 1300.0 1295.3092 H W 0.64006501  
15164 15164 7582 196710130OAK ABA 1 1968 10/13/1967 1 0 ANA Stars 129 1300.0 1295.3092 40.50798 OAK Squires 134 1300.0 1304.6908 A L 0.35993499  
15169 15169 7585 196710140INA ABA 1 1968 10/14/1967 1 0 KEN Colonels 95 1300.0 1288.3286 39.776089 INA Pacers 117 1300.0 1311.6714 A L 0.35993499  
15170 15170 7585 196710140INA ABA 0 1968 10/14/1967 1 0 INA Pacers 117 1300.0 1311.6714 42.223911 KEN Colonels 95 1300.0 1288.3286 H W 0.64006501  
15173 15173 7587 196710150DNR ABA 1 1968 10/15/1967 2 0 ANA Stars 105 1295.3092 1290.7152 40.026249 DNR Nuggets 110 1300.0 1304.594 A L 0.35373795  
15174 15174 7587 196710150DNR ABA 0 1968 10/15/1967 1 0 DNR Nuggets 110 1300.0 1304.594 41.481869 ANA Stars 105 1295.3092 1290.7152 H W 0.64626205  
15175 15175 7588 196710160DLC ABA 0 1968 10/16/1967 1 0 DLC Spurs 129 1300.0 1304.0446 41.42424 ANA Stars 125 1290.7152 1286.6707 H W 0.65228397  
15176 15176 7588 196710160DLC ABA 1 1968 10/16/1967 3 0 ANA Stars 125 1290.7152 1286.6707 39.602352 DLC Spurs 129 1300.0 1304.0446 A L 0.34771603  
15185 15185 7593 196710170DNR ABA 1 1968 10/17/1967 1 0 HSM Spirits 102 1300.0 1320.657 43.16481 DNR Nuggets 85 1304.594 1283.937 A W 0.35386533  
15186 15186 7593 196710170DNR ABA 0 1968 10/17/1967 2 0 DNR Nuggets 85 1304.594 1283.937 39.316013 HSM Spirits 102 1300.0 1320.657 H L 0.64613467  
15193 15193 7597 196710180INA ABA 0 1968 10/18/1967 2 0 INA Pacers 106 1311.6714 1315.0002 42.572685 ANA Stars 103 1286.6707 1283.3418 H W 0.67251056  
15194 15194 7597 196710180INA ABA 1 1968 10/18/1967 4 0 ANA Stars 103 1286.6707 1283.3418 39.253685 INA Pacers 106 1311.6714 1315.0002 A L 0.32748944  
15199 15199 7600 196710190NOB ABA 0 1968 10/19/1967 1 0 NOB Sounds 120 1300.0 1306.621 41.694443 HSM Spirits 112 1320.657 1314.036 H W 0.61223936  
15200 15200 7600 196710190NOB ABA 1 1968 10/19/1967 2 0 HSM Spirits 112 1320.657 1314.036 42.471684 NOB Sounds 120 1300.0 1306.621 A L 0.38776064  
15201 15201 7601 196710190OAK ABA 0 1968 10/19/1967 2 0 OAK Squires 91 1304.6908 1286.595 39.594421 DNR Nuggets 104 1283.937 1302.0328 H L 0.66710377  
15202 15202 7601 196710190OAK ABA 1 1968 10/19/1967 3 0 DNR Nuggets 104 1283.937 1302.0328 41.213234 OAK Squires 91 1304.6908 1286.595 A W 0.33289623  
15207 15207 7604 196710200KEN ABA 1 1968 10/20/1967 3 0 INA Pacers 106 1315.0002 1325.796 43.701965 KEN Colonels 99 1288.3286 1277.5328 A W 0.39601147  
15208 15208 7604 196710200KEN ABA 0 1968 10/20/1967 2 0 KEN Colonels 99 1288.3286 1277.5328 38.645885 INA Pacers 106 1315.0002 1325.796 H L 0.60398853  
15209 15209 7605 196710200OAK ABA 0 1968 10/20/1967 3 0 OAK Squires 112 1286.595 1293.9949 40.37014 DNR Nuggets 102 1302.0328 1294.6329 H W 0.61934727 at San Jose CA
15210 15210 7605 196710200OAK ABA 1 1968 10/20/1967 4 0 DNR Nuggets 102 1302.0328 1294.6329 40.437054 OAK Squires 112 1286.595 1293.9949 A L 0.38065273 at San Jose CA
15223 15223 7612 196710210NOB ABA 1 1968 10/21/1967 4 0 INA Pacers 114 1325.796 1333.139 44.467831 NOB Sounds 111 1306.621 1299.278 A W 0.38573736  
15224 15224 7612 196710210NOB ABA 0 1968 10/21/1967 2 0 NOB Sounds 111 1306.621 1299.278 40.924259 INA Pacers 114 1325.796 1333.139 H L 0.61426264  
15229 15229 7615 196710220DLC ABA 1 1968 10/22/1967 5 0 INA Pacers 121 1333.139 1353.9999 46.628582 DLC Spurs 101 1304.0446 1283.1837 A W 0.39935219  
15230 15230 7615 196710220DLC ABA 0 1968 10/22/1967 2 0 DLC Spurs 101 1304.0446 1283.1837 39.237133 INA Pacers 121 1333.139 1353.9999 H L 0.60064781  
15231 15231 7616 196710220MNM ABA 1 1968 10/22/1967 3 0 KEN Colonels 104 1277.5328 1291.0062 40.056759 MNM Floridians 96 1300.0 1286.5266 A W 0.33070952  
15232 15232 7616 196710220MNM ABA 0 1968 10/22/1967 1 0 MNM Floridians 96 1300.0 1286.5266 39.587261 KEN Colonels 104 1277.5328 1291.0062 H L 0.66929048  
15233 15233 7617 196710230HSM ABA 1 1968 10/23/1967 3 0 DLC Spurs 100 1283.1837 1305.4297 41.569515 HSM Spirits 83 1314.036 1291.79 A W 0.32011437  
15234 15234 7617 196710230HSM ABA 0 1968 10/23/1967 3 0 HSM Spirits 83 1314.036 1291.79 40.138939 DLC Spurs 100 1283.1837 1305.4297 H L 0.67988563  
15235 15235 7618 196710230NJA ABA 0 1968 10/23/1967 1 0 NJA Nets 107 1300.0 1292.2209 40.18412 PTP Condors 110 1300.0 1307.7791 H L 0.64006501  
15236 15236 7618 196710230NJA ABA 1 1968 10/23/1967 1 0 PTP Condors 110 1300.0 1307.7791 41.81588 NJA Nets 107 1300.0 1292.2209 A W 0.35993499  
15245 15245 7623 196710240KEN ABA 1 1968 10/24/1967 5 0 ANA Stars 127 1283.3418 1280.738 38.98114 KEN Colonels 128 1291.0062 1293.61 A L 0.34983462  
15246 15246 7623 196710240KEN ABA 0 1968 10/24/1967 4 0 KEN Colonels 128 1291.0062 1293.61 40.329777 ANA Stars 127 1283.3418 1280.738 H W 0.65016538  
15247 15247 7624 196710240PTP ABA 0 1968 10/24/1967 2 0 PTP Condors 86 1307.7791 1285.254 39.453945 MNM Floridians 104 1286.5266 1309.0516 H L 0.66774088  
15248 15248 7624 196710240PTP ABA 1 1968 10/24/1967 2 0 MNM Floridians 104 1286.5266 1309.0516 41.949306 PTP Condors 86 1307.7791 1285.254 A W 0.33225912  
15259 15259 7630 196710250NJA ABA 1 1968 10/25/1967 3 0 MNM Floridians 100 1309.0516 1298.1259 40.803413 NJA Nets 118 1292.2209 1303.1467 A L 0.38254476  
15260 15260 7630 196710250NJA ABA 0 1968 10/25/1967 2 0 NJA Nets 118 1292.2209 1303.1467 41.33007 MNM Floridians 100 1309.0516 1298.1259 H W 0.61745524  
15261 15261 7631 196710260KEN ABA 1 1968 10/26/1967 3 0 NJA Nets 134 1303.1467 1310.7083 42.122967 KEN Colonels 131 1293.61 1286.0485 A W 0.37267727  
15262 15262 7631 196710260KEN ABA 0 1968 10/26/1967 5 0 KEN Colonels 131 1293.61 1286.0485 39.537167 NJA Nets 134 1303.1467 1310.7083 H L 0.62732273  
15263 15263 7632 196710260MNM ABA 1 1968 10/26/1967 6 0 ANA Stars 115 1280.738 1301.3052 41.136906 MNM Floridians 99 1298.1259 1277.5587 A W 0.33721304  
15264 15264 7632 196710260MNM ABA 0 1968 10/26/1967 4 0 MNM Floridians 99 1298.1259 1277.5587 38.648594 ANA Stars 115 1280.738 1301.3052 H L 0.66278696  
15265 15265 7633 196710260OAK ABA 1 1968 10/26/1967 6 0 INA Pacers 114 1353.9999 1348.574 46.069126 OAK Squires 118 1293.9949 1299.4208 A L 0.4426955  
15266 15266 7633 196710260OAK ABA 0 1968 10/26/1967 4 0 OAK Squires 118 1293.9949 1299.4208 40.939243 INA Pacers 114 1353.9999 1348.574 H W 0.5573045  
15277 15277 7639 196710270DLC ABA 0 1968 10/27/1967 4 0 DLC Spurs 97 1305.4297 1296.4701 40.629738 NOB Sounds 101 1299.278 1308.2375 H L 0.64818221 at Memphis TN
15278 15278 7639 196710270DLC ABA 1 1968 10/27/1967 3 0 NOB Sounds 101 1299.278 1308.2375 41.863953 DLC Spurs 97 1305.4297 1296.4701 A W 0.35181779 at Memphis TN
15279 15279 7640 196710270OAK ABA 0 1968 10/27/1967 5 0 OAK Squires 105 1299.4208 1284.0656 39.329472 INA Pacers 119 1348.574 1363.9292 H L 0.57265645 at San Jose CA
15280 15280 7640 196710270OAK ABA 1 1968 10/27/1967 7 0 INA Pacers 119 1348.574 1363.9292 47.646725 OAK Squires 105 1299.4208 1284.0656 A W 0.42734355 at San Jose CA
15281 15281 7641 196710270PTP ABA 0 1968 10/27/1967 3 0 PTP Condors 91 1285.254 1294.1874 40.390327 DNR Nuggets 77 1294.6329 1285.6996 H W 0.62753516  
15282 15282 7641 196710270PTP ABA 1 1968 10/27/1967 5 0 DNR Nuggets 77 1294.6329 1285.6996 39.500618 PTP Condors 91 1285.254 1294.1874 A L 0.37246484  
15289 15289 7645 196710280DLC ABA 1 1968 10/28/1967 4 0 PTP Condors 92 1294.1874 1305.0193 41.52647 DLC Spurs 86 1296.4701 1285.6382 A W 0.35691333  
15290 15290 7645 196710280DLC ABA 0 1968 10/28/1967 5 0 DLC Spurs 86 1296.4701 1285.6382 39.494186 PTP Condors 92 1294.1874 1305.0193 H L 0.64308667  
15291 15291 7646 196710280HSM ABA 0 1968 10/28/1967 4 0 HSM Spirits 94 1291.79 1278.0452 38.699455 NOB Sounds 104 1308.2375 1321.9824 H L 0.61797613  
15292 15292 7646 196710280HSM ABA 1 1968 10/28/1967 4 0 NOB Sounds 104 1308.2375 1321.9824 43.303429 HSM Spirits 94 1291.79 1278.0452 A W 0.38202387  
15293 15293 7647 196710280NJA ABA 1 1968 10/28/1967 6 0 DNR Nuggets 126 1285.6996 1307.5902 41.796078 NJA Nets 109 1310.7083 1288.8176 A W 0.32747936  
15294 15294 7647 196710280NJA ABA 0 1968 10/28/1967 4 0 NJA Nets 109 1310.7083 1288.8176 39.827339 DNR Nuggets 126 1285.6996 1307.5902 H L 0.67252064  
15301 15301 7651 196710290ANA ABA 0 1968 10/29/1967 7 0 ANA Stars 120 1301.3052 1293.1298 40.279415 OAK Squires 123 1284.0656 1292.241 H L 0.66259623  
15302 15302 7651 196710290ANA ABA 1 1968 10/29/1967 6 0 OAK Squires 123 1284.0656 1292.241 40.186218 ANA Stars 120 1301.3052 1293.1298 A W 0.33740377  
15303 15303 7652 196710290MNM ABA 1 1968 10/29/1967 6 0 KEN Colonels 81 1286.0485 1277.5709 38.649868 MNM Floridians 94 1277.5587 1286.0363 A L 0.37126929  
15304 15304 7652 196710290MNM ABA 0 1968 10/29/1967 5 0 MNM Floridians 94 1277.5587 1286.0363 39.535889 KEN Colonels 81 1286.0485 1277.5709 H W 0.62873071  
15305 15305 7653 196710300NJA ABA 0 1968 10/30/1967 5 0 NJA Nets 114 1288.8176 1296.5847 40.641762 KEN Colonels 101 1277.5709 1269.8038 H W 0.65484107  
15306 15306 7653 196710300NJA ABA 1 1968 10/30/1967 7 0 KEN Colonels 101 1277.5709 1269.8038 37.838844 NJA Nets 114 1288.8176 1296.5847 A L 0.34515893  
15307 15307 7654 196710300NOB ABA 1 1968 10/30/1967 5 0 PTP Condors 99 1305.0193 1291.8413 40.144314 NOB Sounds 128 1321.9824 1335.1604 A L 0.33775967 at Memphis TN
15308 15308 7654 196710300NOB ABA 0 1968 10/30/1967 5 0 NOB Sounds 128 1321.9824 1335.1604 44.678253 PTP Condors 99 1305.0193 1291.8413 H W 0.66224033 at Memphis TN
15315 15315 7658 196710310ANA ABA 0 1968 10/31/1967 8 0 ANA Stars 126 1293.1298 1296.8416 40.668701 OAK Squires 123 1292.241 1288.5292 H W 0.64124286  
15316 15316 7658 196710310ANA ABA 1 1968 10/31/1967 7 0 OAK Squires 123 1292.241 1288.5292 39.797108 ANA Stars 126 1293.1298 1296.8416 A L 0.35875714  
15317 15317 7659 196710310MNM ABA 0 1968 10/31/1967 6 0 MNM Floridians 108 1286.0363 1295.4581 40.523598 HSM Spirits 91 1278.0452 1268.6233 H W 0.65059298  
15318 15318 7659 196710310MNM ABA 1 1968 10/31/1967 5 0 HSM Spirits 91 1278.0452 1268.6233 37.715775 MNM Floridians 108 1286.0363 1295.4581 A L 0.34940702  
15319 15319 7660 196710310NJA ABA 1 1968 10/31/1967 8 0 KEN Colonels 107 1269.8038 1278.2001 38.715652 NJA Nets 104 1296.5847 1288.1885 A W 0.32523656  
15320 15320 7660 196710310NJA ABA 0 1968 10/31/1967 6 0 NJA Nets 104 1296.5847 1288.1885 39.761402 KEN Colonels 107 1269.8038 1278.2001 H L 0.67476344  
15331 15331 7666 196711010DNR ABA 0 1968 11/1/1967 7 0 DNR Nuggets 103 1307.5902 1293.4159 40.309422 PTP Condors 112 1291.8413 1306.0156 H L 0.66067511  
15332 15332 7666 196711010DNR ABA 1 1968 11/1/1967 6 0 PTP Condors 112 1291.8413 1306.0156 41.630962 DNR Nuggets 103 1307.5902 1293.4159 A W 0.33932489  
15333 15333 7667 196711010INA ABA 0 1968 11/1/1967 8 0 INA Pacers 123 1363.9292 1368.7815 48.141312 NJA Nets 113 1288.1885 1283.3362 H W 0.73334193  
15334 15334 7667 196711010INA ABA 1 1968 11/1/1967 7 0 NJA Nets 113 1288.1885 1283.3362 39.253098 INA Pacers 123 1363.9292 1368.7815 A L 0.26665807  
15337 15337 7669 196711020MNM ABA 1 1968 11/2/1967 9 0 INA Pacers 84 1368.7815 1351.4486 46.365776 MNM Floridians 109 1295.4581 1312.791 A L 0.46168453  
15338 15338 7669 196711020MNM ABA 0 1968 11/2/1967 7 0 MNM Floridians 109 1295.4581 1312.791 42.34124 INA Pacers 84 1368.7815 1351.4486 H W 0.53831547  
15339 15339 7670 196711020NOB ABA 1 1968 11/2/1967 8 0 NJA Nets 117 1283.3362 1273.558 38.230576 NOB Sounds 141 1335.1604 1344.9386 A L 0.29442883  
15340 15340 7670 196711020NOB ABA 0 1968 11/2/1967 6 0 NOB Sounds 141 1335.1604 1344.9386 45.693199 NJA Nets 117 1283.3362 1273.558 H W 0.70557117  
15341 15341 7671 196711020OAK ABA 1 1968 11/2/1967 7 0 PTP Condors 111 1306.0156 1314.3656 42.50621 OAK Squires 107 1288.5292 1280.1792 A W 0.38343674  
15342 15342 7671 196711020OAK ABA 0 1968 11/2/1967 8 0 OAK Squires 107 1288.5292 1280.1792 38.922668 PTP Condors 111 1306.0156 1314.3656 H L 0.61656326  
15349 15349 7675 196711030ANA ABA 1 1968 11/3/1967 8 0 PTP Condors 94 1314.3656 1308.3126 41.871826 ANA Stars 101 1296.8416 1302.8945 A L 0.38348794  
15350 15350 7675 196711030ANA ABA 0 1968 11/3/1967 9 0 ANA Stars 101 1296.8416 1302.8945 41.303619 PTP Condors 94 1314.3656 1308.3126 H W 0.61651206  
15361 15361 7681 196711040KEN ABA 0 1968 11/4/1967 9 0 KEN Colonels 104 1278.2001 1281.1987 39.02935 ANA Stars 103 1302.8945 1299.8959 H W 0.60670757  
15362 15362 7681 196711040KEN ABA 1 1968 11/4/1967 10 0 ANA Stars 103 1302.8945 1299.8959 40.989079 KEN Colonels 104 1278.2001 1281.1987 A L 0.39329243  
15363 15363 7682 196711040NOB ABA 1 1968 11/4/1967 6 0 HSM Spirits 105 1268.6233 1262.3458 37.06242 NOB Sounds 120 1344.9386 1351.2161 A L 0.26601177  
15364 15364 7682 196711040NOB ABA 0 1968 11/4/1967 7 0 NOB Sounds 120 1344.9386 1351.2161 46.341801 HSM Spirits 105 1268.6233 1262.3458 H W 0.73398823  
15367 15367 7684 196711050MNM ABA 0 1968 11/5/1967 8 0 MNM Floridians 119 1312.791 1325.5387 43.675091 ANA Stars 92 1299.8959 1287.1482 H W 0.65698266  
15368 15368 7684 196711050MNM ABA 1 1968 11/5/1967 11 0 ANA Stars 92 1299.8959 1287.1482 39.65239 MNM Floridians 119 1312.791 1325.5387 A L 0.34301734  
15369 15369 7685 196711060DNR ABA 1 1968 11/6/1967 12 0 ANA Stars 100 1287.1482 1276.1624 38.502632 DNR Nuggets 121 1293.4159 1304.4017 A L 0.35166556  
15370 15370 7685 196711060DNR ABA 0 1968 11/6/1967 8 0 DNR Nuggets 121 1293.4159 1304.4017 41.461704 ANA Stars 100 1287.1482 1276.1624 H W 0.64833444  
15371 15371 7686 196711060KEN ABA 0 1968 11/6/1967 10 0 KEN Colonels 95 1281.1987 1269.6602 37.82386 INA Pacers 105 1351.4486 1362.9872 H L 0.54270953  
15372 15372 7686 196711060KEN ABA 1 1968 11/6/1967 10 0 INA Pacers 105 1351.4486 1362.9872 47.550468 KEN Colonels 95 1281.1987 1269.6602 A W 0.45729047  
15373 15373 7687 196711060NOB ABA 0 1968 11/6/1967 8 0 NOB Sounds 136 1351.2161 1356.485 46.884117 OAK Squires 125 1280.1792 1274.9103 H W 0.72801352  
15374 15374 7687 196711060NOB ABA 1 1968 11/6/1967 9 0 OAK Squires 125 1280.1792 1274.9103 38.371807 NOB Sounds 136 1351.2161 1356.485 A L 0.27198648  
15383 15383 7692 196711070DLC ABA 0 1968 11/7/1967 6 0 DLC Spurs 118 1285.6382 1290.5514 40.009075 OAK Squires 112 1274.9103 1269.9971 H W 0.65416574  
15384 15384 7692 196711070DLC ABA 1 1968 11/7/1967 10 0 OAK Squires 112 1274.9103 1269.9971 37.858994 DLC Spurs 118 1285.6382 1290.5514 A L 0.34583426  
15385 15385 7693 196711070PTP ABA 1 1968 11/7/1967 11 0 INA Pacers 100 1362.9872 1380.1573 49.292225 PTP Condors 83 1308.3126 1291.1425 A W 0.435139  
15386 15386 7693 196711070PTP ABA 0 1968 11/7/1967 9 0 PTP Condors 83 1308.3126 1291.1425 40.071041 INA Pacers 100 1362.9872 1380.1573 H L 0.564861  
15395 15395 7698 196711080ANA ABA 0 1968 11/8/1967 13 0 ANA Stars 104 1276.1624 1280.1251 38.917007 HSM Spirits 100 1262.3458 1258.3831 H W 0.65817696  
15396 15396 7698 196711080ANA ABA 1 1968 11/8/1967 7 0 HSM Spirits 100 1262.3458 1258.3831 36.65099 ANA Stars 104 1276.1624 1280.1251 A L 0.34182304  
15397 15397 7699 196711080DNR ABA 1 1968 11/8/1967 11 0 OAK Squires 97 1269.9971 1260.3358 36.853626 DNR Nuggets 118 1304.4017 1314.063 A L 0.31568027  
15398 15398 7699 196711080DNR ABA 0 1968 11/8/1967 9 0 DNR Nuggets 118 1304.4017 1314.063 42.47451 OAK Squires 97 1269.9971 1260.3358 H W 0.68431973  

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