29:null 2a:["$","title",null,{"children":"MotoGP riders results statistics | Andrew P | Observable"}] 2f:T67c,{ const data = aq .from(selected) .derive({ no_points: (d) => d.finishes - d.with_points - d.podiums - d.wins, name: (d) => `${d.first_name} ${d.last_name}` }) .select([ "name", "starts", "wins", "podiums", "with_points", "no_points", "dnf" ]) .orderby(aq.desc(orderField)) .slice(0, 30) .fold(["wins", "podiums", "with_points", "no_points", "dnf"]); return Plot.plot({ marginLeft: 100, marginBottom: 0, marginRight: 10, width: width, x: { axis: "top", grid: true, nice: displayValues !== "pct", label: "Race Starts", percent: displayValues === "pct" }, color: { domain: ["wins", "podiums", "with_points", "no_points", "dnf"], range: [ "rgb(242, 142, 44)", "rgb(78, 121, 167)", "rgb(129, 171, 129)", "#AAA", "#888" ] }, y: { label: "" }, marks: [ Plot.barX(data, { y: "name", x: (d) => (displayValues === "pct" ? d.value / d.starts : d.value), fill: "key" }) // Plot.barX(data, { y: "name", x1: (d) => -d.dnf, x2: 0, fill: "tomato" }), // Plot.barX(data, { y: "name", x1: 0, x2: "no_points", fill: "lightgrey" }), // Plot.barX(data, { // y: "name", // x1: "no_points", // x2: (d) => d.no_points + d.with_points, // fill: "grey" // }), // Plot.barX(data, { // y: "name", // x1: (d) => d.no_points + d.with_points, // x2: (d) => d.no_points + d.with_points + d.podiums, // fill: "yellow" // }) ] }); }30:T580,RIDER_STATS = await GPResultsDB.query( ` SELECT c.iso_code as country, first_name, last_name, starts, finishes, with_points, podiums, wins, seconds, thirds, starts - finishes as dnf, min_year, max_year, years_active FROM (SELECT rider, count(*) as starts, sum(CASE WHEN position > 0 THEN 1 ELSE 0 END) as finishes, sum(CASE WHEN position > 3 AND points > 0 THEN 1 ELSE 0 END) as with_points, sum(CASE WHEN position BETWEEN 2 AND 3 THEN 1 ELSE 0 END) as podiums, sum(CASE WHEN position = 1 THEN 1 ELSE 0 END) as wins, sum(CASE WHEN position = 2 THEN 1 ELSE 0 END) as seconds, sum(CASE WHEN position = 3 THEN 1 ELSE 0 END) as thirds, min(year) as min_year, max(year) as max_year, count(DISTINCT year) as years_active FROM race_results WHERE category in (${categories.map((_) => "?").join(",")}) GROUP BY rider) stats JOIN riders ON stats.rider = riders.id JOIN countries c on c.gp_code = riders.country ORDER by wins DESC, podiums DESC, finishes DESC `, [...categories] )31:[] 2d:{"id":"2042c8ec16d9045c","slug":"motogp-riders-results-statistics","title":"MotoGP riders results statistics","thumbnail":"a624c262166f98a8ba974be4f07a7cab78056381a8e8cc4b6e7aeba197b98d33","access_level":"public","create_time":"$D2021-06-21T19:33:40.078Z","update_time":"$D2021-09-29T10:39:23.748Z","view_time":null,"first_public_time":"$D2021-08-10T14:00:57.593Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"448956d8a4a43eb5","login":"piratus","name":"Andrew P","avatar_url":"https://avatars-next.observableusercontent.com/10979fe53e8362346572a5770112fd1a4efba4fb09c4182a6652b6f09e12f9e4","tier":"starter_2024"},"version":937,"publish_version":937,"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 riders results statistics","cells":[{"id":0,"value":"# MotoGP riders results statistics","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"viewof categories = Inputs.checkbox(\n (\n await GPResultsDB.query(\n \"SELECT c.name FROM categories c ORDER BY c.'order'\"\n )\n ).map((c) => c.name),\n { label: html`Categories`, value: [\"MotoGP\"] }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":905,"value":"viewof orderField = Inputs.radio(\n new Map([\n [\"Starts\", \"starts\"],\n [\"Wins\", \"wins\"],\n [\"Podiums\", \"podiums\"],\n [\"With points\", \"with_points\"],\n [\"Without points\", \"no_points\"],\n [\"DNF\", \"dnf\"]\n ]),\n { value: \"starts\", label: html`Top 20 By` }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":738,"value":"viewof displayValues = Inputs.radio(\n new Map([\n [\"Absolute Values\", \"abs\"],\n [\"Percentage\", \"pct\"]\n ]),\n { value: \"pct\", label: html`Display` }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":918,"value":"viewof selected = searchCheckbox(\n RIDER_STATS, // What elements to chose from\n {\n value: RIDER_STATS,\n format: (d) => htl.html`${d.first_name} ${d.last_name}` // Start with everything selected\n // Any other options you pass here will be passed to the checkbox and search inputs\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":882,"value":"### Browse query results","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":926,"value":"htl.html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"viewof RIDER_STATS_FILTERED = {\n return Inputs.search(RIDER_STATS, {\n label: html`Search`\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"Inputs.table(RIDER_STATS_FILTERED, {\n width: {\n name: 150,\n last_name: 100,\n country: 35\n },\n align: { country: \"center\", first_name: \"right\" },\n format: {\n name: (d) => {\n const [last, first] = d.split(\", \");\n return html`${last.toUpperCase()}, ${first}`;\n },\n last_name: (last) => html`${last.toUpperCase()}`,\n min_year: (d) => d.toString(),\n max_year: (d) => d.toString(),\n id: (d) => d.toString(),\n country: (d) =>\n html`${Flags.codeToIcon(\n d\n )}`\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"Inputs.table(\n await GPResultsDB.query(\n \"SELECT r.last_name || ', ' || r.first_name as name, min_year, max_year, races, points, points*1.0/races as avg_points FROM (SELECT rider, count(*) as races, sum(points) as points, min(year) as min_year, max(year) as max_year FROM race_results_view WHERE year >= 1977 GROUP BY rider) JOIN riders r ON rider = r.id WHERE races > 1 AND points > 0 ORDER BY avg_points DESC, races DESC\"\n ),\n {\n format: {\n name: (d) => {\n const [last, first] = d.split(\", \");\n return html`${last.toUpperCase()}, ${first}`;\n },\n min_year: (d) => d.toString(),\n max_year: (d) => d.toString(),\n avg_points: (d) => `${(Math.round(d * 100) / 100).toFixed(1)}`\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"Flags = {\n const FLAG_ICON_OFFSET = 127397;\n function codeToIcon(code) {\n return code.length !== 2\n ? code\n : code\n .toUpperCase()\n .replace(/./g, (char) =>\n String.fromCodePoint(char.charCodeAt(0) + FLAG_ICON_OFFSET)\n );\n }\n return { codeToIcon };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":859,"value":"import { GPResultsDB } from \"@piratus/motogp-results-database\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":917,"value":"import {searchCheckbox} from \"@john-guerra/search-checkbox\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 2e:"$2d:body"