NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)
Data on major North American sports leagues compiled into CSV/JSONL form.
@kaggle.chiefzach12_sports_data
Data on major North American sports leagues compiled into CSV/JSONL form.
@kaggle.chiefzach12_sports_data
nameName | slugSlug | noteNote | yearsremainingYearsRemaining | termsTerms | termsdetailsTermsDetails | termswaiversexemptTermsWaiversExempt | termsslidecandidateTermsSlideCandidate | termsspcexemptTermsSPCExempt | posPos | statusStatus | acquiredAcquired | acquisitiondetailsAcquisitionDetails | bornBorn | birthplaceBirthplace | nationalityNationality | shootsShoots | heightHeight | weightWeight | elc_signing_ageElc Signing Age | waivers_ageWaivers Age | draft_yearDraft Year | drafted_overallDrafted Overall | draft_roundDraft Round | drafted_byDrafted By | contractsContracts | statsStats | nhlurlNhlUrl | nhlidNhlId | headshotHeadshot | sweaternumberSweaterNumber | shootscatchesShootsCatches | careergamesplayedCareerGamesPlayed | careerseasonsplayedCareerSeasonsPlayed | currentteamCurrentTeam | currentteamtricodeCurrentTeamTricode | currentteamslugCurrentTeamSlug | positionsPositions | nhldaysNhlDays | transactionsTransactions | teamTeam | arbitrationeligibleArbitrationEligible | acquisitiontradeidAcquisitionTradeId | injuryInjury | acqisitiondetailsAcqisitionDetails | positionPosition |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Greer, A.J. | a-j-greer | nan | 2 UFA | nan | The contract details displayed have not yet been confirmed and are subject to change | False | False | False | LW | NHL | Signed | 2015 Round 2, #39 Overall | Dec. 14, 1996 | Joliette, Quebec, CAN | CAN | Left | ['6\'3"', '191cm'] | ['209 lbs', '95kg'] | 20 | 20 | 2015 | 39 | 2 | COL | [{'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/8478421 | 8478421 | https://assets.nhle.com/mugs/nhl/latest/8478421.png | 10 | L | 4 | Florida Panthers | FLA | florida_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'} | nan | nan | nan | nan | nan | |
Ekblad, Aaron | aaron-ekblad | "A" | 1 UFA | M-NTC | Modified No-Trade Clause - (Modified NTC: Player submits a list of 12 teams he would not be willing to be traded to) | False | False | False | RD | Suspended | Draft | 2014 Round 1, #1 Overall | Feb. 7, 1996 | Windsor, Ontario, CAN | CAN | Right | ['6\'4"', '193cm'] | ['215 lbs', '98kg'] | 18 | 18 | 2014 | 1 | 1 | FLA | [{'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/8477932 | 8477932 | https://assets.nhle.com/mugs/nhl/latest/8477932.png | 5 | R | 740 | 10 | Florida Panthers | FLA | florida_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'} | nan | nan | nan | nan | nan |
Jamsen, Aatu | aatu-jamsen | nan | 2 RFA | ELC | Entry-Level Contract, Waivers Exempt | True | False | False | RW | Minor | Draft | 2020 Round 7, #190 Overall | Jul. 22, 2002 | FIN | FIN | Left | ['6\'1"', '185cm'] | ['154 lbs', '70kg'] | 22 | 22 | 2020 | 190 | 7 | LAK | [{'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/8482466 | 8482466 | https://assets.nhle.com/mugs/nhl/latest/8482466.png | 74 | L | Los Angeles Kings | LAK | los_angeles_kings | nan | nan | [{'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'} | False | nan | nan | nan | nan | ||
Raty, Aatu | aatu-raty | nan | 1 RFA | ELC | Entry-Level Contract, Maximum Potential Performance Bonuses: $32,500, Waivers Exempt | True | False | False | C | NHL | Trade | Traded from New York Islanders Jan. 30, 2023 | Nov. 14, 2002 | Oulu, FIN | FIN | Left | ['6\'2"', '188cm'] | ['190 lbs', '86kg'] | 18 | 19 | 2021 | 52 | 2 | NYI | [{'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/8482691 | 8482691 | https://assets.nhle.com/mugs/nhl/latest/8482691.png | 54 | L | 1 | Vancouver Canucks | VAN | vancouver_canucks | nan | {'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'} | False | 2023-01-30-VAN-NYI | nan | nan | nan | |
Beckman, Adam | adam-beckman | nan | 0 RFA | nan | nan | False | False | False | LW, RW | Minor | Trade | The New Jersey Devils have acquired defenseman Dennis Cholowski from the New York Islanders in exchange for forward Adam Beckman. on Mar. 07 2025 | May. 10, 2001 | Saskatoon, Saskatchewan, CAN | CAN | Left | ['6\'2"', '188cm'] | ['182 lbs', '83kg'] | 19 | 19 | 2019 | 75 | 3 | MIN | [{'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/8481550 | 8481550 | https://assets.nhle.com/mugs/nhl/latest/8481550.png | 12 | L | New York Islanders | NYI | new_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'} | False | 2025-03-07-NJD-NYI | nan | nan | nan | ||
Boqvist, Adam | adam-boqvist | nan | nan | nan | nan | False | nan | nan | RD, LD | NHL | Waivers | Claimed off waivers from FLA 2025-01-31 | Aug. 15, 2000 | Falun, SWE | SWE | nan | ['6\'0"', '183cm'] | ['189 lbs', '86kg'] | 18 | 18 | 2018 | 8 | 1 | CHI | [{'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/8480871 | 8480871 | https://assets.nhle.com/mugs/nhl/latest/8480871.png | 34 | R | 217 | 5 | New York Islanders | NYI | new_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'} | nan | nan | nan | nan | nan |
Edstrom, Adam | adam-edstrom | nan | 1 RFA | ELC | Entry-Level Contract, Waivers Exempt | True | False | False | RW, C | IR | Draft | 2019 Round 6, #161 Overall | Oct. 12, 2000 | Karlstad, SWE | SWE | Left | ['6\'7"', '201cm'] | ['234 lbs', '106kg'] | 21 | 22 | 2019 | 161 | 6 | NYR | [{'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/8481726 | 8481726 | https://assets.nhle.com/mugs/nhl/latest/8481726.png | 84 | L | New York Rangers | NYR | new_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'} | False | nan | {'type': 'Lower Body', 'returnDate': '2025-04-17'} | nan | nan | ||
Engstrom, Adam | adam-engstrom | nan | 3 RFA | ELC | Entry-Level Contract, Maximum Potential Performance Bonuses: $80,000, Waivers Exempt | True | False | False | LD, RD | Minor | Draft | 2022 Round 3, #92 Overall | Nov. 17, 2003 | Jarna, SWE | SWE | Left | ['6\'2"', '188cm'] | ['193 lbs', '88kg'] | 20 | 21 | 2022 | 92 | 3 | MTL | [{'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/8483686 | 8483686 | https://assets.nhle.com/mugs/nhl/latest/8483686.png | 42 | L | Montréal Canadiens | MTL | montreal_canadiens | nan | nan | [{'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'} | False | nan | nan | nan | nan | ||
Fantilli, Adam | adam-fantilli | nan | 2 RFA | ELC | Entry-Level Contract, Maximum Potential Performance Bonuses: $3,200,000, Waivers Exempt | True | False | False | C, LW | NHL | Draft | 2023 Round 1, #3 Overall | Oct. 12, 2004 | Nobleton, Ontario, CAN | CAN | Left | ['6\'2"', '188cm'] | ['194 lbs', '88kg'] | 18 | 19 | 2023 | 3 | 1 | CBJ | [{'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/8484166 | 8484166 | https://assets.nhle.com/mugs/nhl/latest/8484166.png | 19 | L | 1 | Columbus Blue Jackets | CBJ | columbus_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'} | False | nan | nan | nan | nan | |
Fox, Adam | adam-fox | "A" | 5 UFA | nan | nan | False | False | False | RD | NHL | Trade | Traded from Carolina Hurricanes Apr. 30, 2019 | Feb. 17, 1998 | Jericho, New York, USA | USA | Right | ['5\'11"', '180cm'] | ['185 lbs', '84kg'] | 21 | 21 | 2016 | 66 | 3 | CGY | [{'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/8479323 | 8479323 | https://assets.nhle.com/mugs/nhl/latest/8479323.png | 23 | R | 403 | 5 | New York Rangers | NYR | new_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'} | nan | 2019-04-30-NYR-CAR | nan | nan | nan |
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
);
Anyone who has the link will be able to view this.