alternate headline: man does job
fun with data
Does anyone know a good free source for downloading box score data? Primarily interested in this year's games, but somewhat interested in previous years as well. I'm looking to put together some statistical summaries of B1G games and would love to not have to enter data by hand if it's already out there (and free).
Thanks and Go Blue!
Now that we're seriously into the season, I thought it might be time to see how we're doing as compared to last year. Some people around here like tables (called "charts"), but methinks charts are hard to read. In fact, that's why last year I started plotting the Hennegraphs and other related graphical views of data B. Cook has put together.
And hence, a graph of some key offensive statistics across the first ten games of the year, for both 2009 and 2010:
Click here for the full-sized graph, which is much easier to read.
The graph plots a number of statistics across each game of the season. On the left are all the number for 2009, and on the right the numbers for 2010. The bottom-most graph shows points scored in each game; the next graph up shows point differential (how many points we scored minus how many points the opposition scored); a similar set of graphs for how many yards our offense accumulated and yard differential (yards gained minus yards given up) are shown above those.
I also took some liberty of moving the 2009 Delaware St. game to before the Big Ten Season so that the comparable games are in the same part of the season.
These graphs I believe allow one to make a few observations about how much the team has progressed since last season. And so I do:
- In 2009, we were outgained in yardage, often significantly, in virtually every game against serious competition (the Big Ten team and Notre Dame). I think it is reasonable to make the case, and the record indeed shows, that we were just a bad Big Ten team.
- In 2010, there is only one game like this: the MSU game. We have thus made a jump, at least to the middle of the pack, and possible higher (which the next two weeks will play a significant role in determining).
- In 2009, a number of Big Ten games were quite close despite the yardage differentials. Is this a testimony to the fact that the team is actually pretty tough mentally, never quitting in games even though they were getting pushed around? It is pretty amazing how close the team was to having a pretty good seasonin 2009.
- In 2010, in many ways our record is worse than our yardage numbers. This has a lot to do with turnovers undoubtedly, and is a great sign for the 2011 season.
- Your observations go here.
A lot of this is well known and obvious for those who follow the team (i.e. mgoblog fanatics like myself), but I thought the visualization was a nice way to see the differences between 2009 and 2010. Certainly, it can be shown to any idiot who claims we haven't made much progress.
Enjoy! And please do suggest other items to include on said graphs; it is not hard to scrape the data from the espn box scores.
Not that this couldn't have been done by everyone else, but I figure this might be of some use to the board. I took that database mentioned in UV today as found here:
And google doc'd it so I could give it out and do some easy sorting. If you want to check it out yourself, here's the link:
In case you were wondering, here's the top 25:
|University||Total Subsidy, 2005||Total Subsidy, 2008||Total Operating Revenue, 2008||Subsidy as % of 2008||Total Operating Expenses, 2008||Profit/loss, pre-subsidy||Profit/loss, counting subsidy|
|U. of Michigan||0||58817||99027105||0.06%||85496004||13531101||13472284|
|U. of Kansas||3186282||3893956||82976047||4.69%||65748366||17227681||13333725|
|Texas A&M U.||839348||3264000||92476146||3.53%||77426317||15049829||11785829|
|U. of Georgia||3028878||3073606||85554395||3.59%||71993533||13560862||10487256|
|U. of Iowa||3632198||2287795||81515865||2.81%||71602594||9913271||7625476|
|U. of Texas at Austin||3027310||1832229||120288370||1.52%||110996365||9292005||7459776|
|Kansas State U.||2949040||3189559||49113706||6.49%||41362747||7750959||4561400|
|Oklahoma State U.||4174287||4644017||98874092||4.7%||89801118||9072974||4428957|
|Louisiana State U.||0||0||85018205||0%||81150829||3867376||3867376|
|U. of Florida||3753327||4431187||106607895||4.16%||98775583||7832312||3401125|
|West Virginia U.||2780626||3652315||54262716||6.73%||49052709||5210007||1557692|
|Ohio State U.||5429||0||115737022||0%||114264848||1472174||1472174|
|Florida State U.||4796773||6590629||73458494||8.97%||65583105||7875389||1284760|
|U. of Nebraska at Lincoln||0||0||75492884||0%||74981110||511774||511774|
|U. of Illinois||4708707||4202696||67818403||6.2%||63458807||4359596||156900|
|U. of Kentucky||639686||568996||71727243||0.79%||71079982||647261||78265|
|U. of South Carolina||854387||1987931||66545953||2.99%||64516437||2029516||41585|
|U. of Arkansas at Fayetteville||1429833||1518452||66174916||2.29%||64632499||1542417||23965|
|U. of Oklahoma||150000||150000||77098008||0.19%||76945882||152126||2126|
|U. of Oregon||1369845||1168411||56623901||2.06%||56259942||363959||-804452|
And here's the bottom 25:
|Eastern Michigan U.||17135653||21396376||24971850||85.68%||25153393||-181543||-21577919|
|New Mexico State U.||8074837||16103229||25379586||63.45%||28298002||-2918416||-19021645|
|U. of Nevada at Las Vegas||9596488||19044324||38377947||49.62%||37934266||443681||-18600643|
|U. of Central Florida||13756337||18676064||39715730||47.02%||38825507||890223||-17785841|
|U. of Houston||12437318||17547745||30988450||56.63%||30988450||0||-17547745|
|U.S. Air Force Academy||8417045||16579598||30604249||54.17%||31174646||-570397||-17149995|
|State U. of New York at Buffalo||14397205||17001122||21859641||77.77%||21854374||5267||-16995855|
|Miami U. (Ohio)||14462096||16665051||23307295||71.5%||23320946||-13651||-16678702|
|San Diego State U.||11161382||16874292||32118251||52.54%||31405858||712393||-16161899|
|Western Michigan U.||14201835||15478356||21990723||70.39%||21635009||355714||-15122642|
|U. of Cincinnati||5642852||10699504||32281546||33.14%||36369715||-4088169||-14787673|
|Middle Tennessee State U.||11386377||14737696||19656265||74.98%||19656265||0||-14737696|
|Northern Illinois U.||10634413||15435450||23342006||66.13%||22448970||893036||-14542414|
|Central Michigan U.||11841935||13824715||21103460||65.51%||21636204||-532744||-14357459|
|Kent State U.||12373580||13384016||18106791||73.92%||18891134||-784343||-14168359|
|U. of Akron||10272310||13813933||18711948||73.82%||18858092||-146144||-13960077|
|Florida International U.||12131586||15691580||20230654||77.56%||18475489||1755165||-13936415|
|Western Kentucky U.||10047994||13704025||19957909||68.66%||19957909||0||-13704025|
|U. of Wyoming||10638025||13233339||24547609||53.91%||24876915||-329306||-13562645|
|U. of Virginia||7973032||11119358||64396612||17.27%||65838543||-1441931||-12561289|
|U. of New Mexico||8107987||12010006||35979959||33.38%||36477159||-497200||-12507206|
|U. of Tennessee||7546536||13382629||101806196||13.15%||100507146||1299050||-12083579|
|U. of Texas at El Paso||10759894||11375111||25269243||45.02%||25707421||-438178||-11813289|
Should we maybe look skeptically on the idea of adding Rutgers to the Big 10? Maybe? And that was 6 of 11 programs in the big 10 in the top 25 (aka "profitable") in 2008, with 0 in the bottom 25.