Abstract

ADI: An index of socioeconomic status for communities. Dataset ingested directly from BigQuery.

Documentation

The Area Deprivation Index (ADI) can show where areas of deprivation and affluence exist within a community. The ADI is calculated with 17 indicators from the American Community Survey (ACS) having been well-studied in the peer-reviewed literature since 2003, and used for 20 years by the Health Resources and Services Administration (HRSA). High levels of deprivation have been linked to health outcomes such as 30-day hospital readmission rates, cardiovascular disease deaths, cervical cancer incidence, cancer deaths, and all-cause mortality. The 17 indicators from the ADI encompass income, education, employment, and housing conditions at the Census Block Group level.

The ADI is available on BigQuery for release years 2018-2020 and is reported as a percentile that is 0-100% with 50% indicating a "middle of the nation" percentile. Data is provided at the county, ZIP, and Census Block Group levels. Neighborhood and racial disparities occur when some neighborhoods have high ADI scores and others have low scores. A low ADI score indicates affluence or prosperity. A high ADI score is indicative of high levels of deprivation. Raw ADI scores and additional statistics and dataviz can be seen in this ADI story with a BroadStreet free account.

Dataset source: https://help.broadstreet.io/article/adi/

These datasets provide aggregated community risk scores for exposure to flooding using the First Street Foundation Flood Model (Version 1.3) at the county and zip code level. county_flood_score and zcta_flood_score provide the overall community risk score. county_flood_category_score and zcta_flood_category_score provide the risk score to specific categories of infrastructure. Each category; critical infrastructure, social infrastructure, residential properties, roads, and commercial properties, is a component of the overall community risk.

If you are interested in acquiring First Street flood data, you can request to access the data here. More information on First Street's flood risk statistics can be found here and information on First Street's hazards can be found here.

The following fields are in the overall risk datasets:

Attribute	Description
county_id	The county FIPS code
count	The count (#) of infrastructure facilities
flood_score	A score of 1, 2, 3, 4, or 5 is shown. Community risk rankings represent risk as Minimal, Minor (1), Moderate (2), Major (3), Severe (4) and Extreme (5). Minimal risk is a case where no facilities within a category have flood risk. County level risks are ranked based on how their total depths compare to counties across the country.

The following fields are in the category risk datasets:

Attribute	Description
FIPS	County FIPS code
ZIP_CODE	ZIP code
count	The approximate length of roads (miles) within the geography of aggregation (i.e. ZIP Code, County)
flood_score	A score (Community Risk level) of 0, 1, 2, 3, 4, or 5 is shown. Community risk levels represent risk as Minimal (0), Minor (1), Moderate (2), Major (3), Severe (4) and Extreme (5). Minimal risk is a case where no facilities within a category have flood risk. ZIP Code and County level risks are assessed based on how their total depths compare to ZIP Codes and Counties across the country.
risk_direction	A score of 1, -1, or 0 is shown. These note if flood risk is expected to increase (1), decrease (-1), or remain constant (0) over the next 30 years.

infrastructure_category_id

1= critical infrastructure, 4 = social infrastructure , 6 = residential properties, 8 - roads, 9 = commercial properties

Abstract

This dataset contains tables that match an estimated Gini coefficient to a specific geographic region (either census tract, county, or state) from 2010 to 2018. The 1-year estimates are produced by the American Community Survey (ACS).

Documentation

*The passage below comes from the US Census website:*

GINI INDEX OF INCOME INEQUALITYSurvey/Program: American Community SurveyUniverse: HouseholdsYear: 2018Estimates: 1-YearTable ID: B19083

Source: U.S. Census Bureau, 2018 American Community Survey 1-Year Estimates Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of housing units for states and counties. Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation ). The effect of nonsampling error is not represented in these tables. While the 2018 American Community Survey (ACS) data generally reflect the July 2015 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas, in certain instances the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineations due to differences in the effective dates of the geographic entities. Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on Census 2010 data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization. Explanation of Symbols: Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Technical Documentation section. Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section.

Data SourcesAmerican Community Survey (ACS):Conducted by: U.S. Census BureauDescription: The ACS is an ongoing survey that provides detailed demographic and socio-economic data on the population and housing characteristics of the United States.Content: The survey collects information on various topics such as income, education, employment, health insurance coverage, and housing costs and conditions.Frequency: The ACS offers more frequent and up-to-date information compared to the decennial census, with annual estimates produced based on a rolling sample of households.Purpose: ACS data is essential for policymakers, researchers, and communities to make informed decisions and address the evolving needs of the population.CDC/ATSDR Social Vulnerability Index (SVI):Created by: ATSDR’s Geospatial Research, Analysis & Services Program (GRASP)Utilized by: CDCDescription: The SVI is designed to identify and map communities that are most likely to need support before, during, and after hazardous events.Content: SVI ranks U.S. Census tracts based on 15 social factors, including unemployment, minority status, and disability, and groups them into four related themes. Each tract receives rankings for each Census variable and for each theme, as well as an overall ranking, indicating its relative vulnerability.Purpose: SVI data provides insights into the social vulnerability of communities at both the tract and zip code levels, helping public health officials and emergency response planners allocate resources effectively.Utilization and IntegrationBy integrating data from both the ACS and the SVI, this dataset enables an in-depth analysis and understanding of various socio-economic and demographic indicators at the census tract level. This integrated data is valuable for research, policymaking, and community planning purposes, allowing for a comprehensive understanding of social and economic dynamics across different geographical areas in the United States.ApplicationsTargeted Interventions: Facilitates the development of targeted interventions to address the needs of vulnerable populations within specific zip codes.Resource Allocation: Assists emergency response planners in allocating resources more effectively based on community vulnerability at the zip code level.Research: Provides a rich dataset for academic and applied research in socio-economic and demographic studies at a granular zip code level.Community Planning: Supports the planning and development of community programs and initiatives aimed at improving living conditions and reducing vulnerabilities within specific zip code areas.Note: Due to limitations in the data environment, variable names may be truncated. Refer to the provided table for a clear understanding of the variables. CSV Variable NameShapefile Variable NameDescriptionStateNameStateNameName of the stateStateFipsStateFipsState-level FIPS codeState nameStateNameName of the stateCountyNameCountyNameName of the countyCensusFipsCensusFipsCounty-level FIPS codeState abbreviationStateFipsState abbreviationCountyFipsCountyFipsCounty-level FIPS codeCensusFipsCensusFipsCounty-level FIPS codeCounty nameCountyNameName of the countyAREA_SQMIAREA_SQMITract area in square milesE_TOTPOPE_TOTPOPPopulation estimates, 2013-2017 ACSEP_POVEP_POVPercentage of persons below poverty estimateEP_UNEMPEP_UNEMPUnemployment Rate estimateEP_HBURDEP_HBURDHousing cost burdened occupied housing units with annual income less than $75,000EP_UNINSUREP_UNINSURUninsured in the total civilian noninstitutionalized population estimate, 2013-2017 ACSEP_PCIEP_PCIPer capita income estimate, 2013-2017 ACSEP_DISABLEP_DISABLPercentage of civilian noninstitutionalized population with a disability estimate, 2013-2017 ACSEP_SNGPNTEP_SNGPNTPercentage of single parent households with children under 18 estimate, 2013-2017 ACSEP_MINRTYEP_MINRTYPercentage minority (all persons except white, non-Hispanic) estimate, 2013-2017 ACSEP_LIMENGEP_LIMENGPercentage of persons (age 5+) who speak English "less than well" estimate, 2013-2017 ACSEP_MUNITEP_MUNITPercentage of housing in structures with 10 or more units estimateEP_MOBILEEP_MOBILEPercentage of mobile homes estimateEP_CROWDEP_CROWDPercentage of occupied housing units with more people than rooms estimateEP_NOVEHEP_NOVEHPercentage of households with no vehicle available estimateEP_GROUPQEP_GROUPQPercentage of persons in group quarters estimate, 2014-2018 ACSBelow_5_yrBelow_5_yrUnder 5 years: Percentage of Total populationBelow_18_yrBelow_18_yrUnder 18 years: Percentage of Total population18-39_yr18_39_yr18-39 years: Percentage of Total population40-64_yr40_64_yr40-64 years: Percentage of Total populationAbove_65_yrAbove_65_yrAbove 65 years: Percentage of Total populationPop_malePop_malePercentage of total population malePop_femalePop_femalePercentage of total population femaleWhitewhitePercentage population of white aloneBlackblackPercentage population of black or African American aloneAmerican_indianamerican_iPercentage population of American Indian and Alaska native aloneAsianasianPercentage population of Asian aloneHawaiian_pacific_islanderhawaiian_pPercentage population of Native Hawaiian and Other Pacific Islander aloneSome_othersome_otherPercentage population of some other race aloneMedian_tot_householdsmedian_totMedian household income in the past 12 months (in 2019 inflation-adjusted dollars) by household size – total householdsLess_than_high_schoolLess_than_Percentage of Educational attainment for the population less than 9th grades and 9th to 12th grade, no diploma estimateHigh_schoolHigh_schooPercentage of Educational attainment for the population of High school graduate (includes equivalency)Some_collegeSome_collePercentage of Educational attainment for the population of Some college, no degreeAssociates_degreeAssociatesPercentage of Educational attainment for the population of associate degreeBachelor’s_degreeBachelor_sPercentage of Educational attainment for the population of Bachelor’s degreeMaster’s_degreeMaster_s_dPercentage of Educational attainment for the population of Graduate or professional degreecomp_devicescomp_devicPercentage of Household having one or more types of computing devicesInternetInternetPercentage of Household with an Internet subscriptionBroadbandBroadbandPercentage of Household having Broadband of any typeSatelite_internetSatelite_iPercentage of Household having Satellite Internet serviceNo_internetNo_internePercentage of Household having No Internet accessNo_computerNo_computePercentage of Household having No computerThis table provides a mapping between the CSV variable names and the shapefile variable names, along with a brief description of each variable.