Nflfastr
NFL play-by-play data since 1999
@kaggle.benbaldwin_nflfastr
Play By Play 2009
@kaggle.benbaldwin_nflfastr.play_by_play_2009
- 17.8 MB
- 47083 rows
- 340 columns
- Only the first 100 columns are shown
play_idPlay Id | game_idGame Id | old_game_idOld Game Id | home_teamHome Team | away_teamAway Team | season_typeSeason Type | weekWeek | posteamPosteam | posteam_typePosteam Type | defteamDefteam | side_of_fieldSide Of Field | yardline_100Yardline 100 | game_dateGame Date | quarter_seconds_remainingQuarter Seconds Remaining | half_seconds_remainingHalf Seconds Remaining | game_seconds_remainingGame Seconds Remaining | game_halfGame Half | quarter_endQuarter End | driveDrive | spSp | qtrQtr | downDown | goal_to_goGoal To Go | timeTime | yrdlnYrdln | ydstogoYdstogo | ydsnetYdsnet | descDesc | play_typePlay Type | yards_gainedYards Gained | shotgunShotgun | no_huddleNo Huddle | qb_dropbackQb Dropback | qb_kneelQb Kneel | qb_spikeQb Spike | qb_scrambleQb Scramble | pass_lengthPass Length | pass_locationPass Location | air_yardsAir Yards | yards_after_catchYards After Catch | run_locationRun Location | run_gapRun Gap | field_goal_resultField Goal Result | kick_distanceKick Distance | extra_point_resultExtra Point Result | two_point_conv_resultTwo Point Conv Result | home_timeouts_remainingHome Timeouts Remaining | away_timeouts_remainingAway Timeouts Remaining | timeoutTimeout | timeout_teamTimeout Team | td_teamTd Team | posteam_timeouts_remainingPosteam Timeouts Remaining | defteam_timeouts_remainingDefteam Timeouts Remaining | total_home_scoreTotal Home Score | total_away_scoreTotal Away Score | posteam_scorePosteam Score | defteam_scoreDefteam Score | score_differentialScore Differential | posteam_score_postPosteam Score Post | defteam_score_postDefteam Score Post | score_differential_postScore Differential Post | no_score_probNo Score Prob | opp_fg_probOpp Fg Prob | opp_safety_probOpp Safety Prob | opp_td_probOpp Td Prob | fg_probFg Prob | safety_probSafety Prob | td_probTd Prob | extra_point_probExtra Point Prob | two_point_conversion_probTwo Point Conversion Prob | epEp | epaEpa | total_home_epaTotal Home Epa | total_away_epaTotal Away Epa | total_home_rush_epaTotal Home Rush Epa | total_away_rush_epaTotal Away Rush Epa | total_home_pass_epaTotal Home Pass Epa | total_away_pass_epaTotal Away Pass Epa | air_epaAir Epa | yac_epaYac Epa | comp_air_epaComp Air Epa | comp_yac_epaComp Yac Epa | total_home_comp_air_epaTotal Home Comp Air Epa | total_away_comp_air_epaTotal Away Comp Air Epa | total_home_comp_yac_epaTotal Home Comp Yac Epa | total_away_comp_yac_epaTotal Away Comp Yac Epa | total_home_raw_air_epaTotal Home Raw Air Epa | total_away_raw_air_epaTotal Away Raw Air Epa | total_home_raw_yac_epaTotal Home Raw Yac Epa | total_away_raw_yac_epaTotal Away Raw Yac Epa | wpWp | def_wpDef Wp | home_wpHome Wp | away_wpAway Wp | wpaWpa | home_wp_postHome Wp Post | away_wp_postAway Wp Post | vegas_wpVegas Wp | vegas_home_wpVegas Home Wp | total_home_rush_wpaTotal Home Rush Wpa | total_away_rush_wpaTotal Away Rush Wpa | total_home_pass_wpaTotal Home Pass Wpa | total_away_pass_wpaTotal Away Pass Wpa | air_wpaAir Wpa | yac_wpaYac Wpa | comp_air_wpaComp Air Wpa | comp_yac_wpaComp Yac Wpa | total_home_comp_air_wpaTotal Home Comp Air Wpa | total_away_comp_air_wpaTotal Away Comp Air Wpa | total_home_comp_yac_wpaTotal Home Comp Yac Wpa | total_away_comp_yac_wpaTotal Away Comp Yac Wpa | total_home_raw_air_wpaTotal Home Raw Air Wpa | total_away_raw_air_wpaTotal Away Raw Air Wpa | total_home_raw_yac_wpaTotal Home Raw Yac Wpa | total_away_raw_yac_wpaTotal Away Raw Yac Wpa | punt_blockedPunt Blocked | first_down_rushFirst Down Rush | first_down_passFirst Down Pass | first_down_penaltyFirst Down Penalty | third_down_convertedThird Down Converted | third_down_failedThird Down Failed | fourth_down_convertedFourth Down Converted | fourth_down_failedFourth Down Failed | incomplete_passIncomplete Pass | touchbackTouchback | interceptionInterception | punt_inside_twentyPunt Inside Twenty | punt_in_endzonePunt In Endzone | punt_out_of_boundsPunt Out Of Bounds | punt_downedPunt Downed | punt_fair_catchPunt Fair Catch | kickoff_inside_twentyKickoff Inside Twenty | kickoff_in_endzoneKickoff In Endzone | kickoff_out_of_boundsKickoff Out Of Bounds | kickoff_downedKickoff Downed | kickoff_fair_catchKickoff Fair Catch | fumble_forcedFumble Forced | fumble_not_forcedFumble Not Forced | fumble_out_of_boundsFumble Out Of Bounds | solo_tackleSolo Tackle | safetySafety | penaltyPenalty | tackled_for_lossTackled For Loss | fumble_lostFumble Lost | own_kickoff_recoveryOwn Kickoff Recovery | own_kickoff_recovery_tdOwn Kickoff Recovery Td | qb_hitQb Hit | rush_attemptRush Attempt | pass_attemptPass Attempt | sackSack | touchdownTouchdown | pass_touchdownPass Touchdown | rush_touchdownRush Touchdown | return_touchdownReturn Touchdown | extra_point_attemptExtra Point Attempt | two_point_attemptTwo Point Attempt | field_goal_attemptField Goal Attempt | kickoff_attemptKickoff Attempt | punt_attemptPunt Attempt | fumbleFumble | complete_passComplete Pass | assist_tackleAssist Tackle | lateral_receptionLateral Reception | lateral_rushLateral Rush | lateral_returnLateral Return | lateral_recoveryLateral Recovery | passer_player_idPasser Player Id | passer_player_namePasser Player Name | receiver_player_idReceiver Player Id | receiver_player_nameReceiver Player Name | rusher_player_idRusher Player Id | rusher_player_nameRusher Player Name | lateral_receiver_player_idLateral Receiver Player Id | lateral_receiver_player_nameLateral Receiver Player Name | lateral_rusher_player_idLateral Rusher Player Id | lateral_rusher_player_nameLateral Rusher Player Name | lateral_sack_player_idLateral Sack Player Id | lateral_sack_player_nameLateral Sack Player Name | interception_player_idInterception Player Id | interception_player_nameInterception Player Name | lateral_interception_player_idLateral Interception Player Id | lateral_interception_player_nameLateral Interception Player Name | punt_returner_player_idPunt Returner Player Id | punt_returner_player_namePunt Returner Player Name | lateral_punt_returner_player_idLateral Punt Returner Player Id | lateral_punt_returner_player_nameLateral Punt Returner Player Name | kickoff_returner_player_nameKickoff Returner Player Name | kickoff_returner_player_idKickoff Returner Player Id | lateral_kickoff_returner_player_idLateral Kickoff Returner Player Id | lateral_kickoff_returner_player_nameLateral Kickoff Returner Player Name | punter_player_idPunter Player Id | punter_player_namePunter Player Name | kicker_player_nameKicker Player Name | kicker_player_idKicker Player Id | own_kickoff_recovery_player_idOwn Kickoff Recovery Player Id | own_kickoff_recovery_player_nameOwn Kickoff Recovery Player Name | blocked_player_idBlocked Player Id | blocked_player_nameBlocked Player Name | tackle_for_loss_1_player_idTackle For Loss 1 Player Id | tackle_for_loss_1_player_nameTackle For Loss 1 Player Name | tackle_for_loss_2_player_idTackle For Loss 2 Player Id | tackle_for_loss_2_player_nameTackle For Loss 2 Player Name | qb_hit_1_player_idQb Hit 1 Player Id | qb_hit_1_player_nameQb Hit 1 Player Name | qb_hit_2_player_idQb Hit 2 Player Id | qb_hit_2_player_nameQb Hit 2 Player Name | forced_fumble_player_1_teamForced Fumble Player 1 Team | forced_fumble_player_1_player_idForced Fumble Player 1 Player Id | forced_fumble_player_1_player_nameForced Fumble Player 1 Player Name | forced_fumble_player_2_teamForced Fumble Player 2 Team | forced_fumble_player_2_player_idForced Fumble Player 2 Player Id | forced_fumble_player_2_player_nameForced Fumble Player 2 Player Name | solo_tackle_1_teamSolo Tackle 1 Team | solo_tackle_2_teamSolo Tackle 2 Team | solo_tackle_1_player_idSolo Tackle 1 Player Id | solo_tackle_2_player_idSolo Tackle 2 Player Id | solo_tackle_1_player_nameSolo Tackle 1 Player Name | solo_tackle_2_player_nameSolo Tackle 2 Player Name | assist_tackle_1_player_idAssist Tackle 1 Player Id | assist_tackle_1_player_nameAssist Tackle 1 Player Name | assist_tackle_1_teamAssist Tackle 1 Team | assist_tackle_2_player_idAssist Tackle 2 Player Id | assist_tackle_2_player_nameAssist Tackle 2 Player Name | assist_tackle_2_teamAssist Tackle 2 Team | assist_tackle_3_player_idAssist Tackle 3 Player Id | assist_tackle_3_player_nameAssist Tackle 3 Player Name | assist_tackle_3_teamAssist Tackle 3 Team | assist_tackle_4_player_idAssist Tackle 4 Player Id | assist_tackle_4_player_nameAssist Tackle 4 Player Name | assist_tackle_4_teamAssist Tackle 4 Team | pass_defense_1_player_idPass Defense 1 Player Id | pass_defense_1_player_namePass Defense 1 Player Name | pass_defense_2_player_idPass Defense 2 Player Id | pass_defense_2_player_namePass Defense 2 Player Name | fumbled_1_teamFumbled 1 Team | fumbled_1_player_idFumbled 1 Player Id | fumbled_1_player_nameFumbled 1 Player Name | fumbled_2_player_idFumbled 2 Player Id | fumbled_2_player_nameFumbled 2 Player Name | fumbled_2_teamFumbled 2 Team | fumble_recovery_1_teamFumble Recovery 1 Team | fumble_recovery_1_yardsFumble Recovery 1 Yards | fumble_recovery_1_player_idFumble Recovery 1 Player Id | fumble_recovery_1_player_nameFumble Recovery 1 Player Name | fumble_recovery_2_teamFumble Recovery 2 Team | fumble_recovery_2_yardsFumble Recovery 2 Yards | fumble_recovery_2_player_idFumble Recovery 2 Player Id | fumble_recovery_2_player_nameFumble Recovery 2 Player Name | return_teamReturn Team | return_yardsReturn Yards | penalty_teamPenalty Team | penalty_player_idPenalty Player Id | penalty_player_namePenalty Player Name | penalty_yardsPenalty Yards | replay_or_challengeReplay Or Challenge | replay_or_challenge_resultReplay Or Challenge Result | penalty_typePenalty Type | defensive_two_point_attemptDefensive Two Point Attempt | defensive_two_point_convDefensive Two Point Conv | defensive_extra_point_attemptDefensive Extra Point Attempt | defensive_extra_point_convDefensive Extra Point Conv | seasonSeason | cpCp | cpoeCpoe | seriesSeries | series_successSeries Success | series_resultSeries Result | order_sequenceOrder Sequence | start_timeStart Time | time_of_dayTime Of Day | stadiumStadium | weatherWeather | nfl_api_idNfl Api Id | play_clockPlay Clock | play_deletedPlay Deleted | play_type_nflPlay Type Nfl | special_teams_playSpecial Teams Play | st_play_typeSt Play Type | end_clock_timeEnd Clock Time | end_yard_lineEnd Yard Line | fixed_driveFixed Drive | fixed_drive_resultFixed Drive Result | drive_real_start_timeDrive Real Start Time | drive_play_countDrive Play Count | drive_time_of_possessionDrive Time Of Possession | drive_first_downsDrive First Downs | drive_inside20Drive Inside20 | drive_ended_with_scoreDrive Ended With Score | drive_quarter_startDrive Quarter Start | drive_quarter_endDrive Quarter End | drive_yards_penalizedDrive Yards Penalized | drive_start_transitionDrive Start Transition | drive_end_transitionDrive End Transition | drive_game_clock_startDrive Game Clock Start | drive_game_clock_endDrive Game Clock End | drive_start_yard_lineDrive Start Yard Line | drive_end_yard_lineDrive End Yard Line | drive_play_id_startedDrive Play Id Started | drive_play_id_endedDrive Play Id Ended | away_scoreAway Score | home_scoreHome Score | locationLocation | resultResult | totalTotal | spread_lineSpread Line | total_lineTotal Line | div_gameDiv Game | roofRoof | surfaceSurface | tempTemp | windWind | home_coachHome Coach | away_coachAway Coach | stadium_idStadium Id | game_stadiumGame Stadium | successSuccess | passerPasser | passer_jersey_numberPasser Jersey Number | rusherRusher | rusher_jersey_numberRusher Jersey Number | receiverReceiver | receiver_jersey_numberReceiver Jersey Number | passPass | rushRush | first_downFirst Down | aborted_playAborted Play | specialSpecial | playPlay | passer_idPasser Id | rusher_idRusher Id | receiver_idReceiver Id | nameName | jersey_numberJersey Number | idId | qb_epaQb Epa | xyac_epaXyac Epa | xyac_mean_yardageXyac Mean Yardage | xyac_median_yardageXyac Median Yardage | xyac_successXyac Success | xyac_fdXyac Fd |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | NE | home | BUF | BUF | 30 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 900 | 1800 | 3600 | Half1 | 1 | 1 | 15:00 | BUF 30 | 9 | R.Lindell kicks 71 yards from BUF 30 to NE -1. L.Maroney pushed ob at BUF 49 for 52 yards (R.Lindell). | kickoff | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0065009039826691 | 0.1815980076789856 | 0.0033474285155534 | 0.2434615045785904 | 0.2165955901145935 | 0.0039858613163232 | 0.3445106744766235 | 0.8136138021945953 | 2.0400871492456645 | 2.0400871492456645 | -2.0400871492456645 | 0.0003131736593786627 | 0.9996868263406212 | 0.0003131736593786627 | 0.9996868263406212 | 0.5931107889337 | 0.5934239625930786 | 0.4065760374069214 | 0.0036801660899072 | 0.0036801660899072 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 79 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | NE | home | BUF | BUF | 49 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 892 | 1792 | 3592 | Half1 | 1 | 1 | 1 | 14:52 | BUF 49 | 10 | 9 | (14:52) T.Brady pass incomplete short right to R.Moss. | pass | 1 | short | right | 1 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0055867307819426 | 0.0987800657749176 | 0.0012992598349228 | 0.133875086903572 | 0.3021005690097809 | 0.0050088446587324 | 0.4533494114875793 | 2.85370095144026 | -0.4637464715633541 | 1.5763406776823103 | -1.5763406776823103 | -0.4637464715633541 | 0.4637464715633541 | -0.4506826801225543 | -0.0130637914407998 | -0.4506826801225543 | 0.4506826801225543 | -0.0130637914407998 | 0.0130637914407998 | 0.5934239625930786 | 0.4065760374069214 | 0.5934239625930786 | 0.4065760374069214 | -0.0100743770599365 | 0.5833495855331421 | 0.4166504144668579 | 0.9164554476737976 | 0.9164554476737976 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 101 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | NE | home | BUF | BUF | 49 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 887 | 1787 | 3587 | Half1 | 1 | 1 | 2 | 14:47 | BUF 49 | 10 | 9 | (14:47) F.Taylor right end to BUF 46 for 3 yards (P.Posluszny, D.Whitner). | run | 3 | nan | nan | right | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0058521837927401 | 0.1129672676324844 | 0.0013490042183548 | 0.1604657620191574 | 0.2882061004638672 | 0.0055842432193458 | 0.4255754053592682 | 2.3899544798769057 | -0.5189418781083077 | 1.0573987995740026 | -1.0573987995740026 | -0.5189418781083077 | 0.5189418781083077 | -0.4637464715633541 | 0.4637464715633541 | -0.4506826801225543 | 0.4506826801225543 | -0.0130637914407998 | 0.0130637914407998 | 0.5833495855331421 | 0.4166504144668579 | 0.5833495855331421 | 0.4166504144668579 | -0.0225074887275695 | 0.5608420968055725 | 0.4391579031944275 | 0.9280719757080078 | 0.9280719757080078 | -0.0225074887275695 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 122 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | NE | home | BUF | BUF | 46 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 843 | 1743 | 3543 | Half1 | 1 | 1 | 3 | 14:03 | BUF 46 | 7 | 9 | (14:03) (Shotgun) T.Brady pass short middle to K.Faulk to BUF 40 for 6 yards (P.Posluszny) [C.Kelsay]. | pass | 6 | 1 | 1 | short | middle | 4 | 2 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0068063423968851 | 0.1353654861450195 | 0.0014729817630723 | 0.1834255158901214 | 0.2786061763763428 | 0.006409902125597 | 0.3879136145114898 | 1.871012601768598 | -0.4490418122150004 | 0.6083569873590022 | -0.6083569873590022 | -0.5189418781083077 | 0.5189418781083077 | -0.9127882837783544 | 0.9127882837783544 | -1.2899064489174634 | 0.840864636702463 | -1.2899064489174634 | 0.840864636702463 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -1.7405891290400175 | 1.7405891290400175 | 0.8278008452616632 | -0.8278008452616632 | 0.5608420968055725 | 0.4391579031944275 | 0.5608420968055725 | 0.4391579031944275 | -0.00007784366607666016 | 0.5607642531394958 | 0.4392357468605041 | 0.8728542923927307 | 0.8728542923927307 | -0.0225074887275695 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 146 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | NE | home | BUF | BUF | 40 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 819 | 1719 | 3519 | Half1 | 1 | 1 | 4 | 13:39 | BUF 40 | 1 | 9 | (13:39) N.Kaczur reported in as eligible. L.Maroney left tackle to BUF 40 for no gain (K.Ellison, K.Williams). | run | nan | nan | left | tackle | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0068970131687819 | 0.167449414730072 | 0.0015734819462522 | 0.2073413729667663 | 0.2228110283613205 | 0.0094142295420169 | 0.3845134377479553 | 1.4219707895535976 | -2.856667476473376 | -2.248310489114374 | 2.248310489114374 | -3.375609354581684 | 3.375609354581684 | -0.9127882837783544 | 0.9127882837783544 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -1.7405891290400175 | 1.7405891290400175 | 0.8278008452616632 | -0.8278008452616632 | 0.5607642531394958 | 0.4392357468605041 | 0.5607642531394958 | 0.4392357468605041 | -0.059402972459793 | 0.5013612806797028 | 0.4986387193202972 | 0.8488442897796631 | 0.8488442897796631 | -0.0819104611873626 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 169 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | BUF | away | NE | BUF | 60 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 813 | 1713 | 3513 | Half1 | 2 | 1 | 1 | 13:33 | BUF 40 | 10 | -2 | (13:33) T.Edwards pass incomplete short right to L.Evans (A.Thomas). | pass | 1 | short | right | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0071351365186274 | 0.1312867850065231 | 0.0024131380487233 | 0.2192094624042511 | 0.272124707698822 | 0.0046679656952619 | 0.3631627857685089 | 1.4346966869197786 | -0.4901196085847914 | -1.7581908805295825 | 1.7581908805295825 | -3.375609354581684 | 3.375609354581684 | -0.4226686751935631 | 0.4226686751935631 | -0.4909732663072645 | 0.0008536577224731445 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -1.2496158627327532 | 1.2496158627327532 | 0.82694718753919 | -0.82694718753919 | 0.4986387193202972 | 0.5013612806797028 | 0.5013612806797028 | 0.4986387193202972 | -0.0011643469333648 | 0.5025256276130676 | 0.4974743723869324 | 0.1580709367990493 | 0.8419290632009506 | -0.0819104611873626 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 198 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | BUF | away | NE | BUF | 60 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 810 | 1710 | 3510 | Half1 | 2 | 1 | 2 | 13:30 | BUF 40 | 10 | -2 | (13:30) (No Huddle) F.Jackson left end to BUF 43 for 3 yards (L.Bodden, J.Mayo). | run | 3 | 1 | nan | nan | left | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0072706523351371 | 0.1459559947252273 | 0.0026245797052979 | 0.2487164884805679 | 0.2535246312618255 | 0.0050435797311365 | 0.3368640840053558 | 0.9445770783349872 | -0.4603941421955824 | -1.297796738334 | 1.297796738334 | -2.915215212386101 | 2.915215212386101 | -0.4226686751935631 | 0.4226686751935631 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -1.2496158627327532 | 1.2496158627327532 | 0.82694718753919 | -0.82694718753919 | 0.4974743723869324 | 0.5025256276130676 | 0.5025256276130676 | 0.4974743723869324 | -0.023912638425827 | 0.5264382660388947 | 0.4735617339611053 | 0.1554792076349258 | 0.8445207923650742 | -0.0579978227615356 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 219 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | BUF | away | NE | BUF | 57 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 771 | 1671 | 3471 | Half1 | 2 | 1 | 3 | 12:51 | BUF 43 | 7 | -2 | (12:51) (Shotgun) T.Edwards pass deep middle to J.Reed to NE 36 for 21 yards (B.Meriweather, J.Wilhite). PENALTY on BUF-D.Bell, Illegal Formation, 5 yards, enforced at BUF 43 - No Play. | no_play | 1 | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0075926943682134 | 0.1705432385206222 | 0.0025454410351812 | 0.268622875213623 | 0.2367692440748214 | 0.0053059617057442 | 0.3086205720901489 | 0.4841829361394048 | -0.774688234552741 | -0.5231085037812591 | 0.5231085037812591 | -2.915215212386101 | 2.915215212386101 | -0.4226686751935631 | 0.4226686751935631 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -1.2496158627327532 | 1.2496158627327532 | 0.82694718753919 | -0.82694718753919 | 0.4735617339611053 | 0.5264382660388947 | 0.5264382660388947 | 0.4735617339611053 | -0.0303076803684234 | 0.5567459464073181 | 0.4432540535926819 | 0.19420126080513 | 0.80579873919487 | -0.0579978227615356 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 254 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | BUF | away | NE | BUF | 62 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 752 | 1652 | 3452 | Half1 | 2 | 1 | 3 | 12:32 | BUF 38 | 12 | -2 | (12:32) (Shotgun) T.Edwards pass incomplete short right to F.Jackson. | pass | 1 | 1 | short | right | 2 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0073565021157264 | 0.1938279867172241 | 0.0039617377333343 | 0.3201622664928436 | 0.1892136335372924 | 0.0051896786317229 | 0.2802882492542267 | -0.2905052984133363 | -1.119754615239799 | 0.59664611145854 | -0.59664611145854 | -2.915215212386101 | 2.915215212386101 | 0.6970859400462359 | -0.6970859400462359 | -0.9100470738485456 | -0.2097075413912534 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -0.3395687888842076 | 0.3395687888842076 | 1.0366547289304435 | -1.0366547289304435 | 0.4432540535926819 | 0.5567459464073181 | 0.5567459464073181 | 0.4432540535926819 | -0.0247613191604614 | 0.5815072655677795 | 0.4184927344322204 | 0.1490207016468048 | 0.8509792983531952 | -0.0579978227615356 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 276 | 2009_01_BUF_NE | 2009091400 | NE | BUF | REG | 1 | BUF | away | NE | BUF | 62 | Mon Sep 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time) | 745 | 1645 | 3445 | Half1 | 2 | 1 | 4 | 12:25 | BUF 38 | 12 | -2 | (12:25) B.Moorman punts 55 yards to NE 7, Center-G.Sanborn. W.Welker to NE 17 for 10 yards (K.Ellison, K.Mitchell). | punt | nan | nan | nan | nan | nan | 55 | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0073902173899114 | 0.2297557592391967 | 0.0047973375767469 | 0.3870260715484619 | 0.1421440839767456 | 0.006170704960823 | 0.2227158397436142 | -1.4102599136531353 | 0.751549644395709 | -0.154903532937169 | 0.154903532937169 | -2.915215212386101 | 2.915215212386101 | 0.6970859400462359 | -0.6970859400462359 | -1.2899064489174634 | 1.2899064489174634 | 0.840864636702463 | -0.840864636702463 | -0.3395687888842076 | 0.3395687888842076 | 1.0366547289304435 | -1.0366547289304435 | 0.4184927344322204 | 0.5815072655677795 | 0.5815072655677795 | 0.4184927344322204 | 0.0501320362091064 | 0.5313752293586731 | 0.4686247706413269 | 0.1121708080172538 | 0.8878291919827461 | -0.0579978227615356 |
CREATE TABLE play_by_play_2009 (
"play_id" BIGINT,
"game_id" VARCHAR,
"old_game_id" BIGINT,
"home_team" VARCHAR,
"away_team" VARCHAR,
"season_type" VARCHAR,
"week" BIGINT,
"posteam" VARCHAR,
"posteam_type" VARCHAR,
"defteam" VARCHAR,
"side_of_field" VARCHAR,
"yardline_100" DOUBLE,
"game_date" TIMESTAMP,
"quarter_seconds_remaining" DOUBLE,
"half_seconds_remaining" DOUBLE,
"game_seconds_remaining" DOUBLE,
"game_half" VARCHAR,
"quarter_end" BIGINT,
"drive" BIGINT,
"sp" BIGINT,
"qtr" BIGINT,
"down" DOUBLE,
"goal_to_go" DOUBLE,
"time" VARCHAR,
"yrdln" VARCHAR,
"ydstogo" BIGINT,
"ydsnet" BIGINT,
"desc" VARCHAR,
"play_type" VARCHAR,
"yards_gained" DOUBLE,
"shotgun" BIGINT,
"no_huddle" BIGINT,
"qb_dropback" DOUBLE,
"qb_kneel" BIGINT,
"qb_spike" BIGINT,
"qb_scramble" BIGINT,
"pass_length" VARCHAR,
"pass_location" VARCHAR,
"air_yards" DOUBLE,
"yards_after_catch" DOUBLE,
"run_location" VARCHAR,
"run_gap" VARCHAR,
"field_goal_result" VARCHAR,
"kick_distance" DOUBLE,
"extra_point_result" VARCHAR,
"two_point_conv_result" VARCHAR,
"home_timeouts_remaining" BIGINT,
"away_timeouts_remaining" BIGINT,
"timeout" DOUBLE,
"timeout_team" VARCHAR,
"td_team" VARCHAR,
"posteam_timeouts_remaining" DOUBLE,
"defteam_timeouts_remaining" DOUBLE,
"total_home_score" BIGINT,
"total_away_score" BIGINT,
"posteam_score" DOUBLE,
"defteam_score" DOUBLE,
"score_differential" DOUBLE,
"posteam_score_post" DOUBLE,
"defteam_score_post" DOUBLE,
"score_differential_post" DOUBLE,
"no_score_prob" DOUBLE,
"opp_fg_prob" DOUBLE,
"opp_safety_prob" DOUBLE,
"opp_td_prob" DOUBLE,
"fg_prob" DOUBLE,
"safety_prob" DOUBLE,
"td_prob" DOUBLE,
"extra_point_prob" BIGINT,
"two_point_conversion_prob" DOUBLE,
"ep" DOUBLE,
"epa" DOUBLE,
"total_home_epa" DOUBLE,
"total_away_epa" DOUBLE,
"total_home_rush_epa" DOUBLE,
"total_away_rush_epa" DOUBLE,
"total_home_pass_epa" DOUBLE,
"total_away_pass_epa" DOUBLE,
"air_epa" DOUBLE,
"yac_epa" DOUBLE,
"comp_air_epa" DOUBLE,
"comp_yac_epa" DOUBLE,
"total_home_comp_air_epa" DOUBLE,
"total_away_comp_air_epa" DOUBLE,
"total_home_comp_yac_epa" DOUBLE,
"total_away_comp_yac_epa" DOUBLE,
"total_home_raw_air_epa" DOUBLE,
"total_away_raw_air_epa" DOUBLE,
"total_home_raw_yac_epa" DOUBLE,
"total_away_raw_yac_epa" DOUBLE,
"wp" DOUBLE,
"def_wp" DOUBLE,
"home_wp" DOUBLE,
"away_wp" DOUBLE,
"wpa" DOUBLE,
"home_wp_post" DOUBLE,
"away_wp_post" DOUBLE,
"vegas_wp" DOUBLE,
"vegas_home_wp" DOUBLE,
"total_home_rush_wpa" DOUBLE
);