Database of transactions by day

ctorg · 01-09-2011, 05:44 PM

Hey all.

I'm looking to find a database that has all major league transactions for all seasons going back as far as possible. I can find websites that seem to access such a database, but I'm looking to get a hold of an actual database (or something I could easily make into one - hopefully something downloadable.

I have this idea that I may want to recreate history including trades, signings, etc. on appropriate dates. I don't know if I'll really go through with it, but getting a database would be a first step.

Anyone know where I could get this?

Chicagofan76 · 01-09-2011, 06:08 PM

I couldnt find anythign on Google for ya best i found is u can do yearly on Baseball ref.

heres some for the White Sox

1963 Chicago White Sox Trades and Transactions - Baseball-Reference.com

ctorg · 01-09-2011, 06:15 PM

I actually just found what I was looking for at retrosheet. For some reason I couldn't find it before. They actually have a downloadable zip with every transaction listed. I couldn't have asked for anything better.

Charlie Hough · 01-10-2011, 09:41 AM

Just be aware that the Retrosheet data are not complete. There are still many transactions that remain unknown and unreported.

ctorg · 01-10-2011, 09:57 AM

Yeah, thanks. I figure they've probably got the most exhaustive list, though.

Looking it over, I'm not sure I want to undertake this after all. I mean, there are over 60,000 transactions there. Even when I filter out the ones that would be irrelevant in OOTP, like amateur draft signings, I still see around 50,000. I think that's a bit much to keep up with for me. It would be cool to be able to have OOTP read the file and make the appropriate transactions, though it's not exactly a priority.

BaseballMan · 01-10-2011, 02:29 PM

Before I accidentally formatted my hard drive I had something like that. I also had a retire and unretire list cause some players retire and unretire. So I'm gonna redo it. I will make a spreadsheet and match the players games played to that teams schedule if there is no historical trade date. If the player isn't traded then I will just mark him has released. I am also gonna redo my retiregunretire list.

Charlie Hough · 01-10-2011, 03:47 PM

Quote:

Originally Posted by ctorg

It would be cool to be able to have OOTP read the file and make the appropriate transactions, though it's not exactly a priority.

This has been proposed on a number of occasions. It may ultimately come down to whether OOTP Developments considers it acceptable to use a data source that is only partially correct.

BaseballMan · 01-10-2011, 05:29 PM

Yeah but they use a modified database for historical
replay in cases where there is no data. So why not just add it
as an optional database? I'm sure people are not gonna go crazy over
2 mistakes but its better than doing it manually and would make
The game more enjoyable for historical simmers.

ctorg · 01-10-2011, 06:12 PM

Yeah, it's fine if it's inexact. It could work in conjunction with the Lahman database by refreshing the rosters each season - i.e., if there's a record of a guy playing for Team X in year 1 and Team Y in year 2, but there's nothing about it in the transaction file, the game could move the guy automatically and maybe just record it as "[player] moved from Team X to Team Y".

BaseballMan · 01-10-2011, 07:33 PM

Does the game recognize the AA,UA, etc abbreviations now.
I had database for the rookies for each league. I still haven't got
OOTP 11. Not that I don't want it but I'm stuck with an old system
And I'm slowly building a new one.

pstrickert · 01-10-2011, 07:44 PM

Spritze claims to have a Lahman/OOTP-compatible Transaction.csv.

Spritze · 01-11-2011, 10:31 AM

Here is a sample. It is way to humongous to upload here.

I put the full thing on my ftp site.

Has not been updated for a year or so as there was no interest in it from nobody and I don't use it the way I play da game.

Gambo · 01-11-2011, 12:41 PM

The retrosheet database is actually much more correct than you'd realize, at least in terms of comings and goings as long as you're only focusing on a player's professional debut with a major league organization and then his transactions during his major league career. Where it is lacking is in minor league transactions and post major league transactions.

For when the player is floating around the minors it may be missing a few but if he played in the majors for an organization it has when they went to that organization.

I use this database for doing the opening day team assignments in the Gambo/Spritze database and really have not found that ommision. The transaction database will occasionally have designated "January 1960 Joe Blow goes to Los Angeles Dodgers in an unknown transaction"

pstrickert · 01-11-2011, 01:00 PM

Based on what I've seen, the data is there. Is there enough interest in including it in OOTP12? Would it sell more copies? BTW, as-played lineup files are available, too (at least from 1901).

pstrickert · 01-11-2011, 01:05 PM

Even Puresim has real-life transaction and as-played lineup files. I'd hope to see them in OOTP, too.

ctorg · 01-11-2011, 01:10 PM

If it's not a programming nightmare, I think it could only help bring more people in.

Spritze · 01-11-2011, 02:46 PM

4,517 Major League Players have no entry at all in the transaction database. Is that close enough? About 200 of them are players that debuted in Lahman after the last TranDB Update so they don't count.

Gambo · 01-11-2011, 04:52 PM

Quote:

Originally Posted by Spritze

4,517 Major League Players have no entry at all in the transaction database. Is that close enough? About 200 of them are players that debuted in Lahman after the last TranDB Update so they don't count.

Only 25% that's not too bad.

This is also part of the reason I combine info from the transaction database with your minor league stats when doing my database. It fills in alot of voids and gets me as close to accurate as I can.

ctorg · 01-11-2011, 05:48 PM

Wow, that's a lot of missing transactions.

Is it accurate back to a certain date? I.e., are there players who debuted after, say, 1980 who are not in the transaction DB?

Spritze · 01-11-2011, 06:57 PM

If the average player had 7.51934 transactions in a career that might be 33,965 missing transactions give or take. Of course that 7.51934 number could be suspect itself as I just made it up. Anyway, that could be a bunch of missing transactions that might be missing in a transactional transcendental sense tangentally targeted.

01-09-2011, 05:44 PM	#1
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Database of transactions by day Hey all. I'm looking to find a database that has all major league transactions for all seasons going back as far as possible. I can find websites that seem to access such a database, but I'm looking to get a hold of an actual database (or something I could easily make into one - hopefully something downloadable. I have this idea that I may want to recreate history including trades, signings, etc. on appropriate dates. I don't know if I'll really go through with it, but getting a database would be a first step. Anyone know where I could get this? __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-09-2011, 06:15 PM	#3
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	I actually just found what I was looking for at retrosheet. For some reason I couldn't find it before. They actually have a downloadable zip with every transaction listed. I couldn't have asked for anything better. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-10-2011, 09:57 AM	#5
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Yeah, thanks. I figure they've probably got the most exhaustive list, though. Looking it over, I'm not sure I want to undertake this after all. I mean, there are over 60,000 transactions there. Even when I filter out the ones that would be irrelevant in OOTP, like amateur draft signings, I still see around 50,000. I think that's a bit much to keep up with for me. It would be cool to be able to have OOTP read the file and make the appropriate transactions, though it's not exactly a priority. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-10-2011, 06:12 PM	#9
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Yeah, it's fine if it's inexact. It could work in conjunction with the Lahman database by refreshing the rosters each season - i.e., if there's a record of a guy playing for Team X in year 1 and Team Y in year 2, but there's nothing about it in the transaction file, the game could move the guy automatically and maybe just record it as "[player] moved from Team X to Team Y". __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-10-2011, 07:44 PM	#11
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 15,733	Spritze claims to have a Lahman/OOTP-compatible Transaction.csv. Last edited by pstrickert; 01-10-2011 at 10:40 PM.

01-09-2011, 06:08 PM	#2
Chicagofan76 Banned Join Date: Oct 2009 Location: Diamond, IL Posts: 6,339 Infractions: 2/2 (3)	I couldnt find anythign on Google for ya best i found is u can do yearly on Baseball ref. heres some for the White Sox 1963 Chicago White Sox Trades and Transactions - Baseball-Reference.com

01-10-2011, 09:41 AM	#4
Charlie Hough Hall Of Famer Join Date: May 2006 Posts: 3,625	Just be aware that the Retrosheet data are not complete. There are still many transactions that remain unknown and unreported.

01-10-2011, 02:29 PM	#6
BaseballMan Hall Of Famer Join Date: Jan 2002 Posts: 6,266	Before I accidentally formatted my hard drive I had something like that. I also had a retire and unretire list cause some players retire and unretire. So I'm gonna redo it. I will make a spreadsheet and match the players games played to that teams schedule if there is no historical trade date. If the player isn't traded then I will just mark him has released. I am also gonna redo my retiregunretire list.

01-10-2011, 05:29 PM	#8
BaseballMan Hall Of Famer Join Date: Jan 2002 Posts: 6,266	Yeah but they use a modified database for historical replay in cases where there is no data. So why not just add it as an optional database? I'm sure people are not gonna go crazy over 2 mistakes but its better than doing it manually and would make The game more enjoyable for historical simmers.

01-10-2011, 07:33 PM	#10
BaseballMan Hall Of Famer Join Date: Jan 2002 Posts: 6,266	Does the game recognize the AA,UA, etc abbreviations now. I had database for the rookies for each league. I still haven't got OOTP 11. Not that I don't want it but I'm stuck with an old system And I'm slowly building a new one.

01-11-2011, 12:41 PM	#13
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	The retrosheet database is actually much more correct than you'd realize, at least in terms of comings and goings as long as you're only focusing on a player's professional debut with a major league organization and then his transactions during his major league career. Where it is lacking is in minor league transactions and post major league transactions. For when the player is floating around the minors it may be missing a few but if he played in the majors for an organization it has when they went to that organization. I use this database for doing the opening day team assignments in the Gambo/Spritze database and really have not found that ommision. The transaction database will occasionally have designated "January 1960 Joe Blow goes to Los Angeles Dodgers in an unknown transaction" __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com

01-11-2011, 01:00 PM	#14
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 15,733	Based on what I've seen, the data is there. Is there enough interest in including it in OOTP12? Would it sell more copies? BTW, as-played lineup files are available, too (at least from 1901).

01-11-2011, 01:05 PM	#15
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 15,733	Even Puresim has real-life transaction and as-played lineup files. I'd hope to see them in OOTP, too.

01-11-2011, 01:10 PM	#16
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	If it's not a programming nightmare, I think it could only help bring more people in. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-11-2011, 02:46 PM	#17
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	4,517 Major League Players have no entry at all in the transaction database. Is that close enough? About 200 of them are players that debuted in Lahman after the last TranDB Update so they don't count.

01-11-2011, 05:48 PM	#19
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Wow, that's a lot of missing transactions. Is it accurate back to a certain date? I.e., are there players who debuted after, say, 1980 who are not in the transaction DB? __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

01-11-2011, 06:57 PM	#20
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	If the average player had 7.51934 transactions in a career that might be 33,965 missing transactions give or take. Of course that 7.51934 number could be suspect itself as I just made it up. Anyway, that could be a bunch of missing transactions that might be missing in a transactional transcendental sense tangentally targeted.