Rider data

A programming hiccup.
When searching in the database for riders with Junior Status, there appear 16 names, all born 1998 or before, so all in fact Elite-2.
When searching for riders born >=1999 (Junior or Youth), there are 71 names, in the data base all with the Status Elite-2…
(In the Rider database of CQ Women it works without problem)

DijkCQ wrote:

These statuses are fixed and apparently never updated. I've updated the statuses now according to their 2018 status (to be pragmatic).

7673;ROJAS ROMERO Maximo Eliecer
26312;TAKAPE Eroni;FIJ1974
26412;PULIDO ARANGO Juan Alberto
26414;HIDALGO Ignacio
26619;TRIMINIO MARTINEZ Cristhian Antonio;HON19950830
26621;MELGAR CARDONA Oscar Emanuel;HON1989
26772;REEVES Randall;GUM1965
26774;MEDINA Rafael;VEN19941013; ID 10015109853
27443;SIERRA PEREZ Robert David
27585;RASTEGORAC GRUBISIC Antonio Jesus

27846;SYROVATKA Matej; ID 10010967145
27848;VARHANOVSKY Jakub; ID 10010967751
27849;MELIS Matus; ID 10015814923
27850;ANDERSSON Andreas; ID 10011055253
27851;JAKOUBEK Tomas; ID 10047443690

DijkCQ wrote:

Done.

26772;REEVES Randall;GUM19650930

DijkCQ wrote:

Done.

24319;ROSA BENITEZ Hector Fabian;PAR19920804
27855;CRISPIM Andre Filipe Roxo; ID 10014937677
27856;ROCHA Felipe Jose Parente
27858;GUO Kai; ID 10015339623
27859;PEÑA MOLANO Wilson Estiben; ID 10053637950
27860;JENSEN Jeppe Klein; ID 10036502595
27861;DE VILLE Jelle;BEL19950710; ID 10013549567
27862;ZHI Tianxiang; ID 10053581467
27863;ZHAO Riquiang; ID 10015340027
27864;MARTINEZ Carmelo Franco; wrong entry, no CQ result nor team, delete
27865;MCPHADEN Cameron; ID 10014483801
27866;TOMIO Daichi; ID 10014374673
27867;MUNYANEZA Didier; ID 10016117037
27877;GOUDIN Valentin; ID 10026105411

The list of pending posts is getting rather long…

DijkCQ wrote:

Done.

27879; MENDEZ Gabriel USA19991127

DijkCQ wrote:

Done.

4993;MEZA CASTRO Daniel Eduardo;HON19820515
26620;FLORES VARELA Ariel Eduardo
26622;ARGUETA RIOS Joyner Jaffeth;HON19940827
26623;LOPEZ MEJIA Marlon Goel;HON19900529
27869;CABRERA LOPEZ Junior Antonio
27870;MOLINA GUEVARA Gerson;HON19941207
27873;LOZANO Rene Orlando

DijkCQ wrote:

Done.

17712;EDWARDS Tyrone;JAM19770411
18191;NARTEY William;GHA19880606
26716;RIYADI Jeri Sutomo (10043849337). He is a second time in the UCI database as RIADI Jeri under ID 10014584538
27875;TAEBLING Paul; ID 10015768039
27876;ÖRENCIK Ahmet; ID 10015326788
27878;SCHUNK Conor; ID 10049932045
27879;MENDEZ Gabriel; ID 10063853363
27880;MCCORMACK Brendan; ID 10013385980
27881;HEIDERSCHEID Colin;LUX19980128; @ColHeiderscheid; ID 10009748581
27882;BLUMMEL Robin;NED19990610; ID 10015681244
27883;KNOLLE Jon; ID 10015766726
27884;MÜNSTERMANN Per;@PerMuenstermann; ID 10036495424
27885;HODAPP Johannes;GER19990909; ID 10015766524
27886;GIESSELMANN Michel; ID 10036198663
27887;KNAPP Daniel; ID 10014640920
27888;MANSOURI Hamza;ALG19990413; ID 10015589294
27889;MENGOULAS Alex; ID 10014217655
27890;MAAS Danny; @MaasDanny; ID 10015689732
27891;CHAVES RUBIO Brayan; @BrayanChavesr
27892;BECHKOV Aleks;BUL19990214; ID 10052873872
27893;NIKOLOV Konstantin;BUL19990524; ID 10023473677
27894;TRANNINGER Elias; ID 10008079777
27895;WARD Tristan;AUS19950818; ID 10009489412
27896;POTOCKI Viktor; ID 10015338007
27897;DEBEVEC Blaz;SLO19990215; ID 10017562337
27903;SOLEH Abdul; ID 10054558339
27905;RAJCHART Jan; ID 10008820213
27906;BRAYAN-LUND Thomas; ID 10014713466

DijkCQ wrote:

Done.

I just continue adding these posts in the hope that you will find one day the time to enter the information in the database.
(starting from two months ago, September 28….)

22117;KRAMP Kelly;CAN1962
23935;NASCIMENTO Edney
27907;HJORTH Jonas; @jonashjorth; ID 10013853196
27910;MAZZONE Leon;GBR19961213; http://leonmazzone.blogspot.com ; ID 10014671434
27911;BATT Ethan;NZL19980820; ID 10011156701
27913;OM PRAKASH; Retired > Elite-2
27914;NEVES Jose, with the date of birth of the Oliveira Alves twins, is probably a wrong entry  for 27471;FERNANDES Jose Carlos Prates Neves.
27915;WIGGINS Craig;AUS19990528; Retired > Junior
27916;NOLAN Liam;AUS19990305; @LiamNolan1999; Retired > Junior
27917;GROUBE Carne; ID 10010750816; Retired > Elite-2
27918;BROWN Connor;NZL19980806; ID 10010794060; Retired > Elite-2
27919;WIGHT Rohan; ID 10010597737
27920;ERIKSSON Jacob; ID 10011048785
27921;HJEMSAETER Olav;NOR19961226; ID 10015486032
27922;VANDEBOSCH Toon; @ToonVandebosch; ID 10010943604
27923;TURNER Ben; ID 10010947038

DijkCQ wrote:

Done. Deleted Neves, put the Retired > Junior to Elite-2 to be ready for 2018, found more info for Prakash. UCI has Evan Bybee born as USA19890312.

stephane david wrote:

27795; SANTOS João Castro Guimarães ID : 10008821829
27796; SANTOS André Gonçalo Duarte ID : 10014953340
27797 ... I've found this :  João Bernardo Quaresma Saavedra Pereira Leite !!

UCI ID 10044603210 is Joao Leite, POR19980501. What's the CQ standard? SAAVEDRA João Bernardo Quaresma Pereira Leite?

Finally up to date, except for my previous post.

DijkCQ wrote:

Finally up to date, except for my previous post.

Well done, that must have been a very busy Sunday afternoon…

Just a few leftovers:
13540;LOBATO DEL VALLE Juan Jose; www.juanjolobato.com
16092;RAZAFINDRAKOTO Alain Hasinavalona
26414;HIDALGO Ignacio
26621;MELGAR CARDONA Oscar Emanuel;HON1989
26716;RIYADI Jeri Sutomo (like his brother Elan in the same team)
27791;ORTIZ FRAUSTO Jesus;MEX19920916

Dijk wrote:

Done.

DijkCQ wrote:

stephane david wrote:

27797 ... I've found this :  João Bernardo Quaresma Saavedra Pereira Leite !!

UCI ID 10044603210 is Joao Leite, POR19980501.  What's the CQ standard?  SAAVEDRA João Bernardo Quaresma Pereira Leite?

I vote for LEITE Joao Bernardo Quaresma Saavedra Pereira (if there is space for all that) because in general the father’s name, the family name for CQ, comes in Portugal at the end of the sausage.
As LEITE Joao is his UCI name, this will also give the least chance for confusion when entering results.

DijkCQ wrote:

..... found more info for Prakash ......

I do not think that the Om Prakash who finished 4th in the ITT Men (and 2nd with SSCB in the TTT Men) of the Indian championships in February 2016 is Thalor because Thalor Omprakash (10.10.1998) participated in the same championships in the Junior category in the ITT, TTT and Road Race.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2017/06/Final-results-20th-NRCC.pdf

I found an Om Prakash born 08.10.1990 in the list of participants of the Indian track championships 2014 but no idea whether this could be our man. Thalor Omprakash is actually also in this list.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2015/03/License-card-issued-during-67-NTCC.pdf

Hans wrote:

DijkCQ wrote:

..... found more info for Prakash ......

I do not think that the Om Prakash who finished 4th in the ITT Men (and 2nd with SSCB in the TTT Men) of the Indian championships in February 2016 is Thalor because Thalor Omprakash (10.10.1998) participated in the same championships in the Junior category in the ITT, TTT and Road Race.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2017/06/Final-results-20th-NRCC.pdf

I found an Om Prakash born 08.10.1990 in the list of participants of the Indian track championships 2014 but no idea whether this could be our man. Thalor Omprakash is actually also in this list.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2015/03/License-card-issued-during-67-NTCC.pdf

I found these UCI IDs for a Om Prakash: 10050508890, 10050712186 (the 1998-guy), 10015505230 (the 1998-guy again), 10050716634, 10050981665 (too young).  The first one is born in 1996.

From what result did he enter our database? Since he got no result now and we don't know who he is, we might as well delete him.

Hans wrote:

DijkCQ wrote:

stephane david wrote:

27797 ... I've found this :  João Bernardo Quaresma Saavedra Pereira Leite !!

UCI ID 10044603210 is Joao Leite, POR19980501.  What's the CQ standard?  SAAVEDRA João Bernardo Quaresma Pereira Leite?

I vote for LEITE Joao Bernardo Quaresma Saavedra Pereira (if there is space for all that) because in general the father’s name, the family name for CQ, comes in Portugal at the end of the sausage.
As LEITE Joao is his UCI name, this will also give the least chance for confusion when entering results.

Nope, not enough space :-(
Shall we drop the Quaresma?

DijkCQ wrote:

Hans wrote:

DijkCQ wrote:

stephane david wrote:

27797 ... I've found this :  João Bernardo Quaresma Saavedra Pereira Leite !!

UCI ID 10044603210 is Joao Leite, POR19980501.  What's the CQ standard?  SAAVEDRA João Bernardo Quaresma Pereira Leite?

I vote for LEITE Joao Bernardo Quaresma Saavedra Pereira (if there is space for all that) because in general the father’s name, the family name for CQ, comes in Portugal at the end of the sausage.
As LEITE Joao is his UCI name, this will also give the least chance for confusion when entering results.

Nope, not enough space :-(
Shall we drop the Quaresma?

Either Quaresma or Pereira. I let you choose.

DijkCQ wrote:

Ok. Dropped Quaresma

DijkCQ wrote:

Hans wrote:

DijkCQ wrote:

..... found more info for Prakash ......

I do not think that the Om Prakash who finished 4th in the ITT Men (and 2nd with SSCB in the TTT Men) of the Indian championships in February 2016 is Thalor because Thalor Omprakash (10.10.1998) participated in the same championships in the Junior category in the ITT, TTT and Road Race.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2017/06/Final-results-20th-NRCC.pdf

I found an Om Prakash born 08.10.1990 in the list of participants of the Indian track championships 2014 but no idea whether this could be our man. Thalor Omprakash is actually also in this list.
Link: http://cyclingfederationofindia.org/web/wp-content/uploads/2015/03/License-card-issued-during-67-NTCC.pdf

I found these UCI IDs for a Om Prakash: 10050508890, 10050712186 (the 1998-guy), 10015505230 (the 1998-guy again), 10050716634, 10050981665 (too young).  The first one is born in 1996.

From what result did he enter our database?  Since he got no result now and we don't know who he is, we might as well delete him.

The result is still there, http://www.cqranking.com/men/asp/gen/race.asp?raceid=29434 , and the link from number 4 to id 27913 works, but not the other way around for some reason.
I think the man we are looking for is ID 10050716634, Om PRAKASH, IND19901008, for two reasons:
(i) In the result of the Indian Federation he is just called Om Prakash, like in the UCI database, without the addition of Mahato (10050508890) or Thalor (10050712186).
(ii) He is participating on national level in championships as he appears on the list of particiants in the track championships 2014.

Hans wrote:

The result is still there, http://www.cqranking.com/men/asp/gen/race.asp?raceid=29434 , and the link from number 4 to id 27913 works, but not the other way around for some reason.
I think the man we are looking for is ID 10050716634, Om PRAKASH, IND19901008, for two reasons:
(i) In the result of the Indian Federation he is just called Om Prakash, like in the UCI database, without the addition of Mahato (10050508890) or Thalor (10050712186).
(ii) He is participating on national level in championships as he appears on the list of particiants in the track championships 2014.

You are right.  Om PRAKASH, IND19901008 it is.

There were 2 National Championships in India in 2016.  The problem with the result is that the race has RaceYear 2015 and the results are in RaceYear 2016.  The index page of the rider uses the RaceYear of the results and the results page uses the RaceYear of the race.  
See: http://www.cqranking.com/men/asp/gen/rider_palm.asp?riderid=27913&year=2015&all=1&current=0
I can easily change the RaceYears, but changing the code is a lot harder.  Let me check why it is done like this.  Maybe the Indian Championship was postponed and we forgot to change the race year.

DijkCQ wrote:

There were 2 National Championships in India in 2016.  The problem with the result is that the race has RaceYear 2015 and the results are in RaceYear 2016.  The index page of the rider uses the RaceYear of the results and the results page uses the RaceYear of the race.  
See: http://www.cqranking.com/men/asp/gen/rider_palm.asp?riderid=27913&year=2015&all=1&current=0
I can easily change the RaceYears, but changing the code is a lot harder.  Let me check why it is done like this.  Maybe the Indian Championship was postponed and we forgot to change the race year.

Yes, the February 2016 races were indeed the delayed 2015 championships.
With CQ Women the linking problem was “solved” by putting the ITT on the fictitious date of 30/12/2015 and the RR on 31/12/2015. A Race Comment on the results page gives the actual date the championships took place.

Hans wrote:

DijkCQ wrote:

Hans wrote:

DijkCQ wrote:

stephane david wrote:

27797 ... I've found this :  João Bernardo Quaresma Saavedra Pereira Leite !!

UCI ID 10044603210 is Joao Leite, POR19980501.  What's the CQ standard?  SAAVEDRA João Bernardo Quaresma Pereira Leite?

I vote for LEITE Joao Bernardo Quaresma Saavedra Pereira (if there is space for all that) because in general the father’s name, the family name for CQ, comes in Portugal at the end of the sausage.
As LEITE Joao is his UCI name, this will also give the least chance for confusion when entering results.

Nope, not enough space :-(
Shall we drop the Quaresma?

Either Quaresma or Pereira. I let you choose.

DijkCQ wrote:

Ok.  Dropped Quaresma

He's called Saavedra for his team

LeonCQ wrote:

Terrible...
Well, let's call him SAAVEDRA LEITE Joao Bernardo Pereira then, if Saavedra is his 'racing name'.

DijkCQ wrote:

There were 2 National Championships in India in 2016.  The problem with the result is that the race has RaceYear 2015 and the results are in RaceYear 2016.  The index page of the rider uses the RaceYear of the results and the results page uses the RaceYear of the race.  
See: http://www.cqranking.com/men/asp/gen/rider_palm.asp?riderid=27913&year=2015&all=1&current=0
I can easily change the RaceYears, but changing the code is a lot harder.  Let me check why it is done like this.  Maybe the Indian Championship was postponed and we forgot to change the race year.

The links between the results of the February 2016 races and the rider pages all work well now but in the Palmares table on the History page of both the Indian ITT and RR Championships, there are two blank lines….

Hans wrote:

DijkCQ wrote:

There were 2 National Championships in India in 2016.  The problem with the result is that the race has RaceYear 2015 and the results are in RaceYear 2016.  The index page of the rider uses the RaceYear of the results and the results page uses the RaceYear of the race.  
See: http://www.cqranking.com/men/asp/gen/rider_palm.asp?riderid=27913&year=2015&all=1&current=0
I can easily change the RaceYears, but changing the code is a lot harder.  Let me check why it is done like this.  Maybe the Indian Championship was postponed and we forgot to change the race year.

The links between the results of the February 2016 races and the rider pages all work well now but in the Palmares table on the History page of both the Indian ITT and RR Championships, there are two blank lines….

I know. Changing data won't solve both problems. I have to change the code of the website.

LIN Wen Shing (ID 18303, no date of birth) has no CQ results but is in the database as member of the Taiwanese team Fuji - Cyclingtime.com in 2011. He was indeed in the list of riders when the creation of the team was announced (here), but he was never in the UCI roster of Fuji that year. Could have been a misspelling of one of the other LIN’s that are in that UCI roster. Suggest to delete.

17616;DIALLO Chiaka;MLI19740211; ID10008463030
20380;TRUSSELL Chris;GBR19890814
21595;GOODYER Timothy;BER1975
24171;DOSSOUVI Komi Kowouvi;TOG19750312
25707;FERNANDES Venceslau Sousa
27854;CARIÑO Daniel Ver
27926;KOCKELMANN Raphaël; www.raphaelkockelmann.lu and @KockelmannRaph
27930;AMANN Dominik; ID 10016012559
27931;HIRSCHBICHLER Johannes; ID 10035058309
27932;BAYER Tobias; ID 10011072229
27933;GAMPER Mario; ID 10015332549
27934;GAMPER Florian; ID 10015329620
27937;BABOR Daniel; ID 10015327903
27938;TYRPEKL Karel; ID 10047918081
27939;DOLNICEK Marek; ID 10015528771
27940;BARTA Tomas; ID 10051673294
27941;MACIEJUK Filip; ID 10015329923
27942;BASSO Luiz Guilherme Morosini;BRA19990322
27943;LOPES Pedro Miguel; ID 10015332751
27945;DINIS Joao Traila;POR19990325; ID 10011167310
27946;COSTA Fabio; double entry for 24706;COSTA Fabio
27947;LOPES Pedro Jose Ramos;POR19990127; ID 10015333761
27948;LISSON Joakim; ID 10015599503
27951;POTTER Michael; ID 10009557918
27954;KUBA Karel;CZE19990602; ID 10016145026

Dijk wrote:

Done, but kept Lin. Maybe Leon knows about this team composition.

A few updates to 2017-18 transfers

Drapac - Pat's Veg Holistic Development Team - Brad Evans can be confirmed as moving to Mobius BridgeLane link

UnitedHealthcare - Greg Henderson can now be confirmed as retired link

Team LottoNL - Jumbo - Twan Castelijns also confirmed as retired? (I don't speak Dutch...) link

LeonCQ wrote:

Castelijns will probably continue as an amateur rider, so he won't be registered as Retired yet

25391;ROSS Dion Sandile;RSA1990
27955;KIERNER Florian; ID 10015765110
27956;ANDREWS Benjamin;AUS19970226
27958;PUGLIESE Antonino Schillaci;ITA19900706; ID 10013834709
27959;MORA GARITA Melvin Alexander;CRC19891119; ID 10053221153

Dijk wrote:

Done.