Statistics/sandbox: Difference between revisions
From UFFL Wiki
m (may be an extension issue with calling views) |
mNo edit summary |
||
| Line 4: | Line 4: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=ufflData | db=ufflData | ||
|from= | |from=LeagueRecords | ||
|limit=50 | |limit=50 | ||
|data=recordName= | |where= RecordType = '0' | ||
|data=recordName=RecordID,season=Season,week=Week,name=PlayerID,playerTeam=TeamID,vsTeam=VsTeamID,recordValue=RecordValue | |||
}} | }} | ||
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | {| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable" | ||
Revision as of 01:04, 29 January 2021
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.
| UFFL Game Records | ||||||
|---|---|---|---|---|---|---|
| Record Name | Season | Week | Player | Team | Versus | Record |
|
Passing Attempts |
2019 | 1 | Darius Smith | Chicago Outlaws | New Orleans Corsairs | 52 |
|
Passing Completions |
2021 | 7 | Kiedo Masquarde | Nashville Tuts | California Dons | 37 |
|
Pass Completion % |
2015 | 5 | Michelle Housley | North Florida Renegades | New York Titans | 100 |
|
Passing Interceptions |
2017 | 10 | Terence Curran | Grand Rapids Dragons | Montreal Royal | 6 |
|
Passing Yards |
2015 | 14 | Aspen Redfield | Baltimore Ponies | California Dons | 444 |
|
Passing Touchdowns |
2015 | 12 | Darius Smith | Chicago Outlaws | Downriver Waves | 5 |
|
Passing Rating |
2017 | 4 | Nigel Seals | Chicago Outlaws | Texas Ramblers | 158.3 |
|
Longest Pass |
2021 | 7 | Andrew Calder | Texas Ramblers | Fargo Axemen | 97 |
|
Rushing Attempts |
2017 | 12 | Bernard Randolph | Fargo Axemen | Grand Rapids Dragons | 38 |
|
Rushing Yards |
2021 | 13 | Carrice Kenton | Texas Ramblers | Downriver Waves | 254 |
|
Rushing Touchdowns |
2017 | 11 | Tyler Wirl | New York Titans | New Orleans Corsairs | 4 |
|
Longest Run |
2019 | 9 | Adam Nelson | Fargo Axemen | Downriver Waves | 95 |
|
Catches |
2015 | 2 | Delph Adler | Easton Bald Eagles | Fargo Axemen | 10 |
|
Receiving Yards |
2019 | 14 | Artemis Milano | Texas Ramblers | California Dons | 162 |
|
Receiving Touchdowns |
2015 | 12 | Ricky Mitchell | Chicago Outlaws | Downriver Waves | 3 |
|
Longest Catch |
2021 | 7 | Artemis Milano | Texas Ramblers | Fargo Axemen | 97 |
|
Fumbles |
2015 | 10 | Michelle Housley | North Florida Renegades | Easton Bald Eagles | 4 |
|
Fumbles Lost |
2015 | 3 | Joe Bowers | California Dons | Baltimore Ponies | 3 |
|
Interceptions |
2016 | 11 | Milford Hope | Downriver Waves | Chicago Outlaws | 3 |
|
Interception Return Yards |
2019 | 10 | Derrick Overton | Texas Ramblers | Baltimore Ponies | 100 |
|
Tackles |
2016 | 13 | Kelley Rowe | Las Vegas Bandits | North Florida Renegades | 18 |
|
Sacks |
2016 | 13 | J.J. White | Baltimore Ponies | New York Titans | 4 |
|
Forced Fumbles |
2019 | 6 | Artemis Griner | California Dons | Montreal Royal | 3 |
|
Recovered Fumbles |
2015 | 3 | Kim Fletcher | Baltimore Ponies | California Dons | 2 |
|
Fumble Return Yards |
2015 | 11 | Edmond Theisen | Chicago Outlaws | Fargo Axemen | 31 |
|
Defensive Touchdowns |
2015 | 1 | Gordon Kuhn | Baltimore Ponies | Fargo Axemen | 1 |
|
Punt Return Yards |
2015 | 8 | Alex Kangaroo | Downriver Waves | California Dons | 141 |
|
Punt Return Touchdowns |
2015 | 3 | Mark Heineken | Fargo Axemen | Montreal Royal | 1 |
|
Longest Punt Return |
2018 | 13 | Daniel van Baarle | Grand Rapids Dragons | Texas Ramblers | 88 |
|
Kickoff Return Yards |
2018 | 4 | Antoine Tardif | Baltimore Ponies | Fargo Axemen | 216 |
|
Kickoff Return Touchdowns |
2015 | 1 | John Gradkowski | Baltimore Ponies | Fargo Axemen | 1 |
|
Longest Kickoff Return |
2018 | 2 | Arnold Tarbour | Las Vegas Bandits | Chicago Outlaws | 108 |
|
FG Attempted |
2017 | 5 | Chas Patterson | Baltimore Ponies | Miami Tropics | 7 |
|
FG Made |
2017 | 5 | Chas Patterson | Baltimore Ponies | Miami Tropics | 7 |
|
Longest FG |
2018 | 15 | Earl Holley | Miami Tropics | New Orleans Corsairs | 63 |
|
XP Attempted |
2021 | 13 | Tyler Kim | Montreal Royal | Baltimore Ponies | 8 |
|
XP Made |
2016 | 9 | Howard Blevins | Baltimore Ponies | Fargo Axemen | 7 |
|
FG % |
2015 | 1 | Earl Holley | Grand Rapids Dragons | Montreal Royal | 100 |
|
XP % |
2015 | 1 | Earl Holley | Grand Rapids Dragons | Montreal Royal | 100 |
|
Punt Average |
2018 | 15 | Michael Dresmond | Miami Tropics | New Orleans Corsairs | 66 |
|
Punt Yards |
2015 | 2 | Odis Cantrell | Downriver Waves | Chicago Outlaws | 725 |
|
Longest Punt |
2016 | 4 | Travis Westmore | Texas Ramblers | Las Vegas Bandits | 80 |
|
Tackles For Loss |
2017 | 8 | Kennith Shrader | North Florida Renegades | Chicago Outlaws | 6 |
|
Pancakes |
2021 | 12 | Uzumoi Ujuboijgedhoyi | California Dons | New York Titans | 14 |
|
Sacks Allowed |
2018 | 10 | Bernardo Cotton | Montreal Royal | Chicago Outlaws | 5 |
