Checks whether or not csvs have the predetermined column names for each csv

Last updated: 2024-11-15 16:03:41

sdc.food

[VALID] Food Access/Food Accessibility Indicator (HOI): va_tr_usda_2015_2019_food_access_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Access/Healthy Food Availability: ncr_cttrbgca_sdad_2023_mrfei.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Children's Food Insecurity: va_hdct_fa_2014_2019_childrens_food_insecurity.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Children's Food Insecurity: va_hdct_fa_2014_2019_childrens_food_insecurity.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Children's Food Insecurity: ncr_ct_fa_2014_2019_childrens_food_insecurity.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Children's Food Insecurity: ncr_ct_fa_2014_2019_childrens_food_insecurity.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Food Budget Shortfall: va_hdct_fa_2014_2019_food_budget_shortfall.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Food Budget Shortfall: va_hdct_fa_2014_2019_food_budget_shortfall.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Food Budget Shortfall: ncr_ct_fa_2014_2019_food_budget_shortfall.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Food Budget Shortfall: ncr_ct_fa_2014_2019_food_budget_shortfall.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Food Secure Average Meal Cost: ncr_ct_fa_2014_2019_food_secure_avg_meal_cost.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Food Secure Average Meal Cost: ncr_ct_fa_2014_2019_food_secure_avg_meal_cost.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Feeding America/Food Secure Average Meal Cost: va_hdct_fa_2014_2019_food_secure_avg_meal_cost.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Food Secure Average Meal Cost: va_hdct_fa_2014_2019_food_secure_avg_meal_cost.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Overall Food Insecurity: ncr_cttr_fa_2014_2020_overall_food_insecurity.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food Security/Feeding America/Overall Food Insecurity: va_hdcttr_fa_2014_2020_overall_food_insecurity.csv.xz

[MISSING COLUMNS] ['moe'] Food Security/Food Insecurity: ncr_tr_sdad_2022_food_insecurity.csv

[MISSING COLUMNS] ['moe'] Food Security/Food Insecurity: va059_tr_sdad_2022_food_insecurity_col_base_snap_food_shortfall.csv

[MISSING COLUMNS] ['moe'] Food Security/Food Insecurity: ncr_tr_sdad_2022_food_insecurity.csv.xz

[MISSING COLUMNS] ['moe'] Food and Nutrition Assistance/Supplemental Nutrition Assistance Program (SNAP): va_hdcttrbg_acs_2013_2020_hh_receiving_snap.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food and Nutrition Assistance/Supplemental Nutrition Assistance Program (SNAP): va_hdcttrbg_acs_2013_2020_hh_receiving_snap.csv.xz

[MISSING COLUMNS] ['moe'] Food and Nutrition Assistance/Supplemental Nutrition Assistance Program (SNAP): ncr_cttrbg_acs_2013_2020_hh_receiving_snap.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Food and Nutrition Assistance/Supplemental Nutrition Assistance Program (SNAP): ncr_cttrbg_acs_2013_2020_hh_receiving_snap.csv.xz

sdc.demographics

[VALID] Age: va_hsrsdpdzccttrbg_sdad_2009_2021_age_demographics.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Age: ncr_cttrbg_acs_2009_2021_age_demographics.csv.xz

[MISSING COLUMNS] ['moe'] Cooperative extension: va_ct_20172023_vote_youth.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Cooperative extension: va_cttr_2010_2021_perc_male.csv.xz

[EXTRA COLUMNS] ['region_name', 'estimate', 'variable', 'region_type'] Cooperative extension: va_cttr_2010_2021_perc_children_raised_by_GPs.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Gender: ncr_cttrbg_acs_2009_2021_gender_demographics.csv.xz

[VALID] Gender: va_hsrsdpdzccttrbg_sdad_2009_2021_gender_demographics.csv.xz

[VALID] Geographic Mobility (HOI): va_hdcttrbg_2015_2022_moving_demographics.csv.xz

[VALID] Geographic Mobility (HOI): va_cttrbg_acs_2015_2021_moving_demographics.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Language: ncr_cttrbg_acs_2016_2021_language_demographics.csv.xz

[VALID] Language: va_hsrsdpdzccttrbg_sdad_2009_2021_language_demographics.csv.xz

[VALID] Overall: census.csv.xz

[VALID] Population Density: va_hdtrct_2015_2022_population_density.csv.xz

[VALID] Race: va_hsrsdpdzccttrbg_sdad_2009_2021_race_demographics.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Race: ncr_cttrbg_acs_2009_2021_race_demographics.csv.xz

[VALID] Segregation (HOI): va_hdtrct_2015_2022_segregation_index_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Veteran: ncr_cttrbg_acs_2009_2021_veteran_demographics.csv.xz

[VALID] Veteran: va_hsrsdpdzccttrbg_sdad_2009_2021_veteran_demographics.csv.xz

sdc.broadband

[VALID] Wired/Accessibility/Average Download Speed: ncr_cttrbg_ookla_download_speeds.csv.xz

[VALID] Wired/Accessibility/Average Upload Speed: ncr_cttrbg_ookla_upload_speeds.csv.xz

[MISSING COLUMNS] ['moe'] Wired/Accessibility/Number of devices: ncr_hdcttrbg_2019_2021q3_speed_measurements.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Wired/Accessibility/Number of devices: ncr_hdcttrbg_2019_2021q3_speed_measurements.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Accessibility/Percent Fast (internet-connected): ncr_hdcttrbg_2019_2021q3_percent_above_threshold.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Accessibility/Percent Fast (total): ncr_hdcttrbg_2019_2021q3_percent_above_threshold.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Accessibility/Percent Good (internet-connected): ncr_hdcttrbg_2019_2021q3_percent_above_threshold.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Accessibility/Percent Good (total): ncr_hdcttrbg_2019_2021q3_percent_above_threshold.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type'] Wired/Adoption/Computer Type: ncr_cttrbg_acs_2017_2021_hh_without_compdev.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type'] Wired/Adoption/Computer Type: va_hdcttrbg_acs_2017_2021_hh_without_compdev.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type'] Wired/Adoption/Internet Type: ncr_cttrbg_acs_2017_2021_hh_internet_type.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type'] Wired/Adoption/Internet Type: va_hdcttrbg_acs_2017_2021_hh_internet_type.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Affordability/Percentage of income for fast internet: ncr_broadbandnow_acs_sdad_2021_perc_income_on_internet.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Affordability/Percentage of income for good internet: ncr_broadbandnow_acs_sdad_2021_perc_income_on_internet.csv.xz

[EXTRA COLUMNS] ['region_name', 'region_type', 'Unnamed: 0', 'measure_units', 'measure_type'] Wired/Affordability/Percentage of income for internet (average): ncr_broadbandnow_acs_sdad_2021_perc_income_on_internet.csv.xz

sdc.geographies

NA

sdc.housing

[VALID] Cost/Affordability_HT: va_hdcttr_2015_2021_affordability_index.csv.xz

[VALID] Cost/Affordability_HT: va_hdcttr_2015_2021_affordability_index_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Cost/Rent: ncr_cttr_hud_2022_housing_cost.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Cost/Rent: va_cttr_hud_2022_housing_cost.csv.xz

[VALID] Cost-burdened HHs: va_hdcttrbg_acs_2014_2021_cost_burdened_hhs.csv.xz

[VALID] Cost-burdened HHs: ncr_cttrbg_acs_2014_2021_cost_burdened_hhs.csv.xz

sdc.education

[VALID] Daycare: vdss.csv.xz

[VALID] Funding: va_ct_2022_2023_funding_adequacy.csv.xz

[VALID] Postsecondary: nces.csv.xz

[VALID] Postsecondary: acs.csv.xz

[MISSING COLUMNS] ['moe'] Reading: va_hdctsd_vdoe_2015_2021_3rd_grade_mean_read_score.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Reading: va_hdctsd_vdoe_2015_2021_3rd_grade_mean_read_score.csv.xz

[VALID] Years of Schooling: va_hdcttr_acs5_2015_2021_years_of_schooling.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Years of Schooling: ncr_tr_acs5_2017_2021_years_of_schooling.csv.xz

[VALID] Years of Schooling: va_hdtrct_acs5_2015_2021_years_of_schooling_std.csv.xz

sdc.health

[VALID] Access to Care (HOI): va_tr_2017_2021_care_access_indicator.csv.xz

[MISSING COLUMNS] ['moe', 'measure', 'value'] Access to Care (HOI): va_cnt_physician_lt_30mi_from_tract.csv

[EXTRA COLUMNS] ['phys_30_cnt'] Access to Care (HOI): va_cnt_physician_lt_30mi_from_tract.csv

[VALID] Access to Care (HOI): va_tr_2017_2021_care_access_indicator_std.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Dentists/Service Catchment Scores: va_hdcttrbgca_webmd_2021_access_scores_dentists.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Dentists/Service Catchment Scores: va_hdcttrbgca_webmd_2021_access_scores_dentists.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Dentists/Service Catchment Scores: ncr_cttrbg_webmd_2021_access_scores_dentists.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Dentists/Service Catchment Scores: ncr_cttrbg_webmd_2021_access_scores_dentists.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Drug and Rehab/Service Catchment Scores: ncr_cttrbg_samhsa_2021_access_scores_substance.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Drug and Rehab/Service Catchment Scores: ncr_cttrbg_samhsa_2021_access_scores_substance.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Drug and Rehab/Service Catchment Scores: va_hdcttrbgca_samhsa_2021_access_scores_substance.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Drug and Rehab/Service Catchment Scores: va_hdcttrbgca_samhsa_2021_access_scores_substance.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/EMS/Service Catchment Scores: ncr_cttrbg_hifld_2021_access_scores_ems.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/EMS/Service Catchment Scores: ncr_cttrbg_hifld_2021_access_scores_ems.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/EMS/Service Catchment Scores: va_hdcttrbgca_hifld_2021_access_scores_ems.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/EMS/Service Catchment Scores: va_hdcttrbgca_hifld_2021_access_scores_ems.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Health Professionals/VA Graduates: va_ct_schev_2016_2019_health_degrees_awarded.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Health Professionals/VA Graduates: va_ct_schev_2016_2019_health_degrees_awarded.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Health Professionals/VA Graduates: va_ahec_schev_2016_2019_health_degrees_awarded.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Health Professionals/VA Graduates: va_ahec_schev_2016_2019_health_degrees_awarded.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Health Professionals/VA Graduates: va_hd_schev_2016_2019_health_degrees_awarded.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Health Professionals/VA Graduates: va_hd_schev_2016_2019_health_degrees_awarded.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2021_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2021_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2017_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2017_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2015_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2015_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2020_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2020_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2016_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2016_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2022_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2022_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2019_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2019_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: va_hdcttrbgca_hifld_2021_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: va_hdcttrbgca_hifld_2021_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2018_access_scores_hospitals.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Hospitals and Emergency Rooms/Service Access Scores: ncr_bgtrct_2018_access_scores_hospitals.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Mental Health/Service Access Scores: va_hdcttrbgca_samhsa_2021_access_scores_mental.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Mental Health/Service Access Scores: va_hdcttrbgca_samhsa_2021_access_scores_mental.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Mental Health/Service Access Scores: ncr_cttrbg_samhsa_2021_access_scores_mental.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Mental Health/Service Access Scores: ncr_cttrbg_samhsa_2021_access_scores_mental.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_obgyn.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_obgyn.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/OB-GYN/Service Access Scores: ncr_cttrbg_webmd_2021_access_scores_obgyn.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/OB-GYN/Service Access Scores: ncr_cttrbg_webmd_2021_access_scores_obgyn.csv.xz

[MISSING COLUMNS] ['moe', 'measure', 'year', 'geoid', 'value'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va059_weighted_access_scores_obgyn.csv.xz

[EXTRA COLUMNS] ['desc', 'weighted_mean', 'variable'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va059_weighted_access_scores_obgyn.csv.xz

[MISSING COLUMNS] ['moe', 'measure', 'year', 'geoid', 'value'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va059_weighted_access_scores_obgyn.csv

[EXTRA COLUMNS] ['desc', 'weighted_mean', 'variable'] Health Care Services/Physicians/OB-GYN/Service Access Scores: va059_weighted_access_scores_obgyn.csv

[VALID] Health Care Services/Physicians/OB-GYN/Service Access Scores: va059_cms_2022_obgyn_access_scores.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/Pediatric/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_pediatrics.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/Pediatric/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_pediatrics.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/Pediatric/Service Access Scores: ncr_cttrbg_webmd_2021_access_scores_pediatrics.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/Pediatric/Service Access Scores: ncr_cttrbg_webmd_2021_access_scores_pediatrics.csv.xz

[VALID] Health Care Services/Physicians/Pediatric/Service Access Scores: va059_webmd_2022_pediatricians_access_scores.csv.xz

[MISSING COLUMNS] ['moe', 'measure', 'year', 'geoid', 'value'] Health Care Services/Physicians/Pediatric/Service Access Scores: va059_weighted_access_scores_pediatrician.csv

[EXTRA COLUMNS] ['desc', 'weighted_mean'] Health Care Services/Physicians/Pediatric/Service Access Scores: va059_weighted_access_scores_pediatrician.csv

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/Primary Care/Service Access Scores: ncr_cttrbg_webmd_2021_acccess_scores_primcare.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/Primary Care/Service Access Scores: ncr_cttrbg_webmd_2021_acccess_scores_primcare.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Physicians/Primary Care/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_primcare.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Physicians/Primary Care/Service Access Scores: va_hdcttrbgca_webmd_2021_access_scores_primcare.csv.xz

[MISSING COLUMNS] ['moe'] Health Care Services/Urgent Care Centers/Service Access Scores: ncr_bgtrct_gmap_2022_access_scores_urgent_care_centers.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Health Care Services/Urgent Care Centers/Service Access Scores: ncr_bgtrct_gmap_2022_access_scores_urgent_care_centers.csv.xz

[VALID] Population Health/Health Opportunity Index: consumer_opportunity_indicator_2016_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2017_2020_food_accessibility_index.csv.xz

[VALID] Population Health/Health Opportunity Index: wellness_disparity_indicator_2016_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: consumer_opportunity_indicator_2015_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: wellness_disparity_indicator_2015_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: consumer_opportunity_indicator_2019_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: consumer_opportunity_indicator_2017_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2020_community_environment_profile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2020_health_opportunity_profile.csv.xz

[VALID] Population Health/Health Opportunity Index: community_environment_indicator_2017_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: economic_opportunity_indicator_2016_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: economic_opportunity_indicator_2018_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2020_consumer_opportunity_profile.csv.xz

[VALID] Population Health/Health Opportunity Index: community_environment_indicator_2016_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2020_wellness_disparity_profile.csv.xz

[VALID] Population Health/Health Opportunity Index: consumer_opportunity_indicator_2018_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: economic_opportunity_indicator_2019_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2017_2020_air_quality_index.csv.xz

[VALID] Population Health/Health Opportunity Index: community_environment_indicator_2015_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: community_environment_indicator_2018_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: wellness_disparity_indicator_2019_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: economic_opportunity_indicator_2017_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: economic_opportunity_indicator_2015_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: community_environment_indicator_2019_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: wellness_disparity_indicator_2018_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: wellness_disparity_indicator_2017_quintile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_tr_vdh_2020_economic_opportunity_profile.csv.xz

[VALID] Population Health/Health Opportunity Index: va_hdcttr_vdh_2017_2020_walkability_index.csv.xz

[VALID] Population Health/Mental Health/Mental and Physical Healthy Days: va_trcthd_sdad_2015_2019_brfss_sae.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/Mental Health/Mental and Physical Healthy Days: ncr_trct_sdad_2015_2019_brfss_sae.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Population Health/Mental Health/Mental and Physical Healthy Days: ncr_trct_sdad_2015_2019_brfss_sae.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/Reproductive Health/Prenatal Care Adequacy: va_ct_nchs_2014_2020_kotelchuck.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Population Health/Reproductive Health/Prenatal Care Adequacy: va_ct_nchs_2014_2020_kotelchuck.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/Social Vulnerability Index: va_cttr_2014_2020_social_vulnerability_index.csv.xz

[EXTRA COLUMNS] ['measure_type'] Population Health/Social Vulnerability Index: va_cttr_2014_2020_social_vulnerability_index.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/Substance Abuse/Drug Overdose ED Visits: va_hdct_vdh_2015_2021_drug_overdose_ed_visits.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Population Health/Substance Abuse/Drug Overdose ED Visits: va_hdct_vdh_2015_2021_drug_overdose_ed_visits.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/System Usage and Insurance/Preventable Hospitalizations: va_hdct_2015_2021_preventable_hospitalizations.csv.xz

[EXTRA COLUMNS] ['measure_type'] Population Health/System Usage and Insurance/Preventable Hospitalizations: va_hdct_2015_2021_preventable_hospitalizations.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/System Usage and Insurance/Without Health Insurance: ncr_cttrbg_acs5_2015_2019_no_health_insurance_19_to_64.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Population Health/System Usage and Insurance/Without Health Insurance: ncr_cttrbg_acs5_2015_2019_no_health_insurance_19_to_64.csv.xz

[MISSING COLUMNS] ['moe'] Population Health/System Usage and Insurance/Without Health Insurance: va_hdcttr_acs5_2015_2019_no_health_insurance_19_to_64.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Population Health/System Usage and Insurance/Without Health Insurance: va_hdcttr_acs5_2015_2019_no_health_insurance_19_to_64.csv.xz

sdc.transportation

[VALID] Infrastructure/Walkability (HOI): va_hdcttr_2021_walkability_index.csv.xz

[MISSING COLUMNS] ['moe'] Population Characteristics: ncr_cttr_acs_2016_2020_carpools.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Population Characteristics: ncr_cttr_acs_2016_2020_carpools.csv.xz

[MISSING COLUMNS] ['moe'] Population Characteristics: ncr_cttr_acs_2016_2020_commutes.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Population Characteristics: ncr_cttr_acs_2016_2020_commutes.csv.xz

[MISSING COLUMNS] ['moe'] Population Characteristics: ncr_cttr_acs_2016_2020_vehicles.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_units', 'measure_type', 'region_type'] Population Characteristics: ncr_cttr_acs_2016_2020_vehicles.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Population Characteristics: va_cttr_2010_2021_perc_no_car_households.csv.xz

sdc.business_climate

[VALID] Business_characteristics/Industry: rva_cttrbg_mi_2010_2020_business_metrics_by_Industry.csv.xz

[VALID] Business_characteristics/Industry: va059_cttrbg_mi_2010_2020_business_metrics_by_Industry.csv.xz

[VALID] Business_characteristics/Industry: ncr_cttrbg_mi_2010_2020_business_metrics_by_Industry.csv.xz

[VALID] Business_characteristics/Minority_owned: ncr_cttrbg_mi_2010_2020_business_metrics_by_Minority_owned.csv.xz

[VALID] Business_characteristics/Minority_owned: va059_cttrbg_mi_2010_2020_business_metrics_by_Minority_owned.csv.xz

[VALID] Business_characteristics/Minority_owned: rva_cttrbg_mi_2010_2020_business_metrics_by_Minority_owned.csv.xz

[VALID] Business_characteristics/Total: va059_cttrbg_mi_2010_2020_business_metrics_by_Total.csv.xz

[VALID] Business_characteristics/Total: rva_cttrbg_mi_2010_2020_business_metrics_by_Total.csv.xz

[VALID] Business_characteristics/Total: ncr_cttrbg_mi_2010_2020_business_metrics_by_Total.csv.xz

[VALID] Employment/Industry: va059_ct_mi_2010_2020_herfindalh_index_by_industry.csv.xz

[VALID] Employment/Industry: rva_cttrbg_mi_2010_2020_employment_metrics_by_Industry.csv.xz

[VALID] Employment/Industry: ncr_ct_mi_2010_2020_herfindalh_index_by_industry.csv.xz

[VALID] Employment/Industry: rva_ct_mi_2010_2020_herfindalh_index_by_industry.csv.xz

[VALID] Employment/Industry: ncr_cttrbg_mi_2010_2020_location_quotient_by_industry.csv.xz

[VALID] Employment/Industry: ncr_cttrbg_mi_2010_2020_employment_metrics_by_Industry.csv.xz

[VALID] Employment/Industry: va059_cttrbg_mi_2010_2020_employment_metrics_by_Industry.csv.xz

[VALID] Employment/Industry: rva_cttrbg_mi_2010_2020_location_quotient_by_industry.csv.xz

[VALID] Employment/Industry: va059_cttrbg_mi_2010_2020_location_quotient_by_industry.csv.xz

[VALID] Employment/Minority_owned: ncr_cttrbg_mi_2010_2020_employment_metrics_by_Minority_owned.csv.xz

[VALID] Employment/Minority_owned: rva_cttrbg_mi_2010_2020_employment_metrics_by_Minority_owned.csv.xz

[VALID] Employment/Minority_owned: va059_cttrbg_mi_2010_2020_employment_metrics_by_Minority_owned.csv.xz

[VALID] Employment/Total: rva_cttrbg_mi_2010_2020_employment_metrics_by_Total.csv.xz

[VALID] Employment/Total: va059_cttrbg_mi_2010_2020_employment_metrics_by_Total.csv.xz

[VALID] Employment/Total: ncr_cttrbg_mi_2010_2020_employment_metrics_by_Total.csv.xz

[VALID] Employment/Worker_diversity: va059_cttrbg_lodes_2010_2019_wac_employment_segments_by_sex.csv.xz

[VALID] Employment/Worker_diversity: va059_cttrbg_lodes_2010_2019_workplace_employment_segments_by_sex.csv.xz

[EXTRA COLUMNS] ['measure_type'] Employment/Worker_diversity: rva_cttrbg_lodes_2010_2019_employment_by_minority_workers.csv.xz

[EXTRA COLUMNS] ['measure_type'] Employment/Worker_diversity: va059_cttrbg_lodes_2010_2019_employment_by_minority_workers.csv.xz

[EXTRA COLUMNS] ['measure_type'] Employment/Worker_diversity: ncr_cttrbg_lodes_2010_2019_employment_by_minority_workers.csv.xz

[VALID] Employment/Worker_diversity: va059_cttrbg_lodes_2010_2019_rac_employment_segments_by_sex.csv.xz

[MISSING COLUMNS] ['moe'] Industry specific/Agriculture: va_ct_2017_industry_agriculture.csv.xz

[EXTRA COLUMNS] ['measure_type'] Industry specific/Agriculture: va_ct_2017_industry_agriculture.csv.xz

[MISSING COLUMNS] ['moe'] Industry specific/Agriculture: va_ct_2022_industry_agriculture.csv.xz

[EXTRA COLUMNS] ['measure_type'] Industry specific/Agriculture: va_ct_2022_industry_agriculture.csv.xz

sdc.financial_well_being

[EXTRA COLUMNS] ['measure_type'] Asset Limited Income Constrained Employed (ALICE): va_ct_2010_2021_alice.csv.xz

[VALID] Employment: va_hdcttr_2015_2022_labor_participate_rate_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Employment: ncr_cttr_2015_2021_job_participate_rate.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Employment: ncr_cttr_2015_2021_employment_rate.csv.xz

[VALID] Employment: va_cttr_acs_2015_2019_emp_rate.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Employment: va_cttr_2015_2021_employment_rate.csv.xz

[VALID] Employment: va_hdcttr_2015_2022_labor_participate_rate.csv.xz

[VALID] Employment Access: va_hdcttr_2015_2021_employment_access_index.csv.xz

[VALID] Employment Access: va_hdcttr_2015_2021_employment_access_index_std.csv.xz

[VALID] Material_Deprivation: va_hdcttr_vdh_2015_2021_material_deprivation_index.csv.xz

[VALID] Material_Deprivation: va_hdcttr_vdh_2015_2021_material_deprivation_index_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Household Income: ncr_cttrbg_2015_2021_median_household_income.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Household Income: ncr_cttrbg_2015_2019_median_household_income.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Household Income: va_cttrbg_2015_2019_median_household_income.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Income Inequality: ncr_cttr_2015_2021_income_inequality_gini_index.csv.xz

[MISSING COLUMNS] ['moe', 'measure', 'year', 'geoid', 'value'] Pay and Benefits/Income Inequality: occ_codes.csv

[EXTRA COLUMNS] ['OCCP', 'OCCP_text'] Pay and Benefits/Income Inequality: occ_codes.csv

[VALID] Pay and Benefits/Income Inequality: va_hdcttr_2015_2021_income_inequality_gini_index.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Income Inequality: va_cttr_2015_2021_income_inequality_gini_index.csv.xz

[VALID] Pay and Benefits/Income Inequality: va_hdcttr_2015_2021_income_inequality_gini_index_std.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] Pay and Benefits/Personal Income: va_hdct_bea_2015_2021_earnings_per_job.csv.xz

[VALID] Poverty: va059_tr_acs_2021_poverty_demographics.csv.xz

[VALID] Poverty: ncr_tr_acs_2021_poverty_children.csv.xz

[VALID] Poverty: ncr_tr_acs_2021_poverty_adults.csv.xz

sdc.environment

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] climate_change: ncr_tr_fema_2019_natural_hazards_risk_scores.csv.xz

[VALID] environmental_justice: va_tr_2020_env_haz_inx.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] environmental_justice: ncr_bg_epa_2022_environmental_justice_screen.csv.xz

[VALID] environmental_justice: va_tr_2019_env_haz_inx.csv.xz

[VALID] environmental_justice: va_tr_2016_env_haz_inx.csv.xz

[EXTRA COLUMNS] ['region_name', 'measure_type', 'region_type'] environmental_justice: ncr_tr_epa_2022_environmental_justice_screen.csv.xz

[VALID] environmental_justice: va_tr_2018_env_haz_inx.csv.xz

[VALID] environmental_justice: va_tr_2021_env_haz_inx.csv.xz

[VALID] environmental_justice: va_tr_2017_env_haz_inx.csv.xz

sdc.public_safety

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2021_incarceration_rate.csv.xz

[MISSING COLUMNS] ['moe'] Incarceration: va_hdcttr_2020_incarceration_rate.csv.xz

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2018_incarceration_rate.csv.xz

[ERROR] Incarceration: measure_info.json.xz

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2019_incarceration_rate.csv.xz

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2015_incarceration_rate.csv.xz

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2017_incarceration_rate.csv.xz

[EXTRA COLUMNS] ['Unnamed: 0'] Incarceration: va_hdcttr_2016_incarceration_rate.csv.xz