List All Pages
This is an attempt to replicate J.C. Bradbury's Marginal Revenue Product estimates of player values in his book, "The Baseball Economist," described in Chapter 13 and the footnotes. I tweaked the...
Calculates a player's Equivalent Runs and Marginal Lineup Value, the two competing run estimation techniques used by Baseball Prospectus.
Thanks to Patriot for helping explain EqR.
MySQL
CREATE...
Questions? Comments? Concerns? Send an email to:
pontifexexmachina at hotmail.com
Players' statistics are stored in the database by each team that they played for in each year (each "stint"). The following views can be used to work with a player's full year stats. This does not...
Uses the Baseball On A Stick database schema.
CREATE TABLE player_subs AS
SELECT gameName
, IF(halfInning = "top","home","away") AS homeAway
, eventNumber
, player
, (CASE WHEN...
If you are allowed to edit pages in this Site, simply click on edit button at the bottom of the page. This will open an editor.
To create a link to a new page, use syntax: [[[new page name]]] or...
Download MySQL 5.1 CE Essentials. (It should be the first link under “Windows Downloads.” If you aren’t running Windows… well, I suspect you know more about your Linux/Mac/Amiga machine...
We want you - the few, the proud, the sabermetricians. Join us!
Based on Tom Tango's Marcels projection system.
MySQL
CREATE TABLE batting_pos
AS
SELECT b.playerID
, CAST(b.yearID AS SIGNED) AS yearID
, POW(0.9994,(2009-CAST(b.yearID AS...
MySQL
Using the appearances table:
SELECT playerID
, yearID
, teamID
, (CASE WHEN G_p = GREATEST(G_p,G_c,G_1b,G_2b,G_3b,G_ss,G_lf,G_cf,G_rf,G_dh)
THEN "P"
WHEN G_c =...
Find run expectancy season-by-season using only the Baseball Databank. Based upon a blog post from Tango.
CREATE TABLE FATE_RE
AS
SELECT yearID, lgID, SUM(R)/SUM(IPOuts/3) AS RE_0_0
,...
Welcome page
How to edit pages?
How to join this site?
Site members
Recent changes
List all pages
Page Tags
Site Manager
Page tags
Add a new page
edit this panel
This is my zone rating system, as written about in The Hardball Times. So far, only the Retrosheet version of SZR is being made available.
WARNING: Some of these queries can take a long time to...
Members:
Moderators
Admins
Menu
Forums
contact
Tutorials
Building a Sabermetrican's Workbench, Part I
Building a Sabermetrican's Workbench, Part II
FirstSQL Tutorial
Tizag's tutorial
W3Schools SQL
References
MySQL Documentation
MySQL Cheat...
What's BaSQL?
The name is a combination of "base" and "SQL" (pronounced "sequel"), a database query language. If you want to study baseball using SQL, you're in the right place.
Where do I...
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
Adapted from a blog entry by Tom Tango. For the Baseball Databank.
MySQL
CREATE TABLE PrimPos AS
SELECT playerID
, yearID
, teamID
, MAX(G) AS G
, POS
FROM (SELECT * from bdb.fielding
WHERE...
