GuidoSarducci

Yeah the final product uses SQL backend. (SQLite at the moment) . The idea is the user wouldn't have to mess with that, although some concepts such as grouping and aggregations map nearly 1-1 with SQL concepts, you just click/select what you want, and with some experimenting it should become apparent what was going on (I hope) Still more work to be done on the team stats, I could add more filter types, allow, custom stats, etc. but right now I find working on the event files more interesting. Like I would want to see all at-bats Babe Ruth had vs. Walter Johnson, something like that. There are resources like Chadwick and Boxball, might be faster to get certain things but I thought it would be fun to process the raw data myself, as well as have max flexibility to extract what I want

Little update because I got at least some interest. I have been working on the Retrosheet event files, which give a play-by-play account of games to varying degrees. From these you can reconstruct quite a bit, obviously the further you go back the less quality it is and (e..g, you don't get pitch data until ~1990). Anyway I am now giving all games a uniquely generated ID, to simply the DB operations. Testing my play-by-play processor, and it turns out that game 100,000 was played between Baltimore and Boston on September 6th, 1963. I am generating that looks like this: applyPlay B1 BOS 1 BAL 0 2 outs BAL poweb101 at bat BOS monbb101 pitching onBase: 1: 2: 3: play= D/78 double play runs= 0 outs= 0 applyPlay B1 BOS 1 BAL 0 2 outs BAL gentj101 at bat BOS monbb101 pitching onBase: 1: 2: poweb101 3: play= W walk runner on 2 does not advance play runs= 0 outs= 0 applyPlay B1 BOS 1 BAL 0 2 outs BAL branj101 at bat BOS monbb101 pitching onBase: 1: gentj101 2: poweb101 3: play= HR.2-H;1-H home run runner on 2 ( poweb101 ) scored runner on 1 ( gentj101 ) scored basesAdv= {1, 2} play runs= 3 outs= 0 The "play" line is what I'm getting from Retrosheet, from there I have to infer just about everything else. (It does have inning and batter info, but I also keep track of this internally and verify I am doing the right thing, so like it says a certain batter is up, I check to see if they were next in the order) Anyway parsing some of these "play" lines can be quite challening... this particularly game I think everything was the same as Baseball reference (I summarize at the end), except like one catcher assist was credited as a putout.

22nd in Ks, 9th in OPS, so no.

Yeah I just tried. Works but a bit ugly . Guess I need more experience with Bootstrap

Yeah I think maybe I should add a client-side sortable table. Right now it just dumps into a standard HTML table. You can select the ordering as part of the query, which is important for things like "worst pitching performances in the entire history of the MLB", but for just reordering what you have on screen, would be mucher nicer. The eventual goal is to run queries where you could find out exactly something like that. Need to process the event files for things that, then come up with usable interface. The boxscores alone have been a handful, but I'll probably reach reach a point where I can't get much interesting data from them aside from some historical records. At one point durijng the early Hyde years I was seriously wondering whether Chris Holt's mound visits were actually making things worse .. would be great if there some stats to back that up. Now to answer the records question : unfortunately the "Parks" feature seems to be broken but running a manual query on my local db, he Orioles in Fenway against the Red Sox were 14-12 from 2012 to 2022 which is when my data ends ... lost two last year (including infamous Ryan McKenna game). Incuding the sweep we're head 17-14 (since 2012, in Fenway, in April )

I'll have to find some horrible records about the Red Sox or Fenway. Gave me an idea for query .. all games the Orioels have played in Fewnay in April .over the last ten years or so

http://switchfielder.com/baseball/ The idea is to be able to run fairly arbitrary queries against data, not just set stuff like leaderboards/etc.. So you can find info like "What have been the worst pitching performances by a team in a given month over the last ten years" (sadly the O's own two of the top ten positions Only boxscore data available now, and its still kinda barebones. And its more of a learning /exploratory project. Some of the queries may not work or make sense. If interested let me know what you think.

Knowing Boras he's probably going to want like 9/180

Today's result has no bearing on my concern for the pitching. And Fenway. Strange things happen Starting pitching and bullpen depth past the top three (two with Bautista out) has always the obvious concern. Playoffs are a crapshoot and having at least two dominant starters is the way most teams make it deep. Maybe we have those guys, maybe we don't. Its very hard to say. We don't have anyone with a history of being dominant, except Means and he will be coming back from injury. Bradish has put up near Cy Young numbers but this is first breakout year. Those two plus strong performances from Cano/Coulombe/Bautista might allow us to make a legit run.

Because MLB batters are used to seeing 80 mph pitches. When you throw them a 50 mph eephus, it throw off their timing.

I think they should play "Wild Thing" when he comes out of the bullpen ..

I think McCann told Fujinami to just aim for the middle ...

We will not pony up the ~$500m it takes to sign Ohtani, even if he wanted to be here (I don't think he does) Yes, our payroll is low ($91 million, including all deferred/retained money) My guess is our ultimate payroll cap is roughly around $150m max. The picture doesn't look better next year, alot of those guys will be FA (which has positives and negative, but its roughly even) or will get raises in arbitration. So Ohtani would burn through pretty much all of our remaining payroll space were we to sign him. If we were to somehow sign Ohtani , we are basically saying that we're aren't planning on signing anyone of any significance for the next 7-8 years, including Adley, Gunnar, etc. Basically we will be the Angels within 2-3 years, if we're lucky. More likely we would be significantly below .500, and with a relatively high payroll without much flexibility, virtually guaranteeing the suck would continue for another 5 years after that.

We call up Kjerstaad probably

Where's the fun in that