Baselight

NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)

Data on major North American sports leagues compiled into CSV/JSONL form.

@kaggle.chiefzach12_sports_data

All Players
@kaggle.chiefzach12_sports_data.all_players

  • 4.39 MB
  • 1539 rows
  • 46 columns
name

Name

slug

Slug

note

Note

yearsremaining

YearsRemaining

terms

Terms

termsdetails

TermsDetails

termswaiversexempt

TermsWaiversExempt

termsslidecandidate

TermsSlideCandidate

termsspcexempt

TermsSPCExempt

pos

Pos

status

Status

acquired

Acquired

acquisitiondetails

AcquisitionDetails

born

Born

birthplace

Birthplace

nationality

Nationality

shoots

Shoots

height

Height

weight

Weight

elc_signing_age

Elc Signing Age

waivers_age

Waivers Age

draft_year

Draft Year

drafted_overall

Drafted Overall

draft_round

Draft Round

drafted_by

Drafted By

contracts

Contracts

stats

Stats

nhlurl

NhlUrl

nhlid

NhlId

headshot

Headshot

sweaternumber

SweaterNumber

shootscatches

ShootsCatches

careergamesplayed

CareerGamesPlayed

careerseasonsplayed

CareerSeasonsPlayed

currentteam

CurrentTeam

currentteamtricode

CurrentTeamTricode

currentteamslug

CurrentTeamSlug

positions

Positions

nhldays

NhlDays

transactions

Transactions

team

Team

arbitrationeligible

ArbitrationEligible

acquisitiontradeid

AcquisitionTradeId

injury

Injury

acqisitiondetails

AcqisitionDetails

position

Position

Greer, A.J.a-j-greernan2 UFAnanThe contract details displayed have not yet been confirmed and are subject to changeFalseFalseFalseLWNHLSigned2015 Round 2, #39 OverallDec. 14, 1996Joliette, Quebec, CANCANLeft['6\'3"', '191cm']['209 lbs', '95kg']20202015392COL[{'type': 'Standard Contract', 'signedBy': 'Bill Zito', 'length': '2 years', 'value': '$1,700,000', 'expiryStatus': 'UFA', 'capPercent': '0.97', 'signingTeam': 'Florida Panthers', 'signingDate': 'Jul. 1, 2024', 'description': 'AJ Greer signed a 2 year, $1,700,000 contract with the Florida Panthers o…[{'season': '2008-09', 'team': 'Lanaudière Pionniers', 'league': 'QC Int PW', 'gp': 3, 'g': 3, 'a': 1, 'p': 4, 'plusMinus': 0, 'pim': 0, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '…https://www.nhl.com/player/84784218478421https://assets.nhle.com/mugs/nhl/latest/8478421.png10L4Florida PanthersFLAflorida_panthers{'LW': 20336}{'2024-25': 12, 'lastUpdated': '2024-10-09T13:45:51.853Z'}[{'date': 'Jul. 1, 2024', 'team': 'florida_panthers', 'type': 'SIGNING', 'details': 'Signed a Standard Contract for 2 years with Florida Panthers'}, {'date': 'Jul. 13, 2022', 'team': 'boston_bruins', 'type': 'SIGNING', 'details': 'Signed a Standard Contract for 2 years with Boston Bruins'}, {'date':…{'label': 'Florida Panthers', 'tricode': 'FLA'}nannannannannan
Ekblad, Aaronaaron-ekblad"A"1 UFAM-NTCModified No-Trade Clause - (Modified NTC: Player submits a list of 12 teams he would not be willing to be traded to)FalseFalseFalseRDSuspendedDraft2014 Round 1, #1 OverallFeb. 7, 1996Windsor, Ontario, CANCANRight['6\'4"', '193cm']['215 lbs', '98kg']1818201411FLA[{'type': 'Standard Contract (Extension)', 'signedBy': 'Tom Rowe', 'length': '8 years', 'value': '$60,000,000', 'expiryStatus': 'UFA', 'capPercent': '10.27', 'signingTeam': 'Florida Panthers', 'signingDate': 'Jul. 1, 2016', 'description': 'Aaron Ekblad signed a 8 year, $60,000,000 contract with the …[{'season': '2010-11', 'team': 'Sun County', 'league': 'Minor-ON', 'gp': 30, 'g': 4, 'a': 30, 'p': 34, 'plusMinus': 0, 'pim': 34, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'playoffs': {'season': '2010-11', 'team': 'Sun County', 'l…https://www.nhl.com/player/84779328477932https://assets.nhle.com/mugs/nhl/latest/8477932.png5R74010Florida PanthersFLAflorida_panthers{'RD': 46615, 'LD': 681}{'2024-25': 12, 'lastUpdated': '2024-10-09T13:45:51.856Z'}[{'date': 'Jul. 1, 2016', 'team': 'florida_panthers', 'type': 'SIGNING', 'details': 'Signed a Standard Contract (Extension) for 8 years with Florida Panthers'}, {'date': 'Sep. 7, 2014', 'team': 'florida_panthers', 'type': 'SIGNING', 'details': 'Signed a Entry-Level Contract for 3 years with Florida …{'label': 'Florida Panthers', 'tricode': 'FLA'}nannannannannan
Jamsen, Aatuaatu-jamsennan2 RFAELCEntry-Level Contract, Waivers ExemptTrueFalseFalseRWMinorDraft2020 Round 7, #190 OverallJul. 22, 2002FINFINLeft['6\'1"', '185cm']['154 lbs', '70kg']222220201907LAK[{'type': 'Entry-Level Contract', 'signedBy': 'Rob Blake', 'length': '2 years', 'value': '$1,705,000', 'expiryStatus': 'RFA', 'capPercent': '1.02', 'signingTeam': 'Los Angeles Kings', 'signingDate': 'May 21, 2024', 'description': 'Aatu Jämsen signed a 2 year, $1,705,000 contract with the Los Angeles…[{'season': '2017-18', 'team': 'Pelicans U18', 'league': 'U18 SM-sarja', 'gp': 1, 'g': 0, 'a': 0, 'p': 0, 'plusMinus': 0, 'pim': 0, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '2017-…https://www.nhl.com/player/84824668482466https://assets.nhle.com/mugs/nhl/latest/8482466.png74LLos Angeles KingsLAKlos_angeles_kingsnannan[{'date': 'May 21, 2024', 'team': 'los_angeles_kings', 'type': 'SIGNING', 'details': 'Signed a Entry-Level Contract for 2 years with Los Angeles Kings'}, {'date': 'October 6, 2020', 'team': 'los_angeles_kings', 'type': 'DRAFT', 'details': 'Drafted round 7, #190 Overall'}]{'label': 'Los Angeles Kings', 'tricode': 'LAK'}Falsenannannannan
Raty, Aatuaatu-ratynan1 RFAELCEntry-Level Contract, Maximum Potential Performance Bonuses: $32,500, Waivers ExemptTrueFalseFalseCNHLTradeTraded from New York Islanders Jan. 30, 2023Nov. 14, 2002Oulu, FINFINLeft['6\'2"', '188cm']['190 lbs', '86kg']18192021522NYI[{'type': 'Entry-Level Contract', 'signedBy': 'Lou Lamoriello', 'length': '3 years', 'value': '$2,800,000', 'expiryStatus': 'RFA', 'capPercent': '1.03', 'signingTeam': 'New York Islanders', 'signingDate': 'Aug. 14, 2021', 'description': 'Aatu Räty signed a 3 year, $2,800,000 contract with the New Yo…[{'season': '2014-15', 'team': 'Finland Selects U13', 'league': 'WSI U13', 'gp': 9, 'g': 4, 'a': 10, 'p': 14, 'plusMinus': 0, 'pim': 6, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '2…https://www.nhl.com/player/84826918482691https://assets.nhle.com/mugs/nhl/latest/8482691.png54L1Vancouver CanucksVANvancouver_canucksnan{'2024-25': 9, 'lastUpdated': '2024-10-09T13:45:51.858Z'}[{'date': '2024-11-14', 'teamSlug': 'vancouver_canucks', 'type': 'DEL', 'details': 'Recalled from loan by Vancouver (NHL)'}, {'date': '2024-11-13', 'teamSlug': 'vancouver_canucks', 'type': 'ADD', 'details': 'Returned on loan from Vancouver (NHL)'}, {'date': '2024-11-05', 'teamSlug': 'vancouver_canuc…{'label': 'Vancouver Canucks', 'tricode': 'VAN'}False2023-01-30-VAN-NYInannannan
Beckman, Adamadam-beckmannan0 RFAnannanFalseFalseFalseLW, RWMinorTradeThe New Jersey Devils have acquired defenseman Dennis Cholowski from the New York Islanders in exchange for forward Adam Beckman. on Mar. 07 2025May. 10, 2001Saskatoon, Saskatchewan, CANCANLeft['6\'2"', '188cm']['182 lbs', '83kg']19192019753MIN[{'type': 'Two-Way Contract', 'length': '1 year', 'value': '$775,000', 'expiryStatus': 'RFA (Arb)', 'signingTeam': 'New Jersey Devils', 'signingDate': 'Jul. 15, 2024', 'signedBy': 'Tom Fitzgerald', 'description': 'Adam Beckman signed a 1 year, $775,000 two-way contract with the New Jersey Devils on …[{'season': '2013-14', 'team': 'Saskatoon Stallions Bantam AA', 'league': 'SBAAHL', 'gp': 5, 'g': 0, 'a': 3, 'p': 3, 'plusMinus': 0, 'pim': 0, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'playoffs': {'season': '2013-14', 'team': 'Sa…https://www.nhl.com/player/84815508481550https://assets.nhle.com/mugs/nhl/latest/8481550.png12LNew York IslandersNYInew_york_islanders{'RW': 892, 'LW': 2713}nan[{'date': 'Mar. 07, 2025', 'team': 'new_york_islanders', 'type': 'TRADE', 'details': 'The New Jersey Devils have acquired defenseman Dennis Cholowski from the New York Islanders in exchange for forward Adam Beckman.', 'tradeId': '2025-03-07-NJD-NYI'}, {'date': '2024-10-21', 'teamSlug': 'new_jersey_d…{'label': 'New York Islanders', 'tricode': 'NYI'}False2025-03-07-NJD-NYInannannan
Boqvist, Adamadam-boqvistnannannannanFalsenannanRD, LDNHLWaiversClaimed off waivers from FLA 2025-01-31Aug. 15, 2000Falun, SWESWEnan['6\'0"', '183cm']['189 lbs', '86kg']1818201881CHI[{'type': 'Standard Contract', 'length': '1 year', 'value': '$775,000', 'expiryStatus': 'RFA (Arb)', 'signingTeam': 'Florida Panthers', 'signingDate': 'Jul. 9, 2024', 'description': 'Adam Boqvist signed a one-year contract with the Florida Panthers on Jul. 9, 2024. Boqvist brings NHL experience from…[{'season': '2013-14', 'team': 'Hedemora SK U16', 'league': 'U16 Elit', 'gp': 17, 'g': 0, 'a': 1, 'p': 1, 'plusMinus': 0, 'pim': 2, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '2014-…https://www.nhl.com/player/84808718480871https://assets.nhle.com/mugs/nhl/latest/8480871.png34R2175New York IslandersNYInew_york_islanders{'RD': 30087, 'LD': 1607}{'2024-25': 12, 'lastUpdated': '2024-10-09T13:45:51.859Z'}[{'type': 'claim waivers', 'date': '2025-01-31', 'teamSlug': 'new_york_islanders', 'details': ' Adam Boqvist Claimed off waivers from FLA'}, {'type': 'add waivers', 'date': '2025-01-30', 'teamSlug': 'florida_panthers', 'details': 'Placed on waivers'}, {'date': 'Jul. 9, 2024', 'team': 'florida_panthe…{'label': 'New York Islanders', 'tricode': 'NYI'}nannannannannan
Edstrom, Adamadam-edstromnan1 RFAELCEntry-Level Contract, Waivers ExemptTrueFalseFalseRW, CIRDraft2019 Round 6, #161 OverallOct. 12, 2000Karlstad, SWESWELeft['6\'7"', '201cm']['234 lbs', '106kg']212220191616NYR[{'type': 'Entry-Level Contract', 'signedBy': 'Chris Drury', 'length': '3 years', 'value': '$2,540,000', 'expiryStatus': 'RFA (Arb)', 'capPercent': '1.03', 'signingTeam': 'New York Rangers', 'signingDate': 'May 7, 2022', 'description': 'Adam Edström signed a 3 year, $2,540,000 contract with the New …[{'season': '2014-15', 'team': 'Hammarö HC U16', 'league': 'U16 Div.1', 'gp': 15, 'g': 9, 'a': 7, 'p': 16, 'plusMinus': 0, 'pim': 8, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '2015…https://www.nhl.com/player/84817268481726https://assets.nhle.com/mugs/nhl/latest/8481726.png84LNew York RangersNYRnew_york_rangers{'RW': 3485}{'2024-25': 11, 'lastUpdated': '2024-10-10T13:48:07.826Z'}[{'type': 'ADD IR', 'date': '2025-02-04', 'teamSlug': 'new_york_rangers', 'details': 'Placed on Injured Reserve'}, {'date': 'May 7, 2022', 'team': 'new_york_rangers', 'type': 'SIGNING', 'details': 'Signed a Entry-Level Contract for 3 years with New York Rangers'}, {'date': 'June 21, 2019', 'team': '…{'label': 'New York Rangers', 'tricode': 'NYR'}Falsenan{'type': 'Lower Body', 'returnDate': '2025-04-17'}nannan
Engstrom, Adamadam-engstromnan3 RFAELCEntry-Level Contract, Maximum Potential Performance Bonuses: $80,000, Waivers ExemptTrueFalseFalseLD, RDMinorDraft2022 Round 3, #92 OverallNov. 17, 2003Jarna, SWESWELeft['6\'2"', '188cm']['193 lbs', '88kg']20212022923MTL[{'type': 'Entry-Level Contract', 'signedBy': 'Kent Hughes', 'length': '3 years', 'value': '$2,850,000', 'expiryStatus': 'RFA', 'capPercent': '1.07', 'signingTeam': 'Montreal Canadiens', 'signingDate': 'May 3, 2024', 'description': 'Adam Engström signed a 3 year, $2,850,000 contract with the Montrea…[{'season': '2016-17', 'team': 'Järna SK J18 2', 'league': 'J18 Div.2', 'gp': 8, 'g': 0, 'a': 0, 'p': 0, 'plusMinus': 0, 'pim': 6, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'platformSeason': None, 'diff': None}, {'season': '2017-1…https://www.nhl.com/player/84836868483686https://assets.nhle.com/mugs/nhl/latest/8483686.png42LMontréal CanadiensMTLmontreal_canadiensnannan[{'date': 'May 3, 2024', 'team': 'montreal_canadiens', 'type': 'SIGNING', 'details': 'Signed a Entry-Level Contract for 3 years with Montreal Canadiens'}, {'date': 'July 7, 2022', 'team': 'montreal_canadiens', 'type': 'DRAFT', 'details': 'Drafted round 3, #92 Overall'}]{'label': 'Montreal Canadiens', 'tricode': 'MTL'}Falsenannannannan
Fantilli, Adamadam-fantillinan2 RFAELCEntry-Level Contract, Maximum Potential Performance Bonuses: $3,200,000, Waivers ExemptTrueFalseFalseC, LWNHLDraft2023 Round 1, #3 OverallOct. 12, 2004Nobleton, Ontario, CANCANLeft['6\'2"', '188cm']['194 lbs', '88kg']1819202331CBJ[{'type': 'Entry-Level Contract', 'signedBy': 'Jarmo Kekalainen', 'length': '3 years', 'value': '$12,450,000', 'expiryStatus': 'RFA', 'capPercent': '1.14', 'signingTeam': 'Columbus Blue Jackets', 'signingDate': 'Jul. 1, 2023', 'description': 'Adam Fantilli signed a 3 year, $12,450,000 contract with …[{'season': '2013-14', 'team': 'Toronto Pro Hockey', 'league': 'Brick Invitational', 'gp': 6, 'g': 3, 'a': 0, 'p': 3, 'plusMinus': 0, 'pim': 0, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'playoffs': {'season': '2013-14', 'team': 'T…https://www.nhl.com/player/84841668484166https://assets.nhle.com/mugs/nhl/latest/8484166.png19L1Columbus Blue JacketsCBJcolumbus_blue_jackets{'LW': 7534, 'C': 18458, 'RW': 1194}{'2024-25': 12, 'lastUpdated': '2024-10-09T13:45:51.860Z'}[{'date': 'Jul. 1, 2023', 'team': 'columbus_blue_jackets', 'type': 'SIGNING', 'details': 'Signed a Entry-Level Contract for 3 years with Columbus Blue Jackets'}, {'date': 'June 23, 2023', 'team': 'columbus_blue_jackets', 'type': 'DRAFT', 'details': 'Drafted round 1, #3 Overall'}]{'label': 'Columbus Blue Jackets', 'tricode': 'CBJ'}Falsenannannannan
Fox, Adamadam-fox"A"5 UFAnannanFalseFalseFalseRDNHLTradeTraded from Carolina Hurricanes Apr. 30, 2019Feb. 17, 1998Jericho, New York, USAUSARight['5\'11"', '180cm']['185 lbs', '84kg']21212016663CGY[{'type': 'Standard Contract (Extension)', 'signedBy': 'Chris Drury', 'length': '7 years', 'value': '$66,500,000', 'expiryStatus': 'UFA', 'capPercent': '11.66', 'signingTeam': 'New York Rangers', 'signingDate': 'Nov. 1, 2021', 'description': 'Adam Fox signed a 7 year, $66,500,000 contract with the N…[{'season': '2010-11', 'team': 'New York Jr. Islanders', 'league': 'QC Int PW', 'gp': 2, 'g': 0, 'a': 2, 'p': 2, 'plusMinus': 0, 'pim': 2, 'toi': 0, 'foPct': 0, 'gwg': 0, 'otG': 0, 'ppg': 0, 'ppp': 0, 'shootingPct': 0, 'shG': 0, 'shP': 0, 'shots': 0, 'playoffs': {'season': '2010-11', 'team': 'New Yo…https://www.nhl.com/player/84793238479323https://assets.nhle.com/mugs/nhl/latest/8479323.png23R4035New York RangersNYRnew_york_rangers{'RD': 70013, 'LD': 3666}{'2024-25': 12, 'lastUpdated': '2024-10-09T13:45:51.861Z'}[{'type': 'DEL IR', 'date': '2025-03-15', 'teamSlug': 'new_york_rangers', 'details': 'Activated from Injured Reserve'}, {'type': 'ADD IR', 'date': '2025-02-26', 'teamSlug': 'new_york_rangers', 'details': 'Placed on Injured Reserve'}, {'date': 'Nov. 1, 2021', 'team': 'new_york_rangers', 'type': 'SIGN…{'label': 'New York Rangers', 'tricode': 'NYR'}nan2019-04-30-NYR-CARnannannan

CREATE TABLE all_players (
  "name" VARCHAR,
  "slug" VARCHAR,
  "note" VARCHAR,
  "yearsremaining" VARCHAR,
  "terms" VARCHAR,
  "termsdetails" VARCHAR,
  "termswaiversexempt" VARCHAR,
  "termsslidecandidate" VARCHAR,
  "termsspcexempt" VARCHAR,
  "pos" VARCHAR,
  "status" VARCHAR,
  "acquired" VARCHAR,
  "acquisitiondetails" VARCHAR,
  "born" VARCHAR,
  "birthplace" VARCHAR,
  "nationality" VARCHAR,
  "shoots" VARCHAR,
  "height" VARCHAR,
  "weight" VARCHAR,
  "elc_signing_age" VARCHAR,
  "waivers_age" VARCHAR,
  "draft_year" VARCHAR,
  "drafted_overall" DOUBLE,
  "draft_round" DOUBLE,
  "drafted_by" VARCHAR,
  "contracts" VARCHAR,
  "stats" VARCHAR,
  "nhlurl" VARCHAR,
  "nhlid" BIGINT,
  "headshot" VARCHAR,
  "sweaternumber" DOUBLE,
  "shootscatches" VARCHAR,
  "careergamesplayed" DOUBLE,
  "careerseasonsplayed" DOUBLE,
  "currentteam" VARCHAR,
  "currentteamtricode" VARCHAR,
  "currentteamslug" VARCHAR,
  "positions" VARCHAR,
  "nhldays" VARCHAR,
  "transactions" VARCHAR,
  "team" VARCHAR,
  "arbitrationeligible" VARCHAR,
  "acquisitiontradeid" VARCHAR,
  "injury" VARCHAR,
  "acqisitiondetails" VARCHAR,
  "position" VARCHAR
);

Share link

Anyone who has the link will be able to view this.