⌘K commands · ? keys
Fantasy
Waiver, trade and start-or-sit comparisons for a player in a league week.
- One row
player_id, week· per week- Stamped at
- week Join on this time to read only what was known.
- Known at
- After final (161)
- Source
- Computed by Kelly from stored data
Fields (161)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (161) of (161) fieldsOrder: most widely usable, then name
Showing (161) of (161) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| comparison_by_format | The same draws under PPR, half-PPR and standard | After final | feature | Any sport | Fantasy | number | week |
| comparison_by_scoring_over_replacement_gap | Points over replacement gap under another public format | After final | feature | Any sport | Fantasy | number | week |
| comparison_by_scoring_points_gap | Projected points gap under another public format | After final | feature | Any sport | Fantasy | number | week |
| comparison_by_scoring_receive_p_highest | Chance the received side scores more under another public format | After final | feature | Any sport | Fantasy | number | week |
| comparison_bye_weeks | Bye weeks left | After final | feature | Any sport | Fantasy | number | week |
| comparison_coin_flip | Within the engine's 55/45 coin-flip band | After final | feature | Any sport | Fantasy | number | week |
| comparison_expected_games | Games the player is expected to play | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors | Factors container (decisions.factors) | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_defense | Opponent defense container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_defense_allowed | Fantasy points the opponent allowed per game to the position | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_defense_games | Opponent games counted | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_defense_league_average | League average allowed per game to the position | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_defense_of | Defenses ranked | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_defense_rank | Opponent's rank by points allowed to the position (1 = most) | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_form | Recent games container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_form_average | Average fantasy points over the recent games | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_form_opponent | Opponent in a recent game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_form_points | Fantasy points scored in a recent game, under the format | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_form_season | Season of a recent game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_form_week | Week of a recent game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game | The week's game container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_game_home | Home game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game_implied_points | Team's implied points (from the spread and total) | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game_inactives_at | When the inactive lists post (90 minutes before kickoff) | After final | dimension | Any sport | Fantasy | datetime | week |
| comparison_factors_game_kickoff_at | Kickoff | After final | dimension | Any sport | Fantasy | datetime | week |
| comparison_factors_game_roof | Roof | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game_spread | Consensus spread from the player's team's side | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game_surface | Playing surface | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_game_total | Consensus game total | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury | This week's report container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_injury_game_day | Game-day status | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury_injury | Injury | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury_last_listed_status | Designation when last listed | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury_last_listed_week | Last week on the injury report this season (not on this week's) | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury_practice | Practice participation | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_injury_status | Injury designation | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_trenches | Line play container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_trenches_opponent_sack_rate | Opponent's sacks per dropback | After final | feature | Any sport | Fantasy | percent | week |
| comparison_factors_trenches_opponent_yards_per_carry_allowed | Opponent's yards per carry allowed | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_trenches_sack_rate_allowed | Team sacks allowed per dropback | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_trenches_yards_per_carry | Team yards per carry | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage | Usage container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_usage_carries | Carries per game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage_catches | Catches per game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage_games | Games averaged | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage_pass_attempts | Pass attempts per game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage_red_zone_touches | Red-zone carries and targets per game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_usage_target_share | Target share | After final | feature | Any sport | Fantasy | percent | week |
| comparison_factors_usage_targets | Targets per game | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_weather | Forecast container | After final | feature | Any sport | Fantasy | record | week |
| comparison_factors_weather_indoor | Dome or closed roof | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_weather_precipitation_prob | Forecast chance of rain | After final | price | Any sport | Fantasy | probability | week |
| comparison_factors_weather_temperature_f | Forecast temperature | After final | feature | Any sport | Fantasy | number | week |
| comparison_factors_weather_wind_mph | Forecast wind | After final | feature | Any sport | Fantasy | number | week |
| comparison_format_flips | The player ahead changes with the scoring format | After final | feature | Any sport | Fantasy | number | week |
| comparison_games_left | Games projected over the rest of the season | After final | feature | Any sport | Fantasy | number | week |
| comparison_gap | First player's expected points minus the second's, by source and in total | After final | feature | Any sport | Fantasy | number | week |
| comparison_give | Trade: players given, in the order named | After final | feature | Any sport | Fantasy | number | week |
| comparison_give_total | Trade: the given package's summed projection | After final | feature | Any sport | Fantasy | number | week |
| comparison_horizon | Comparison horizon | After final | feature | Any sport | Fantasy | number | week |
| comparison_leaders | Who leads each measure (chance to score the most, median, floor, ceiling) | After final | feature | Any sport | Fantasy | number | week |
| comparison_league | The comparison in the person's connected league | After final | feature | Any sport | Fantasy | record | week |
| comparison_league_p_highest | Chance to score the most, in the league's scoring | After final | feature | Any sport | Fantasy | number | week |
| comparison_league_p_win | Chance to win this week's matchup with the player in the lineup | After final | feature | Any sport | Fantasy | number | week |
| comparison_league_points | Projected points in the league's scoring | After final | feature | Any sport | Fantasy | number | week |
| comparison_leans | The player each directional factor favours | After final | feature | Any sport | Fantasy | number | week |
| comparison_method | Method, in Kelly's words | After final | feature | Any sport | Fantasy | number | week |
| comparison_notes | Players without a projection, and why | After final | feature | Any sport | Fantasy | number | week |
| comparison_opponent | Opponent that week (abbreviation) | After final | feature | Any sport | Fantasy | number | week |
| comparison_over_replacement | Projected points over the public replacement level | After final | feature | Any sport | Fantasy | number | week |
| comparison_over_replacement_gap | Points over replacement, received minus given | After final | feature | Any sport | Fantasy | number | week |
| comparison_p_highest | Chance to score the most of those named | After final | feature | Any sport | Fantasy | record | week |
| comparison_p_highest_if_active | Chance to score the most if he plays | After final | feature | Any sport | Fantasy | number | week |
| comparison_players | Compared players, in the order named | After final | feature | Any sport | Fantasy | number | week |
| comparison_playoff_p_highest | Chance to score more in the fantasy playoff weeks | After final | feature | Any sport | Fantasy | number | week |
| comparison_playoff_points | Projected points in the fantasy playoff weeks (15–17) | After final | feature | Any sport | Fantasy | number | week |
| comparison_playoff_weeks | Fantasy playoff weeks summed | After final | feature | Any sport | Fantasy | number | week |
| comparison_points_gap | Projected points, received minus given | After final | feature | Any sport | Fantasy | number | week |
| comparison_projection_version | Projection version | After final | feature | Any sport | Fantasy | number | week |
| comparison_receive | Trade: players received, in the order named | After final | feature | Any sport | Fantasy | number | week |
| comparison_receive_total | Trade: the received package's summed projection | After final | feature | Any sport | Fantasy | number | week |
| comparison_replacement_points | Replacement-level player's projected points | After final | feature | Any sport | Fantasy | number | week |
| comparison_replacement_rank | Public replacement rank at the position | After final | feature | Any sport | Fantasy | number | week |
| comparison_scoring | Scoring format compared under | After final | feature | Any sport | Fantasy | number | week |
| comparison_season | NFL season | After final | feature | Any sport | Fantasy | number | week |
| comparison_team | Player's NFL team (abbreviation) | After final | feature | Any sport | Fantasy | number | week |
| comparison_through_week | Last NFL week summed (rest of season) | After final | feature | Any sport | Fantasy | number | week |
| comparison_timezone | Time zone kickoffs are shown in (IANA) | After final | feature | Any sport | Fantasy | number | week |
| comparison_timing | Whose game kicks off first and last, and the hours between | After final | feature | Any sport | Fantasy | record | week |
| comparison_timing_hours_apart | Hours between the first and last kickoff | After final | feature | Any sport | Fantasy | number | week |
| comparison_week | NFL week | After final | feature | Any sport | Fantasy | number | week |
| fantasy_facts | Kelly's own fantasy fits (aging by age, injury odds and return rates, K/DST streaming levels), from its checked-in fits on nflverse data | After final | feature | Any sport | Fantasy | record | week |
| fantasy_format | A public fantasy scoring format: its slug and name (PPR, Half-PPR, Standard, each with 6-point passing TDs, PPR with TE premium) | After final | feature | Any sport | Fantasy | number | week |
| fantasy_rank | A player's rank by fantasy points among the players read, and how many there are | After final | feature | Any sport | Fantasy | number | week |
| waivers_budget | FAAB budget left | After final | feature | Any sport | Fantasy | number | week |
| waivers_budget_total | FAAB budget for the season | After final | feature | Any sport | Fantasy | number | week |
| waivers_method | Method, in Kelly's words | After final | feature | Any sport | Fantasy | number | week |
| waivers_notes | Players without a projection, and why | After final | feature | Any sport | Fantasy | number | week |
| waivers_pool_size | Players counted as likely available | After final | feature | Any sport | Fantasy | number | week |
| waivers_position | Position asked about | After final | feature | Any sport | Fantasy | number | week |
| waivers_projection_version | Projection version | After final | feature | Any sport | Fantasy | number | week |
| waivers_replacement | Replacement levels (the last likely-rostered player at each position) | After final | feature | Any sport | Fantasy | record | week |
| waivers_replacement_name | The player at replacement level now | After final | feature | Any sport | Fantasy | number | week |
| waivers_replacement_points | Replacement level's projected rest-of-season points | After final | feature | Any sport | Fantasy | number | week |
| waivers_replacement_position | Position | After final | feature | Any sport | Fantasy | number | week |
| waivers_replacement_rank | Replacement rank at the position | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows | Waiver pickups, by rest-of-season value (players named first) | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_bid | Suggested FAAB bid | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_bid_high | FAAB bid range, high (within 10% of the best expected value) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_bid_low | FAAB bid range, low (within 10% of the best expected value) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_bye_week | Bye week | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab | FAAB price container | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_faab_by_budget | The bid at other budgets left | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_faab_by_budget_bid | Suggested bid with that budget left | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_by_budget_budget | FAAB budget left | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_curve | Bid curve | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_faab_curve_bid | Bid on the curve | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_curve_net_value | Expected net value of a bid, in rest-of-season points | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_curve_p_win | Chance a bid wins (Kelly's price model) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_points_per_dollar | Rest-of-season points a dollar is expected to buy later | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_tier | Price tier (headline, mid, depth) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_tier_high | Tier's winning bids, 75th percentile | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_tier_low | Tier's winning bids, 25th percentile | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_faab_typical_price | Typical winning bid in the tier (Kelly's price model) | After final | price | Any sport | Fantasy | price | week |
| waivers_rows_games_left | Games left this season | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_kind | streamer for a kicker or defense to stream, else absent | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_likely_rostered | Likely on a roster already (Kelly's rule) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_name | Player's name | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_opening | The injured teammate whose role he may take | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_opening_injury | Injured teammate's injury | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_opening_name | Injured teammate's name | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_opening_season_points | Injured teammate's fantasy points this season | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_opening_status | Injured teammate's status this week | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_opponent | Opponent this week (abbreviation) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_p_win | Chance the suggested bid wins (Kelly's price model) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_player_id | Player ID (plr_) | After final | identifier | Any sport | Fantasy | id | week |
| waivers_rows_position | Player's position | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_rank | Rank among likely-available players by rest-of-season value | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_ros_points | Projected rest-of-season points (expected) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_team | Player's NFL team (abbreviation) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_this_week | Why he is not projected this week (practice squad, inactive, out, a reserve list) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_tier | Price tier (headline, mid, depth) | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_trend | Touches trend container | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_trend_change | Change in touches per game | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_trend_earlier | Touches per game, earlier games this season | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_trend_earlier_season | Whose games the earlier touches are: this season's or last season's | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_trend_recent | Touches per game, last three games | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_typical_price | Typical winning bid in his price tier (Kelly's price model; the bid that wins half the time) | After final | price | Any sport | Fantasy | price | week |
| waivers_rows_value | Rest-of-season points above replacement level at the position | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_weekly | The next weeks' projections | After final | feature | Any sport | Fantasy | record | week |
| waivers_rows_weekly_opponent | Opponent that week | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_weekly_p_active | Chance to play that week | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_weekly_week | NFL week | After final | feature | Any sport | Fantasy | number | week |
| waivers_rows_weeks_ahead | Weeks he is projected above replacement level | After final | feature | Any sport | Fantasy | number | week |
| waivers_scoring | Scoring format | After final | feature | Any sport | Fantasy | number | week |
| waivers_season | NFL season | After final | feature | Any sport | Fantasy | number | week |
| waivers_teams | Teams in the league | After final | feature | Any sport | Fantasy | number | week |
| waivers_through_week | Last NFL week valued | After final | feature | Any sport | Fantasy | number | week |
| waivers_timezone | Time zone kickoffs are shown in (IANA) | After final | feature | Any sport | Fantasy | number | week |
| waivers_week | NFL week | After final | feature | Any sport | Fantasy | number | week |
| waivers_weeks_left | Weeks until the fantasy playoffs | After final | feature | Any sport | Fantasy | number | week |