Name: GameResults
Display Field: season_type
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- game_id (type: esriFieldTypeInteger, alias: Game ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- season (type: esriFieldTypeInteger, alias: Season, SQL Type: sqlTypeOther, nullable: true, editable: true)
- week (type: esriFieldTypeSmallInteger, alias: Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
- season_type (type: esriFieldTypeString, alias: Season Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- start_date (type: esriFieldTypeDate, alias: Kickoff (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- home_id (type: esriFieldTypeInteger, alias: Home Team ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_id (type: esriFieldTypeInteger, alias: Away Team ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_team (type: esriFieldTypeString, alias: Home Team, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- away_team (type: esriFieldTypeString, alias: Away Team, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- home_conference (type: esriFieldTypeString, alias: Home Conference, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- away_conference (type: esriFieldTypeString, alias: Away Conference, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- home_division (type: esriFieldTypeString, alias: Home Division, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- away_division (type: esriFieldTypeString, alias: Away Division, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- home_points (type: esriFieldTypeInteger, alias: Home Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_points (type: esriFieldTypeInteger, alias: Away Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_line_scores (type: esriFieldTypeString, alias: Home by Quarter, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- away_line_scores (type: esriFieldTypeString, alias: Away by Quarter, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- total_points (type: esriFieldTypeInteger, alias: Total Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
- margin (type: esriFieldTypeInteger, alias: Margin, SQL Type: sqlTypeOther, nullable: true, editable: true)
- winner_id (type: esriFieldTypeInteger, alias: Winner Team ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- winner_team (type: esriFieldTypeString, alias: Winner, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- excitement_index (type: esriFieldTypeDouble, alias: Excitement Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
- excitement_pctile (type: esriFieldTypeSmallInteger, alias: Excitement Percentile (week), SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_postgame_wp (type: esriFieldTypeDouble, alias: Home Postgame Win Prob, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_postgame_wp (type: esriFieldTypeDouble, alias: Away Postgame Win Prob, SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_pregame_elo (type: esriFieldTypeDouble, alias: Home Pregame Elo, SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_postgame_elo (type: esriFieldTypeDouble, alias: Home Postgame Elo, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_pregame_elo (type: esriFieldTypeDouble, alias: Away Pregame Elo, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_postgame_elo (type: esriFieldTypeDouble, alias: Away Postgame Elo, SQL Type: sqlTypeOther, nullable: true, editable: true)
- elo_swing (type: esriFieldTypeDouble, alias: Winner Elo Swing, SQL Type: sqlTypeOther, nullable: true, editable: true)
- attendance (type: esriFieldTypeInteger, alias: Attendance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- capacity (type: esriFieldTypeInteger, alias: Venue Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pct_capacity (type: esriFieldTypeSmallInteger, alias: Percent of Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
- venue (type: esriFieldTypeString, alias: Venue, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- host_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- host_state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- neutral_site (type: esriFieldTypeSmallInteger, alias: Neutral Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
- conference_game (type: esriFieldTypeSmallInteger, alias: Conference Game, SQL Type: sqlTypeOther, nullable: true, editable: true)
- closing_spread (type: esriFieldTypeDouble, alias: Closing Spread (home), SQL Type: sqlTypeOther, nullable: true, editable: true)
- over_under (type: esriFieldTypeDouble, alias: Over/Under, SQL Type: sqlTypeOther, nullable: true, editable: true)
- line_provider (type: esriFieldTypeString, alias: Line Provider, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- cover_result (type: esriFieldTypeString, alias: Against the Spread, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- ou_result (type: esriFieldTypeString, alias: Total Result, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- home_rank (type: esriFieldTypeSmallInteger, alias: Home Poll Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_rank (type: esriFieldTypeSmallInteger, alias: Away Poll Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
- upset (type: esriFieldTypeSmallInteger, alias: Upset, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rivalry (type: esriFieldTypeSmallInteger, alias: Rivalry, SQL Type: sqlTypeOther, nullable: true, editable: true)
- road_miles (type: esriFieldTypeDouble, alias: Away Travel Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pass_leader (type: esriFieldTypeString, alias: Passing Leader, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
- rush_leader (type: esriFieldTypeString, alias: Rushing Leader, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
- recv_leader (type: esriFieldTypeString, alias: Receiving Leader, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
- team_stats_home (type: esriFieldTypeString, alias: Home Team Stats, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
- team_stats_away (type: esriFieldTypeString, alias: Away Team Stats, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
- home_logo_url (type: esriFieldTypeString, alias: Home Logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- away_logo_url (type: esriFieldTypeString, alias: Away Logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- home_color (type: esriFieldTypeString, alias: Home Color, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- away_color (type: esriFieldTypeString, alias: Away Color, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- home_text_on (type: esriFieldTypeString, alias: Home Text Color, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- away_text_on (type: esriFieldTypeString, alias: Away Text Color, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- home_ml (type: esriFieldTypeInteger, alias: Home Moneyline, SQL Type: sqlTypeOther, nullable: true, editable: true)
- away_ml (type: esriFieldTypeInteger, alias: Away Moneyline, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ml_payout (type: esriFieldTypeDouble, alias: Winner Moneyline Payout per 100, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fav_won (type: esriFieldTypeSmallInteger, alias: Favourite Won, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fav_covered (type: esriFieldTypeSmallInteger, alias: Favourite Covered, SQL Type: sqlTypeOther, nullable: true, editable: true)
- home_won (type: esriFieldTypeSmallInteger, alias: Home Team Won, SQL Type: sqlTypeOther, nullable: true, editable: true)
- one_score (type: esriFieldTypeSmallInteger, alias: One-Score Game, SQL Type: sqlTypeOther, nullable: true, editable: true)
- went_ot (type: esriFieldTypeSmallInteger, alias: Overtime, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ranked_matchup (type: esriFieldTypeSmallInteger, alias: Both Ranked, SQL Type: sqlTypeOther, nullable: true, editable: true)
- comeback (type: esriFieldTypeSmallInteger, alias: Halftime Comeback, SQL Type: sqlTypeOther, nullable: true, editable: true)
- aftermath_index (type: esriFieldTypeSmallInteger, alias: Aftermath Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
- index_why (type: esriFieldTypeString, alias: Index Components, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
- week_key (type: esriFieldTypeString, alias: Week Key, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- week_label (type: esriFieldTypeString, alias: Week Label, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- is_latest (type: esriFieldTypeSmallInteger, alias: Latest Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
- data_tier (type: esriFieldTypeString, alias: Data Tier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- stamp_updated (type: esriFieldTypeDate, alias: Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Templates:
Name: GameResults
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/18/2026 3:51:23 PM
Schema Last Edit Date: 9/18/2026 3:51:23 PM
Data Last Edit Date: 9/18/2026 3:51:15 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat