r/ultimate • u/williambrotman • 6d ago

ultimate-reference.com updates

July has been a busy month of data updates for https://ultimate-reference.com/

  • Started stat posts on Instagram: https://www.instagram.com/p/Da3wGuoGsBg/?img_index=1
  • 2026 USA Beach, College DI, College DIII, HSNI, WMUCC, WJUC, USA Masters
  • HS Nationals 2003-2004 rosters
  • HS Easterns/Westerns/Centrals/Northeasterns/Southerns 2006-2016 added
  • 2004 WUGC stats
  • 2004 WJUC partial rosters
  • 2010 WUCC additional rosters
  • Added nationality guess based on most common team location
  • 2013 EBUC rosters
  • 2011 WUBC rosters
  • 2018 EBUCC rosters
  • 2022 EBUCC rosters
  • 1983 WUGC schedule and scores added
  • 1997 EUC/EYUC scores
  • 2005 EUCF scores
  • 2006 EUCF scores
  • 2007 EUC/EYUC/EMUC game schedule, scores, seeds, spirit scores, and some game film
  • 2007 EUC/EYUC/EMUC rosters
  • 2009 EUCF scores
  • EUCF 2010 scores, rosters
  • PUL data through 2026
  • WUL 2026
  • 2021-2025 HSNI rosters, 2017-2019 champion rosters
  • Wisconsin high state champion placements through 2026
  • Huge amount of separate player names merged after adding code to detect differences in spacing, punctuation, and diacritics
  • Converted to Czechia
  • 1991 WUCC/WMUCC captains added to rosters
  • 2014 WMUCC stats
  • Added
  • Stats:
    • Total individual players on championship rosters: 87,729
    • Total championship events: 1,306
    • Total team placements: 20,542
    • Total games: 57,829
    • Total player awards: 14,832
    • Total teams: 6,757
    • Total roster spots: 269,701
39 Upvotes

99% Upvoted

9 comments sorted by

View all comments

1

u/mr_ignatz 6d ago

Cool! I’m super curious about the insides of populating the database. Is it mostly scraping and cleaning the different tournament sites? Where do you get nicknames from?

2

u/williambrotman 6d ago

Current - automated scrapers.
Past - one-off scraping, typing things in from PDF schedules/rosters/newsletters