2a:null 2b:["$","title",null,{"children":"The Way To Win Down Ballot | TargetSmart | Observable"}] 30:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }31:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }32:T567,demShareBarCharts = { const spec = vl.markBar({ stroke: "black" }).encode( vl .x() .fieldQ("dem_vote_share") .axis({ title: null, format: "%", grid: false, values: [0, 0.5, 1] }) .scale({ domain: [0, 1] }), vl.row().fieldO("year").spacing(5).header({ title: null, labelAngle: 0, labelOrient: "left", labelPadding: 5, labelAlign: "left" }), vl.y().fieldN("race").axis(null).sort("descending"), vl .color() .fieldN("race") .legend({ title: null }) .sort("descending") .scale({ scheme: "paired" }), vl.tooltip().fieldQ("dem_vote_share").format(".2%").title("hi") ); const all = barChartData .select("district", "district_type") .orderby("district") .dedupe() .objects() .map(({ district, district_type }) => spec .data( barChartData .params({ district: district }) .filter((d, $) => d.district === $.district) .objects() ) .title({ text: `${district_type} ${district}`, anchor: "middle", align: "left" }) ); const view = vl .concat(all) .columns(all.length > 1 ? 3 : 1) // .center(true) .spacing(30) .config({ view: { stroke: "transparent" } }); return view.render(); }33:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }34:T513,cvapDonutCharts = { const spec = vl.markArc({ stroke: "black", innerRadius: 50 }).encode( vl.theta().fieldQ("cvap"), vl.color().fieldN("race").title(null).scale({ scheme: "rainbow" }), vl.tooltip([ { field: "race", type: "nominal", title: "Race" }, { field: "cvap", type: "quantitative", title: "CVAP", format: "," }, { field: "cvap_rate", type: "quantitative", title: "Rate", format: ".1%" } ]) ); const all = donutChartData .select(["district", "district_type"]) .orderby("district") .dedupe() .objects() .map((d) => spec .data( donutChartData .params({ district: d.district }) .filter((d, $) => d.district === $.district) .objects() ) .title({ text: `${d.district_type} ${d.district}`, subtitle: `${d3.format(",")( aq.agg( donutChartData .params({ district: d.district }) .filter((d, $) => d.district === $.district), op.sum("cvap") ) )} total eligible voters` }) ); const view = vl .concat(all) .columns(all.length > 1 ? 3 : 1) .spacing(70) .config({ view: { stroke: "transparent" } }); return view.render(); }35:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }36:T9c9,regVoterAgeDonutCharts = { let districts = aq.agg(map_data_table, op.array_agg_distinct("district")); if (downballot_office.district_type === "CD") { var data = tables.current_vb_counts.rename({ cd: "district" }); var district_type = "CD"; districts = districts.map((d) => "0" + d); } else if (downballot_office.district_type === "SD") { var data = tables.current_vb_counts.rename({ sd: "district" }); var district_type = "SD"; } else if (downballot_office.district_type === "HD") { var data = tables.current_vb_counts.rename({ hd: "district" }); var district_type = "HD"; } data = data .params({ zoom_to: zoomTo.pattern, district_type: district_type, districts: districts }) .filter( (d, $) => op.match(d.district, $.zoom_to) && op.includes($.districts, d.district) ) .groupby(["district", "age_range"]) .rollup({ reg_count: op.sum("reg_count") }) .groupby(["district"]) .derive({ reg_total: op.sum("reg_count") }) .derive({ reg_rate: (d) => d.reg_count / d.reg_total, district_type: (d, $) => $.district_type }) .reify(); const spec = vl.markArc({ stroke: "black", innerRadius: 50 }).encode( vl.theta().fieldQ("reg_count"), vl.color().fieldN("age_range").title(null).scale({ scheme: "rainbow" }), vl.tooltip([ { field: "age_range", type: "nominal", title: "Age range" }, { field: "reg_count", type: "quantitative", title: "Reg count", format: "," }, { field: "reg_rate", type: "quantitative", title: "Rate", format: ".1%" } ]) ); const all = data .select(["district", "district_type"]) .orderby("district") .dedupe() .objects() .map((d) => spec .data( data .params({ district: d.district }) .filter((d, $) => d.district === $.district) .objects() ) .title({ text: `${d.district_type} ${d.district}`, subtitle: `${d3.format(",")( aq.agg( data .params({ district: d.district }) .filter((d, $) => d.district === $.district), op.sum("reg_count") ) )} total registered voters` }) ); const view = vl .concat(all) .columns(all.length > 1 ? 3 : 1) .spacing(70) .config({ view: { stroke: "transparent" } }); return embed(view.toSpec()); }37:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }38:T9ee,regVoterPartyDonutCharts = { let districts = aq.agg(map_data_table, op.array_agg_distinct("district")); if (downballot_office.district_type === "CD") { var data = tables.current_vb_counts.rename({ cd: "district" }); var district_type = "CD"; districts = districts.map((d) => "0" + d); } else if (downballot_office.district_type === "SD") { var data = tables.current_vb_counts.rename({ sd: "district" }); var district_type = "SD"; } else if (downballot_office.district_type === "HD") { var data = tables.current_vb_counts.rename({ hd: "district" }); var district_type = "HD"; } data = data .params({ zoom_to: zoomTo.pattern, district_type: district_type, districts: districts }) .filter( (d, $) => op.match(d.district, $.zoom_to) && op.includes($.districts, d.district) ) .groupby(["district", "party"]) .rollup({ reg_count: op.sum("reg_count") }) .groupby(["district"]) .derive({ reg_total: op.sum("reg_count") }) .derive({ reg_rate: (d) => d.reg_count / d.reg_total, district_type: (d, $) => $.district_type }) .reify(); const spec = vl.markArc({ stroke: "black", innerRadius: 50 }).encode( vl.theta().fieldQ("reg_count"), vl .color() .fieldN("party") .title(null) .scale({ range: ["#377eb8", "#e41a1c", "#999999"] }), vl.tooltip([ { field: "party", type: "nominal", title: "Likely Party" }, { field: "reg_count", type: "quantitative", title: "Reg count", format: "," }, { field: "reg_rate", type: "quantitative", title: "Rate", format: ".1%" } ]) ); const all = data .select(["district", "district_type"]) .orderby("district") .dedupe() .objects() .map((d) => spec .data( data .params({ district: d.district }) .filter((d, $) => d.district === $.district) .objects() ) .title({ text: `${d.district_type} ${d.district}`, subtitle: `${d3.format(",")( aq.agg( data .params({ district: d.district }) .filter((d, $) => d.district === $.district), op.sum("reg_count") ) )} total registered voters` }) ); const view = vl .concat(all) .columns(all.length > 1 ? 3 : 1) .spacing(70) .config({ view: { stroke: "transparent" } }); return view.render(); }39:T7e4,{ if (zoomTo.label === " ") { var view = form(html``); } else { var view = form(html``); // var view = form(html``); } return Inputs.bind(view, viewof include_only); }3a:T6c3,{ let display_cols = [ { name: "cvap", label: "CVAP" }, { name: "reg_count", label: "Reg count" } ]; if (selectedParty.label === "") { display_cols = [{ name: "party", label: "Party" }].concat(display_cols); } if (selectedRace.label === "") { display_cols = [{ name: "cvap_race", label: "Race (from CVAP)" }].concat( display_cols ); } if (selectedAgeRange.label === "") { display_cols = [{ name: "age_range", label: "Age range" }].concat( display_cols ); } if (zoomTo.label === " ") { var district_type = downballot_office.district_type; display_cols = [ { name: district_type.toLowerCase(), label: district_type.toUpperCase() } ].concat(display_cols); } display_cols = display_cols.concat([ { name: "share_of_cvap", label: "Share of CVAP" } // "share_of_district_cvap" ]); return Inputs.table( districtData .params({ district_type: downballot_office.district_type.toLowerCase(), included_districts: aq.agg( map_data_table, op.array_agg_distinct("district") ) }) .groupby("cvap_race") .derive({ share_of_cvap: (d) => d.reg_count / d.cvap }) .filter( (d, $) => d.cvap_race !== "Other" && d.age_range !== "Unknown" && op.includes($.included_districts, d[$.district_type]) ) .rename( Object.fromEntries(display_cols.map(({ name, label }) => [name, label])) ), { height: 650, rows: 30, format: { "Share of CVAP": d3.format(".1%") // share_of_district_cvap: d3.format(".1%") }, columns: display_cols.map((d) => d.label) } ); }3b:Tc88,map = { if (zoomTo.label === " ") { var feature = downballot_office.district_type.toLowerCase(); var table = performance_by_district.params({ fips: state.fips }).derive({ geo_id: (d, $) => $.fips + d.district }); } else { var feature = "tract"; var table = performance_by_tract .params({ district: zoomTo.pattern }) .filter((d, $) => op.match(d.District, $.district)) .derive({ geo_id: (d) => d.tract_id }); } // const geoCentroids = vl // .markCircle({ // fillOpacity: 0.8, // stroke: "black", // strokeWidth: 0.5, // fill: "gray" // }) // .transform( // vl // .lookup("geo_id") // .from( // vl // .lookupData(vl.topojson(geoShapeData).feature(feature)) // .key("properties.GEOID") // ) // .as("geo") // ) // .encode( // vl.longitude("geo.properties.CENTROID[0]"), // vl.latitude("geo.properties.CENTROID[1]"), // vl // .size() // .fieldQ(geoCentroidsSizedBy.name) // .sort(geoCentroidsSizedBy.sort_order) // .title(geoCentroidsSizedBy.label) // ); const geoShape = vl .markGeoshape({ stroke: "gray", strokeWidth: 1, shape: "geo" }) .transform( vl .lookup("geo_id") .from( vl .lookupData(vl.topojson(geoShapeData).feature(feature)) .key("properties.GEOID") ) .as("geo") ) .encode( vl.shape().field("geo").type("geojson"), vl .color() .fieldQ(geoShapesColoredBy.name) .scale(geoShapesColoredBy.scale_config) .title(geoShapesColoredBy.label) .legend({ format: "%" }), vl.tooltip([ { field: "geo.properties.NAMELSAD", type: "nominal", title: "Name" }, { field: "dem_vote_share_bottom", type: "quantitative", title: `Vote share (${downballot_office.label_short})`, format: ".2%" }, { field: "dem_vote_share_top", type: "quantitative", title: `Vote share (${top_ballot.Contest})`, format: ".2%" }, { field: "total_vote_count_bottom", type: "quantitative", title: `Total votes (${downballot_office.label_short})`, format: ",d" }, { field: "total_vote_count_top", type: "quantitative", title: `Total votes (${top_ballot.Contest})`, format: ",d" }, { field: "total_vote_count_bottom_to_top_diff", type: "quantitative", title: "Rolloff", format: ",d" }, { field: "rolloff_rate", type: "quantitative", title: "Rolloff rate", format: ".2%" } // { // field: "turnout", // type: "quantitative", // title: "Turnout", // format: ".2%" // } ]) ); return ( vl // , geoCentroids) .layer(geoShape) .data(table) .project(vl.projection("albersUsa")) .width(700) .height(600) ); }3c:Tc6e,geo_color_fields = [ // { // name: "", // label: "", // description: md`Shows tract shapes without coloring.` // }, { name: "dem_vote_share_bottom_to_top_diff", label: `${downballot_office.label_short} / ${top_ballot.office} vote share diff`, description: md`Shows the percentage point **difference** between the **vote shares** for the DEM **${downballot_office.label_short}** candidates and the DEM **${top_ballot.office}** candidate in each census tract.`, format: ".2f", scale_config: { scheme: "redyellowgreen", domainMid: 0.0 } }, { name: "dem_vote_share_bottom", label: `${downballot_office.label_short} vote share`, description: md`Shows the DEM **${downballot_office.label_short}** candidates' **share of votes** in each census tract.`, format: ".2%", scale_config: { scheme: "redblue", domainMid: 0.5 } }, // { // name: "dem_vote_share_margin_bottom", // label: `${downballot_office.label_short} margin (pct point)`, // description: md`Shows the DEM **${downballot_office.label_short}** candidates' percentage point **margin** in each census tract.`, // format: ".2f" // }, { name: "dem_vote_share_top", label: `${top_ballot.office} vote share`, description: md`Shows the DEM **${top_ballot.office}** candidate's **share of votes** in each census tract.`, format: ".2%", scale_config: { scheme: "redblue", domainMid: 0.5 } }, // { // name: "dem_vote_share_margin_top", // label: `${top_ballot.office} margin (pct point)`, // description: md`Shows the DEM **${top_ballot.office}** candidate's percentage point **margin** in each census tract.`, // format: ".2f" // }, // { // name: "turnout", // label: "Turnout rate", // description: md`Shows the rate at which **registered voters** in the census tract **turned out to vote** in the ${topBallot.year} general election.`, // format: ".2%", // scale_config: { scheme: "bluepurple" } // }, { name: "rolloff_rate", label: "Voter rolloff rate", description: md`Shows the **difference** between the tract-level **vote totals** in the **${downballot_office.label_short}** and **${top_ballot.office}** contests as a **rate** of votes cast in the **${top_ballot.office}** contest.`, format: ".2%", scale_config: { scheme: "purpleorange" } } // { // name: "dem_vote_share_4y_diff", // label: `${topBallot.year} / ${topBallot.year - 4} ${ // downballot_office.label_short // } vote share diff`, // description: md`Shows the percentage point **difference** between vote shares for the **${ // topBallot.year // }** and **${topBallot.year - 4}** DEM **${ // downballot_office.label_short // }** candidates in each census tract.`, // format: ".2f" // }, // { // name: "turnout_4y_diff", // label: `${topBallot.year} / ${topBallot.year - 4} turnout diff`, // description: md`Shows the percentage point **difference** between the voter turnout rates in **${ // topBallot.year // }** and **${topBallot.year - 4}** general elections in each census tract.`, // format: ".2f" // } ]3d:T5c1,get_party_display_fields = (party) => { return [ { name: `${party.toLowerCase()}_vote_count_bottom`, label: `${party.toUpperCase()} ${downballot_office.label_short} votes`, format: (d) => Math.abs(d) > 99 ? d3.format(".3s")(d) : d3.format(",d")(d), width: 89 }, { name: `${party.toLowerCase()}_vote_share_bottom`, label: `${party.toUpperCase()} ${downballot_office.label_short} share`, format: (d) => format_vote_share(d, party), width: 47 }, { name: `${party.toLowerCase()}_vote_count_top`, label: `${party.toUpperCase()} ${top_ballot.office} votes`, format: (d) => Math.abs(d) > 99 ? d3.format(".3s")(d) : d3.format(",d")(d), width: 83 }, { name: `${party.toLowerCase()}_vote_share_top`, label: `${party.toUpperCase()} ${top_ballot.office} share`, format: (d) => format_vote_share(d, party), width: 80 }, { name: `${party.toLowerCase()}_vote_count_bottom_to_top_diff`, label: `${party.toUpperCase()} vote diff`, format: (d) => Math.abs(d) > 99 ? d3.format("+.3s")(d) : d3.format("+,d")(d), width: 50 }, { name: `${party.toLowerCase()}_vote_share_bottom_to_top_diff`, label: `${party.toUpperCase()} share diff`, format: (d) => format_vote_share_diff(d), width: 53 } // { name: "turnout", label: "Turnout", format: d3.format(".1%"), width: 60 } ]; }3e:T567,dataDisplayLabels = { if (zoomTo.label == " ") { var fields = [ { name: "district", label: "District", format: (d) => d, width: 4 } // { name: "county_name", label: "County", format: (d) => d, width: 55 } ]; } else { var fields = [ { name: "tract_id", label: "Tract", format: (d) => d, width: 78 } ]; } const dem_party_fields = get_party_display_fields("dem"); const gop_party_fields = get_party_display_fields("gop"); return fields .concat(dem_party_fields) .concat(gop_party_fields) .concat([ { name: "rolloff", label: "Rolloff", format: (d) => Math.abs(d) > 99 ? d3.format(".3s")(d) : d3.format(",d")(d), width: 50 }, { name: "rolloff_rate", label: "Rolloff rate", format: (d) => format_rolloff_rate(d), width: 53 }, { name: "vote_count_margin_bottom", label: `${downballot_office.label_short} W/L margin`, format: (d) => Math.abs(d) > 99 ? d3.format(".3s")(d) : d3.format(",d")(d) }, { name: "vote_count_margin_top", label: `${top_ballot.office} W/L margin`, format: (d) => Math.abs(d) > 99 ? d3.format(".3s")(d) : d3.format(",d")(d) } // { name: "turnout", label: "Turnout", format: d3.format(".1%"), width: 60 } ]); }3f:T642,custom_queries = ({ calcPerformance: aq .query() .derive({ dem_vote_share: (d) => d.dem_vote_count / d.total_vote_count, gop_vote_share: (d) => d.gop_vote_count / d.total_vote_count, oth_vote_share: (d) => d.oth_vote_count / d.total_vote_count, vote_count_margin: (d) => op.abs(d.dem_vote_count - d.gop_vote_count) }) .derive({ vote_share_margin: (d) => op.abs(d.dem_vote_share - d.gop_vote_share) }), diffBallotParts: aq .query() .derive({ dem_vote_count_bottom_to_top_diff: (d) => d.dem_vote_count_bottom - d.dem_vote_count_top, dem_vote_share_bottom_to_top_diff: (d) => d.dem_vote_share_bottom - d.dem_vote_share_top, gop_vote_count_bottom_to_top_diff: (d) => d.gop_vote_count_bottom - d.gop_vote_count_top, gop_vote_share_bottom_to_top_diff: (d) => d.gop_vote_share_bottom - d.gop_vote_share_top, total_vote_count_bottom_to_top_diff: (d) => d.total_vote_count_bottom - d.total_vote_count_top }) .derive({ rolloff: (d) => d.total_vote_count_bottom_to_top_diff < 0 ? op.abs(d.total_vote_count_bottom_to_top_diff) : NaN }) .derive({ rolloff_rate: (d) => d.rolloff / d.total_vote_count_top }) // special_geo: (d) => // d.total_vote_count_bottom_to_top_diff < 0 && // d.dem_vote_count_bottom_to_top_diff < 0 && // d.vote_count_margin_bottom < // op.abs(d.dem_vote_count_bottom_to_top_diff) && // op.abs(d.dem_vote_count_bottom_to_top_diff) < // op.abs(d.gop_vote_count_bottom_to_top_diff) })40:T8fc,districtData = { let data = tables.current_vb_counts .params({ district_type: downballot_office.district_type.toLowerCase(), district: zoomTo.pattern, age_range: selectedAgeRange.pattern, race: selectedRace.pattern, party: selectedParty.pattern }) .filter( (d, $) => d[$.district_type] !== null && op.match(d.age_range, $.age_range) && op.match(d.race, $.race) && op.match(d.party, $.party) ) .groupby([ downballot_office.district_type.toLowerCase(), "age_range", "race", "cvap_race", "party" ]) .rollup({ reg_count: op.sum("reg_count") }); if (downballot_office.district_type === "CD") { var cvapLookupTable = cvap.by_cd .groupby(["cd", "race"]) .rollup({ cvap: op.sum("cvap") }); data = data .derive({ cd: (d) => op.substring(d.cd, 1) }) .filter((d, $) => op.match(d.cd, $.district)) .lookup( cvapLookupTable, [ ["cd", "cvap_race"], ["cd", "race"] ], "cvap" ) .groupby(["cd", "cvap_race"]); } else if (downballot_office.district_type === "SD") { var cvapLookupTable = cvap.by_sd .groupby(["sd", "race"]) .rollup({ cvap: op.sum("cvap") }); data = data .filter((d, $) => op.match(d.sd, $.district)) .lookup( cvapLookupTable, [ ["sd", "cvap_race"], ["sd", "race"] ], "cvap" ) .groupby(["sd", "cvap_race"]); } else if (downballot_office.district_type === "HD") { var cvapLookupTable = cvap.by_hd .groupby(["hd", "race"]) .rollup({ cvap: op.sum("cvap") }); data = data .filter((d, $) => op.match(d.hd, $.district)) .lookup( cvapLookupTable, [ ["hd", "cvap_race"], ["hd", "race"] ], "cvap" ) .groupby(["hd", "cvap_race"]); } return ( data // .derive({ // cvap_district_total: (d) => op.sum(d.cvap) // }) // .derive({ // share_of_race_cvap: (d) => d.reg_count / d.cvap, // share_of_district_cvap: (d) => d.reg_count / op.sum(d.cvap) // }) .orderby([downballot_office.district_type.toLowerCase()]) ); }41:Tbd4,from_electionbase = ({ top_contest_vote_counts: { statewide: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/top-contests/vote-counts/statewide.csv` ), by_cd: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-cd.csv`, { parse: { district: (d) => d } } ), by_sd: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-sd.csv`, { parse: { district: (d) => d } } ), by_hd: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-hd.csv`, { parse: { district: (d) => d } } ), by_cd_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-cd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ), by_sd_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-sd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ), by_hd_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/top-contests/vote-counts/by-hd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ) }, us_rep_contests: { vote_counts_by_district: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/congressional-contests/vote-counts/by-cd.csv`, { parse: { district: (d) => d } } ), vote_counts_by_district_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/congressional-contests/vote-counts/by-cd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ) }, state_sen_contests: { vote_counts_by_district: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/state-senate-contests/vote-counts/by-sd.csv`, { parse: { district: (d) => d } } ), vote_counts_by_district_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/state-senate-contests/vote-counts/by-sd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ) }, state_rep_contests: { vote_counts_by_district: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/state-house-contests/vote-counts/by-hd.csv`, { parse: { district: (d) => d } } ), vote_counts_by_district_and_tract: await aq.loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/state-house-contests/vote-counts/by-hd-and-tract.csv`, { parse: { district: (d) => d, tract_id: (d) => d } } ) } })42:Tc83,performance_by_tract = { if (downballot_office.district_type === "CD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_cd_and_tract; var down_ballot_table = from_electionbase.us_rep_contests.vote_counts_by_district_and_tract; } else if (downballot_office.district_type === "SD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_sd_and_tract; var down_ballot_table = from_electionbase.state_sen_contests.vote_counts_by_district_and_tract; } else if (downballot_office.district_type === "HD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_hd_and_tract; var down_ballot_table = from_electionbase.state_rep_contests.vote_counts_by_district_and_tract; } top_ballot_table = custom_queries.calcPerformance.evaluate( top_ballot_table .params({ year: top_ballot.year, zoomToPattern: zoomTo.pattern }) .filter( (d, $) => d.year == $.year && op.match(d.district, $.zoomToPattern) ) .groupby("tract_id") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count") }) ); down_ballot_table = custom_queries.calcPerformance.evaluate( down_ballot_table .params({ year: top_ballot.year, zoomToPattern: zoomTo.pattern }) .filter( (d, $) => d.year == $.year && op.match(d.district, $.zoomToPattern) ) .groupby("tract_id") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count"), district: op.array_agg_distinct("district") }) .derive({ District: (d) => op.join(d.district, ", ") }) ); const data = custom_queries.diffBallotParts .evaluate( down_ballot_table.join(top_ballot_table, "tract_id", null, { suffix: ["_bottom", "_top"] }) ) .derive({ county_code: (d) => op.substring(d.tract_id, 0, 5) }) .lookup(counties, ["county_code", "geo_id"], "name") .derive({ county_name: (d) => op.replace(d.name, " County", "") }) .select(aq.not("name")) // .lookup(turnout, "tract_id", ["reg_count", "ballot_count", "turnout"]) .params({ geoShapeColorBy: geoShapesColoredBy.name // geoCentroidSizeBy: geoCentroidsSizedBy.name, // flipDirection: flipFilter.pattern, // turnoutRange: turnoutRange, // voteShareRange: voteShareRange }) // .filter( // (d, $) => // op.match(d.flip_direction_top_to_bottom, $.flipDirection) && // d.turnout >= $.turnoutRange[0] && // d.turnout <= $.turnoutRange[1] && // d.dem_vote_share_bottom >= $.voteShareRange[0] && // d.dem_vote_share_bottom <= $.voteShareRange[1] // ) .derive({ geoShapeColorBy: (d, $) => d[$.geoShapeColorBy] // geoCentroidSizeBy: (d, $) => d[$.geoCentroidSizeBy] }); return data; }43:T754,performance_by_district_no_district_filter = { if (downballot_office.district_type === "CD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_cd; var down_ballot_table = from_electionbase.us_rep_contests.vote_counts_by_district; } else if (downballot_office.district_type === "SD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_sd; var down_ballot_table = from_electionbase.state_sen_contests.vote_counts_by_district; } else if (downballot_office.district_type === "HD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_hd; var down_ballot_table = from_electionbase.state_rep_contests.vote_counts_by_district; } top_ballot_table = custom_queries.calcPerformance.evaluate( top_ballot_table .params({ year: top_ballot.year }) .filter((d, $) => d.year == $.year) .groupby("district") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count") }) ); down_ballot_table = custom_queries.calcPerformance.evaluate( down_ballot_table .params({ year: top_ballot.year }) .filter((d, $) => d.year == $.year && op.match(d.district)) .groupby("district") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count") // district: op.array_agg_distinct("tract_id") }) ); const data = custom_queries.diffBallotParts.evaluate( down_ballot_table.join(top_ballot_table, "district", null, { suffix: ["_bottom", "_top"] }) ); return data; }44:Tb02,performance_by_district = { if (downballot_office.district_type === "CD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_cd; var down_ballot_table = from_electionbase.us_rep_contests.vote_counts_by_district; } else if (downballot_office.district_type === "SD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_sd; var down_ballot_table = from_electionbase.state_sen_contests.vote_counts_by_district; } else if (downballot_office.district_type === "HD") { var top_ballot_table = from_electionbase.top_contest_vote_counts.by_hd; var down_ballot_table = from_electionbase.state_rep_contests.vote_counts_by_district; } top_ballot_table = custom_queries.calcPerformance.evaluate( top_ballot_table .params({ year: top_ballot.year, zoomToPattern: zoomTo.pattern }) .filter( (d, $) => d.year == $.year && op.match(d.district, $.zoomToPattern) ) .groupby("district") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count") }) ); down_ballot_table = custom_queries.calcPerformance.evaluate( down_ballot_table .params({ year: top_ballot.year, zoomToPattern: zoomTo.pattern }) .filter( (d, $) => d.year == $.year && op.match(d.district, $.zoomToPattern) ) .groupby("district") .rollup({ dem_vote_count: op.sum("dem_vote_count"), gop_vote_count: op.sum("gop_vote_count"), oth_vote_count: op.sum("oth_vote_count"), total_vote_count: op.sum("total_vote_count") // district: op.array_agg_distinct("tract_id") }) ); let data = custom_queries.diffBallotParts .evaluate( down_ballot_table.join(top_ballot_table, "district", null, { suffix: ["_bottom", "_top"] }) ) // .lookup(turnout, "tract_id", ["reg_count", "ballot_count", "turnout"]) .params({ geoShapeColorBy: geoShapesColoredBy.name // geoCentroidSizeBy: geoCentroidsSizedBy.name, // flipDirection: flipFilter.pattern, // turnoutRange: turnoutRange, // voteShareRange: voteShareRange }) // .filter( // (d, $) => // op.match(d.flip_direction_top_to_bottom, $.flipDirection) && // d.turnout >= $.turnoutRange[0] && // d.turnout <= $.turnoutRange[1] && // d.dem_vote_share_bottom >= $.voteShareRange[0] && // d.dem_vote_share_bottom <= $.voteShareRange[1] // ) .derive({ geoShapeColorBy: (d, $) => d[$.geoShapeColorBy] // geoCentroidSizeBy: (d, $) => d[$.geoCentroidSizeBy] }); return data; }45:T6d3,barChartData = { if (downballot_office.district_type === "SD") { var downBallotData = full_district_data.derive({ race: () => "State Sen" }); var topBallotData = from_electionbase.top_contest_vote_counts.by_sd; var district_type = "SD"; } else if (downballot_office.district_type === "HD") { var downBallotData = full_district_data.derive({ race: () => "State Rep" }); var topBallotData = from_electionbase.top_contest_vote_counts.by_hd; var district_type = "HD"; } else if (downballot_office.district_type === "CD") { var downBallotData = full_district_data.derive({ race: () => "U.S. Rep" }); var topBallotData = from_electionbase.top_contest_vote_counts.by_cd; var district_type = "CD"; } const data = downBallotData .params({ district_type: district_type, zoom_to: zoomTo.pattern, included_districts: aq.agg( map_data_table, op.array_agg_distinct("district") ) }) .select("year", "race", "district", "dem_vote_count", "total_vote_count") .concat( topBallotData .derive({ race: () => "Top contest" }) .select( "year", "race", "district", "dem_vote_count", "total_vote_count" ) ) .filter( (d, $) => op.match(d.district, $.zoom_to) && op.includes($.included_districts, d.district) ) .groupby(["year", "race", "district"]) .rollup({ dem_vote_count: op.sum("dem_vote_count"), total_vote_count: op.sum("total_vote_count") }) .derive({ dem_vote_share: (d) => d.dem_vote_count / d.total_vote_count, district_type: (d, $) => $.district_type }); return data; }46:T4cb,tables = ({ current_vb_counts: await aq .loadCSV( `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/current-vb-counts.csv`, { parse: { cd: (d) => d, sd: (d) => d, hd: (d) => d } } ) .then( (table) => table .derive({ cvap_race: (d) => { if (d.race === "Asian") { return "AAPI"; } else if (d.race === "African-American") { return "Black"; } else if (d.race === "Native American") { return "Native"; } else if (d.race === "Caucasian") { return "White"; } else if (d.race === "Uncoded") { return "Other"; } else { return d.race; } } }) .derive({ party: (d) => (d.party === "DEMOCRAT" ? "DEM" : d.party) }) .derive({ party: (d) => (d.party === "REPUBLICAN" ? "GOP" : d.party) }) .derive({ party: (d) => (d.party === "UNAFFILIATED" ? "OTH" : d.party) }) // .orderby(["cd", "sd", "hd", "age_range", "party"]) // ) ) })47:[] 2e:{"id":"35496006b15aa6ce","slug":"way-to-win-down-ballot-analysis","title":"The Way To Win Down Ballot","thumbnail":"e15b52bbbeb9b370a1fd60cdc6b6c5fc96ca0944a375e561ee56c8ba729caeb1","access_level":"public","create_time":"$D2021-10-19T14:42:14.436Z","update_time":"$D2022-05-09T03:05:40.873Z","view_time":null,"first_public_time":"$D2021-12-07T17:27:14.212Z","has_unpublished_edits":null,"fork":true,"stars":3,"starred":false,"owner":{"type":"team","id":"84e1d5b645e8ca24","login":"targetsmart","name":"TargetSmart","avatar_url":"https://avatars-next.observableusercontent.com/fb9f176255f04c17a10aa723473e8a97b4304ad1573a9c4feed08110a11dbc5a","tier":"pro"},"version":3344,"publish_version":3344,"role":null,"authored":false,"authors":[{"type":"individual","id":"b994c936cb92cfce","login":"gordo-ts","name":"James Gordon","avatar_url":"https://avatars-next.observableusercontent.com/67a39968898ee5f5fd2c602cca1882d83060aea874e87a1ea6711b6cd54afa6e","tier":null}],"members":[{"type":"individual","id":"b994c936cb92cfce","login":"gordo-ts","name":"James Gordon","avatar_url":"https://avatars-next.observableusercontent.com/67a39968898ee5f5fd2c602cca1882d83060aea874e87a1ea6711b6cd54afa6e","tier":null,"role":"editor"},{"type":"individual","id":"fb5890c4c51f384a","login":"benlazarus","name":"Benjamin Lazarus","avatar_url":"https://avatars-next.observableusercontent.com/c2bccf66db9042e905ad43ea6697506727c6cb16cd7b91cef386eaa8ae1f6225","tier":null,"role":"viewer"},{"type":"individual","id":"7b1cbf83a69124b5","login":"benstroud","name":"","avatar_url":null,"tier":null,"role":"viewer"},{"type":"individual","id":"c93cb110a7302aec","login":"c93cb110a7302aec","name":"Christopher Brill","avatar_url":"https://avatars-next.observableusercontent.com/73ad5c3f21fe5ccf27aac58f399848476fd71a3a627f56f03101b723efb36484","tier":null,"role":"viewer"},{"type":"individual","id":"363f4c7a3c1c0d3e","login":"colleen","name":"Colleen Loper","avatar_url":null,"tier":null,"role":"viewer"},{"type":"individual","id":"c660ad177809002e","login":"jennpae","name":"Jennifer Pae","avatar_url":"https://avatars-next.observableusercontent.com/fa13efcdf59973f39a04c6823877a3a98baff5c441172fbd7f840a7fdba16883","tier":null,"role":"viewer"},{"type":"individual","id":"b66cb842272113eb","login":"moliphant","name":"","avatar_url":null,"tier":null,"role":"viewer"},{"type":"individual","id":"36df443debe2d106","login":"roksana","name":"Roksana Borzouei","avatar_url":"https://avatars-next.observableusercontent.com/b5d3ba2f9f4ed0adc2049a59973646262e5e5e69a2b698467bfe6108ea7da0db","tier":null,"role":"viewer"},{"type":"team","id":"84e1d5b645e8ca24","login":"targetsmart","name":"TargetSmart","avatar_url":"https://avatars-next.observableusercontent.com/fb9f176255f04c17a10aa723473e8a97b4304ad1573a9c4feed08110a11dbc5a","tier":"pro","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":9,"collection":null,"type":"notebook","body":{"titling":"auto","title":"The Way To Win Down Ballot","cells":[{"id":0,"value":"# The Way To Win Down Ballot","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2027,"value":"TargetSmart has developed an interactive descriptive analysis of November general election results from 2012 to 2020. The analysis examined voting history from 13 states identified by our partner, [WayToWin](https://waytowin.us), as critical to the future of the progressive movement.\n\n**Disclaimer:** Vote counts and shares derived from TargetSmart's ElectionBase product do not align precisely with official election results. For definitive information about the outcomes of previous elections, please consult official certified results published by state and local election authorities.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":582,"value":"Inputs.bind(\n Inputs.select(states, {\n format: (d) => d.name,\n label: \"State\",\n width: \"20%\"\n }),\n viewof state\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"In the **Nov ${top_ballot.year}** general election, the Democratic **${top_ballot.office}** candidate **${top_ballot.result}** with a **${ d3.format('.1%')(top_ballot.dem_vote_share) }** share of votes across the state of **${state.name}**. The margin between the DEM and GOP candidates was **${d3.format(\".0s\")(top_ballot.vote_count_margin)} votes** (${d3.format('.1f')(top_ballot.vote_share_margin * 100)} percentage points).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2416,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":440,"value":"{\n const data = top_contest_statewide_results.objects();\n\n const options = {\n columns: [\n \"Year\",\n \"Contest\",\n \"DEM share\",\n \"GOP share\",\n \"Vote count margin\",\n \"Vote share margin\"\n // \"Turnout\"\n ],\n format: {\n Year: d3.format(\"d\"),\n \"DEM share\": d3.format(\".2%\"),\n \"GOP share\": d3.format(\".2%\"),\n Turnout: d3.format(\".2%\"),\n \"Vote count margin\": d3.format(\"+.0s\"),\n \"Vote share margin\": (d) => d3.format(\"+.2f\")(d * 100)\n },\n layout: \"auto\",\n width: \"80%\",\n multiple: false,\n required: false,\n value: data.find((d) => d.Year === top_ballot.year)\n };\n\n return Inputs.bind(Inputs.table(data, options), viewof top_ballot);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":916,"value":"{\n const select = Inputs.select(downballot_offices, {\n format: (d) => d.label_long,\n label: \"Office\"\n });\n\n return Inputs.bind(select, viewof downballot_office);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2617,"value":"{\n const districts = current_district_data.array(\"district\").map((d) => {\n return { label: d, pattern: new RegExp(`${d}`) };\n });\n\n const options = [{ label: \" \", pattern: /\\d{2,3}/ }].concat(districts);\n\n const select = Inputs.select(options, {\n label: \"District\",\n format: (d) => d.label\n });\n\n return Inputs.bind(select, viewof zoomTo);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"{\n const select = Inputs.select(geo_color_fields, {\n // value: options.find((d) => d.name === \"dem_vote_share_bottom_to_top_diff\"),\n label: \"Geo colored by\",\n format: (d) => d.label\n });\n\n return Inputs.bind(select, viewof geoShapesColoredBy);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"geoShapesColoredBy.description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2020,"value":"map.render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2019,"value":"In the **${top_ballot.year}** ${downballot_office.label_short} contests:\n\n* The average district-level voter rolloff rate was **${d3.format('.2%')(district_level_metrics.avg_rolloff_rate)}**\n* The average district-level down ballot under-performance (i.e., the DEM Share diff) was **${d3.format('.2%')(district_level_metrics.avg_dem_share_diff)}**\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2018,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2017,"value":"The table below compares votes cast for the Democratic candidate for **${top_ballot.office}** versus the Democratic candidate for the **${downballot_office.label_long}** along with the number of voters and rolloff rate.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2016,"value":"**Scroll** horizontal down and to the right to **view** more data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2015,"value":"**Click** any column header to **re-sort** the table.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":164,"value":"{\n const data = map_data_table.rename(\n Object.fromEntries(\n dataDisplayLabels.map(({ name, label }) => [name, label])\n )\n );\n\n const num_rows = data.numRows();\n\n if (num_rows > 30) {\n var height = 600;\n } else {\n var height = num_rows * 40;\n }\n\n const options = {\n columns: dataDisplayLabels.map((d) => d.label),\n height: height,\n rows: 30,\n format: Object.assign(\n {},\n ...dataDisplayLabels.map((item) => ({ [item.label]: item.format }))\n ),\n width: Object.assign(\n {},\n ...dataDisplayLabels.map((item) => ({ [item.label]: item.width }))\n )\n };\n\n // return [num_rows, height];\n return Inputs.table(data, options);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3116,"value":"{\n const districtType = downballot_office.district_type.toLowerCase();\n\n const geoLevel = isZoomedIn\n ? `${districtType}-${zoomTo.label}`\n : districtType;\n\n const file_name = `${state.usps}-${geoLevel}-${selectedYear}.csv`;\n\n const options = {\n columns: dataDisplayLabels.map((d) => d.name),\n format: Object.assign(\n {},\n ...dataDisplayLabels.map((item) => ({\n [item.name]:\n item.name.includes(\"_share\") || item.name.includes(\"_rate\")\n ? d3.format(\".1%\")\n : item.name.includes(\"_id\")\n ? (d) => d\n : d3.format(\"d\")\n }))\n )\n };\n\n const csv = new Blob([map_data_table.toCSV(options)], { type: \"text/csv\" });\n const size = (csv.size / 1024).toFixed(0);\n\n const button = DOM.download(\n csv,\n file_name,\n `Download ${file_name} (~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1275,"value":"## DEM Vote Shares in Top / Down Ballot Contests","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2013,"value":"Inputs.bind(\n Inputs.select(states, {\n format: (d) => d.name,\n label: \"State\",\n width: \"20%\"\n }),\n viewof state\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2012,"value":"Inputs.bind(\n Inputs.select(downballot_offices, {\n format: (d) => d.label_long,\n label: \"Office\"\n }),\n viewof downballot_office\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2472,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1271,"value":"## Citizen Voting Age Population by Racial Category\n\nAs estimated in the [2019 American Community Survey](https://www.census.gov/programs-surveys/decennial-census/about/voting-rights/cvap.2019.html) published by the U.S. Census Bureau.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2010,"value":"Inputs.bind(\n Inputs.select(states, {\n format: (d) => d.name,\n label: \"State\",\n width: \"20%\"\n }),\n viewof state\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2009,"value":"Inputs.bind(\n Inputs.select(downballot_offices, {\n format: (d) => d.label_long,\n label: \"Office\"\n }),\n viewof downballot_office\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2537,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1256,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1823,"value":"## Registered Voters by Age Range","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2008,"value":"Inputs.bind(\n Inputs.select(states, {\n format: (d) => d.name,\n label: \"State\",\n width: \"20%\"\n }),\n viewof state\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2007,"value":"Inputs.bind(\n Inputs.select(downballot_offices, {\n format: (d) => d.label_long,\n label: \"Office\"\n }),\n viewof downballot_office\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2542,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1856,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1868,"value":"## Registered Voters by Modeled Party","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2004,"value":"Inputs.bind(\n Inputs.select(states, {\n format: (d) => d.name,\n label: \"State\",\n width: \"20%\"\n }),\n viewof state\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2003,"value":"Inputs.bind(\n Inputs.select(downballot_offices, {\n format: (d) => d.label_long,\n label: \"Office\"\n }),\n viewof downballot_office\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2544,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1863,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1744,"value":"Use the filters below to produce counts by key demographic queries.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"viewof selectedRace = {\n const cvapValues = [\"\", \"AAPI\", \"Black\", \"Hispanic\", \"Native\", \"White\"];\n const vbValues = [\n /.+/,\n \"Asian\",\n \"African-American\",\n \"Hispanic\",\n \"Native American\",\n \"Caucasian\"\n ];\n const choices = d3\n .zip(cvapValues, vbValues)\n .map((d) => ({ label: d[0], pattern: d[1] }));\n return Inputs.select(choices, {\n label: \"Racial Category\",\n format: (d) => d.label\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1488,"value":"viewof selectedAgeRange = {\n const ageRanges = aq\n .agg(\n tables.current_vb_counts.filter((d) => d.age_range != \"Unknown\"),\n op.array_agg_distinct(\"age_range\")\n )\n .map((d) => ({ label: d, pattern: d }));\n\n const choices = [{ label: \"\", pattern: /.+/ }].concat(ageRanges);\n\n return Inputs.select(choices, { label: \"Age Range\", format: (d) => d.label });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1505,"value":"viewof selectedParty = {\n const parties = aq\n .agg(tables.current_vb_counts, op.array_agg_distinct(\"party\"))\n .map((d) => ({ label: d, pattern: d }));\n\n const choices = [{ label: \"\", pattern: /.+/ }].concat(parties);\n return Inputs.select(choices, {\n label: \"Party\",\n format: (d) => d.label\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2588,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1454,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1999,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3169,"value":"selectedYear = top_ballot.year","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3153,"value":"isZoomedIn = zoomTo.label.trim().length > 0 ? true : false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2527,"value":"map_data_table = {\n if (zoomTo.label === \" \") {\n var table = performance_by_district;\n } else {\n var table = performance_by_tract;\n }\n\n if (include_only.districts_w_narrow_margins) {\n table = table.filter(\n (d) => d.dem_vote_share_bottom > 0.48 && d.dem_vote_share_bottom < 0.52\n );\n }\n\n if (include_only.districts_w_competitive_contests) {\n table = table.filter(\n (d) => d.rolloff_rate < 0.89 && d.vote_share_margin_bottom < 0.95\n );\n }\n\n if (include_only.geos_w_above_avg_rolloff) {\n table = table\n .params({ avg_rolloff_rate: district_level_metrics.avg_rolloff_rate })\n .filter((d, $) => d.rolloff_rate > $.avg_rolloff_rate);\n }\n\n if (include_only.geos_w_above_avg_dem_underperformance) {\n table = table\n .params({ avg_dem_share_diff: district_level_metrics.avg_dem_share_diff })\n .filter(\n (d, $) => d.dem_vote_share_bottom_to_top_diff < $.avg_dem_share_diff\n );\n }\n return table;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1998,"value":"The URL for the notebook accepts the following parameters:\n\n- state (e.g., `?state=TX`)\n- year (e.g., `?year=2020`)\n- office (e.g., `?office=Cong`)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1997,"value":"params = {\n const params = new URLSearchParams(location.search);\n\n return {\n state: params.get(\"state\") || \"az\",\n year: +params.get(\"year\") || 2020,\n office: params.get(\"office\") || \"cong\",\n geo_shapes_colored_by:\n params.get(\"geo_shapes_colored_by\") || \"dem_vote_share_bottom_to_top_diff\"\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1996,"value":"User selected values (set either via inputs or the URL parameters)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1995,"value":"viewof state = Inputs.input(\n states.find((d) => d.usps === params.state.toLowerCase())\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"states = [\n { usps: \"az\", name: \"Arizona\", fips: \"04\" },\n { usps: \"ca\", name: \"California\", fips: \"06\" },\n { usps: \"co\", name: \"Colorado\", fips: \"08\" },\n { usps: \"fl\", name: \"Florida\", fips: \"12\" },\n { usps: \"ga\", name: \"Georgia\", fips: \"13\" },\n { usps: \"mi\", name: \"Michigan\", fips: \"26\" },\n { usps: \"mn\", name: \"Minnesota\", fips: \"27\" },\n { usps: \"mo\", name: \"Missouri\", fips: \"29\" },\n { usps: \"nv\", name: \"Nevada\", fips: \"32\" },\n { usps: \"nc\", name: \"North Carolina\", fips: \"37\" },\n { usps: \"pa\", name: \"Pennsylvania\", fips: \"42\" },\n { usps: \"tx\", name: \"Texas\", fips: \"48\" },\n { usps: \"va\", name: \"Virginia\", fips: \"51\" }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2242,"value":"viewof top_ballot = {\n const contest = top_contest_statewide_results\n .objects()\n .find((d) => d.year === params.year);\n\n return Inputs.input(contest);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1993,"value":"viewof downballot_office = Inputs.input(\n downballot_offices.find(\n (d) => d.eb_race_prefix.toLowerCase() === params.office.toLowerCase()\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1992,"value":"downballot_offices = [\n {\n label_long: \"U.S. Representative\",\n label_short: \"U.S. Rep\",\n eb_race_prefix: \"Cong\",\n district_type: \"CD\"\n },\n {\n label_long: \"State Senate\",\n label_short: \"State Sen\",\n eb_race_prefix: \"StateSen\",\n district_type: \"SD\"\n },\n {\n label_long: \"State Representative\",\n label_short: \"State Rep\",\n eb_race_prefix: \"StateRep\",\n district_type: \"HD\"\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"viewof zoomTo = Inputs.input({ label: \" \", pattern: /\\d{2,3}/ })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2682,"value":"viewof geoShapesColoredBy = {\n const init = geo_color_fields.find(\n (d) => d.name === params.geo_shapes_colored_by\n );\n\n return Inputs.input(init);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2684,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2469,"value":"viewof include_only = Inputs.input({\n districts_w_competitive_contests: true,\n districts_w_narrow_margins: false,\n geos_w_above_avg_rolloff: false,\n geos_w_above_avg_dem_underperformance: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1991,"value":"👇 Register a custom aquero table method.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":491,"value":"aq.addFunction(\n \"get_majority\",\n (d) => {\n if (\n d.dem_vote_count > d.gop_vote_count &&\n d.dem_vote_count > d.oth_vote_count\n ) {\n var majority = \"DEM\";\n } else if (\n d.gop_vote_count > d.dem_vote_count &&\n d.gop_vote_count > d.oth_vote_count\n ) {\n var majority = \"GOP\";\n } else if (\n d.oth_vote_count > d.dem_vote_count &&\n d.oth_vote_count > d.goo_vote_count\n ) {\n var majority = \"OTH\";\n } else {\n majority = \"\";\n }\n\n return majority;\n },\n { override: true }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1989,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1988,"value":"format_vote_share = (value, party) => {\n if (party.toUpperCase() === \"DEM\") {\n var color_value = color_scales.dem_vote_share(value);\n } else if (party.toUpperCase() === \"GOP\") {\n var color_value = color_scales.gop_vote_share(value);\n }\n\n // https://observablehq.com/@youbastard/color-scales-with-adaptive-text-color\n const text_color_scale = d3\n .scaleQuantile()\n .range([\"#fff\", \"#000\"])\n .domain([0, 60, 100]);\n\n const luminance = d3.hcl(color_value).l;\n\n const text_color = text_color_scale(luminance);\n\n return htl.html`

${d3.format(\".1%\")(value)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1987,"value":"format_vote_share_diff = (value) => {\n const color_value = color_scales.dem_vote_share_bottom_to_top_diff(value);\n\n // https://observablehq.com/@youbastard/color-scales-with-adaptive-text-color\n const text_color_scale = d3\n .scaleQuantile()\n .range([\"#fff\", \"#000\"])\n .domain([0, 60, 100]);\n\n const luminance = d3.hcl(color_value).l;\n\n const text_color = text_color_scale(luminance);\n\n return htl.html`

${d3.format(\".1%\")(value)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1986,"value":"format_rolloff_rate = (value) => {\n const color_value = color_scales.rolloff_rate(value);\n\n // https://observablehq.com/@youbastard/color-scales-with-adaptive-text-color\n const text_color_scale = d3\n .scaleQuantile()\n .range([\"#fff\", \"#000\"])\n .domain([0, 60, 100]);\n\n const luminance = d3.hcl(color_value).l;\n\n const text_color = text_color_scale(luminance);\n\n return htl.html`

${d3.format(\".1%\")(value)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1985,"value":"color_scales = {\n if (zoomTo.label === \" \") {\n var table = performance_by_district;\n } else {\n var table = performance_by_tract;\n }\n\n return {\n dem_vote_share: d3\n .scaleDiverging()\n .domain([0.2, 0.5, 0.8])\n .interpolator(d3.interpolateRdBu),\n gop_vote_share: d3\n .scaleDiverging()\n // .domain([0.2, 0.5, 0.8])\n .domain([0.8, 0.5, 0.2])\n .interpolator(d3.interpolateRdBu),\n dem_vote_share_bottom_to_top_diff: d3\n .scaleDiverging()\n .domain([\n aq.agg(table, op.min(\"dem_vote_share_bottom_to_top_diff\")),\n aq.agg(table, op.mean(\"dem_vote_share_bottom_to_top_diff\")),\n aq.agg(table, op.max(\"dem_vote_share_bottom_to_top_diff\"))\n ])\n .interpolator(d3.interpolateRdYlGn),\n rolloff_rate: d3\n .scaleDiverging()\n .domain([\n aq.agg(table, op.min(\"rolloff_rate\")),\n aq.agg(table, op.mean(\"rolloff_rate\")),\n aq.agg(table, op.max(\"rolloff_rate\"))\n ])\n .interpolator(d3.interpolatePuOr)\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1982,"value":"str_to_title_case = (str) =>\n str.slice(0, 1).toUpperCase() + str.slice(1).toLowerCase()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1981,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2376,"value":"top_contest_statewide_results = custom_queries.calcPerformance\n .evaluate(\n from_electionbase.top_contest_vote_counts.statewide\n .params({ state: state.usps.toUpperCase() })\n .filter((d, $) => d.state === $.state)\n )\n .derive({\n office: (d) => (d.race === \"Sen\" ? \"U.S. Sen\" : d.race),\n vote_count_margin: (d) => d.dem_vote_count - d.gop_vote_count,\n vote_share_margin: (d) => d.dem_vote_share - d.gop_vote_share,\n result: (d) => (d.dem_vote_count > d.gop_vote_count ? \"won\" : \"lost\")\n })\n .derive({\n Year: (d) => d.year,\n Contest: (d) => d.office,\n \"DEM share\": (d) => d.dem_vote_share,\n \"GOP share\": (d) => d.gop_vote_share,\n \"Vote count margin\": (d) => d.vote_count_margin,\n \"Vote share margin\": (d) => d.vote_share_margin\n // turnout: \"Turnout\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1435,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1977,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2176,"value":"from_us_census = ({\n cvap: {\n by_cd: await aq.loadCSV(\n \"https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/cvap/by-cd.csv\",\n { parse: { cd: (d) => d } }\n ),\n by_sd: await aq.loadCSV(\n \"https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/cvap/by-sd.csv\",\n { parse: { sd: (d) => d } }\n ),\n by_hd: await aq.loadCSV(\n \"https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/cvap/by-hd.csv\",\n { parse: { hd: (d) => d } }\n )\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1976,"value":"$42","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1975,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1974,"value":"district_level_metrics = ({\n avg_rolloff_rate: aq.agg(\n performance_by_district_no_district_filter,\n op.mean(\"rolloff_rate\")\n ),\n avg_dem_share_diff: aq.agg(\n performance_by_district_no_district_filter,\n op.mean(\"dem_vote_share_bottom_to_top_diff\")\n )\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1973,"value":"$44","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1972,"value":"current_district_data = full_district_data\n .params({ year: top_ballot.year })\n .filter((d, $) => d.year === $.year)\n .select(aq.not([\"year\", \"race\", \"description\"]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1971,"value":"full_district_data = {\n if (downballot_office.district_type === \"CD\") {\n var table = from_electionbase.us_rep_contests.vote_counts_by_district;\n } else if (downballot_office.district_type === \"SD\") {\n var table = from_electionbase.state_sen_contests.vote_counts_by_district;\n } else if (downballot_office.district_type === \"HD\") {\n var table = from_electionbase.state_rep_contests.vote_counts_by_district;\n }\n\n return table;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":694,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1299,"value":"donutChartData = {\n if (downballot_office.district_type === \"CD\") {\n var data = cvap.by_cd.rename({ cd: \"district\" });\n var district_type = \"CD\";\n } else if (downballot_office.district_type === \"SD\") {\n var data = cvap.by_sd.rename({ sd: \"district\" });\n var district_type = \"SD\";\n } else if (downballot_office.district_type === \"HD\") {\n var data = cvap.by_hd.rename({ hd: \"district\" });\n var district_type = \"HD\";\n }\n\n return data\n .params({\n state: state.usps.toUpperCase(),\n zoom_to: zoomTo.pattern,\n district_type: district_type,\n included_districts: aq.agg(\n map_data_table,\n op.array_agg_distinct(\"district\")\n )\n })\n .filter(\n (d, $) =>\n d.state === $.state &&\n op.match(d.district, $.zoom_to) &&\n op.includes($.included_districts, d.district)\n )\n .groupby([\"district\"])\n .derive({\n cvap_rate: (d) => d.cvap / op.sum(d.cvap),\n district_type: (d, $) => $.district_type\n })\n .reify();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"#### From TargetSmart","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1389,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"#### From Census.gov","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1239,"value":"cvap = ({\n by_cd: from_us_census.cvap.by_cd\n .params({ state: state.usps.toUpperCase() })\n .filter((d, $) => d.state === $.state),\n by_sd: from_us_census.cvap.by_sd\n .params({ state: state.usps.toUpperCase() })\n .filter((d, $) => d.state === $.state),\n by_hd: from_us_census.cvap.by_hd\n .params({ state: state.usps.toUpperCase() })\n .filter((d, $) => d.state === $.state)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"counties = aq.loadCSV(\n `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/counties.csv`,\n { parse: { geo_id: (d) => d } }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"### AWS S3 ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1952,"value":"geoShapeData = d3.json(\n `https://s3.amazonaws.com/notebook.targetsmart.com/way-to-win/${state.usps}/shapefiles/2020.json`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"### Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"embed = require(\"vega-embed@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1949,"value":"import { form } from \"@mbostock/form-input\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 2f:"$2e:body"