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 |
Last updated