Skip to content

Latest commit

 

History

History
33 lines (28 loc) · 3.11 KB

codebook.md

File metadata and controls

33 lines (28 loc) · 3.11 KB
Raw

This document summarizes the fields in each of the three main output files:

  1. tract_coc_match.csv:

    • coc_number: The 2017 HUD CoC Number
    • coc_name: The 2017 HUD CoC Name
    • tract_fips: The 2017 Census Tract FIPS code.
    • in_2017_PIT: A flag indicating whether a particular CoC is in the 2017 HUD Point in Time (PIT) count file. This is necessary because there is a slight mismatch between the CoCs in the 2017 CoC boundary shapefile and the 2017 PIT count data.
    • total_population: An estimate of the total population in each tract from the American Community Survey 2012-2016 5-Year Estimates
    • total_pop_in_poverty: An An estimate of the total population in each tract with income below the poverty threshold from the American Community Survey 2012-2016 5-Year Estimates

  2. coc_population.csv:

    • coc_number: The 2017 HUD CoC Number
    • total_population: An estimate of the total population in each CoC based on estimates from the American Community Survey 2012-2016 5-Year Estimates.
    • total_pop_in_poverty: An An estimate of the total population in each CoC with income below the poverty threshold based on estimates from the American Community Survey 2012-2016 5-Year Estimates.

  3. county_coc_match.csv:

    • county_fips: The 5-digit county FIPS code
    • coc_number: The 2017 HUD CoC Number
    • coc_name: The 2017 HUD CoC Name
    • in_2017_shapefile: A flag indicating whether a particular CoC is in the 2017 HUD boundary shapefile. This is necessary because there is a slight mismatch between the CoCs in the 2017 CoC boundary shapefile and the 2017 PIT count data.
    • in_2017_PIT: A flag indicating whether a particular CoC is in the 2017 HUD Point in Time (PIT) count file. This is necessary because there is a slight mismatch between the CoCs in the 2017 CoC boundary shapefile and the 2017 PIT count data.
    • n_cocs_in_county: The number of CoCs in which a county is partially (or completely) located
    • n_counties_in_coc: The number of counties that a given CoC partially (or completely) encompasses
    • _mult_county_mult_coc: A flag indicating whether the county-CoC combination in a given row represents both a CoC that encompasses multiple counties and a county that is partially located in multiple CoCs.
    • rel_type: The relationship type of the county-CoC combination represented by each row. The relationship types are as follows:
      • 1: The boundaries of a single CoC and a single county are coterminous.
      • 2: A CoC's boundary fully encompass multiple counties.
      • 3: A single county fully contains multiple CoCs.
      • 4: A CoC is partially located in multiple counties and the counties in which it is located also contain parts of multiple CoCs.
    • pct_cnty_pop_coc : For the county-CoC combination represented by each row, this field provides the % of the county's population that is located in the CoC
    • pct_cnty_pov_coc: For the county-CoC combination represented by each row, this field provides the % of the county's population in poverty that is located in the CoC.