menu

Database model

When we started ProCyclingStats in 2013, we focussed on UCI results to make sure we were 99.9% accurate on that. We decided not to collect national results, because the large number of national results would mean we could never garantuee a certain quality level. However, there is certainly value in these results, as every pro rider starts out on a national level. Now that we have a solid database structure in place, we are starting to collect and process national results. Therefore we have made a separation between both datasets, a database with pro results and a mirror database with national results. For the pro DB we maintain the same quality level as ever. For the national DB we maintain a looser structure. For example, in national results it is possible that not all rider names are dynamic. When no rider is connected to a result, a flat text name is shown.
Pro DB
Pro race levels
  • WT
  • Pro
  • Level 1
  • Level 2
  • National


Pro team levels
  • WT
  • Pro
  • Continental
  • National
National DB
National race levels
  • 1st
  • 2nd
  • 3rd
  • 4th


National team levels
  • 1st
  • 2nd
  • 3rd
Visible on ProCyclingStats
Not visible
We start out by collecting results from the highest national levels. The above scheme depicts the way road racing is structured. At the top of the pyramid are the WorldTour races. Then follows the Pro level, level 1 and level 2 races. Below level 2 races are the national races. These national races are also made up out of different levels. Each national federation maintains a different structure, but most federations have a pyramid structure with a top level segment of races. We are able to process all national race levels, but for now we only show the top level within the ProCyclingStats profiles and pages.