Attribute Schema

The tables below list the required schema for the Data Driven PHB Process.

Total Population 🏘️

Block_Group_Population Table

Field Name	Description
GEO_ID	Census Geography
Geography	Block Group, Census Tract, County
Pop_Estimate_Total	Total Population Estimate
Pop_MOE_Total	Total Population Margin of Error
GEOID	Census Geography ID (text field for join)

Household Income 💰

Block_Group_HH_Income Table

Field Name	Description
GEO_ID	Census Geography ID
Geography	Block Group, Census Tract, County
HH_Income_Total	Total Household Income
HH_Income_MOE	Margin of Error Total Household Income
Total_less_than_10k	Household Income less than $10K
MOE_less_than_10k	Margin of Error less than $10K
Total_10k_to_15k	Household Income between $10K and $15K
MOE_10k_to_15k	Margin of Error between $10K and $15K
Total_15k_to_20k	Household Income between $15K and $20K
MOE_15k_to_20k	Margin of Error between $15K and $20K
Total_20k_to_25k	Household Income between $20K and $25K
MOE_20k_to_25k	Margin of Error between $20K and $25K
Total_25k_to_30k	Household Income between $25K and $30K
MOE_25k_to_30k	Margin of Error between $25K and $30K
Total_30k_to_35k	Household Income between $30K and $ 35K
MOE_30k_to_35k	Margin of Error between $30K and $35K
Total_35k_to_40k	Household Income between $35K and $40K
MOE_35k_to_40k	Margin of Error between $35K and $40K
Total_40k_to_45k	Household Income between $40K and $45K
MOE_40k_to_45k	Margin of Error between $40K and $45K
Total_45k_to_50k	Household Income between $45K and $50K
MOE_45k_to_50k	Margin of Error between $45K and $50K
Total_50k_to_60k	Household Income between $50K and $60K
MOE_50k_to_60k	Margin of Error between $50K and $60K
Total_60k_to_75k	Household Income between $60K and $75K
MOE_60k_to_75k	Margin of Error between $60K and $75K
Total_75k_to_100k	Household Income between $75K and $100K
MOE_75k_to_100k	Margin of Error between $75K and $100K
Total_100k_to_125k	Household Income between $100K and $125K
MOE_100k_to_125k	Margin of Error between $100K and $125K
Total_125k_to_150k	Household Income between $125K and $150K
MOE_125k_to_150k	Margin of Error between $125K and $150K
Total_150k_to_200k	Household Income between $150K and $200K
MOE_150k_to_200k	Margin of Error between $150K and $200K
Total_200k_or_more	Household Income $200K or more
MOE_200k_or_more	Margin of Error $200K or more