|
|
Post by New York Mets on Jul 18, 2021 16:00:23 GMT -6
I think I know the answer to this, but want to confirm. If a player is Optioned or Outrighted to an MLB Team's Alternate Training Site, are they still eligible to play if they have a projection? My understanding would be "no", because the player is not active on an MLB or MILB team during this time. E.g., given the set of official MLB transactions below, would there ever be a time that Lewis Thorpe would not be eligible to play in the sim (assuming he has a projection)? +---------------------------------------------------------------------------+-----------------------------+--------+------------+-----------------------------+--------------------------+--------------------------+---------------+
|note |team |type |player |from_team |trans_date |effective_date |resolution_date|
+---------------------------------------------------------------------------+-----------------------------+--------+------------+-----------------------------+--------------------------+--------------------------+---------------+
|Minnesota Twins recalled Lewis Thorpe from Twins Alternate Training Site. |Minnesota Twins |Recalled|Lewis Thorpe|Twins Alternate Training Site|2021-04-16 00:00:00.000000|2021-04-17 00:00:00.000000|NULL |
|Minnesota Twins optioned LHP Lewis Thorpe to Twins Alternate Training Site.|Twins Alternate Training Site|Optioned|Lewis Thorpe|Minnesota Twins |2021-04-17 00:00:00.000000|2021-04-17 00:00:00.000000|NULL |
|Minnesota Twins recalled Lewis Thorpe from Twins Alternate Training Site. |Minnesota Twins |Recalled|Lewis Thorpe|Twins Alternate Training Site|2021-04-20 00:00:00.000000|2021-04-21 00:00:00.000000|NULL |
|Minnesota Twins optioned LHP Lewis Thorpe to Twins Alternate Training Site.|Twins Alternate Training Site|Optioned|Lewis Thorpe|Minnesota Twins |2021-04-21 00:00:00.000000|2021-04-21 00:00:00.000000|NULL |
|Minnesota Twins recalled Lewis Thorpe from Twins Alternate Training Site. |Minnesota Twins |Recalled|Lewis Thorpe|Twins Alternate Training Site|2021-05-05 00:00:00.000000|2021-05-06 00:00:00.000000|NULL |
|Minnesota Twins optioned LHP Lewis Thorpe to St. Paul Saints. |St. Paul Saints |Optioned|Lewis Thorpe|Minnesota Twins |2021-05-06 00:00:00.000000|2021-05-06 00:00:00.000000|NULL |
|Minnesota Twins recalled LHP Lewis Thorpe from St. Paul Saints. |Minnesota Twins |Recalled|Lewis Thorpe|St. Paul Saints |2021-05-20 00:00:00.000000|2021-05-20 00:00:00.000000|NULL |
|Minnesota Twins optioned LHP Lewis Thorpe to St. Paul Saints. |St. Paul Saints |Optioned|Lewis Thorpe|Minnesota Twins |2021-05-21 00:00:00.000000|2021-05-21 00:00:00.000000|NULL |
+---------------------------------------------------------------------------+-----------------------------+--------+------------+-----------------------------+--------------------------+--------------------------+---------------+It's a bit of a gray area, but I think they're technically active if they were at an alternate training site at the start of the year. They're not inactive, and this was a measure to help teams keep players fresh and ready in case they're needed at the major league level before the delayed minor league start. Just because they were close but didn't make the Opening Day roster doesn't mean they should be penalized for that brief, one month period. www.mlb.com/news/2021-alternate-training-sites"Alternate training sites are back for the start of the 2021 season after Major League Baseball informed teams that the Triple-A season would be delayed by a month. This year’s version of the sites will be similar to those used during the pandemic-shortened campaign a year ago. Players not on their teams’ Opening Day rosters will train and practice at locations near their clubs’ big league ballparks. The move removes the obstacle of commercial travel for Triple-A players and those called up to the Majors for the first month of the 2021 big league season as well as eases MLB teams’ task of coronavirus testing and protocol oversight. The Triple-A delay also affords players a likelier opportunity to be vaccinated before the start of the season." |
|
|
|
Post by Los Angeles Angels on Jul 18, 2021 19:58:29 GMT -6
In the case below, Juan Lagares was reassigned to an MILB team after returning from the IL. This is different from a Rehab Assignment, so I assume he's available to use on/after 2021-04-30. Is this correct?
+--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
|trans_date |effective_date |note |team |type |
+--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
|2021-04-13 00:00:00.000000|2021-04-11 00:00:00.000000|Los Angeles Angels placed CF Juan Lagares on the 10-day injured list retroactive to April 11, 2021. Left calf strain.|Los Angeles Angels |Status Change|
|2021-04-11 00:00:00.000000|2021-04-11 00:00:00.000000|Los Angeles Angels placed RF Juan Lagares on the 10-day injured list. Left calf strain. |Los Angeles Angels |Status Change|
|2021-04-30 00:00:00.000000|2021-04-30 00:00:00.000000|Los Angeles Angels reassigned RF Juan Lagares to the minor leagues. |Los Angeles Angels |Status Change|
|2021-04-30 00:00:00.000000|2021-04-30 00:00:00.000000|Los Angeles Angels optioned RF Juan Lagares to Angels Alternate Training Site. |Angels Alternate Training Site|Optioned |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled RF Juan Lagares from Salt Lake Bees. |Los Angeles Angels |Recalled |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled CF Juan Lagares. |Los Angeles Angels |Recalled |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled CF Juan Lagares. |Los Angeles Angels |Recalled |
+--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
This is different from Michael Pineda who was sent on a Rehab assignment before activation.
+--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+
|trans_date |effective_date |note |team |type |
+--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+
|2021-05-19 00:00:00.000000|2021-05-16 00:00:00.000000|Minnesota Twins placed RHP Michael Pineda on the 10-day injured list retroactive to May 16, 2021. Abscess.|Minnesota Twins|Status Change|
|2021-05-26 00:00:00.000000|2021-05-26 00:00:00.000000|Minnesota Twins activated RHP Michael Pineda from the 10-day injured list. |Minnesota Twins|Status Change|
|2021-06-14 00:00:00.000000|2021-06-14 00:00:00.000000|Minnesota Twins placed RHP Michael Pineda on the 10-day injured list. Right elbow inflammation. |Minnesota Twins|Status Change|
|2021-07-01 00:00:00.000000|2021-07-01 00:00:00.000000|Minnesota Twins sent RHP Michael Pineda on a rehab assignment to St. Paul Saints. |St. Paul Saints|Assigned |
|2021-07-07 00:00:00.000000|2021-07-07 00:00:00.000000|Minnesota Twins activated RHP Michael Pineda from the 10-day injured list. |Minnesota Twins|Status Change|
+--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+
|
|
|
|
Post by Los Angeles Angels on Jul 18, 2021 20:24:05 GMT -6
If anyone is interested, please check out this Google Sheet containing all MLB and MiLB transactions since 2019-01-01 to current (to backfill enough data to catch players who started the season injured). The important column is the ACTIVE column. If you guys look at the sheet, I want to know whether you see any issues with the value in the ACTIVE column. Or... if you see any issues in the the rules for setting true/false in the column. These rules, in SQL, are as follows (this kind of statement might be tricky to understand, so let me know and I can try to translate it into more plain english): case
when type in ('Designated for Assignment', 'Claimed Off Waivers', 'Optioned', 'Outrighted', 'Recalled', 'Returned', 'Selected', 'Signed', 'Signed as Free Agent') then true
when type = 'Status Change' and note ilike '%activated%' then true
when type = 'Status Change' and note ilike '%reassigned%' then true
when type = 'Assigned' and not note ilike '%rehab%' then true
when type = 'Status Change' and note ilike '%placed%' then false
when type = 'Assigned' and note ilike '%rehab%' then false
when type = 'Status Change' and note ilike '%transferred%injured list%' then false
when type = 'Status Change' and note ilike '%restricted list%' then false
when type in ('Retired', 'Released', 'Declared Free Agency') then false end as ACTIVE
-- AND after assigning these values, if we have a status change without an explanation, then assume the status is the opposite of what it was before
-- Alternatively, it seems like 'roster status change' is code for 'SUSPENDED' lol....
case
when active is null and type = 'Status Change' and note ilike '%roster status changed%'
then coalesce(not lag(active) over (partition by player_id order by player_id, effective_date, transaction_id::int), false)
else active end as active
|
|
|
|
Post by New York Mets on Jul 19, 2021 10:31:10 GMT -6
In the case below, Juan Lagares was reassigned to an MILB team after returning from the IL. This is different from a Rehab Assignment, so I assume he's available to use on/after 2021-04-30. Is this correct? +--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
|trans_date |effective_date |note |team |type |
+--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
|2021-04-13 00:00:00.000000|2021-04-11 00:00:00.000000|Los Angeles Angels placed CF Juan Lagares on the 10-day injured list retroactive to April 11, 2021. Left calf strain.|Los Angeles Angels |Status Change|
|2021-04-11 00:00:00.000000|2021-04-11 00:00:00.000000|Los Angeles Angels placed RF Juan Lagares on the 10-day injured list. Left calf strain. |Los Angeles Angels |Status Change|
|2021-04-30 00:00:00.000000|2021-04-30 00:00:00.000000|Los Angeles Angels reassigned RF Juan Lagares to the minor leagues. |Los Angeles Angels |Status Change|
|2021-04-30 00:00:00.000000|2021-04-30 00:00:00.000000|Los Angeles Angels optioned RF Juan Lagares to Angels Alternate Training Site. |Angels Alternate Training Site|Optioned |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled RF Juan Lagares from Salt Lake Bees. |Los Angeles Angels |Recalled |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled CF Juan Lagares. |Los Angeles Angels |Recalled |
|2021-05-05 00:00:00.000000|2021-05-05 00:00:00.000000|Los Angeles Angels recalled CF Juan Lagares. |Los Angeles Angels |Recalled |
+--------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------------+------------------------------+-------------+
This is different from Michael Pineda who was sent on a Rehab assignment before activation. +--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+
|trans_date |effective_date |note |team |type |
+--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+
|2021-05-19 00:00:00.000000|2021-05-16 00:00:00.000000|Minnesota Twins placed RHP Michael Pineda on the 10-day injured list retroactive to May 16, 2021. Abscess.|Minnesota Twins|Status Change|
|2021-05-26 00:00:00.000000|2021-05-26 00:00:00.000000|Minnesota Twins activated RHP Michael Pineda from the 10-day injured list. |Minnesota Twins|Status Change|
|2021-06-14 00:00:00.000000|2021-06-14 00:00:00.000000|Minnesota Twins placed RHP Michael Pineda on the 10-day injured list. Right elbow inflammation. |Minnesota Twins|Status Change|
|2021-07-01 00:00:00.000000|2021-07-01 00:00:00.000000|Minnesota Twins sent RHP Michael Pineda on a rehab assignment to St. Paul Saints. |St. Paul Saints|Assigned |
|2021-07-07 00:00:00.000000|2021-07-07 00:00:00.000000|Minnesota Twins activated RHP Michael Pineda from the 10-day injured list. |Minnesota Twins|Status Change|
+--------------------------+--------------------------+----------------------------------------------------------------------------------------------------------+---------------+-------------+Just to clarify in case there are any questions, a player on a rehab assignment is still ineligible in the simulation because the player is not officially active yet in real-life--there are frequently setbacks on rehab assignments and vary greatly in length. |
|
