31:T8d0,data_queried = { let sql = '' if (queryType == 'indiv') { // query individual donors sql = ` SELECT CI.FIPS, COUNT(DISTINCT NAME_ID, ZIP_CODE)/TOTAL_BOTH AS PERCENTAGE FROM ContributionsByIndividuals CI JOIN CommitteeMaster CM ON CI.CYCLE = CM.CYCLE AND CI.CMTE_ID = CM.CMTE_ID JOIN ( SELECT FIPS, SUM(INDIVS) AS TOTAL_BOTH FROM ( SELECT CMTE_ID, FIPS, COUNT( DISTINCT NAME_ID, ZIP_CODE) AS INDIVS FROM ContributionsByIndividuals WHERE CYCLE = 2020 AND CMTE_ID IN ( SELECT CMTE_ID FROM CommitteeMaster WHERE CYCLE = 2020 AND CAND_ID IN ('P80001571', 'P80000722') ) ${constraints} AND FIPS IS NOT NULL GROUP BY CMTE_ID, FIPS ) T GROUP BY FIPS ) U ON CI.FIPS = U.FIPS WHERE CI.CYCLE = 2020 AND CAND_ID = 'P80000722' ${constraints} GROUP BY CI.FIPS; ` } else { // query contribution amount sql = ` SELECT CI.FIPS, (SUM(TRANSACTION_AMT)/TOTALS_BOTH) AS PERCENTAGE FROM ContributionsByIndividuals CI JOIN CommitteeMaster CM ON CI.CYCLE = CM.CYCLE AND CI.CMTE_ID = CM.CMTE_ID JOIN ( SELECT FIPS, SUM(TRANSACTION_AMT) AS TOTALS_BOTH FROM ContributionsByIndividuals WHERE CYCLE = 2020 AND CMTE_ID IN ( SELECT CMTE_ID FROM CommitteeMaster WHERE CYCLE = 2020 AND CAND_ID IN ('P80001571', 'P80000722') ) ${constraints} AND FIPS IS NOT NULL GROUP BY FIPS ) U ON CI.FIPS = U.FIPS WHERE CI.CYCLE = 2020 AND CAND_ID = 'P80000722' ${constraints} GROUP BY CI.FIPS; ` } const endpoint = 'https://api.data.eventures.vc/query'; let url = encodeURI(endpoint + '?token=' + API_KEY + '&sql=' + sql); let results = await d3.csv(url); return results; }32:[] 2f:{"title":"Contributions: Trump vs. Biden 2020","cells":[{"id":0,"value":"md`# Contributions: Trump vs. Biden 2020`","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"viewof queryType = {\n const form = html`\n `\n form.select.onchange = () => {\n mutable status = 'Chart is loading...' ;\n form.value = form.select.value;\n form.dispatchEvent(new CustomEvent(\"input\"));\n };\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":558,"value":"viewof queryGender = {\n const form = html`\n `\n form.select.onchange = () => {\n mutable status = 'Chart is loading...' ;\n form.value = form.select.value;\n form.dispatchEvent(new CustomEvent(\"input\"));\n };\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":596,"value":"viewof queryAge = {\n const form = html`\n `\n form.select.onchange = () => {\n mutable status = 'Chart is loading...' ;\n form.value = form.select.value;\n form.dispatchEvent(new CustomEvent(\"input\"));\n };\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":500,"value":"viewof queryEthnicity = {\n const form = html`\n `\n form.select.onchange = () => {\n mutable status = 'Chart is loading...' ;\n form.value = form.select.value;\n form.dispatchEvent(new CustomEvent(\"input\"));\n };\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":819,"value":"viewof st = { return html`${status}` };","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"chart = {\n const path = d3.geoPath();\n\n const svg = d3.create(\"svg\")\n .attr(\"viewBox\", \"0 0 960 600\")\n .style(\"width\", \"100%\")\n .style(\"height\", \"auto\");\n\n svg.append(\"g\")\n .attr(\"transform\", \"translate(600,40)\")\n .call(legend);\n\n svg.append(\"g\")\n .selectAll(\"path\")\n .data(topojson.feature(us, us.objects.counties).features)\n .join(\"path\")\n .attr(\"fill\", d => color(data.get(d.id)))\n .attr(\"d\", path)\n .append(\"title\")\n .text(d => `${d.properties.name}, ${states.get(d.id.slice(0, 2)).name}\n${format(Math.abs(data.get(d.id)-0.5)+0.5)}`);\n\n svg.append(\"path\")\n .datum(topojson.mesh(us, us.objects.states, (a, b) => a !== b))\n .attr(\"fill\", \"none\")\n .attr(\"stroke\", \"white\")\n .attr(\"stroke-linejoin\", \"round\")\n .attr(\"d\", path);\n\n mutable status = '';\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"md`**How this map is created:** For each county the share of Trump's and Biden's contribution $$ (resp. individual donors) of the total contribution $$ (resp. individual donors) of both of them are color coded.\n\n*For example:* if both get an equal share in a county (could be $0/0 donors both), the value is 50% are displayed and the color is bright; if one of them receives $0 / zero donors at all the other candidate's value is 100% and the color is deep red or blue.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":763,"value":"md`### Computation:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":255,"value":"API_KEY = '3FV1QKqcA818roNDM4zJoHjhF04WzF5524741'","pinned":false,"hidden":false,"mode":"ojs"},{"id":794,"value":"mutable status = ''","pinned":false,"hidden":false,"mode":"ojs"},{"id":680,"value":"constraints = {\n let items = new Array();\n if (queryGender != '') {\n items.push(queryGender)\n }\n if (queryEthnicity != '') {\n items.push(queryEthnicity)\n }\n if (queryAge != '') {\n items.push(queryAge)\n }\n if (items.length > 0) {\n items.splice(0, 0, '');\n }\n return items.join(\" AND \");\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":490,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":278,"value":"data = {\n let allCounties = new Map(us.objects.counties.geometries.map(d => [d.id, +0.5]));\n let dataCounties = new Map(data_queried.map(d => [d.FIPS, +d.PERCENTAGE]));\n return new Map([...allCounties, ...dataCounties]);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":350,"value":"data['title'] = \"Difference from mean contribution $$ (Red: Trump, Blue: Biden)\";","pinned":false,"hidden":false,"mode":"ojs"},{"id":126,"value":"legend = g => {\n const width = 240;\n\n g.append(\"image\")\n .attr(\"width\", width)\n .attr(\"height\", 8)\n .attr(\"preserveAspectRatio\", \"none\")\n .attr(\"xlink:href\", ramp(color.interpolator()).toDataURL());\n\n g.append(\"text\")\n .attr(\"class\", \"caption\")\n .attr(\"y\", -6)\n .attr(\"fill\", \"#000\")\n .attr(\"text-anchor\", \"start\")\n .attr(\"font-weight\", \"bold\")\n .text(data.title);\n\n g.call(d3.axisBottom(d3.scaleLinear(color.domain(), [0, width / 2, width]))\n .ticks(6)\n .tickFormat(d => `+${(Math.abs((d-0.5) * 100)+50).toFixed(0)}%`)\n .tickSize(13))\n .select(\".domain\")\n .remove();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":320,"value":"color = d3.scaleDiverging([0, 0.5, 1], d3.interpolateRdBu)","pinned":false,"hidden":false,"mode":"ojs"},{"id":75,"value":"format = d3.format(\"+.1%\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"states = new Map(us.objects.states.geometries.map(d => [d.id, d.properties]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"us = d3.json(\"https://cdn.jsdelivr.net/npm/us-atlas@2/us/10m.json\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":3,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":211,"value":"import {ramp} from \"@mbostock/color-ramp\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}