Home | Texas Water Development Board



To determine Disadvantaged Community eligibility in the Clean Water and Drinking Water State Revolving Fund programs, the TWDB utilizes U.S. Census Bureau data, specifically the American Community Survey (ACS) 5-Year Estimates regarding Annual Median Household Income, Total Population, Average Household Size and Unemployment Rate. This data may be obtained through the TWDB’s excel spreadsheets provided below (or directly sourced from the U.S. Census Bureau’s Explore Census Data website)SFY 2023 Intended Use Plan - SRF Program – American Community Survey (ACS) 5-Year Estimates – Excel FileFor SFY 2023, use the 2015 - 2019 ACS 5-year estimates (and for calculating population adjustment for the Household Cost Factor, compare it to the population found in the 2011 - 2015 ACS 5-year estimates.)HYPERLINK "" 2022 Intended Use Plan - SRF Program – American Community Survey (ACS) 5-Year Estimates – Excel FileFor SFY 2022, use the 2015 - 2019 ACS 5-year estimates (and for calculating population adjustment for the Household Cost Factor, compare it to the population found in the 2011 - 2015 ACS 5-year estimates.) HYPERLINK "" Census Data Note: The U.S. Census Bureau denotes different time periods for data depending on the last year survey information was gathered (e.g. 5-year data from 2015-2019 will be categorized as “2019 ACS 5-year estimates”).Tables Used:B19103 for Annual Median Household Income.B25010 for Average Household Size.B01003 for Total Population.B23025 for Civilian Labor Force: Total and Civilian Labor Force: Unemployed to determine Unemployment Rate. Note: To determine Unemployment Rate, divide the Civilian Labor Force: Unemployed by the Civilian Labor Force: Total.Explore Census Data - Advanced SearchSteps Go to on “Advanced Search” Enter the Table number (such as B19013 for Annual Median Household Income) in the search box, then click on Surveys and select ACS 5-Year Estimates Detailed TablesClick on Years and select the years (such as 2018, for ACS 5 Year Estimates 2014 to 2018)Click on Geography and select the desired geography (such as Place and then the city desired such as Abbott city, TX)Select the table desired, click on Download Selected, then DownloadOnce the files are prepared for downloading, click on Download NowOnce the files are prepared for downloading, click on Download NowClick on Extract all Extract to the desired folderLoad the csv file using Excel, or some other spreadsheetProrated Tables - ExamplesFor census tract or block group information, a prorated data table should be used on the data found. The retrieved data must be organized in table format and prorated according to the percentage of household connections. See: the following examples – Prorated U.S. Census Data based on Block Group data for Total Population, AMHI, and Household Size, Change in Population, and Unemployment Rates. Example -- Prorated U.S. Census Data – Total Population, AMHI, and Household SizeABCDEFGHIJUS Census TractBlock GroupPopulationAMHIAverage Household SizeNumber of Household ConnectionsHousehold Connections as a % of Total Household ConnectionsEntity's Current Population (ExF)Entity's AMHI (DxG)Entity's Average Household Size (ExG)CountySourcex52311,279$29,712 2.9420012.33%588$3,664 0.36ABCACS 5 -Year Estimatesx52325,079$60,399 3.5664.07%231$2,458 0.14ABCACS 5 -Year Estimatesx52414,683$43,149 3.191,00061.65%3,190$26,602 1.97ABCACS 5 -Year Estimatesx52441,439$45,781 2.9635621.95%1,054$10,048 0.65ABCACS 5 -Year EstimatesTotal????1,622100.00%5,063$42,772 3.12Example -- Prorated U.S. Census Data – Change in Population ABCDEFGHIUS Census TractBlock GroupPopulation 2010Population 2014Change in population 2010 to 2014 Average Household SizeNumber of Current Household ConnectionsHousehold Connections as a % of Total Household ConnectionsChange in Population-2010 to 2014 (ExH)CountySourcex52311,2401,2793.15%2.9420012.33%0.39%ABCACS 5 -Year Estimatesx52325,1065,079-0.53%3.5664.07%0.02%ABCACS 5 -Year Estimatesx52414,6834,683-9.09%3.191,00061.65%-5.60%ABCACS 5 -Year Estimatesx52441,4391,4392.79%2.9635621.95%0.61ABCACS 5 -Year EstimatesTotal????1,622100.00%-4.62%Example -- Prorated U.S. Census Data – Unemployment Rates at the Census Tract LevelABCDEFUS Census TractUnemployment rateAverage Household SizeNumber of Current Household ConnectionsHousehold Connections as a % of Total Household ConnectionsUnemployment Rate(CxE)CountySourcex5236.2%3.2026616.40%1.0%ABCACS 5 -Year Estimatesx5245.7%3.001,35683.60%4.8%ABCACS 5 -Year EstimatesTotal??1,622100.00%5.8% ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download