Nflfastr
NFL play-by-play data since 1999
@kaggle.benbaldwin_nflfastr
Play By Play 2010
@kaggle.benbaldwin_nflfastr.play_by_play_2010
- 17.94 MB
- 47467 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | LA | 30 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 900 | 1800 | 3600 | Half1 | 1 | 1 | 15:00 | LA 30 | 53 | J.Brown kicks 70 yards from STL 30 to ARI 0. L.Stephens-Howling to ARI 22 for 22 yards (C.Ah You). | kickoff | nan | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0048854136839509 | 0.1641076058149337 | 0.0056453943252563 | 0.3001112043857574 | 0.1986964344978332 | 0.0031654916238039 | 0.3233884572982788 | 0.2617474510334432 | 0.0435819164849817 | -0.0435819164849817 | 0.0435819164849817 | 0.0005277247983030975 | 0.9994722752016968 | 0.9994722752016968 | 0.0005277247983030975 | 0.4043951777857728 | 0.5950770974159241 | 0.4049229025840759 | 0.0005982068250887096 | 0.9994017931749112 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 58 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | ARI | 78 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 895 | 1795 | 3595 | Half1 | 1 | 1 | 1 | 14:55 | ARI 22 | 10 | 53 | (14:55) D.Anderson pass short right to S.Spach to ARI 22 for no gain (J.Laurinaitis). | pass | 1 | short | right | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0049956762231886 | 0.1630418449640274 | 0.0054872366599738 | 0.2964465618133545 | 0.203153058886528 | 0.0034067290835082 | 0.323468953371048 | 0.305329367518425 | -0.564643248450011 | 0.5210613319650292 | -0.5210613319650292 | 0.564643248450011 | -0.564643248450011 | -0.564643248450011 | -0.564643248450011 | 0.564643248450011 | -0.564643248450011 | 0.564643248450011 | -0.564643248450011 | 0.4049229025840759 | 0.5950770974159241 | 0.5950770974159241 | 0.4049229025840759 | -0.0056592226028442 | 0.6007363200187683 | 0.3992636799812317 | 0.6013631224632263 | 0.3986368775367737 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 82 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | ARI | 78 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 864 | 1764 | 3564 | Half1 | 1 | 1 | 2 | 14:24 | ARI 22 | 10 | 53 | (14:24) T.Hightower left end to ARI 27 for 5 yards (B.Fletcher). | run | 5 | nan | nan | left | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.004976422060281 | 0.181179016828537 | 0.0059227058663964 | 0.3282675743103027 | 0.1866792142391204 | 0.0033842634875327 | 0.2895907759666443 | -0.259313880931586 | -0.0223504365421831 | 0.5434117685072124 | -0.5434117685072124 | 0.0223504365421831 | -0.0223504365421831 | 0.564643248450011 | -0.564643248450011 | 0.564643248450011 | -0.564643248450011 | 0.564643248450011 | -0.564643248450011 | 0.3992636799812317 | 0.6007363200187683 | 0.6007363200187683 | 0.3992636799812317 | -0.0061154663562774 | 0.6068517863750458 | 0.3931482136249542 | 0.5864583849906921 | 0.4135416150093078 | 0.0061154663562774 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 103 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | ARI | 73 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 823 | 1723 | 3523 | Half1 | 1 | 1 | 3 | 13:43 | ARI 27 | 5 | 53 | (13:43) (Shotgun) D.Anderson pass short right to L.Fitzgerald pushed ob at ARI 45 for 18 yards (O.Atogwe). | pass | 18 | 1 | 1 | short | right | 7 | 11 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0055715469643473 | 0.1797262877225875 | 0.0056200455874204 | 0.3286020457744598 | 0.1946303397417068 | 0.0031740767881274 | 0.2826756834983825 | -0.2816643174737692 | 2.2075696331448853 | -1.664157864637673 | 1.664157864637673 | 0.0223504365421831 | -0.0223504365421831 | -1.6429263846948745 | 1.6429263846948745 | 1.4486536048352718 | 0.7589160283096135 | 1.4486536048352718 | 0.7589160283096135 | -0.8840103563852608 | 0.8840103563852608 | -0.7589160283096135 | 0.7589160283096135 | -0.8840103563852608 | 0.8840103563852608 | -0.7589160283096135 | 0.7589160283096135 | 0.3931482136249542 | 0.6068517863750458 | 0.6068517863750458 | 0.3931482136249542 | 0.0687499940395355 | 0.5381017923355103 | 0.4618982076644897 | 0.5713565945625305 | 0.4286434054374695 | 0.0061154663562774 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 132 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | ARI | 55 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 797 | 1697 | 3497 | Half1 | 1 | 1 | 1 | 13:17 | ARI 45 | 10 | 53 | (13:17) (Shotgun) D.Anderson pass short right to T.Hightower pushed ob at STL 38 for 17 yards (O.Atogwe). | pass | 17 | 1 | 1 | short | right | 17 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0052418964914977 | 0.1084467321634292 | 0.0023570184130221 | 0.1987703591585159 | 0.2813804447650909 | 0.0046828505583107 | 0.3991207182407379 | 1.925905315671116 | 1.3444025344215331 | -3.0085603990592062 | 3.0085603990592062 | 0.0223504365421831 | -0.0223504365421831 | -2.987328919116408 | 2.987328919116408 | -0.4718651128932833 | 1.8162676473148167 | -0.4718651128932833 | 1.8162676473148167 | -0.4121452434919774 | 0.4121452434919774 | -2.57518367562443 | 2.57518367562443 | -0.4121452434919774 | 0.4121452434919774 | -2.57518367562443 | 2.57518367562443 | 0.4618982076644897 | 0.5381017923355103 | 0.5381017923355103 | 0.4618982076644897 | 0.0360276103019714 | 0.5020741820335388 | 0.4979258179664612 | 0.6393770575523376 | 0.3606229424476623 | 0.0061154663562774 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 156 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | LA | 38 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 772 | 1672 | 3472 | Half1 | 1 | 1 | 1 | 12:52 | LA 38 | 10 | 53 | (12:52) T.Hightower left guard to STL 36 for 2 yards (J.Laurinaitis). | run | 2 | nan | nan | left | guard | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0039252019487321 | 0.0638463944196701 | 0.0016181217506527 | 0.1164251342415809 | 0.3495897352695465 | 0.0041755875572562 | 0.4604198336601257 | 3.270307850092649 | -0.343897320330143 | -2.6646630787290637 | 2.6646630787290637 | 0.3662477568723261 | -0.3662477568723261 | -2.987328919116408 | 2.987328919116408 | -0.4121452434919774 | 0.4121452434919774 | -2.57518367562443 | 2.57518367562443 | -0.4121452434919774 | 0.4121452434919774 | -2.57518367562443 | 2.57518367562443 | 0.4979258179664612 | 0.5020741820335388 | 0.5020741820335388 | 0.4979258179664612 | -0.0112190544605255 | 0.5132932364940643 | 0.4867067635059356 | 0.6618973612785339 | 0.338102638721466 | 0.0173345208168029 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 177 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | LA | 36 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 727 | 1627 | 3427 | Half1 | 1 | 1 | 2 | 12:07 | LA 36 | 8 | 53 | (12:07) (Shotgun) D.Anderson pass short right to S.Breaston to STL 24 for 12 yards (O.Atogwe). | pass | 12 | 1 | 1 | short | right | 12 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0036565070040524 | 0.0709501132369041 | 0.0015830115880817 | 0.1242964044213295 | 0.3920016884803772 | 0.0032178198453038 | 0.4042944312095642 | 2.9264105297625065 | 1.4389680766034871 | -4.10363115533255 | 4.10363115533255 | 0.3662477568723261 | -0.3662477568723261 | -4.426296995719895 | 4.426296995719895 | 1.4389680766034871 | 1.4389680766034871 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | 0.4867067635059356 | 0.5132932364940643 | 0.5132932364940643 | 0.4867067635059356 | 0.0541771948337554 | 0.4591160416603088 | 0.5408839583396912 | 0.6517181396484375 | 0.3482818603515625 | 0.0173345208168029 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 201 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | LA | 24 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 701 | 1601 | 3401 | Half1 | 1 | 1 | 1 | 11:41 | LA 24 | 10 | 53 | (11:41) (Shotgun) T.Hightower right tackle to STL 22 for 2 yards (J.King). | run | 2 | 1 | nan | nan | right | tackle | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0022339082788676 | 0.0296287164092063 | 0.001217441749759 | 0.0461628213524818 | 0.4147163331508636 | 0.0013190319295972 | 0.5047217607498169 | 4.365378606365994 | -0.3690556068904698 | -3.7345755484420806 | 3.7345755484420806 | 0.7353033637627959 | -0.7353033637627959 | -4.426296995719895 | 4.426296995719895 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | 0.5408839583396912 | 0.4591160416603088 | 0.4591160416603088 | 0.5408839583396912 | -0.0011568069458007 | 0.4602728486061096 | 0.5397271513938904 | 0.7210303544998169 | 0.2789696455001831 | 0.0184913277626037 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 222 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | ARI | away | LA | LA | 22 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 663 | 1563 | 3363 | Half1 | 1 | 1 | 2 | 11:03 | LA 22 | 8 | 53 | (11:03) T.Hightower left tackle to STL 21 for 1 yard (O.Atogwe). FUMBLES (O.Atogwe), RECOVERED by STL-B.Fletcher at STL 25. B.Fletcher to ARI 32 for 43 yards (S.Breaston). | run | -3 | nan | nan | left | tackle | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0024161306209862 | 0.0330387130379676 | 0.0010480715427547 | 0.0500300899147987 | 0.4849932491779327 | 0.0013099570060148 | 0.4271637499332428 | 3.996322999475524 | -8.031045242212713 | 4.296469693770632 | -4.296469693770632 | 8.766348605975509 | -8.766348605975509 | -4.426296995719895 | 4.426296995719895 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | -1.8511133200954648 | 1.8511133200954648 | -2.57518367562443 | 2.57518367562443 | 0.5397271513938904 | 0.4602728486061096 | 0.4602728486061096 | 0.5397271513938904 | -0.240679383277893 | 0.7009522318840027 | 0.2990477681159973 | 0.6929000020027161 | 0.3070999979972839 | 0.2591707110404968 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 254 | 2010_01_ARI_STL | 2010091208 | LA | ARI | REG | 1 | LA | home | ARI | ARI | 32 | Sun Sep 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time) | 650 | 1550 | 3350 | Half1 | 2 | 1 | 1 | 10:50 | ARI 32 | 10 | 16 | (10:50) S.Bradford pass short left to M.Clayton ran ob at ARI 19 for 13 yards (G.Toler). | pass | 13 | 1 | short | left | 13 | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0032918280921876 | 0.048256404697895 | 0.0009922700701281428 | 0.0691642686724662 | 0.3664377629756927 | 0.0033379383385181 | 0.5085195302963257 | 4.034722242737189 | 0.7701444479171187 | 5.066614141687751 | -5.066614141687751 | 8.766348605975509 | -8.766348605975509 | -3.656152547802776 | 3.656152547802776 | 0.7701444479171187 | 0.7701444479171187 | -1.080968872178346 | 1.080968872178346 | -2.57518367562443 | 2.57518367562443 | -1.080968872178346 | 1.080968872178346 | -2.57518367562443 | 2.57518367562443 | 0.7009522318840027 | 0.2990477681159973 | 0.7009522318840027 | 0.2990477681159973 | 0.0128467082977294 | 0.7137989401817322 | 0.2862010598182678 | 0.5155680775642395 | 0.5155680775642395 | 0.2591707110404968 |
CREATE TABLE play_by_play_2010 (
"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
);