2a:null 2b:["$","title",null,{"children":"Manhattan - Zipcode: Evictions and COVID Cases | Zhi Keng He | Observable"}] 31:Te1f,evi_chart = { const container = html`

`; const height = 400; const svg = d3 .select(container) .append("svg") .attr("viewBox", [0, 0, width, height]); const max = d3.max(Array.from(evi_data.values()).map((i) => i.per10k)); const scale = d3.scaleSequential(d3.interpolateReds).domain([0, max]); svg .append("g") .attr("transform", "translate(20,20)") .append(() => Legend(scale, { // title: `2021 Eviction filings per 1,000 rental units by zipcode`, title: `Eviction filings per 1k between ${evi_sliderDates[0].toLocaleDateString()} and ${evi_sliderDates[1].toLocaleDateString()} by zipcode`, ticks: 5, tickFormat: ".1f" }) ); const div = d3.select(container).append("div").classed("tooltip", true); const tooltip = new Tooltip(div); function tooltipContents(d) { const zip = d.properties.MODZCTA.toString(); const value = evi_data.get(zip); if (!value) return `

${zip}

${modzcta_lookup.get( zip )}

No filings during this date range.

`; const percent = d3.format(".2f")(value.per10k), filings = value.filings, unitsrental = d3.format(",")(value.unitsrental); return `

${zip}

${modzcta_lookup.get( zip )}

${percent} filings per 10,000 units or ${filings} filings among ${unitsrental} rental units.

`; } const projection = d3 .geoMercator() .rotate([0, -65, 0]) .fitExtent( [ [20, 20], [width, height] ], manhattan ); const path = d3.geoPath(projection); const g = svg.append("g"); const zips = g .selectAll(".p-base") .data(modzcta.features) .enter() .append("path") .classed("p-base", true) .attr("d", path) .attr("stroke", "white") .attr("stroke-width", 0.4) .attr("fill", (d) => { const zip = d.properties.MODZCTA.toString(); if (zip === "99999") return "#cccccc"; if (mn_zctas.includes(zip)) { //lookup values const value = evi_data.get(zip); return value ? scale(value.per10k) : "#ccc"; } return "#E9E9E9"; //default return }); const tooltip_zips = g .selectAll(".p-inter") .data( modzcta.features.filter((d) => mn_zctas.includes(d.properties.MODZCTA.toString()) ) ) .enter() .append("path") .classed("p-inter", true) .attr("d", path) .attr("fill", "rgba(0,0,0,0)") .attr("stroke", "black") .attr("stroke-width", 0) .on("mouseover", function (event, d) { tooltip.display(d, tooltipContents); d3.select(this).style("stroke", "black").style("stroke-width", 1.5); }) .on("mouseout", function () { tooltip.hide(); d3.select(this).style("stroke", "black").style("stroke-width", 0); }) .on("mousemove", (event) => { tooltip.move(event); }); g.append("path") .datum(marble_hill) .attr("fill", "none") .attr("stroke", "white") .attr("stroke-alignment", "outside") .attr("stroke-width", 1.4) .attr("d", path); return container; }32:Tccb,covid_chart = { const container = html`

`; const height = 400; const svg = d3 .select(container) .append("svg") .attr("viewBox", [0, 0, width, height]); svg .append("g") .attr("transform", "translate(20,20)") .append(() => Legend(covid_scale, { title: covid_options.date === "last7days" ? "COVID positivity percentage by zipcode" : "Cumulative total cases per 100k (confirmed)", ticks: 4, tickFormat: ".1f" }) ); const div = d3.select(container).append("div").classed("tooltip", true); const tooltip = new Tooltip(div); function tooltipContents(d) { const zip = d.properties.MODZCTA.toString(); const format = covid_options.date === "last7days" ? d3.format("") : d3.format(","); const number = format(covid_data.get(zip)); const text = covid_options.date === "last7days" ? `

${number}% of people with a molecular test tested positive

` : `

${number} cases per 100k people

`; return `

${zip}

${modzcta_lookup.get(zip)}

${text}`; } const projection = d3 .geoMercator() .rotate([0, -65, 0]) .fitExtent( [ [20, 20], [width, height] ], manhattan ); const path = d3.geoPath(projection); const g = svg.append("g"); const zips = g .selectAll(".p-base") .data(modzcta.features) .enter() .append("path") .classed("p-base", true) .attr("d", path) .attr("stroke", "white") .attr("stroke-width", 0.4) .attr("fill", (d) => { const zip = d.properties.MODZCTA.toString(); if (zip === "99999") return "#cccccc"; if (mn_zctas.includes(zip)) { //lookup values return covid_scale(+covid_data.get(zip)); } return "#E9E9E9"; //default return }); const tooltip_zips = g .selectAll(".p-inter") .data( modzcta.features.filter((d) => mn_zctas.includes(d.properties.MODZCTA.toString()) ) ) .enter() .append("path") .classed("p-inter", true) .attr("d", path) .attr("fill", "rgba(0,0,0,0)") .attr("stroke", "black") .attr("stroke-width", 0) .on("mouseover", function (event, d) { tooltip.display(d, tooltipContents); d3.select(this).style("stroke", "black").style("stroke-width", 1.5); }) .on("mouseout", function () { tooltip.hide(); d3.select(this).style("stroke", "black").style("stroke-width", 0); }) .on("mousemove", (event) => { tooltip.move(event); }); g.append("path") .datum(marble_hill) .attr("fill", "none") .attr("stroke", "white") .attr("stroke-alignment", "outside") .attr("stroke-width", 1.4) .attr("d", path); return container; }33:T4bb,marble_hill = { return { type: "Feature", properties: {}, geometry: { type: "LineString", coordinates: [ [-73.918367528576368, 40.875867239164897], [-73.917001510708317, 40.876850975913165], [-73.917541801357615, 40.8773402957465], [-73.916614132506908, 40.877890780558999], [-73.916073841857596, 40.877982528027744], [-73.91506461970134, 40.877997819272537], [-73.913963650076354, 40.878344420821144], [-73.913097146204819, 40.87887451730726], [-73.911078701892322, 40.880332282644062], [-73.91056899373261, 40.880424030112806], [-73.910252974673554, 40.879965292769057], [-73.909325305822861, 40.87922111885586], [-73.90806122958675, 40.878354614984332], [-73.907235502367996, 40.87751869360239], [-73.906797153350652, 40.876825490505162], [-73.906277251027731, 40.876509471446134], [-73.906146001176594, 40.874907713554258], [-73.90670540588188, 40.873400251671832], [-73.906618755494733, 40.87335437793746], [-73.907459773958294, 40.871407292767344], [-73.908734044357615, 40.871789573887142] ] } }; }34:T46a,evi_data = { const _unitsrental = await FileAttachment("filings_since_032320.csv").csv(); const _modzcta = await FileAttachment("ZCTA-to-MODZCTA.csv").csv(); const zcta_to_modzcta = new Map(_modzcta.map((i) => [i.ZCTA, i.MODZCTA])); const modzcta_unitsrental = d3.rollup( _unitsrental, (xs) => d3.sum(xs, (x) => +x.unitsrental), (d) => zcta_to_modzcta.get(d.zipcode) ); //filter for dates between const range_rows = ( await FileAttachment("filings_since_010121_dates.csv").csv() ).filter( (i) => new Date(i.fdate) >= evi_sliderDates[0] && new Date(i.fdate) <= evi_sliderDates[1] ); //rollup data by modzcta const range_rollup = d3 .rollups( range_rows, (xs) => d3.sum(xs, (x) => +x.filings_since_032320), (d) => zcta_to_modzcta.get(d.zipcode) ) .map(([k, v]) => { const unitsrental = modzcta_unitsrental.get(k); return { zipcode: k, filings: v, unitsrental, per10k: unitsrental > 0 ? (v / unitsrental) * 1000 : 0 }; }); return new Map(range_rollup.map((i) => [i.zipcode, { ...i }])); }35:[{"id":"0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","href":"https://static.observableusercontent.com/files/0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","name":"manhattan@3.geojson","type":"application/geo+json","lastModified":1641538753701.14,"size":26457},{"id":"495aae67b26f320e7733677260ca740d7ce1b7e89954eca4cbd722188ab164aa4ea1367033297b53b65ffffada51876049e62670dc3d3a356a3ee961fd953d59","href":"https://static.observableusercontent.com/files/495aae67b26f320e7733677260ca740d7ce1b7e89954eca4cbd722188ab164aa4ea1367033297b53b65ffffada51876049e62670dc3d3a356a3ee961fd953d59","name":"filings_since_010121_dates.csv","type":"text/csv","lastModified":1641546833912.164,"size":331497},{"id":"ed5f274702a6bb44dee6940a67e8db152cf6f9402ab7545c1e0c8c8c64a0d2ebc3505f97ec275dabbc2666c98c7d6cc880a435f332d65850a7a9144aa13812ed","href":"https://static.observableusercontent.com/files/ed5f274702a6bb44dee6940a67e8db152cf6f9402ab7545c1e0c8c8c64a0d2ebc3505f97ec275dabbc2666c98c7d6cc880a435f332d65850a7a9144aa13812ed","name":"filings_since_032320.csv","type":"text/csv","lastModified":1641546675043.728,"size":8288},{"id":"c234ed7733af42093723ff4c207161eeef8a74dedd2d799027d2c329a3d8ae6a67cb9b63d6132dd44cb1a492fcf81d3e3833c421eb064ae1f88a434e4a4005ce","href":"https://static.observableusercontent.com/files/c234ed7733af42093723ff4c207161eeef8a74dedd2d799027d2c329a3d8ae6a67cb9b63d6132dd44cb1a492fcf81d3e3833c421eb064ae1f88a434e4a4005ce","name":"ZCTA-to-MODZCTA.csv","type":"text/csv","lastModified":1641546675369.127,"size":3457}] 2e:{"id":"71e3198b25cc5a29","slug":"manhattan-zipcode-evictions-and-covid-cases","title":"Manhattan - Zipcode: Evictions and COVID Cases","thumbnail":"80f345a78942c23b3e37eeca8dde44ab6c64fa53d7f191e7923929e0f4dd4e15","access_level":"public","create_time":"$D2022-01-06T19:03:57.776Z","update_time":"$D2022-01-13T14:13:49.811Z","view_time":null,"first_public_time":"$D2022-01-07T07:36:58.475Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"16506c8d98fe0d4f","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":"starter_2024"},"version":897,"publish_version":897,"role":null,"authored":false,"authors":[{"type":"individual","id":"215e59083f0e53f8","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":null}],"members":[{"type":"individual","id":"215e59083f0e53f8","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Manhattan - Zipcode: Evictions and COVID Cases","cells":[{"id":0,"value":"# Manhattan - Zipcode: Evictions and COVID Cases","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"viewof evi_slider = rangeSlider({\n min: 0,\n max: d3.timeDay.count(evi_start, evi_end),\n step: 1,\n value: this\n ? this.value\n : [evi_scale(new Date(2021, 0, 1)), evi_scale(new Date(2021, 11, 31))],\n format: (d) => formatDate(d3.timeDay.offset(evi_start, d)),\n title: \"Eviction cases in 2021\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":854,"value":"

Data from NYS Office of Court Administration (OCA) via HDC, and and PLUTO19v2.
*Numbers of total units per zip code exclude single-unit properties to approximate the number of rental units.
\nHover for details.

","pinned":false,"hidden":false,"mode":"html"},{"id":800,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"viewof covid_options = form(html``)","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"## Appendix ","pinned":false,"hidden":false,"mode":"md"},{"id":877,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":120,"value":"#### Data imports: covid from [nychealth](https://github.com/nychealth/coronavirus-data/blob/master/totals/data-by-modzcta.csv?utm_source=pocket_mylist) and eviction court filings from [housing data coalition](https://github.com/housing-data-coalition/oca).","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"modzcta = topojson.feature(\n MODZCTA_2010_WGS1984,\n MODZCTA_2010_WGS1984.objects.collection\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"manhattan = await (await FileAttachment(\"manhattan@3.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":314,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"mn_zctas = [\n \"10001\",\n \"10002\",\n \"10003\",\n \"10004\",\n \"10005\",\n \"10006\",\n \"10007\",\n \"10009\",\n \"10010\",\n \"10011\",\n \"10012\",\n \"10013\",\n \"10014\",\n \"10016\",\n \"10017\",\n \"10018\",\n \"10019\",\n \"10021\",\n \"10022\",\n \"10023\",\n \"10024\",\n \"10025\",\n \"10026\",\n \"10027\",\n \"10028\",\n \"10029\",\n \"10030\",\n \"10031\",\n \"10032\",\n \"10033\",\n \"10034\",\n \"10035\",\n \"10036\",\n \"10037\",\n \"10038\",\n \"10039\",\n \"10040\",\n \"10044\",\n \"10065\",\n \"10069\",\n \"10075\",\n \"10128\",\n \"10280\",\n \"10282\",\n \"10463\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":228,"value":"MODZCTA_2010_WGS1984 = await (\n await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/Geography-resources/MODZCTA_2010_WGS1984.topo.json\"\n )\n).json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"covid_last7days = {\n const file = await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/latest/last7days-by-modzcta.csv\"\n );\n\n return d3.csvParse(await file.text());\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":217,"value":"covid_totalsince = {\n const file = await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/totals/data-by-modzcta.csv\"\n );\n\n return (await d3.csvParse(await file.text())).map((d) => {\n d.modzcta = d.MODIFIED_ZCTA;\n return d;\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":475,"value":"covid_data = {\n if (covid_options.date === \"last7days\") {\n return new Map(\n covid_last7days.map((i) => [i.modzcta, +i.percentpositivity_7day])\n );\n }\n\n if (covid_options.date === \"totalsince\") {\n return new Map(\n covid_totalsince.map((i) => [i.modzcta, +i.COVID_CASE_RATE])\n );\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":494,"value":"modzcta_lookup = new Map(\n covid_last7days.map((i) => [i.modzcta, i.modzcta_name])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":519,"value":"covid_scale = d3\n .scaleSequentialQuantile(d3.interpolateReds)\n .domain(Array.from(covid_data.values()))","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"#### Slider code adapted from [azureuse](https://observablehq.com/@azureuse/slider-time)","pinned":false,"hidden":false,"mode":"md"},{"id":36,"value":"evi_sliderDates = evi_slider.map((d) => d3.timeDay.offset(evi_start, d))","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"evi_scale = d3\n .scaleTime()\n .domain([evi_start, evi_end])\n .range([0, d3.timeDay.count(evi_start, evi_end)])","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"formatDate = d3.timeFormat(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"evi_start = new Date(2021, 0, 1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"evi_end = new Date(2021, 11, 31)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"import {rangeSlider} from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"#### Other imports and logic","pinned":false,"hidden":false,"mode":"md"},{"id":115,"value":"function formValue(form) {\n const object = {};\n for (const input of form.elements) {\n if (input.disabled || !input.hasAttribute(\"name\")) continue;\n let value = input.value;\n switch (input.type) {\n case \"range\":\n case \"number\": {\n value = input.valueAsNumber;\n break;\n }\n case \"date\": {\n value = input.valueAsDate;\n break;\n }\n case \"radio\": {\n if (!input.checked) continue;\n break;\n }\n case \"checkbox\": {\n if (input.checked) value = true;\n else if (input.name in object) continue;\n else value = false;\n break;\n }\n case \"file\": {\n value = input.multiple ? input.files : input.files[0];\n break;\n }\n case \"select-multiple\": {\n value = Array.from(input.selectedOptions, (option) => option.value);\n break;\n }\n }\n object[input.name] = value;\n }\n return object;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":156,"value":"function form(form) {\n const container = html`

${form}`;\n form.addEventListener(\"submit\", (event) => event.preventDefault());\n form.addEventListener(\"change\", () => {\n container.dispatchEvent(new CustomEvent(\"input\"));\n });\n form.addEventListener(\"input\", () => (container.value = formValue(form)));\n container.value = formValue(form);\n return container;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"topojson = require(\"topojson\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":284,"value":"d3 = require(\"d3@6\", \"d3-geo-projection@2\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"import { Legend } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":596,"value":"import { Tooltip } from \"@clhenrick/tooltip-component\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}} 2f:"$2e:body"