Data Preparation Procedures

This page provides information on data preparation for using QuickStatement.

Procedures vary based on the year that a game occurred.

IMPORTANT: Before creating an Item page, be to to search to be sure it doesn't already exist!

PRELIMINARY STEPS

1. Make sure a season page exists for each team participating in the game: Indexing a Football Team Season
2. Creating an item page for a game: Indexing a Football Game

DATA PREPARATION PROCEDURES

1. Spreadsheet preparation procedures - downloading and initializing spreadsheets based on time period within which each game occurred
   1. Preparing Spreadsheets (2014 to Present): For games occurring from 2014 to present
   2. Preparing Spreadsheets (2001 to 2013): For games occurring from 2001 to 2013
   3. Preparing Spreadsheets (Transcribed Games): For for games occurring prior to 2001 (transcribed spreadsheets)
   4. Preparing Spreadsheets (Historical Games): For historical games drawn from newspaper accounts (for games lacking extant play-by-play data)

1. Drive Data Preparation and Upload Procedures

Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:

1. 1. Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: Drive Creation Procedure
   2. Create spreadsheet to populate data about each drive's (now) existing item page: Drive Data Preparation
2. Play-by-play Data Preparation and Upload Procedures