Difference between revisions of "Data Preparation Procedures"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
− | === | + | === PROCEDURES === |
Spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred | Spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred | ||
Line 16: | Line 16: | ||
==== Category 1 Games ==== | ==== Category 1 Games ==== | ||
− | + | Football games in this category span the 2001 to present time period and have JSON-encoded play-by-play data sources. This category further subdivides based on the availability of wall clock data for each play (2014 to present). | |
## '''[[Preparing Spreadsheets for Games 2014 to Present]]''' (with wall clock data) | ## '''[[Preparing Spreadsheets for Games 2014 to Present]]''' (with wall clock data) |
Revision as of 14:50, 21 December 2018
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
- Make sure a season page exists for each team participating in the game: Indexing a Football Team Season
- Creating an item page for a game: Indexing a Football Game
PROCEDURES
Spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred
Category 1 Games
Football games in this category span the 2001 to present time period and have JSON-encoded play-by-play data sources. This category further subdivides based on the availability of wall clock data for each play (2014 to present).
- Preparing Spreadsheets for Games 2014 to Present (with wall clock data)
- Preparing Spreadsheets for Games 2001 to 2013 (no wall clock data)
- Preparing Spreadsheets for Transcribed Games (that is, games with transcribed play-by-play data sources)
- Preparing Spreadsheets for Historical Games (that is, games without play-by-play data sources)
- Drive data preparation and upload procedures
- Drive creation
- Drive data
- Play-by-play data preparation and upload procedures
- Play creation
- Play-by-play data
Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:
- Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: Drive Creation Procedure
- Create spreadsheet to populate data about each drive's (now) existing item page: Drive Data Preparation
- Play-by-play Data Preparation and Upload Procedures