--------------------------------------------- # Metropolitan Geographic Definitions and Code for "Geographies of Insecure Water Access and the Housing-Water Nexus in U.S. Cities." Preferred citation: Meehan, Katie; Jason R. Jurjevich; Nicholas M.J.W. Chun, and Justin Sherrill (2020): Metropolitan Geographic Definitions and Code for "Geographies of Insecure Water Access and the Housing-Water Nexus in U.S. Cities." Tucson, AZ: University of Arizona Research Data Repository. https://doi.org/10.25422/azu.data.12456536 Corresponding Author: Katie Meehan, Department of Geography, King's College London, katie.meehan@kcl.ac.uk License: CC BY 4.0 (data) MIT (code) DOI: https://doi.org/10.25422/azu.data.12456536 --------------------------------------------- # Summary Safe, reliable, and equitable water access is critical to human health and livelihoods. In this study, we undertake the first systematic and comprehensive analysis of household piped water access in the United States, with the aim of explaining drivers of infrastructural inequality in the 50 largest metropolitan areas. Drawing on statistical analysis and regression modeling of U.S. census microdata at the household scale, our analysis reveals spatial and sociodemographic patterns of racialized, class-based, and housing disparities that characterize plumbing poverty across metropolitan areas. This dataset includes relevant supplemental data for our manuscript titled, "Geographies of Insecure Water Access and the Housing-Water Nexus in U.S. Cities" (forthcoming, PNAS). Here, we present customized Public Use Microdata Sample (PUMS) definitions used in our study that make U.S. Metropolitan Statistical Area (MSA) geographies comparable over time, as well as the accompanying R code for statistical analysis of census microdata and the creation of spatial visualizations. Important points - License for the geographic definitions and code can be found in the License_data.txt file. - The code runs on R. License for the code can be found in License_code.txt file. --------------------------------------------- # Files **GeographicDefintions.csv** - Dataset contains customized Public Use Microdata Sample (PUMS) definitions used in our study that make U.S. Metropolitan Statistical Area (MSA) geographies comparable over time. "metro" - numeric identifier for each MSA - The identifier is based on the 1999 Office of Management and Budget (OMB) standards (https://www2.census.gov/programs-surveys/metro-micro/geographies/reference-files/1999/historical-delineation-files/99mfips.txt) "metro_name" - name of each MSA "st_puma" - combined state + Public Use Microdata Area (PUMA) Federal Information Processing Standards (FIPS) geographic codes - Numeric identifiers based on the delineation following the 2010 decennial census (https://www.census.gov/geographies/reference-maps/2010/geo/2010-pumas.html) **state_list.csv** - List of states used call tract-level information to create the index of dissimilarity estimates for the top-50 metros. **h_model_2017_5yr.rds, p_model_2017_5yr.rds** - model data in R-Studio object format **PlumbingPoverty_2017_edit.R** - Contains the accompanying R code for statistical analysis of census microdata and the creation of spatial visualizations. The code produces the results for figure 1 and tables 1, 2 and 3.