Nflfastr
NFL play-by-play data since 1999
@kaggle.benbaldwin_nflfastr
Play By Play 2011
@kaggle.benbaldwin_nflfastr.play_by_play_2011
- 18.86 MB
- 48200 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | nan | nan | nan | nan | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 900 | 1800 | 3600 | Half1 | 1 | 15:00 | ATL 35 | GAME | nan | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 36 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | ATL | 35 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 900 | 1800 | 3600 | Half1 | 1 | 1 | 15:00 | ATL 35 | 54 | 5-M.Bosher kicks 69 yards from ATL 35 to CHI -4. 23-D.Hester to CHI 27 for 31 yards (5-M.Bosher). PENALTY on ATL-34-O.Mughelli, Illegal Formation, 5 yards, enforced at ATL 35 - No Play. | no_play | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0039180973544716 | 0.0670915246009826 | 0.0010195345385 | 0.0909710004925727 | 0.3551867008209228 | 0.0072508631274104 | 0.4745623469352722 | 3.5618876109365374 | -2.739497163100168 | -2.739497163100168 | 2.739497163100168 | 0.5504932403564453 | 0.4495067596435547 | 0.5504932403564453 | 0.4495067596435547 | 0.4546030461788177 | 0.4546030461788177 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 69 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | ATL | 30 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 896 | 1796 | 3596 | Half1 | 1 | 1 | 14:56 | ATL 30 | 54 | 5-M.Bosher kicks 70 yards from ATL 30 to CHI 0. 23-D.Hester to CHI 23 for 23 yards (44-J.Snelling). | kickoff | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0064985952340066 | 0.1813929229974746 | 0.0033218825701624 | 0.2426715791225433 | 0.2177422642707824 | 0.0039844457060098 | 0.344388335943222 | 0.8223904478363693 | 0.160476682242006 | -2.579020480858162 | 2.579020480858162 | 0.5504932403564453 | 0.4495067596435547 | 0.5504932403564453 | 0.4495067596435547 | 0.0038135647773742 | 0.5543068051338196 | 0.4456931948661804 | 0.4546030461788177 | 0.4546030461788177 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 91 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | CHI | 77 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 890 | 1790 | 3590 | Half1 | 1 | 1 | 1 | 14:50 | CHI 23 | 10 | 54 | (14:50) 22-M.Forte left end to CHI 20 for -3 yards (56-S.Weatherspoon). | run | -3 | nan | nan | left | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0067852078936994 | 0.1648798137903213 | 0.002928998786956 | 0.2408353984355926 | 0.2254407554864883 | 0.0042037675157189 | 0.3549260795116424 | 0.9828671300783752 | -1.0269652595743537 | -3.605985740432516 | 3.605985740432516 | -1.0269652595743537 | 1.0269652595743537 | 0.5543068051338196 | 0.4456931948661804 | 0.5543068051338196 | 0.4456931948661804 | -0.0500488877296447 | 0.5042579174041748 | 0.4957420825958252 | 0.458822101354599 | 0.458822101354599 | -0.0500488877296447 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 112 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | CHI | 80 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 857 | 1757 | 3557 | Half1 | 1 | 1 | 2 | 14:17 | CHI 20 | 13 | 54 | (14:17) 6-J.Cutler pass short right to 23-D.Hester to CHI 25 for 5 yards. FUMBLES, and recovers at CHI 26. 23-D.Hester to CHI 27 for 1 yard (23-D.Robinson). CHI #23 had his arm hit by CHI #72 which caused the fumble | pass | 7 | 1 | short | right | 7 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0071236910298466 | 0.2207801789045334 | 0.0041113100014626 | 0.286266416311264 | 0.1802738159894943 | 0.0041207619942724 | 0.2973238527774811 | -0.0440981294959783 | 0.3493510563857853 | -3.2566346840467304 | 3.2566346840467304 | -1.0269652595743537 | 1.0269652595743537 | 0.3493510563857853 | -0.3493510563857853 | -0.8152043223381042 | 1.1645553787238896 | -0.8152043223381042 | 1.1645553787238896 | -0.8152043223381042 | 0.8152043223381042 | 1.1645553787238896 | -1.1645553787238896 | -0.8152043223381042 | 0.8152043223381042 | 1.1645553787238896 | -1.1645553787238896 | 0.5042579174041748 | 0.4957420825958252 | 0.5042579174041748 | 0.4957420825958252 | 0.0120630860328674 | 0.5163210034370422 | 0.4836789965629577 | 0.4073794782161712 | 0.4073794782161712 | -0.0500488877296447 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 147 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | CHI | 73 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 817 | 1717 | 3517 | Half1 | 1 | 1 | 3 | 13:37 | CHI 27 | 6 | 54 | (13:37) 6-J.Cutler pass deep left to 11-R.Williams pushed ob at 50 for 23 yards (23-D.Robinson). | pass | 23 | 1 | deep | left | 18 | 5 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0074613904580473 | 0.1917541921138763 | 0.0030397914815694 | 0.275075227022171 | 0.2064287513494491 | 0.0041698520071804 | 0.3120708167552948 | 0.305252926889807 | 2.600647134473548 | -0.6559875495731831 | 0.6559875495731831 | -1.0269652595743537 | 1.0269652595743537 | 2.9499981908593327 | -2.9499981908593327 | 2.271982805803418 | 0.3286643286701292 | 2.271982805803418 | 0.3286643286701292 | 1.456778483465314 | -1.456778483465314 | 1.4932197073940188 | -1.4932197073940188 | 1.456778483465314 | -1.456778483465314 | 1.4932197073940188 | -1.4932197073940188 | 0.5163210034370422 | 0.4836789965629577 | 0.5163210034370422 | 0.4836789965629577 | 0.0805956125259399 | 0.5969166159629822 | 0.4030833840370178 | 0.4174122512340545 | 0.4174122512340545 | -0.0500488877296447 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 175 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | 50 | 50 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 791 | 1691 | 3491 | Half1 | 1 | 1 | 1 | 13:11 | MID 50 | 10 | 54 | (13:11) 22-M.Forte left end to 50 for no gain (56-S.Weatherspoon). | run | nan | nan | left | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0061443564482033 | 0.0989042893052101 | 0.0013203568523749 | 0.1298154443502426 | 0.3018026947975158 | 0.0051072225905954 | 0.4569056034088135 | 2.9059000613633543 | -0.4946125280112028 | -1.150600077584386 | 1.150600077584386 | -1.5215777875855565 | 1.5215777875855565 | 2.9499981908593327 | -2.9499981908593327 | 1.456778483465314 | -1.456778483465314 | 1.4932197073940188 | -1.4932197073940188 | 1.456778483465314 | -1.456778483465314 | 1.4932197073940188 | -1.4932197073940188 | 0.5969166159629822 | 0.4030833840370178 | 0.5969166159629822 | 0.4030833840370178 | -0.0103899836540222 | 0.58652663230896 | 0.41347336769104 | 0.4897901713848114 | 0.4897901713848114 | -0.0604388713836669 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 196 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | 50 | 50 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 753 | 1653 | 3453 | Half1 | 1 | 1 | 2 | 12:33 | MID 50 | 10 | 54 | (12:33) 6-J.Cutler pass incomplete deep right to 80-E.Bennett (20-B.Grimes). | pass | 1 | deep | right | 25 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0064015039242804 | 0.1134602800011634 | 0.0013845021603628 | 0.1583022475242614 | 0.2879649698734283 | 0.0057494593784213 | 0.4267370402812958 | 2.4112875333521515 | -0.830635969992727 | -1.981236047577113 | 1.981236047577113 | -1.5215777875855565 | 1.5215777875855565 | 2.1193622208666056 | -2.1193622208666056 | 1.9278485581744464 | -2.7584845281671733 | 1.456778483465314 | -1.456778483465314 | 1.4932197073940188 | -1.4932197073940188 | 3.38462704163976 | -3.38462704163976 | -1.2652648207731545 | 1.2652648207731545 | 0.58652663230896 | 0.41347336769104 | 0.58652663230896 | 0.41347336769104 | -0.0228111743927001 | 0.5637154579162598 | 0.4362845420837402 | 0.4833723306655884 | 0.4833723306655884 | -0.0604388713836669 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 218 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | 50 | 50 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 747 | 1647 | 3447 | Half1 | 1 | 1 | 3 | 12:27 | MID 50 | 10 | 54 | (12:27) 6-J.Cutler pass short middle to 22-M.Forte to ATL 27 for 23 yards (28-T.DeCoud). | pass | 23 | 1 | short | middle | 10 | 13 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0072595165111124 | 0.1482865810394287 | 0.0015440337592735 | 0.201030895113945 | 0.2561055421829223 | 0.0065830536186695 | 0.3791904151439667 | 1.5806515633594245 | 2.64326692558825 | 0.6620308780111372 | -0.6620308780111372 | -1.5215777875855565 | 1.5215777875855565 | 4.762629146454856 | -4.762629146454856 | 1.9119600281119349 | 0.7313068974763155 | 1.9119600281119349 | 0.7313068974763155 | 3.368738511577249 | -3.368738511577249 | 2.2245266048703343 | -2.2245266048703343 | 5.296587069751695 | -5.296587069751695 | -0.533957923296839 | 0.533957923296839 | 0.5637154579162598 | 0.4362845420837402 | 0.5637154579162598 | 0.4362845420837402 | 0.0630700588226318 | 0.6267855167388916 | 0.3732144832611084 | 0.4590721130371094 | 0.4590721130371094 | -0.0604388713836669 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 242 | 2011_01_ATL_CHI | 2011091105 | CHI | ATL | REG | 1 | CHI | home | ATL | ATL | 27 | Sun Sep 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 701 | 1601 | 3401 | Half1 | 1 | 1 | 1 | 11:41 | ATL 27 | 10 | 54 | (11:41) 6-J.Cutler pass short right to 22-M.Forte to ATL 24 for 3 yards (56-S.Weatherspoon). | pass | 3 | 1 | short | right | 3 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0041521550156176 | 0.0387430526316165 | 0.0006717272335663438 | 0.0544108301401138 | 0.3956501185894012 | 0.0018375879153609 | 0.5045344829559326 | 4.223918488947675 | -0.0538613995304331 | 0.6081694784807041 | -0.6081694784807041 | -1.5215777875855565 | 1.5215777875855565 | 4.708767746924423 | -4.708767746924423 | -0.0538613995304331 | -0.0538613995304331 | 3.3148771120468155 | -3.3148771120468155 | 2.2245266048703343 | -2.2245266048703343 | 5.242725670221262 | -5.242725670221262 | -0.533957923296839 | 0.533957923296839 | 0.6267855167388916 | 0.3732144832611084 | 0.6267855167388916 | 0.3732144832611084 | -0.0010281205177307 | 0.6257573962211609 | 0.3742426037788391 | 0.511989951133728 | 0.511989951133728 | -0.0604388713836669 |
CREATE TABLE play_by_play_2011 (
"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" DOUBLE,
"sp" BIGINT,
"qtr" BIGINT,
"down" DOUBLE,
"goal_to_go" BIGINT,
"time" VARCHAR,
"yrdln" VARCHAR,
"ydstogo" BIGINT,
"ydsnet" DOUBLE,
"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" DOUBLE,
"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
);