31:[] 2f:{"title":"Color investigations - manually set colors","cells":[{"id":0,"value":"# Color investigations - manually set colors\n\nThis tool helps us understand what colors have been picked manually in charts. It extracts all hex values from grapher charts and shows them.","pinned":false,"hidden":false,"mode":"md"},{"id":401,"value":"colorCell = (color) => `

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":418,"value":"colorCell(\"#33aa22\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":431,"value":"oldOwidDistinct = new Set([\n \"#3C4E66\",\n \"#B13507\",\n \"#00847E\",\n \"#6D3E91\",\n \"#CF0A66\",\n \"#883039\",\n \"#00823F\",\n \"#4C6A9C\",\n \"#C05917\",\n \"#D73C50\",\n \"#287669\",\n \"#CD2285\",\n \"#0F739C\",\n \"#9A5129\",\n \"#C45267\",\n \"#008860\",\n \"#8C4569\",\n \"#B36216\",\n \"#366388\",\n \"#A2559C\",\n \"#578145\",\n \"#D7263F\",\n \"#18470F\",\n \"#BC8E5A\",\n \"#585C64\",\n ])","pinned":false,"hidden":false,"mode":"ojs"},{"id":409,"value":"colorsCell = (colors) => `

${colors.map(color => colorCell(color))}

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":347,"value":" viewof chartsTable = Inputs.table(chartsWithCustomColorsAndFlaggings, {\n width: {id: \"2%\", slug: \"15%\"},\n format: {\n \n slug: (slug) => html`${slug}`,\n owidColors: (colors) => html`${colorsCell(colors)}`,\n manualColors: (colors) => html`${colorsCell(colors)}`\n }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":450,"value":"chartsWithCustomColorsAndFlaggings = chartsWithParsedColors.map(row => ({id: row.id, slug: row.slug, owidColors: row.colors.filter(color => oldOwidDistinct.has(color)), manualColors: row.colors.filter(color => !oldOwidDistinct.has(color))}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":440,"value":"chartsWithParsedColors = chartsWithCustomColors.map(row => ({...row, colors: JSON.parse(row.colors).map(row => row.name)}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":207,"value":"select\n id,\n slug,\n regexp_matches('(?P#[\\da-f]{6,6})(?P[\\w\"])', config) as colors\n from\n charts\n where json_array_length(regexp_matches('(?P#[\\da-f]{6,6})(?P[\\w\"])', config)) > 0","pinned":true,"hidden":false,"mode":"sql","output":"chartsWithCustomColors","database":"var:owid"},{"id":136,"value":"## Internals below","pinned":false,"hidden":false,"mode":"md"},{"id":21,"value":"owid = new DatasetteClient(\n \"https://owid-datasette-y43qr.ondigitalocean.app/owid\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"//Inputs.table(variables.query(`SELECT * from variables ${whereClause}`))","pinned":true,"hidden":false,"mode":"ojs"},{"id":3,"value":"import {DatasetteClient} from \"@ambassadors/datasette-client\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"import {debounce} from \"@mbostock/debouncing-input\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}