2e:null 2f:["$","title",null,{"children":"How Fast To Podium? Data | Anna Wiederkehr | Observable"}] 34:[] 32:{"id":"c91c26400d1b120c","slug":"how-fast-to-podium-data","title":"How Fast To Podium? Data","thumbnail":"a94de52526e8c6c90ae40513e301409006a718c68fbcb0ed8464a81f91df2459","access_level":"public","create_time":"$D2022-04-29T14:52:50.996Z","update_time":"$D2022-06-10T16:30:50.699Z","view_time":null,"first_public_time":"$D2022-04-29T15:25:43.305Z","has_unpublished_edits":null,"fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"7d04db8988659721","login":"wiederkehra","name":"Anna Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/309f2f5fa773b78376c2631c463386d1adaa6fab2c0b9912e88628029ff0ccf5","tier":"starter_2024"},"version":315,"publish_version":315,"role":null,"authored":false,"authors":[{"type":"individual","id":"c9088ec5a693fb58","login":"wiederkehra","name":"Anna Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/309f2f5fa773b78376c2631c463386d1adaa6fab2c0b9912e88628029ff0ccf5","tier":null}],"members":[{"type":"individual","id":"c9088ec5a693fb58","login":"wiederkehra","name":"Anna Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/309f2f5fa773b78376c2631c463386d1adaa6fab2c0b9912e88628029ff0ccf5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"315b4398067b7ec1","slug":"running","title":"Running","owner":{"id":"7d04db8988659721","login":"wiederkehra","name":"Anna Wiederkehr"}},"type":"notebook","body":{"title":"How Fast To Podium? Data","cells":[{"id":0,"value":"# How Fast To Podium? Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"This is the data that powers [this notebook](https://observablehq.com/d/a8ef7c072a0b1988). ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"## Salt Flats Endurance","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"upload data with CORS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"remove DNF and DNS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":138,"value":"noDNF22 = uploadSFE22.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"noDNF21 = uploadSFE21.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"noDNF19 = uploadSFE19.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"noDNF18 = uploadSFE18.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"noDNF17 = uploadSFE17.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"noDNF16 = uploadSFE16.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"add years","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"SFE22 = noDNF22.map(object => {\n return {...object, year: '2022'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"SFE21 = noDNF21.map(object => {\n return {...object, year: '2021'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"SFE19 = noDNF19.map(object => {\n return {...object, year: '2019'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"SFE18 = noDNF18.map(object => {\n return {...object, year: '2018'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"SFE17 = noDNF17.map(object => {\n return {...object, year: '2017'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"SFE16 = noDNF16.map(object => {\n return {...object, year: '2016'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"merge a case for all genders, female and male","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":77,"value":"SFEAllGen = [...SFE22, ...SFE21, ...SFE19, ...SFE18, ...SFE17, ...SFE16];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"SFEFemale = SFEAllGen.filter(d => d.gender === \"F\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"SFEMale = SFEAllGen.filter(d => d.gender === \"M\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"add parsed time","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":151,"value":"# Golden Gate Dirty Thirty","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":153,"value":"upload data with CORS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"remove DNF and DNS (and a case of place 0 in 2022)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":205,"value":"noDNFDT22 = uploadDT22.filter(d => d.time !== \"0\" && d.place !== 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"noDNFDT21 = uploadDT21.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"noDNFDT19 = uploadDT19.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"noDNFDT18 = uploadDT18.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"noDNFDT17 = uploadDT17.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"noDNFDT16 = uploadDT16.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"noDNFDT15 = uploadDT15.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"noDNFDT14 = uploadDT14.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"noDNFDT13 = uploadDT13.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"noDNFDT12 = uploadDT12.filter(d => d.time !== \"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"add years","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":239,"value":"DT22 = noDNFDT22.map(object => {\n return {...object, year: '2022'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"DT21 = noDNFDT21.map(object => {\n return {...object, year: '2021'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"DT19 = noDNFDT19.map(object => {\n return {...object, year: '2019'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"DT18 = noDNFDT18.map(object => {\n return {...object, year: '2018'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"DT17 = noDNFDT17.map(object => {\n return {...object, year: '2017'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"DT16 = noDNFDT16.map(object => {\n return {...object, year: '2016'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"DT15 = noDNFDT15.map(object => {\n return {...object, year: '2015'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"DT14 = noDNFDT14.map(object => {\n return {...object, year: '2014'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"DT13 = noDNFDT13.map(object => {\n return {...object, year: '2013'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"DT12 = noDNFDT12.map(object => {\n return {...object, year: '2012'};\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"merge a case for all genders, female and male","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":280,"value":"DTAllGen = [...DT22, ...DT21, ...DT19, ...DT18, ...DT17, ...DT16, ...DT15, ...DT14, ...DT13 ,...DT12];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":283,"value":"DTFemale = DTAllGen.filter(d => d.gender === \"F\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"DTMale = DTAllGen.filter(d => d.gender === \"M\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"add parsed time","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":92,"value":"### Variables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"fixedFloat = 3","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"