|
||||
|
09-27-2009, 06:38 PM | #1 |
Bat Boy
Join Date: Sep 2009
Posts: 2
|
Minor League Statistics - Spritze
Back in September 2006 Spritze announced a database of of actual (non-MLE) statistics of MLB players who debuted between 1948-1973 with some Japanese and Negro League players also. I have been unable to locate the correct file on a working website. All the files that I have been able to find and download contain translated statistics instead of the original stats. Does anyone know where this database may be obtained?
|
09-27-2009, 08:56 PM | #2 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Quote:
|
|
09-27-2009, 09:24 PM | #3 |
Bat Boy
Join Date: Sep 2009
Posts: 2
|
Is the data still online somewhere? Everything that I tried had the translated stats. If it is could you post a link?
If not, are you are willing to (re-)share this data? If so I'm obviously interested and would definitely be appreciative of it being emailed to me. Or if others are still interested in it perhaps it could be re-posted? |
09-27-2009, 10:10 PM | #4 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Sorry. I had to rush off there...........
Yes this data is available. It has never been posted because no one was interested. I added every Japan league player into the db, that added about 6,000 players so now the db contains around 23,084 players and 97,551 minor league or japanese or mexican or cuban or negro league seasons. Keep in mind that none, zip, zero, nil, nada of the data will import into OOTP without changing league and team ID's. I'll send it to PadresFans site for postering in a day or three, as soon as I get home. I'm in NYC visiting my granddaughter the next couple of days. Gonna see "Wicked" too. Last edited by Spritze; 09-27-2009 at 10:14 PM. |
09-28-2009, 04:41 PM | #5 |
Hall Of Famer
Join Date: May 2007
Location: Hucknall, Notts, UK
Posts: 4,902
|
How difficult would it be for Markus to support these kind of databases in say OOTP11? I can't see how it would be a huge amount of work if they are in a similar format to the Lahamn database.
|
09-28-2009, 05:40 PM | #6 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Quote:
If the original assumptions made during the design phase of a program do not allow for the addition of unknown future data it is generally not programming time efficient to replace them unless the code is written in discrete self contained chunks that can be removed and rewritten as a whole. That is generally why programs need a complete rewrite every 5 years or so. Things change. |
|
09-28-2009, 05:57 PM | #7 | |
Hall Of Famer
Join Date: May 2007
Location: Hucknall, Notts, UK
Posts: 4,902
|
Quote:
|
|
09-28-2009, 06:01 PM | #8 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
It is in the Lahman format exactly. Only the team and league abbreviations are different. That may be enough to confuse the import system. I believe in that case all the players are put into the free agent pile.
Besides when one is deciding if something is a lot of work or a little work, if you ain't doing it you don't get a vote. Last edited by Spritze; 09-28-2009 at 06:04 PM. |
09-28-2009, 06:32 PM | #9 | |
Hall Of Famer
Join Date: May 2007
Location: Hucknall, Notts, UK
Posts: 4,902
|
Quote:
Well yeah, that is very true. |
|
09-30-2009, 04:46 PM | #10 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
I created the CSV files this morning from the database.
If you try to open these CSV's with a spreadsheet most of the files will truncate as there are too many rows for a spreadsheet to handle so it is best to import them into a database of your choice before fiddling around with them. I will zip them up later today and send them to Ms. Padre tomorrow. Atchelly sent them today. Watch 4 it. Last edited by Spritze; 09-30-2009 at 08:31 PM. |
10-04-2009, 02:23 PM | #11 |
All Star Reserve
Join Date: Mar 2003
Location: Michigan
Posts: 555
|
Wasn't that a dance in the 60's....."The Atchelly"
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel |
10-06-2009, 12:47 AM | #12 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Spritze DB 10.4 Finished
I will send this db to Padre in the AM. Tested with latest version of OOTPx(the one that has not seen the light of day yet). Includes nearly every Japanese League player ever as well as the usual Negro, minor league and other stars. Players are set to be on the team they are most associated with, Ruth will be a Yankee and not a RedSoxian with this db.
I am going to send forth another db in a week or so with everyone set to be in whichever organization they actually were in that year. It will be exactly the same as this one but the organization a player was in will be historically accurate. This will make most players enter as free agents as that is what nearly everyone was before the draft was instigated in the 1960's. This db has gap seasons filled in and where I have not gotten to a players minor league record yet a place-holder record exists that takes the players actual major league record and runs it through a few hoops to get an age appropriate approximation. All players 1943-1974 have their actual minor league records converted to neutralized MLE's for inclusion in this db. With this number of players available I find the minor leagues in OOTP endlessly fascinating. Year NumberOfAvailablePlayers 1871 250 1872 292 1873 350 1874 427 1875 501 1876 556 1877 634 1878 707 1879 786 1880 852 1881 929 1882 1029 1883 1166 1884 1249 1885 1327 1886 1386 1887 1435 1888 1496 1889 1561 1890 1575 1891 1573 1892 1571 1893 1620 1894 1638 1895 1668 1896 1678 1897 1695 1898 1699 1899 1706 1900 1661 1901 1677 1902 1685 1903 1748 1904 1783 1905 1817 1906 1860 1907 1949 1908 2034 1909 2131 1910 2195 1911 2255 1912 2317 1913 2377 1914 2429 1915 2456 1916 2485 1917 2484 1918 2523 1919 2543 1920 2523 1921 2519 1922 2502 1923 2471 1924 2444 1925 2425 1926 2370 1927 2327 1928 2269 1929 2218 1930 2170 1931 2171 1932 2180 1933 2183 1934 2261 1935 2306 1936 2409 1937 2511 1938 2602 1939 2688 1940 2753 1941 2818 1942 2880 1943 2967 1944 3070 1945 3142 1946 3145 1947 3161 1948 3158 1949 3206 1950 3255 1951 3232 1952 3254 1953 3264 1954 3286 1955 3296 1956 3284 1957 3287 1958 3234 1959 3228 1960 3225 1961 3262 1962 3296 1963 3350 1964 3395 1965 3490 1966 3546 1967 3586 1968 3610 1969 3630 1970 3625 1971 3585 1972 3569 1973 3561 1974 3555 1975 3594 1976 3611 1977 3603 1978 3614 1979 3669 1980 3654 1981 3684 1982 3715 1983 3734 1984 3766 1985 3784 1986 3834 1987 3882 1988 3952 1989 3978 1990 4061 1991 4119 1992 4163 1993 4214 1994 4291 1995 4362 1996 4399 1997 4461 1998 4507 1999 4510 2000 4525 2001 4484 2002 4440 2003 4309 2004 4136 2005 3890 2006 3647 2007 3361 2008 3093 2009 2673 |
10-07-2009, 01:37 AM | #13 |
All Star Reserve
Join Date: Apr 2009
Posts: 648
|
A naive question because I'm naive about these database sorts of things:
If you used your data base but began with an inaugural draft and had the new players enter the amateur draft instead of being assigned to their original teams, would it work like the historical database included with OOTP? Let me know if that was confusingly worded. Thanks. I'm longing to play the 30's and 40's with Major Leaguers and Negro Leaguers available for integrated teams. |
10-07-2009, 08:08 PM | #14 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Yes thou mayest use this db like that.
In factoid I personally use this db that way sometimes and actually tested it under that scenario scenariotestwiseificationally. I made up that last word so don't try and look it up in your Wikipedia yet but it still is a "true dat" thing. Last edited by Spritze; 10-08-2009 at 12:14 AM. |
10-08-2009, 12:20 AM | #15 |
Moderator
Join Date: Aug 2008
Posts: 3,109
|
So, am I reading this correctinfactually? As in starting a league in a certain year and having the players where they were historicalectionally where they were that year?
|
10-08-2009, 03:22 AM | #16 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Yes
and that is two more words in my quest to add 10,000 meaningless new words to the English language via Wikipedia! |
10-08-2009, 01:17 PM | #17 | |
Moderator
Join Date: Aug 2008
Posts: 3,109
|
Quote:
Or is this, auf Deutsch, just a smokescreen for the Final Solution to the English Language Problem, via the concatenation of otherwise innocent syllables into meaninglessthoughlengthy gibberish? Ja oder Nein? |
|
10-08-2009, 03:30 PM | #18 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
"coalstonewcastlebringing" makes perfect sense to me.
Not meaningless and not gibberesh but if one has English as a second language it could be problematical. I am not sure a Canadian would understand it, eh. Besides I really like the country full of convicted cats in concatanation. How about we give a meaning to ohohteapeterism? "The school of thought promulgated by the nerdiforus (A.K.A. Markusians)......." Perhaps if this became part of the language via Wikipedia sales could increase? Schools of thought need texts and adherents and martyrs and can be taught as a college course. All of which would get the word out. Maybe some wack job Hollywood folk would come on board as well. OOTP splashed all over Entertainment Tonight might be a good sales tool. I'm just sayin'........ Thinking outside the box is what it is............ Last edited by Spritze; 10-08-2009 at 03:31 PM. |
10-08-2009, 03:57 PM | #19 |
Moderator
Join Date: Aug 2008
Posts: 3,109
|
Ah, I should have guessed that this was just some avenueofmadisonistic ploy aimed at sordid commercial gain!
But think of all those innocent syllables, herded into experimental linguistic cages like so many labratikins! Worse yet, think of their children! It makes me want to Besides, don't you just hate getting all those little red, dotted lines under half the words you type?? (though, curiously enough, fewer than one might think ) |
10-09-2009, 01:37 PM | #20 |
All Star Starter
Join Date: Dec 2002
Posts: 1,320
|
Wow! Thanks for the effort, I truly appreciate the enhancement to this addiction we share.
Any chance these dbs will be included in the new patch? If not, where would I find them and can you provide a step-by-step guide for adding them into the game for those of us who remain crushingly computer illiterate? |
Bookmarks |
Thread Tools | |
|
|