--------------------------------------------------------------------------------
OVERVIEW
--------------------------------------------------------------------------------

(1) cty_covariates.dta
(2) state-geocodes-v2017.xlsx
(3) online_table4-2.dta
(4) health_ineq_online_table_12.dta
(5) ZIP_COUNTY_122019.xlsx
(6) city_counties_raw.csv
(7) csa-est2023-pop.xlsx

--------------------------------------------------------------------------------
SOURCE
--------------------------------------------------------------------------------

(1) https://opportunityinsights.org/data/?geographic_level=0&topic=0&paper_id=1652#resource-listing

(2) https://www.census.gov/geographies/reference-files/2017/demo/popest/2017-fips.html

(3) https://opportunityinsights.org/wp-content/uploads/2018/04/online_table4-2.dta

(4) https://opportunityinsights.org/wp-content/uploads/2018/04/health_ineq_online_table_12.dta

(5) https://www.huduser.gov/portal/datasets/usps_crosswalk.html

(6) Original creation by Billy Ferguson 

(7) https://www2.census.gov/programs-surveys/popest/tables/2020-2023/metro/totals/csa-est2023-pop.xlsx


--------------------------------------------------------------------------------
WHEN/WHERE OBTAINED & ORIGINAL FORM OF FILES
--------------------------------------------------------------------------------
(1) Downloaded April 2020

(2) Downloaded April 2020

(3) Downloaded April 2020

(4) Downloaded April 2020

(5) Downloaded April 2020

(6) Created by Billy Ferguson

(7) Downloaded September 2024

--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------

(1) County covariates from Opportunity Insights

(2) County to Census division crosswalk from US Census

(3) County level causal effects from Opportunity Insights (contains county names and state names)

(4) County level health covariates from Chetty's JAMA on LE and inequality

(5) 2019 Q4 zip-county crosswalk from HUD

(6) A crosswalk between cities that passed stay-at-home orders in the New York Times data and the respective counties.

(7) Population counts by CSA, used to get percentage of US population that lives in a CSA in 2020.

--------------------------------------------------------------------------------
