Skip to content
Kelly
⌘K commands · ? keys

Game context

What is known about a game for a player or team row: home, rest, opponent, week and roof.

One row
subject_id, game_id · per game
Stamped at
game start Join on this time to read only what was known.
Known at
Static (14) · Pregame (22) · At close (1) · After final (3)
Sports (11)
Football, Aussie rules, Baseball, Basketball, Cricket, Esports, Hockey, Racing, Rugby league, Soccer, Volleyball
Source
Computed by Kelly from stored data

Fields (40)

Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .

Matching (24) of (40) fieldsOrder: most widely usable, then name

Showing (24) of (24) · Fields

Formula nameLabelKnown atRoleSportsDatasetTypeGrain
day_of_weekDay of weekPregamedimension10 sportsGame contexttextgame
game_dateGame datePregamedimension10 sportsGame contextdategame
homeHomePregamedimension10 sportsGame contextboolgame
monthMonthPregamefeature10 sportsGame contextnumbergame
neutralNeutralPregamedimension10 sportsGame contextboolgame
opponent_idOpponent idPregameidentifier10 sportsGame contextidgame
player_idPlayer idPregameidentifier10 sportsGame contextidgame
resultResultAfter finaloutcome10 sportsGame contexttextgame
seasonSeasonStaticdimension10 sportsGame contexttextgame
season_typeSeason typeStaticdimension10 sportsGame contexttextgame
startedStartedAfter finaldimension10 sportsGame contextboolgame
team_idTeam idPregameidentifier10 sportsGame contextidgame
positionPositionPregamedimension5 sportsGame contexttextgame
rest_daysRest daysPregamefeature5 sportsGame contextnumbergame
ageAgePregamefeature4 sportsGame contextnumbergame
career_game_numberCareer game numberPregamefeature4 sportsGame contextnumbergame
back_to_backBack to backPregamedimensionBasketball, HockeyGame contextboolgame
competitionCompetitionPregamedimensionSoccerGame contexttextgame
day_nightDay nightPregamedimensionBaseballGame contexttextgame
divisionalDivisionalPregamedimensionFootballGame contextboolgame
primetimePrimetimePregamedimensionFootballGame contextboolgame
roofRoofPregamedimensionFootballGame contexttextgame
surfaceSurfacePregamedimensionFootballGame contexttextgame
weekWeekPregamefeatureFootballGame contextnumbergame