⌘K commands · ? keys
Team games
One team in one game: the result, closing lines, rest, travel, weather and venue.
- One row
team_id, game_id· per game- Stamped at
- game start Join on this time to read only what was known.
- Known at
- Static (23) · Pregame (10) · At close (12) · After final (9)
- Sports (10)
- Football, Aussie rules, Baseball, Basketball, Cricket, Esports, Hockey, Rugby league, Soccer, Volleyball
- Source
- Computed by Kelly from stored data
Fields (54)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (49) of (54) fieldsOrder: most widely usable, then name
Showing (49) of (49) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| ats_result | ATS result | After final | outcome | 10 sports | Team games | text | game |
| back_to_back | Back to back | Pregame | dimension | 10 sports | Team games | bool | game |
| classification | Classification | Static | dimension | 10 sports | Team games | text | game |
| conference | Conference | Static | dimension | 10 sports | Team games | text | game |
| conference_game | Conference game | Static | dimension | 10 sports | Team games | bool | game |
| day_of_week | Day of the week | Static | dimension | 10 sports | Team games | text | game |
| division | Division | Static | dimension | 10 sports | Team games | text | game |
| divisional | Division game | Static | dimension | 10 sports | Team games | bool | game |
| game_date | Game date | Static | dimension | 10 sports | Team games | date | game |
| game_timezone | Venue time zone | Static | dimension | 10 sports | Team games | text | game |
| game_type | Game type | Static | dimension | 10 sports | Team games | text | game |
| games_last_7_days | Games in the last 7 days | Pregame | feature | 10 sports | Team games | number | game |
| humidity | Humidity (%) | At close | feature | 10 sports | Team games | number | game |
| kickoff_hour_et | Kickoff hour (Eastern) | Static | feature | 10 sports | Team games | number | game |
| kickoff_hour_local | Kickoff hour (local) | Static | feature | 10 sports | Team games | number | game |
| margin | Margin | After final | outcome | 10 sports | Team games | number | game |
| moneyline_close | Closing moneyline | At close | price | 10 sports | Team games | price | game |
| month | Month | Static | feature | 10 sports | Team games | number | game |
| ou_result | Over/under result | After final | outcome | 10 sports | Team games | text | game |
| prev_season_ats_pct | Cover rate last season (%) | Static | feature | 10 sports | Team games | number | game |
| prev_season_postseason | Made the postseason last season | Static | dimension | 10 sports | Team games | bool | game |
| prev_season_wins | Wins last season | Static | feature | 10 sports | Team games | number | game |
| rest_days | Rest days | Pregame | feature | 10 sports | Team games | number | game |
| result | Result | After final | outcome | 10 sports | Team games | text | game |
| roof | Roof | Static | dimension | 10 sports | Team games | text | game |
| seed | Seed | Static | feature | 10 sports | Team games | number | game |
| spread_close | Closing spread | At close | price | 10 sports | Team games | number | game |
| spread_price_close | Closing spread price | At close | price | 10 sports | Team games | price | game |
| stadium | Stadium | Static | dimension | 10 sports | Team games | text | game |
| starter_id | Starter | At close | identifier | 10 sports | Team games | id | game |
| starter_name | Starter's name | At close | dimension | 10 sports | Team games | text | game |
| surface | Surface | Static | dimension | 10 sports | Team games | text | game |
| team_timezone | Home time zone | Static | dimension | 10 sports | Team games | text | game |
| temperature_f | Temperature (°F) | At close | feature | 10 sports | Team games | number | game |
| total_close | Closing total | At close | price | 10 sports | Team games | number | game |
| tournament | Tournament | Static | dimension | 10 sports | Team games | text | game |
| weather_source | Weather source | At close | dimension | 10 sports | Team games | text | game |
| week_number | Week number | Static | feature | 10 sports | Team games | number | game |
| wind_direction_deg | Wind direction (°) | At close | feature | 10 sports | Team games | number | game |
| wind_mph | Wind (mph) | At close | feature | 10 sports | Team games | number | game |
| points_against | Points against | After final | outcome | 8 sports | Team games | number | game |
| points_for | Points for | After final | outcome | 8 sports | Team games | number | game |
| btts | Both teams scored | After final | outcome | Soccer | Team games | bool | game |
| clean_sheet | Clean sheet | After final | outcome | Soccer | Team games | bool | game |
| league_goal_difference | Goal difference before the match | Pregame | feature | Soccer | Team games | number | game |
| league_played | League matches played before the match | Pregame | feature | Soccer | Team games | number | game |
| league_points | League points before the match | Pregame | feature | Soccer | Team games | number | game |
| league_position | League position before the match | Pregame | feature | Soccer | Team games | number | game |
| match_points | Match points | After final | outcome | Soccer | Team games | number | game |