3e:null 3f:["$","title",null,{"children":"WBEZ Prod: COVID-19 Cases By School | Charmaine Runes | Observable"}] 45:T71a,viewof cpsTimeSeriesChart = { const outerContainer = html`

${timeSeriesStyle()}${style()}

` const chartContainer = html`

` const chartHed = html`

${chatter.hed}

` const chartSubhed = html`

${chatter.subhed}

` const chartAttribution = html`

` const chartSource = html`Source: ${chatter.src}
` const chartNote = html`Note: ${chatter.note} See Methodology for additonal information.
` const chartCredit = html`Visualization: ${chatter.credit}
` const chartLastUpdated= html`Last updated: ${cpsDataLastUpdated}
` const count = html`

${totalCasesToDate} total positives

` let chart = renderLineChart({ school: selectedSchool, data_label: "COVID-19 cases", data_x_value: (d) => d["date"], data_y_value: (d) => +d["cases"], min_date: null, max_date: null, lineColor: "#5f2b7b" }) chartAttribution.appendChild(chartSource); chartAttribution.appendChild(chartNote); chartAttribution.appendChild(chartCredit); chartAttribution.appendChild(chartLastUpdated); chartContainer.appendChild(chartHed); //chartContainer.appendChild(chartSubhed); chartContainer.appendChild(viewof selectedSchool); chartContainer.appendChild(html`
`); chartContainer.appendChild(count); chartContainer.appendChild(chart); chartContainer.appendChild(chartAttribution); outerContainer.appendChild(chartContainer); outerContainer.appendChild(html`
`); return outerContainer; }46:T1671,function renderLineChart(props) { const parse_time = d3.timeParse("%Y-%m-%d"); const margin = { top: 25, right: 40, bottom: 35, left: 40 }; const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [0, 0, width, height]) .attr("style", "max-width: 100%; height: auto;"); // fixes the mobile view if (props.school && schoolNames.includes(props.school)) { let schoolObj = findSchoolData(props.school); let data = reproduceDateSeries(schoolObj["Date Series"]); data = data.filter((d) => { let minDateFilter = true; if (props.min_date) minDateFilter = parse_time(props.data_x_value(d)) >= parse_time(props.min_date); let maxDateFilter = true; if (props.max_date) maxDateFilter = parse_time(props.data_x_value(d)) <= parse_time(props.max_date); return minDateFilter && maxDateFilter && !isNaN(props.data_y_value(d)); }); const rectW = (width / (data.length - 1)) * 0.75; const y = d3 .scaleLinear() .domain([0, d3.max(data, (d) => props.data_y_value(d))]) .range([height - margin.bottom, margin.top]); const x = d3 .scaleTime() .domain(d3.extent(data, (d) => parse_time(props.data_x_value(d)))) .range([margin.left, width - margin.right]); const line = d3 .line() .x((d) => x(parse_time(props.data_x_value(d)))) .y((d) => y(props.data_y_value(d))); const chart = svg .append("g") .attr("width", width) .attr("height", height) //.attr("transform", "translate(" + margin.left + "," + margin.top + ")"); const yAxis = d3.axisLeft(y); const yScaleTicks = yAxis.scale().ticks(5).filter(tick => Number.isInteger(tick)); chart .append("g") .attr("class", "y-axis") .attr("transform", `translate(${margin.left} - 10, 0)`) .call( d3 .axisLeft(y) .ticks(2, '.0f') .tickValues(yScaleTicks) // precision of 0 decimals .tickSize(-width - margin.left) ); chart.select(".y-axis .domain").remove(); const yTicks = chart.selectAll(".y-axis .tick line"); yTicks .style("stroke-dasharray", (d, i) => (i ? "2,2" : "none")) .style("color", "#dcddde"); chart .append("text") .text(props.data_label) .attr("x", 38) .attr("y", y(yScaleTicks[yScaleTicks.length - 1]) - 5.5) .attr("font-size", 12) .attr("font-family", "Source Sans Pro") .attr("fill", "#636466") //.attr("transform", `translate(${margin.left - rectW / 2}, -6.5)`); chart .selectAll(".tick text") .attr("font-size", 12) .attr("fill", "#636466") .attr("transform", `translate(${margin.left - rectW / 2}, -10)`); // Annotations if (singleAnnotations.length > 0) { for (let note of singleAnnotations) { const xPosition = x(parse_time(note["date"])) chart.append("text") .attr("text-anchor", "end") .attr("x", xPosition - 2) .attr("y", margin.top - 10) .style("font-weight", "normal") .style("font-family", "Source Sans Pro") .text(note["text"]) .style("font-size", "10px") .attr("fill", "#636466") chart.append("line") .attr("x1", xPosition) .attr("x2", xPosition) .attr("y1", -height) .attr("y2", y(0)) .style("stroke", "#dfd5e5") .style("stroke-width", "1.5px") } } if (rangeAnnotations.length > 0) { for (let note of rangeAnnotations) { const x1 = x(parse_time(note["startDate"])) const x2 = x(parse_time(note["endDate"])) chart.append("rect") .attr("x", x1) .attr("y", 0) .attr("width", x2 - x1) .attr("height", height - margin.bottom) .style("fill", "#dfd5e5") .style("opacity", 0.5) chart.append("text") .attr("text-anchor", "start") .attr("x", x1 + 5) .attr("y", margin.top - 10) .style("font-weight", "normal") .style("font-family", "Source Sans Pro") .text(note["text"]) .style("font-size", "10px") .attr("fill", "#636466") } } // Line chart chart .append("path") .datum(data) .attr("fill", "none") .style("stroke", props.lineColor) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("stroke-width", 2) .attr("d", line); const timePeriod = d3.extent(data, (d) => parse_time(props.data_x_value(d)) ); const months = d3.timeMonths(timePeriod[0], timePeriod[1]).length; const renderXAxis = (d) => { if (months <= 2) { return d3.timeFormat("%b. %e")(d); } else { return d3.timeFormat("%b.")(d); } }; chart .append("g") .attr("class", "x-axis") .attr("transform", `translate(0, ${height - margin.bottom})`) // This controls the vertical position of the Axis .call( d3 .axisBottom(x) .ticks(width / 100) .tickFormat((d) => d3.timeFormat("%b.")(d) === "Jan." | d3.timeFormat("%b.")(d) === "Sep." ? d3.timeFormat("%b. %Y")(d) : renderXAxis(d) ) ); chart.select(".x-axis .domain").remove(); chart .selectAll(".x-axis text") .attr("font-size", 12) .attr("fill", "#636466"); chart.selectAll(".x-axis line").attr("stroke", "#aaa"); } return svg.node(); }; 47:T52b,function timeSeriesStyle() { return html ` ` }48:T578,viewof lookupTool = { const outerContainer = html`

${style()}

` const hed = html`

DO NOT USE: Look up a school's COVID-19 cases

` const subhed = html`

Search for a school by name.

` const sourceText = html`

Source: Illinois Department of Public Health data on school outbreaks and potential exposures, and Chicago Public Schools data on actionable cases.

` const notesText = html`

Notes: ${loremImpsum}.

` outerContainer.appendChild(hed) outerContainer.appendChild(subhed) //outerContainer.appendChild(viewof searchAllSchools) outerContainer.appendChild(viewof autoSelectSchool) outerContainer.appendChild(html`
`) //outerContainer.appendChild(renderSchoolProperties(searchAllSchools)) outerContainer.appendChild(renderSchoolProperties(autoSelectSchool)) outerContainer.appendChild(sourceText) outerContainer.appendChild(notesText) return outerContainer; }49:T621,function findCPS() { // Get list of Cook County school names from IDPH data let cookCountySchools = []; Array.from(mergedIDPHDataForTable.filter(school => school.CountyName == 'Cook')).forEach(school => cookCountySchools.push(school['School'])); // Get list of CPS school names let cpsSchools = []; cpsCasesData.forEach(school => cpsSchools.push(school['School'])); // Find potential matches let potentialMatches = [] cpsSchools.sort().forEach(cpsSchool => { for (let cookCountySchool of cookCountySchools) { if (cookCountySchool.toUpperCase().includes(cpsSchool)) { potentialMatches.push({ "CPS name": cpsSchool, "IDPH name": cookCountySchool, "CPS cases": mergedIDPHDataForTable.filter(school => school.School == cpsSchool)[0]['Confirmed Cases'], "IDPH city": mergedIDPHDataForTable.filter(school => school.School == cookCountySchool)[0]['City'], "IDPH cases (potential exposures)": mergedIDPHDataForTable.filter(school => school.School == cookCountySchool)[0]['CaseCountDefinition'], "IDPH cases (outbreaks)": mergedIDPHDataForTable.filter(school => school.School == cookCountySchool)[0]['CaseCount'], "IDPH latitude": mergedIDPHDataForTable.filter(school => school.School == cookCountySchool)[0]['Latitude'], "IDPH longitude": mergedIDPHDataForTable.filter(school => school.School == cookCountySchool)[0]['Longitude'] }) } } }) return potentialMatches //[cookCountySchools.sort(), cpsSchools.sort()] }4a:T450,loremImpsum = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. In metus vulputate eu scelerisque felis. Id interdum velit laoreet id donec ultrices tincidunt. Tellus in metus vulputate eu scelerisque felis imperdiet. Varius vel pharetra vel turpis. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Senectus et netus et malesuada fames. Id aliquet lectus proin nibh nisl condimentum id. Porttitor rhoncus dolor purus non. Neque convallis a cras semper auctor neque vitae tempus quam. Pellentesque id nibh tortor id aliquet lectus proin. Maecenas ultricies mi eget mauris. Aliquam purus sit amet luctus venenatis lectus magna fringilla urna. Pretium quam vulputate dignissim suspendisse in. Egestas congue quisque egestas diam in arcu cursus euismod quis. Sem viverra aliquet eget sit amet. Cursus risus at ultrices mi tempus imperdiet nulla malesuada pellentesque. Volutpat odio facilisis mauris sit amet massa vitae tortor. Ut ornare lectus sit amet est placerat in. Sed nisi lacus sed viverra tellus in hac habitasse.'4b:T578,function mergeData(listOfArrays) { // Takes a list of arrays, where each Object in each array represents a unique school // Returns a compiled array of Objects, where each Object represents a unique school var mergedData = new Map() for (let [i, array] of listOfArrays.entries()) { var schoolVarName = findCorrectSchoolVar(Object.getOwnPropertyNames(array[0])) for (let school of array) { var schoolName = school[schoolVarName] if (Object.getOwnPropertyNames(school).includes("CountyName")) { var county = `(${school['CountyName']} County)` } else if (i == 2) { // i.e., it's the CPS dataset var county = "(Chicago Public Schools)" } else { var county = "" } // Use both school name and county, since school name alone is not a unique identifier var id = `${schoolName} ${county}` var attributes = new Map() attributes.set('School', schoolName) for (var [property, val] of Object.entries(school)) { if (property != schoolVarName) { attributes.set(property, val) } } if (Array.from(mergedData.keys()).includes(id)) { var initialAttributes = mergedData.get(id) mergedData.set(id, new Map([...initialAttributes, ...attributes])) } else { mergedData.set(id, attributes) } } } return mergedData }4c:T4c2,function renderSchoolProperties(school) { const propertiesToExclude = ["School", "CountyName", "Latitude", "Longitude", "ReportDate", "Address", "City", "reportDate"] const outerContainer = html`

${style()}

${schoolName}

` container.appendChild(schoolText) // Assume CPS naming convention for schools with uppercase is consistent var countyName = schoolProperties.get('CountyName') if (schoolName != schoolName.toUpperCase() && countyName == "") { // no county name since this is IDPH data that's missing a county, potentially a charter school with multiple locations } else { if (schoolName == schoolName.toUpperCase() && countyName == undefined) { var countyName = "Chicago Public Schools" } else if (schoolName != schoolName.toUpperCase() && countyName == "") { var countyName = schoolProperties.get('CountyName') + " County" } const countyText = html`

${countyName}` container.appendChild(countyText) } }4e:T413,function renderSearchResults(arrayOfSchools) { // Similar function as above, but works with an array of school Objects instead of a string // Testing to work with the searchAllSchools result const propertiesToExclude = ["Latitude", "Longitude", "ReportDate", "Address", "City", "reportDate"] const outerContainer = html`

${style()}

` const updatedNames = new Map([ ["School", ""], ["CaseCountDefinition", "Potential exposures"], ["CaseCount", "Outbreak status"], ["CaseCategory", "Cases among"], ["CaseSource", "Source"], ["CountyName", "County"], ["SchoolCategory", "School type"], ["Confirmed Cases", "Confirmed cases"], ["Close Contacts Identified", "Close contacts identified"] ]) let topSearchResult = arrayOfSchools[0] let properties = mergedIDPHData.get() properties.forEach((val, key) => { if (propertiesToExclude.includes(key)) { // skip } else { renderProperty(updatedNames.get(key), val, outerContainer) } }) return outerContainer }4f:[] 43:{"id":"7b4a4a13d03f3bbf","slug":null,"title":"WBEZ Prod: COVID-19 Cases By School","thumbnail":"b05f2881cd98d6a6c1f1838b923864e1cda2c0e7cb7433effcae907cf4021a6f","access_level":"public","create_time":"$D2022-01-07T18:47:34.062Z","update_time":"$D2022-03-15T14:56:24.701Z","view_time":null,"first_public_time":"$D2022-11-30T18:42:18.839Z","has_unpublished_edits":null,"fork":true,"stars":5,"starred":false,"owner":{"type":"team","id":"451a0400736e977f","login":"charmainerunes","name":"Charmaine Runes","avatar_url":"https://avatars-next.observableusercontent.com/9069f31bf56352d79ae388ec3b816e456cd89dd50070abd328688221122c5ac8","tier":"starter_2024","bio":"data | design | journalism","following":false},"version":2256,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"0ec3ddf39719bc08","login":"charmainerunes","name":"Charmaine Runes","avatar_url":"https://avatars-next.observableusercontent.com/9069f31bf56352d79ae388ec3b816e456cd89dd50070abd328688221122c5ac8","tier":null,"bio":"data | design | journalism","following":false}],"members":[{"type":"individual","id":"0ec3ddf39719bc08","login":"charmainerunes","name":"Charmaine Runes","avatar_url":"https://avatars-next.observableusercontent.com/9069f31bf56352d79ae388ec3b816e456cd89dd50070abd328688221122c5ac8","tier":null,"role":"editor"},{"type":"individual","id":"8b80db70f6cc1f93","login":"mattkiefer","name":"matt kiefer","avatar_url":"https://avatars-next.observableusercontent.com/9e3243fe5215c8659233a47e5142477a02dc0f4791e10e529c76e2766e62c248","tier":null,"role":"viewer"}],"comments":[{"id":"96d40d5f71f68faf","reply_to_id":null,"content":"Need to iterate through this list, get the date using Object.getOwnPropertyNames() and value","create_time":"$D2022-01-07T19:56:11.574Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"0ec3ddf39719bc08","login":"charmainerunes","name":"Charmaine Runes","avatar_url":"https://avatars-next.observableusercontent.com/9069f31bf56352d79ae388ec3b816e456cd89dd50070abd328688221122c5ac8","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"WBEZ Prod: COVID-19 Cases By School","cells":[{"id":983,"value":"# WBEZ Prod: COVID-19 Cases By School\nThis notebook cleans up the original version, accessing CPS data from our S3 bucket instead of from a spreadsheet we generated using a Colab notebook. It also adds the time series embed. \n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1782,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1742,"value":"## Time Series","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1895,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1946,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1768,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1468,"value":"time_series_url = 'https://api-static.wbez.org/v1/covid-in-schools/cps_daily_covid.json'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1470,"value":"casesBySchool = d3.json(time_series_url)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1541,"value":"schoolNames = casesBySchool.map(obj => obj['School']).sort();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1753,"value":"### Helpers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2056,"value":"function validate() {\n const input = document.getElementById('searchTerm');\n if (!schoolNames.includes(input.value)) {\n input.setCustomValidity('\"' + input.value + '\" is not in our list of Chicago public schools.');\n } else { \n input.setCustomValidity('');\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2011,"value":"totalCasesToDate = d3.format(',')(findSchoolData(selectedSchool)['Reported Cases'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1900,"value":"chatter = new Object({\n \"hed\": \"Daily COVID-19 case counts in Chicago public schools\",\n \"subhed\": \"Search for a school to see COVID-19 case counts over time\",\n \"src\": \"Chicago Public Schools\",\n \"note\": \"Reporting lags may result in under-counts for recent dates.\",\n \"credit\": \"Charmaine Runes/WBEZ\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1573,"value":"viewof selectedSchool = Inputs.select(schoolNames, {sort: true, value: \"CPS\"})\n\n//Inputs.text({name: 'searchTerm', datalist: schoolNames, placeholder:\"Enter school name\", value: \"CPS\", autocomplete: true, submit: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1954,"value":"selectedSchool","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1473,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1786,"value":"singleAnnotations = [\n {date: \"2022-03-15\", text: \"Masks optional →\"}\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1789,"value":"rangeAnnotations = [\n {startDate: \"2021-11-24\", endDate: \"2021-11-28\", text: \"Thanksgiving\"},\n {startDate: \"2021-12-18\", endDate: \"2022-01-02\", text: \"Winter break\"},\n {startDate: \"2022-01-05\", endDate: \"2022-01-11\", text: \"CPS shutdown\"}\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1587,"value":"height = 250;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1589,"value":"width = 800;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1512,"value":"function restructureDateData(dateObject) {\n var newDateObject = {}\n let dateVal = Object.getOwnPropertyNames(dateObject)[0]\n \n newDateObject['date'] = String(dateVal).slice(0, 10);\n newDateObject['cases'] = dateObject[dateVal];\n \n return newDateObject;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1523,"value":"function reproduceDateSeries(data) {\n let workingData = []\n data.forEach(item => workingData.push(restructureDateData(item)))\n\n return workingData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1595,"value":"function findSchoolData(schoolName) {\n return casesBySchool.filter(item => item.School == schoolName)[0]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1907,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1464,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1718,"value":"# Dates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1725,"value":"## Values","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":939,"value":"cpsDataLastUpdated = formatDate(new Date()) // automatically today","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1326,"value":"cpsDataLastAccessed = formatDate(lastUpdated)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1281,"value":"outbreaksDataRange = getDataRange(schoolOutbreaksDate, 30)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1300,"value":"exposuresDataRange = getDataRange(schoolPotentialExposuresDate, 30)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1730,"value":"## Helpers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1681,"value":"function formatDate(date) {\n \n const year = String(date.getFullYear())\n const month = convertMonth[date.getMonth() + 1] // apparently in JavaScript, months are from 0-11\n const day = String(date.getDate())\n \n return month.concat(' ', day, ', ', year)\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1692,"value":"sampleDateSeries = cpsCasesData[0][\"Date Series\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1659,"value":"lastUpdated = new Date(Object.keys(sampleDateSeries[sampleDateSeries.length - 1])[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":947,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1736,"value":"# Embeds","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":815,"value":"viewof lookupCPS = {\n\n const outerContainer = html`

${style()}

`\n const hed = html`

${cpsHed}

`\n const subhed = html`

${subhedText}

`\n\n outerContainer.appendChild(hed)\n outerContainer.appendChild(subhed)\n \n return outerContainer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"viewof searchCPS = Inputs.search(cpsCasesData, \n {columns: ['School', 'Reported Cases'],\n placeholder: \"e.g., Lane Tech\", \n layout: 'auto'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"viewof cpsCases = Inputs.table(searchCPS, {sort: \"Reported Cases\", reverse: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":849,"value":"viewof cpsSourceNotes = {\n\n const sourceNotesContainer = html`

${style()}

`\n \n const sourceText = html`

Source: ${cpsSourceLang}

`\n const notesText = html`

Notes: ${cpsNotesLang}

`\n const creditText = html`

Visualization: ${vizCreditLang}

`\n\n sourceNotesContainer.appendChild(sourceText)\n sourceNotesContainer.appendChild(notesText)\n sourceNotesContainer.appendChild(creditText)\n\n return sourceNotesContainer\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1060,"value":"button(cpsCasesData, 'cps-covid-cases.csv')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":925,"value":"viewof lookupPotentialExposures = {\n\n const outerContainer = html`

${style()}

`\n const hed = html`

${exposuresHed}

`\n const subhed = html`

${subhedText}

`\n\n outerContainer.appendChild(hed)\n //outerContainer.appendChild(subhed)\n \n return outerContainer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"viewof searchExposures = Inputs.search(potentialExposuresDataClean,\n {placeholder: \"Search by school name\", layout: 'auto'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"viewof exposures = Inputs.table(searchExposures, \n {columns: ['School Name', 'Case Count Definition', 'County Name'], \n sort: 'School Name',\n width: '100%'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":928,"value":"viewof exposuresSourceNotes = {\n\n const sourceNotesContainer = html`

${style()}

`\n \n const sourceText = html`

Source: ${idphSourceLang}

`\n const notesText = html`

Notes: ${exposuresNotesLang}

`\n const creditText = html`

Visualization: ${vizCreditLang}

`\n\n sourceNotesContainer.appendChild(sourceText)\n sourceNotesContainer.appendChild(notesText)\n sourceNotesContainer.appendChild(creditText)\n\n return sourceNotesContainer\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1064,"value":"button(schoolPotentialExposuresData, 'idph-potential-exposures.json')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":919,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":863,"value":"viewof lookupOutbreaks = {\n\n const outerContainer = html`

${style()}

`\n const hed = html`

${outbreaksHed}

`\n const subhed = html`

${subhedText}

`\n\n outerContainer.appendChild(html`
`)\n outerContainer.appendChild(hed)\n //outerContainer.appendChild(subhed)\n \n return outerContainer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"viewof searchOutbreaks = Inputs.search(outbreaksDataClean, \n {placeholder: \"Search by school name\", \n layout: 'auto'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2171,"value":"viewof topThreeOutbreakResults = getTopResults(searchOutbreaks, outbreaksDataClean)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2170,"value":"function getTopResults(results, originalList) {\n\n let textContainer = html`

${style()}

`;\n \n if (results.length != originalList.length) {\n let topThree = results.slice(0,3);\n\n for (let result of topThree) {\n let currentSchool = result[\"School Site\"].trim();\n let text = html`

\n ${result[\"School Site\"].trim()}\n
\n ${result[\"City\"].trim()}, ${result[\"County Name\"]} County\n
\n Source: ${result[\"Case Source\"]}\n
\n Count: ${result[\"Case Count\"]}\n

\n `\n textContainer.appendChild(text)\n }\n \n } else {\n let text = html`

`\n textContainer.appendChild(text);\n }\n return textContainer;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"viewof outbreaks = Inputs.table(searchOutbreaks, \n {columns: [\"School Site\", \"Case Count\", \"Case Category\", \"Case Source\", \"City\", \"County Name\"],\n sort: 'School Site',\n width: '100%'}\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":891,"value":"viewof outbreaksSourceNotes = {\n\n const sourceNotesContainer = html`

${style()}

`\n \n const sourceText = html`

Source: ${idphSourceLang}

`\n const notesText = html`

Notes: ${outbreaksNotesLang}

`\n const creditText = html`

Visualization: ${vizCreditLang}

`\n\n sourceNotesContainer.appendChild(sourceText)\n sourceNotesContainer.appendChild(notesText)\n sourceNotesContainer.appendChild(creditText)\n sourceNotesContainer.appendChild(html`
`)\n\n return sourceNotesContainer\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1068,"value":"button(schoolOutbreaksData, 'idph-outbreaks.json')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":908,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":951,"value":"# Viz copy elements","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"cpsHed = `Look up reported cases in Chicago Public Schools, Aug. 29 to ${cpsDataLastUpdated}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":967,"value":"outbreaksHed = `Look up outbreaks in Illinois schools, ${outbreaksDataRange}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":969,"value":"exposuresHed = `Look up potential exposures in Illinois schools, ${exposuresDataRange}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":960,"value":"subhedText = `Search for a school by name, or click column headers to sort the data.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"idphSourceLang = `Illinois Department of Public Health data on school outbreaks and potential exposures.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1212,"value":"outbreaksNotesLang = `IDPH data were last updated ${outbreaksLastUpdated}. Outbreak information is reported once clusters of cases are confirmed to be linked by location and time (within 14 days). Some outbreaks are pending processing and evaluation and will be added as more complete information is available. The outbreak information is reported by local health departments to the Illinois Department of Public Health through an outbreak reporting system. Specific outbreaks included are those that have been identified by the local health department to have three or more COVID-19 cases who may have a shared exposure on school grounds and are from different households. Case counts for school-related outbreaks also include those associated with before and after school programs (e.g., school-sponsored sports). These outbreaks do not include secondary cases that may occur in a household member who has not been on school grounds.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1206,"value":"exposuresNotesLang = `IDPH data were last updated ${potentialExposuresLastUpdated}. Potential exposures data show the number of confirmed and probable cases who listed a school as a place visited, but that does not mean it is where they were infected. Only schools where names have been provided are included.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1029,"value":"vizCreditLang = `Charmaine Runes/WBEZ.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":832,"value":"cpsSourceLang = `Chicago Public Schools data on all reported cases within the latest 24-hour reporting period.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"cpsNotesLang = `WBEZ last accessed CPS data on ${cpsDataLastAccessed}. These data include cases that were recorded as a result of a test taken inside of a school and those self-reported outside of a school. They also include cases where an investigation has not yet started or is in progress. Previously, CPS reported cases of COVID-19 only when an investigation was closed.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":932,"value":"# Sandbox","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"md`### Search all schools`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"viewof searchSchools = Inputs.search(mergedIDPHDataForTable, {label: 'School', placeholder: 'e.g., Lane Tech', query: 'LANE TECH HS'})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"viewof searchResults = Inputs.table(searchSchools)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"viewof searchAllSchools = Inputs.text({\n label: 'School', \n placeholder: 'e.g., Lane Tech',\n datalist: Array.from(mergedIDPHData.keys()).sort()\n})\n\n//viewof searchAllSchools = Inputs.search(mergedIDPHDataForTable, {label: 'School', placeholder: 'e.g., Lane Tech'})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"viewof searchAllResults = Inputs.table(mergedIDPHDataForTable.filter(school => school.School == searchAllSchools))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":599,"value":"viewof autoSelectSchool = autoSelect({\n options: Array.from(mergedIDPHData.keys()).sort(),\n placeholder: \"e.g., Lane Tech\",\n value: \"\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"md`### Search outbreaks by county and age category`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"viewof beginDatePicked = Inputs.text({\n type: \"date\",\n label: html`From`,\n value: beginDate\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"viewof endDatePicked = Inputs.text({\n type: \"date\",\n label: html`To`,\n value: endDate\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"viewof ageFilters = Inputs.checkbox(d3.group(countyOutbreaksData.schoolAgeOutbreaks, d => d.AgeGroup), {label: \"Age categories\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"viewof searchCounties = Inputs.select(d3.group(ageFilters.flat(), d => d.CountyName), {multiple: true, label: \"Counties\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"viewof countyOutbreaks = Inputs.table(searchCounties.flat())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":503,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"potentialMatches = findCPS()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"schoolOutbreaksURL = 'https://idph.illinois.gov/DPHPublicInformation/api/COVID/GetSchoolOutbreaksTemp?filterCategory='","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"schoolPotentialExposuresURL = 'https://idph.illinois.gov/DPHPublicInformation/api/covidct/GetCOVIDSchoolExposures'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"countyOutbreaksURL = 'https://idph.illinois.gov/DPHPublicInformation/api/COVID/GetSchoolAgeOutbreaks'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"cpsCasesURL = 'https://api-static.wbez.org/v1/covid-in-schools/cps_daily_covid.json'\n \n//'https://docs.google.com/spreadsheets/d/e/2PACX-1vREIIFkRSHRwEtaZnAd79Id8WUR4hvnp7GfZ3navMPK4lhhaHSPLL3_jxZFyaPalEQXeAS-TDipxfZG/pub?gid=585428002&single=true&output=csv'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"schoolOutbreaksData = await d3.json(schoolOutbreaksURL)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1087,"value":"outbreaksDataClean = schoolOutbreaksData.cOVIDSchoolOutbreaks.map(school => renameKeys(cleanOutbreakFields, school))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"countyOutbreaksData = d3.json(countyOutbreaksURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"schoolPotentialExposuresData = d3.json(schoolPotentialExposuresURL)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1056,"value":"potentialExposuresDataClean = schoolPotentialExposuresData.schoolCases.map(school => renameKeys(cleanExposureFields, school))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"cpsCasesData = d3.json(cpsCasesURL)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"mergedIDPHData = mergeData([schoolPotentialExposuresData.schoolCases, schoolOutbreaksData.cOVIDSchoolOutbreaks, cpsCasesData])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":739,"value":"mergedIDPHData.get('LANE TECH HS (Chicago Public Schools)')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"mergedIDPHDataForTable = convertMapForTable(mergedIDPHData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":749,"value":"mergedIDPHDataForTable.filter(school => school.School == 'LANE TECH HS')[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"md`## Helpers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2118,"value":"function serialize (data) {\n let parser = new json2csv.Parser();\n let csv = parser.parse(data);\n return csv \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1210,"value":"outbreaksLastUpdated = `${convertMonth[schoolOutbreaksDate.month]} ${schoolOutbreaksDate.day}` //, ${schoolOutbreaksDate.year}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1202,"value":"potentialExposuresLastUpdated = `${convertMonth[schoolPotentialExposuresDate.month]} ${schoolPotentialExposuresDate.day}` //, ${schoolPotentialExposuresDate.year}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1247,"value":"function getDataRange(updatedAsOf, difference) {\n\n const lastUpdated = ''.concat(updatedAsOf.year + '/' + updatedAsOf.month + '/' + updatedAsOf.day)\n\n const date = new Date();\n date.setDate(date.getDate(updatedAsOf) - difference);\n\n const dateString = date.toLocaleDateString(); // month/day/year\n const dateObj = new Object({\"year\": '', \"month\": '', \"day\": ''})\n \n dateObj.year = dateString.split(\"/\")[2]\n dateObj.month = dateString.split(\"/\")[0]\n dateObj.day = dateString.split(\"/\")[1]\n\n const dateFormatted = `${convertMonth[dateObj.month]} ${dateObj.day}` //, ${dateObj.year}`\n\n return `${dateFormatted} to ${outbreaksLastUpdated}`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1191,"value":"convertMonth = new Object({\n 1: 'Jan.',\n 2: 'Feb.',\n 3: 'Mar.',\n 4: 'Apr.',\n 5: 'May',\n 6: 'June',\n 7: 'July',\n 8: 'Aug.',\n 9: 'Sept.',\n 10: 'Oct.',\n 11: 'Nov.',\n 12: 'Dec.'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"lastUpdatedIDPH = schoolOutbreaksData['lastUpdatedDate']","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"wbezColors = new Map([\n ['red', '#ed0000'],\n ['white', '#ffffff'],\n ['black', '#000000'],\n ['mediumgray', '#636466'],\n ['lightgray', '#dcddde'],\n ['gold', '#ffd03d'],\n ['teal', '#24bcb7'],\n ['periwinkle', '#5151bd'],\n ['lightblue', '#1d9cd3'],\n ['cottoncandy', '#ffd7ff'],\n ['lime', '#adf45b'],\n ['lavender', '#99a8ff'],\n ['sky', '#88f7ff'],\n ['marigold', '#f79e1c'],\n ['peacock', '#016480'],\n ['royalpurple', '#5f2b7b'],\n ['royalblue', '#263c80'],\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"beginDate = \"2020-03-01\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"endDate = d3.utcFormat(\"%Y-%m-%d\")(new Date())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"schoolOutbreaksDate = schoolOutbreaksData.lastUpdatedDate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"countyOutbreaksDate = countyOutbreaksData.lastUpdatedDate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"schoolPotentialExposuresDate = schoolPotentialExposuresData.LastUpdatedDate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"function checkIfInDateRange(begin, end, reportDate) {\n var range = Date.parse(end) - Date.parse(begin)\n return null\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"schoolVarNames = [\"School\", \"SchoolName\", \"SchoolSite\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"function cleanTitleCaseString(string) {\n // splits and rejoins a string based on uppercase characters\n // e.g. \"ThisIsALongString\" -> \"This Is A Long String\"\n \n return string.match(/([A-Z]?[^A-Z]*)/g).slice(0,-1).join(\" \")\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1148,"value":"// Need to abstract using cleanTitleString() and loop through / map keys\ncleanOutbreakFields = new Object({\n 'Address': 'Address',\n 'City': 'City',\n 'SchoolSite': 'School Site',\n 'CaseCategory': 'Case Category',\n 'CaseSource': 'Case Source',\n 'SchoolCategory': 'School Category', \n 'CountyName': 'County Name', \n 'CaseCount': 'Case Count', \n 'reportDate': 'report Date', \n 'dateReported': 'date Reported'\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1174,"value":"cleanExposureFields = new Object({\n 'SchoolName': 'School Name',\n 'CountyName': 'County Name',\n 'CaseCountDefinition': 'Case Count Definition',\n 'Longitude': 'Longitude',\n 'Latitude': 'Latitude',\n 'ReportDate': 'Report Date'\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1001,"value":"function renameKeys(keysMap, obj) {\n return Object.keys(obj).reduce(\n (acc, key) => ({\n ...acc,\n ...{ [keysMap[key] || key]: obj[key] }\n }),\n {}\n )\n};","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"function findCorrectSchoolVar(properties) {\n // Assumes that there is only one correct school variable name\n for (const [index, name] of schoolVarNames.entries()) {\n if (properties.includes(name)) {\n return schoolVarNames[index]\n }\n }\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"$4b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"function convertMapForTable(mapOfSchools) {\n return Array.from(mapOfSchools.values()).map(school => Object.fromEntries(school))\n} ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"function renderProperty(key, val, outerContainer) {\n const container = html`

${style()}

`\n \n const keyText = html`

${key}

`\n const valText = html`

${val}

`\n\n container.appendChild(keyText)\n container.appendChild(valText)\n \n outerContainer.appendChild(container)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"md`## Parking Lot`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":726,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":350,"value":"import {style} from \"@charmainerunes/wbez-data-visuals-style-guide\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":597,"value":"import {autoSelect} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1039,"value":"import {button} from \"@jeremiak/download-data-button\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1046,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2116,"value":"json2csv = require(\"json2csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4f","stdlib":"1"}} 44:"$43:body"