Vital Signs: Income (Quintile by Place of Residence) – County
data.bayareametro.gov | Last Updated 13 Aug 2019VITAL SIGNS INDICATOR Income (EC4) FULL MEASURE NAME Household income by place of residence LAST UPDATED May 2019 DESCRIPTION Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis. DATA SOURCE U.S. Census Bureau: Decennial Census Count 4Pb (1970) Form STF3 (1980-1990) Form SF3a (2000) https://nhgis.org U.S. Census Bureau: American Community Survey Form B19013 (2006-2017; place of residence) http://api.census.gov Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2017; specific to each metro area) http://data.bls.gov CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Income data reported in a given year reflects the income earned in the prior year (decennial Census) or in the prior 12 months (American Community Survey); note that this inconsistency has a minor effect on historical comparisons (for more information, go to: http://www.census.gov/acs/www/Downloads/methodology/ASA_nelson.pdf). American Community Survey 1-year data is used for larger geographies – metropolitan areas and counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Quintile income for 1970-2000 is imputed from Decennial Census data using methodology from the California Department of Finance (for more information, go to: http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf). Bay Area income is the population weighted average of county-level income. Income has been inflated using the Consumer Price Index specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data is unavailable for some historical data points. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.
This dataset has the following 11 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Residence_Geo | residence_geo | text | Alameda County Contra Costa County Marin County Napa County San Francisco County view top 100 | |
Year | year | number | 1970 1980 1990 2000 2006 view top 100 | |
20_Percentile_HH_Inc_PlaceOfResidence_IA | _20_percentile_hh_inc_placeofresidence_ia | number | 20th percentile median household income (2017 dollars) | 21364 22333 24450 25407 26233 view top 100 |
40_Percentile_HH_Inc_PlaceOfResidence_IA | _40_percentile_hh_inc_placeofresidence_ia | number | 40th percentile median household income (2017 dollars) | 63333 47885 48718 54796 55113 view top 100 |
60_Percentile_HH_Inc_PlaceOfResidence_IA | _60_percentile_hh_inc_placeofresidence_ia | number | 60th percentile median household income (2017 dollars) | 71409 75136 77140 80721 84748 view top 100 |
80_Percentile_HH_Inc_PlaceOfResidence_IA | _80_percentile_hh_inc_placeofresidence_ia | number | 80th percentile median household income (2017 dollars) | 107831 109345 110567 113893 119032 view top 100 |
20_Percentile_HH_Inc_PlaceOfResidence_IA_PerChg1970 | _20_percentile_hh_inc_placeofresidence_ia_perchg1970 | number | Percent change in 20th percentile median household income since 1970 (2017 dollars) | 0 -0.16375052264465428 -0.156761487015606 -0.15394181516595917 -0.14011406112634106 view top 100 |
40_Percentile_HH_Inc_PlaceOfResidence_IA_PerChg1970 | _40_percentile_hh_inc_placeofresidence_ia_perchg1970 | number | Percent change in 40th percentile median household income since 1970 (2017 dollars) | 0 -0.09268212952522559 -0.09039654223312654 -0.08803400073316592 -0.08031434689570216 view top 100 |
60_Percentile_HH_Inc_PlaceOfResidence_IA_PerChg1970 | _60_percentile_hh_inc_placeofresidence_ia_perchg1970 | number | Percent change in 60th percentile median household income since 1970 (2017 dollars) | 0 0.030193568825742645 0.034842278084400435 0.04871280295969216 0.0524812016244145 view top 100 |
80_Percentile_HH_Inc_PlaceOfResidence_IA_PerChg1970 | _80_percentile_hh_inc_placeofresidence_ia_perchg1970 | number | Percent change in 80th percentile median household income since 1970 (2017 dollars) | 0 0.019724614751479352 0.03625568790794276 0.05755880716490225 0.08281905178104298 view top 100 |
Source | source | text | ACS 1-year Census 1970 Census 1980 Census 1990 Census 2000 view top 100 |