dynastyprocess / data

An open-data fantasy football repository, maintained by DynastyProcess.com
https://dynastyprocess.com
GNU General Public License v3.0
73 stars 19 forks source link

[Data Bug] Chris Herndon incorrect Sleeper ID #13

Closed danabrey closed 4 years ago

danabrey commented 4 years ago

Describe the data bug Chris Herndon's Sleeper ID should be 5009, not 5755

Which file is having trouble? db_playerids.csv

There is an old, deprecated Chris Herndon in Sleeper's player database:

  "5755": {
    "hashtag": "#ChrisHerndon-NFL-FA-0",
    "sport": "nfl",
    "practice_description": null,
    "birth_state": null,
    "team": null,
    "injury_notes": null,
    "last_name": "Herndon",
    "injury_start_date": null,
    "weight": "",
    "fantasy_data_id": 19914,
    "search_first_name": "chris",
    "college": "Miami (Fla.)",
    "age": 22,
    "first_name": "Chris",
    "full_name": "Chris Herndon",
    "search_rank": 9999999,
    "yahoo_id": 900358,
    "birth_date": "1996-02-23",
    "injury_status": null,
    "news_updated": null,
    "position": null,
    "metadata": null,
    "birth_city": null,
    "rotowire_id": null,
    "high_school": null,
    "rotoworld_id": 13228,
    "player_id": "5755",
    "number": 0,
    "birth_country": null,
    "pandascore_id": null,
    "search_last_name": "herndon",
    "years_exp": 0,
    "height": "",
    "active": true,
    "stats_id": null,
    "search_full_name": "chrisherndon",
    "depth_chart_position": null,
    "depth_chart_order": null,
    "sportradar_id": "780a48de-d092-4e87-9c34-8d1b45a154cc",
    "gsis_id": "00-0034766",
    "injury_body_part": null,
    "fantasy_positions": null,
    "status": "Inactive",
    "espn_id": null,
    "practice_participation": null
  }

The Chris Herndon that is actually on rosters is this one:

  "5009": {
    "hashtag": "#ChrisHerndon-NFL-NYJ-89",
    "sport": "nfl",
    "practice_description": null,
    "birth_state": null,
    "team": "NYJ",
    "injury_notes": null,
    "last_name": "Herndon",
    "injury_start_date": null,
    "weight": "253",
    "fantasy_data_id": 19947,
    "search_first_name": "chris",
    "college": "Miami (FL)",
    "age": 24,
    "first_name": "Chris",
    "full_name": "Chris Herndon",
    "search_rank": 290,
    "yahoo_id": 31077,
    "birth_date": "1996-02-23",
    "injury_status": null,
    "news_updated": 1593620408253,
    "position": "TE",
    "metadata": null,
    "birth_city": null,
    "rotowire_id": 12899,
    "high_school": null,
    "rotoworld_id": 13228,
    "player_id": "5009",
    "number": 89,
    "birth_country": null,
    "pandascore_id": null,
    "search_last_name": "herndon",
    "years_exp": 2,
    "height": "6'4\"",
    "active": true,
    "stats_id": 832080,
    "search_full_name": "chrisherndon",
    "depth_chart_position": "TE",
    "depth_chart_order": 1,
    "sportradar_id": "780a48de-d092-4e87-9c34-8d1b45a154cc",
    "gsis_id": " 00-0034766",
    "injury_body_part": null,
    "fantasy_positions": [
      "TE"
    ],
    "status": "Active",
    "espn_id": 3123050,
    "practice_participation": null
  }
tanho63 commented 4 years ago

image

What in the flying hell look at em all

tanho63 commented 4 years ago

Logging my solution for posterity: I'm taking a unique of sportradar_id and the oldest of "age" - it seems that sleeper stops tracking/recalculating age for their duplicates. Here's hoping this solves it a little.

danabrey commented 4 years ago

Thanks for looking into this!

I will forever call him Deprecated Chris Herndon.