45:["$","title",null,{"children":"Low to Moderate Income Population in Multnomah County | Chloe Bui | Observable"}] 4d:[{"id":"bdaea4a7aa212c460f2d6b230fe580636306479ed11bcfe1751363be69012f77dad2b3ac1598b06eaa5b174d5fed290c0855404a4d67538adb8b9afce44ec1d3","href":"https://static.observableusercontent.com/files/bdaea4a7aa212c460f2d6b230fe580636306479ed11bcfe1751363be69012f77dad2b3ac1598b06eaa5b174d5fed290c0855404a4d67538adb8b9afce44ec1d3","name":"low_mc_1520.csv","type":"text/csv","lastModified":1734597212048.331,"size":188},{"id":"91854885f181e83c01ba04e12648c730a7d60ab7d06b648e1e30e433efd03740119eec51195bee51498b8bcf91111da805fca1fb1557647e943501952fd597e5","href":"https://static.observableusercontent.com/files/91854885f181e83c01ba04e12648c730a7d60ab7d06b648e1e30e433efd03740119eec51195bee51498b8bcf91111da805fca1fb1557647e943501952fd597e5","name":"lowmod.csv","type":"text/csv","lastModified":1732560372514.029,"size":99},{"id":"b01673fa4d3815c6754e5e932f5fc68c413a7ba6ddfb357d3c087b57325d3227d48cfbb3023dba44acb5fb542f853d912e42354cd0f3ef5ebea9dde7221fa030","href":"https://static.observableusercontent.com/files/b01673fa4d3815c6754e5e932f5fc68c413a7ba6ddfb357d3c087b57325d3227d48cfbb3023dba44acb5fb542f853d912e42354cd0f3ef5ebea9dde7221fa030","name":"lowmod_2020.csv","type":"text/csv","lastModified":1732650112153.946,"size":100},{"id":"ac335f273f354f67105e8a3c17c629908703ed9f15cd23bd93f76a572e34f004fa12ff1879ad8870209731e0a847a0b1c006b9476b784b14312d26006f3a502e","href":"https://static.observableusercontent.com/files/ac335f273f354f67105e8a3c17c629908703ed9f15cd23bd93f76a572e34f004fa12ff1879ad8870209731e0a847a0b1c006b9476b784b14312d26006f3a502e","name":"lowmod_2020_new.csv","type":"text/csv","lastModified":1738003931508.568,"size":99},{"id":"bd6503e924846ff5d2bbc3345b005840467a4d199ae578b2e794b923998c330d7ba1caaa20120669e081554d299dedd543cc5dc6120a538395fe73710b80da6f","href":"https://static.observableusercontent.com/files/bd6503e924846ff5d2bbc3345b005840467a4d199ae578b2e794b923998c330d7ba1caaa20120669e081554d299dedd543cc5dc6120a538395fe73710b80da6f","name":"low_mc_1520_new.csv","type":"text/csv","lastModified":1738006869269.094,"size":175},{"id":"a7f5b82b315a623fc90a41356762f01c8cf0ba18589e1ce5c34c4db5f99b32b84280fa2b0f08ef72b469495f02bbec04bf356f3d2e50e48e008dc39cce1abf98","href":"https://static.observableusercontent.com/files/a7f5b82b315a623fc90a41356762f01c8cf0ba18589e1ce5c34c4db5f99b32b84280fa2b0f08ef72b469495f02bbec04bf356f3d2e50e48e008dc39cce1abf98","name":"low_mc_1520_long@1.csv","type":"text/csv","lastModified":1738134346906.466,"size":395}] 49:{"id":"9f197ddcb0d1c4a4","slug":"low-to-moderate-income-population","title":"Low to Moderate Income Population in Multnomah County","thumbnail":"beb809f7f70e84d392908429b6fa18d0614c80ca55ceef1753cac6a97f764812","access_level":"public","create_time":"$D2024-11-25T18:45:31.913Z","update_time":"$D2025-02-10T18:49:58.041Z","view_time":null,"first_public_time":"$D2024-11-26T22:29:47.876Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"38687cf2b05a9fb2","login":"cdco","name":"Chloe Bui","avatar_url":"https://avatars-next.observableusercontent.com/a1dc092075d75f22b8331655ed10563c4738bdff4834cca0d856f476e0281bdd","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":240,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a0996923973394b5","login":"cdco","name":"Chloe Bui","avatar_url":"https://avatars-next.observableusercontent.com/5f2909d79277de6d1b62b68b7fa0450afbfead99f832337373b3f8cf2570bfac","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"38687cf2b05a9fb2","login":"cdco","name":"Chloe Bui","avatar_url":"https://avatars-next.observableusercontent.com/a1dc092075d75f22b8331655ed10563c4738bdff4834cca0d856f476e0281bdd","tier":"starter_2024","role":"editor"},{"type":"individual","id":"a0996923973394b5","login":"cdco","name":"Chloe Bui","avatar_url":"https://avatars-next.observableusercontent.com/5f2909d79277de6d1b62b68b7fa0450afbfead99f832337373b3f8cf2570bfac","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Low to Moderate Income Population in Multnomah County","cells":[{"id":0,"value":"# Low to Moderate Income Population in Multnomah County","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":59,"value":" html`These data are derived from HUD GIS Helpdesk.
Source: 2011-2015 American Community Survey (ACS)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"lowmod = await FileAttachment(\"lowmod.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"lowmod","database":"$undefined"},{"id":6,"value":"Plot.plot({\n marginLeft : 60,\n title: \"Percentage of Low and Moderate income people in Multnomah County\",\n caption: \"Source: HUD GIS Helpdesk - 2011-2015 American Community Survey (ACS) \",\n x: {\n padding: 0.5, // Adjust spacing between bars, smaller values mean thinner bars,\n label: null\n },\n y: { grid: true,\n domain : [0, 60],\n ticks: [0,20,40,60],\n tickFormat: (d) => d + \"%\",\n label: \"Percentage\"},\n marks: [\n Plot.barY(lowmod, {x: \"Region\", y: \"lowmod_pct\", \n fill: d => (d.Region === \"West County\" ? \"green\" : \"blue\")}),\n Plot.ruleY([0]),,\n Plot.text(lowmod, { \n text: d => `${d['lowmod_pct']}%`,\n x: \"Region\",\n y: \"lowmod_pct\",\n dy: -9,\n fontSize: 15,\n fill: \"black\"\n }),\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"Plot.plot({\n marginLeft : 60,\n title: \"The count of Low and Moderate income people in Multnomah County\",\n caption: \"Source: HUD GIS Helpdesk - 2011-2015 American Community Survey (ACS) \",\n x: { label: null,\n padding: 0.5 // Adjust spacing between bars, smaller values mean thinner bars\n },\n y: { domain : [0, 180000],\n ticks: [0, 30000, 60000,90000,120000,150000, 180000],\n grid: true,\n label: \" Count \"},\n marks: [\n Plot.barY(lowmod, {x: \"Region\", y: \"lowmod\", \n fill: d => (d.Region === \"West County\" ? \"green\" : \"blue\")}),\n Plot.ruleY([0]),,\n Plot.text(lowmod, { \n text: d => `${Number(d['lowmod']).toLocaleString()}`,\n x: \"Region\",\n y: \"lowmod\",\n dy: -9,\n fontSize: 15,\n fill: \"black\"\n }),\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":" html`These data are derived from HUD Exchange.
Source: 2016-2020 American Community Survey (ACS)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"lowmod_2020 = await FileAttachment(\"lowmod_2020.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"lowmod_2020","database":"$undefined"},{"id":67,"value":"Plot.plot({\n marginLeft : 60,\n title: \"Percentage of Low and Moderate income people in Multnomah County\",\n caption: \"Source: HUD GIS Helpdesk - 2016-2020 American Community Survey (ACS) \",\n x: {\n padding: 0.5, // Adjust spacing between bars, smaller values mean thinner bars,\n label: null\n },\n y: { grid: true,\n domain : [0, 60],\n ticks: [0,20,40,60],\n tickFormat: (d) => d + \"%\",\n label: \"Percentage\"},\n marks: [\n Plot.barY(lowmod_2020, {x: \"Region\", y: \"lowmod_pct\", \n fill: d => (d.Region === \"West County\" ? \"green\" : \"blue\")}),\n Plot.ruleY([0]),,\n Plot.text(lowmod_2020, { \n text: d => `${d['lowmod_pct']}%`,\n x: \"Region\",\n y: \"lowmod_pct\",\n dy: -9,\n fontSize: 15,\n fill: \"black\"\n }),\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"Plot.plot({\n marginLeft : 60,\n title: \"The count of Low and Moderate income people in Multnomah County\",\n caption: \"Source: HUD GIS Helpdesk - 2016-2020 American Community Survey (ACS) \",\n x: { label: null,\n padding: 0.5 // Adjust spacing between bars, smaller values mean thinner bars\n },\n y: { domain : [0, 200000],\n ticks: [0, 40000, 80000,120000,160000, 200000],\n grid: true,\n label: \" Count \"},\n marks: [\n Plot.barY(lowmod_2020, {x: \"Region\", y: \"lowmod\", \n fill: d => (d.Region === \"West County\" ? \"green\" : \"blue\")}),\n Plot.ruleY([0]),,\n Plot.text(lowmod_2020, { \n text: d => `${Number(d['lowmod']).toLocaleString()}`,\n x: \"Region\",\n y: \"lowmod\",\n dy: -9,\n fontSize: 15,\n fill: \"black\"\n }),\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":" html`The table below combines the data from 2 table above.
These data from 2011 to 2015 are derived from HUD GIS Helpdesk.
Source: 2011-2015 American Community Survey (ACS)
These data from 2016 to 2020 are derived from HUD Exchange.
Source: 2016-2020 American Community Survey (ACS)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"low_mc_1520 = await FileAttachment(\"low_mc_1520.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"low_mc_1520","database":"$undefined"},{"id":99,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520, \n{ x: \"Year\",\n y: \"lowmod\",\n fx: \"Region\",\n fill: d => d.Region === \"West County\" ? \"#3ca951\" : \"#4269d0\"}),\n Plot.ruleY([0]),\n \n Plot.text(low_mc_1520, \n{ text: d => `${Number(d['lowmod']).toLocaleString()}`,\n x: \"Year\",\n y: \"lowmod\",\n fx: \"Region\",\n dy: 13,\n fontSize: 13,\n fontWeight: \"bold\",\n fill: \"white\" })],\n y: { grid: true,\n domain: [0, 200000], \n ticks: [0, 40000, 80000,120000,160000, 200000],\n label: \"Count\"\n },\n title: \"The count of Low and Moderate income people in Multnomah County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520, \n{ x: \"Year\",\n y: \"lowmod_pct\",\n fx: \"Region\",\n fill: d => d.Region === \"West County\" ? \"#3ca951\" : \"#4269d0\"}),\n Plot.ruleY([0]),\n \n Plot.text(low_mc_1520, \n{ text: d => `${d['lowmod_pct']}%`,\n x: \"Year\",\n y: \"lowmod_pct\",\n fx: \"Region\",\n dy: 13,\n fontSize: 13,\n fontWeight: \"bold\",\n fill: \"white\" })],\n y: { grid: true,\n domain : [0, 60],\n ticks: [0,20,40,60],\n tickFormat: (d) => d + \"%\",\n label: \"Percentage\"},\n title: \"Percentage of Low and Moderate income people in Multnomah County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"The map below shows a significantly higher number of tracts with a high percentage of low-to-moderate income individuals in East County compared to West County.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":77,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"low_mc_1520_new = await FileAttachment(\"low_mc_1520_new.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"low_mc_1520_new","database":"$undefined"},{"id":145,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520_new, \n{ x: \"Year\",\n y: \"lowmod\",\n fx: \"Region\",\n fill: d => d.Region === \"West County\" ? \"#3ca951\" : \"#4269d0\"}),\n Plot.ruleY([0]),\n \n Plot.text(low_mc_1520_new, \n{ text: d => `${Number(d['lowmod']).toLocaleString()}`,\n x: \"Year\",\n y: \"lowmod\",\n fx: \"Region\",\n dy: 13,\n fontSize: 13,\n fontWeight: \"bold\",\n fill: \"white\" })],\n y: { grid: true,\n domain: [0, 300000], \n ticks: [0, 50000, 100000,150000,200000, 250000, 300000],\n label: \"Count\"\n },\n title: \"The count of Low and Moderate income people in Multnomah County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520_new, \n{ x: \"Year\",\n y: \"lowmod_pct\",\n fx: \"Region\",\n fill: d => d.Region === \"West County\" ? \"#3ca951\" : \"#4269d0\"}),\n Plot.ruleY([0]),\n \n Plot.text(low_mc_1520_new, \n{ text: d => `${d['lowmod_pct']}%`,\n x: \"Year\",\n y: \"lowmod_pct\",\n fx: \"Region\",\n dy: 13,\n fontSize: 13,\n fontWeight: \"bold\",\n fill: \"white\" })],\n y: { grid: true,\n domain : [0, 60],\n ticks: [0,20,40,60],\n tickFormat: (d) => d + \"%\",\n label: \"Percentage\"},\n title: \"Percentage of Low and Moderate income people in Multnomah County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"low_mc_1520_long = await FileAttachment(\"low_mc_1520_long@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"low_mc_1520_long","database":"$undefined"},{"id":161,"value":"Plot.plot({ marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520_long, {\n fx: \"Region\",\n x: \"Year\",\n y: \"Population_Estimate\",\n fill: \"Type\",\n tip : \"X\",\n }),\n Plot.ruleY([0]),\n Plot.text(low_mc_1520_long.filter(d => d.Type === \"lowmod\"), \n {text: d => `${d['lowmod_pct']}%`,\n x: \"Year\",\n y: \"lowmod_pct\",\n fx: \"Region\",\n dy: -20,\n fontSize: 15,\n fontWeight: \"bold\",\n fill: \"white\" })\n ],\n color: {\n legend : true,\n domain: [\"lowmod\", \"notlowmod\"], // Define the categories for the legend\n range: [\"#EFB118\", \"#4269d0\"], \n },\n y: { grid: true, \n domain: [0,700000],\n ticks: [0, 100000, 200000, 300000, 400000, 500000, 600000, 700000],\n label: \"Count\"},\n title: \"The count of Low Moderate income people in Multnomah County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"Plot.plot({ marginLeft : 60,\n marks: [\n Plot.barY(low_mc_1520_long.filter(d => d.Region === \"East County\"), {\n //fx: \"Region\",\n x: \"Year\",\n y: \"Population_Estimate\",\n fill: \"Type\",\n tip : \"X\",\n }),\n Plot.ruleY([0]),\n Plot.text(low_mc_1520_long.filter(d => d.Region === \"East County\" && d.Type === \"lowmod\"), \n {text: d => `${d['lowmod_pct']}%`,\n x: \"Year\",\n y: \"lowmod_pct\",\n //fx: \"Region\",\n dy: -70,\n fontSize: 19,\n fontWeight: \"bold\",\n fill: \"white\" })\n ],\n color: {\n legend : true,\n domain: [\"lowmod\", \"notlowmod\"], // Define the categories for the legend\n range: [\"#EFB118\", \"#4269d0\"], \n },\n y: { grid: true, \n domain: [0,170000],\n ticks: [0, 50000, 100000, 150000],\n label: \"Count\"},\n width: 400, // Increase chart width\n title: \"The count of Low Moderate income people in East County\",\n caption: \"HUD- American Community Survey\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"var:low_mc_1520"},{"id":240,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 44:null