Statistics/sandbox

Mad is using this sandbox to review a variety of ways data can be imported from the DDSPF2021 MDB file (via MySQL) into meaningful information for the Wiki.

Roster
Pos	#	Name	Species/College	Ht (in)	Wt (lbs)	Yrs
QB	2	Lezra Astrah	Dragon / Braylor	72	250	4
K	10	Thalia Perez	Bear / SFU	68	150	7
QB	11	Gregory Russell	Coyote / Pred Tech	78	234	5
P	14	Rodger Blackman	Dog-Neapolitan Mastiff	73	210	13
WR	17	Zeke Carmichael	Kingfisher / Baltimore Bay	73	190	12
QB	19	Darius Smith	African Wild Dog / Forest Park	74	205	7
RB	23	Ellsworth Starr	Swallow-Tree / Harvaardwak	72	195	7
SS	24	Marigold Wu	Tibetan Sand Fox - University of California - Santa Bearba	72	210	2
RB	27	Steven Durand	Wolverine / Gambling State	71	194	2
RB	32	Willy Redman	Marlin-Blue / Florida Aquatic	70	218	1
CB	33	Julius Stafford	Canary / Oriole Robin	72	196	10
CB	33	Uka Nakoyak	Alaska Hare / Lapine State University	72	190	2
SS	34	Everett Simms	Crow / DE Anthro	72	150	7
FB	36	Hiroshige Neo	Japanese Serow - UW - Farmside	70	244	2
CB	36	Tina Gaye	Penn State	74	222	0
FS	37	Patrice Bush	Civet-African Palm / West La.	76	226	10
FS	38	Chi Lim	Tennessee	72	184	4
SS	43	John Pressley	Panther-Black / Savannah River	73	191	1
LB	43	Elliot Brisette	Dog, American Pitbull Terrier / UA Laval	76	260	0
FS	44	Quincy Doss	Dog -Canaan / CT Canid	73	230	11
RB	45	Jean-Étienne Tremblay	Bear-Brown / UA Laval	76	255	5
LB	51	Erick Farmer	Dog- Chihuahua	69	226	7
C	51	Kyle Sykes	Turtle / Josephtown	75	319	1
T	52	Ralph Razortusk	Boar / Longhorn State	80	315	0
LB	54	Toby Otternator	Otter-NA River / Otterville	73	265	7
LB	54	Julian Coronado	Jaguar - Wissota	75	253	2
DT	54	Fortuna Angulu	Oryx-Scimitar / Gem State	75	277	1
LB	58	Bennie Sierra	Horse-Miniature / Iowa College	71	241	9
LB	59	Harlan Freeman	Pika- American	72	245	11
C	60	Sam Zapata	Hare-Grey / Lapine State	75	260	7
DT	62	Brandon Whitaker	West Texas A&M	73	273	0
G	62	Torry Greco	Missouri	73	274	0
DE	63	Billy-Bob Robertson	Pig / Appalachian Ungulate	75	235	0
DT	66	Ralph Cano	Lizard - Cope's Leopard	76	302	14
DE	67	Jamarcus Triper	Zebra - Braylor	75	275	2
DT	68	Nathan Mills	Tiger-White / CSUF	76	290	3
T	69	Sal Darden	Leopard - Snow	75	270	8
G	72	Otis Benitez	Cow / Western Illinois	74	300	9
T	73	Leroy Wilcox	Air Force	74	315	3
G	74	Edison Schroeder	Pied Tamarin / Appalachian Mammal	71	285	10
G	77	Tomas Steiger	Dog (White Schnauzer) - Pittsburgh Anthropomorphic College	75	328	2
WR	81	Aaron Ragland	Otter - River	75	210	9
TE	82	Lucie Damphousse	Otter / UA Laval	74	185	4
TE	83	Byrus Downey	Porcupine / MN's West	72	235	9
WR	84	Mtendere Idowu	Antelope / Oglethorpe	73	193	1
WR	85	Ricky Mitchell	Iguana - Gray's Spiny-tailed	74	195	10
WR	87	Eddie Halstead	California	73	182	0
WR	89	Nicholas Baker	Jacksonville FL	74	212	1
DE	99	J.J. White	Shark- Tiger	77	288	5

IMPORTING PLAYER RECORDS

Records
Record ID	Week	Season	Team	Versus	Value
1	16	2019	8	5	28
2	9	2021	2	15	100
4	14	2015	8	9	444
5	14	2015	8	9	5
3	6	2016	8	10	3
6	10	2018	8	6	150
7	8	2016	8	12	87
0	16	2019	8	5	43
5	0	2019	8	0	26
7	0	2016	8	0	87
6	0	2018	8	0	97
3	0	2016	8	0	14
4	0	2015	8	0	3955
2	0	2016	8	0	63
1	0	2015	8	0	322
0	0	2015	8	0	532
0	0	2015	8	5	40
1	0	2015	8	9	27
2	0	2015	8	12	72
4	0	2015	8	12	523
5	0	2015	8	9	4
3	0	2015	8	5	2
6	0	2015	8	9	128
7	0	2015	8	12	98

Issues: - Convert/teamid is not working on the TeamID and VsTeamID columns - I do not know yet how to make the RecordID field meaningful (each number corresponds to a record type, and it may change depending on player position)