Welsh Castles Relay Results — Help

WCR Emblem

Help

Help — Welsh Castles Relay Historic Results Database

This site provides searchable access to historic Welsh Castles Relay results from 1983 onward, covering every year the race has been held (excluding 2001 when Foot & Mouth cancelled the event, and 2020–2021 when no race took place due to COVID-19). These results came from mostly scans of paper results held here WCR Historic Results

Stage Results

Select a year and stage to view the full results for that stage. Results are ordered by finishing position. Use the Previous / Next links to navigate between stages. Each entry shows the runner's name, club, category (Open / Ladies / Vets / Business House), time, and age category. Runners marked NRE (No Runner Entered) indicate the team did not field a runner on that stage and received a penalty time.

Overall Results

Select a year to see the final team standings. Teams are ranked by total time across all stages. Only teams with a complete set of stage results (one runner on every stage) appear in the standings. The table shows each team's club, category, total time, and stage count.

Stage Records

View course records for each stage across all years. Select a stage number to see the fastest male and female times on record for that stage. Records carry forward year-to-year when the stage distance remains unchanged. Use the Year filter to focus on a specific year. The table shows the record time, the athlete who set it, and the stage distance. Click the stage number heading to open a Google My Maps map showing all 20 stage routes.

Runner Search

Search for athletes by name, club, year range, stage, category, sex, or age category.

Name search supports boolean operators:

  • John Smith — both terms must match (AND)
  • John OR Smith — either term matches
  • John NOT Smith or John -Smith — exclude a term
  • "Les Croupiers" John — quoted phrase AND term
  • Dav% — raw SQL LIKE pattern (use % as wildcard)

Click Advanced filters to narrow by club, year range, stage, race category, sex, or age category. All filters are combinable and appear in the URL for bookmarking.

Team Appearances

Browse all clubs that have participated in the Welsh Castles Relay, with the years they competed and total entries. Clubs are grouped by normalised name and category. The Total years column shows how many different years a club has fielded at least one team.

Statistics

View aggregate statistics across all years of data:

  • Total unique teams and runners
  • Top 10 runners by number of appearances
  • Top 10 runners by stage wins (includes mountain-stage win count)
  • Top 10 female runners by first-female finishes
  • Outright female stage winners (women who finished first overall on a stage)
  • Top 5 overall club winners and top 5 Ladies club winners by year

About the data

Results from 1983 to 2006 were extracted from scanned JPG images/PDF using OCR (optical character recognition). Results from 2007 onward were parsed from PDF files. The most recent years (2022+) are loaded from Google Sheets exports. Cross-checking every result against the original source materials is an ongoing process — it takes time, but that is always the goal.

Data sources:

  • 1983–2006: A variety of formats in PDFs/JPGs dictated or extracted with Tesseract OCR or Google Gemini and my smartphone
  • 2007–2019: PDF stage result files
  • 2022–present: Google Sheets exports from the race organisers