31:[] 2f:{"title":"How Fast To Podium? Data","cells":[{"id":0,"value":"# How Fast To Podium? Data","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"This is the data that powers [this notebook](https://observablehq.com/d/a8ef7c072a0b1988). ","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"## Salt Flats Endurance","pinned":false,"hidden":false,"mode":"md"},{"id":109,"value":"upload data with CORS","pinned":false,"hidden":false,"mode":"md"},{"id":134,"value":"uploadSFE22 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/85313/1/json?_search=false&nd=1652384347174&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"uploadSFE21 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/77340/1/json?_search=false&nd=1651179346342&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"uploadSFE19 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/57603/1/json?_search=false&nd=1651230976594&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"uploadSFE18 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/47702/1/json?_search=false&nd=1651231014752&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"uploadSFE17 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/40404/1/json?_search=false&nd=1651231040134&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"uploadSFE16 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/33336/1/json?_search=false&nd=1651231054486&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"remove DNF and DNS","pinned":false,"hidden":false,"mode":"md"},{"id":138,"value":"noDNF22 = uploadSFE22.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"noDNF21 = uploadSFE21.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"noDNF19 = uploadSFE19.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"noDNF18 = uploadSFE18.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"noDNF17 = uploadSFE17.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"noDNF16 = uploadSFE16.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"add years","pinned":false,"hidden":false,"mode":"md"},{"id":142,"value":"SFE22 = noDNF22.map(object => {\n return {...object, year: '2022'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"SFE21 = noDNF21.map(object => {\n return {...object, year: '2021'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"SFE19 = noDNF19.map(object => {\n return {...object, year: '2019'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":63,"value":"SFE18 = noDNF18.map(object => {\n return {...object, year: '2018'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"SFE17 = noDNF17.map(object => {\n return {...object, year: '2017'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"SFE16 = noDNF16.map(object => {\n return {...object, year: '2016'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"merge a case for all genders, female and male","pinned":false,"hidden":false,"mode":"md"},{"id":77,"value":"SFEAllGen = [...SFE22, ...SFE21, ...SFE19, ...SFE18, ...SFE17, ...SFE16];","pinned":false,"hidden":false,"mode":"ojs"},{"id":80,"value":"SFEFemale = SFEAllGen.filter(d => d.gender === \"F\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"SFEMale = SFEAllGen.filter(d => d.gender === \"M\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"add parsed time","pinned":false,"hidden":false,"mode":"md"},{"id":87,"value":"SFEPAllGen = SFEAllGen.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"SFEPFemale = SFEFemale.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"SFEPMale = SFEMale.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":151,"value":"# Golden Gate Dirty Thirty","pinned":false,"hidden":false,"mode":"md"},{"id":153,"value":"upload data with CORS","pinned":false,"hidden":false,"mode":"md"},{"id":155,"value":"uploadDT22 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/95275/1/json?_search=false&nd=1654876698761&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"uploadDT21 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/86163/1/json?_search=false&nd=1654876811918&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":167,"value":"uploadDT19 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/62370/1/json?_search=false&nd=1654876888235&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":171,"value":"uploadDT18 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/51968/1/json?_search=false&nd=1654876904894&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":179,"value":"uploadDT17 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/41734/1/json?_search=false&nd=1654876932905&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":183,"value":"uploadDT16 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/33332/1/json?_search=false&nd=1654876947258&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":186,"value":"uploadDT15 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/29606/1/json?_search=false&nd=1654876961019&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":189,"value":"uploadDT14 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/27093/1/json?_search=false&nd=1654876979240&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":192,"value":"uploadDT13 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/19159/1/json?_search=false&nd=1654876999188&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":195,"value":"uploadDT12 = d3.json(\"https://observable-cors.glitch.me/\" + \"https://ultrasignup.com/service/events.svc/results/15311/1/json?_search=false&nd=1654877009596&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":201,"value":"remove DNF and DNS (and a case of place 0 in 2022)","pinned":false,"hidden":false,"mode":"md"},{"id":205,"value":"noDNFDT22 = uploadDT22.filter(d => d.time !== \"0\" && d.place !== 0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":209,"value":"noDNFDT21 = uploadDT21.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":212,"value":"noDNFDT19 = uploadDT19.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":214,"value":"noDNFDT18 = uploadDT18.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":219,"value":"noDNFDT17 = uploadDT17.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"noDNFDT16 = uploadDT16.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":223,"value":"noDNFDT15 = uploadDT15.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":225,"value":"noDNFDT14 = uploadDT14.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":227,"value":"noDNFDT13 = uploadDT13.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":229,"value":"noDNFDT12 = uploadDT12.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"add years","pinned":false,"hidden":false,"mode":"md"},{"id":239,"value":"DT22 = noDNFDT22.map(object => {\n return {...object, year: '2022'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":242,"value":"DT21 = noDNFDT21.map(object => {\n return {...object, year: '2021'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":247,"value":"DT19 = noDNFDT19.map(object => {\n return {...object, year: '2019'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":250,"value":"DT18 = noDNFDT18.map(object => {\n return {...object, year: '2018'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":253,"value":"DT17 = noDNFDT17.map(object => {\n return {...object, year: '2017'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":256,"value":"DT16 = noDNFDT16.map(object => {\n return {...object, year: '2016'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":258,"value":"DT15 = noDNFDT15.map(object => {\n return {...object, year: '2015'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":260,"value":"DT14 = noDNFDT14.map(object => {\n return {...object, year: '2014'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"DT13 = noDNFDT13.map(object => {\n return {...object, year: '2013'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"DT12 = noDNFDT12.map(object => {\n return {...object, year: '2012'};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":277,"value":"merge a case for all genders, female and male","pinned":false,"hidden":false,"mode":"md"},{"id":280,"value":"DTAllGen = [...DT22, ...DT21, ...DT19, ...DT18, ...DT17, ...DT16, ...DT15, ...DT14, ...DT13 ,...DT12];","pinned":false,"hidden":false,"mode":"ojs"},{"id":283,"value":"DTFemale = DTAllGen.filter(d => d.gender === \"F\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":285,"value":"DTMale = DTAllGen.filter(d => d.gender === \"M\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":290,"value":"add parsed time","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"DTPAllGen = DTAllGen.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":299,"value":"DTPFemale = DTFemale.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":302,"value":"DTPMale = DTMale.map(object => {\n return {...object, parsedTime: parseFloat((object.time / 1000) / 3600).toFixed(fixedFloat)};\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":199,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":92,"value":"### Variables","pinned":false,"hidden":false,"mode":"md"},{"id":131,"value":"fixedFloat = 3","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"---","pinned":false,"hidden":false,"mode":"md"}],"files":"$W31","stdlib":"1","titling":"auto"}