⌘K commands · ? keys
Teams, leagues and seasons
Identity rows every other dataset joins to: sports, leagues, seasons, teams, venues and books.
- One row
id· per static- Stamped at
- static Join on this time to read only what was known.
- Known at
- Static (25) · After final (18)
- Source
- League and data-provider feeds
Fields (43)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (43) of (43) fieldsOrder: most widely usable, then name
Showing (43) of (43) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| abbreviation | Team abbreviation | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| betting_record | A team's betting record: straight up, against the spread and over/under, as favourite and underdog, home and away, with each split's game count and the average cover margin; each final's cover and over/under result | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| book | A book: slug, name, kind, regulation, offshore flag, licensed states, status note | Static | feature | Any sport | Teams, leagues and seasons | record | static |
| book_group | Books of one kind | Static | feature | Any sport | Teams, leagues and seasons | record | static |
| closing_line | A final's closing spread (the team's side) and total, and whose close it is | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| competition | Team's competition (Kelly's slug) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| competitions | A sport's competitions (a container) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| end_at | Tournament end | Static | dimension | Any sport | Teams, leagues and seasons | datetime | static |
| ends_on | Season's last day | Static | dimension | Any sport | Teams, leagues and seasons | date | static |
| facts | Where a game is played: latitude, longitude, elevation, IANA time zone, roof, surface, capacity, city and country | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| id | Competition ID (cmp_) | Static | identifier | Any sport | Teams, leagues and seasons | id | static |
| id | Season ID (ssn_) | Static | identifier | Any sport | Teams, leagues and seasons | id | static |
| id | Sport ID (spt_) | Static | identifier | Any sport | Teams, leagues and seasons | id | static |
| id | Team ID (tm_) | After final | identifier | Any sport | Teams, leagues and seasons | id | season |
| id | Tournament ID (trn_) | Static | identifier | Any sport | Teams, leagues and seasons | id | static |
| label | Season label (2026, 2026-27) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| logo | A team's logo image (URL, light and dark, source, credit) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| name | Competition name | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| name | Sport name | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| name | Team name | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| name | Tournament name (The RSM Classic) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| record | A team's record and form before a game (wins, losses, ties; points per game; recent results; rest; past meetings) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| schedule | A team's schedule spot before a game (rest days, back-to-back, games in 4 and 6 days, next game's rest, road trip or homestand game) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| school | College team's school | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| seasons | A competition's seasons (a container) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| slug | Competition slug (nfl) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| slug | Sport slug (american_football) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| sport | Competition's sport (Kelly's slug) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| sport_facts_facts_value | A sport's fixed rule fact (game length, overtime, scoring, clock, teams, games per team), from the league's rulebook or site | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| sport_facts_key_numbers | The share of NFL games decided by each key number, its counts and the seasons counted, computed from Kelly's own NFL results | Static | feature | Any sport | Teams, leagues and seasons | record | static |
| start_at | Tournament start | Static | dimension | Any sport | Teams, leagues and seasons | datetime | static |
| starts_on | Season's first day | Static | dimension | Any sport | Teams, leagues and seasons | date | static |
| stats_epa_per_play | Team EPA per play | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| stats_game | Team box score for a game (Kelly's stat keys) | After final | feature | Any sport | Teams, leagues and seasons | record | season |
| stats_games_played | Games in a team's play-by-play sample (stat line; K4 check) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| stats_pace | Plays per game | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| stats_plays | Team scrimmage plays on offense (stat line) | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| stats_season | Team season totals or averages (Kelly's stat keys) | After final | feature | Any sport | Teams, leagues and seasons | record | season |
| stats_success_rate | Team success rate | After final | feature | Any sport | Teams, leagues and seasons | percent | season |
| status | Tournament status (scheduled, in progress, final) | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| travel | A team's trip into a game: home or not, days since its previous game, kilometres from that venue, time zones crossed (the change in UTC offset), elevation and its change | After final | feature | Any sport | Teams, leagues and seasons | number | season |
| venue | Tournament course | Static | feature | Any sport | Teams, leagues and seasons | number | static |
| year | Year the season starts | Static | feature | Any sport | Teams, leagues and seasons | number | static |