Players

Search for players by filling in the fields below. See the detailed instructions below the form.

Name (Surname, Given):
Player ID number:
USATT ID:
TT Australia ID:
Sport:
Minimum rating:
Maximum rating:
Maximum current st. dev.:
Maximum last-played st. dev.:
Earliest last played (yy-m-d):
Most-recent last played:
Last-played window:
Event ID number:
Minimum age:
Maximum age:
Earliest birth (yyyy):
Most-recent birth:
Sex:
Exclude deceased:
ITTF ID:
Has ITTF ID:
ITTF age division:
Exclude younger:
ITTF age division year:
USA state:
Canada province:
Other-country province:
Postal code:
Country:
Country group:
Club:
Club USA state:
Club Canada province:
Club other-country province:
Club country:
Club country group:
Federation:
Match non-primary clubs:
Sort results by:
As of date (yy-m-d):
Current ranking cutoff:
Last-played ranking cutoff:
Heading:
State/province display:
Club display:
Display country:
Display sport:
Output:

You may leave fields blank if you do not wish to restrict the search on that attribute. You may enter a partial name or postal code and the search will return all players whose name or postal code starts with what you entered. Note that there is always a comma after a player’s family name, so to find, for example, Ma Lin, you should enter “Ma, Lin”.

Values that you enter are combined with “and” to narrow the search, so, for example, specifying both a USA state and a Canadian province will result in no players being returned by the search.

To specify multiple player IDs, use the Players (multiple IDs) page. The “Players (multiple IDs)” page does an HTTP POST so that it can handle a large number of IDs (URLs and HTTP GET requests have a size limit). However, if you don’t have too many IDs, you can modify the URL that this page (the “Players” page) produces by changing the PlayerID parameter to a list of IDs by putting a non-digit between the IDs.

To get CSV (comma-separated values) output instead of a webpage, set the “Output” field to one of the “CSV” options. Your browser may handle the two CSV options differently. If you select CSV output, the fields that you get are fixed (i.e., not affected by the various display options on this page). Note that most spreadsheet apps can open or import CSV files.

If you sort the results by rating, then the list will include a ranking column. Only players with a current standard deviation that is smaller than the “Current ranking cutoff” value will be ranked. Leave the “Current ranking cutoff” field blank to rank all players. Similarly, only players with a standard deviation after their last event that is smaller than the “Last-played ranking cutoff” value will be ranked.

Set the “As of date” value to use ratings, standard deviations, ages, and last-played dates as of that date rather than as of today, and to display ratings and standard deviations as of that date.

Enter an event ID in the “Event ID number” field to get players who played in that event.

A federation is a club that has other clubs (and possibly players) as members. If you select a federation in the “Club” combo box, you will only get players who are direct members of the federation. If you select the federation in the “Federation” combo box, you will also get players who are members of clubs that belong to the federation.

If the “Match non-primary clubs” check box is not checked, then the search only considers the player’s primary club (and ignores any other clubs that the player belongs to) when applying the club or federation attributes. To consider all of the player’s clubs, check the box.

Set the “Heading” field to have that value as the heading on the results page.

The “Minimum age” and “Maximum age” values are as of the end of the preceding year.

Make a selection in the “Country group” field to select players from a group of countries. Make a selection in the “Club country group” field to select players from clubs in a group of countries.

The “ETTU” group consists of Albania, Andorra, Armenia, Austria, Azerbaijan, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, England, Estonia, Faroe Islands, Finland, France, Georgia, Germany, Greece, Guernsey, Hungary, Iceland, Ireland, Isle of Man, Israel, Italy, Jersey, Kosovo, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Moldova, Monaco, Montenegro, Netherlands, North Macedonia, Norway, Poland, Portugal, Romania, Russia, San Marino, Scotland, Serbia, Slovakia, Slovenia, Spain, Sweden, Switzerland, Turkey, Ukraine, and Wales.
The “Great Britain” group consists of England, Great Britain, Northern Ireland, Scotland, and Wales.
The “Oceania” group consists of American Samoa, Australia, Cook Islands, Federated States of Micronesia, Fiji, Guam, Kiribati, Marshall Islands, Nauru, New Zealand, Niue, Norfolk Island, Palau, Papua New Guinea, Samoa, Solomon Islands, Tokelau, Tonga, Tuvalu, and Vanuatu.

Make a selection in the “ITTF age division” field to select players who participated in the specified age division or younger age divisions in an ITTF tournament in the year specified in the “ITTF age division year” field. Check the “Exclude younger” check box to not include players who participated in younger divisions in the tournament. For example, selecting “U17 ITTF Players” and checking the “Exclude younger” check box will not include a player who participated in the U17 event if they also participated in the U15 event.

If you set the “Last-played window” field to an integer, it is equivalent to the “Earliest last played” field being set as follows:

If the “Most-recent last played” field is set, then it is equivalent to the “Earliest last played” field being set to last-played-window days before the “Most-recent last played” date.
Otherwise, it is equivalent to the “Earliest last played” field being set to last-played-window days before today.