"Event ID","Event Name","Started At","Ended At" "358-2147483649-20170902","The Road America Challenge","2017-09-01 20:28:00 UTC","2017-09-04 23:59:59 UTC" "Venue ID","Venue Name","Venue Configuration ID","Venue Configuration Name","Venue Length","Venue units (km/mi)","Venue Direction" "79","Road America","140","Road America","4.0","mi","cw" "Group ID","Group Name","Run ID","Run Name","Type","Started At","Ended At","Status","Total Laps","Results URL" "2147483651","1. Purple Enduro","1073741833","Enduro","Race","2017-09-04 14:30:00 UTC","2017-09-04 16:05:47 UTC","PROVISIONAL","34","https://racehero.io/events/the-road-america-challenge/results/1073741833" "Name","Position","Position In Class","Number","Class","StartPos","StartPosInClass","GapToAhead","GapToAheadInClass","Gap to P1","Gap to P1 In Class","Total Laps","Total Time","Best Lap","Best Lap time","Best Speed","Average Speed","Total Distance","Total Pit Stops","S-Group","Color","E-Group","Description","Region" "GLENN WIEDENBECK","1","1","366","SP996","2","1","","","","0","34","5530.313","4","149.428","97.524","89.593","137.632","1","BLUE","BLACK/WHITE","PURPLE","02 996","MAV" "DAVID HODGES","2","2","41","SP996","3","2","","","37.744","37.744","34","5568.057","29","150.46","96.855","88.985","137.632","2","BLUE","BLACK","PURPLE","02 996","MAV" "GLEN SPIEGLER","3","1","58","GT4","4","2","","","1:04.546","0","34","5594.859","11","150.79","96.643","88.559","137.632","1","BLUE","WHITE/BLUE","PURPLE","71 911","CHO" "MATT DISTEFANO","4","1","93","SPC","7","1","","","1:19.289","0","34","5609.602","3","153.083","95.195","88.326","137.632","1","BLUE","BLACK","PURPLE","07 CAYMAN S","UCR" "CHRIS DOOLEY","5","2","404","SPC","10","3","","","2:14.930","55.641","34","5665.243","4","154.404","94.381","87.459","137.632","1","BLUE","GRAY","PURPLE","06 CAYMAN","PST" "CHED CROUSE","6","3","198","SP996","8","3","","","2:23.314","2:23.314","34","5673.627","10","154.393","94.388","87.33","137.632","1","BLUE","BLUE","PURPLE","99 CARRERA COUPE","BGS" "NEILS MEISSSNER","7","1","711","E","15","3","","","1 Lap","0","33","5532.161","4","155.663","93.618","86.928","133.584","1","GREEN","BLUE","PURPLE","S 84 911 CARRERA","MAV" "GREG TUREK","8","1","012","SP3","16","3","","","1 Lap","0","33","5556.284","3","156.397","93.178","86.551","133.584","1","GREEN","BLACK","PURPLE","89 944 S2","CHO" "ED DUNNE","9","2","86","SP3","12","2","","","1 Lap","11.804","33","5568.088","30","154.195","94.509","86.368","133.584","2","GREEN","BLACK","PURPLE","92 968 FIREHAWK","CHO" "DENNIS HIFFMAN","10","3","141","SP3","11","1","","","1 Lap","16.713","33","5572.997","4","155.204","93.894","86.292","133.584","1","GREEN","YELLOW","PURPLE","95 968 FIREHAWK","CHO" "MIKE KECK","11","4","691","SP3","18","4","","","1 Lap","17.561","33","5573.845","20","156.381","93.188","86.278","133.584","1","GREEN","BLACK","PURPLE","89 951","CHO" "MARK WHITE","12","2","935","E","13","1","","","1 Lap","43.158","33","5575.319","10","155.398","93.777","86.256","133.584","2","GREEN","WHITE","PURPLE","S 87 911","CHO" "JOHN COLLIER","13","3","513","SPC","9","2","","","1 Lap","1 Lap","33","5577.566","3","154.827","94.123","86.221","133.584","1","BLUE","GRAY","PURPLE","07 CAYMAN S","CHO" "K O'ROURKE / L CARPENTIER","14","1","006","F","26","1","","","1 Lap","0","33","5581.751","27","155.588","93.663","86.156","133.584","2","GREEN","BLACK","PURPLE","S 00 BOXSTER S","K O'ROURKE","NOO","/ L CARPENTIER" "STEVEN ANDERSON","15","3","61","E","34","7","","","1 Lap","54.769","33","5586.93","22","156.783","92.949","86.076","133.584","1","GREEN","BLACK","PURPLE","S 87 911","GEM" "JOHN MACHUL","16","4","113","E","28","6","","","1 Lap","57.059","33","5589.22","33","155.608","93.651","86.041","133.584","1","GREEN","RED","PURPLE","S 87 911","GCT" "TIM McLEAN","17","5","715","SP3","29","8","","","1 Lap","53.315","33","5609.599","27","157.567","92.486","85.728","133.584","1","GREEN","BLACK/WHITE","PURPLE","89 944 S2","CHO" "MARK HILL","18","1","318","H","22","2","","","1 Lap","0","33","5627.139","15","157.703","92.407","85.461","133.584","1","BLUE","BLACK","PURPLE","S 99 996","CHO" "FRANCOIS FAUST","19","4","367","SPC","20","4","","","1 Lap","20.022","33","5629.624","4","156.201","93.295","85.424","133.584","2","BLUE","SILVER","PURPLE","07 CAYMAN","UCR" "DOUG CROSSMAN","20","5","902","E","25","5","","","1 Lap","1:45.064","33","5637.225","14","159.197","91.539","85.308","133.584","1","GREEN","SILVER/BLUE","PURPLE","S 84 911","CHO" "JACK STRIFLING","21","6","87","E","40","10","","","1 Lap","2:14.564","33","5666.725","15","160.055","91.049","84.864","133.584","1","GREEN","RED","PURPLE","S 87 911","BGS" "MARC GUERETTE","22","2","038","F","30","2","","","1 Lap","1:25.115","33","5666.866","17","158.237","92.095","84.862","133.584","1","GREEN","BLACK","PURPLE","S 00 BOXSTER S","REN" "MICHAEL SCHMITZ","23","2","497","H","21","1","","","1 Lap","40.484","33","5667.623","33","158.065","92.195","84.851","133.584","1","BLUE","SILVER","PURPLE","S 99 911","MIL" "CHIP EGGLETON","24","7","40","E","43","12","","","1 Lap","2:38.299","33","5690.46","26","160.338","90.888","84.51","133.584","1","GREEN","BLUE","PURPLE","S 78 911","GCT" "TIM LAMBIE","25","5","515","SPC","36","5","","","2 Laps","2 Laps","32","5567.307","30","156.674","93.014","83.762","129.536","1","BLUE","SILVER","PURPLE","06 CAYMAN S","UCR" "CAROLE HALVORSEN","26","1","186","I","33","1","","","2 Laps","0","32","5600.835","11","156.666","93.018","83.261","129.536","1","BLUE","GREEN","PURPLE","S 09 CAYMAN S","CTV" "DAVID VARWIG","27","6","80","SP3","46","10","","","2 Laps","1:16.487","32","5632.771","3","162.508","89.674","82.789","129.536","1","GREEN","RED","PURPLE","89 951","CHO" "MA HOKE / MI HOKE","28","1","491","D","53","1","","","2 Laps","0","32","5652.006","8","162.978","89.416","82.507","129.536","1","GREEN","BLUE","PURPLE","S 80 911 SC","MA HOKE","NST","/ MI HOKE" "GREG ROJIK","29","7","320","SP3","47","11","","","2 Laps","1:49.845","32","5666.129","28","161.03","90.497","82.301","129.536","2","GREEN","RED","PURPLE","91 944 S2","PST" "CRAIG WATKINS","30","2","46","GT4","5","3","","","3 Laps","3 Laps","31","5544.046","4","152.104","95.808","81.485","125.488","1","BLUE","YELLOW","PURPLE","72 911","GG" "TYLER FARNER","31","1","787","GT5","71","2","","","3 Laps","0","31","5569.408","9","164.152","88.776","81.114","125.488","1","GREEN","WHITE","PURPLE","S 83 911 SC","SCH" "DAVID SWANSON","32","8","662","SP3","54","12","","","3 Laps","43.886","31","5600.17","26","165.844","87.871","80.668","125.488","1","GREEN","BLUE","PURPLE","92 968","CHO" "P HEPTIG / J BUCKLEY","33","1","914","SP1","55","1","","","3 Laps","0","31","5617.318","31","167.863","86.814","80.422","125.488","1","GREEN","RED","87 944","P HEPTIG","MAV","/ J BUCKLEY" "ANDREW BURKE","34","2","95","GT5","59","1","","","3 Laps","50.435","31","5619.843","31","164.758","88.45","80.386","125.488","1","GREEN","RED","PURPLE","S 79 911","SFL" "B CORCORAN / B WOLFSON","35","8","132","E","37","9","","","4 Laps","54.134","30","5586.295","7","164.38","88.653","78.26","121.44","1","GREEN","BLACK","PURPLE","S 85 911","B CORCORAN","NST","/ B WOLFSON" "DAN MAYER","36","1","6","SP2","62","2","","","4 Laps","0","30","5597.409","27","171.171","85.136","78.105","121.44","1","GREEN","WHITE/YELLOW","PURPLE","84 944","RMT" "MARK FENNER","37","9","70","SP3","63","13","","","4 Laps","2:25.567","30","5701.851","16","173.556","83.966","76.674","121.44","1","GREEN","BLACK","PURPLE","87 944 S","RMT" "BOB ENGLING","38","1","156","SP911","55","1","","","5 Laps","0","29","5544.037","14","169.307","86.073","76.228","117.392","1","GREEN","ORANGE","PURPLE","79 911","CTV" "DAVID AGRETELIS","39","3","92","GT4","6","4","","","6 Laps","6 Laps","28","4905.654","4","152.046","95.845","83.177","113.344","1","BLUE","BROWN","PURPLE","78 911","DIA" "CLARKE SIMPSON","40","9","213","E","19","4","","","12 Laps","11 Laps","22","3842.97","15","155.821","93.523","83.425","89.056","2","GREEN","WHITE","PURPLE","S 78 911 SC","POT" "SHANE DENNEY","41","2","57","SP2","61","1","","","17 Laps","13 Laps","17","3310.967","14","172.235","84.61","74.823","68.816","1","GREEN","BLUE","PURPLE","87 944","LTR" "CHESTER BAILEY","42","2","322","D","60","2","","","17 Laps","7.936","17","5659.942","3","172.992","84.24","43.77","68.816","1","GREEN","WHITE","PURPLE","S 83 911 SC","WIC" "RANDY ALEXANDER","43","10","070","E","49","13","","","19 Laps","18 Laps","15","2767.904","9","160.617","90.73","78.974","60.72","1","GREEN","WHITE","PURPLE","S 82 911 SC","CHO" "JIM HAMMAN","44","10","74","SP3","23","5","","","23 Laps","22 Laps","11","1810.922","6","157.72","92.397","88.519","44.528","1","GREEN","BLACK","PURPLE","84 968","CHO" "BRENT HOOVER","45","11","936","E","57","16","","","25 Laps","24 Laps","9","1566.441","5","170.085","85.68","83.728","36.432","0","GREEN","BLACK","PURPLE","S 86 911","INT" "CLAUDIO KAEMPF","46","4","66","GT4","1","1","","","DNF","1 Lap","33","5414.796","23","148.564","98.091","88.813","133.584","2","BLUE","BLUE","PURPLE","70 911","WMI" "DANIEL MARTINSON","47","12","781","E","14","2","","","DNF","10 Laps","23","3999.668","6","154.656","94.227","83.801","93.104","2","GREEN","WHITE","PURPLE","S 78 911 EURO SC","NST" "BOB DANKO","48","13","339","E","56","15","","","DNF","12 Laps","21","4032.677","10","163.883","88.922","75.887","85.008","2","GREEN","SILVER","PURPLE","S 82 911 SC EURO","CHO" "G COLLINS / J COLLINS","49","11","323","SP3","24","6","","","DNF","15 Laps","18","2853.407","4","155.489","93.722","91.929","72.864","0","GREEN","BLUE","PURPLE","88 951","G COLLINS","CHO","/ J COLLINS" "JEFF PAWLOWSKI","50","12","418","SP3","45","9","","","DNF","19 Laps","14","2470.965","4","166.025","87.775","82.567","56.672","2","GREEN","SILVER","PURPLE","89 968","CHO" "BILL PAWLAN","51","13","26","SP3","27","7","","","DNF","20 Laps","13","2502.183","7","157.919","92.28","75.712","52.624","2","GREEN","WHITE","PURPLE","89 944 S2","CHO" "M WILLIAMS / J SHOFFIT","52","4","517","SP996","17","4","","","DNF","27 Laps","7","1622.9","6","154.881","94.09","62.856","28.336","1","BLUE","BLACK","PURPLE","00 996 C2","M WILLIAMS","MAV","/ J SHOFFIT" "JUAN PORRO","53","14","775","E","35","8","","","DNF","28 Laps","5","854.929","3","160.338","90.888","85.228","20.24","1","GREEN","BLACK","PURPLE","S 86 911","GCT" "JOHN WESTRA","54","5","199","GT4","39","5","","","DNF","31 Laps","3","511.133","3","162.569","89.641","85.532","12.144","0","BLUE","BLUE","PURPLE","75 911 S","CHO" "FRANCIS FLORIDO","55","15","48","E","42","11","","","DNF","30 Laps","3","516.701","3","163.065","89.368","84.611","12.144","0","GREEN","RED","PURPLE","S 86 911","CTV" "J GAUCHER / E GAUCHER","56","16","469","E","51","14","","","DNF","30 Laps","3","551.516","2","171.066","85.188","79.27","12.144","1","GREEN","RED","PURPLE","S 81 911 EURO SC","J GAUCHER","CHO","/ E GAUCHER"