dbforbes Posted November 8, 2011 Share Posted November 8, 2011 I wasn't sure where to post this, but as it is not a WDIS kind of post, I posted it here. That said, I want to evaluate the difference made in NFL games by a variable I've never seen analyzed before. However, in order to do so, I need to get my hands on some data. Consequently, I was wondering whether anybody could point me to an easy to use data source for the past 10 seasons showing the dates of games; teams involved; which teams were favored; by how much those teams were favored; the per quarter scoring for each game; and the final scores. The results of my research will eventually be disclosed here. Thanks in advance for any help! Quote Link to comment Share on other sites More sharing options...
keggerz Posted November 8, 2011 Share Posted November 8, 2011 I might have that info...have to check Quote Link to comment Share on other sites More sharing options...
keggerz Posted November 8, 2011 Share Posted November 8, 2011 (edited) I have the following info dating back to 1985...not all categories were recorded that far back: Date Season Week Team Opponent HomeOrAway Score OpponentScore TotalScore Stadium * 2001 PlayingSurface Temperature * 2001 Humidity * 2001 WindSpeed * 2001 OverUnder PointSpread ScoreQuarter1 ScoreQuarter2 ScoreQuarter3 ScoreQuarter4 ScoreOvertime TimeOfPosessionMinutes TimeOfPosessionSeconds TimeOfPosession FirstDowns FirstDownsByRushing * 2001 FirstDownsByPassing * 2001 FirstDownsByPenalty * 2001 OffensivePlays OffensiveYards OffensiveYardsPerPlay Touchdowns * 2001 RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns * 2001 PassingAttempts PassingCompletions PassingYards PassingTouchdowns * 2001 PassingInterceptions PassingYardsPerAttempt PassingYardsPerCompletion CompletionPercentage PasserRating * 2001 ThirdDownAttempts * 2001 ThirdDownConversions * 2001 ThirdDownPercentage * 2001 FourthDownAttempts * 2001 FourthDownConversions * 2001 FourthDownPercentage * 2001 RedZoneAttempts * 2001 RedZoneConversions * 2001 GoalToGoAttempts * 2001 GoalToGoConversions * 2001 ReturnYards Penalties PenaltyYards Fumbles FumblesLost TimesSacked TimesSackedYards QuarterbackHits * 2006 TacklesForLoss * 2008 Safeties * 2001 Punts PuntYards PuntAverage Giveaways Takeaways TurnoverDifferential OpponentScoreQuarter1 OpponentScoreQuarter2 OpponentScoreQuarter3 OpponentScoreQuarter4 OpponentScoreOvertime OpponentTimeOfPosessionMinutes OpponentTimeOfPosessionSeconds OpponentTimeOfPosession OpponentFirstDowns OpponentFirstDownsByRushing * 2001 OpponentFirstDownsByPassing * 2001 OpponentFirstDownsByPenalty * 2001 OpponentOffensivePlays OpponentOffensiveYards OpponentOffensiveYardsPerPlay OpponentTouchdowns * 2001 OpponentRushingAttempts OpponentRushingYards OpponentRushingYardsPerAttempt OpponentRushingTouchdowns * 2001 OpponentPassingAttempts OpponentPassingCompletions OpponentPassingYards OpponentPassingTouchdowns * 2001 OpponentPassingInterceptions OpponentPassingYardsPerAttempt OpponentPassingYardsPerCompletion OpponentCompletionPercentage OpponentPasserRating * 2001 OpponentThirdDownAttempts * 2001 OpponentThirdDownConversions * 2001 OpponentThirdDownPercentage * 2001 OpponentFourthDownAttempts * 2001 OpponentFourthDownConversions * 2001 OpponentFourthDownPercentage * 2001 OpponentRedZoneAttempts * 2001 OpponentRedZoneConversions * 2001 OpponentGoalToGoAttempts * 2001 OpponentGoalToGoConversions * 2001 OpponentReturnYards OpponentPenalties OpponentPenaltyYards OpponentFumbles OpponentFumblesLost OpponentTimesSacked OpponentTimesSackedYards OpponentQuarterbackHits * 2006 OpponentTacklesForLoss * 2008 OpponentSafeties * 2001 OpponentPunts OpponentPuntYards OpponentPuntAverage OpponentGiveaways OpponentTakeaways OpponentTurnoverDifferential edit: it is 126 columns wide in excel and 13,281 rows Edited November 8, 2011 by keggerz Quote Link to comment Share on other sites More sharing options...
loaf Posted November 8, 2011 Share Posted November 8, 2011 Quote Link to comment Share on other sites More sharing options...
dbforbes Posted November 8, 2011 Author Share Posted November 8, 2011 I have the following info dating back to 1985...not all categories were recorded that far back: Date Season Week Team Opponent HomeOrAway Score OpponentScore TotalScore Stadium PlayingSurface Temperature Humidity WindSpeed OverUnder PointSpread ScoreQuarter1 ScoreQuarter2 ScoreQuarter3 ScoreQuarter4 ScoreOvertime TimeOfPosessionMinutes TimeOfPosessionSeconds TimeOfPosession FirstDowns FirstDownsByRushing FirstDownsByPassing FirstDownsByPenalty OffensivePlays OffensiveYards OffensiveYardsPerPlay Touchdowns RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns PassingAttempts PassingCompletions PassingYards PassingTouchdowns PassingInterceptions PassingYardsPerAttempt PassingYardsPerCompletion CompletionPercentage PasserRating ThirdDownAttempts ThirdDownConversions ThirdDownPercentage FourthDownAttempts FourthDownConversions FourthDownPercentage RedZoneAttempts RedZoneConversions GoalToGoAttempts GoalToGoConversions ReturnYards Penalties PenaltyYards Fumbles FumblesLost TimesSacked TimesSackedYards QuarterbackHits TacklesForLoss Safeties Punts PuntYards PuntAverage Giveaways Takeaways TurnoverDifferential OpponentScoreQuarter1 OpponentScoreQuarter2 OpponentScoreQuarter3 OpponentScoreQuarter4 OpponentScoreOvertime OpponentTimeOfPosessionMinutes OpponentTimeOfPosessionSeconds OpponentTimeOfPosession OpponentFirstDowns OpponentFirstDownsByRushing OpponentFirstDownsByPassing OpponentFirstDownsByPenalty OpponentOffensivePlays OpponentOffensiveYards OpponentOffensiveYardsPerPlay OpponentTouchdowns OpponentRushingAttempts OpponentRushingYards OpponentRushingYardsPerAttempt OpponentRushingTouchdowns OpponentPassingAttempts OpponentPassingCompletions OpponentPassingYards OpponentPassingTouchdowns OpponentPassingInterceptions OpponentPassingYardsPerAttempt OpponentPassingYardsPerCompletion OpponentCompletionPercentage OpponentPasserRating OpponentThirdDownAttempts OpponentThirdDownConversions OpponentThirdDownPercentage OpponentFourthDownAttempts OpponentFourthDownConversions OpponentFourthDownPercentage OpponentRedZoneAttempts OpponentRedZoneConversions OpponentGoalToGoAttempts OpponentGoalToGoConversions OpponentReturnYards OpponentPenalties OpponentPenaltyYards OpponentFumbles OpponentFumblesLost OpponentTimesSacked OpponentTimesSackedYards OpponentQuarterbackHits OpponentTacklesForLoss OpponentSafeties OpponentPunts OpponentPuntYards OpponentPuntAverage OpponentGiveaways OpponentTakeaways OpponentTurnoverDifferential edit: it is 126 columns wide in excel and 13,281 rows Jesus! That is jaw-dropping, though I'm going to have to come back when I'm not working to read through this mountain of options! Quote Link to comment Share on other sites More sharing options...
Big Country Posted November 8, 2011 Share Posted November 8, 2011 I heart keggerz and his data Quote Link to comment Share on other sites More sharing options...
keggerz Posted November 8, 2011 Share Posted November 8, 2011 (edited) I heart keggerz and his data That is just one file too Edit: give me a sec and I will post all the data that I have at my disposal. EDIT 2: Found a way to post it so it was easier to read. I have all this data from 85-2011(like I said earlier, not all data was being recorded in all past years) Schedule (Includes upcoming schedule) Season Week Date AwayTeam HomeTeam AwayScore HomeScore Channel PointSpread OverUnder TeamGame Date Season Week Team Opponent HomeOrAway Score OpponentScore TotalScore Stadium * 2001 PlayingSurface Temperature * 2001 Humidity * 2001 WindSpeed * 2001 OverUnder PointSpread ScoreQuarter1 ScoreQuarter2 ScoreQuarter3 ScoreQuarter4 ScoreOvertime TimeOfPosessionMinutes TimeOfPosessionSeconds TimeOfPosession FirstDowns FirstDownsByRushing * 2001 FirstDownsByPassing * 2001 FirstDownsByPenalty * 2001 OffensivePlays OffensiveYards OffensiveYardsPerPlay Touchdowns * 2001 RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns * 2001 PassingAttempts PassingCompletions PassingYards PassingTouchdowns * 2001 PassingInterceptions PassingYardsPerAttempt PassingYardsPerCompletion CompletionPercentage PasserRating * 2001 ThirdDownAttempts * 2001 ThirdDownConversions * 2001 ThirdDownPercentage * 2001 FourthDownAttempts * 2001 FourthDownConversions * 2001 FourthDownPercentage * 2001 RedZoneAttempts * 2001 RedZoneConversions * 2001 GoalToGoAttempts * 2001 GoalToGoConversions * 2001 ReturnYards Penalties PenaltyYards Fumbles FumblesLost TimesSacked TimesSackedYards QuarterbackHits * 2006 TacklesForLoss * 2008 Safeties * 2001 Punts PuntYards PuntAverage Giveaways Takeaways TurnoverDifferential OpponentScoreQuarter1 OpponentScoreQuarter2 OpponentScoreQuarter3 OpponentScoreQuarter4 OpponentScoreOvertime OpponentTimeOfPosessionMinutes OpponentTimeOfPosessionSeconds OpponentTimeOfPosession OpponentFirstDowns OpponentFirstDownsByRushing * 2001 OpponentFirstDownsByPassing * 2001 OpponentFirstDownsByPenalty * 2001 OpponentOffensivePlays OpponentOffensiveYards OpponentOffensiveYardsPerPlay OpponentTouchdowns * 2001 OpponentRushingAttempts OpponentRushingYards OpponentRushingYardsPerAttempt OpponentRushingTouchdowns * 2001 OpponentPassingAttempts OpponentPassingCompletions OpponentPassingYards OpponentPassingTouchdowns * 2001 OpponentPassingInterceptions OpponentPassingYardsPerAttempt OpponentPassingYardsPerCompletion OpponentCompletionPercentage OpponentPasserRating * 2001 OpponentThirdDownAttempts * 2001 OpponentThirdDownConversions * 2001 OpponentThirdDownPercentage * 2001 OpponentFourthDownAttempts * 2001 OpponentFourthDownConversions * 2001 OpponentFourthDownPercentage * 2001 OpponentRedZoneAttempts * 2001 OpponentRedZoneConversions * 2001 OpponentGoalToGoAttempts * 2001 OpponentGoalToGoConversions * 2001 OpponentReturnYards OpponentPenalties OpponentPenaltyYards OpponentFumbles OpponentFumblesLost OpponentTimesSacked OpponentTimesSackedYards OpponentQuarterbackHits * 2006 OpponentTacklesForLoss * 2008 OpponentSafeties * 2001 OpponentPunts OpponentPuntYards OpponentPuntAverage OpponentGiveaways OpponentTakeaways OpponentTurnoverDifferential TeamSeason Season Team Score OpponentScore TotalScore Temperature * 2001 Humidity * 2001 WindSpeed * 2001 OverUnder PointSpread ScoreQuarter1 ScoreQuarter2 ScoreQuarter3 ScoreQuarter4 ScoreOvertime TimeOfPosession FirstDowns FirstDownsByRushing * 2001 FirstDownsByPassing * 2001 FirstDownsByPenalty * 2001 OffensivePlays OffensiveYards OffensiveYardsPerPlay Touchdowns * 2001 RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns * 2001 PassingAttempts PassingCompletions PassingYards PassingTouchdowns * 2001 PassingInterceptions PassingYardsPerAttempt PassingYardsPerCompletion CompletionPercentage PasserRating * 2001 ThirdDownAttempts * 2001 ThirdDownConversions * 2001 ThirdDownPercentage * 2001 FourthDownAttempts * 2001 FourthDownConversions * 2001 FourthDownPercentage * 2001 RedZoneAttempts * 2001 RedZoneConversions * 2001 GoalToGoAttempts * 2001 GoalToGoConversions * 2001 ReturnYards Penalties PenaltyYards Fumbles FumblesLost TimesSacked TimesSackedYards QuarterbackHits * 2006 TacklesForLoss * 2008 Safeties * 2001 Punts PuntYards PuntAverage Giveaways Takeaways TurnoverDifferential OpponentScoreQuarter1 OpponentScoreQuarter2 OpponentScoreQuarter3 OpponentScoreQuarter4 OpponentScoreOvertime OpponentTimeOfPosession OpponentFirstDowns OpponentFirstDownsByRushing * 2001 OpponentFirstDownsByPassing * 2001 OpponentFirstDownsByPenalty * 2001 OpponentOffensivePlays OpponentOffensiveYards OpponentOffensiveYardsPerPlay OpponentTouchdowns * 2001 OpponentRushingAttempts OpponentRushingYards OpponentRushingYardsPerAttempt OpponentRushingTouchdowns * 2001 OpponentPassingAttempts OpponentPassingCompletions OpponentPassingYards OpponentPassingTouchdowns * 2001 OpponentPassingInterceptions OpponentPassingYardsPerAttempt OpponentPassingYardsPerCompletion OpponentCompletionPercentage OpponentPasserRating * 2001 OpponentThirdDownAttempts * 2001 OpponentThirdDownConversions * 2001 OpponentThirdDownPercentage * 2001 OpponentFourthDownAttempts * 2001 OpponentFourthDownConversions * 2001 OpponentFourthDownPercentage * 2001 OpponentRedZoneAttempts * 2001 OpponentRedZoneConversions * 2001 OpponentGoalToGoAttempts * 2001 OpponentGoalToGoConversions * 2001 OpponentReturnYards OpponentPenalties OpponentPenaltyYards OpponentFumbles OpponentFumblesLost OpponentTimesSacked OpponentTimesSackedYards OpponentQuarterbackHits * 2006 OpponentTacklesForLoss * 2008 OpponentSafeties * 2001 OpponentPunts OpponentPuntYards OpponentPuntAverage OpponentGiveaways OpponentTakeaways OpponentTurnoverDifferential GameSummary Date Season Week Stadium * 2001 PlayingSurface Temperature * 2001 Humidity * 2001 WindSpeed * 2001 AwayTeam HomeTeam AwayScore HomeScore TotalScore OverUnder PointSpread AwayScoreQuarter1 AwayScoreQuarter2 AwayScoreQuarter3 AwayScoreQuarter4 AwayScoreOvertime HomeScoreQuarter1 HomeScoreQuarter2 HomeScoreQuarter3 HomeScoreQuarter4 HomeScoreOvertime AwayTimeOfPosession HomeTimeOfPosession AwayFirstDowns HomeFirstDowns AwayFirstDownsByRushing * 2001 HomeFirstDownsByRushing * 2001 AwayFirstDownsByPassing * 2001 HomeFirstDownsByPassing * 2001 AwayFirstDownsByPenalty * 2001 HomeFirstDownsByPenalty * 2001 AwayOffensivePlays HomeOffensivePlays AwayOffensiveYards HomeOffensiveYards AwayOffensiveYardsPerPlay HomeOffensiveYardsPerPlay AwayTouchdowns * 2001 HomeTouchdowns * 2001 AwayRushingAttempts HomeRushingAttempts AwayRushingYards HomeRushingYards AwayRushingYardsPerAttempt HomeRushingYardsPerAttempt AwayRushingTouchdowns * 2001 HomeRushingTouchdowns * 2001 AwayPassingAttempts HomePassingAttempts AwayPassingCompletions HomePassingCompletions AwayPassingYards HomePassingYards AwayPassingTouchdowns * 2001 HomePassingTouchdowns * 2001 AwayPassingInterceptions HomePassingInterceptions AwayPassingYardsPerAttempt HomePassingYardsPerAttempt AwayPassingYardsPerCompletion HomePassingYardsPerCompletion AwayCompletionPercentage HomeCompletionPercentage AwayPasserRating * 2001 HomePasserRating * 2001 AwayThirdDownAttempts * 2001 HomeThirdDownAttempts * 2001 AwayThirdDownConversions * 2001 HomeThirdDownConversions * 2001 AwayThirdDownPercentage * 2001 HomeThirdDownPercentage * 2001 AwayFourthDownAttempts * 2001 HomeFourthDownAttempts * 2001 AwayFourthDownConversions * 2001 HomeFourthDownConversions * 2001 AwayFourthDownPercentage * 2001 HomeFourthDownPercentage * 2001 AwayRedZoneAttempts * 2001 HomeRedZoneAttempts * 2001 AwayRedZoneConversions * 2001 HomeRedZoneConversions * 2001 AwayGoalToGoAttempts * 2001 HomeGoalToGoAttempts * 2001 AwayGoalToGoConversions * 2001 HomeGoalToGoConversions * 2001 AwayReturnYards HomeReturnYards AwayPenalties HomePenalties AwayPenaltyYards HomePenaltyYards AwayFumbles HomeFumbles AwayFumblesLost HomeFumblesLost AwayTimesSacked HomeTimesSacked AwayTimesSackedYards HomeTimesSackedYards AwaySafeties * 2001 HomeSafeties * 2001 AwayPunts HomePunts AwayPuntYards HomePuntYards AwayPuntAverage HomePuntAverage AwayGiveaways HomeGiveaways AwayTakeaways HomeTakeaways AwayTurnoverDifferential HomeTurnoverDifferential Most of the following FANTASY info I only have from 2001 . Player PlayerID (Auto-generated number) Team Number FirstName LastName Position Status Height Weight BirthDate College Experience PlayerGame PlayerID (Auto-generated number) Season GameDate Week Team Opponent HomeOrAway Number Name Position PositionCategory Activated Played Started PassingAttempts PassingCompletions PassingYards PassingCompletionPercentage PassingYardsPerAttempt PassingYardsPerCompletion PassingTouchdowns PassingInterceptions PassingRating PassingLong PassingSacks PassingSackYards RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns RushingLong ReceivingTargets Receptions ReceivingYards ReceivingYardsPerReception ReceivingTouchdowns ReceivingLong Fumbles FumblesLost * 2003 PuntReturns PuntReturnYards PuntReturnYardsPerAttempt PuntReturnTouchdowns PuntReturnLong KickReturns KickReturnYards KickReturnYardsPerAttempt KickReturnTouchdowns KickReturnLong SoloTackles AssistedTackles TacklesForLoss * 2008 Sacks SackYards QuarterbackHits * 2006 PassesDefended FumblesForced FumblesRecovered FumbleReturnYards FumbleReturnTouchdowns Interceptions InterceptionReturnYards InterceptionReturnTouchdowns BlockedKicks SpecialTeamsSoloTackles SpecialTeamsAssistedTackles MiscSoloTackles MiscAssistedTackles Punts PuntYards PuntAverage FieldGoalsAttempted FieldGoalsMade FieldGoalsLongestMade ExtraPointsMade TwoPointConversionPasses TwoPointConversionRuns TwoPointConversionReceptions PlayerSeason PlayerID (Auto-generated number) Season Team Number Name Position PositionCategory Activated Played Started PassingAttempts PassingCompletions PassingYards PassingCompletionPercentage PassingYardsPerAttempt PassingYardsPerCompletion PassingTouchdowns PassingInterceptions PassingRating PassingLong PassingSacks PassingSackYards RushingAttempts RushingYards RushingYardsPerAttempt RushingTouchdowns RushingLong ReceivingTargets Receptions ReceivingYards ReceivingYardsPerReception ReceivingTouchdowns ReceivingLong Fumbles FumblesLost * 2003 PuntReturns PuntReturnYards PuntReturnYardsPerAttempt PuntReturnTouchdowns PuntReturnLong KickReturns KickReturnYards KickReturnYardsPerAttempt KickReturnTouchdowns KickReturnLong SoloTackles AssistedTackles TacklesForLoss * 2008 Sacks SackYards QuarterbackHits * 2006 PassesDefended FumblesForced FumblesRecovered FumbleReturnYards FumbleReturnTouchdowns Interceptions InterceptionReturnYards InterceptionReturnTouchdowns BlockedKicks SpecialTeamsSoloTackles SpecialTeamsAssistedTackles MiscSoloTackles MiscAssistedTackles Punts PuntYards PuntAverage FieldGoalsAttempted FieldGoalsMade FieldGoalsLongestMade ExtraPointsMade TwoPointConversionPasses TwoPointConversionRuns TwoPointConversionReceptions TeamDefenseGame Season Week Date Team Opponent PointsSurrendered TouchdownsScored SoloTackles AssistedTackles Sacks SackYards PassesDefended FumblesForced FumblesRecovered FumbleReturnYards FumbleReturnTouchdowns Interceptions InterceptionReturnYards InterceptionReturnTouchdowns BlockedKicks Safeties PuntReturns PuntReturnYards PuntReturnTouchdowns PuntReturnLong KickReturns KickReturnYards KickReturnTouchdowns KickReturnLong TeamDefenseSeason Season Team PointsSurrendered TouchdownsScored SoloTackles AssistedTackles Sacks SackYards PassesDefended FumblesForced FumblesRecovered FumbleReturnYards FumbleReturnTouchdowns Interceptions InterceptionReturnYards InterceptionReturnTouchdowns BlockedKicks Safeties PuntReturns PuntReturnYards PuntReturnTouchdowns PuntReturnLong KickReturns KickReturnYards KickReturnTouchdowns KickReturnLong Edited November 8, 2011 by keggerz Quote Link to comment Share on other sites More sharing options...
HowboutthemCowboys Posted November 9, 2011 Share Posted November 9, 2011 I heart Stats and his data +1 Quote Link to comment Share on other sites More sharing options...
keggerz Posted November 9, 2011 Share Posted November 9, 2011 +1 You make me feel like I should change my user name, that is if we could Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.