Data Preparation Procedures - Revision history

Admin at 20:05, 28 January 2019

2019-01-28T20:05:15Z

Admin at 19:21, 17 January 2019

2019-01-17T19:21:59Z

Admin at 19:21, 17 January 2019

2019-01-17T19:21:08Z

Admin at 16:01, 21 December 2018

2018-12-21T16:01:47Z

Admin: /* PROCEDURES */

2018-12-21T16:00:58Z

PROCEDURES

Admin: /* Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts) */

2018-12-21T15:48:59Z

Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts)

Admin: /* Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts) */

2018-12-21T15:48:28Z

Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts)

Admin: /* Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts) */

2018-12-21T15:43:20Z

Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts)

Admin: /* Category 2 Games (with play-by-play data sources requiring transcribing) */

2018-12-21T15:31:11Z

Category 2 Games (with play-by-play data sources requiring transcribing)

Admin: /* Category 1 Games (with available JSON-encoded play-by-play data sources - 2001 to present) */

2018-12-21T15:30:19Z

Category 1 Games (with available JSON-encoded play-by-play data sources - 2001 to present)

@@ Line 21: / Line 21: @@
 IMPORTANT: Need to first download and install a JSON to CSV converter from https://json-csv.en.softonic.com/download
-# Games 2014 to present (JSON files with wall clock data):
+# Games '''2016''' to present (JSON files with wall clock data):
 ## '''[[Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## '''[[Preparing Drive Creation Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## '''[[Preparing Drive Data Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## Further preparation procedures to come later, including for player participation data (draft version available: [[Player Indexing]])

@@ Line 10: / Line 10: @@
 # 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 ===
@@ Line 19: / Line 18: @@
 Football games in this category occurred 2001 to present and have JSON-encoded play-by-play data sources. This category further subdivides based on the availability of wall clock data for each play (games occurring 2014 to present).
 # Games 2014 to present (JSON files with wall clock data):

@@ Line 10: / Line 10: @@
 # 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 ===

@@ Line 25: / Line 25: @@
 ## '''[[Preparing Play Creation Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2014 to Present]]'''
-## Further preparation procedures to come later, including for player participation data (draft available: [[Player Indexing]]
+## Further preparation procedures to come later, including for player participation data (draft version available: [[Player Indexing]])
 # Games 2001 to 2013 (JSON files without wall clock data):
 ## '''[[Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2001 to 2013]]'''
@@ Line 32: / Line 32: @@
 ## '''[[Preparing Play Creation Spreadsheets for Category 1 Games 2001 to 2013]]'''
 ## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2001 to 2013]]'''
-## Further preparation procedures to come later, including for player participation data
+## Further preparation procedures to come later, including for player participation data (draft version available: [[Player Indexing]])
 ==== Category 2 Games (with play-by-play data sources requiring transcribing) ====
@@ Line 43: / Line 43: @@
 # '''[[Preparing Play Creation Spreadsheets for Category 2 Games]]'''
 # '''[[Preparing Play-by-play Data Spreadsheets for Category 2 Games]]'''
-# Further preparation procedures to come later, including for player participation data
+# Further preparation procedures to come later, including for player participation data (draft version available: [[Player Indexing]])
 ==== Category 3 Games (with play-by-play data requiring reconstruction from newspaper accounts) ====
@@ Line 54: / Line 54: @@
 # '''[[Preparing Play Creation Spreadsheets for Category 3 Games]]'''
 # '''[[Preparing Play-by-play Data Spreadsheets for Category 3 Games]]'''
-# Further preparation procedures to come later, including for player participation data
+# Further preparation procedures to come later, including for player participation data (draft version available: [[Player Indexing]])
 Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:

@@ Line 25: / Line 25: @@
 ## '''[[Preparing Play Creation Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2014 to Present]]'''
-## Further preparation procedures to come later, including for player participation data
+## Further preparation procedures to come later, including for player participation data (draft available: [[Player Indexing]]
 # Games 2001 to 2013 (JSON files without wall clock data):
 ## '''[[Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2001 to 2013]]'''

@@ Line 49: / Line 49: @@
 Football games in this category occurred prior to 2001 and do not have any play-by-play data sources other than newspaper game accounts that require transcribing to spreadsheets.
-# '''[[Data Gathering, Transcribing Steps and Initial Prepping of Spreadsheets for Category 3 Games]]'''
+# '''[[Data Gathering, Transcribing Steps, and Initial Prepping of Spreadsheets for Category 3 Games]]'''
 # '''[[Preparing Drive Creation Spreadsheets for Category 3 Games]]'''
 # '''[[Preparing Drive Data Spreadsheets for Category 3 Games]]'''

@@ Line 49: / Line 49: @@
 Football games in this category occurred prior to 2001 and do not have any play-by-play data sources other than newspaper game accounts that require transcribing to spreadsheets.
-# '''[[Preparing Spreadsheets for Historical Games]]'''
+# '''[[Preparing Spreadsheets for Category 3 Games]]'''
-# '''[[Preparing Drive Creation Spreadsheets for Historical Games]]'''
+# '''[[Preparing Drive Creation Spreadsheets for Category 3 Games]]'''
 # '''[[Preparing Drive Data Spreadsheets for Historical Games]]'''
 # '''[[Preparing Play Creation Spreadsheets for Historical Games]]'''

@@ Line 38: / Line 38: @@
 Football games in this category occurred prior to 2001 and have paper-based play-by-play data sources that require transcribing to spreadsheets.
-# '''[[Transcribing Steps and Initial Prepping of Spreadsheets for Transcribed Games]]'''
+# '''[[Transcribing Steps and Initial Prepping of Spreadsheets for Category 2 Games]]'''
-# '''[[Preparing Drive Creation Spreadsheets for Transcribed Games]]'''
+# '''[[Preparing Drive Creation Spreadsheets for Category 2 Games]]'''
-# '''[[Preparing Drive Data Spreadsheets for Transcribed Games]]'''
+# '''[[Preparing Drive Data Spreadsheets for Category 2 Games]]'''
-# '''[[Preparing Play Creation Spreadsheets for Transcribed Games]]'''
+# '''[[Preparing Play Creation Spreadsheets for Category 2 Games]]'''
-# '''[[Preparing Play-by-play Data Spreadsheets for Transcribed Games]]'''
+# '''[[Preparing Play-by-play Data Spreadsheets for Category 2 Games]]'''
 # Further preparation procedures to come later, including for player participation data

@@ Line 20: / Line 20: @@
 # Games 2014 to present (JSON files with wall clock data):
-## '''[[Downloading and Initial Prepping of Spreadsheets for Games 2014 to Present]]'''
+## '''[[Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2014 to Present]]'''
-## '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]'''
+## '''[[Preparing Drive Creation Spreadsheets for Category 1 Games 2014 to Present]]'''
-## '''[[Preparing Drive Data Spreadsheets for Games 2014 to Present]]'''
+## '''[[Preparing Drive Data Spreadsheets for Category 1 Games 2014 to Present]]'''
-## '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]'''
+## '''[[Preparing Play Creation Spreadsheets for Category 1 Games 2014 to Present]]'''
-## '''[[Preparing Play-by-play Data Spreadsheets for Games 2014 to Present]]'''
+## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2014 to Present]]'''
 ## Further preparation procedures to come later, including for player participation data
 # Games 2001 to 2013 (JSON files without wall clock data):
-## '''[[Downloading and Initial Prepping of Spreadsheets for Games 2001 to 2013]]'''
+## '''[[Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2001 to 2013]]'''
-## '''[[Preparing Drive Creation Spreadsheets for Games 2001 to 2013]]'''
+## '''[[Preparing Drive Creation Spreadsheets for Category 1 Games 2001 to 2013]]'''
-## '''[[Preparing Drive Data Spreadsheets for Games 2001 to 2013]]'''
+## '''[[Preparing Drive Data Spreadsheets for Category 1 Games 2001 to 2013]]'''
-## '''[[Preparing Play Creation Spreadsheets for Games 2001 to 2013]]'''
+## '''[[Preparing Play Creation Spreadsheets for Category 1 Games 2001 to 2013]]'''
-## '''[[Preparing Play-by-play Data Spreadsheets for Games 2001 to 2013]]'''
+## '''[[Preparing Play-by-play Data Spreadsheets for Category 1 Games 2001 to 2013]]'''
 ## Further preparation procedures to come later, including for player participation data