Part 4: Regional Data SetsĀ 

Part One of this report, Existing Conditions, is based on an Excel workbook that includes data tables and figures for the eight counties in the region and for the region as a whole. That data workbook is available by clicking here.

Data in the workbook are organized by data worksheets that focus on four topics: population, households, economic conditions, and housing. Each of the topical data worksheets has two sections: tables on the left and charts on the right. The tables and charts are formatted to facilitate their straightforward integration into analysis or reports that may be produced with these data. The following tables summarize the data tables and charts included in each data worksheet.

The following tables summarize the data tables and charts included in each data worksheet.

 

Population Metrics Worksheet

Tables Charts
Total Population Total Population by County
Total Population by County Over Time
Percent Change in Total Population by County Over Time Percent Change in Total Population Over Time by County (1980 to 2020)
Regional Population and Annual Growth Rate Regional Population and Annual Growth Rate (1980 to 2020)
Population by Age Group (Detailed)
Population by Age Groups (Both Sex Combined) Population by Age and County (2019)
Population by Race
Population by Race by Hispanic Origin
Regional Population by Race by Hispanic Origin Over Time Regional Population by Race by Hispanic Origin Over Time (2000 to 2020)
Population by Race by Hispanic Origin Over Time (Simplified)
Race by Hispanic Status (18 Years and Under)
Race by Hispanic Status (18 Years and Over)
Percent of Population by Hispanic Origin by Age San Joaquin Valley Region Percent of Population by Hispanic Origin by Age
Population Density Population Density by County

Household Metrics Worksheet

Tables Charts
Total Households Over Time (Region) Total Households and Percent Change Over Time (1980 to 2019*) (Region)
Total Households Over Time (State)
Decennial Increase in Households Over Time (1980-2019*) (Region and State) Decennial Increase in Households Over Time (1980-2019*) (Region and State)
Household by Size by Family or Nonfamily Households (County, Region, and State) Household Size by County Compared to the Region and State (2019)
Family and Nonfamily Households by Size (County, Region, and State)
Average Household Size (County, Region, and State) Average Household Size by Tenure (2019)
Average Household Size Over Time (Region and State)
Older Adult Households by Income (County, Region, and State) Older Adult Households by Income (2019) (Region and State)
Older Adult Households by Tenure (County, Region, and State) Older Adult Households by Tenure (County)

Economic Conditions Metrics Worksheet

Tables Charts
Median Household Income Median Household Income by County
Housing Costs as a Percentage of Income Median Monthly Housing Costs as a Percentage of Income Over Time (2009-2019)
Median Household Income by Race Median Household Income by Race or Ethnicity (2019)
Number of Percentage of Households in Poverty
Percent of Households in Poverty Over Time Percent of Households in Poverty, Over Time (2009-2019)
Percentage of Households in Poverty by County Percentage of Households in Poverty by County
Number and Percentage of Households in Poverty by Race
Number and Percentage of Households in Poverty by Ethnicity
Percentage of Households in Poverty by Race Percentage of Households in Poverty by Race
Employment by Industry over time Employment by Industry Over Time (2009-2019)
Percentage of Employment by Industry over time
Employment by Industry Over Time Regional Employment by Industry (2019)
Employment by Industry by County Employment by Occupation by County (2019)
Gini Index
Gini Index Over Time Gini Index, Over Time (2009-2019)
Means of Transportation to Work Means of Transportation to Work (2019)
Travel Time to Work
Travel Time to Work (Simplified) Travel Time to Work by Region and State
Travel Time to Work Over Time Travel Time to Work Over Time (2009-2019)
Travel Time to Work 90 or More Minutes Travel Time to Work 90 or More Minutes Over Time (2009-2019)
Cost of Living (Household Budget for a Family of Three) Cost of Living (Household Budget for a Family of Three) by County
Cost of Living: Income Deficit
Total Number of Jobs by Industry (2020 Quarter 1)
Jobs-Housing Balance (2020 Quarter 1) Jobs-Housing Balance by County (2020 Quarter 1)
Jobs-Housing Balance Over Time
Jobs-Housing Balance Over Time – Simplified Regional Jobs-Housing Balance Over Time

Housing Metrics Worksheet

Tables Charts
Housing Units (County, Region, and State)
Regional Housing Units and Annual Growth Rate (Region) Regional Housing Units and Annual Growth Rate (1980 to 2020)
Housing Units by Type (County, Region, and State) Housing Units by Type by County (2019)
Housing Units By Type Over Time (Region) Housing Units by Type Over Time (2009-2019)
Housing Units by Number of Bedrooms Over Time (Region) Housing Units by Number of Bedrooms (2019) (Region)
Housing Units by Year Built (County, Region, and State) Total Housing Units by Year Built (Region)
Percent of Total Housing Units by Year Built (County, Region, State) Percent of Total Housing Units by Year Built (Region and State)
Overcrowding: Units by Occupants per Room (County, Region, and State) Percent Units by Occupants per Room (2019) (Region)
Overcrowding: Large Households by Tenure (County, Region, and State)
Overcrowding: Large Households by Tenure (Region) Large Households by Tenure (2019)
Housing Units by Tenure (County, Region, and State) Housing Tenure by County
Housing Units by Tenure Over Time (Region) Household Tenure Over Time (1980 to 2019) (Region)
Housing Tenure by Number of Bedrooms (County, Region, and State)
Housing Tenure by Number of Bedrooms (Region) Housing Tenure by Number of Bedrooms (2019) (Region)
Housing Tenure by Race (County, Region, and State) Housing Tenure by Race (2019)
Housing Tenure by Race (Region)
HUD CoC – Homelessness by Type
HUD CoC – Homelessness by Type Over Time Homelessness by Type, Over Time (2005-2020)
HUD CoC – Homelessness by Race Homelessness by Race or Ethnicity (2020)
HUD CoC – Homeless by Ethnicity Homelessness by Ethnicity (2020)
Building Permits (Number of Structures Authorized) (County, Region, and State)
5th Cycle Production by Affordability – HCD (All years combined) (County, Region, and State) 5th Cycle Production by Affordability – HCD (All years combined)
5th Cycle Production by Affordability – HCD (All years combined) (Region)
Median Housing Value (County, Region, and State)
Median Housing Value Over Time (Region) Median Housing Value, Over Time (1980-2019)
Median Selected Monthly Owner Costs by County (County, Region, and State)
Regional Median Selected Monthly Owner Costs Over Time (Region) Median Selected Monthly Owner Costs, Over Time (2009-2019)
Median Selected Monthly Owner Costs as % of Household Income (County, Region, and State) Median Selected Monthly Owner Costs as a Percentage of Household Income by County, Region, and State (2019)
Owners: Cost-burdened Households (County, Region, and State) Percentage of Cost-burdened Owner Households by County, Region, and State (2019)
Owners: Cost-burdened Households Over Time (Region) Cost-Burdened Owner Households and Percentage Over Time (1980-2019)
Median Gross Rent (County, Region, and State)
Median Gross Rent Over Time (Region) Median Gross Rent, Over Time (1980-2019)
Median Gross Rent as % of Household Income (County, Region, and State) Median Gross Rent as a Percentage of Household Income by County, Region, and State (2019)
Renters: Cost-burdened Households (County, Region, and State) Percentage of Cost-burdened Renter Households by County, Region, and State (2019)
Renters: Cost-burdened Households Over Time (Region) Cost-Burdened Renter Households and Percentage Over Time by County, Region, and State (1980-2019)
Affordable Home Shortfall (County and Region) Affordable Home Shortfall
Affordable Home Shortfall Affordable Home Shortfall
Who Can Afford Rent Who Can Afford Rent
Market Rent (ZORI) Zillow: Market Rate Rent Trends for SJV Metropolitan Statistical Areas (2014 to 2021)
Median Sale Price (MSP) Zillow: Median Sales Price for SJV Metropolitan Statistical Areas (2008 to 2021)
Home Value (ZHVI) Zillow: Home Values for All SJV Counties (1996 to 2021)

For reference, the comprehensive data sets from each of the data sources are also included, as summarized in the table below.

Worksheet Name Description Notes
Ref. ACS-5-YR-Pt1 American Community Survey (ACS) 5-Year Estimates at the county and regional levels for years 2005-2009, 2010-2014, and 2015-2019 Most robust set of raw data tables used for analyses. Not inflation adjusted.
Ref. ACS-5-YR-Pt2 American Community Survey (ACS) 5-Year Estimates for years 2005-2009. Because of changes in how the Census organized employment data, Industry by Occupation data for 2005-2009 is located in this separate worksheet.
Ref. ACS-State American Community Survey (ACS) 5-Year Estimates at the state level for years 2005-2009, 2010-2014, and 2015-2019
Ref. DC-2020 Decennial Census (DC) 2020 Data available for a limited set of metrics.
Ref. DC-2010 Decennial Census (DC) 2010 Data available for a limited set of metrics.
Ref. DC-2000 Decennial Census (DC) 2000
Ref. DC-1990 Decennial Census (DC) 1990
Ref. DC-1980 Decennial Census (DC) 1980
Ref. Building Permits U.S. Census Bureau’s Building Permits Survey for 2019, at the county, regional, and state levels
Ref. 5th Cycle Full Filtered Housing and Community Development (HCD) 2015-2019 Annual Housing Progress Data for all San Joaquin Valley Counties
Ref. Workforce Quarterly Workforce Indicators from the U.S. Census Bureau and Social Explorer for Quarter 1 in the years 2000, 2010, and 2020