Baseball SQL Discussion

Contact owners and managers

1–23 of 23

I think more people learning SQL is better for the sabermetric community. We can learn more from each other here. Check out some links to help you get started:

Getting Started:

Beyond the Box Score

Daily Database Update:

0 selected

8/15/14

Help Finding Peak Offensive Performance

Hey all, Pretty pumped about finding this discussion board. I'm new to programming, but have been

unread,

Help Finding Peak Offensive Performance

Hey all, Pretty pumped about finding this discussion board. I'm new to programming, but have been

8/15/14

Matt Bandi, Daniel Hirsch3

7/2/14

first X number of career years

Worked perfectly. Thanks so much for your help. On Tuesday, July 1, 2014 2:58:11 PM UTC-4, Dan Hirsch

unread,

first X number of career years

Worked perfectly. Thanks so much for your help. On Tuesday, July 1, 2014 2:58:11 PM UTC-4, Dan Hirsch

7/2/14

David Taylor, Jonathan Cram3

4/9/14

Sorry David, I misread your message. I don't know the answer to your question unless you can join

unread,

Sorry David, I misread your message. I don't know the answer to your question unless you can join

4/9/14

Jerry Woodfield, … Jonathan Cram6

4/9/14

Importing a CSV file

Sorry, for got to include the group. On Wed, Apr 9, 2014 at 2:59 PM, Jonathan Cram <jonathan.cram@

unread,

Importing a CSV file

Sorry, for got to include the group. On Wed, Apr 9, 2014 at 2:59 PM, Jonathan Cram <jonathan.cram@

4/9/14

Chris St. John, … David Taylor5

4/7/14

Analyzing baseball data with R

I can't seem to get R to connect to my MySQL database. On Wednesday, November 6, 2013 3:19:18 PM

unread,

Analyzing baseball data with R

I can't seem to get R to connect to my MySQL database. On Wednesday, November 6, 2013 3:19:18 PM

4/7/14

3/1/14

Can't understand lack of matching records using left join

Hi folks, I feel really stupid asking this, but I CANNOT figure out why this is returning all null

unread,

Can't understand lack of matching records using left join

Hi folks, I feel really stupid asking this, but I CANNOT figure out why this is returning all null

3/1/14

Chris St. John, Matt Dennewitz2

2/4/14

Baseball Hack Day Resources

this is an incredible resource. thanks for sharing. On Tue, Feb 4, 2014 at 1:45 PM, Chris St. John

unread,

Baseball Hack Day Resources

this is an incredible resource. thanks for sharing. On Tue, Feb 4, 2014 at 1:45 PM, Chris St. John

2/4/14

jonath...@gmail.com, Bryan Cole2

1/17/14

Stumbled across this site the other day. The book "Baseball Hacks" has a number of MySQL

unread,

Stumbled across this site the other day. The book "Baseball Hacks" has a number of MySQL

1/17/14

John Choiniere, … jonath...@gmail.com7

1/17/14

Run Expectancy/Empirical LWTS

I don't know if anyone used by RE creator, but I realized today it didn't include any three-

unread,

Run Expectancy/Empirical LWTS

I don't know if anyone used by RE creator, but I realized today it didn't include any three-

1/17/14

Chris St. John, … jonath...@gmail.com4

12/22/13

Weekly Challenge

Whoah, I don't know why but I struggled with this one. Humbling experience. I originally wrote it

unread,

Weekly Challenge

Whoah, I don't know why but I struggled with this one. Humbling experience. I originally wrote it

12/22/13

John Choiniere, jonath...@gmail.com3

11/30/13

Pitching game log

They're homemade from "events" and "games" respectively. I manually, using

unread,

Pitching game log

They're homemade from "events" and "games" respectively. I manually, using

11/30/13

wool0135, … jonath...@gmail.com16

11/30/13

General question

I ran this query (returning all the columns) and it looks like the roster table has a record for each

unread,

General question

I ran this query (returning all the columns) and it looks like the roster table has a record for each

11/30/13

jonath...@gmail.com

11/30/13

Top 10 Longest Games In Hours

My first REAL query using the Retrosheet database. I went overboard obviously since this probably

unread,

Top 10 Longest Games In Hours

My first REAL query using the Retrosheet database. I went overboard obviously since this probably

11/30/13

Chris St. John, … jonath...@gmail.com44

11/30/13

Welcome everyone, let's start discussing

Hello, my name is Jonathan Cram and I learned about the Retrosheet db via the 'Saberizing a Mac

unread,

Welcome everyone, let's start discussing

Hello, my name is Jonathan Cram and I learned about the Retrosheet db via the 'Saberizing a Mac

11/30/13

Ben Horrow, … Matthew Dickinson4

11/16/13

Thanks so much for all the help, I've been able to figure it out. On Sat, Nov 16, 2013 at 11:55

unread,

Thanks so much for all the help, I've been able to figure it out. On Sat, Nov 16, 2013 at 11:55

11/16/13

Bryan Cole, Nicholas Miceli2

11/3/13

NFL play-by-play SQL data

I think that Sean Lahman (http://seanlahman.com/) was involved with a group of people in The Football

unread,

NFL play-by-play SQL data

I think that Sean Lahman (http://seanlahman.com/) was involved with a group of people in The Football

11/3/13

9/2/13

Leverage Index and WPA calculators?

Hey guys, Just started working with the Retrosheet and BDB databases (thanks to everyone behind the

unread,

Leverage Index and WPA calculators?

Hey guys, Just started working with the Retrosheet and BDB databases (thanks to everyone behind the

9/2/13

Nicholas Miceli2

8/23/13

~BSQL~: Pitch f/x data; matching pitcher id with pitches.

Good evening, With some valuable help, I just figured it out. Harry Pavlidis pointed me in the right

unread,

~BSQL~: Pitch f/x data; matching pitcher id with pitches.

Good evening, With some valuable help, I just figured it out. Harry Pavlidis pointed me in the right

8/23/13

Chris St. John, … James Gentile7

6/3/13

Summing fields with criteria

This is a copy from the Retrosheet site somewhere: http://uzrillusion2.blogspot.com/2013/04/

unread,

Summing fields with criteria

This is a copy from the Retrosheet site somewhere: http://uzrillusion2.blogspot.com/2013/04/

6/3/13

5/8/13

Pitch f/x Hit_x and Hit_y

Hey everyone, what a lively group! I'm playing with some pitch f/x data and have a question

unread,

Pitch f/x Hit_x and Hit_y

Hey everyone, what a lively group! I'm playing with some pitch f/x data and have a question

5/8/13

Chris St. John, … Sean Ahmed7

4/18/13

I was thinking of just looking at fly balls and home runs to hopefully get rid of the fielder caveat.

unread,

I was thinking of just looking at fly balls and home runs to hopefully get rid of the fielder caveat.

4/18/13

Chris St. John, KiNG KoNG2

4/15/13

Creating indexes

An index creates an ordered subset of a table in memory so that it can search it more quickly when

unread,

Creating indexes

An index creates an ordered subset of a table in memory so that it can search it more quickly when

4/15/13

4/10/13

To address Matt's question about a Run Expectancy database: There may be easier or better ways to

unread,

To address Matt's question about a Run Expectancy database: There may be easier or better ways to

4/10/13

Search

Clear search

Close search

Google apps

Main menu