Pro Results Query Page     Pro Results Query Page

Tour Selected: (Hit Back to select a different tour or Click Here)

WRT Database Last Updated 10/22/18: WRT Database updated to 2018 Canadian Open in Calgary, singles and oubles

Page Instructions: Click on one of the pre-built queries to run the selection. If any box is selected, any 'Submit Form' button will work.


WRT Singles Match Results Data: Singles only match by match Results database

Select Event:

All matches per event: This query will list every match that occurred at the tourney. All known qualifiers are included.
Quarters, Semis and Final per Event: Quarters, Semis and Finals
Seed Report per Event: Lists the Seeding for an event. Caveat; seeding only guaranteed to be populated from 2010 onwards.
Upsets by Seed Report per Event: Lists all upsets by seeding for the event. Caveat; seeding only guaranteed to be populated from 2010 onwards.
Draw Size per Event: Gives the size of the draw per Event.


Select Season/Year:

Finals by Season: This query will list the finals of every tourney for the selected season
Quarters, Semis, Final by Season: Quarters, Semis and Finals for a Season
Distinct Winners per Season: Number of distinct Tourney winners in a season
Season-Ending Rankings: Season Ending Rankings per season
Season Summaries for all Players: This will list the "Season Summary" totals for all players who appeared in a season.
Statistical Abstract Stats for the Season: Evan Prichard's Statistical Abstracts (beta)
Highest Seeds to...: Highest Seeds to win, make a final, etc. Data for the chose season only (see below for same report for the whole database). Fyi: Seeding data only guaranteed to be available starting with the 2010-11 season; data is spotty prior to that.
Draw Size per Event for Season: Gives the size of the draw in all events for the Season.
Season Seed Report: Lists all the leading players and their seed per event for a season. Fyi: Seeding data only available starting with the 2010-11 season


Select from All Players: or Select regular tour player:
(choose (none) for "All Players" if you're selecting a "Regular tour player". Regular tour player defined as having more than 15 wins on tour.)

Season and Career Player Summary: One line summary of a player's career by season (i.e., Alejandro Cardona: 2 Wins, 3 Finals, 2 Semis, 3 Quarters).
Player Overall W-L record: This will list the player's Won-Lost record, overall and by season
Season Ending Rankings Per Player: by season
Complete player match history chronologically: This query will list every match that the player has in the DB, earliest to latest/Ascending
Complete player match history: This query will list every match that the player has in the DB, latest to earliest/Descending
Complete player match history, All tours: This query will list every match that the player has across ALL tours, earliest to latest/Ascending
Player Wins: This will list the all the players Wins chronologically
Player Losses: This will list all the players Losses chronologically
Player Games and W-L record: This will list the player's Won-Lost record, including Games won/lost, overall and by season
Player Head-to-Head Record Alphabetically: This will list a matrix of the player's head to head record w/ every other player in the DB, sorted by player name
Player Head-to-Head Record Ordered by most Matchups: This will list a matrix of the player's head to head record w/ every other player in the DB, sorted by the number of times they've met from most to least
Player Head-to-Head Records in last 3 years : To gauge more recent head-to-head records, this limits the search to the last three years for active players
Non-Trivial Player Head-to-Head Record: This is head-to-head among the more regular tour members (eliminates all matchups where there have been less than 2 meetings)
Non-Trivial Player Head-to-Head Records With Results: Shows non-trivial head-to-head records for players on tour, with the results.
Career Best Showing : Shows a player's best showing on tour
Player Record by City: Do players do better in particular cities?
Donut Counts: Given and received
'Twinkie' Counts: (11-1 or 1-11 games), Given and received (inspired by the IRT stats page)
Tournament Winning Percentage: Percentage of Tournaments won when entered.
Finals Percentage: Percentage of Tournaments reaching the Final
All Titles: Lists all Titles won by the player.
Player W-L record in Finals: This will list the player's Won-Lost record in finals only, overall and by season
Player W-L record in Semis
Player W-L record in Quarters
Player W-L record in 16s
Player W-L record in Early rounds: not as meaningful for 90s players b/c records are spotty for round of 32
Player "Firsts": Prints a player's first Tour Event Appearance, First Tour Win, and the Number of Tourneys it took to win their first
Player "Lasts": Prints a player's last Tour Event Appearance, Last Tour Win
Misc Player Stats: How does a player fare when losing the first game? When winning the first game? etc


Miscellaneous Tour Statistics

Most Tourney Wins: This query will list the number of tourney wins in the database by player.
Best Seasons: This query will print a list of the best player performances in a single season (by winning pct).
Best Career Won/Loss Percentages: This query will list all the Regular tour players and their career W/L percentages.
Best Career Won/Loss Percentages, main draws only: This query will list the best career W/L percentages excluding qualifying rounds
Career Season Summaries: This will list the "Season Summary" career totals for all players in the database (15 second query).
Most Appearances on Tour: This query will list every player in the database and the number of times they played a tournament on the WRT tour.
Longest Tourney Appearance Streaks: Longest consecutive tournament Appearance Streaks in tour history. (longer running query, be patient)
Most Wins on Tour: This query will list every player in the database and the number of Wins they have on the WRT tour.
Most Losses on Tour: This query will list every player in the database and the number of Losses they have on the WRT tour.
All Finals: This query will list the results of every Final in the database.
All Quarters/Semis/Finals: This query will list all the Q/S/F of every tourney in the database
Quarters, Semis and Final Country Of Origin: country of Origin for the Q/S/F players for every tourney (longer running query; be patient)
Longest Games: Matches with the longest single games
Worst Defeats: Most one-sided matches in the database (note: most of these are qualifying rounds)
Worst Defeats In Quarters/Semis/Finals: Most one-sided matches in Quarters/Semis/Finals
Worst Defeats In Finals: Most one-sided matches in Finals
Most Dominant Tourney Wins: Ranking of the most dominant tourney wins in history; fewest games dropped, fewest points allowed, etc
Longest Matches : Most points scored in a match. Note: WRT games are scored by USA-R amateur rules: 2 games to 15, tiebreaker to 11, so the max longest game is 15-14, 14-15, 11-10
Most Points in a Win: Most points scored in a match by someone who won the match.
Most Points in a Loss: Most points scored in a match by someone who lost the match.
All Negative Score Games: A list of all matches with negative scores on tour.
All Forfeit Score Games: A list of all matches with forfeit scores on tour.
All Forfeit Score Games in Q/S/F: A list of all matches with forfeit scores on tour that occurred in the Quarters/Semis/Finals (this strips away most of the FFTs show in the above query because many happen in early rounds.
Season by Season Tourney Wins/Distinct Winners per Season: Marty Hogan suggested List of Tourney Winners by season; Provides an interesting look at year-end winner versus who won the most tourneys.
Number of Events per Season: Quick count of events per season for the entirety of the tour.
Draw Size per Event, all Time: Gives the size of the draw per Event for every event on tour
Most Consecutive Distinct Winners: Report showing the most consecutive Distinct tourney winners in Tour history.
Longest Game Winning Streaks: Longest Individual Game Winning Streaks. Note that this report will skip forfeits only if they resulted in no on-court play.
Longest Match Winning Streaks: Longest individual Match Winning Streaks. Note: ffts break winning streaks in this report; we are working on a non-fft win streak version
Longest Match Winning Streaks, no Ffts: Longest Match Winning Streaks not counting Ffts.
Longest Tourney Winning Streaks: Longest tourney Winning Streaks. Note: missed tournaments break winning streaks in this report; we are working on a non-missed tourney win streak version
Longest Tourney Winning Streaks, No FFts/Missed tourneys: Longest tourney Winning Streaks, accounting for missed tourneys.
Most Matchups: What two players have played the most on tour?
Head to Head Matrix: Head to Head Matrix all-time of top 20 players on tour (using previous season's rankings)
Tour Depth Report: A report that shows the 'depth' of the tour by season. Longer query; 10-15 seconds to run
All Season Top 10 Lists: This will show the top 10 for every season on tour. Still needs some work on the older tournaments
Matrix of all Top 10 Finishes: This prints a matrix of every player who has finished a season ranked in the top 10 with counts by finish.
Player Profiles - All: List of All Player Profiles, including hometown, current residence, height/weight, sponsors, birthday.
Player Profiles - Regular: List of Regular Player Profiles, including hometown, current residence, height/weight, sponsors, birthday.
Ages of Tour Winners: A list of every winner on tour, their age at first tour win, first appearance, last tour win, etc.
Oldest Players to...: Oldest player to win a tourney, make a final, etc.
Youngest Players to...: Youngest player to win a tourney, make a final, etc.
Ages of All Tour Champs: A report that shows the age of each season tour winner at season end.
Highest Seeds to...: Highest Seeds to win, make a final, etc. Reports across all available data, though the seeding is really only guaranteed to be available starting in the 2010-11 season for all tours
Highest Combined Seeds in Finals: Highest Combined Seeds to comprise a Final (rpts suggested by Evan Pritchard).
Highest Combined Seeds in Semis: Highest Combined Seeds to comprise a Semis field.
Highest Combined Seeds in Qtrs/Semis/Final: Highest Combined Seeds to comprise the Qtrs/Semis/Finals field.
Lowest Combined Seeds in Finals: Lowest Combined Seeds to comprise a Final
Lowest Combined Seeds in Semis: Lowest Combined Seeds to comprise a Semis field.
Lowest Combined Seeds in Qtrs/Semis/Final: Lowest Combined Seeds to comprise the Qtrs/Semis/Finals field.


WRT Pro tour History Pages

  • WRT Tour History: A brief overview of the WRT, which started in late 2012 but began "touring" in earnest in 2013.
  • WRT Major Rule Change History: no real rule changes thus far to document. WRT plays by IRF/Amateur scoring rules (2 games to 15, tiebreaker to 11, win by one).
  • WRT Tour Name History: No changes to document.
  • WRT Commissioner History: Overview of the WRT management.
    WRT Tour Player History Pages

  • WRT Year End Title Winners: 2013 to present; see seedings or POTY links.
  • WRT Players of the Year: Poty, Rookie of the Year, Sportsmanship, Most Improved and "Fan Favorites." Have 2015, 2016, waiting for older data.
  • Season End Standings by year: Loaded in Database: see Match Results Database and run the "All Season Top 10 Lists" report. More data needed.
  • Major Championship Titles: No WRT Majors as of yet.
  • Year End Summaries: tbd
  • Top Players never to have finished #1: tbd
  • Greatest Upsets in tour History: tbd
    Data Sources

    All data here was compiled by Todd Boss, by entering data published in Magazines, on r2sports.com or at National sites. If there are errors within, they may be because of publishing errors or incomplete online data, or due to data entry errors on my part. If you have additions, corrections or comments, please direct them to me, at tboss@bossconsulting.com .