"Event ID","Event Name","Started At","Ended At" "358-140-2147483687-20180901","The Road America Challenge 2018","2018-09-01 13:30:00 UTC","2018-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" "2147483688","Green 1","1073742013","Green 1 Race 1","Race","2018-09-02 15:20:00 UTC","2018-09-02 15:56:20 UTC","FINAL","12","https://racehero.io/events/the-road-america-challenge-2018/results/1073742013" "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","Color","Description","Sprint Group","Enduro Group","ZONE","Region","License Type" "JOHN POOR","1","1","555","GT5","4","1","","","","0","12","1886.736","2","154.077","94.581","92.686","48.576","0","SILVER","72 914-6","GREEN","PURPLE","12","GCT","FULL" "NIELS MEISSNER","2","1","06","E","1","1","","","0.272","0","12","1887.008","5","154.427","94.367","92.672","48.576","0","BLUE","S 79 911 EURO SC","GREEN","PURPLE","5","LST","FULL" "DANIEL MARTINSON","3","2","78","E","3","3","","","1.018","0.746","12","1887.754","2","154.406","94.38","92.636","48.576","0","WHITE","S 78 911 EURO SC","GREEN","PURPLE","10","NST","FULL" "PAT HEPTIG","4","3","714","E","5","4","","","1.092","0.82","12","1887.828","9","155.185","93.906","92.632","48.576","0","WHITE","S 87 911","GREEN","5","MAV","FULL" "MARK WHITE","5","4","935","E","8","7","","","28.126","27.854","12","1914.862","7","157.065","92.782","91.324","48.576","0","WHITE","S 87 911","GREEN","PURPLE","13","CHO","FULL" "KAI BOCKMANN","6","1","619","F","10","1","","","41.136","0","12","1927.872","8","157.374","92.6","90.708","48.576","0","SILVER","S 04 BOXSTER","GREEN","PURPLE","13","CHO","FULL" "RICK POLK","7","5","27","E","7","6","","","41.667","41.395","12","1928.403","2","157.442","92.56","90.683","48.576","0","BLACK","S 87 CARRERA","GREEN","10","NST","FULL" "ALAN WEINER","8","6","186","E","11","8","","","46.716","46.444","12","1933.452","6","158.942","91.686","90.446","48.576","0","BLACK","S 87 911","GREEN","PURPLE","10","NST","FULL" "FRANCIS FLORIDO","9","2","006","F","15","3","","","49.117","7.981","12","1935.853","7","158.451","91.97","90.334","48.576","0","BLACK","S 00 BOXSTER S","GREEN","PURPLE","1","CTV","FULL" "MATT CLARK","10","7","124","E","6","5","","","50.290","50.018","12","1937.026","7","157.132","92.742","90.279","48.576","0","SILVER","S 87 951","GREEN","10","NST","FULL" "CHERYL LEHMAN COLLIER","11","2","514","GT5","9","2","","","51.116","51.116","12","1937.852","7","158.294","92.062","90.241","48.576","0","BLACK","97 993","GREEN","PURPLE","13","CHO","FULL" "BILL WOLFSON","12","8","07","E","12","9","","","56.155","55.883","12","1942.891","5","159.158","91.562","90.007","48.576","0","BLACK","S 85 911 CARRERA","GREEN","PURPLE","10","NST","FULL" "MARK HILL","13","9","316","E","13","10","","","1:00.012","59.74","12","1946.748","8","159.693","91.255","89.829","48.576","0","RED","S 86 911","GREEN","PURPLE","13","CHO","FULL" "CHIP SMITH","14","3","13","F","16","4","","","1:05.597","24.461","12","1952.333","8","159.549","91.337","89.572","48.576","0","RED","S 90 964 C2","GREEN","PURPLE","10","NST","FULL" "RANDY ALEXANDER","15","10","077","E","17","11","","","1:18.983","1:18.711","12","1965.719","6","161.143","90.434","88.962","48.576","0","WHITE","S 82 911 SC","GREEN","PURPLE","13","CHO","FULL" "KARL POELTL","16","1","371","SP3","35","1","","","1:31.612","0","12","1978.348","4","153.872","94.707","88.394","48.576","0","WHITE","89 968 S2","GREEN","PURPLE","3","SMT","FULL" "ANDREW BURKE","17","11","90","E","20","13","","","1:35.397","1:35.125","12","1982.133","4","162.676","89.582","88.225","48.576","0","WHITE","S 82 911","GREEN","PURPLE","12","SFL","FULL" "MATTHEW GOETZINGER","18","12","126","E","23","16","","","1:44.494","1:44.222","12","1991.23","4","162.787","89.521","87.822","48.576","0","BLUE/WHITE","S 88 911","GREEN","PURPLE","13","MIL","FULL" "BILL CORCORAN","19","13","132","E","19","12","","","1:53.594","1:53.322","12","2000.33","8","163.035","89.384","87.422","48.576","0","BLACK","S 85 911","GREEN","PURPLE","10","NST","FULL" "DENNIS HIFFMAN","20","2","141","SP3","38","4","","","1:59.680","28.068","12","2006.416","8","155.341","93.812","87.157","48.576","0","YELLOW","95 968 FIREHAWK","GREEN","PURPLE","13","CHO","FULL" "GREG TUREK","21","3","012","SP3","39","5","","","2:00.692","29.08","12","2007.428","8","155.731","93.577","87.113","48.576","0","BLACK","89 944 S2","GREEN","PURPLE","13","CHO","FULL" "MIKE KECK","22","4","691","SP3","40","6","","","2:02.714","31.102","12","2009.45","4","156.29","93.242","87.026","48.576","0","BLACK","89 951","GREEN","PURPLE","13","CHO","FULL" "JOHN GLUECKERT","23","5","358","SP3","37","3","","","2:07.795","36.183","12","2014.531","8","157.116","92.752","86.806","48.576","0","BLACK","91 944 S2","GREEN","PURPLE","13","CHO","FULL" "RAY RAMIREZ","24","14","59","E","26","17","","","2:07.939","2:07.667","12","2014.675","5","164.18","88.761","86.8","48.576","0","GREEN","S 83 911","GREEN","PURPLE","5","LST","FULL" "ROB HALE","25","1","61","D","28","1","","","2:08.136","0","12","2014.872","8","163.228","89.279","86.791","48.576","0","YELLOW","S 74 911","GREEN","PURPLE","3","MSO","FULL" "SIGGI MEISSNER","26","15","760","E","27","18","","","2:08.189","2:07.917","12","2014.925","8","163.706","89.018","86.789","48.576","0","BLUE","S 79 911 EURO SC","GREEN","PURPLE","5","LST","FULL" "CHUCK REITER","27","6","23","SP3","41","7","","","2:09.037","37.425","12","2015.773","8","156.429","93.159","86.753","48.576","0","BLUE","91 944 S2","GREEN","13","CHO","FULL" "GREGG WILSON","28","16","10","E","22","15","","","2:09.266","2:08.994","12","2016.002","8","163.692","89.026","86.743","48.576","0","YELLOW","S 81 911 SC EURO","GREEN","2","DEL","FULL" "JOE GAUCHER","29","17","469","E","34","20","","","2:10.617","2:10.345","12","2017.353","8","163.202","89.293","86.685","48.576","0","RED","S 81 911 EURO SC","GREEN","PURPLE","13","CHO","FULL" "JOSHUA VIEIRA","30","1","199","SPB","24","1","","","2:11.930","0","12","2018.666","2","164.808","88.423","86.628","48.576","0","WHITE","97 BOXSTER","GREEN","2","POT","FULL" "STAN WENGER","31","2","622","SPB","25","2","","","2:13.635","1.705","12","2020.371","7","164.234","88.732","86.555","48.576","0","BLACK","98 BOXSTER","GREEN","5","HCT","FULL" "DUANE CRANDALL","32","18","025","E","29","19","","","2:31.371","2:31.099","12","2038.107","4","163.72","89.011","85.802","48.576","0","BAMBOO","S 82 911 EURO SC","GREEN","PURPLE","10","NST","FULL" "CORY HOEGLUND","33","3","51","SPB","30","3","","","2:51.417","39.487","12","2058.153","8","167.177","87.17","84.966","48.576","0","MAROON","97 BOXSTER","GREEN","10","NST","FULL" "JEFF PAWLOWSKI","34","7","418","SP3","47","13","","","1 Lap","1 Lap","11","1897.633","7","161.385","90.298","84.474","44.528","0","GRAY","90 944","GREEN","PURPLE","13","CHO","FULL" "DAVID BYASSEE","35","4","986","SPB","33","4","","","1 Lap","1 Lap","11","1898.101","7","168.511","86.48","84.453","44.528","0","ORANGE/BLACK","99 BOXSTER","GREEN","PURPLE","9","RMT","FULL" "GREG ROJIK","36","8","320","SP3","49","15","","","1 Lap","1 Lap","11","1907.519","6","160.845","90.602","84.036","44.528","0","RED","91 944 S2","GREEN","ROJIK","PURPLE","3","PST","FULL" "FRED WICKS","37","9","95","SP3","46","12","","","1 Lap","1 Lap","11","1912.562","2","160.027","91.065","83.815","44.528","0","BLACK","89 951","GREEN","PURPLE","12","SFL","FULL" "BOB DANKO","38","19","339","E","50","21","","","1 Lap","1:35.257","11","1982.265","4","167.061","87.23","80.867","44.528","0","SILVER","S 82 911 SC EURO","GREEN","PURPLE","13","CHO","FULL" "MIKE FAEMS","39","10","941","SP3","45","11","","","1 Lap","40.258","11","2018.606","6","162.119","89.89","79.412","44.528","1","BLUE","93 968","GREEN","PURPLE","14","YEL","FULL" "KEITH DAVIS","40","2","116","D","31","2","","","2 Laps","2 Laps","10","1944.673","7","172.357","84.55","74.937","40.48","0","WHITE","S 81 911 SC","GREEN","PURPLE","3","MSO","FULL" "CAL SHARP","41","11","602","SP3","48","14","","","2 Laps","2 Laps","10","1972.904","5","166.044","87.765","73.865","40.48","1","ROSE/GOLD","89 951 S","GREEN","4","RSP","FULL" "SCOTT PLUNKETT","42","4","434","F","14","2","","","DNF","3 Laps","9","1450.934","7","158.422","91.987","90.394","36.432","0","RED","S 90 911","GREEN","PURPLE","3","MSO","FULL" "MARK WEINING","43","20","7","E","21","14","","","DNF","3 Laps","9","1492.769","7","161.236","90.382","87.86","36.432","0","SILVER","S 82 911 SC EURO","GREEN","2","DEL","FULL" "ED DUNNE","44","12","86","SP3","36","2","","","DNF","3 Laps","9","1511.916","8","155.446","93.748","86.748","36.432","0","BLACK","92 968 FIREHAWK","GREEN","PURPLE","13","CHO","FULL" "JOHN MILLER","45","3","4","GT5","32","4","","","DNF","4 Laps","8","1415.183","3","170.793","85.324","82.38","32.384","1","BLACK","87 911","GREEN","13","CHO","FULL" "JONATHAN FOULDS","46","13","137","SP3","44","10","","","DNF","6 Laps","6","1049.99","3","157.454","92.553","83.274","24.288","0","BLACK","93 968","GREEN","3","SMT","FULL" "BILL PAWLAN","47","14","26","SP3","43","9","","","DNF","7 Laps","5","917.532","3","157.161","92.725","79.413","20.24","1","WHITE","89 968 S2","GREEN","13","CHO","FULL" "CLARKE SIMPSON","48","21","213","E","2","2","","","DNF","7 Laps","5","1152.889","2","155.39","93.782","63.201","20.24","1","WHITE","S 78 911 SC","GREEN","PURPLE","2","POT","FULL" "JIM HAMMAN","49","15","74","SP3","42","8","","","DNF","8 Laps","4","1055.978","2","157.807","92.346","55.201","16.192","1","BLACK","94 968","GREEN","PURPLE","13","CHO","FULL" "JOHN WESTRA","50","4","99","GT5","18","3","","","DNF","11 Laps","1","179.257","1","171.382","85.031","81.296","4.048","0","BLUE","75 911 S","GREEN","PURPLE","13","CHO","FULL"