Nflfastr
NFL play-by-play data since 1999
@kaggle.benbaldwin_nflfastr
Play By Play 2002
@kaggle.benbaldwin_nflfastr.play_by_play_2002
- 13.85 MB
- 47819 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | ARI | 30 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 900 | 1800 | 3600 | Half1 | 1 | 1 | 15:00 | ARI 30 | 49 | B.Gramatica kicks 59 yards from ARI 30 to WAS 11. K.Watson to WAS 33 for 22 yards (M.Stone). | kickoff | nan | nan | nan | nan | 59 | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0083952294662594 | 0.1755823940038681 | 0.0042135813273489 | 0.2452274560928344 | 0.219468668103218 | 0.0039334157481789 | 0.3431792855262756 | 0.8167612971737981 | 0.9299734979867936 | 0.9299734979867936 | -0.9299734979867936 | 0.0003553012211341411 | 0.999644698778866 | 0.0003553012211341411 | 0.999644698778866 | 0.5688331147830468 | 0.5691884160041809 | 0.4308115839958191 | 0.0010145897977054 | 0.0010145897977054 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 57 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | WAS | 67 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 894 | 1794 | 3594 | Half1 | 1 | 1 | 1 | 14:54 | WAS 33 | 10 | 49 | (14:54) S.Davis right tackle to WAS 34 for 1 yard (M.Bell). | run | 1 | nan | right | tackle | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0085072023794054 | 0.1384852528572082 | 0.0023347088135778 | 0.1980808824300766 | 0.2480597198009491 | 0.0044956961646676 | 0.4000365138053894 | 1.7467347951605916 | -0.4323924952186644 | 0.4975810027681291 | -0.4975810027681291 | -0.4323924952186644 | 0.4323924952186644 | 0.5691884160041809 | 0.4308115839958191 | 0.5691884160041809 | 0.4308115839958191 | -0.0113489627838134 | 0.5578394532203674 | 0.4421605467796325 | 0.7055660486221313 | 0.7055660486221313 | -0.0113489627838134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 78 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | WAS | 66 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 855 | 1755 | 3555 | Half1 | 1 | 1 | 2 | 14:15 | WAS 34 | 9 | 49 | (14:15) S.Matthews pass to S.Davis to WAS 41 for 7 yards (R.Davis). | pass | 7 | 1 | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0098143136128783 | 0.1497152894735336 | 0.0023043432738631 | 0.2194333672523498 | 0.2508800327777862 | 0.0046956492587924 | 0.3631570041179657 | 1.3143422999419272 | 0.3384979628026485 | 0.8360789655707777 | -0.8360789655707777 | -0.4323924952186644 | 0.4323924952186644 | 0.3384979628026485 | -0.3384979628026485 | 0.5578394532203674 | 0.4421605467796325 | 0.5578394532203674 | 0.4421605467796325 | 0.0161696672439575 | 0.574009120464325 | 0.425990879535675 | 0.6905202269554138 | 0.6905202269554138 | -0.0113489627838134 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 99 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | WAS | 59 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 824 | 1724 | 3524 | Half1 | 1 | 1 | 3 | 13:44 | WAS 41 | 2 | 49 | (13:44) S.Davis right tackle to WAS 45 for 4 yards (M.Bell). | run | 4 | nan | right | tackle | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.010108976624906 | 0.1434338390827179 | 0.002148667583242 | 0.2034546434879303 | 0.2363811582326889 | 0.0057662329636514 | 0.3987065255641937 | 1.6528402627445755 | 0.8843899688217789 | 1.7204689343925563 | -1.7204689343925563 | 0.4519974736031145 | -0.4519974736031145 | 0.3384979628026485 | -0.3384979628026485 | 0.574009120464325 | 0.425990879535675 | 0.574009120464325 | 0.425990879535675 | 0.0173963904380798 | 0.5914055109024048 | 0.4085944890975952 | 0.6986002326011658 | 0.6986002326011658 | 0.0060474276542663 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 120 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | WAS | 55 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 790 | 1690 | 3490 | Half1 | 1 | 1 | 1 | 13:10 | WAS 45 | 10 | 49 | (13:10) S.Davis up the middle to WAS 47 for 2 yards (R.McKinnon; M.Bell). | run | 2 | nan | middle | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0096773020923137 | 0.1056130602955818 | 0.0017239969456568 | 0.1568827629089355 | 0.2753851413726806 | 0.0050964877009391 | 0.4456211924552917 | 2.537230231566354 | -0.3803584012202918 | 1.3401105331722647 | -1.3401105331722647 | 0.0716390723828226 | -0.0716390723828226 | 0.3384979628026485 | -0.3384979628026485 | 0.5914055109024048 | 0.4085944890975952 | 0.5914055109024048 | 0.4085944890975952 | -0.0239062309265136 | 0.5674992799758911 | 0.4325007200241089 | 0.6968090534210205 | 0.6968090534210205 | -0.0178588032722473 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 141 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | WAS | 53 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 759 | 1659 | 3459 | Half1 | 1 | 1 | 2 | 12:39 | WAS 47 | 8 | 49 | (12:39) S.Matthews pass to D.Thompson to ARI 39 for 14 yards (K.Lassiter). | pass | 14 | 1 | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.009992423467338 | 0.1144457384943962 | 0.0017894868506118 | 0.1757116615772247 | 0.2809556722640991 | 0.0057665384374558 | 0.4113385081291199 | 2.156871830346063 | 1.2938098548911512 | 2.633920388063416 | -2.633920388063416 | 0.0716390723828226 | -0.0716390723828226 | 1.6323078176937995 | -1.6323078176937995 | 0.5674992799758911 | 0.4325007200241089 | 0.5674992799758911 | 0.4325007200241089 | 0.0430759191513061 | 0.6105751991271973 | 0.3894248008728027 | 0.6965204477310181 | 0.6965204477310181 | -0.0178588032722473 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 162 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | ARI | 39 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 710 | 1610 | 3410 | Half1 | 1 | 1 | 1 | 11:50 | ARI 39 | 10 | 49 | (11:50) S.Matthews pass to R.Gardner to ARI 33 for 6 yards (D.Barrett; R.Davis). | pass | 6 | 1 | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0095875253900885 | 0.0667344108223915 | 0.0012442433508113 | 0.1073526218533515 | 0.3193182349205017 | 0.0046906950883567 | 0.4910722374916076 | 3.450681685237214 | 0.1953856002073735 | 2.8293059882707894 | -2.8293059882707894 | 0.0716390723828226 | -0.0716390723828226 | 1.8276934179011728 | -1.8276934179011728 | 0.6105751991271973 | 0.3894248008728027 | 0.6105751991271973 | 0.3894248008728027 | 0.0059574246406555 | 0.6165326237678528 | 0.3834673762321472 | 0.7333900332450867 | 0.7333900332450867 | -0.0178588032722473 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 183 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | ARI | 33 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 681 | 1581 | 3381 | Half1 | 1 | 1 | 2 | 11:21 | ARI 33 | 4 | 49 | (11:21) S.Davis up the middle to ARI 31 for 2 yards (R.McKinnon). | run | 2 | nan | middle | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0086070448160171 | 0.0565378330647945 | 0.0010313438251614 | 0.0927284732460975 | 0.3524577021598816 | 0.0021987927611917 | 0.4864388704299927 | 3.646067285444588 | -0.3693756730062887 | 2.4599303152645007 | -2.4599303152645007 | -0.2977366006234661 | 0.2977366006234661 | 1.8276934179011728 | -1.8276934179011728 | 0.6165326237678528 | 0.3834673762321472 | 0.6165326237678528 | 0.3834673762321472 | -0.0059134364128112 | 0.6106191873550415 | 0.3893808126449585 | 0.741351306438446 | 0.741351306438446 | -0.0237722396850585 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 204 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | ARI | 31 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 647 | 1547 | 3347 | Half1 | 1 | 1 | 3 | 10:47 | ARI 31 | 2 | 49 | (10:47) S.Davis right end to ARI 26 for 5 yards (R.McKinnon). | run | 5 | nan | right | end | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0083915069699287 | 0.0652556717395782 | 0.0008335264283232391 | 0.1037564873695373 | 0.3861912488937378 | 0.0014307633973658 | 0.4341408312320709 | 3.2766916124382988 | 0.8918724172981456 | 3.3518027325626463 | -3.3518027325626463 | 0.5941358166746795 | -0.5941358166746795 | 1.8276934179011728 | -1.8276934179011728 | 0.6106191873550415 | 0.3893808126449585 | 0.6106191873550415 | 0.3893808126449585 | 0.01616632938385 | 0.6267855167388916 | 0.3732144832611084 | 0.7385832071304321 | 0.7385832071304321 | -0.0076059103012084 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 225 | 2002_01_ARI_WAS | 2002090800 | WAS | ARI | REG | 1 | WAS | home | ARI | ARI | 26 | Sun Sep 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 611 | 1511 | 3311 | Half1 | 1 | 1 | 1 | 10:11 | ARI 26 | 10 | 49 | (10:11) S.Matthews pass to S.Davis to ARI 20 for 6 yards (R.Fredrickson; R.McKinnon). | pass | 6 | 1 | nan | nan | nan | nan | nan | nan | 3 | 3 | nan | nan | 3 | 3 | 0.0059991958551108 | 0.0385504588484764 | 0.0007431640988215804 | 0.0619660206139087 | 0.3808303475379944 | 0.0012805431615561 | 0.5106302499771118 | 4.168564029736444 | 0.2270296637434512 | 3.578832396306097 | -3.578832396306097 | 0.5941358166746795 | -0.5941358166746795 | 2.0547230816446245 | -2.0547230816446245 | 0.6267855167388916 | 0.3732144832611084 | 0.6267855167388916 | 0.3732144832611084 | 0.0132979750633239 | 0.6400834918022156 | 0.3599165081977844 | 0.7729571461677551 | 0.7729571461677551 | -0.0076059103012084 |
CREATE TABLE play_by_play_2002 (
"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" VARCHAR,
"yards_after_catch" VARCHAR,
"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" VARCHAR,
"yac_epa" VARCHAR,
"comp_air_epa" VARCHAR,
"comp_yac_epa" VARCHAR,
"total_home_comp_air_epa" VARCHAR,
"total_away_comp_air_epa" VARCHAR,
"total_home_comp_yac_epa" VARCHAR,
"total_away_comp_yac_epa" VARCHAR,
"total_home_raw_air_epa" VARCHAR,
"total_away_raw_air_epa" VARCHAR,
"total_home_raw_yac_epa" VARCHAR,
"total_away_raw_yac_epa" VARCHAR,
"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
);