3c:null 3d:["$","title",null,{"children":"Visualising Rental Units Data Per State | Benedicta Gokah | Observable"}] 43:T43f,// Function to get rent data for the selected state function getRentData(selectedState) { const less500 = occupiedUnitsPayingRentless500CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const between500and999 = occupiedUnitsPayingRent500to999CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const between1000and1500 = occupiedUnitsPayingRent1000to1500CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const between2000and2500 = occupiedUnitsPayingRent1500to2000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const between2500and3000 = occupiedUnitsPayingRent2000to2500CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const between3000and3500 = occupiedUnitsPayingRent2500to3000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const above3000 = occupiedUnitsPayingRentAbove3500CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; return {less500, between500and999,between1000and1500,between2000and2500, between2500and3000, between3000and3500, above3000 }; }44:Tac1,// Cell 4: Chart creation function createChart = () => { const width = 1500; const height = 610; const mapWidth = 975; // Standard width for US Albers projection const legendWidth = 200; // Width for the legend const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]); const path = d3.geoPath(); const states = topojson.feature(us, us.objects.states); svg.append("g") .selectAll("path") .data(states.features) .join("path") .attr("fill", d => { const stateData = medianRentPerState.find(r => r.fipsCode === +d.id); return stateData ? color(stateData.medianRent) : "#ccc"; }) .attr("d", path) .attr("stroke", d => { const stateData = medianRentPerState.find(r => r.fipsCode === +d.id); return stateData && stateData.state === mutable selectedState ? "red" : "white"; }) .attr("stroke-width", d => { const stateData = medianRentPerState.find(r => r.fipsCode === +d.id); return stateData && stateData.state === mutable selectedState ? 2 : 0.5; }) .on("click", (event, d) => { const stateData = medianRentPerState.find(r => r.fipsCode === +d.id); if (stateData) { mutable selectedState = stateData.state; svg.dispatch("input"); } }) .append("title") .text(d => { const stateData = medianRentPerState.find(r => r.fipsCode === +d.id); return `${d.properties.name}: ${stateData ? formatCurrency(stateData.medianRent) : 'No data'}`; }); // Add color scale legend const legendX = mapWidth + 50; // Position legend to the right of the map const legendY = 100; const legendHeight = height - 200; const [minRent, maxRent] = d3.extent(medianRentPerState, d => d.medianRent); const legendScale = d3.scaleLinear() .domain([minRent, maxRent]) // Reverse the domain .range([0, legendHeight]); const legendAxis = d3.axisRight(legendScale) .tickSize(13) .tickFormat(d => formatCurrency(d)); const legend = svg.append("g") .attr("transform", `translate(${legendX},${legendY})`); const colorRange = color.range(); const stepHeight = legendHeight / colorRange.length; legend.selectAll("rect") .data(colorRange) .join("rect") .attr("width", 30) .attr("y", (d, i) => i * stepHeight) .attr("height", stepHeight) .attr("fill", d => d); legend.append("g") .call(legendAxis) .attr("transform", `translate(30,0)`) .select(".domain") .remove(); // Add legend title legend.append("text") .attr("x", 15) .attr("y", -10) .attr("text-anchor", "middle") .attr("font-weight", "bold") .text("Median Rent"); return svg.node(); }45:T505,function getHouseValue(selectedState) { const housingValueLess50000 = housingValueLess50000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue50000To99999 = housingValue50000To99999CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue100000To150000 = housingValue100000To150000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue150000To200000 = housingValue150000To200000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue200000To2500000 = housingValue200000To2500000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue300000To500000 = housingValue300000To500000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValue500000To999999 = housingValue500000To999999CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; const housingValueAbove1000000 = housingValueAbove1000000CLEAN.find(d => d.state === selectedState)?.rentless500 || "N/A"; return {housingValueLess50000, housingValue50000To99999,housingValue100000To150000,housingValue150000To200000, housingValue200000To2500000, housingValue300000To500000, housingValue500000To999999,housingValueAbove1000000 }; }46:T540,function calculateHomeownershipRate(housingData) { let totalOccupied = 0; let ownerOccupied = 0; // Skip the header row (index 0) for (let i = 1; i < housingData.length; i++) { const totalUnits = parseFloat(housingData[i][1]); // B25136_001E: Total housing units const vacantUnits = parseFloat(housingData[i][7]); // B25136_008E: Total vacant units const ownerUnits = parseFloat(housingData[i][2]); // B25136_002E: Owner occupied // Check if any of the values are NaN if (isNaN(totalUnits) || isNaN(vacantUnits) || isNaN(ownerUnits)) { console.warn(`Skipping row ${i} due to NaN values:`, housingData[i]); continue; // Skip this iteration and move to the next row } const occupiedUnits = totalUnits - vacantUnits; // Additional check to ensure we don't add negative values if (occupiedUnits > 0) totalOccupied += occupiedUnits; if (ownerUnits > 0) ownerOccupied += ownerUnits; } // Check if we have valid data to calculate the rate if (totalOccupied === 0) { console.error("Total occupied units is zero. Cannot calculate homeownership rate."); return { error: "Insufficient data" }; } const homeownershipRate = (ownerOccupied / totalOccupied) * 100; return { totalOccupied, ownerOccupied, homeownershipRate: homeownershipRate.toFixed(2) }; }47:[] 41:{"id":"a04970853c2c395b","slug":null,"title":"Visualising Rental Units Data Per State","thumbnail":"88a46acf24237af3e9d6a6385f1f8e8d955632029ccbd5cff216c5a44432b109","access_level":"public","create_time":"$D2024-09-24T19:46:47.776Z","update_time":"$D2024-10-07T14:41:43.647Z","view_time":null,"first_public_time":"$D2024-09-25T14:21:20.383Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"2722a31cbb5fad50","login":"benedicta-gokah","name":"Benedicta Gokah","avatar_url":"https://avatars-next.observableusercontent.com/d8db78ddfcfe2ff02f1b753d574017dcb8397749b707a40a604a75bef3c9c272","tier":"pro_2024","bio":""},"version":821,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"bce0b2f8a6893db7","login":"benedicta-gokah","name":"Benedicta Gokah","avatar_url":"https://avatars-next.observableusercontent.com/030081bf976d55accfd0f324d43eee3e61e6f728c0d6a6572bf1f63c23caa22b","tier":null,"bio":""}],"members":[{"type":"team","id":"2722a31cbb5fad50","login":"benedicta-gokah","name":"Benedicta Gokah","avatar_url":"https://avatars-next.observableusercontent.com/d8db78ddfcfe2ff02f1b753d574017dcb8397749b707a40a604a75bef3c9c272","tier":"pro_2024","role":"editor"},{"type":"individual","id":"bce0b2f8a6893db7","login":"benedicta-gokah","name":"Benedicta Gokah","avatar_url":"https://avatars-next.observableusercontent.com/030081bf976d55accfd0f324d43eee3e61e6f728c0d6a6572bf1f63c23caa22b","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Visualising Rental Units Data Per State","cells":[{"id":58,"value":"# Visualising Rental Units Data Per State","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"The Rental Housing Finance Survey from the [ACS](https://www.census.gov/programs-surveys/acs) provides a current and continuous measure of financial, mortgage, and property characteristics of rental housing properties in the United States. \n\nThe survey focuses on the financing of rental housing properties, with emphasis on new mortgages, refinanced mortgages, or similar devices such as deeds of trust or land contracts, and the characteristics of debt originations.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":87,"value":"---\n### Select a state either through the drop down or from the map to know what the comparative median rent for each state is.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":145,"value":"//viewof selectedState = Inputs.select(\n// RentByState3,\n// {\n// label: \"Select a state\",\n// sort: true,\n // unique: true,\n //value: \"Illinois\"\n //}\n//)\n// Cell 2: Create a viewof binding for the selected state\nviewof stateDropdown = Inputs.select(\n medianRentPerState.map(d => d.state),\n {\n label: \"Select a state\",\n sort: true,\n value: mutable selectedState\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":446,"value":"{\n const stateData = medianRentPerState.find(state => state.state === selectedState);\n const medianRent = stateData ? stateData.medianRent : 0;\n const formattedRent = new Intl.NumberFormat('en-US', { style: 'currency', currency: 'USD' }).format(medianRent);\n \n return html`

${formattedRent}

median rent in ${selectedState}

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"{\n // Sort the array based on medianRent values\n const sortedStates = medianRentPerState.sort((a, b) => a.medianRent - b.medianRent);\n \n const middle = Math.floor(sortedStates.length / 2);\n \n let medianRent;\n if (sortedStates.length % 2 === 0) {\n // If even number of states, average the two middle values\n medianRent = (sortedStates[middle - 1].medianRent + sortedStates[middle].medianRent) / 2;\n } else {\n // If odd number of states, use the middle value\n medianRent = sortedStates[middle].medianRent;\n }\n \n // Format the median rent as currency\n const formattedRent = new Intl.NumberFormat('en-US', { \n style: 'currency', \n currency: 'USD',\n minimumFractionDigits: 2,\n maximumFractionDigits: 2\n }).format(medianRent);\n \n return html`\n

${formattedRent}

median rent in the United States

\n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":749,"value":"// Cell 5: Render the chart\nchart = {\n const svg = createChart();\n d3.select(svg).selectAll(\"path\")\n .attr(\"stroke\", d => {\n const stateData = medianRentPerState.find(r => r.fipsCode === +d.id);\n return stateData && stateData.state === mutable selectedState ? \"red\" : \"white\";\n })\n .attr(\"stroke-width\", d => {\n const stateData = medianRentPerState.find(r => r.fipsCode === +d.id);\n return stateData && stateData.state === mutable selectedState ? 2 : 0.5;\n });\n return svg;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"// Create the bar chart\nrentDataChart = Plot.plot({\n title: `Rent Distribution for ${selectedState}`,\n width: 800,\n height: 500,\n marginBottom: 100,\n marginTop: 30,\n marginLeft: 55,\n x: {\n label: \"Rent Category\",\n tickRotate: -45\n },\n y: {\n label: \"Number of Units\",\n grid: true\n },\n marks: [\n Plot.barY(Object.entries(rentData).map(([key, value]) => ({\n category: formatCategory1(key),\n value: typeof value === \"number\" ? value : 0\n })), {\n x: \"category\",\n y: \"value\",\n fill: \"steelblue\",\n title: d => `${d.category}: ${d.value.toLocaleString()}`\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"---\n# APPENDIX","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":489,"value":"## Home Ownership Rate","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":626,"value":"// Function to calculate percentages\nfunction calculatePercentages(data) {\n const validValues = Object.values(data).filter(value => value !== \"N/A\" && !isNaN(value));\n const total = validValues.reduce((sum, value) => sum + Number(value), 0);\n \n return Object.entries(data).map(([key, value]) => ({\n category: formatCategory(key),\n value: value !== \"N/A\" && !isNaN(value) ? Number(value) : 0,\n percentage: value !== \"N/A\" && !isNaN(value) ? (Number(value) / total) * 100 : 0\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"// Function to format category names\nfunction formatCategory(key) {\n return key.replace('housingValue', '')\n .replace(/([A-Z])/g, ' $1')\n .trim()\n .replace(/To/g, ' - ')\n .replace(/Less/g, 'Less than')\n .replace(/Above/g, 'More than');\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":607,"value":"\n\n// Create the housing value chart\n//housingValueChart = Plot.plot({\n // title: `Housing Value Distribution`,\n //width: 800,\n //height: 500,\n //marginBottom: 100,\n //marginTop: 30,\n //marginLeft: 55,\n //x: {\n // label: \"Housing Value Category\",\n // tickRotate: -45\n // },\n // y: {\n // label: \"Percentage of Houses\",\n // grid: true,\n // tickFormat: d => d.toFixed(1) + \"%\"\n// },\n// marks: [\n // Plot.barY(calculatePercentages(houseValueData), {\n // x: \"category\",\n // y: \"percentage\",\n // fill: \"steelblue\",\n // sort: {x: \"y\", reverse: true},\n // title: d => `${d.category}: ${d.value.toLocaleString()} (${d.percentage.toFixed(2)}%)`\n // }),\n // Plot.ruleY([0])\n // ]\n//})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"# FUNCTIONS CORNER","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"### Cleaning up data into JSON format","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":0,"value":"censusData = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,C25068_001E&for=county:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"RentByCounty = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < censusData.length; i++) {\n const state = censusData[i];\n statesData.push({\n countyName: state[0],\n roomsForRent: parseInt(state[1]),\n fipsCode: parseInt(state[2]),\n countyCode: parseInt(state[3])\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"RentByState = {\n const stateData = {};\n \n for (let i = 0; i < RentByCounty.length; i++) {\n const county = RentByCounty[i];\n const stateName = county.countyName.split(', ')[1];\n \n if (!stateData[stateName]) { \n stateData[stateName] = { \n State: stateName,\n totalRooms: 0, // setting the number of rooms per state to 0\n countyCount: 0 // number of counties per state in the data\n };\n }\n \n stateData[stateName].totalRooms += parseInt(county.roomsForRent); //NOT WORKING !!!\n stateData[stateName].countyCount++;\n }\n \n //return stateData;\n return Object.values(stateData);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"RentByState2 = (() => {\n const stateData = {};\n \n for (let i = 0; i < RentByCounty.length; i++) {\n const county = RentByCounty[i];\n const stateName = county.countyName.split(', ')[1];\n \n if (!stateData[stateName]) { \n stateData[stateName] = { \n State: stateName,\n totalRooms: 0,\n countyCount: 0\n };\n }\n \n // Parse roomsForRent and handle potential invalid inputs\n const roomsForRent = parseInt(county.roomsForRent);\n if (!isNaN(roomsForRent)) {\n stateData[stateName].totalRooms += roomsForRent;\n stateData[stateName].countyCount++;\n } else {\n console.warn(`Invalid roomsForRent value for ${county.countyName}: ${county.roomsForRent}`);\n }\n }\n \n return Object.values(stateData);\n})();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"### fetching from Census API","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":296,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"// Cell 6: Get and display rent data for the selected state\nrentData = getRentData(selectedState)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"houseValueData = getHouseValue(selectedState)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"rentData","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":676,"value":"# Building the choropleth ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":744,"value":"// Cell 3: Update mutable selectedState when dropdown changes\n{\n stateDropdown;\n mutable selectedState = stateDropdown;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":736,"value":"// Cell 1: Create a mutable state for selection\nmutable selectedState = \"Illinois\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"us = await d3.json(\"https://cdn.jsdelivr.net/npm/us-atlas@3/states-albers-10m.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":699,"value":"// Cell 2: Rent data (assuming RentByState3 is your data source)\nmedianRentPerStateGraph = RentByState3","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"// Cell 3: Color scale\ncolor = d3.scaleQuantize()\n .domain(d3.extent(medianRentPerState, d => d.medianRent))\n .range(d3.schemeBlues[9])\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":706,"value":"// Cell 4: Currency formatter\nformatCurrency = d3.format(\"$,.0f\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"$44","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"# PART 1: CENSUS DATA CLEAN UP","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"medianRentPerState = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < MedianRentPerState.length; i++) {\n const state = MedianRentPerState[i];\n statesData.push({\n state: state[0],\n medianRent: parseInt(state[1]),\n fipsCode: parseInt(state[2])\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"MedianRentPerState = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25031_001E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"medianRent = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < MedianRentPerStateCounties.length; i++) {\n const state = MedianRentPerStateCounties[i];\n statesData.push({\n state: state[0],\n medianRent: parseInt(state[1]),\n fipsCode: parseInt(state[2])\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"// Function to format category labels\nfunction formatCategory1(key) {\n switch(key) {\n case \"less500\": return \"< $500\";\n case \"between500and999\": return \"$500-$999\";\n case \"between1000and1500\": return \"$1000-$1500\";\n case \"between2000and2500\": return \"$2000-$2500\";\n case \"between2500and3000\": return \"$2500-$3000\";\n case \"between3000and3500\": return \"$3000-$3500\";\n case \"above3000\": return \"> $3000\";\n default: return key;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":653,"value":"Object.values((await d3.json(\"https://api.census.gov/data/2016/acs/acs1/variables.json\")).variables).filter(d=>d.label.includes('Vac'))\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"occupiedUnitsPayingRentless500 = (await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_002E,B25061_003E,B25061_004E,B25061_005E,B25061_006E,B25061_007E,B25061_008E,B25061_009E,B25061_010E&for=state:*\"\n)).map(d=>\n ({state: d[0],\n rentless500: parseInt(d[1])+parseInt(d[2])+parseInt(d[3])+parseInt(d[4])+parseInt(d[5])+parseInt(d[6])+parseInt(d[7])+parseInt(d[7])+parseInt(d[8])+parseInt(d[9]),\n fipsCode: parseInt(d[10]),\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"occupiedUnitsPayingRentless500CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRentless500.length; i++) {\n const state = occupiedUnitsPayingRentless500[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8])+parseInt(state[9]),\n fipsCode: parseInt(state[10]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"MedianRentPerStateCounties = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25031_001E&for=county:*&in=state:17\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"RentByState3 = MedianRentPerState.map(state => state[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"occupiedUnitsPayingRent500to999 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_011E,B25061_012E,B25061_013E,B25061_014E,B25061_015E,B25061_016E,B25061_017E,B25061_018E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"occupiedUnitsPayingRent500to999CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent500to999.length; i++) {\n const state = occupiedUnitsPayingRent500to999[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"occupiedUnitsPayingRent1000to1500 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_019E,B25061_020E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"occupiedUnitsPayingRent1000to1500CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent1000to1500.length; i++) {\n const state = occupiedUnitsPayingRent1000to1500[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"occupiedUnitsPayingRent1500to2000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_021E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"occupiedUnitsPayingRent1500to2000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent1500to2000.length; i++) {\n const state = occupiedUnitsPayingRent1500to2000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1]),\n fipsCode: parseInt(state[3]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"occupiedUnitsPayingRent2000to2500 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_022E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"occupiedUnitsPayingRent2000to2500CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent2000to2500.length; i++) {\n const state = occupiedUnitsPayingRent2000to2500[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1]),\n fipsCode: parseInt(state[3]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"occupiedUnitsPayingRent2500to3000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_023E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"occupiedUnitsPayingRent2500to3000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent2500to3000.length; i++) {\n const state = occupiedUnitsPayingRent2500to3000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1]),\n fipsCode: parseInt(state[3]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"occupiedUnitsPayingRent3000to3500 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_024E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"occupiedUnitsPayingRent3000to3500CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRent3000to3500.length; i++) {\n const state = occupiedUnitsPayingRent3000to3500[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1]),\n fipsCode: parseInt(state[3]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"occupiedUnitsPayingRentAbove3500 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25061_025E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"occupiedUnitsPayingRentAbove3500CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < occupiedUnitsPayingRentAbove3500.length; i++) {\n const state = occupiedUnitsPayingRentAbove3500[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1]),\n fipsCode: parseInt(state[3]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":643,"value":"data2 = ({occupiedUnitsPayingRent1000to1500,occupiedUnitsPayingRent1500to2000})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"import {data2} from \"a04970853c2c395b\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":487,"value":"# PART 2: CENSUS DATA CLEAN UP","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":499,"value":"housingValueLess50000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_002E,B25085_003E,B25085_004E,B25085_005E,B25085_006E,B25085_007E,B25085_008E,B25085_009E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":569,"value":"housingValueLess50000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValueLess50000.length; i++) {\n const state = housingValueLess50000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":503,"value":"housingValue50000To99999 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_010E,B25085_011E,B25085_012E,B25085_013E,B25085_014E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"housingValue50000To99999CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue50000To99999.length; i++) {\n const state = housingValue50000To99999[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"housingValue100000To150000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_015E,B25085_016E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"housingValue100000To150000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue100000To150000.length; i++) {\n const state = housingValue100000To150000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"housingValue150000To200000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_017E,B25085_018E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":582,"value":"housingValue150000To200000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue150000To200000.length; i++) {\n const state = housingValue150000To200000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":512,"value":"housingValue200000To250000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_019E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"housingValue200000To2500000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue200000To250000.length; i++) {\n const state = housingValue200000To250000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"housingValue300000To500000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_021E,B25085_022E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"housingValue300000To500000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue300000To500000.length; i++) {\n const state = housingValue300000To500000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"housingValue500000To999999 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_023E,B25085_024E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":593,"value":"housingValue500000To999999CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValue500000To999999.length; i++) {\n const state = housingValue500000To999999[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"housingValueAbove1000000 = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25085_026E,B25085_027E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":598,"value":"housingValueAbove1000000CLEAN = {\n const statesData = [];\n\n //note we are starting at 1 to skip the first row!\n for (let i = 1; i < housingValueAbove1000000.length; i++) {\n const state = housingValueAbove1000000[i];\n statesData.push({\n state: state[0],\n rentless500: parseInt(state[1])+parseInt(state[2])+parseInt(state[3])+parseInt(state[4])+parseInt(state[5])+parseInt(state[6])+parseInt(state[7])+parseInt(state[7])+parseInt(state[8]),\n fipsCode: parseInt(state[9]),\n });\n }\n return statesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"TotalHousingUnits = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25136_001E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"TotalVacantUnits = await d3.json(\n \"https://api.census.gov/data/2023/acs/acs1?get=NAME,B25136_008E&for=state:*\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"// Function to calculate the national vacancy rate\nfunction calculateNationalVacancyRate(totalHousingUnits, totalVacantUnits) {\n let totalUnits = 0;\n let totalVacant = 0;\n\n // Skip the header row (index 0)\n for (let i = 1; i < totalHousingUnits.length; i++) {\n // Convert string values to numbers and add to totals\n totalUnits += +totalHousingUnits[i][1];\n totalVacant += +totalVacantUnits[i][1];\n }\n\n // Calculate the vacancy rate after the loop\n const vacancyRate = (totalVacant / totalUnits) * 100;\n\n return {\n totalUnits,\n totalVacant,\n vacancyRate: vacancyRate.toFixed(2)\n };\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"NationalVacancyResult = calculateNationalVacancyRate(TotalHousingUnits, TotalVacantUnits)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"result = calculateHomeownershipRate(TotalHousingUnits)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":558,"value":"if (result.error) {\n md`\n## Error in Homeownership Statistics Calculation\n\n${result.error}\n\nPlease check your data and ensure it contains valid numerical values.\n `\n} else {\n md`\n## National Homeownership Statistics\n\n- **Total Occupied Housing Units:** ${d3.format(\",\")(result.totalOccupied)}\n- **Owner-Occupied Housing Units:** ${d3.format(\",\")(result.ownerOccupied)}\n- **National Homeownership Rate:** ${result.homeownershipRate}%\n `\n}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":90,"value":"## Home Ownership Rates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":92,"value":"Home Ownership Rates","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":94,"value":"Home Ownership Rates in the United States","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"Housing Value","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":98,"value":"## Housing Units ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":100,"value":"Total Housing Units","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":102,"value":"Total Housing Units in the United States","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":104,"value":"Occupancy Characteristics","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":106,"value":"Owner-Renter Characteristics","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":108,"value":"## Physical Characteristics","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":110,"value":"Bedrooms in Occupied Housing Units","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":113,"value":"## Vacancy Rates ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":650,"value":"-----\n### Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 42:"$41:body"