Mapping Asthma Onto Housing: A Population Health Proposal That Links Clinical Data and Code Violations to Target Home-Based Asthma Care
[Student Name]
University of Phoenix
NSG/507: Social Justice and Information Systems for Population Health
Week 6 Assignment
[Instructor Name]
[Date]
The city, health system and figures are a composite written for a model paper.
Children's asthma is often treated as a problem of lungs and inhalers. For a composite pediatric nurse practitioner in a midsized city, the pattern in her clinic suggested something else. The same children returned to the emergency department again and again despite correct controller prescriptions, and many lived on a handful of streets in older rental housing. When she asked families about their homes, she heard about mold on bedroom walls, leaking pipes and cockroaches that returned after every spray. Her prescriptions were right for the child in the exam room and wrong for the apartment the child went home to. This paper proposes linking the health system's clinical data with the city's housing records to find where housing is driving asthma, and using that information to deliver home-based care and to support housing enforcement.
The Inequity
Asthma burden in the city falls unevenly. Emergency department visits for asthma among children in the three lowest-income zip codes occur at more than three times the rate of the city as a whole, and most of those children are Black or Latino. Much of the city's oldest rental housing is concentrated in the same neighborhoods. These patterns reflect a social determinant, housing quality, that is shaped by landlord investment, code enforcement and decades of housing policy rather than by family choices, the kind of upstream condition that Braveman and Gottlieb (2014) described as the causes of the causes. A response that treats each child's asthma only in the clinic leaves the cause untouched.
What Linked Data Can Show
Clinical data alone show which children have asthma and how often they use emergency care. Housing data alone show which buildings have violations. Linked, they can show whether the two occur in the same places. Beck et al. (2014), working in Cincinnati, geocoded pediatric asthma emergency visits and hospitalizations and linked them with the density of housing code violations by census tract. Tracts with higher violation density had significantly higher rates of asthma-related emergency visits and hospitalizations, even after accounting for poverty, which suggested that housing conditions contribute to asthma morbidity beyond income alone. The study also showed that such linkage is feasible with data that cities and health systems already hold.
Data Design and Privacy Safeguards
The proposal has four data steps, led by the nurse practitioner with the health system's population health analytics team and the city's housing department.
First, extraction. The analytics team identifies children aged 2 to 17 with an asthma diagnosis and at least one asthma-related emergency visit or hospitalization in the past two years, using the electronic health record.
Second, geocoding. Home addresses are converted to geographic coordinates and census tracts inside the health system's secure environment, and addresses are then removed from the analytic file.
Third, linkage. The city's open data portal provides housing code violations by address, category and date. Violations related to moisture, mold, pests and ventilation are counted per rental unit for each census tract.
Fourth, mapping. The team produces maps at the census tract level showing asthma emergency visit rates and violation density, with no individual patient locations displayed.
Privacy protections are built in. The linkage is reviewed by the health system's privacy office and institutional review board under a data use agreement with the city; patient-level data never leave the health system; published maps show only aggregated tract-level rates; and tracts with very small numbers are suppressed so that no child can be identified.
Using the Map to Target Care
The map's purpose is action. Tracts with both high asthma visit rates and high violation density become priority areas for a home-based asthma program. Reviewing the evidence for the federal Community Preventive Services Task Force, Crocker et al. (2011) concluded that home-based, multi-trigger, multicomponent interventions with an environmental focus, which combine home visits, education about triggers and remediation such as pest control, mattress covers and moisture repair, reduced asthma symptom days, school days missed and acute care visits among children.
In the priority tracts, a community health worker and an asthma educator will visit families of children with recent emergency visits, assess the home for triggers, provide supplies such as allergen-proof bedding and integrated pest management materials and teach families about medications and triggers. The nurse practitioner reviews each child's treatment plan in light of the home findings. When a visit finds conditions that violate the housing code, the family is offered help from a medical-legal partnership, which can contact the landlord or request a city inspection with the family's consent.
From Data to Policy
The aggregated maps also serve advocacy. The nurse practitioner and the health system's community benefit office will present the findings to the city council's housing committee, showing where asthma burden and housing violations overlap. The goal is to support proactive rental inspection in priority tracts, rather than inspections only after tenant complaints, which many families avoid for fear of retaliation or eviction. Data from a health system carry weight with policy makers because they connect housing conditions to measurable health costs.
Engaging the Community in the Map
Maps of disease can stigmatize neighborhoods if they are presented without the people who live there. Before any findings go to the city council, the nurse practitioner will share the tract-level maps with a tenants' association and two neighborhood organizations in the priority areas, asking whether the patterns match residents' experience and how the findings should be framed. Residents may add knowledge the data lack, such as which buildings changed owners recently or where tenants are afraid to complain. Framing the map as evidence of housing neglect rather than of unhealthy neighborhoods keeps responsibility on the conditions and the institutions that control them, not on the families who live with them. Community review also builds the trust families will need before they open their doors to home visitors.
Evaluation
The program will be evaluated at two levels. For enrolled children, measures include asthma emergency visits and hospitalizations in the year before and after enrollment, symptom-free days and school days missed. For the population, the maps will be updated annually to track asthma visit rates in priority tracts compared with other tracts, and the housing department will report changes in violation resolution times. Equity will be assessed by comparing changes across neighborhoods and by race and ethnicity, since the program's purpose is to reduce the gap, not only the overall rate.
Limits
The study design shows association, not causation, and families may move, which complicates tract-level tracking. Violation data depend on complaints and inspections, so neighborhoods where tenants fear reporting may appear healthier than they are. These limits argue for combining the map with home visit findings, which record conditions directly.
Conclusion
Children's asthma in this city follows housing, and housing follows social and economic history. Linking clinical data with housing code records turns that pattern into a map that shows where to send a home-based asthma program and where to press for enforcement. Built with strong privacy safeguards and evaluated by the gap it closes, the proposal applies information systems to social justice: using data not only to describe who is sick, but to change the conditions that make them sick.
References
Beck, A. F., Huang, B., Chundur, R., & Kahn, R. S. (2014). Housing code violation density associated with emergency department and hospital use by children with asthma. Health Affairs, 33(11), 1993-2002. https://doi.org/10.1377/hlthaff.2014.0496
Braveman, P., & Gottlieb, L. (2014). The social determinants of health: It's time to consider the causes of the causes. Public Health Reports, 129(Suppl. 2), 19-31. https://doi.org/10.1177/00333549141291S206
Crocker, D. D., Kinyota, S., Dumitru, G. G., Ligon, C. B., Herman, E. J., Ferdinands, J. M., Hopkins, D. P., Lawrence, B. M., & Sipe, T. A. (2011). Effectiveness of home-based, multi-trigger, multicomponent interventions with an environmental focus for reducing asthma morbidity: A community guide systematic review. American Journal of Preventive Medicine, 41(2 Suppl. 1), S5-S32. https://doi.org/10.1016/j.amepre.2011.05.012
How this NSG 507 Week 6 example is structured
The NSG/507 library guide has no separate Week 6 tab, and the course combines social justice with information systems for population health, so this final-week model is a proposal that uses both. It starts with the inequity, shows how linked data reveal a cause that clinical data alone miss, sets out the data design with its privacy safeguards, chooses an evidence-based intervention and closes with evaluation and the policy use of the findings, so the paper moves from data to justice rather than stopping at a map. Students search this week as NSG 507 Week 6, NSG507 Wk 6 or NSG/507 Wk 6; all three are the same assignment.
NSG/507 Week 6 questions, answered
What does NSG/507 Week 6 usually ask for?
The NSG/507 library guide has no separate Week 6 tab, so read your week's instructions closely. Many final-week prompts in this course ask for a proposal or synthesis that applies information systems to a population health problem shaped by social determinants and health equity.
Can clinical data be combined with public records?
Yes, if it is done under a proper data agreement and privacy review. Public housing code records are not health information, and clinical data can be aggregated to census tracts or geocoded under HIPAA-compliant procedures so that no individual patient is identifiable on the map.
Why use a map instead of a table?
Because place is part of the cause. A map shows clusters where housing problems and asthma visits overlap, which helps decision makers see where to act and makes the case for resources more persuasive than a list of numbers.
Write yours, or have the desk draft it
This paper is an original model document written by our desk, not a submitted student paper and not an official University of Phoenix document. Read it for the moves, then write your own to the instructions in your classroom. If you want one built to your exact prompt and rubric, the first custom sample is free and arrives in 24 to 48 hours.