We're going to need to have an entry in our database for each of the 30 teams. This will allow our "Years" page to link to individual team years in "Team" pages for all of the teams.
It also allows for those standings to be a ForeignKey in our Models (I think). Which is cleaner than having some nasty list of strings for that field or something.
This is what a team’s data currently looks like:
Name: Minnesota Twins
City: Minneapolis
State: MN
Park: Target Field
Division: AL Central
social media: @Twins
Manager: Ron Gardenhire
[years]:
Year,Lg,W,L,Finish,Playoffs,Attendance,Attend/G,Rank,Est. Payroll
2013,AL Central,66,96,4,,2477644,30588,7th of 15,$63042500
2012,AL Central,66,96,5,,2776354,34276,6th of 14,$99066000
2011,AL Central,63,99,5,,3168116,39113,2nd of 14,$112737000
2010,AL Central,94,68,1,Lost LDS (3-0),3223640,39798,3rd of 14,$97559166
2009,AL Central,87,76,1,Lost LDS (3-0),2416237,29466,5th of 14,$67804266
2008,AL Central,88,75,2,,2302431,28425,8th of 14,$56932766
2007,AL Central,79,83,3,,2296383,28350,9th of 14,$71439500
2006,AL Central,96,66,1,Lost LDS (3-0),2285018,28210,9th of 14,$63396006
2005,AL Central,83,79,3,,2034243,25114,9th of 14,$56186000
2004,AL Central,92,70,1,Lost LDS (3-1),1911490,23599,11th of 14,$53890000
Squab
commented
10 years ago
We're going to need to have an entry in our database for each of the 30 teams. This will allow our "Years" page to link to individual team years in "Team" pages for all of the teams.
It also allows for those standings to be a ForeignKey in our Models (I think). Which is cleaner than having some nasty list of strings for that field or something.
This is what a team’s data currently looks like: Name: Minnesota Twins City: Minneapolis State: MN Park: Target Field Division: AL Central social media: @Twins Manager: Ron Gardenhire
[years]: Year,Lg,W,L,Finish,Playoffs,Attendance,Attend/G,Rank,Est. Payroll 2013,AL Central,66,96,4,,2477644,30588,7th of 15,$63042500 2012,AL Central,66,96,5,,2776354,34276,6th of 14,$99066000 2011,AL Central,63,99,5,,3168116,39113,2nd of 14,$112737000 2010,AL Central,94,68,1,Lost LDS (3-0),3223640,39798,3rd of 14,$97559166 2009,AL Central,87,76,1,Lost LDS (3-0),2416237,29466,5th of 14,$67804266 2008,AL Central,88,75,2,,2302431,28425,8th of 14,$56932766 2007,AL Central,79,83,3,,2296383,28350,9th of 14,$71439500 2006,AL Central,96,66,1,Lost LDS (3-0),2285018,28210,9th of 14,$63396006 2005,AL Central,83,79,3,,2034243,25114,9th of 14,$56186000 2004,AL Central,92,70,1,Lost LDS (3-1),1911490,23599,11th of 14,$53890000
Everything except for years is manually gathered. The Years data is generated from this page: http://www.baseball-reference.com/teams/MIN/attend.shtml Using the “Share” Function on that table.
So the rest of the teams need to be added to the Raw Data doc at some point. But this probably isn't something to worry about for idb1.