45:["$","title",null,{"children":"Demographic Data of East Metro Region | Chloe Bui | Observable"}] 4d:T464,a= Plot.plot({ marks: [ Plot.ruleY([0]), Plot.lineY(race_em_1223, {x: "Year", y: "Total_Population", stroke: "Region", strokeWidth: 3, tip : "x"}), Plot.dot(race_em_1223, { x: "Year", y: "Total_Population", fill: "Region", r: 4 // Radius of the dots }), Plot.text(race_em_1223.filter(d => d.Year === d3.max(race_em_1223, d => d.Year)), { x: "Year", y: "Total_Population", text: d => d.Region, dx: 70, // Offset text to the right of the line end dy: -2, fill: "Region", fontSize: 15, fontWeight: "bold", }) ], title: " Total Population in 4 regions", caption: "Source: 2020-2023 US Census Bureau ACS 5 Year Estimates", y: { grid: true, domain: [0,4500000], label: "Total population", tickFormat: "s", tickFontSize: 50 } , x: { domain: [2011.5, 2027], ticks: ["2012", "2013", "2014", "2015", "2016", "2017", "2018","2019","2020", "2021", "2022", "2023"], tickFormat: (d) => d + "", } })4e:T572,Plot.plot({ marks: [ Plot.ruleY([0]), Plot.lineY(race_em_1223.filter((d )=> (d.Race =="People of color")), {x: "Year", y: "Percentage", stroke: "Region", strokeWidth: 3, tip : "x"}), Plot.dot(race_em_1223.filter((d )=> (d.Race =="People of color")), { x: "Year", y: "Percentage", fill: "Region", r: 4, // Radius of the dots title: d => `${d.Year} - ${d.Region}: ${d.Percentage}%` // Tooltip for dots similar to line }), Plot.text(race_em_1223.filter(d => d.Race =="People of color" && d.Year === d3.max(race_em_1223, d => d.Year)), { x: "Year", y: "Percentage", text: d => d.Region, dx: 35, // Offset text to the right of the line end dy: d => d.Region === "East Metro"? -10: -5, fill: "Region", fontSize: 12, fontWeight: "bold", }) ], title: " People of color in 4 regions", caption: "Source: 2012-2023 US Census Bureau ACS 5 Year Estimates", y: { grid: true, label: "Percent people of color", domain: [0, 40], tickFormat: (d) => d + "%", //ticks: [20,30,40,50,60], } , x: { domain: [2011.5, 2025], ticks: ["2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020", "2021", "2022", "2023"], tickFormat: (d) => d } })4f:T4c9,Plot.plot({ marks: [ Plot.ruleY([0]), Plot.lineY(race_em_1223.filter((d )=> (d.Race =="Black alone")), {x: "Year", y: "Percentage", stroke: "Region", strokeWidth: 3, tip : "x"}), Plot.dot(race_em_1223.filter((d )=> (d.Race =="Black alone")), { x: "Year", y: "Percentage", fill: "Region", r: 4 }), Plot.text(race_em_1223.filter(d => d.Race =="Black alone" && d.Year === d3.max(race_em_1223, d => d.Year)), { x: "Year", y: "Percentage", text: d => d.Region, dx: 30, dy: -7, fill: "Region", fontSize: 12, fontWeight: "bold", }) ], title: " Black Identifying in 4 regions", caption: "Source: 2012-2023 US Census Bureau ACS 5 Year Estimates", y: { grid: true, label: "Percent black people", domain: [0, 12], tickFormat: (d) => d + "%", ticks: [0,3,6,9,12], nice: false, tickFontSize: 50 } , x: { domain: [2011.5, 2025], ticks: ["2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020", "2021", "2022", "2023"], tickFormat: (d) => d } })50:T486,Plot.plot({ marginLeft : 60, marks: [ Plot.ruleY([30000]), Plot.lineY(mhi_em_1223, {x: "Year", y: "Average Median Household Income", stroke: "Region", strokeWidth: 3, tip : "x"}), Plot.dot(mhi_em_1223, { x: "Year", y: "Average Median Household Income", fill: "Region", r: 4 // Radius of the dots }), Plot.text(mhi_em_1223.filter(d => d.Year === d3.max(mhi_em_1223, d => d.Year)), { x: "Year", y: "Average Median Household Income", text: d => d.Region, dx: 30, // Offset text to the right of the line end dy: -6, fill: "Region", fontSize: 12, fontWeight: "bold", }) ], title: " Average Median Household Income ", caption: "Source: 2012-2023 US Census Bureau ACS 5 Year Estimates", y: { grid: true, domain: [30000, 110000], //ticks: [30000,60000,90000,120000], } , x: { domain: [2011.5, 2025], ticks: ["2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020", "2021", "2022", "2023"], tickFormat: (d) => d } })51:T4b2,Plot.plot({ marks: [ Plot.ruleY([0]), Plot.lineY(income_em_1223.filter((d )=> (d.Gender==`${Gender_income}` && d.Income_Group==`${IncomeRange}`)) , {x: "Year", y: "Percentage", stroke: "Region", strokeWidth: 3, tip : "x"}), Plot.dot(income_em_1223.filter((d )=> (d.Gender==`${Gender_income}` && d.Income_Group==`${IncomeRange}`)), { x: "Year", y: "Percentage", fill: "Region", r: 4 // Radius of the dots }) ], color: {legend: true, domain: ["East Metro", "West Multnomah", "West Clackamas", "Oregon"]}, title: Gender_income=== "both" ? "Percentage of population with Annual Income range of "+`${IncomeRange}` : "Percentage of "+ `${Gender_income}` +" population with Annual Income range of "+ `${IncomeRange}`, caption: "Source: 2012-2023 US Census Bureau ACS 5 Year Estimates", y: { grid: true, tickFormat: (d) => d + "%", tickFontSize: 50 } , x: { domain: [2011.5, 2024], ticks: ["2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020", "2021", "2022", "2023"], tickFormat: (d) => d } })52:[{"id":"497f53b1fa427050a91075bc1c340778dbfed8c3c90b611a1851ee7f44336406033276763f223e5a1175db73bba35418da8d0f6c695a56bcd3e77ba694dede0b","href":"https://static.observableusercontent.com/files/497f53b1fa427050a91075bc1c340778dbfed8c3c90b611a1851ee7f44336406033276763f223e5a1175db73bba35418da8d0f6c695a56bcd3e77ba694dede0b","name":"tenure_4region_EM_2022.csv","type":"text/csv","lastModified":1731696568684.859,"size":1101},{"id":"f1a492ae5c592fedeaa9a06588a04349db39483393eda50449807c493ad22e41229ef1dafdaed35638899b6493419c508ffb76d86e6d59b3ea44059ea21f0b08","href":"https://static.observableusercontent.com/files/f1a492ae5c592fedeaa9a06588a04349db39483393eda50449807c493ad22e41229ef1dafdaed35638899b6493419c508ffb76d86e6d59b3ea44059ea21f0b08","name":"income_4region_em_ami@1.csv","type":"text/csv","lastModified":1731717482204.13,"size":2879},{"id":"7199427acf41d05da567423a167ac4238782b414a10fd91b8bc987de32cb461ccbc866c2ad7954606e75d97e8880932b1a5023c29d2aed0980e009bc67f13c3f","href":"https://static.observableusercontent.com/files/7199427acf41d05da567423a167ac4238782b414a10fd91b8bc987de32cb461ccbc866c2ad7954606e75d97e8880932b1a5023c29d2aed0980e009bc67f13c3f","name":"race_4region_EM_2022@1.csv","type":"text/csv","lastModified":1732295205932.55,"size":5681},{"id":"c43e518247ef4b82505f2c3760780f6da5980f08d452fe1bc6bfe9151938a227df40c2ce6b16b6032071939b24445866aad38d29fd902026ec030fd0111091ae","href":"https://static.observableusercontent.com/files/c43e518247ef4b82505f2c3760780f6da5980f08d452fe1bc6bfe9151938a227df40c2ce6b16b6032071939b24445866aad38d29fd902026ec030fd0111091ae","name":"occ_4region_EM_2022.csv","type":"text/csv","lastModified":1732300193370.782,"size":1121},{"id":"0059e25dec9a9948d1e47f7b16fa49c71100ae2c085a73049ad75d18e6030c4bc723d6f674b32f9d61c5077b458d623974187e339342ab72280ba4d56232d42b","href":"https://static.observableusercontent.com/files/0059e25dec9a9948d1e47f7b16fa49c71100ae2c085a73049ad75d18e6030c4bc723d6f674b32f9d61c5077b458d623974187e339342ab72280ba4d56232d42b","name":"tenureocc_4region_EM_2022@1.csv","type":"text/csv","lastModified":1732303317411.982,"size":1101},{"id":"8e937571b393e26cb315938568a917780fb1346b167bfbc908d27150cddb2e4b3947c3f2c557e71bb12f1205643488d978af41b0b809129b5e726fed73bb0963","href":"https://static.observableusercontent.com/files/8e937571b393e26cb315938568a917780fb1346b167bfbc908d27150cddb2e4b3947c3f2c557e71bb12f1205643488d978af41b0b809129b5e726fed73bb0963","name":"size_4region_EM_2022.csv","type":"text/csv","lastModified":1732317082152.254,"size":8452},{"id":"371b1859289d2b892473f088b0f9084511559482c1db670e71ec18bdf06f0cfc1bc0fe1876d114564cb3efeb818a96271563ab31dbe79813e50e37d818b3fdc6","href":"https://static.observableusercontent.com/files/371b1859289d2b892473f088b0f9084511559482c1db670e71ec18bdf06f0cfc1bc0fe1876d114564cb3efeb818a96271563ab31dbe79813e50e37d818b3fdc6","name":"race_EM_1223.csv","type":"text/csv","lastModified":1738623632923.59,"size":26396},{"id":"dfea606873ef398a4e4d14de75a9da3f9e97d25ad7876eb8ee4c796f89de967fc88a5a1df806730328504ce0f0608e555ebc340e71729dc0f5d55ac42b17dd65","href":"https://static.observableusercontent.com/files/dfea606873ef398a4e4d14de75a9da3f9e97d25ad7876eb8ee4c796f89de967fc88a5a1df806730328504ce0f0608e555ebc340e71729dc0f5d55ac42b17dd65","name":"mhi_em_1223.csv","type":"text/csv","lastModified":1738626369873.388,"size":1294},{"id":"dc9110f9b3ff4c8947d70738c4d54633332151cbc3a0ec1c45cfa4f1efc548f320059332f71e78882c9255a017fe8a51f6e33f2f98395df171957198fd85b900","href":"https://static.observableusercontent.com/files/dc9110f9b3ff4c8947d70738c4d54633332151cbc3a0ec1c45cfa4f1efc548f320059332f71e78882c9255a017fe8a51f6e33f2f98395df171957198fd85b900","name":"income_em_1223.csv","type":"text/csv","lastModified":1738709883643.311,"size":87966}] 49:{"id":"13a71fbc70b91cb1","slug":"demographic-data-of-east-metro-region","title":"Demographic Data of East Metro Region","thumbnail":"43f3823fd4b18833d0d67d05978eecbb253d57cd15607e6dde9ad32ee048c581","access_level":"public","create_time":"$D2024-11-15T08:47:22.772Z","update_time":"$D2025-02-05T00:17:03.696Z","view_time":null,"first_public_time":"$D2024-11-15T20:32:18.650Z","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":465,"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Demographic Data of East Metro Region","cells":[{"id":356,"value":"# Demographic Data of East Metro Region","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":352,"value":"html`These tables and charts below show the demographic data of East Metro Region compare to other regions, including: West Multnomah County, West Clackamas County and Oregon.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"# 1. Race","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":211,"value":"html`Data source: US Census Bureau ACS 5-year estimate
\nTable B03002 (Hispanic or Latino Origin by Race)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"html`According to the table, we will review the total population across four regions from 2020 to 2023, based on the latest U.S. Census Bureau ACS 5-Year Estimates.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":383,"value":"race_em_1223 = await FileAttachment(\"race_EM_1223.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"race_em_1223","database":"$undefined"},{"id":8,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"b = Plot.plot({\n marks: [\n Plot.barY(race_em_1223.filter((d )=> (d.Race !=\"People of color\")), \n {fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Race\",\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n domain: categoryOrder,\n scheme: \"spectral\"\n },\n x: { axis: null },\n y: { grid: true,\n domain:[0,100],\n tickFormat: (d) => d + \"%\",\n ticks: [0,20,40,60,80, 100]},\n fx: { label: null,\n domain: [\"East Metro\", \"West Multnomah County\", \"West Clackamas County\", \"Oregon\"]},\n title: \"Race distribution by percent in 4 regions\",\n caption: \"Source: 2012-2023 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"b2= html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"# 2. Housing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":239,"value":"**Data source**: US Census Bureau ACS 5-year estimate \nTable B25002 (Occupancy Status)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":237,"value":"occ_4region_em_2022 = await FileAttachment(\"occ_4region_EM_2022.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"occ_4region_em_2022","database":"$undefined"},{"id":241,"value":"c=Plot.plot({\n marks: [\n Plot.barY(occ_4region_em_2022, {\n fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Occupancy type\",\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n scheme: \"spectral\"\n },\n //x: { axis: null },\n y: { grid: true,\n domain : [0,100],\n tickFormat: (d) => d + \"%\",},\n fx: { label: null,\n domain : [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\", \"Oregon\"]},\n title: \"Percentage of Occupied and Vacant Housing Units by Region (2020-2022)\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"viewof Year1 = Inputs.select([2020, 2021, 2022],\n {label: \"SELECT YEAR\", value: 2022})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"d=Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(occ_4region_em_2022.filter((d )=> (d.Year==`${Year1}`)), \n{ x: \"Occupancy type\",\n y: \"Estimate\",\n fx: \"Region\",\n fill: \"Occupancy type\",\n }),\n Plot.ruleY([0]),\n \n Plot.text(occ_4region_em_2022.filter((d )=> (d.Year==`${Year1}`)), \n{ \n //text: d => `${d['Population Estimate']}`,\n text: d => `${Number(d['Estimate']).toLocaleString()}`,\n x: \"Occupancy type\",\n y: \"Estimate\",\n fx: \"Region\", \n dy: -7,\n fill: \"black\"\n }),\n \n ],\n \n color: {\n legend : true,\n scheme: \"Warm\"\n },\n x: { axis: null},\n fx: {domain: [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"],\n label : null},\n y: { grid: true,\n domain: [0, 300000], label: \"Housing Unit Estimate\"\n },\n title: \"Occupied and Vacant Housing Units by Region in \"+ `${Year1}`,\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"Next, we will focus on occupied housing units to analyze tenure, specifically examining how many units are owner-occupied versus rented.\n\n**Data source**: US Census Bureau ACS 5-year estimate \nTable B25003 (Occupied Housing Units by Tenure)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":272,"value":"tenureocc_4region_em_2022 = await FileAttachment(\"tenureocc_4region_EM_2022@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"tenureocc_4region_em_2022","database":"$undefined"},{"id":275,"value":"Plot.plot({\n marks: [\n Plot.barY(tenureocc_4region_em_2022, {\n fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Tenure type\",\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n scheme: \"spectral\"\n },\n //x: { axis: null },\n y: { grid: true,\n domain : [0,100],\n tickFormat: (d) => d + \"%\",},\n fx: { label: null,\n domain : [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\", \"Oregon\"]},\n title: \"Percentage of owned vs rented occupied Housing Units by Region (2020-2022)\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"viewof Year3 = Inputs.select([2020, 2021, 2022],\n {label: \"SELECT YEAR\", value: 2022})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(tenureocc_4region_em_2022.filter((d )=> (d.Year==`${Year3}`)), \n{ x: \"Tenure type\",\n y: \"Estimate\",\n fx: \"Region\",\n fill: \"Tenure type\",\n }),\n Plot.ruleY([0]),\n \n Plot.text(tenureocc_4region_em_2022.filter((d )=> (d.Year==`${Year3}`)), \n{ \n //text: d => `${d['Population Estimate']}`,\n text: d => `${Number(d['Estimate']).toLocaleString()}`,\n x: \"Tenure type\",\n y: \"Estimate\",\n fx: \"Region\", \n dy: -7,\n fill: \"black\"\n }),\n \n ],\n \n color: {\n legend : true,\n scheme: \"Warm\"\n },\n x: { axis: null},\n fx: {domain: [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"],\n label : null},\n y: { grid: true,\n domain: [0, 200000], \n label: \"Housing Unit Estimate\"\n },\n title: \"Owned and Rented Occupied Housing Units by Region in \"+ `${Year3}`,\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":331,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"Next, we will examine the total population living in occupied housing units, categorized by whether they own or rent their homes.\n\n**Data source**: US Census Bureau ACS 5-year estimate \nTable B25008 (Total Population in Occupied Housing Units by Tenure)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"tenure_4region_em_2022 = await FileAttachment(\"tenure_4region_EM_2022.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"tenure_4region_em_2022","database":"$undefined"},{"id":43,"value":"Plot.plot({\n marks: [\n Plot.barY(tenure_4region_em_2022, {\n fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Type\",\n //z: {value: d => d.variableOrder}, // Use the factor for sorting\n //order: \"variableOrder\", // Ensure the stacking order follows the factor\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n //domain: categoryOrder, // Ensuring legend follows the same order\n scheme: \"spectral\"\n },\n //x: { axis: null },\n y: { grid: true,\n domain : [0,100],\n tickFormat: (d) => d + \"%\",},\n fx: { label: \"Region\",\n domain : [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\", \"Oregon\"]},\n title: \"Tenure type py percentage in 4 regions\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(tenure_4region_em_2022.filter(d=> d.Region !== \"Oregon\")\n , {\n fx: \"Region\",\n x: \"Year\",\n y: \"Population Estimate\",\n fill: \"Type\",\n //z: {value: d => d.variableOrder}, // Use the factor for sorting\n //order: \"variableOrder\", // Ensure the stacking order follows the factor\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n //domain: categoryOrder, // Ensuring legend follows the same order\n scheme: \"spectral\"\n },\n x: { label: null },\n y: { grid: true,\n //domain : [0, 650000]\n },\n fx: { label: \"Region\",\n domain : [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"]},\n title: \"Tenure type by population estimate in 3 regions\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"viewof Year = Inputs.select([2020, 2021, 2022],\n {label: \"SELECT YEAR\", value: 2022})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(tenure_4region_em_2022.filter((d )=> (d.Year==`${Year}`)), \n{ x: \"Type\",\n y: \"Population Estimate\",\n fx: \"Region\",\n fill: \"Type\",\n tip : \"X\",\n }),\n Plot.ruleY([0]),\n \n Plot.text(tenure_4region_em_2022.filter((d )=> (d.Year==`${Year}`)), \n{ \n //text: d => `${d['Population Estimate']}`,\n text: d => `${Number(d['Population Estimate']).toLocaleString()}`,\n x: \"Type\",\n y: \"Population Estimate\",\n fx: \"Region\", \n dy: -7,\n fill: \"black\"\n }),\n \n ],\n \n color: {\n legend : true,\n scheme: \"Warm\"\n },\n x: { axis: null},\n fx: {domain: [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"], label : null},\n y: { grid: true,\n domain: [0, 450000]\n },\n title: \"Tenure type in 3 regions in \"+ `${Year}`,\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"**Data source**: US Census Bureau ACS 5-year estimate \nTable B25009 (Tenure by Household Size)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":301,"value":"size_4region_em_2022 = await FileAttachment(\"size_4region_EM_2022.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"size_4region_em_2022","database":"$undefined"},{"id":294,"value":"viewof TenureType = Inputs.select([\"own\",\"rent\"],\n {label: \"SELECT TENURE TYPE\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"Plot.plot({\n marks: [\n Plot.barY(\n size_4region_em_2022.filter(d => d.Tenure_type==`${TenureType}`)\n , {\n fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Household size\",\n //z: {value: d => d.VariableOrder3}, // Use the factor for sorting\n //order: \"VariableOrder3\", // Ensure the stacking order follows the factor\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n //domain : IncomeOrder,\n scheme: \"spectral\"\n },\n x: { axis: null },\n y: { grid: true,\n tickFormat: (d) => d + \"%\",\n //domain: [0,60]\n },\n fx: { label: \"Region\",\n domain: [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\", \"Oregon\"]},\n title: \"Household size Distribution in 4 regions for \"+`${TenureType}`+\"ed type\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"viewof Year4 = Inputs.select([2020, 2021, 2022],\n {label: \"SELECT YEAR\", value: 2022})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"Plot.plot({\n marginLeft : 60,\n marks: [\n Plot.barY(size_4region_em_2022.filter((d )=> (d.Tenure_type==`${TenureType}` && d.Year==`${Year4}`)), \n{ x: \"Household size\",\n y: \"Estimate\",\n fx: \"Region\",\n fill: \"Household size\",\n tip : \"X\",\n }),\n Plot.ruleY([0]),\n \n ],\n \n color: {\n legend : true,\n scheme: \"Warm\"\n },\n x: { axis: null},\n fx: {domain: [\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"], label : null},\n y: { grid: true,\n domain: [0, 70000]\n },\n title: \"Household size distribution of \"+ `${TenureType}` +\"ed type in \"+ `${Year4}`,\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"# 3. Income","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":403,"value":"**Data source**: US Census Bureau ACS 5-year estimate \nTable B19013 (Median Household Income)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":406,"value":"mhi_em_1223 = await FileAttachment(\"mhi_em_1223.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"mhi_em_1223","database":"$undefined"},{"id":409,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":421,"value":"html`Data source: US Census Bureau ACS 5-year estimate
\nTable B20001 (Sex by Earnings in the Past 12 Months (Inflation-adjusted Dollars) for the Population 16 Years and Over With Earnings in the Past 12 Months)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":429,"value":"income_em_1223 = await FileAttachment(\"income_em_1223.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"income_em_1223","database":"$undefined"},{"id":109,"value":"viewof Gender = Inputs.select([\"male\", \"female\",\"both\"],\n {label: \"SELECT GENDER\", value: \"both\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"Plot.plot({\n marks: [\n Plot.barY(\n income_em_1223.filter(d => d.Gender==`${Gender}`)\n , {\n fx: \"Region\",\n x: \"Year\",\n y: \"Percentage\",\n fill: \"Income_Group\",\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n domain : IncomeOrder,\n scheme: \"spectral\"\n },\n x: { axis: null },\n y: { grid: true,\n tickFormat: (d) => d + \"%\",\n //domain: [0,60]\n },\n fx: { label: \"Region\",\n domain: [\"East Metro\", \"West Multnomah\", \"West Clackamas\", \"Oregon\"]},\n title: \"Income Range Distribution in 4 regions for \"+`${Gender}`+\" gender\",\n caption: \"Source: 2020-2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"viewof Gender_income = Inputs.select([\"male\", \"female\", \"both\"],\n {label: \"SELECT GENDER\", value: \"both\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"viewof IncomeRange = Inputs.select([\"$4,999 or less\", \"$5,000 to $9,999\",\"$10,000 to $19,999\",\"$20,000 to $29,999\",\"$30,000 to $39,999\",\"$40,000 to $49,999\",\"$50,000 to $64,999\",\"$65,000 to $74,999\",\"$75,000 to $99,999\", \"$100,000 or more\"],\n {label: \"SELECT INCOME RANGE\", value : \"$50,000 to $64,999\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"viewof Region = Inputs.select([\"East Metro\", \"Other Multnomah\", \"Other Clackamas\", \"Oregon\"],\n {label: \"SELECT REGION\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"viewof Year2 = Inputs.select([2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023],\n {label: \"SELECT YEAR\", value: 2023})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"Plot.plot({\n marks: [\n Plot.barY(income_em_1223.filter((d )=> (d.Region==`${Region}` && d.Year==`${Year2}`)), \n{ x: \"Gender\",\n y: \"Population estimate\",\n fx: \"Income_Group\",\n fill: \"Gender\",\n tip : \"X\",\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n scheme: \"Warm\"\n },\n x: { axis: null},\n fx: {domain: IncomeOrder,\n },\n marginLeft: 60, // Add left margin for better readability\n marginRight: 60, // Add right margin for better spacing\n width: 1100, // Increase chart width\n height: 600, // Increase chart height\n y: { grid: true},\n title: \"Income group distribution in \"+ `${Region}`+\" by gender in \"+ `${Year2}`,\n caption: \"Source: \"+`${Year2}` +\" US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"Based on the Area Median Income (AMI) of Multnomah and Clackamas County = $106,500 in 2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":146,"value":"income_4region_em_ami = await FileAttachment(\"income_4region_em_ami@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"income_4region_em_ami","database":"$undefined"},{"id":201,"value":"viewof Region2 = Inputs.select([\"East Metro\", \"Other Multnomah\", \"Other Clackamas\"],\n {label: \"SELECT REGION\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"Plot.plot({\n marginLeft : 100,\n marks: [\n Plot.barX(income_4region_em_ami.filter((d )=> (d.Region==`${Region2}`)), \n{ y: \"Gender\",\n x: \"Population Estimate\",\n fy: \"Type_AMI\",\n fill: \"Gender\",\n tip : \"y\",\n }),\n Plot.text(income_4region_em_ami.filter((d )=> (d.Region==`${Region2}`)), \n{ \n //text: d => `${d['Population Estimate']}`,\n text: d => `${Number(d['Population Estimate']).toLocaleString()}`,\n y: \"Gender\",\n x: \"Population Estimate\",\n fy: \"Type_AMI\", \n textAnchor: \"end\",\n dx: -3,\n fill: \"white\"\n }),\n Plot.ruleY([0])\n ],\n color: {\n legend : true,\n scheme: \"Warm\"\n },\n y: { axis: null},\n fy: {domain: [\"Above 94% AMI\",\"70% - 94% AMI\",\"61% - 70% AMI\", \"28% - 61% AMI\", \"Under 28% AMI\"]},\n //x: { grid: true},\n title: \"Income group distribution in \"+ `${Region2}`+\" in 2022 by gender\",\n caption: \"Source: 2022 US Census Bureau ACS 5 Year Estimates\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"# 4. Poverty","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":336,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":390,"value":"categoryOrder = [ \"Black alone\", \"Asian alone\", \"Native Hawaiian and Other Pacific Islander alone\", \"American Indian and Alaska Native alone\", \"Hispanic or Latino\", \"White alone\", \"Some other race alone\", \"Two or more races\"];","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"IncomeOrder = [\"$4,999 or less\", \"$5,000 to $9,999\",\"$10,000 to $19,999\",\"$20,000 to $29,999\",\"$30,000 to $39,999\",\"$40,000 to $49,999\",\"$50,000 to $64,999\",\"$65,000 to $74,999\",\"$75,000 to $99,999\",\"$100,000 or more\" ]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W52","stdlib":"1"}} 44:null