Distressed Tracts By County

Counts of FFEIC distressed tracts, by county.

civicknowledge.com-distressed-county-1.1.5. Modified 2020-06-25T16:01:09

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

The FFEIC publishes a very large dataset of Census variables and flags indicating ways in which housing and populations in tracts are distressed. This dataset aggregates those tract flags into counts of distressed tracts per county.

Images

  • Percentage of Poverty Distressed Population Per County

Contacts

Data Dictionary

distressed_counties

distressed_counties

Column NameData TypeDescription
geoidstringCounty geoid
stusabstringState postal abbreviation
stateintegerState FIPS code
countyintegerCounty FIPS code
yearintegerYear values were observed
current_prior_distressedintegerCount of tracts in county with flag: Meets at least one of current or previous year’s CRA distressed/underserved tract criteria? ‘X’ – Yes, ‘ ‘ (blank space) – No
current_prior_distressed_pctnumberPercentage of tracts in county with flag: Meets at least one of current or previous year’s CRA distressed/underserved tract criteria? ‘X’ – Yes, ‘ ‘ (blank space) – No
current_prior_distressed_popintegerPopulation in county in tracts with flag: Meets at least one of current or previous year’s CRA distressed/underserved tract criteria? ‘X’ – Yes, ‘ ‘ (blank space) – No
current_prior_distressed_pop_pctnumberPercentage of population in county in tracts with flag: Meets at least one of current or previous year’s CRA distressed/underserved tract criteria? ‘X’ – Yes, ‘ ‘ (blank space) – No
last_year_distressedintegerCount of tracts in county with flag: Meets at least one of the previous year’s CRA distressed criteria? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_distressed_pctnumberPercentage of tracts in county with flag: Meets at least one of the previous year’s CRA distressed criteria? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_distressed_popintegerPopulation in county in tracts with flag: Meets at least one of the previous year’s CRA distressed criteria? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_distressed_pop_pctnumberPercentage of population in county in tracts with flag: Meets at least one of the previous year’s CRA distressed criteria? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_underservedintegerCount of tracts in county with flag: Meets previous year’s CRA underserved criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_underserved_pctnumberPercentage of tracts in county with flag: Meets previous year’s CRA underserved criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_underserved_popintegerPopulation in county in tracts with flag: Meets previous year’s CRA underserved criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
last_year_underserved_pop_pctnumberPercentage of population in county in tracts with flag: Meets previous year’s CRA underserved criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
population_distressedintegerCount of tracts in county with flag: Total persons
population_distressed_pctnumberPercentage of tracts in county with flag: Total persons
population_distressed_popintegerPopulation in county in tracts with flag: Total persons
population_distressed_pop_pctnumberPercentage of population in county in tracts with flag: Total persons
poverty_distressedintegerCount of tracts in county with flag: Meets current year’s poverty CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
poverty_distressed_pctnumberPercentage of tracts in county with flag: Meets current year’s poverty CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
poverty_distressed_popintegerPopulation in county in tracts with flag: Meets current year’s poverty CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
poverty_distressed_pop_pctnumberPercentage of population in county in tracts with flag: Meets current year’s poverty CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
rural_underservedintegerCount of tracts in county with flag: Meets current year’s remote rural (low density) CRA underserved criterion? ‘X’ -Yes, ‘ ‘ (blank space) – No
rural_underserved_pctnumberPercentage of tracts in county with flag: Meets current year’s remote rural (low density) CRA underserved criterion? ‘X’ -Yes, ‘ ‘ (blank space) – No
rural_underserved_popintegerPopulation in county in tracts with flag: Meets current year’s remote rural (low density) CRA underserved criterion? ‘X’ -Yes, ‘ ‘ (blank space) – No
rural_underserved_pop_pctnumberPercentage of population in county in tracts with flag: Meets current year’s remote rural (low density) CRA underserved criterion? ‘X’ -Yes, ‘ ‘ (blank space) – No
unemployment_distressedintegerCount of tracts in county with flag: Meets current year’s unemployment CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
unemployment_distressed_pctnumberPercentage of tracts in county with flag: Meets current year’s unemployment CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
unemployment_distressed_popintegerPopulation in county in tracts with flag: Meets current year’s unemployment CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No
unemployment_distressed_pop_pctnumberPercentage of population in county in tracts with flag: Meets current year’s unemployment CRA distressed criterion? ‘X’ – Yes , ‘ ‘ (blank space) – No

References

Urls used in the creation of this data package.

  • metapack+http://library.metatab.org/ffeic.gov-census-tract.csv#ffeic_distressed. Flags indicating FFEIC “distressed” designations, per tract.
  • metapack+http://library.metatab.org/census.gov-boundaries-2018.csv#county_500k. County Boundaries

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


distressed_counties_df =  pd.read_csv('http://library.metatab.org/civicknowledge.com-distressed-county-1.1.5/data/distressed_counties.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/civicknowledge.com-distressed-county-1.1.5.csv')

# Create Dataframes
distressed_counties_df = pkg.resource('distressed_counties').dataframe()