File-Based MatchUp Contribution
- David DiStasio
- Jonathan Cohen
- Abhineet Mittal
Overview
For contributors without infrastructure, USTA offers the ability to contribute match results activity (MatchUps) in csv files via AWS S3.
File Name Convention
Play Activity files use the following naming convention
playactivity-[SOURCENAME]-[YYYYMMDD].csv
Where:
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Effective date of contribution
Column Definitions
The following table lists the fields and formats.
Players.must be defined by -EITHER- UAID -OR- the complete set of identifying fields (firstname, lastname, dob, gender, zipcode, email)
The matchid defines a unique match up. This is what is used for de-duping.
Field | Required/Optional | Values |
|---|---|---|
eventId | Optional | Unique identifier for the league or tournament |
eventName | Required | Name of league or tournament |
category | Optional | Text description of event ie “Anytown Winter League” |
subCategory | Optional | Text description of group within event ie “Women’s 50 And Over” |
startDate | Required | YYYY-MM-DD |
endDate | Required | YYYY-MM-DD |
eventType | Required |
|
facility_name | Required | Text |
facility_addressLine1 | Optional | Text |
facility_addressLine2 | Optional | Text |
facility_city | Optional | Text |
facility_state | Optional | Text |
facility_zipcode | Optional | Text |
matchDate | Required | YYYY-MM-DD |
matchId | Required | Must be unique for each matchup/contributor. This ID will be used to resubmit scores to USTA along with the sourceName. Ex. 2022-08-10-1 |
matchStatus | Required | The match status code should be used on a submission
|
matchType | Required |
|
matchUrl | Optional | Link to website for match scorecard or similar. |
playLevel | Optional | NTRP, WTN, UTR |
positionId | Optional | Text description ie “1st Singles” |
ustaScore | Required/Optional (Either ustaScore or score must be present) | |
score | Required.Optional (Either ustaScore or score must be present) | |
scoreFormat | Required |
|
side_1_player_1_uaid | Required | The UAID of the player. This is the USTA number. 2 UAIDs are expected for singles matches and 4 UAIDs for doubles matches. |
side_1_player_1_firstname | Required | Text |
side_1_player_1_lastname | Required | Text |
side_1_player_1_dob | Required | Text |
side_1_player_1_zipcode | Required | Text |
side_1_player_1_email | Required | Text |
side_1_player_2_uaid | Required | Text |
side_1_player_2_firstname | Required | Text |
side_1_player_2_lastname | Required | Text |
side_1_player_2_dob | Required | Text |
side_1_player_2_zipcode | Required | Text |
side_1_player_2_email | Required | Text |
side_2_player_1_uaid | Required For Doubles | Text |
side_2_player_1_firstname | Required For Doubles | Text |
side_2_player_1_lastname | Required For Doubles | Text |
side_2_player_1_dob | Required For Doubles | Text |
side_2_player_1_zipcode | Required For Doubles | Text |
side_2_player_1_email | Required For Doubles | Text |
side_2_player_2_uaid | Required For Doubles | Text |
side_2_player_2_firstname | Required For Doubles | Text |
side_2_player_2_lastname | Required For Doubles | Text |
side_2_player_2_dob | Required For Doubles | Text |
side_2_player_2_zipcode | Required For Doubles | Text |
side_2_player_2_email | Required For Doubles | Text |
team_1_name | Required For Leagues | Text |
team_2_name | Required For Leagues | Text |
team_1_captain | Required For Leagues | Text |
team_2_captain | Required For Leagues | Text |
team_1_co_captain | Required For Leagues | Text |
team_2_co_captain | Required For Leagues | Text |
team_1_home | Required For Leagues | Required if there are teams being submitted. This identifies whether the team is the home or away team. |
team_2_home | Required For Leagues | Text |
url | Optional | Link to league or tournament website |
winningSide | Required |
|
Example
PLAYACTIVITY-ACTIONSPORTS-20220620.csv
Where:
SOURCENAME: ACTIONSPORTS
Effective Date: 2022-06-20
eventId,eventName,category,subCategory,startDate,endDate,eventType,facility_name,facility_addressLine1,,facility_addressLine2,,facility_city,facility_state,facility_zipcode,,matchDate,matchId,matchStatus,matchType,matchUrl,playLevel,positionId,ustaScore,score,scoreFormat,side_1_player_1_uaid,side_1_player_1_firstname,side_1_player_1_lastname,side_1_player_1_dob,side_1_player_1_zipcode,side_1_player_1_email,side_1_player_2_uaid,side_1_player_2_firstname,side_1_player_2_lastname,side_1_player_2_dob,side_1_player_2_zipcode,side_1_player_2_email,side_2_player_1_uaid,,side_2_player_1_firstname,,side_2_player_1_lastname,,side_2_player_1_dob,side_2_player_1_zipcode,side_2_player_1_email,side_2_player_2_uaid,,side_2_player_2_firstname,side_2_player_2_lastname,side_2_player_2_dob,,side_2_player_2_zipcode,,side_2_player_2_email,team_1_name,team_2_name,team_1_captain,team_2_captain,team_1_co_captain,team_2_co_captain,team_1_home,team_2_home,winningSide
85165,2022 EMA Adult 40 & Over Men 3.5 Men ,Adult 40&Over,3.5 Men , 2022-05-09, 2022-07-21,LEAGUE,Wayside Athletic Club,80 Broadmeadow St,,Marlborough,MA,1752, 2022-05-12,1009055860,CO,SINGLES,,3.5,1S ,,"[[6,1,0,0],[6,3,0,0]]",USTA,2017251807,Ashvin,Kalyanaraman, 1982-02-21,07821,player1@email.com,,,,,,,2010262492,Mei,Welcom, 1990-01-16,07821,player2@email.com,,,,,,,WAY:Wayside Red:Kalyanaraman/Cunningham,NETC:NETC Blue:Nguyen/Vutukuri,Ashvin Kalyanaraman,Mei Welcom,Kevin Cunningham,Venkatakrishna VUTUKURI,TRUE,FALSE,1,,,,,,,,,
85165,2022 EMA Adult 40 & Over Men 3.5 Men ,Adult 40&Over,3.5 Men , 2022-05-09, 2022-07-21,LEAGUE,Wayside Athletic Club,80 Broadmeadow St,,Marlborough,MA,1752, 2022-05-19,1009055862,CO,SINGLES,,3.5,1S ,,"[[6,0,0,0],[4,6,0,0],[1,0,1,0]]",USTA,919511821,Edward,Feeney, 1981-03-26,07898,player1@email.com,,,,,,,2017251807,Ashvin,Kalyanaraman, 1982-02-21,07898,player2@email.com,,,,,,,WAY:Wayside Blue:Feeney,WAY:Wayside Red:Kalyanaraman/Cunningham,Edward Feeney,Ashvin Kalyanaraman,,Kevin Cunningham,TRUE,FALSE,1,,,,,,,,,
85165,2022 EMA Adult 40 & Over Men 3.5 Men ,Adult 40&Over,3.5 Men , 2022-05-09, 2022-07-21,LEAGUE,Marcus Lewis Tennis Center,10 Granite Rd,,Acton,MA,1720, 2022-05-26,1009055863,CO,SINGLES,,3.5,1S ,,"[[2,6,0,0],[4,6,0,0]]",USTA,921520068,Phil,Wolf, 1972-06-11,07896,player1@email.com,,,,,,,2017251807,Ashvin,Kalyanaraman, 1982-02-21,08844,player2@email.com,,,,,,,MLTC:Marcus Lewis TC:Wolf,WAY:Wayside Red:Kalyanaraman/Cunningham,Phil Wolf,Ashvin Kalyanaraman,,Kevin Cunningham,TRUE,FALSE,2,,,,,,,,,
85165,2022 EMA Adult 40 & Over Men 3.5 Men ,Adult 40&Over,3.5 Men , 2022-05-09, 2022-07-21,LEAGUE,New England Tennis Center,100 DuVal Rd,,Lancaster,MA,1523, 2022-05-26,1009055864,CO,SINGLES,,3.5,1S ,,"[[3,6,0,0],[6,1,0,0],[0,1,0,1]]",USTA,2018852077,Mei,Welcom, 1990-01-16,07823,player1@email.com,,,,,,,919511821,Edward,Feeney, 1981-03-26,07823,player2@email.com,,,,,,,NETC:NETC Blue:Nguyen/Vutukuri,WAY:Wayside Blue:Feeney,Mei Welcom,Edward Feeney,Venkatakrishna VUTUKURI,,TRUE,FALSE,2,,,,,,,,,
84599,2022 USTA ADULT 18 & OVER - POCATELLO Men 4.5 - 18 & OVER,Adult 18&Over,Men 4.5 - 18 & OVER, 2022-05-09, 2022-07-03,LEAGUE,Pocatello High School,325 N Arthur Ave,,Pocatello,ID,83204, 2022-05-25,1009055905,CO,SINGLES,,4.5,1S ,,"[[3,6,0,0],[0,6,0,0]]",USTA,2010689922,Noah,Wang, 1986-08-02,07856,player1@email.com,,,,,,,2010026131,Steven,Nielsen, 1989-07-09,07856,player2@email.com,,,,,,,Dream Team,Are you sure?,Noah Wang,Steven Nielsen,,,TRUE,FALSE,2,,,,,,,,,
84599,2022 USTA ADULT 18 & OVER - POCATELLO Men 4.5 - 18 & OVER,Adult 18&Over,Men 4.5 - 18 & OVER, 2022-05-09, 2022-07-03,LEAGUE,Pocatello High School,325 N Arthur Ave,,Pocatello,ID,83204, 2022-05-25,1009055905,CO,SINGLES,,4.5,2S ,,"[[1,6,0,0],[5,7,0,0]]",USTA,2010294386,Noxxx,Waxxx, 1988-09-14,07878,player1@email.com,,,,,,,2002541864,Freddy,Gordon, 1986-08-02,07878,player2@email.com,,,,,,,Dream Team,Are you sure?,Noah Wang,Steven Nielsen,,,TRUE,FALSE,2,,,,,,,,,
93888,2022 Piedmont Singles 40 & Over 3.5 Men 40 & Over,Adult Other,3.5 Men 40 & Over, 2022-05-24, 2022-07-30,LEAGUE,Latham Park Tennis Center,905 Cridland Rd,,Greensboro,NC,27408, 2022-05-25,1009056489,CO,SINGLES,,3.5,1S ,,"[[0,6,0,0],[2,6,0,0]]",USTA,2018883164,A. Kobi,Jackson, 1994-06-20,07897,player1@email.com,,,,,,,2018195577,Chris,Whichard, 1983-01-21,07897,player2@email.com,,,,,,,Kobi-Jackson,Whichard - Singes 40s 3.5,A. Kobi-Jackson,Chris Whichard,,,TRUE,FALSE,2,,,,,,,,,
84719,2022 Montgomery Adult 18 & Over Spring Montgomery Adult 18 & Over 5.0 Men,Adult 18&Over,Montgomery Adult 18 & Over 5.0 Men, 2022-05-20, 2022-06-30,LEAGUE,Montgomery TennisPlex,18010 Central Park Cir,,Boyds,MD,20841, 2022-05-24,1009056530,CO,SINGLES,,5,1S ,,"[[0,6,0,0],[2,6,0,0]]",USTA,11374202,Mehrban,Iranshad, 1983-01-21,07587,player1@email.com,,,,,,,921459476,Richard,Barker, 1972-06-11,07587,player2@email.com,,,,,,,Iranshad,Lieber,Mehrban Iranshad,,,,TRUE,FALSE,2,,,,,,,,,
87733,2022 USTA Adult 18 & Over League - NNM 4.5 Men,Adult 18&Over,4.5 Men, 2022-04-11, 2022-06-12,LEAGUE,Highpoint Sports Wellness,4300 Landau St NE,,Albuquerque,NM,87111, 2022-05-18,1009056567,CO,SINGLES,,4.5,1S ,,"[[3,6,0,0],[2,6,0,0]]",USTA,2010745438,Charles,Provencio, 1989-07-09,07890,player1@email.com,,,,,,,2010113751,Randy,Elsethagen, 1994-06-20,07890,player2@email.com,,,,,,,NNM 4.5M HP - Provencio,NNM 4.5M JC - Gordon,Charles Provencio,Freddy Gordon,Phillip Kay,,TRUE,FALSE,2,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,Greenville Country Club,239 Byrd Blvd,,Greenville,SC,29605, 2022-05-25,1009055878,CO,DOUBLES,,4,1D ,,"[[6,3,0,0],[6,2,0,0]]",USTA,2010321406,Cindy,Cannon, 1982-02-21,08844,side1player1@email.com,1180209658,Liliana,McGee, 1982-02-21,08198,side1player2@email.com,2006373057,Mary,McCarthy, 1990-01-16,07821,side2player1@email.com,11809821,Susan,Hulse, 1990-01-16,07821,side2player2@email.com,UPTA55T/Cannon/GCC,UPTA55T/Mccarthy/Reserve,Cindy Cannon,Mary McCarthy,Liliana McGee,Kevin Cunningham,FALSE,TRUE,1,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,Greenville Country Club,239 Byrd Blvd,,Greenville,SC,29605, 2022-05-25,1009055878,CO,DOUBLES,,4,2D ,,"[[3,6,0,0],[6,2,0,0],[1,0,1,0]]",USTA,10205140,Laura,West, 1981-03-26,08502,side1player1@email.com,11565268,Wanda,Cummins, 1981-03-26,08789,side1player2@email.com,2017205488,Wendy,Jakszta, 1982-02-21,07898,side2player1@email.com,2001550478,Tawni,Howell, 1982-02-21,07898,side2player2@email.com,UPTA55T/Cannon/GCC,UPTA55T/Mccarthy/Reserve,Cindy Cannon,Mary McCarthy,Liliana McGee,Kevin Cunningham,FALSE,TRUE,1,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,Greenville Country Club,239 Byrd Blvd,,Greenville,SC,29605, 2022-05-25,1009055878,CO,DOUBLES,,4,3D ,,"[[4,6,0,0],[2,6,0,0]]",USTA,922030342,Kathy,Smith, 1972-06-11,08678,side1player1@email.com,2010755183,Phil,Wolf, 1972-06-11,08923,side1player2@email.com,2018416331,Martin,Rossato, 1982-02-21,08844,side2player1@email.com,2010905428,Janet,Lightheart, 1982-02-21,08844,side2player2@email.com,UPTA55T/Cannon/GCC,UPTA55T/Mccarthy/Reserve,Cindy Cannon,Mary McCarthy,Liliana McGee,,FALSE,TRUE,2,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,The Salvation Army Kroc Center,205 Gibbs St,,Greenville,SC,29601, 2022-05-25,1009055880,CO,DOUBLES,,4,1D ,,"[[6,3,0,0],[4,6,0,0],[0,1,0,1]]",USTA,922732302,Jill,Norman, 1990-01-16,08123,side1player1@email.com,922115555,Aaron,Sutton, 1990-01-16,08678,side1player2@email.com,919657293,Ashley,Jones, 1981-03-26,07823,side2player1@email.com,922060496,Jennifer,Lloyd, 1981-03-26,07823,side2player2@email.com,UPTA55T/Norman/Kroc,UPTA55T/Jakszta/KK,Jill Norman,Wendy Jakszta,Wanda Cummins,,FALSE,TRUE,2,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,The Salvation Army Kroc Center,205 Gibbs St,,Greenville,SC,29601, 2022-05-25,1009055880,CO,DOUBLES,,4,2D ,,"[[6,3,0,0],[1,6,0,0],[1,0,1,0]]",USTA,921572446,Lisa,Pant, 1986-08-02,08789,side1player1@email.com,10757863,Carl,Laitinen, 1986-08-02,08844,side1player2@email.com,2001883203,Susie,Hartzog, 1989-07-09,07856,side2player1@email.com,2003530745,Erin,Wood, 1989-07-09,07856,side2player2@email.com,UPTA55T/Norman/Kroc,UPTA55T/Jakszta/KK,Jill Norman,Wendy Jakszta,Wanda Cummins,,FALSE,TRUE,1,,,,,,,,,
94000,"2022 USTA Tri Level 55 and Over - UPTA 3.0, 3.5, 4.0 Women",Tri-Level 55&Over,"3.0, 3.5, 4.0 Women", 2022-05-15, 2022-07-23,LEAGUE,The Salvation Army Kroc Center,205 Gibbs St,,Greenville,SC,29601, 2022-05-25,1009055880,CO,DOUBLES,,4,3D ,,"[[6,2,0,0],[4,6,0,0],[1,0,1,0]]",USTA,2010919430,Brent,Land, 1988-09-14,08976,side1player1@email.com,1180234888,Amy,Wright, 1988-09-14,08923,side1player2@email.com,2018777064,John,Gilman, 1986-08-02,07878,side2player1@email.com,2018527803,Michelle,Savoy, 1986-08-02,07878,side2player2@email.com,UPTA55T/Norman/Kroc,UPTA55T/Jakszta/KK,Jill Norman,Wendy Jakszta,Wanda Cummins,,FALSE,TRUE,1,,,,,,,,,
84599,2022 USTA ADULT 18 & OVER - POCATELLO Men 4.5 - 18 & OVER,Adult 18&Over,Men 4.5 - 18 & OVER, 2022-05-09, 2022-07-03,LEAGUE,Pocatello High School,325 N Arthur Ave,,Pocatello,ID,83204, 2022-05-25,1009055905,CO,DOUBLES,,4.5,1D ,,"[[2,6,0,0],[0,6,0,0]]",USTA,2010084271,Lensey,Smith, 1994-06-20,08923,side1player1@email.com,11477388,Ann,Creager, 1994-06-20,08976,side1player2@email.com,2010450888,Freddy,Gordon, 1983-01-21,07897,side2player1@email.com,2010879152,Sandy,Clark, 1983-01-21,07897,side2player2@email.com,Dream Team,Are you sure?,Noah Wang,Steven Nielsen,,,FALSE,TRUE,2,,,,,,,,,
84599,2022 USTA ADULT 18 & OVER - POCATELLO Men 4.5 - 18 & OVER,Adult 18&Over,Men 4.5 - 18 & OVER, 2022-05-09, 2022-07-03,LEAGUE,Pocatello High School,325 N Arthur Ave,,Pocatello,ID,83204, 2022-05-25,1009055905,CO,DOUBLES,,4.5,2D ,,"[[0,6,0,0],[1,6,0,0]]",USTA,920720488,Cristy,Presson, 1983-01-21,08445,side1player1@email.com,2010569688,Kim,Thriffiley, 1983-01-21,08123,side1player2@email.com,11197607,Richard,Barker, 1972-06-11,07587,side2player1@email.com,11232529,Reuben,Byrd, 1972-06-11,07587,side2player2@email.com,Dream Team,Are you sure?,Noah Wang,Steven Nielsen,,,FALSE,TRUE,2,,,,,,,,,
84599,2022 USTA ADULT 18 & OVER - POCATELLO Men 4.5 - 18 & OVER,Adult 18&Over,Men 4.5 - 18 & OVER, 2022-05-09, 2022-07-03,LEAGUE,Pocatello High School,325 N Arthur Ave,,Pocatello,ID,83204, 2022-05-25,1009055905,CO,DOUBLES,,4.5,3D ,,"[[4,6,0,0],[4,6,0,0]]",USTA,1180315085,Julie,Hipkins, 1989-07-09,08198,side1player1@email.com,2018526849,Glenn,Heard, 1989-07-09,08502,side1player2@email.com,919481364,Joe,Belnap, 1994-06-20,07890,side2player1@email.com,2003962338,Jack,Allen, 1994-06-20,07890,side2player2@email.com,Dream Team,Are you sure?,Noah Wang,Steven Nielsen,,,FALSE,TRUE,2,,,,,,,,,
File with sample data
On This Page: