28:null 29:["$","title",null,{"children":"MotoGP Results Table | Andrew P | Observable"}] 2e:T6ca,{ const stages = Stages.getByYear(selected_year) const raceResults = RaceResults.getByYear(selected_year) const resultsTable = d3 .groups(raceResults, rr => rr.rider) .map(([rider, results]) => [ rider, d3.sum(results, d => d.points), ...stages.map(s => results.find(rr => rr.sequence == s.sequence)?.points ?? '・'), ]) .sort((a, b) => d3.descending(a[1], b[1])) const renderTag = tagName => children => `<${tagName} style="white-space: nowrap">${ Array.isArray(children) ? children.join('') : children }` const td = renderTag('td') const th = renderTag('th') const tr = renderTag('tr') const thead = renderTag('thead') const tbody = renderTag('tbody') const cell = (color, val) => `${val}` const formatRider = (val) => { const parts = val.match(/([^,]*)\,(.*)/) return `${parts[1]} ${parts[2]}` } const formatPoints = (val) => { switch (val) { case 25: return cell('gold', val) case 20: return cell('silver', val) case 16: return cell('wheat', val) default: return td(val) } } return html` ${thead(tr([ th('#'), th('Rider'), th('Total'), ...stages.map(s => th(s.shortname)), ]))} ${tbody(resultsTable.map(([rider, total, ...rows], index) => tr([ td(index + 1), td(formatRider(rider)), td(total), ...rows.map(formatPoints), ])))}

` }2f:[] 2c:{"id":"b91e23ba9d0023dd","slug":"motogp-results-table","title":"MotoGP Results Table","thumbnail":"d8e285aa764ff96d4413d8cd3731076bd13b52262d5e22418a9bfb1cb2bcf5c9","access_level":"public","create_time":"$D2020-09-28T22:49:12.761Z","update_time":"$D2020-10-01T08:18:36.987Z","view_time":null,"first_public_time":"$D2020-09-29T11:09:10.083Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"448956d8a4a43eb5","login":"piratus","name":"Andrew P","avatar_url":"https://avatars-next.observableusercontent.com/10979fe53e8362346572a5770112fd1a4efba4fb09c4182a6652b6f09e12f9e4","tier":"starter_2024"},"version":362,"publish_version":362,"role":null,"authored":false,"authors":[{"type":"individual","id":"4873f825e6d817f7","login":"piratus","name":"Andrew P","avatar_url":"https://avatars-next.observableusercontent.com/10979fe53e8362346572a5770112fd1a4efba4fb09c4182a6652b6f09e12f9e4","tier":null}],"members":[{"type":"individual","id":"4873f825e6d817f7","login":"piratus","name":"Andrew P","avatar_url":"https://avatars-next.observableusercontent.com/10979fe53e8362346572a5770112fd1a4efba4fb09c4182a6652b6f09e12f9e4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"5abd63e51e823011","slug":"gp-motorcycle-racing","title":"GP Motorcycle Racing","owner":{"id":"448956d8a4a43eb5","login":"piratus","name":"Andrew P"}},"type":"notebook","body":{"title":"MotoGP Results Table","cells":[{"id":0,"value":"md`# MotoGP Results Table`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"viewof selected_year = select({\n title: \"Select Year\",\n options: Stages.all.map(s => s.year),\n value: 2020\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"RaceResults = {\n const all = await fetch(getURLForFile('race_results.tsv'))\n .then(r => r.text())\n .then(rows => d3.tsvParse(rows, d3.autoType));\n const getByYear = year => all.filter(r => r.year == year);\n return { all, getByYear };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"Stages = {\n const all = await fetch(getURLForFile('stages.json')).then(res => res.json());\n all.forEach(row => {\n row.stages = row.stages.map(s => ({ sequence: s[0], shortname: s[1] }));\n });\n const byYear = d3.index(all, d => d.year);\n const getByYear = year => byYear.get(Number(year)).stages;\n\n return {\n all,\n getByYear\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"md`## Helpers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"function getURLForFile(name) {\n const DATA_BASE_URL =\n 'https://gist.githubusercontent.com/piratus/0a223d814a9b313597472f2b023f023e/raw/';\n return `${DATA_BASE_URL}/${name}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"function codeToIcon(code) {\n const FLAG_ICON_OFFSET = 127397;\n return code\n .toUpperCase()\n .replace(/./g, char =>\n String.fromCodePoint(char.charCodeAt(0) + FLAG_ICON_OFFSET)\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require('d3@6')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"import { select } from \"@jashkenas/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"