⌘K commands · ? keys
Players
A player in a week: identity, team, position, injury status, usage and projections.
- One row
player_id, week· per week- Stamped at
- as reported Join on this time to read only what was known.
- Known at
- At close (1) · After final (65)
- Source
- League and data-provider feeds
Fields (66)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (66) of (66) fieldsOrder: most widely usable, then name
Showing (66) of (66) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| adp | Consensus ADP | After final | feature | Any sport | Players | number | week |
| dynasty_value | Dynasty value | After final | feature | Any sport | Players | number | week |
| faab_bid | FAAB bid range | After final | feature | Any sport | Players | number | week |
| game_log | Whether a game in a player's game log counts as played, and whether he left it hurt | After final | feature | Any sport | Players | number | week |
| headshot | A player's headshot image (URL, source, credit) | After final | feature | Any sport | Players | number | week |
| hit_rate | A prop's hit rate: the player's games over, under and push against a line in his last 5, 10 and 20 games and the season, each with its game count and the games he left hurt | After final | feature | Any sport | Players | percent | week |
| id | Player ID (plr_) | After final | identifier | Any sport | Players | id | week |
| injury | Availability container | After final | feature | Any sport | Players | record | week |
| injury_detail | Injury | After final | feature | Any sport | Players | number | week |
| injury_first_seen_at | When Kelly first saw the status (Kelly's clock) | After final | dimension | Any sport | Players | datetime | week |
| injury_game_day | Game-day status | After final | feature | Any sport | Players | number | week |
| injury_game_id | Game an availability status is for | After final | identifier | Any sport | Players | id | week |
| injury_practice_status | Practice participation | After final | feature | Any sport | Players | number | week |
| injury_reported_at | Report time | After final | dimension | Any sport | Players | datetime | week |
| injury_roster_status | Reserve list (injured reserve, PUP, suspended) | After final | feature | Any sport | Players | number | week |
| injury_season | Season an availability status is for | After final | feature | Any sport | Players | number | week |
| injury_status | Injury designation | After final | feature | Any sport | Players | number | week |
| injury_week | Week an availability status is for | After final | feature | Any sport | Players | number | week |
| name | Player name | After final | feature | Any sport | Players | number | week |
| news | A player's news items (container) | After final | feature | Any sport | Players | record | week |
| news_headline | News headline | After final | feature | Any sport | Players | number | week |
| news_kind | News item kind (injury, transaction, news) | After final | feature | Any sport | Players | number | week |
| news_published_at | News item date | After final | dimension | Any sport | Players | datetime | week |
| position | Position | After final | feature | Any sport | Players | number | week |
| projection | Projection container | After final | feature | Any sport | Players | record | week |
| projection_p10 | Projected fantasy points, 10th percentile | After final | feature | Any sport | Players | number | week |
| projection_p10_if_active | 10th percentile if he plays | After final | feature | Any sport | Players | number | week |
| projection_p90 | Projected fantasy points, 90th percentile | After final | feature | Any sport | Players | number | week |
| projection_p90_if_active | 90th percentile if he plays | After final | feature | Any sport | Players | number | week |
| projection_p_active | Chance to play (active) | After final | feature | Any sport | Players | number | week |
| projection_points | Projected fantasy points (median) | After final | feature | Any sport | Players | number | week |
| projection_points_if_active | Median outcome if he plays | After final | feature | Any sport | Players | number | week |
| projection_positional_rank | Positional rank (season-long fantasy) | After final | feature | Any sport | Players | number | week |
| projection_sources | Expected points by source (yards, touchdowns, catches, other) | After final | feature | Any sport | Players | number | week |
| projection_stats | Projected stat line (mean, if he plays) | After final | feature | Any sport | Players | number | week |
| prop_close | A player prop's closing consensus line in a past game | At close | feature | Any sport | Players | number | week |
| room | Position room (container) | After final | feature | Any sport | Players | record | week |
| room_carries | Carries, team's last games | After final | feature | Any sport | Players | number | week |
| room_games | Games played this season | After final | feature | Any sport | Players | number | week |
| room_games_counted | Team games the room's work counts | After final | feature | Any sport | Players | number | week |
| room_is_player | This is the player asked about | After final | feature | Any sport | Players | number | week |
| room_played_last_game | Played the team's last game | After final | feature | Any sport | Players | number | week |
| room_position | Room's position | After final | feature | Any sport | Players | number | week |
| room_returning | Coming back from an absence | After final | feature | Any sport | Players | number | week |
| room_season | Season the room's work is from | After final | feature | Any sport | Players | number | week |
| room_targets | Targets, team's last games | After final | feature | Any sport | Players | number | week |
| room_team | Room's team | After final | feature | Any sport | Players | number | week |
| room_through_week | Week the room's stats run through | After final | feature | Any sport | Players | number | week |
| room_touch_share | Share of the room's touches, team's last games | After final | feature | Any sport | Players | percent | week |
| room_touches | Touches (carries plus targets), team's last games | After final | feature | Any sport | Players | number | week |
| sport | Player's sport (Kelly's slug) | After final | feature | Any sport | Players | number | week |
| stats_air_yards_share | Air-yards share over a season (stat line) | After final | feature | Any sport | Players | percent | week |
| stats_cpoe | CPOE over a sample | After final | feature | Any sport | Players | number | week |
| stats_dropbacks | Dropbacks (stat line) | After final | feature | Any sport | Players | number | week |
| stats_epa_per_play | EPA per play | After final | feature | Any sport | Players | number | week |
| stats_game | Player box score for a game (Kelly's stat keys) | After final | feature | Any sport | Players | record | week |
| stats_plays | Scrimmage plays a player was involved in (stat line) | After final | feature | Any sport | Players | number | week |
| stats_rush_share | Rush share over a season (stat line) | After final | feature | Any sport | Players | percent | week |
| stats_season | Player season totals or averages (Kelly's stat keys) | After final | feature | Any sport | Players | record | week |
| stats_success_rate | Success rate | After final | feature | Any sport | Players | percent | week |
| stats_target_share | Target share over a season (stat line) | After final | feature | Any sport | Players | percent | week |
| team_id | Team ID (tm_) | After final | identifier | Any sport | Players | id | week |
| usage | Usage container | After final | feature | Any sport | Players | record | week |
| usage_air_yards_share | Air-yards share | After final | feature | Any sport | Players | percent | week |
| usage_rush_share | Rush share | After final | feature | Any sport | Players | percent | week |
| usage_target_share | Target share | After final | feature | Any sport | Players | percent | week |