[MI/URSA-CORE] ZIP Code Reference

Prev Next

Object Description

One record per 5-digit ZIP code.

The sources for this object are the Dartmouth Atlas Project, the US Census ZIP Code Tabulation Areas, CDC Census Tract Social Vulnerability Index Data, the Census Tract Reference FIPS Codes, the UW HIP Area Deprivation Index, and the HUD USPS Zip Code Crosswalk Files

Ursa Studio Update Cadence: Annually

Metadata

  • Table Name: ursa.mi_ursa_core_113
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Ursa Reference
  • Temporal Class: Entity
  • Case ID: ZIP Code 5-Digit
  • Primary Key: ZIP Code 5-Digit

Published Fields

  • Location Fields

    • ZIP Code 5-Digit
    • County FIPS Code
    • County Description
    • CBSA Code
    • Dartmouth Atlas HSA ID
    • Dartmouth Atlas HRR ID
    • Dartmouth Atlas HSA Description -- A Hospital Service Area (HSA) represents a local healthcare market for inpatient hospital care. Each HSA is defined by aggregating ZIP codes where the majority of residents receive hospitalizations from a particular group of hospitals. There are approximately 3,436 HSAs in the United States. HSAs are constructed to reflect actual patient utilization patterns for routine and emergency hospital services, making them useful for studying local variations in healthcare access and delivery.
    • Dartmouth Atlas HRR Description -- A Hospital Referral Region (HRR) defines a regional healthcare market for tertiary and complex medical care, such as major cardiovascular procedures and neurosurgeries. HRRs are formed by grouping together HSAs based on where patients within those areas travel to receive specialized care. There are approximately 306 HRRs in the United States. These regions are designed to capture patterns of referral and are useful for evaluating access to specialized services and system-level healthcare delivery across broader geographic areas.
    • Dartmouth Atlas HSA City
    • Dartmouth Atlas HRR City
    • Dartmouth Atlas HSA State Abbreviation
    • Dartmouth Atlas HRR State Abbreviation
    • Census Latitude
    • Census Longitude
    • Census Boundary Coordinates JSON
    • Mean UW HIP Area Deprivation Index National Percentile -- A value between 1 and 100 representing the composite measure of socioeconomic deprivation from University of Wisconsin’s School of Medicine and Public Health. Scores are for Census Block Group geographic level, which generally contains between 600 and 3,000 people. Higher scores indicate more deprivation, so a score of 1 indicates the least deprivation while a score of 100 indicates the most deprivation. Percentiles are constructed by ranking the ADI from low to high for the nation and grouping the block groups into bins corresponding to each 1% range of the ADI. The 2019 ADI was constructed using the 2015-2019 5-year estimates from the US Census' American Community Survey and includes 17 component measures that span the domains of income, education, employment, and housing quality. It may be linked with the 9-digit ZIP code crosswalk, which was built to correspond directly to Census block groups. The 2019 ADI was released on 07/14/2021 and is the most recent version as of 02/02/22.
    • Census ACS Percentage Below Poverty
    • Census ACS Unemployment Rate
    • Census ACS Per Capita Income
    • Census ACS Percentage Without HS Diploma
    • Census ACS Percentage 65 and Older
    • Census ACS Percentage Aged 17 and Younger
    • Census ACS Percentage with Disability
    • Census ACS Percentage Single-Parent Households
    • Census ACS Percentage Minority
    • Census ACS Percentage Speak English Less Than Well
    • Census ACS Percentage Households Without Vehicle
    • Census ACS Percentage Uninsured
    • CDC SVI Overall National Percentile -- Social Vulnerability Index is a composite score maintained by the Center for Disease Control and Prevention using data from the U.S. Census of Population and Housing. The score is a composite of 15 measures, with all directed so that higher values indicate more vulnerability. The composite finds the percentile ranking of each component value, sums the percentile rankings, and then finds the percentile ranking of the sums. Percentile ranks are found with the formula: Percentile Rank = (Rank-1) / (N-1). If any component is missing, then the composite is also recoded as missing. Measures are organized into the four themes of Socioeconomic Status, Household Composition & Disability, Minority Status & Language, and Housing Type & Transportation, and composites for these themes are constructed with the same methodology. SVI is reported at the Census Tract level. Tracts aim to include about 4000 people each. On average, there are about 4 Census Block groups for each Census Tract, so the SVI has less geographic resolution than the ADI. Ursa stores the 2018 version of the SVI, which was released on 01/31/2020 and is the most recent as of 02/02/22. (See also [URSA-CORE] CDC SVI Overall Quintile Category)
    • CDC SVI Socioeconomic Theme National Percentile
    • CDC SVI Household / Disability Theme National Percentile
    • CDC SVI Minority / Language Theme National Percentile -- Includes the two Census measures of (1) Percent minority (all persons except white, non-Hispanic), (2) Percent who speak English "less than well" (persons age 5+). Follows the same methodology as the overall SVI composite. (See also [URSA-CORE] CDC SVI Minority / Language Quintile Category, [URSA-CORE] CDC SVI Overall National Percentile)
    • CDC SVI Housing / Transportation Theme National Percentile -- Includes the five Census measures of (1) Percent housing structures with 10 or more units, (2) Percent mobile homes, (3) Percent households with more people than rooms, (4) Percent households with no vehicle available, (5) Percent living in group quarters (such as correctional facilities, nursing homes, college dorms, and military barracks). Follows the same methodology as the overall SVI composite. (See also [URSA-CORE] CDC SVI Housing / Transportation Quintile Category, [URSA-CORE] CDC SVI Overall National Percentile)
  • Metadata Fields

    • Fraction ZIP Code Residential in County
    • Fraction ZIP Code Residential in CBSA