⌘K commands · ? keys
Datasets (20)
Pick a table first, then a column. Each dataset says what one row is, what identifies it and the time it is stamped with, which is the anchor for a point-in-time join.
Showing (20) of (20) · Datasets
| Dataset | Group | One row is | Keys | Stamped at | Fields | Known pregame | Outcomes | Sports | Source |
|---|---|---|---|---|---|---|---|---|---|
| Team games | Games and results | One team in one game: the result, closing lines, rest, travel, weather and venue. | team_id, game_id | game start | 54 | 33 | 9 | 10 | Computed by Kelly from stored data |
| Game context | Context | What is known about a game for a player or team row: home, rest, opponent, week and roof. | subject_id, game_id | game start | 40 | 36 | 1 | 11 | Computed by Kelly from stored data |
| Games | Games and results | One game: the teams, start time, state, score, broadcasts and weather. | game_id | game start | 120 | — | — | — | League and data-provider feeds |
| Standings and ratings | Games and results | One team at a point in a season: its record, playoff picture and rating. | team_id, season, week | week | 12 | — | — | — | Computed by Kelly from stored data |
| Player game stats | Player and team stats | One player in one game: every catalogue stat the league records. | player_id, game_id | game start | 206 | — | 2 | 7 | League and data-provider feeds |
| Team game stats | Player and team stats | One team in one game: box score lines and rates. | team_id, game_id | game start | 41 | — | 1 | 6 | League and data-provider feeds |
| Player season stats | Player and team stats | One player in one season: stats that exist only at season grain. | player_id, season | season end | 40 | — | — | 5 | League and data-provider feeds |
| Team season stats | Player and team stats | One team in one season: summed from games, or as the league published it. | team_id, season | season end | 97 | — | 4 | 6 | League and data-provider feeds |
| Play by play | Player and team stats | One play: the situation, what happened and the engine's aggregates over plays. | play_id | play time | 22 | — | — | — | League and data-provider feeds |
| Lines and prices | Lines and prices | A market at a moment: the consensus line, no-vig probability, hold, books counted and movement. | market_id, moment | price time | 67 | 2 | — | — | Sportsbook and odds feeds |
| Market signals | Lines and prices | Signals on the day's slate: which book moved a line first, betting splits and steam. | game_id, market, time | signal time | 19 | — | — | — | Computed by Kelly from stored data |
| Analyst picks | Lines and prices | A tracked analyst pick, with the line when it came out and at the close, and analysts' records. | pick_id | pick time | 11 | 6 | — | — | Collected and tracked by Kelly |
| Players | Reference | A player in a week: identity, team, position, injury status, usage and projections. | player_id, week | as reported | 66 | — | — | — | League and data-provider feeds |
| Teams, leagues and seasons | Reference | Identity rows every other dataset joins to: sports, leagues, seasons, teams, venues and books. | id | static | 43 | 25 | — | — | League and data-provider feeds |
| Fantasy | Fantasy | Waiver, trade and start-or-sit comparisons for a player in a league week. | player_id, week | week | 161 | — | — | — | Computed by Kelly from stored data |
| News | Context | A story: when it was first seen, who reported it and what it is about. | story_id | first seen | 25 | 2 | — | — | Collected and tracked by Kelly |
| Reference library | Reference | Reviewed reference entries: rules, law, tax, glossary terms and regulator statistics. | entry_id | reviewed date | 37 | 35 | — | — | Written and reviewed by Kelly |
| Strategies | Reference | A betting or fantasy strategy and Kelly's check of it: the verdict, the decisive figure and evidence. | strategy_id | static | 13 | 2 | — | — | Written and reviewed by Kelly |
| Exchange ticks | Racing and exchange | One price change on an exchange market: back and lay prices, sizes and traded volume. | market_id, selection_id, time | tick time | 51 | — | — | 1 | Exchange and racing feeds |
| Race runners | Racing and exchange | One runner in one race: the horse, connections, form, draw, price and result. | race_id, runner_id | off time | 36 | 19 | 6 | 1 | Exchange and racing feeds |