New Reports at Pro Racquetball Stats (part 3)

Part 3 of 3 posts going over the content we’ve added recently.

– Big news: we’ve started to add Amateur National Qualifiers to the Amateur database! We had to modify some queries and add others. We also have put in a number of additional Categories for searching. We’re still back-filling in lots of Canadian Qualifiers, but as of this writing…
o all USA doubles qualifiers from 2016-2020 are in
o All Canadian qualifiers from Nov 2017-present
o A bunch more Canadian qualifier events are in the staging xls, but not yet loaded.

Some new example queries:
– http://rball.pro/1BEF9F is Q/S/F for USA National Doubles qualifiers from 2016-2020.

– http://rball.pro/0AAA0E is the finals of the last few Canadian Men’s Open qualifier events, the last 6 of which was won by Samuel Murray

I have a ton more to go; two qualifiers a year in Canada going back more than a decade is a lot of events to transcribe. I’ll probably send out a different email upon final data catch-up.

– I’ve also been adding other country data besides the “big 3” of USA, Canada, Mexico in an attempt to widen the scope of the data. This spring we’ve captured Qualifiers and/or Nationals results from Bolivia, Ecuador and India. I’m having some issues getting the full results for these events (India used R2 Sports App but the other countries did not), but the goal is to start loading in more data. I’ve also reached out recently to countries like Chile and Mexico with the hope of building out historical results.

A call to the community: ANYONE with links to national organizations in other countries who may be able to provide data is welcomed. There’s a dozen other countries out there that run national events that I’d love to have in the database.

– I’ve started to work on a change_nationality() function that properly shows all countries of origin properly for players who have switched allegiances in their career. The most recent example is of course Alex Landa switching from Mexico to USA, so the function should properly show Landa being “from” the USA in tourneys after Nov 2019 and being “from” Mexico before that. There’s now many players who have switched and as we see reports that need more coding we fix them.

– fixed bug in player_history_alltours() to get Event links to properly render based on alternate tour variable. This is a common issue in the code actually, since we over load lots of variables to support all sorts of different use cases in the code.

– fixed a bug in the Draw Size queries that was improperly counting draw sizes for events that depended on round robins. I was counting total matches, not distinct losers. I also was mis-couting events that have 3rd place games.

– the most recent addition: A Year-End Rankings Matrix tracking the current pro players and their year over year season ending ranking in one place. http://rball.pro/8D2F5F

———————
Other general improvements
– I’ve begun adding direct links in some places to specific tournaments, so that if you’ve run (for example) All Finals for a season you can click on the tournament name to get immediately to the “All Matches per Event” report.

– We’ve added some additional fields to the Tale of the Tape reports for players as we can find it; we’re always looking for more and better data.

– We’ve added “As of Date” date logic printing to every report; we list the day the report was run as well as the date of the latest tournament in the database. We did this to help support the IRT’s broadcast team so that they know when the data they’re looking at (if its been printed) is as of for context.

– We have created a number of reports to help the Reaching Your Dream Foundation organization report on its sponsored players; these are only available via private links shared only with RYDF staff, but also are something we can support for other tours or other organizations as needed. I’ve also created custom jump pages for the IRT broadcasters for example, and can do other one-offs as needed.

– We’ve modified the code to handle the LPRT’s conversion to best-of-3 scoring in Aug 2019.

– Thanks to an observation from Jon Rafkind, we had some redirect and coding bugs preventing the website from using SSL properly. So now you should see all pages on the site loading via https:// … if not, you may have the non secure link cached in your browser.

– Fixed some code typos as noticed by Tj Baumbaugh where my footer links on the home page/choose_tour.pl page were going to the wrong link for the LPRT.

– We’ve added a third Player Pull-down for all players who have appeared in the current season to help navigate players more easily. Some people have asked how the “Historical tour player” is populated; its driven by 50 tour wins. Well, there’s players in the current top 10 who don’t have that many wins, so they’re not in the “Historical” or “Frequent tour players” list … instead of changing that number, i just added a third pull-down.

– Photo Attribution: I modified the player_profile table to hold Photographer credits for all player profile pictures used, and then modified the code to read in a JS library (label.css) to put in a photo caption and give photographer credit where its due. I’ve also started cleaning out photo usage to try to migrate all photo usage to use materials from photographers that I’ve got “agreements” with. Many of the photos in there right now are from Kevin Savory or Ken Fife, who have been doing a lot of the photography at local pro events the last couple of seasons. But I hope to incorporate more photos from other photographers later on.

——————-
Tags

International Racquetball Tour
LPRT
International Racquetball Federation – IRF
USA Racquetball
Racquetball Canada
Federación Mexicana de Raquetbol
Federación Boliviana De Raquetbol – Febora
Federación Boliviana de Racquetball
Federación Chilena Racquetball
Racquetball Rancagua, Chile
Ferac Racquet
Federación Ecuatoriana de Racquetball – FERAC
India racquetball

Happy Thanksgiving 2019!

On this holiday, I thought i’d print out what i’m thankful for in our Racquetball community, and recognize those who help me do what I do for the Pro Racquetball Stats site.

– International Racquetball Tour commish Mike Grisz for moving the tour forward and already having an impactful change.
– LPRT commish Tj Baumbaugh for keeping tour moving forward and ever expanding the schedule and reach.

– Both tours for all the efforts you make with streaming matches so that we nerds can watch from home. Jerry J Josey Jr.osey Jr. and Pablo Fajre n particular.

– Speaking of broadcasts, special thanks to the lead broadcasters on the pro tours Timothy Baghurst and Dean DeAngelo Baer. Also thanks to those who help out on broadcasts JP Edwards, Favio Saravia and many others who help out and make the streaming entertaining for those of us at home.

– thanks to the amateur orgs out there: International Racquetball Federation – IRF and USA Racquetball and Federación Mexicana de Raquetbol and Racquetball Canada for all the events you put on.

– Thanks to the IRF and USAR lead broadcast voices Gary Mazaroff and Leo Ray Vasquez for all you do for the major USA and international events.

– Thanks to IRT staffers like Andy Kulback and Mark Gibbs for ongoing discussions on various issues related to the integration and use of the data.

– Thanks to Reaching Your Dream Foundation and Michael Lippitt for your sponsorship and assistance provided to younger players to keep them playing.

– thanks to Ryan and Tish Rodgers for R2 Sports App; where would we be without that system and its prevalent use to provide real-time tracking of tournaments. IRF: take note! can we please move to r2sports and move away from PDFs stored in dropbox?

– Thanks to Kramer X for everything you do with The Racquetball Blog, the only person out there really writing about the sport in a blog-format.

– Thanks to all the skilled photographers out there associated with the various organizations; keep up your great work. I’m talking Ken FifeKevin Savory, Mike Augustin, Freddy Ramirez, Roby Partovich, Geoff Thomsen, Mike Boatman, and others who I may have forgotten.

– thanks for the 20 years now of the UnitedHealthcare US OPEN Racquetball Championships and Doug Ganim’s stewardship. I hope we can find someone to continue this great tradition; the one event per year that draws basically everyone in the sport.

– Thanks to all the tournament directors who put up their own time, money and effort to put on tournaments, both professional and amateur. With out you, we have no sport.

– And thanks to anyone who I may have forgotten.

Happy Thanksgiving! Eat some turkey, then hit the courts!

2019 Bay Club Open IRT Tier 4 Wrap-up

Horn captures the title at his home club. Photo US Open 2019, Photographer Kevin Savory

r2sports home page:

https://www.r2sports.com/website/event-website.asp?TID=31326

In the wake of the massive 2019 US Open, Reaching Your Dream Foundation helped fund a lower tier IRT event this past weekend in Northern California (Pleasanton in particular), close enough to the “209” to get a good crew of Stockton players and a healthy Men’s singles pro draw of 21 players.

Here’s a quick review of the Singles draw.

—————
In the 32s.

– #21 Mitchell Forrest Jr. took out former Outdoor champion #12 Luis R Avila in two games, a solid win for Forrest, who honestly I have almost no results for in the national databases.

– Junior #20 Vedant Chauhan took out the 13th seeded Kalyan Kosetty 8,7. Chauhan is just *14 years old* this year, and made it to the final of USA Junior Nationals 14U earlier this year.

– Another California junior national champ #22 Nikhil Prasad defeated Chilean international #11 Johan Igor in two. Think Chauhan is young? Prasad won the World 12U juniors last year, defeated Chauhan in the 14U final this year and is playing in his age 13 season.

————

In the 16s; some surprises and some great matches

– #5 Adam Manilla ended Forrest’s run 5,3.

– #4 Robert Collins was played tough by junior Chauhan but advanced 7,12. Chauhan certainly did not play like a 14yr old in this match, pressing Collins and making shots. He’s one to watch for.

– In the match I immediately looked at upon seeing this draw … former top 8 touring pro #14 seed Markie Rojas met up with up and coming pro #3 Sebastian Fernandez and the match did not disappoint. Rojas advanced 12,(9),10 to move on. Rojas, if he were playing full time, would probably be the favorite in this draw despite the presence of several top 20 pros; it should be interesting to see how far he goes.

– #6 Charlie Pratt ended junior Prasad’s run 7,10. Pratt is another guy to watch for in this draw; he only plays the tour part time but always seems to make noise when he enters tournaments. And, a solid showing for a 13yr old in a pro draw.

– #7 Bolivian 18U Diego Garcia Quispe, still hanging out state-side after traveling up for the US Open, took on another traveling South American in #10 Francisco Troncoso and beat his elder 7,11 to move on. Garcia is going to be a tough out in this fall’s Junior Worlds.

– #2 Jose Diaz ousted 4,4 the Chilean 18U player and #18 seed Rafael Gatica Negroni. I was thrown
for a loop here initially; they posted Gatica as the initial winner on r2sports and was getting ready to talk about what an upset it was. 🙂

So, two upsets by seed in the 16s, with the #9 over #8 and #14 over #3 (though the #14 wasn’t exactly a normal 14 seed).

—————-
Qtrs:

– #1 David ” Bobby” Horn dominated the Mexican international #9 Christian Longoria 2,8 to advance to the semis.

– In a rare battle of lefties, #5 Adam Manilla got the upset-by-seed over #4 Robert Collins in a tiebreaker.

– #6 Pratt took advantage of a possibly spent Rojas and advanced 10,6 into the semis.

– #7 Garcia played two solid games but could not beat #2 Diaz, falling 12,11.

——————
Semis and Final:

– #1 Horn outlasted #5 Manilla 13,11 to move into the final.

– #6 Pratt advanced in two games over #2 Diaz 12,6.

In the final: Horn got a very solid win over Pratt, winning the title in two 13,11. Solid win for Horn over a solid field.

—————–

Consolations: Avila and Troncoso made it to the consolation final after early round upsets, and Troncoso stomped Avila 11,4 to take the title.

In the Open/Elite doubles, a large/fast round robin draw played Sunday afternoon featuring no less than 15 teams. The four teams who made the semis were Diaz & Harold Jagoda, Collins & Tyrone E Snipes, Avila and Will Reynolds, and Rojas with RYDF patron Michael Lippitt.

Avila/Reynolds topped Collins/Snipes in the final

—————–
Nice little tournament! I’ll wrap up another small tourney that went on this weekend in Chihuahua next, then we have a small break until a busy Halloween weekend of events that includes the next IRT Tier 1 in Arizona.

PSA for RYDF

A quick public service announcement for the Reaching Your Dream Foundation organization (RYDF), run by SF bay-area based Michael Lippitt.

Pro Racquetball Stats collaborates with RYDF and provides some RYDF-specific reports highlighting per-event results for RYDF-sponsored players. And we support the initiative of providing assistance to help keep pro players playing pro racquetball.

Click on the link below to sign up for their newsletter, and of course consider contributing to the cause.

https://reachingyourdreamfoundation.us16.list-manage.com/su…