2d:null 2e:["$","title",null,{"children":"Tour de France — Stages | Yannick Carer | Observable"}] 33:[] 31:{"id":"975ccc22220799fa","slug":"tour-de-france-stages","title":"Tour de France — Stages","thumbnail":"3d5c5224a33e269e0d88e6e1d0b8a7a9a9d3529f24b69093cf877ee7f007ee5a","access_level":"public","create_time":"$D2021-02-07T18:33:35.845Z","update_time":"$D2021-02-07T21:34:33.080Z","view_time":null,"first_public_time":"$D2021-02-07T19:14:45.292Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"e8090cba37ea9bce","login":"yannick","name":"Yannick Carer","avatar_url":"https://avatars-next.observableusercontent.com/d2ad7edd0353c81f879f9bb6967f9630ef05b66191762a6a3500fb75a43a53fd","tier":"starter_2024"},"version":383,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"14513d353ffb07b5","login":"yannick","name":"Yannick Carer","avatar_url":"https://avatars-next.observableusercontent.com/d2ad7edd0353c81f879f9bb6967f9630ef05b66191762a6a3500fb75a43a53fd","tier":null}],"members":[{"type":"individual","id":"14513d353ffb07b5","login":"yannick","name":"Yannick Carer","avatar_url":"https://avatars-next.observableusercontent.com/d2ad7edd0353c81f879f9bb6967f9630ef05b66191762a6a3500fb75a43a53fd","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Tour de France — Stages","cells":[{"id":0,"value":"md`# Tour de France — Stages`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"viewof year = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"total_distance_km = Math.ceil(data.reduce((total, d) => total + (d.distance_km || 0), 0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"table = {\n const parser = new DOMParser();\n const external = parser.parseFromString(text.parse.text[\"*\"], \"text/html\");\n const table = document.adoptNode(external.querySelector(\"table\"));\n \n // Set the relative href back to wikipedia.\n for (const anchor of table.getElementsByTagName(\"a\")) {\n anchor.href = anchor.href.replace('https://observablehq.com/wiki/', \"https://en.wikipedia.com/wiki/\")\n console.log(anchor.href); \n }\n \n table.style = `\n display: block;\n position: relative;\n max-width: none;\n max-height: 600px;\n overflow-y: auto;\n -webkit-overflow-scrolling: touch;\n `;\n return table;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"data = headers.reduce((arr, name, index) => {\n const data = Array.from(rows, r => r.querySelector(`td:nth-child(${2+index})`)?.textContent.trim());\n while (arr.length < data.length) arr.push({});\n for (const [i, value] of data.entries()) {\n arr[i][name] = value;\n }\n return arr;\n}, [])\n.map(augment);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"md`## Locations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"locations = {\n const locations = [];\n for (const q of geoQueries) {\n for (const result of Object.values(q)) {\n locations.push(result);\n }\n }\n return locations;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":353,"value":"Table(locations.map(l => {\n const title = l.title;\n const coords = l.coordinates?.[0];\n return {title, lat: coords?.lat, lon: coords?.lon};\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"md`

\n## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"text = fetch(`https://en.wikipedia.org/w/api.php?format=json&origin=*&action=parse&page=${year}_Tour_de_France§ion=${year == 2020? 4 : 3}&prop=text`)\n .then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"rows = table.querySelectorAll(\"tr:not(:first-child)\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"headers = ['date', 'course', 'distance', 'type']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"function augment(obj) {\n const distance = /([\\d.]+)\\skm/.exec(obj['distance']);\n const course = /(.+)\\sto\\s(.+)/.exec(obj['course']);\n \n obj['distance_km'] = +(distance?.[1] || 0);\n obj['course_start'] = course?.[1] || obj['course'];\n obj['course_end'] = course?.[2] || obj['course'];\n return obj;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"locationUrls = {\n const cities = Array.from(rows, r => [...r.querySelectorAll(`td:nth-child(3) a`)].map(a => a.href))\n .flat()\n .filter(s => s.startsWith('https://en.wikipedia.com/wiki/'));\n const uniqueCities = new Set(...[cities]);\n return [...uniqueCities];\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"geoQueries = {\n const getCoordinates = title => `https://en.wikipedia.org/w/api.php?format=json&origin=*&action=query&titles=${title}&prop=coordinates`;\n\n return Promise.all(\n locationUrls\n .map(p => p.replace('https://en.wikipedia.com/wiki/', ''))\n .map(name => fetch(getCoordinates(name))\n .then(response => response.json())\n .then(r => r.query.pages)));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"import {Table} from '@observablehq/inputs'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"