⌘K commands · ? keys
Games
One game: the teams, start time, state, score, broadcasts and weather.
- One row
game_id· per game- Stamped at
- game start Join on this time to read only what was known.
- Known at
- After final (120)
- Source
- League and data-provider feeds
Fields (120)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (120) of (120) fieldsOrder: most widely usable, then name
Showing (120) of (120) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| away_team | A game's away team (a container) | After final | feature | Any sport | Games | number | game |
| broadcasts | Where a game is shown: its TV networks, streaming services and pay-per-view outlets, by name | After final | feature | Any sport | Games | number | game |
| clock | Clock and period | After final | feature | Any sport | Games | number | game |
| competition | Game's competition (Kelly's slug: nfl, ncaaf, nba, ncaab) | After final | feature | Any sport | Games | number | game |
| competition_id | Competition ID (cmp_) | After final | identifier | Any sport | Games | id | game |
| context | Rest and spot (container) | After final | feature | Any sport | Games | record | game |
| context_divisional | Divisional game | After final | feature | Any sport | Games | number | game |
| context_neutral_site | Neutral site | After final | feature | Any sport | Games | number | game |
| context_night_game | Kickoff at 7 PM ET or later | After final | feature | Any sport | Games | number | game |
| context_off_bye | Coming off a bye (13 days' rest or more) | After final | feature | Any sport | Games | number | game |
| context_rest_days | Days since the team's last game (nflverse) | After final | feature | Any sport | Games | number | game |
| context_short_week | Five days' rest or fewer | After final | feature | Any sport | Games | number | game |
| context_weekday | Weekday (nflverse schedule) | After final | feature | Any sport | Games | number | game |
| drives | A game's drives, newest first (plays:{game_id} snapshot) | After final | feature | Any sport | Games | number | game |
| expected_latency_s | Expected latency | After final | feature | Any sport | Games | number | game |
| home_team | A game's home team (a container) | After final | feature | Any sport | Games | number | game |
| id | Game ID (gm_) | After final | identifier | Any sport | Games | id | game |
| injuries | Each team's designated players on the current report (container) | After final | feature | Any sport | Games | record | game |
| injuries_season | Season of the injury report | After final | feature | Any sport | Games | number | game |
| injuries_week | Week of the injury report | After final | feature | Any sport | Games | number | game |
| kickoff_at | Kickoff time | After final | dimension | Any sport | Games | datetime | game |
| kickoff_date | Game date, for a source that gives no time (Cricsheet); kickoff_at is then null | After final | dimension | Any sport | Games | date | game |
| last_play | Last play (template-written) | After final | feature | Any sport | Games | number | game |
| lineup | A game's projected starting lineups (container) | After final | feature | Any sport | Games | record | game |
| lineup_confirmed_at | When Kelly first saw the starter's lineup as confirmed (Kelly's clock) | After final | dimension | Any sport | Games | datetime | game |
| lineup_first_seen_at | When Kelly first saw the starter in the game's projected five (Kelly's clock) | After final | dimension | Any sport | Games | datetime | game |
| lineup_slot | A projected starter's spot in the starting five (PG, SG, SF, PF, C) | After final | feature | Any sport | Games | number | game |
| lineup_status | Whether the lineup is expected or confirmed | After final | feature | Any sport | Games | number | game |
| luck | What is likely to regress, per team (container) | After final | feature | Any sport | Games | record | game |
| luck_epa_margin_per_game | Scrimmage EPA margin per game | After final | feature | Any sport | Games | number | game |
| luck_fumble_recovery_rate | Share of those fumbles it recovered | After final | feature | Any sport | Games | percent | game |
| luck_fumbles | Fumbles in its games (scrimmage plays) | After final | feature | Any sport | Games | number | game |
| luck_games | Games counted | After final | feature | Any sport | Games | number | game |
| luck_losses | Losses | After final | feature | Any sport | Games | number | game |
| luck_one_score_losses | Losses by 8 points or fewer | After final | feature | Any sport | Games | number | game |
| luck_one_score_wins | Wins by 8 points or fewer | After final | feature | Any sport | Games | number | game |
| luck_point_margin_per_game | Point margin per game | After final | feature | Any sport | Games | number | game |
| luck_points_against_per_game | Points allowed per game | After final | feature | Any sport | Games | number | game |
| luck_points_for_per_game | Points scored per game | After final | feature | Any sport | Games | number | game |
| luck_points_over_epa | Point margin per game minus EPA margin per game | After final | feature | Any sport | Games | number | game |
| luck_pythagorean_wins | Pythagorean wins (points scored and allowed, exponent 2.37) | After final | feature | Any sport | Games | number | game |
| luck_season | Season the luck figures cover | After final | feature | Any sport | Games | number | game |
| luck_through_week | Last week the luck figures include | After final | feature | Any sport | Games | number | game |
| luck_ties | Ties | After final | feature | Any sport | Games | number | game |
| luck_turnover_margin_per_game | Takeaways minus giveaways per game | After final | feature | Any sport | Games | number | game |
| luck_win_luck | Wins minus Pythagorean wins (ties count half) | After final | feature | Any sport | Games | number | game |
| luck_wins | Wins | After final | feature | Any sport | Games | number | game |
| matchup | Each offense against the other defense (container) | After final | feature | Any sport | Games | record | game |
| matchup_adj_epa_per_play | Opponent-adjusted EPA per play (NFL: Kelly's ridge ratings; college: CFBD WEPA) | After final | feature | Any sport | Games | number | game |
| matchup_adj_explosiveness | Opponent-adjusted explosiveness (CFBD WEPA) | After final | feature | Any sport | Games | number | game |
| matchup_adj_line_yards | Opponent-adjusted line yards (CFBD WEPA) | After final | feature | Any sport | Games | number | game |
| matchup_adj_pass_epa_per_play | Opponent-adjusted EPA per dropback or pass play (NFL: Kelly's; college: CFBD WEPA) | After final | feature | Any sport | Games | number | game |
| matchup_adj_rush_epa_per_play | Opponent-adjusted EPA per run (NFL: Kelly's; college: CFBD WEPA) | After final | feature | Any sport | Games | number | game |
| matchup_adj_success_rate | Opponent-adjusted success rate (CFBD WEPA) | After final | feature | Any sport | Games | percent | game |
| matchup_as_of | When the source last served the college figures | After final | feature | Any sport | Games | number | game |
| matchup_avg_start | Average starting field position (CFBD) | After final | feature | Any sport | Games | number | game |
| matchup_epa_per_play | EPA per play | After final | feature | Any sport | Games | number | game |
| matchup_explosive_rate | Explosive play rate (20+ yard pass, 10+ yard run) | After final | feature | Any sport | Games | percent | game |
| matchup_explosiveness | Explosiveness (CFBD: average EPA on successful plays) | After final | feature | Any sport | Games | number | game |
| matchup_havoc_rate | Havoc rate (CFBD) | After final | feature | Any sport | Games | percent | game |
| matchup_last4_epa_per_play | EPA per play over the last four games | After final | feature | Any sport | Games | number | game |
| matchup_last4_success_rate | Success rate over the last four games | After final | feature | Any sport | Games | percent | game |
| matchup_line_yards | Offensive line yards per carry (CFBD) | After final | feature | Any sport | Games | number | game |
| matchup_net | Net: the offense's figure minus what the defense allowed | After final | feature | Any sport | Games | number | game |
| matchup_neutral_epa_per_play | EPA per play with the offense's win probability 20-80% | After final | feature | Any sport | Games | number | game |
| matchup_neutral_success_rate | Success rate with the offense's win probability 20-80% | After final | feature | Any sport | Games | percent | game |
| matchup_pass_epa_per_play | EPA per dropback (NFL) or per pass play (college) | After final | feature | Any sport | Games | number | game |
| matchup_pass_success_rate | Success rate on dropbacks (NFL) or pass plays (college, CFBD) | After final | feature | Any sport | Games | percent | game |
| matchup_plays_per_game | Scrimmage plays per game | After final | feature | Any sport | Games | number | game |
| matchup_points_per_opportunity | Points per opportunity: per drive reaching the opponent's 40 (CFBD) | After final | feature | Any sport | Games | number | game |
| matchup_power_success | Power success: short-yardage run success rate (CFBD) | After final | feature | Any sport | Games | number | game |
| matchup_qb | The starter by dropbacks: dropbacks, EPA per dropback, CPOE and Kelly's composite (the mean of the two standardised among the starters) | After final | feature | Any sport | Games | number | game |
| matchup_rank | Rank among the teams (1 = best for that side) | After final | feature | Any sport | Games | number | game |
| matchup_red_zone_td_rate | Red-zone touchdown rate (drives) | After final | feature | Any sport | Games | percent | game |
| matchup_rush_epa_per_play | EPA per designed run | After final | feature | Any sport | Games | number | game |
| matchup_rush_success_rate | Success rate on designed runs (NFL) or runs (college, CFBD) | After final | feature | Any sport | Games | percent | game |
| matchup_sack_rate | Sacks per dropback | After final | feature | Any sport | Games | percent | game |
| matchup_season | Season the matchup figures cover | After final | feature | Any sport | Games | number | game |
| matchup_source | Whose figures the matchup carries (nflverse or cfbd) | After final | feature | Any sport | Games | number | game |
| matchup_stuff_rate | Stuff rate: runs stopped at or behind the line (CFBD) | After final | feature | Any sport | Games | percent | game |
| matchup_success_rate | Success rate (the definition is game.matchup.success_rate_definition) | After final | feature | Any sport | Games | percent | game |
| matchup_success_rate_definition | The success-rate definition the figures use (nflverse: positive EPA; CFBD: 50/70/100% of the yards to go by down) | After final | feature | Any sport | Games | number | game |
| matchup_teams | Teams ranked | After final | feature | Any sport | Games | number | game |
| matchup_third_down_rate | Third-down conversion rate | After final | feature | Any sport | Games | percent | game |
| matchup_through_week | Last week the matchup figures include | After final | feature | Any sport | Games | number | game |
| matchup_turnovers_per_game | Interceptions and lost fumbles per game | After final | feature | Any sport | Games | number | game |
| name | Game name (Chiefs at Bills) | After final | feature | Any sport | Games | number | game |
| neutral_site | Neutral site (neither team at home) | After final | feature | Any sport | Games | number | game |
| picks_count | How many analysts' picks Kelly has published on the game | After final | feature | Any sport | Games | number | game |
| plays | A game's latest plays, newest first (plays:{game_id} snapshot) | After final | feature | Any sport | Games | number | game |
| possession | Possession | After final | feature | Any sport | Games | number | game |
| score | Score | After final | feature | Any sport | Games | number | game |
| season | Season label (2026, 2026-27) | After final | feature | Any sport | Games | number | game |
| season_type | Season type (regular, postseason, preseason) | After final | feature | Any sport | Games | number | game |
| share | How to share a game: its Wire link on askkelly.ai, the link's share card image, a title and a message to send | After final | feature | Any sport | Games | percent | game |
| situation | Live situation (down, distance, spot, red zone, timeouts, clock running, current drive) | After final | feature | Any sport | Games | number | game |
| slate_changes | The games whose place on a slate changed: game ID, what changed (added, removed, rescheduled, status, teams, market), kickoff and status; no score, no price | After final | feature | Any sport | Games | number | game |
| slate_competition | The competition slug (nfl, ncaaf, …) a slate topic's event is about | After final | feature | Any sport | Games | number | game |
| slate_data | The day's games | After final | feature | Any sport | Games | number | game |
| slate_date | The slate's local date | After final | dimension | Any sport | Games | date | game |
| slate_ends_at | The day's end in UTC | After final | dimension | Any sport | Games | datetime | game |
| slate_game_count | Games on the date that match | After final | feature | Any sport | Games | number | game |
| slate_games | The games, in start order | After final | feature | Any sport | Games | number | game |
| slate_starts_at | The day's start in UTC | After final | dimension | Any sport | Games | datetime | game |
| slate_timezone | The time zone the date is read in (IANA) | After final | feature | Any sport | Games | number | game |
| sport | Game's sport (Kelly's slug) | After final | feature | Any sport | Games | number | game |
| state_lag_ms | How far behind its latest play the situation was stored (ms) | After final | feature | Any sport | Games | number | game |
| status | Game status (scheduled, in progress, final) | After final | feature | Any sport | Games | number | game |
| venue | Venue | After final | feature | Any sport | Games | number | game |
| weather | Forecast container | After final | feature | Any sport | Games | record | game |
| weather_conditions | Forecast conditions (NWS short forecast) | After final | feature | Any sport | Games | number | game |
| weather_gust_mph | Forecast wind gusts | After final | feature | Any sport | Games | number | game |
| weather_indoor | Dome or closed roof | After final | feature | Any sport | Games | number | game |
| weather_issued_at | Forecast issue time | After final | dimension | Any sport | Games | datetime | game |
| weather_precipitation_prob | Chance of precipitation | After final | price | Any sport | Games | probability | game |
| weather_roof | Roof (nflverse schedule) | After final | feature | Any sport | Games | number | game |
| weather_surface | Playing surface (nflverse schedule) | After final | feature | Any sport | Games | number | game |
| weather_temperature_f | Forecast temperature | After final | feature | Any sport | Games | number | game |
| weather_wind_mph | Forecast wind | After final | feature | Any sport | Games | number | game |
| week | Week (football) | After final | feature | Any sport | Games | number | game |