search

edavis25 / Fantasy-Football-Database

Fantasy football data scraping and projections.
http://ffdatabase.hopto.org
12 stars 2 forks source link

2 Players, Same Name #2

Closed edavis25 closed 8 years ago

edavis25 commented 8 years ago

Different players same names:

Robert Thomas - 2x

  1. Currently active DT for Dolphins
  2. Retired LB for Packers/Raiders (Player info scraped for this one)

Find them w/ SQL: FROM Games, PlayerGame, Players WHERE Games.GameID = PlayerGame.GameID AND PlayerGame.PlayerID = Players.PlayerID AND Players.Name ='Robert Thomas';

edavis25 commented 8 years ago

2X Brandon Marshalls

  1. WR
  2. LB - Broncos
edavis25 commented 8 years ago

2x Alex Smith

  1. QB - 49ers + Chiefs
  2. TE - Buccaneers, Eagles, Browns, Bengals, Redskins (since 2005)
edavis25 commented 8 years ago

2x Adrian Peterson

  1. Child Beater - Vikings
  2. RB - Bears (2005-2010)
edavis25 commented 8 years ago

2x Mike Adams:

  1. DB - 49ers, Browns, Broncos, Colts (currently)
  2. OL - (Ohio State) Steelers
edavis25 commented 8 years ago

2x Michael Bennett

  1. DE - Seahawks
  2. WR - Bengals
edavis25 commented 8 years ago

2x Malcolm Brown

  1. DL - Patriots
  2. RB - Rams
edavis25 commented 8 years ago

2x Chris Clemons

  1. DL - Seahawks
  2. DB - Cardinals (more of these than I thought....)
edavis25 commented 8 years ago

All exhaustive duplicate player information can be found in the "Player-Info-EXCEL.xlsx" workbook in the database/data.