2f:T458,{ const regGroupThreshStack = aq.from(psaRegGroupThreshStack) .derive({ region: d => d.region === "Autonomous Region in Muslim Mindanao/Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)" ? "BARMM/ARMM" : d.region }) .objects() return Plot.plot({ marks: [ Plot.barX(regGroupThreshStack, { x: "amountMonthly", y: "region", fill: "indicator", fillOpacity: d => d.region === selectRegion ? 1 : 0.5 }), Plot.ruleX([rangeIncomeComp], { stroke: "black", strokeWidth: 2, }), Plot.text([{amountMonthly: rangeIncomeComp}], { x: "amountMonthly", dy: -180, fontSize: 16, text: d => `Your family income: Php ${d.amountMonthly}` }), ], y: { domain: d3.sort(regGroupThreshStack.filter(d => d.indicator === "subpov_annual_percap_thresh"), d => d.amountMonthly).map(d => d.region) }, color: { type: "ordinal", range: ["grey", "orange", "red"], legend: true }, width: 700, height: 400, marginLeft: 250, marginTop: 30, }) }30:T719,psaThresh = { const povThresh = aq.from(psaPovThreshRaw) .fold(psaPovThreshInds.slice(2)) // .filter(d => d.key === "2021_pov_annual_percap_thresh" || "2018_pov_annual_percap_thresh") const subpovThresh = aq.from(psaSubpovThreshRaw) .fold(psaSubpovThreshInds.slice(2)) // .filter(d => d.key === "2021_subpov_annual_percap_thresh" || "2018_subpov_annual_percap_thresh") return povThresh.concat(subpovThresh) .rename({ key: "indicator" }) .derive({ year: aq.escape(d => d.indicator.split("_")[0]), indicator: aq.escape(d => d.indicator.split("_").slice(1).join("_")) }) .filter(d => d.region !== "PHILIPPINES") .relocate( "year", { after: "region" }) .rename({ value: "amountAnnual" }) // Derive amount on a monthly basis .derive({ amountMonthly: d => Math.round(d.amountAnnual / 12)}) .filter(aq.escape(d => d.indicator.includes("thresh"))) // Region name corrections .derive({ region: aq.escape(d => d.region === "Cordillera Adminsitrative Region (CAR)" && "Cordillera Administrative Region (CAR)" || d.region === "Autonomous Region in Muslim Mindanao/ Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)" && "Autonomous Region in Muslim Mindanao/Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)" || d.region) }) // Calculate amount including how many are you in the family .derive({ amountMonthly: aq.escape(d => d.amountMonthly * rangePerson) }) // Remove amountAnnual to avoid confusion .select(aq.not("amountAnnual")) .derive({ region: aq.escape(d => d.region === "Autonomous Region in Muslim Mindanao/Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)" ? "Bangsamoro (BARMM/ARMM)" : d.region) }) .objects() }31:T423,swsThresh = aq.from(swsThreshRaw) .fold(swsThreshInds.slice(2)) .rename({ key: "indicator", value: "amount" }) .derive({ year: aq.escape(d => d.date.split(" ")[1]), amount: aq.escape(d => +d.amount.replaceAll(",", "")) }) .groupby("group", "indicator", "year") // Get median values for every year .rollup({ amount: op.median("amount") }) // Rename Metro Manila as NCR to match data with PSA .derive({ group: aq.escape(d => d.group === "Metro Manila" ? "NCR" : d.group) }) .filter(d => d.group !== "Philippines") .orderby("group", "indicator", "year").reify() .relocate( "year", { before: "indicator" }) // Clearly define that the amount is monthly .rename({ amount: "amountMonthly" }) // SWS has no median number of household estimate, setting 4 as median from PSA // If so, calculate amount monthly per capita first and multiply with how many // family members from user's input .derive({ amountMonthly: aq.escape(d => Math.round((d.amountMonthly / rangeSwsMeanMembers) * rangePerson)) }) .objects()32:T4e1,psaRegGroupThreshStack = { const foodThreshStack = psaThresh .filter(d => d.indicator === "subpov_annual_percap_thresh") const povThreshStack = aq.from(psaThresh) .filter(d => d.indicator === "pov_annual_percap_thresh") .derive({ amountMonthly: aq.escape(d => { const { amountMonthly: subpovAmountMonthly } = psaThresh.find(e => e.indicator === "subpov_annual_percap_thresh" && e.region === d.region && e.year === d.year) return d.amountMonthly - subpovAmountMonthly })}) const maxThresStack = aq.from(psaThresh) .filter(d => d.indicator === "pov_annual_percap_thresh") .derive({ amountMonthly: aq.escape( d => psaSwsAmtExtent[1] - (d.amountMonthly)), indicator: d => "max_annual_percap_thresh", }) return aq.from(foodThreshStack) .concat(povThreshStack) .concat(maxThresStack) .filter(aq.escape(d => d.year === currentYear)) // .derive({ // region: aq.escape(d => d.region === "Autonomous Region in Muslim Mindanao/Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)" ? "BARMM/ARMM" : d.region) // }) .objects() }33:[{"id":"41d9ba66f4b9a6b4f94d99119e50d684abc2a788e35a2fcd0c0696ee54202527226cc478d5733f65e3eca2b8cedb8e77b18605faa746a30d907a05384b0b50a6","href":"https://static.observableusercontent.com/files/41d9ba66f4b9a6b4f94d99119e50d684abc2a788e35a2fcd0c0696ee54202527226cc478d5733f65e3eca2b8cedb8e77b18605faa746a30d907a05384b0b50a6","name":"TABLE C. Household Population, Number of Households,.webp","type":"image/webp","lastModified":1678397764928.662,"size":100292},{"id":"37d69c62f64a23b0421984d17dac5bc094591a473e2d48bc7be32519b4e68c58d44acd6c88dfc9c148147a4f2d3bb16fe1f8231fe988403439140e410bfea844","href":"https://static.observableusercontent.com/files/37d69c62f64a23b0421984d17dac5bc094591a473e2d48bc7be32519b4e68c58d44acd6c88dfc9c148147a4f2d3bb16fe1f8231fe988403439140e410bfea844","name":"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_household.csv","type":"text/csv","lastModified":1678522244417.828,"size":1170},{"id":"8f5a8e851e87504edea9a79054c2a938facc56a2ea5c8b8f81ffe4df2d106d50b3f5fac91e3deef6706277290a07a348ad1c77be9179b15348f1696eff296e3b","href":"https://static.observableusercontent.com/files/8f5a8e851e87504edea9a79054c2a938facc56a2ea5c8b8f81ffe4df2d106d50b3f5fac91e3deef6706277290a07a348ad1c77be9179b15348f1696eff296e3b","name":"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_subpov_pop (3).csv","type":"text/csv","lastModified":1678341923208.128,"size":1474},{"id":"d29ef881ee5634044cfa0087df5fe0e716bf881c339dc3108da991b0c52bfd863d4507b380f670dbb35574f82531010a12f32cc9ef0f9636d69a3e2d9fb7b3c4","href":"https://static.observableusercontent.com/files/d29ef881ee5634044cfa0087df5fe0e716bf881c339dc3108da991b0c52bfd863d4507b380f670dbb35574f82531010a12f32cc9ef0f9636d69a3e2d9fb7b3c4","name":"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_pov_pop (3).csv","type":"text/csv","lastModified":1678341923211.573,"size":1501},{"id":"c1a27428091fff66c6b560450626c97cc6968f53aaad533cc71d7a7c28edbe0a298a625c0af3ff98fdbe1d95a872ec64e514383a87358f4a797b7bdf5d4ad049","href":"https://static.observableusercontent.com/files/c1a27428091fff66c6b560450626c97cc6968f53aaad533cc71d7a7c28edbe0a298a625c0af3ff98fdbe1d95a872ec64e514383a87358f4a797b7bdf5d4ad049","name":"Analysis on Poverty_ PSA (Government) vs SWS (Private) - sws_pov_selfrated_thresh (1).csv","type":"text/csv","lastModified":1678341923243.228,"size":4665}] 2d:{"title":"🏛️ Through the Government's Lens: Am I Seen as Living in Poverty","cells":[{"id":0,"value":"# 🏛️ Through the Government's Lens: Am I Seen as Living in Poverty","pinned":false,"hidden":false,"mode":"md"},{"id":1078,"value":"The Philippine government establishes thresholds to categorize individuals as poor, food poor, or not poor. These classifications are crucial for directing financial aid to those who need it most.\n\nHowever, if these thresholds are set too low and don't reflect the true cost of living, many people in need might be excluded from essential programs like the [Pantawid Pamilyang Pilipino Program (4Ps)](https://pantawid.dswd.gov.ph/about/).\n\nIf a family facing financial difficulties but don't qualify as \"poor\" according to government standards, the charts below simulates the discrepancies.","pinned":false,"hidden":false,"mode":"md"},{"id":698,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":168,"value":"## Let's imagine you are a family in the Philippines","pinned":false,"hidden":false,"mode":"md"},{"id":93,"value":"viewof rangePerson = Inputs.range([1, 15], {label: \"How many people are in your household?\", step: 1, value: 5})","pinned":false,"hidden":false,"mode":"ojs"},{"id":68,"value":"viewof selectRegion = Inputs.select(regionsList, {label: \"Select the region where your family lives:\", value: \"Bangsamoro (BARMM/ARMM)\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1090,"value":"html`

With ${rangePerson} family members in your household currently living in ${selectRegion},

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"viewof radiosPoorAssess = Inputs.radio([\"Food Poor\", \"Poor\", \"Not Poor\", \"Not Sure\"], {label: \"How would you classify your family’s economic status?\", value: \"Not Sure\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"viewof rangeIncome = Inputs.range([0, psaSwsAmtExtent[1]], {label: \"What is your monthly family income in Philippine Pesos (₱)\", step: 100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":696,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1221,"value":"## How Did The Government Classified Your Family","pinned":false,"hidden":false,"mode":"md"},{"id":1223,"value":"html`

Based on the data for ${radiosScope === \"region\" ? selectRegion : getGroup(selectRegion)} from the Philippine Statistics Authority (PSA), the government see you as ${psaStatus}, while the public (self-rated SWS survey) sees you as ${swsStatus}.

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":628,"value":"viewof radiosScope = Inputs.radio([\"region\", \"island group\"], {label: \"Instead, compare as\", value: \"region\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1243,"value":"#### PSA monthly income thresholds for ${radiosScope === \"region\" ? selectRegion : getGroup(selectRegion)}","pinned":false,"hidden":false,"mode":"md"},{"id":247,"value":"{ \n return Plot.plot({\n marks: [\n Plot.barX(psaThreshStack, {\n x: \"amountMonthly\",\n fill: \"indicator\",\n fillOpacity: 1\n }),\n Plot.ruleX(psaThreshFilt, {\n x: \"amountMonthly\",\n stroke: \"white\",\n strokeWidth: 2,\n }),\n Plot.ruleX([rangeIncome], {\n stroke: \"black\",\n strokeWidth: 7,\n }),\n Plot.text([{amountMonthly: rangeIncome}], {\n x: \"amountMonthly\",\n dy: -30,\n fontSize: 16,\n text: d => `Your family income: Php ${d.amountMonthly}`\n }),\n ],\n color: {\n type: \"ordinal\",\n range: [\"grey\", \"orange\", \"red\"],\n legend: true\n },\n width: 700,\n height: 90,\n marginTop: 50\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":558,"value":"#### Social Weather Survey monthly income thresholds for ${getGroup(selectRegion)}","pinned":false,"hidden":false,"mode":"md"},{"id":546,"value":"{ \n return Plot.plot({\n marks: [\n Plot.barX(swsThreshStack, {\n x: \"amountMonthly\",\n fill: \"indicator\",\n fillOpacity: 1\n }),\n Plot.ruleX(swsThreshFilt, {\n x: \"amountMonthly\",\n stroke: \"white\",\n strokeWidth: 2,\n }),\n Plot.ruleX([rangeIncome], {\n stroke: \"black\",\n strokeWidth: 7,\n }),\n Plot.text([{amountMonthly: rangeIncome}], {\n x: \"amountMonthly\",\n dy: -30,\n fontSize: 16,\n text: d => `Your family income: Php ${d.amountMonthly}`\n }),\n ],\n color: {\n type: \"ordinal\",\n range: [\"red\", \"grey\", \"orange\"],\n // legend: true\n },\n width: 700,\n height: 90,\n marginTop: 50\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":597,"value":"viewof rangeSwsMeanMembers = Inputs.range([1, 8], {label: \"*Arbitrary average number of family members\", step: 1, value: 4})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1180,"value":"*In order to compute for per capita data for SWS, we introduce an arbitrary mean number of family in a household to match the estimated per capita values from the PSA data.","pinned":false,"hidden":false,"mode":"md"},{"id":726,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":742,"value":"## Your Monthly Family Income Compared to Other Regions","pinned":false,"hidden":false,"mode":"md"},{"id":892,"value":"viewof rangeIncomeComp = Inputs.range([0, psaSwsAmtExtent[1]], {label: \"Monthly Family Income in Philippine Pesos (₱)\", step: 100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":979,"value":"### Government Comparison","pinned":false,"hidden":false,"mode":"md"},{"id":1310,"value":"Your family’s income is compared against regional data from the Philippine Statistics Authority (PSA):","pinned":false,"hidden":false,"mode":"md"},{"id":746,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":982,"value":"### Public Perception Comparison","pinned":false,"hidden":false,"mode":"md"},{"id":1313,"value":"Your family’s income is also compared with public perception data from Social Weather Stations (SWS), categorized by island group:","pinned":false,"hidden":false,"mode":"md"},{"id":844,"value":"{ \n return Plot.plot({\n marks: [\n Plot.barX(swsRegGroupThreshStack, {\n x: \"amountMonthly\",\n y: \"group\",\n fill: \"indicator\",\n fillOpacity: d => d.group === getGroup(selectRegion) ? 1 : 0.5\n }),\n Plot.ruleX([rangeIncomeComp], {\n stroke: \"black\",\n strokeWidth: 2,\n }),\n Plot.text([{amountMonthly: rangeIncomeComp}], {\n x: \"amountMonthly\",\n dy: -55,\n fontSize: 16,\n text: d => `Your family income: Php ${d.amountMonthly}`\n }),\n ],\n y: {\n domain: d3.sort(swsRegGroupThreshStack.filter(d => d.indicator === \"food_pov_thresh\"), d => d.amountMonthly).map(d => d.group)\n },\n color: {\n type: \"ordinal\",\n range: [\"red\", \"grey\", \"orange\"],\n legend: true\n },\n width: 700,\n height: 150,\n marginLeft: 250,\n marginTop: 30,\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1138,"value":"Unfortunately, the publicly available government data is aggregated and only provided at the regional level. While it is possible to request more detailed data, shouldn't these fundamental poverty statistics for local communities be readily accessible to the public?","pinned":false,"hidden":false,"mode":"md"},{"id":1320,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":606,"value":"### Methods and Notes on Data Processing\n- SWS Data: The Social Weather Stations (SWS) did not specify the average number of family members used in their self-rated survey thresholds.\n- Data Conversion: To align SWS data with PSA data, the poverty thresholds from the SWS survey were converted to per capita values using the average household size provided by PSA.\n- Uniform Comparison: Your provided household size was then used to adjust the monthly income figures, ensuring consistency and comparability across both data sources.","pinned":false,"hidden":false,"mode":"md"},{"id":1160,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"This notebook continues the analysis of poverty data from the Philippine Statistics Authority (PSA) and Social Weather Station (SWS). It builds on the exploration started in [Does the Government See Me? Assessing Poverty in the Philippines Through Transparency and Accountability](https://observablehq.com/d/9882318ab0ad1287).","pinned":false,"hidden":false,"mode":"md"},{"id":1294,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":18,"value":"## Data Cleanup and Derivations","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"### Raw data","pinned":false,"hidden":false,"mode":"md"},{"id":21,"value":"psaPovThreshRaw = analysisOnPoverty_PsaGovernmentVsSwsPrivatePsa_pov","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"psaSubpovThreshRaw = analysisOnPoverty_PsaGovernmentVsSwsPrivatePsa_sub","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"swsThreshRaw = analysisOnPoverty_PsaGovernmentVsSwsPrivateSws_pov","pinned":false,"hidden":false,"mode":"ojs"},{"id":174,"value":"#### PSA thresholds data","pinned":false,"hidden":false,"mode":"md"},{"id":145,"value":"psaPovThreshInds = Object.keys(psaPovThreshRaw[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":155,"value":"psaSubpovThreshInds = Object.keys(psaSubpovThreshRaw[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":130,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"regionsList = [...new Set(psaThresh.map(d => d.region))]\n .filter(reg => reg !== \"PHILIPPINES\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":177,"value":"#### SWS thresholds data","pinned":false,"hidden":false,"mode":"md"},{"id":184,"value":"swsThreshInds = Object.keys(swsThreshRaw[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":179,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"### Data for Self-Assessment Tool","pinned":false,"hidden":false,"mode":"md"},{"id":552,"value":"#### Data for PSA chart","pinned":false,"hidden":false,"mode":"md"},{"id":278,"value":"psaThreshFilt = {\n if(radiosScope === \"region\"){\n return psaThresh\n .filter(d => d.region === selectRegion && d.year === currentYear)\n .map(({amountAnnual, ...d}) => { return {...d} })\n }\n else return aq.from(psaThresh\n .filter(d => d.group === getGroup(selectRegion) && d.year === currentYear))\n .groupby(\"group\", \"year\", \"indicator\")\n .rollup({ amountMonthly: op.median(\"amountMonthly\") })\n .objects()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":280,"value":"psaAmtExtent = d3.extent(psaThresh, d => d.amountMonthly)","pinned":false,"hidden":false,"mode":"ojs"},{"id":296,"value":"psaThreshStack = { \n const foodThreshStack = psaThreshFilt\n .find(d => d.indicator === \"subpov_annual_percap_thresh\")\n const povThreshStack = aq.from(psaThreshFilt.filter(d => d.indicator === \"pov_annual_percap_thresh\"))\n .derive({ \n amountMonthly: aq.escape( d => d.amountMonthly - foodThreshStack.amountMonthly) \n })\n .object()\n const maxThresStack = aq.from(psaThreshFilt.filter(d => d.indicator === \"pov_annual_percap_thresh\"))\n .derive({\n amountMonthly: aq.escape( d => psaSwsAmtExtent[1] - (povThreshStack.amountMonthly + foodThreshStack.amountMonthly)),\n indicator: d => \"max_annual_percap_thresh\"\n })\n .object()\n\n return aq.from([foodThreshStack, povThreshStack, maxThresStack])\n .objects()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":486,"value":"psaThreshVals = psaThreshFilt\n .map(d => d.amountMonthly)\n .sort((a, b) => a - b)","pinned":false,"hidden":false,"mode":"ojs"},{"id":493,"value":"psaStatus = rangeIncome <= psaThreshVals[0] && \"Food poor\" ||\n rangeIncome <= psaThreshVals[1] && \"Poor\" ||\n \"Not poor\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":555,"value":"#### Data for SWS chart","pinned":false,"hidden":false,"mode":"md"},{"id":511,"value":"regionGroupRef = aq.from(psaThresh)\n .groupby(\"group\", \"region\")\n .rollup()\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":518,"value":"getGroup = (region) => regionGroupRef.find(r => r.region === region).group","pinned":false,"hidden":false,"mode":"ojs"},{"id":529,"value":"swsAmtExtent = d3.extent(swsThresh, d => d.amountMonthly)","pinned":false,"hidden":false,"mode":"ojs"},{"id":508,"value":"swsThreshFilt = swsThresh\n .filter(d => d.group === getGroup(selectRegion) && d.year === currentYear)","pinned":false,"hidden":false,"mode":"ojs"},{"id":534,"value":"swsThreshStack = { \n const foodThreshStack = swsThreshFilt\n .find(d => d.indicator === \"food_pov_thresh\")\n const povThreshStack = aq.from(swsThreshFilt.filter(d => d.indicator === \"pov_thresh\"))\n .derive({ \n amountMonthly: aq.escape( d => d.amountMonthly - foodThreshStack.amountMonthly) \n })\n .object()\n const maxThresStack = aq.from(swsThreshFilt.filter(d => d.indicator === \"pov_thresh\"))\n .derive({\n amountMonthly: aq.escape( d => psaSwsAmtExtent[1] - (povThreshStack.amountMonthly + foodThreshStack.amountMonthly)),\n indicator: d => \"max_thresh\"\n })\n .object()\n\n return aq.from([foodThreshStack, povThreshStack, maxThresStack])\n .objects()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":567,"value":"swsThreshVals = swsThreshFilt\n .map(d => d.amountMonthly)\n .sort((a, b) => a - b)","pinned":false,"hidden":false,"mode":"ojs"},{"id":565,"value":"swsStatus = rangeIncome <= swsThreshVals[0] && \"Food poor\" ||\n rangeIncome <= swsThreshVals[1] && \"Poor\" ||\n \"Not poor\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":581,"value":"#### Data for both charts","pinned":false,"hidden":false,"mode":"md"},{"id":583,"value":"psaSwsAmtExtent = [Math.min(...psaAmtExtent, ...swsAmtExtent),\n Math.max(...psaAmtExtent, ...swsAmtExtent)]","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"Based on the most recent 2021 poverty statistics by PSA and 2021 self-rated survey by SWS","pinned":false,"hidden":false,"mode":"md"},{"id":953,"value":"### Data for Region/Island Group Comparison","pinned":false,"hidden":false,"mode":"md"},{"id":761,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":822,"value":"swsRegGroupThreshStack = { \n const foodThreshStack = swsThresh\n .filter(d => d.indicator === \"food_pov_thresh\")\n\n const povThreshStack = aq.from(swsThresh)\n .filter(d => d.indicator === \"pov_thresh\")\n .derive({ amountMonthly: aq.escape(d => {\n const { amountMonthly: foodpovAmountMonthly } = swsThresh.find(e => e.indicator === \"food_pov_thresh\" && \n e.group === d.group && \n e.year === d.year)\n return d.amountMonthly - foodpovAmountMonthly\n })})\n\n const maxThresStack = aq.from(swsThresh)\n .filter(d => d.indicator === \"pov_thresh\")\n .derive({\n amountMonthly: aq.escape( d => psaSwsAmtExtent[1] - d.amountMonthly),\n indicator: d => \"max_annual_percap_thresh\",\n })\n\n return aq.from(foodThreshStack)\n .concat(povThreshStack)\n .concat(maxThresStack)\n .filter(aq.escape(d => d.year === currentYear))\n .objects()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":708,"value":"### Constants","pinned":false,"hidden":false,"mode":"md"},{"id":306,"value":"currentYear = \"2021\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1045,"value":"BARMM_FULLNAME = \"Autonomous Region in Muslim Mindanao/Bangsamoro Autonomous Region in Muslim Mindanao (ARMM/BARMM)\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"## Data Tables","pinned":false,"hidden":false,"mode":"md"},{"id":729,"value":"analysisOnPoverty_PsaGovernmentVsSwsPrivatePsa_pov = await FileAttachment(\"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_pov_pop (3).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"analysisOnPoverty_PsaGovernmentVsSwsPrivatePsa_sub = await FileAttachment(\"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_subpov_pop (3).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"analysisOnPoverty_PsaGovernmentVsSwsPrivateSws_pov = await FileAttachment(\"Analysis on Poverty_ PSA (Government) vs SWS (Private) - sws_pov_selfrated_thresh (1).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1060,"value":"### PSA Household Population, Count and Size","pinned":false,"hidden":false,"mode":"md"},{"id":1058,"value":"analysisOnPoverty_PsaGovernmentVsSwsPrivatePsa_hou = await FileAttachment(\"Analysis on Poverty_ PSA (Government) vs SWS (Private) - psa_household.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":123,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":127,"value":"d3 = require('d3@6')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}