[MI/URSA-CORE] Census Tract Reference

Prev Next

Object Description

One row per census tract FIPS code.

The sources for this object are the CDC Census Tract Social Vulnerability Index Data, the Census Tract Reference FIPS Codes, and the HUD USPS Zip Code Crosswalk Files

Ursa Studio Update Cadence: Annually

Metadata

  • Table Name: ursa.mi_ursa_core_143
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Ursa Reference
  • Temporal Class: Entity
  • Case ID: Census Tract FIPS Code
  • Primary Key: Census Tract FIPS Code

Published Fields

  • Location Fields
    • Census Tract FIPS Code
    • Census Tract Description
    • ZIP Code with Highest Percentage of Residences Contributed -- Given a census tract, identifies the ZIP Code with the highest percentage of its residences contributed by that census tract. NB: even a census tract completely contained by a ZIP Code could have a low value if other census tracts' contributions are much larger.
    • Census Tract Percentage of ZIP Code Residences
    • County FIPS Code
    • County Description
    • State Abbreviation
    • State Description
    • Census ACS Population
    • Census ACS Percentage Below Poverty
    • Census ACS Unemployment Rate
    • Census ACS Per Capita Income
    • Census ACS Percentage Without HS Diploma
    • Census ACS Percentage Aged 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)