Pro Results Query Page     Pro Results Query Page

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

AMATEUR Database Last Updated 2/18/24: Latest update: 2024 Mexican Nationals

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.


AMATEUR 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: top 8 finishers for an event
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.
Player Profiles for all Entrants: Player Profile data for all tourney entrants, including age at the time of the event
Player Country Breakdown for all Entrants: Player Country Report for all entrants of this event


Select Year:

Finals by Year: This query will list the finals of every tourney for the selected year
Quarters, Semis, Final by Year: Quarters, Semis and Finals for a Year
Draw Size per Event for Season: Gives the size of the draw in all events for the Season.
Player Profiles for All Players per Season: Player Profile data for all tourney entrants, including age at the time of the event, for any player who appeared in a season
Player Country Breakdown for players per Season: Player Country Report for all players this season


Select Tourney Category:

All Finals: This query will list the finals of every tourney for the selected category throughout history
All Quarters, Semis, Final: Quarters, Semis and Finals for all tourneys for the selected category throughout history
Draw Size per Event: Gives the size of the draw in all events for all tourneys for the selected category throughout history.
Age of Winners: Prints the age of the winner at the time of the event


Select from All Players: or Select Historical tour player: or Select Current Season tour player:
Choose (none) for the non-selected player pulldowns. Historical Nationals player defined as having more than 5 wins ever in all Amateur events. If more than one player is selected, the left-most player is passed to the report.

Season and Career Player Summary: One line summary of a player's career by season (i.e., Rocky Carson: 2 Wins, 3 Finals, 2 Semis, 3 Quarters).
Player Profile: Player Profile Information: picture, Demographics, Social Media links, etc
Player Overall W-L record: This will list the player's Won-Lost record, overall and by season
Player Overall W-L record Lefty/Righty split: This will list the player's Won-Lost record, overall and by season, with Lefty/Righty splits (suggested by Brian Pineda)
Player Tourney Results Summary with Seeding: this shows every tourney a player has entered, their seed, and their result
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
Complete player match history, US Open Only: This query will list every match that the player has played at all US Opens
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 Win : Shows a player's best win on tour, based on their seeding at the time
Career Best Showing : Shows a player's best showing on tour
Career Best Ranking : Shows a player's best season-ending Ranking on tour
Career Best Seeding : Shows a player's best seeding on tour (2009 and onward)
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 W-L in US Open: Player W/L Record just in the US Open
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, Nationals Only: This query will list the number of National titles in the database by player.
Most Tourney Wins, Nationals and Qualifiers: This query will list the number of National-level tourney wins in the database by player, Qualifiers and Nationals
Most Tourney Finals: This query will list the number of tourney finals in the database by player.
Best Career Won/Loss Percentages: This query will list all the Regular tour players (20+ wins) by their career W/L percentages.
Worst Career Won/Loss Percentages: This query will list the worst Career W/L pcts for semi-regular players (20+ appearances) by 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 Seasons on Tour: This query will list the players with the most seasons with at least one appearance on the AMATEUR tour.
Most Appearances on Tour: This query will list every player in the database and the number of times they played a tournament on the AMATEUR 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 AMATEUR tour.
Most Losses on Tour: This query will list every player in the database and the number of Losses they have on the AMATEUR tour.
Most Matches on Tour: This query will list every player in the database and the number of Total Matches they have on the AMATEUR 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)
Player Country Breakdown for all Players: Player Country Report for all players of all time
Player Country Breakdown for all Players by Season: Counts: Player Country Report for all players of all time, Season by Season progression showing counts (longer running query; be patient)
Player Country Breakdown for all Players by Season: Percentages: Player Country Report for all players of all time, Season by Season progression showing percentages (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: Amateur games are scored by International/Amateur scoring rules: 2 games to 15, tiebreaker to 11, so the max longest game is 15-14, 14-15, 11-10. Canada has slightly altered this to have all games be win by two, so you may see 16-14 or 12-10 games.
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.
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, No FFts/Missed tourneys: Longest tourney Winning Streaks, accounting for missed tourneys.
Most Matchups: What two players have played the most on tour?
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.
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.
Highest Combined Age in a Final: This shows the highest combined age between two finalists in tour history (Cary Slade suggestion)
Lowest Combined Age in a Final: This shows the lowest combined age between two finalists in tour history (Cary Slade suggestion)
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.
Misc Match Stats: For the whole tour and all of time, How does a player fare when losing the first game? When winning the first game? etc


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 .