Sortable Team Stats By Date

[Tyrus4189Cobb]

Sorry to bother everyone again, but I'm in a pickle. Is there any way to sort and see team stats by date on BBRef or any other site? For example, is it possible to see the team stats from the season start to June 22nd, 2010? I'm trying to find a simple way to sort the amount of runs scored by a team on any given date in order to group them into tiers. BBRef lets you see the teams' rank in runs, etc. for the whole season. I'd like to be able to see it on any given date. I'll make numbers up to further illustrate:

Opening day-June 1st, 2005
Team A- 180 runs, 165 ER}
Team B- 178 runs, 166 ER} top tier
Team C- 164 runs, 152 ER}
Team D- 160 runs, 153 ER} middle tier
Team E- 155 runs, 141 ER}
Team F- 150 runs, 137 ER} lower tier

Opening day-July 9th, 2005
Team B- 233 runs, 216 ER}
Team A- 222 runs, 214 ER} upper tier
Team E- 216 runs, 201 ER}
Team C- 210 runs, 196 ER} middle tier
Team D- 201 runs, 184 ER}
Team F- 199 runs, 182 ER} lower tier

[Ben Grimm]

Click on a team. Click on Schedule and Results. Click on date down the list you're looking for (next to the boxscore).

Is that what you mean?

[drstrangelove]

I don't know which page you are using, so I'll give a general answer.

1) BBRef typically creates data in some format for presentation. In their case, you'll note that many 'tables' have a CSV code (among other codes) at the top of the table. That code will convert the data into a delimited file that you can copy and paste into a spreadsheet where you can easily summarize and manipulate it. This will require using a delimited text to column conversion tool (for example excel does this), or some other method.

here's an example:

Rk,Gm#,Date,,Tm,,Opp,,R,RA,Inn,W-L,Rank,GB,Win,Loss,Save,Time,D/N,Attendance,Streak
1,1,Friday Apr 6,boxscore,ARI,,SFG,W,5,4,,1-0,2,0.5,Kennedy,Lincecum,Putz,2:53,D,49130,+
2,2,Saturday Apr 7,boxscore,ARI,,SFG,W,5,4,,2-0,2,0.5,Hudson,Bumgarner,Putz,2:36,D,34789,++
3,3,Sunday Apr 8,boxscore,ARI,,SFG,W,7,6,,3-0,1,up 0.5,Miley,Affeldt,Shaw,3:08,D,24193,+++
4,4,Tuesday Apr 10,boxscore,ARI,@,SDP,W,4,2,11,4-0,1,up 0.5,Breslow,Owings,Putz,3:28,N,18652,++++
5,5,Wednesday Apr 11,boxscore,ARI,@,SDP,L,1,2,,4-1,2,0.5,Frieri,Hernandez,Street,2:58,D,16091,-
6,6,Thursday Apr 12,boxscore,ARI,@,SDP,W,3,1,,5-1,2,0.5,Kennedy,Owings,Putz,3:02,N,20858,+
7,7,Friday Apr 13,boxscore,ARI,@,COL,L,6,7,,5-2,2,1.5,Brothers,Shaw,Betancourt,3:39,N,30642,-
8,8,Saturday Apr 14,boxscore,ARI,@,COL,L,7,8,,5-3,2,2.5,Chatwood,Putz,,3:19,N,29856,--
9,9,Sunday Apr 15,boxscore,ARI,@,COL,W,5,2,,6-3,2,2.5,Cahill,Pomeranz,Shaw,3:19,D,26952,+
10,10,Monday Apr 16,boxscore,ARI,,PIT,W,5,1,,7-3,2,2.0,Saunders,Bedard,,2:42,N,17366,++
11,11,Tuesday Apr 17,boxscore,ARI,,PIT,L,4,5,,7-4,2,2.0,Grilli,Shaw,Cruz,3:01,N,19198,-
12,12,Wednesday Apr 18,boxscore,ARI,,PIT,L,1,2,,7-5,2,2.0,Lincoln,Hudson,Cruz,2:49,D,18368,--
13,13,Thursday Apr 19,boxscore,ARI,,ATL,L,2,10,,7-6,2,3.0,Minor,Collmenter,,2:49,N,18110,---
14,14,Friday Apr 20,boxscore,ARI,,ATL,L,1,9,,7-7,4,4.0,Beachy,Cahill,,2:50,N,27761,----
15,15,Saturday Apr 21,boxscore,ARI,,ATL,L,2,3,,7-8,4,5.0,Hanson,Saunders,Kimbrel,2:17,N,30188,-----
16,16,Sunday Apr 22,boxscore,ARI,,ATL,W,6,4,,8-8,3,4.0,Kennedy,Delgado,Putz,2:36,D,28679,+
17,17,Monday Apr 23,boxscore,ARI,,PHI,W,9,5,,9-8,3,4.0,Miley,Kendrick,,2:36,N,21195,++
18,18,Tuesday Apr 24,boxscore,ARI,,PHI,L,5,8,,9-9,3,4.0,Worley,Collmenter,Papelbon,2:45,N,24213,-
19,19,Wednesday Apr 25,boxscore,ARI,,PHI,L,2,7,,9-10,4,4.0,Hamels,Cahill,,2:41,D,25934,--
20,20,Friday Apr 27,boxscore,ARI,@,MIA,W,5,0,,10-10,3,4.0,Saunders,Zambrano,,2:56,N,31949,+
21,21,Saturday Apr 28,boxscore,ARI,@,MIA,L,2,3,,10-11,4,5.0,Cishek,Ziegler,,2:51,N,33525,-
22,22,Sunday Apr 29,boxscore,ARI,@,MIA,W,8,4,,11-11,3,5.0,Miley,Johnson,,3:14,D,34918,+

Some websites like Retrosheet let you download whole files, so the copy and paste method is not needed.


2) Using dates can be an issue depending upon how the dates are formatted by the creator. You might be able to use them as is, but in some cases you will find that the dates need to be concatenated before they can be used. (e.g., the date may be displayed as 4/15/08, but it's really '4' '/' '15' '/' '08', so 5 pieces, not 1. Sorting is much easier if it's reconfigured as 1 piece, and setting date ranges is much, much easier as well.)

If you are looking for a lot of data, I'd spend time looking around for it before using the copy and paste method. It's really tedious, and I think is worth avoiding, but for some small or unusual searches it's pretty quick and dirty, so can be okay.

[Tyrus4189Cobb]

I appreciate the help

[Ben Grimm]

This is what I came up with >>here<< to give standings/team general stats for the 22nd. I'm not sure if you're looking to go deeper than that, and if so, I'm not sure how to get there.

[Tyrus4189Cobb]

This is what I came up with >>here<< to give standings/team general stats for the 22nd. I'm not sure if you're looking to go deeper than that, and if so, I'm not sure how to get there.

This is similar to what I need. I don't need the scores on any day. I am looking for the runs and earned runs of the teams. This page has the teams' wins and losses up to that day. I need the teams' runs and earned runs up to that day

[scorekeeper]

…I'm trying to find a simple way to sort the amount of runs scored by a team on any given date in order to group them into tiers. …

Don’t mean to confuse the issue, but what’s your purpose in looking at E/ER in terms of tiers? I was kind of expecting you to want to see errors and total chances in there too.

[Tyrus4189Cobb]

Don’t mean to confuse the issue, but what’s your purpose in looking at E/ER in terms of tiers? I was kind of expecting you to want to see errors and total chances in there too.

I've been working on a statistic to measure starting pitchers' starts in terms of the strength of the teams they faced. Lower tiers cause more point loss than higher ones. Allowing 4 earned runs to the Yankees is better than allowing 4 to the Twins.

[JDanger]

I've been working on a statistic to measure starting pitchers' starts in terms of the strength of the teams they faced. Lower tiers cause more point loss than higher ones. Allowing 4 earned runs to the Yankees is better than allowing 4 to the Twins.

BP has an opponent OPS or oppOPS for this sort of thing. Charlie Morton currently has the highest oppOPS (.783) in the majors minimum 50 IP.

[scorekeeper]

I've been working on a statistic to measure starting pitchers' starts in terms of the strength of the teams they faced. Lower tiers cause more point loss than higher ones. Allowing 4 earned runs to the Yankees is better than allowing 4 to the Twins.

K.

But I’d suggest to add a couple other things into the mix, just for the sake of precision. The second someone talks about ERs vs Runs with the perspective of evaluating those numbers to compare pitchers, the 1st thing I like to know is, how many of those R/ERs were directly attributed to something the pitcher did, all by his lonesome, and had nothing to do with his defense.

To me that means tracking walks, HBPs, WPs that led directly to runs, and errors by the pitcher that led directly to runs, and then adjusting the ERs accordingly. To me, those things are all pitcher “mistakes”, and have to be directly attributable to him no matter what.

[Tyrus4189Cobb]

I'm actually not going to bother with that. My stat is taking long enough as is because I'm only one person poring over a lot of data from BBRef. I think people can add the appropriate adjustments for defense behind the pitcher.

[Anachron]

For detailed batting or pitching stats for a team over a specific time period, click Batting [+] or Pitching [+], then choose Game Logs. Click the desired game number in the Gtm column for season stats thru that game. For a specific range of games, click (somewhere in the center of the page) the first and last rows of the range you want.

Ken

[Tyrus4189Cobb]

For detailed batting or pitching stats for a team over a specific time period, click Batting [+] or Pitching [+], then choose Game Logs. Click the desired game number in the Gtm column for season stats thru that game. For a specific range of games, click (somewhere in the center of the page) the first and last rows of the range you want.

Ken

You sir are a good, good man. What a way to spend your first post!