Download baseball reference data with player IDs


Players stats, trades, and more

Teams stats, schedules, and more
Stats, Games, Leaders, Managers, Draft, …

Play Index research tools and more
Season, Event, Streak, Game Finders, …

Leagues standings, leaders, and more
Standings, Leaders, Stats, Debuts, Shortstop Fielding, Box Scores, …

Managers records and more
Durocher, Walsh, Williams, Sortable Leaders …

Leaders season, career, and more
Single-Season, Career, Active, Progressive, Year-by-Year, …

Awards MVP, All-Star, and more
MVP, AL Gold Gloves, Rookie of the Year, Triple Crowns, Hall of Fame, …

Postseason games, stats, and more
1918 WS, 1954 Game 1, Career Batting …

Bullpen Wiki 74,800+ pages of info
Nippon ProBall, College World Series, Contribute …

Nippon Pro Baseball (Japanese) players, teams, and more
Pacific League, Central League, Sadaharu Oh, 2010 Chiba Lotte Marines, …

Negro Leagues players, teams,...

0 0

Welcome to the second part of the “Create Your Own Fantasy Baseball Rankings” series. If you missed Part 1, you can find it here. You can start at the beginning or if you want to start here at Part 2, you can download the Excel file created during part 1 here.

A few notes about the series:

It was originally written before the 2013 MLB season. The screenshots and player references you see might refer to things from that time frame, but the same approach will work today. If you register as SFBB Insider, you can receive all six parts in a free, tidy, and easy-to-use e-book Familiarity with Excel is recommended, but I do my best to explain all formulas and functions used Some of the formulas used in the series do not work in Excel for Mac computers. I apologize for this. I don’t understand why Excel isn’t built to operate the same on that platform.

In this second part of the series we discuss what player IDs are so we can later use them to pull information within...

0 0

Welcome to the first part of a series in which we’ll go step-by-step through the process of using Microsoft Excel to calculate your own rankings for a fantasy baseball points league (as opposed to rotisserie or head-to-head rotisserie).

Whether you’re in a standard points league at a major site like ESPN or a more advanced Ottoneu league at Fangraphs, this process will help you develop customized rankings for your league. These instructions can be used for a season-long points league or a weekly head-to-head points league.

If you’re looking for info on how to rank players for a roto league, look here.

In this first part of the series we’ll start a new Excel file and download projection information.

Why I Created This Series

Points leagues seem to be like fingerprints and snow flakes. Each one is a little different than the others. I’m a big believer that in order to be a strong fantasy player, you need to create your own rankings and dollar...

0 0

mlb_rosetta - A universal baseball player crosswalk

id - Major League Baseball Advanced Media (MLBAM) ID number. This is the ID number you see at the end of a URL when you look at a player's profile page at or a team site. [Integer]

first - first name [String]

last - last name [String]

bis_id - Baseball Information Solutions (BIS) ID. This is the ID number used by Fangraphs and Bill James for their data ( [Integer]

bis_milb_id - BIS ID numbers (I think?) for players who haven't played in the majors yet. [String]

retrosheet_id - ID numbers for Retrosheet ( [String]

baseball_prospectus_id - ID system for Baseball Prospectus' player cards and PECOTA. ( [String]

stats_inc_id - ID numbers from STATS, Inc. ( [Integer]

baseball_db_id - Baseball DataBank ( [Integer]

baseball_reference_id -...

0 0

It's a good time to be a baseball researcher with a computer. This was true in 2000 when How to Do Baseball Research was originally published and it is even more true today. And it isn't only that computer and Internet speeds are more than an order of magnitude faster than they were back at the end of the last century; there has been a tremendous increase in the amount of information available as well. This chapter will describe some of the Internet's best sources of baseball data. Few of these sites even existed back at the beginning of the millenium and most of those that did have changed almost beyond recognition.

So what can we find on the Internet and where can we find it? We will break the answer to this question into two parts: sites that let us browse statistical data and sites that let us download it.

Browsing Baseball Data

This section will focus on data that is made available primarily for browsing. Of course, just about anything that can be...

0 0

Sports Reference frequently receives requests for data. We make every effort to simplify the manual retrieval of small amounts of data from our web sites (e.g., most of our tables can be converted to CSV format). However, our company spends a lot of time, effort, and money producing and checking the data we publish, and as such we can not freely give away large amounts of data that we produce. We are also not able to provide custom datasets for anyone other than our company's closest partners.

If you are interested in obtaining a large amount of data, please contact one or more of the following companies or organizations. Please tell them that we forwarded you to them.

Baseball Info Solutions Contact: Jim Capuano, 630-235-3322 or at jimcapuano at BIS provides a wide array of baseball data. Sports Direct, Inc a Gracenote subsidiary. Gary Gillette 24-7 Baseball, L.L.C. email: GGillette at 24-7 Baseball focuses primarily on historical stats and can...
0 0

Table Definitions (Plain Text format - 26 KB)

Database in Comma-Delimited Form with Table Defs (Zipped Plain Text format - 8207 KB)

Database in mySQL Form (Zipped SQL format - 8566 KB)

Individual Tables in Comma-Delimited Form with Table Defs (Zipped Plain Text format)

Release Notes (last change 2011/03/28)

Consistency Query Results (last change 2011/03/28)

BDB Tables and row count

About this project

A volunteer effort to accumulate and redistribute baseball data in a convenient and easy to use form.

This is an open list that allows folks to discuss new features and bug fixes for the BDB.

We are undergoing a big change in db format and also governance, so there will be considerably change in the next two months.

Ongoing Work

We don't want to duplicate work we don't need to, so this will list the projects currently undertaken and the data currently accumulated by different...

0 0

Regular Season Local Live Blackout in the U.S. and Canada: All live games streamed on any MLB.TV product and available through At Bat are subject to local, regional or national blackouts. Except for certain MLB regular season and Postseason games as described below or in certain MLB Club home television territories for which MLBAM may offer in-market subscription Services, all live games will be blacked out in each applicable Club's home television territory. If a game is blacked out in an area, it is not available for live game viewing. If you are an MLB.TV subscriber within an area subject to blackout, the applicable game will be available as an archived game approximately 90 minutes after the conclusion of the game.

In addition, note:

Home television territory blackout restrictions apply regardless of whether a Club is home or away and regardless of whether or not a game is televised in a Club's home television territory. U.S. Clubs may also be subject to...
0 0

General Tools

Player Season Finder
Search through player regular season and playoff statistics spanning from 1946-47 to today for single seasons or combined seasons that match your criteria.

Player Game Finder
Search through player regular season and playoff game logs spanning from 1963-64 to today for games that match your criteria.

Player Streak Finder
Search through player game logs spanning from 1963-64 to today for streaks that match your criteria.

Team Season Finder
Search through team season stats spanning from 1946-47 to today for seasons that match your criteria.

Team Game Finder
Search through team game logs spanning from 1963-64 to today for games that match your criteria.

Team Streak Finder
Search through team game logs spanning from 1946-47 to today for streaks that match your criteria.

Team Score Finder
Search through team line scores spanning from 1954-55 to today for scores that...

0 0

Do you know if the SGP calculations you’ve done for your league are accurate?

Are you concerned that your home run SGP denominator is 8.87 and Larry Schechter’s book Winning Fantasy Baseball suggests using 5.93 for a 12-team league? Or that your RBI calculation shows 22.31 and the 12-team NFBC history I just calculated shows 19.55?

What does this all mean? Will your rankings be accurate? How can they be when your denominators seem significantly different than those you see elsewhere?

Calm Down, These Numbers Are More Consistent Than You Realize

I know. You’re wondering how on Earth I can say that. How can a HR denominator of 8.87 be consistent with one of 5.93?

To be honest, I’ve had those same fears about SGP. I feel so scientific and strategic by calculating SGP. And then I look at my denominators in comparison to what I see published elsewhere and that confidence evaporates and is replaced with doubt.

In this post I’m going to share an...

0 0

Download the free trial version below to get started. Double-click the downloaded file to install the software.

UpdateStar is compatible with Windows platforms. UpdateStar has been tested to meet all of the technical requirements to be compatible with Windows 10, 8.1, Windows 8, Windows 7, Windows Vista, Windows Server 2003, 2008, and Windows XP, 32 bit and 64 bit editions. Simply double-click the downloaded file to install it. UpdateStar Free and UpdateStar Premium come with the same installer.

UpdateStar includes support for many languages such as English, German, French, Italian, Hungarian, Russian and many more. You can choose your language settings from within the...

0 0