Play Indexing
Jump to navigation
Jump to search
- For games having JSON data source (that is, having a record of every drive and every play)
- Prepare spreadsheet by adding Drive sequence numbers in column BA, play sequence numbers in column BB, and play sequence number relative to each drive in BC
- Do not include KOs as a drive
- End of periods, end of halfs, end of games, and timeouts are not counted as plays in either game or drive play sequences
- Drive-related Properties
- Instance of (P17) (instance of American Football Drive}
- Occurring in Game (P39)
- Sequential Number of Drive in Game (P35)
- Team on Offense (P24)
- Team on Defense (P25)
- Occurring in Game Period (P8)
- Game Clock Display at Start (P34)
- Has Starting Yard Line (P13)
- Drive Result (P33)
- Length of Drive in Yards (P26)
- Length of Drive Elapsed Time (P27) (convert to seconds)
- Length of Drive in Number of Plays (P28)
- Play-related Properties
- Instance of (P17) (instance of Time Segment}
- Instance of (P17) (instance of American Football Play}
- Sequential Number of Play in Game (P19)
- Sequential Number of Play in Current Drive (P36)
- Has Point in Time (P9) - copy and paste "xxxx-xx-xx" portion of spreadsheet data from each BT cell in spreadsheet
- Qualify with Wall Clock Display at Start (P37) by copying the Txx:xx:xxZ" portion of the data from each BT cell in spreadsheet
- Home Team Score at Start of Play (P10)
- Away Team Score at Start of Play (P11)
- Team on Offense (P24)
- Team on Defense (P25)
- Occurring in Game Period (P8)
- Game Clock Display at Start (P34)
- Has Down Type (P15)
- Has Starting Yard Line (P13)
- Yards to go for First Down (P14)
- Textual Description of Play Outcome (P20)
- Type of Play (P16)
- Yardage Resulting from Play Outcome (P38)
- Scoring Result of Play (P6)
- Prepare spreadsheet by adding Drive sequence numbers in column BA, play sequence numbers in column BB, and play sequence number relative to each drive in BC