{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Purpose and Instructions","Overview","1. Project Information","2. Demographic Data","3. MPS","4. Secondary Test","5. LQPI","6. FAA Checklist ","7. Results of Impacts Analysis","8. WQS Decision Table","9. Widespread Impact Analysis","Potential Data Sources","Change Log","BondRating_vlookup","Impacts","Dropdown Menus","Place B tables","Place B tables 5 years earlier","Place DP tables","Place S tables","State B tables","National B tables","National S tables","National DP tables","API_calls"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":64,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Purpose and Instructions","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Uses and Variances - Evaluating Substantial and Widespread Economic and Social Impacts: Public Sector Entities"]
[null,"This Microsoft Excel workbook is a tool provided by the EPA to assist states and authorized tribes assess the degree of economic and social impact of potential Water Quality Standards (WQS) decisions. Federal regulations allow the lowering or removal of certain designated uses or the granting of a WQS variance if the pollutant controls needed to attain the designated use will result in substantial and widespread economic and social impacts (CFR 40 131.10(g)(6)). In 1995, the EPA published guidance entitled: \"Interim Economic Guidance for Water Quality Standards Workbook\" (March 1995, EPA-823-B-95-002, hereafter termed \"1995 WQS Guidance\") to help states, tribes, territories and stakeholders evaluate the potential for substantial and widespread economic and social impacts. In 2024, the EPA supplemented the 1995 WQS Guidance with additional guidance for public sector entities in guidance entitled: \"Clean Water Act Financial Capability Assessment Guidance March 2024 Revision\" (EPA-800-B-24-001, hereafter termed \"FCA Guidance\").\n\nThe FCA Guidance supplements the public sector portion of the 1995 WQS Guidance by recommending additional analyses, an Expanded Economic Impact Matrix, and additional methods to more thoroughly consider the potential effects on low-income households and to communities with potential environmental justice concerns. This spreadsheet tool is an update to previous versions of the public sector spreadsheet tools reflecting the supplemental FCA guidance. This particular spreadsheet tool supports WQS decisions related to revising designated uses and WQS variances. A similar spreadsheet tool is available for analyses related to antidegradation reviews. The EPA's FCA Guidance does not revise the recommended methodology for private sector entities recommended in the 1995 WQS Guidance.\n\nThis tool guides the user through the recommended analytical steps in the 1995 WQS Guidance and FCA Guidance. These analytical steps include the Municipal Preliminary Screener and Secondary Score analyses described in the 1995 WQS Guidance, and the Lowest Quintile Poverty Indicator analysis, Financial Alternatives Analysis, and recommendations for WQS decisions described in the FCA Guidance. This tool describes the data and information needed to perform these analyses, how to obtain the data and information, helps organize and store the data and information, and performs many of the recommended calculations and evaluations. This tool displays the data, information and analytical results in a way that can be used to inform a demonstration of substantial and widespread economic and social impacts when submitting WQS variances or designated use revisions to EPA for review."]
[null,"The instructions and descriptions of the analytical steps in this tool are adapted from selected portions of EPA's 1995 WQS Guidance and FCA Guidance to help the user perform the economic analysis described in those guidance documents. This tool does not replace the 1995 WQS Guidance or FCA Guidance. The user should refer to the 1995 WQS Guidance and FCA Guidance when using this tool to perform the recommended analysis and when using the outputs of this tool to make WQS decisions."]
[]
[null,"General Instructions"]
[null,"The worksheets displayed as tabs along the bottom of the screen provide access to instructions and sequential steps in the analysis described in EPA's 1995 WQS Guidance and FCA Guidance. The EPA recommends addressing each worksheet sequentially from left to right. The numbered tabs with a blue background and black text are worksheets where data are entered and/or calculation results are displayed, and the tabs without numbers with a black background and white text are worksheets that display information that may be useful but does not require user input. Cells that require manual entry of data by the user are shaded green. Cells under the heading \"Comments and Sources\" may be used to store information about entered data.\n\nBelow is a short description of each worksheet:"]
[null,"Purpose and Instructions. This worksheet."]
[null,"Overview. Displays a flowchart describing the recommended steps to help determine if the costs of the pollutant control project necessary to meet the designated use will likely result in substantial and widespread impacts (see Figure 2-1 in the 1995 WQS Guidance, edited to include Lowest Quintile Poverty Indicator and Financial Alternatives Analysis components. No input is required."]
[null,"1. Project Information. Enter information about the proposed project. The most cost-effective approach to meeting water quality standards should be considered in the analysis. The analysis should include assumptions about excess capacity, population growth, and consideration of alternative technologies. An accurate estimate of project costs may be available from the project's design engineers. If site-specific engineering cost estimates are not available, preliminary project cost estimates can sometimes be derived from a comparable project in the State or from the judgment of experienced water pollutant control engineers. See Section 2.1.a in EPA's 1995 WQS Guidance for more information. "]
[null,"2. Demographic Data. Obtain demographic data for the community and the state, authroized tribe, or territory in which the service area is located. Enter the information the tool will need to download relevent Census Bureau Data. Then select a community from the drop-down list that most closely represents the service area of the public entity constructing the pollutant control project. Census Bureau Data tables to generate Census Bureau demographic data used to calculate the Municipal Preliminary Screener, Secondary Score, and Lowest Quintile Poverty Indicator analyses."]
[null,"3. MPS. Enter information that will be used to calculate and evaluate the Municipal Preliminary Screener (MPS). The MPS is the average annualized pollutant control cost per household as a percent of median householde income of the affected community."]
[null,"4 Secondary Test. If the MPS suggests substantial impacts may occur, continue with the analysis by performing the Secondary Test. Enter financial and socioeconomic data for the affected community. The tool will automatically calculate the Secondary Test Score at the bottom of the worksheet."]
[null,"5. LQPI. Review the demographic data of the community previously selected Lowest Quintile Poverty Indicator (LQPI) calculation. No input in needed because the tool calcuates the LQPI score automatically from the downloaded Census Bureau data."]
[null,"6. FAA Checklist. Continue with the Financial Alternatives Analysis (FAA). A Financial Alternatives Analysis should document efforts toward considering feasible steps to reduce costs and address impacts to low-income households (see Section II.a.4 and Appendix C in the FCA Guidance for more information)."]
[null,"7. Results of Impacts Analysis. Displays the MPS, Secondary Test, and LQPI results, and evaluates them with the Initial Economic Impact Matrix and Explanded Economic Impact Matrix. If the Expanded Economic Impact Matrix suggests that the impacts are not likely to be substantial, then performing the widespread analysis is not necessary. Otherwise, proceed with evaluation of whether the impacts are also likely to be widespread."]
[null,"8. WQS Decision Table. The table in this worksheet replicates Exhibit 13 in the FCA Guidance. After indicating whether a Financial Alternatives Analysis was completed, the tool highlights the recommendation in the WQS decision."]
[null,"9. Widespread Impact Analysis. If the Expanded Economic Impacts Matrix suggests that impacts are likely to be substantial, determine if the substantial impact would also be widespread. EPA's guidance does not recomend standard economic tests or benchmarks to evaluate whether or not a substantial economic impact would also be widespread. Instead, use this worksheet to describe relative changes in socioeconomic conditions such as unemployment, local economic activity, household income, tax revenues, indirect effects on other businesses, and sewer fees.  The purpose of this worksheet is to help you collect and organize information you may consider when evaluating impacts on the surrounding community. See Section 4 in the 1995 WQS Guidance for additional information."]
[null,"Potential Data Sources. This worksheet provides information on potential sources of data needed to complete the secondary test in the worksheet (See 1995 WQS Guidance worksheets E and T). No input is required."]
[null,"Change log. Describes bug fixes and other modifications that have been made since the original spreadsheet was posted to the EPA website."]
[]
[null,"Comparison to Worksheets in the Guidance"]
[null,"The tool provides suggested information and methods to evaluate economic impacts for WQS decisions. The worksheets are not exhaustive of all appropriate economic analyses. Alternative or additional information and tests may be necessary or desirable in some circumstances. The principles and methods used to evaluate financial capability in this tool are the same principles and methods used in the 1995 WQS Guidance and FCA Guidance. However, this workbook tool is not a substitute or replacement for EPA's 1995 WQS Guidance and FCA Guidance. The user should refer to the appropriate pages in those guidance documents for assistance on specific topics or calculations."]
[null,"The FCA Guidance is available at:"]
[null,"https://www.epa.gov/waterfinancecenter/clean-water-act-financial-capability-assessment-guidance"]
[null,"The 1995 WQS Guidance is available at:"]
[null,"https://www.epa.gov/wqs-tech/economic-guidance-water-quality-standards"]

{"sheet":"Overview","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,7],[25,1,25,7],[26,1,26,7],[11,2,12,2],[14,6,15,6],[2,1,2,7],[3,1,3,7],[24,1,24,7],[17,6,18,6]]}
[]
[null,"Evaluating Substantial and Widespread"]
[null,"Description \n\nThis flowchart, adapted from Figure 2-1 in the EPA's 1995 WQS Guidance and including additional steps recommended in the EPA's FCA Guidance, provides a summary of the steps involved in performing EPA's recommended analysis to demonstrate substantial and widespread economic and social impacts. No input is required."]
[]
[]
[null,null,null,null,"1. Estimate Total Pollutant Control Costs"]
[null,null,null,null,"Capital Cost & Annual O&M Cost of Existing and Proposed Pollutant Controls"]
[]
[null,null,null,null,"2. Annualize Total Pollutant Control Costs"]
[null,null,null,null,"Annual Cost of Existing and Proposed Pollutant Reductions"]
[]
[null,null,"Refer to Chapter 3 of 1995 WQS Guidance if\nnon-residential costs are anticipated to be substantial","Non-Residential Costs","3. Allocate Total Pollutant Control Costs"]
[null,null,null,null,"Residential, Industrial, \nCommercial, Others"]
[null,null,null,null,"Residential\nCosts"]
[null,null,null,null,"4. Screening Process","Yes","Request Rejected"]
[null,null,null,null,"Is it clear that municipality will not face substantial economic impacts?"]
[null,null,null,null,"No"]
[null,null,null,null,"5. Secondary Analysis, Lowest Quintile Poverty Indicator, and Financial Alternatives Analysis",null,"Request Rejected"]
[null,null,null,null,"Determine whether municipality will incur substantial impacts based on (1) the cost of pollutant control, (2) the characterization of municipality's current financial and socioeconomic well-being, (3) the prevalence and severity of poverty, and (4) the results of the Financial Alternatives Analysis","No Substantial Impacts"]
[null,null,null,null,"Substantial\nImpacts"]
[null,null,null,null,"Proceed to analysis of widespread impacts in Chapter 4 of 1995 WQS Guidance"]
[null,null,null,null,"Substantial\nand\nWidespread\nImpacts"]
[null,null,null,null,"Refer to Exhibit 13 in EPA's FCA Guidance:\nRecommendations for Making WQS Decisions for the Public Sector "]
[]
[]
[null,"Supplementary Notes"]
[null,"See the appropriate pages in EPA's guidance documents for assistance on specific topics or calculations. EPA intends for this spreadsheet tool to be used in conjunction with the EPA's 1995 WQS Guidance and FCA Guidance. This tool does not substitute for or replace the EPA's 1995 WQS Guidance or FCA Guidance."]

{"sheet":"1. Project Information","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,1,19,3],[20,1,21,1],[20,2,20,3],[17,1,17,3],[15,1,15,3],[14,1,14,3],[16,1,16,3],[4,1,4,3],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[5,1,5,3]]}
[]
[null,null,"Green shaded cells are for data entry"]
[]
[]
[null,"Pollutant Control Project Summary (1995 WQS Guidance Worksheet A)"]
[null,"Description\nThis worksheet provides a location to document the pollutant control project(s) needed to attain the designated use.\n \nInstructions\nEnter information on the most cost-effective approach to attain the designated use. The most accurate estimate of project costs may be available from the discharger's design engineers. If site-specific engineering cost estimates are not available, preliminary project cost estimates may be derived from a comparable project in the State or from the judgment of experienced water pollutant control engineers. \n\nDischarge management options to consider include:\n• Pollutant prevention\n• End-of-pipe treatment\n• Upgrades or additional to existing treatment\n\nTypes of pollutant prevention activities to consider are:\n• Public education\n• Change in raw materials\n• Substitution of process chemicals\n• Change in process\n• Water recycling and reuse\n• Pretreatment requirements\n\nWhatever the approach, the information must demonstrate that the proposed project will result in attaining the designated use and fully document project cost estimates. If at least one of the options that results in attaining the designated use will not have a substantial financial impact, then do not proceed with the analysis."]
[]
[null,"Description",null,"Data"]
[null,"Current Capacity of the Pollutant Control System (MGD)"]
[null,"Design Capacity of the Pollutant Control System (MGD)"]
[null,"Current Excess Capacity (%)"]
[null,"Expected Excess Capacity after Completion of Project (%)",{"$f":"IF(AND(C9=\"\",C10=\"\",C11=\"\"),\"\",SUM(C9:C11))","v":""}]
[null,"Projected Groundbreaking Date (MM/DD/YYYY)"]
[null,"Projected Date of Completion (MM/DD/YYYY)"]
[null,"Describe the proposed pollutant control project:"]
[]
[null,"Describe the other pollutant control options considered, explaining why each option was rejected:"]
[]
[]
[null,"Guidance Documentation"]
[null,"Component","1995 WQS Guidance"]
[null,null,"Section","Page"]
[null,"Verify Project Costs","2.1.a","2-3"]
[null,"Documentation of Other Options Considered","2.1.a","2-3"]
[null,"Annual Cost of Pollutant Control (overview)","2.1.b","2-4"]

{"sheet":"2. Demographic Data","index":3,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,13],[5,1,6,13],[17,1,17,13],[14,1,14,13],[8,1,8,13],[9,3,9,13],[10,3,10,13],[11,3,11,13],[12,3,12,13],[7,1,7,13],[13,1,13,13]]}
[]
[null,null,"Green shaded cells are for data entry"]
[]
[]
[null,"Instructions for Downloading and Selecting Census Bureau Demographic Data"]
[null,"This worksheet retrieves demographic data directly from the Census Bureau (internet connection required) and allows the user to select Census data for the community economically impacted by the proposed pollutant control project.\n\nComplete the \"Download Census Bureau Demographic Data\" table.\n1) Select the two-letter state code for the state in which the community is located. \n2) Enter the year of the most recent 5-year American Community Survey (ACS) by the Census Bureau.\n3) Click the circular arrows to download Census Bureau 5-year ACS data for the state and year entered.\n\nComplete the \"Select Census Bureau Data\" table.\nSelect the Census Bureau economic place from the drop-down list in column B that most closely corresponds to the community impacted by the proposed pollutant control project. Data from the Census Bureau for that community will populate the appropriate cells throughout the wookbook.\n\nData Sources\nDemographic data inputs for the Municipal Preliminary Screener, Secondary Score, and Lowest Quintile Poverty Indicator analyses are 5-year Census Bureau ACS estimates ending the year entered. These data are obtained from the following Census Bureau ACS data tables:\n\n• Table B25002: Occupancy Status (used for Municipal Preliminary Screener and Lowest Quintile Poverty Indicator)\n• Table B19013: Median Household Income in the Past 12 Months (used for Municipal Preliminary Screener and Secondary Score)\n• Table B19080: Household Income Quintile Upper Limits (used for the Lowest Quintile Poverty Indicator)\n• Table S1701: Poverty Status in the Past 12 Months (used for the Lowest Quintile Poverty Indicator)\n• Table S2201: Food Stamps/Supplemental Nutrition Assistance Program (SNAP) (used for the Lowest Quintile Poverty Indicator)\n• Table DP03: Selected Economic Characteristics (used for Secondary Score and Lowest Quintile Poverty Indicator)\n• Table B01003: Total Population (used for Secondary Score as an Alternative Indicator)\n\nNotes\nTo determine the year of the most recent 5-year ACS, see: https://www.census.gov/programs-surveys/acs/news/data-releases.html. \nAfter you have downloaded Census Bureau data and selected the appropriate community, the tool will automatically populate all cells requiring Census data.\n\nManually Entering Census Bureau Data\nIf data downloaded from the Census Bureau using this tool is missing or otherwise inappropriate for the community you are analyzing (for example, a different Census geography such as county, county subdivision, or subminor civil division would be a more appropriate representation of the impacted community), you may obtain the appropriate data from the Census Bureau website at: https://data.census.gov and manually enter the Census Bureau data into row 19. Note that manually entering data into cells in row 19 of the Select Census Bureau Data table will permanently remove the automatic Census data retrieval function for those cells. If you want to restore the automatic Census data retrieval function for those cells, you may do so by restarting the analysis with an original version of the tool."]
[]
[]
[null,"Download Census Bureau Demographic Data"]
[null,"Description","Input","Comments"]
[null,"Two-Letter State Abbreviation",null,"Use the drop-down list to select the two-letter abbreviation for the state where the community is located."]
[null,"Census Data Year",null,"Enter the most recent 5-year American Community Survey (ACS) Census data year."]
[null,"Download Census Bureau 5-Year ACS data",null,"Click the circular arrows to the left after selecting the two-letter state code and entering the desired Census data year."]
[]
[null,"Select Census Bureau Data"]
[null,"Demographic Data\n\n(INPUT DATA FROM 5-YEAR ACS, CENSUS BUREAU)","GEO_ID","State","Number of Occupied Housing Units (B25002)","Population\n(B01003)","Median Household Income (B19013)","State Median Household Income (B19013)","Upper Limit of Lowest Quintile Income (B19080) ","Percentage of Population with Income Below 200% of Federal Poverty Level (S1701) ","Percentage of Households Receiving Food Stamps/SNAP Benefits (S2201) ","Percentage of Vacant Housing Units (B25002)","Trend in Household Growth (B25002) ","Percentage of Unemployed Population 16 and Over in Civilian Labor Force (DP03)"]
[null,"Applicable National and State Data",1,{"$f":"IF(C11=\"\",\"\",C11)","v":""},"N/A","N/A",{"$f":"National_B_tables[Column6]/1","v":0},{"$f":"IFERROR(VALUE(INDEX(State_B_tables[Column2],MATCH(INDEX(API_calls!$C$2:$C$58,MATCH($D$17,API_calls!$B$2:$B$58,0)),State_B_tables[Column3],0))),\"\")","v":""},{"$f":"IFERROR(National_B_tables[Column3],\"\")","v":0},{"$f":"IFERROR(National_S_tables[Column2]/National_S_tables[Column3],\"\")","v":""},{"$f":"IFERROR(National_S_tables[Column4]/National_S_tables[Column5],\"\")","v":""},{"$f":"IFERROR(National_B_tables[Column5]/National_B_tables[Column4],\"\")","v":""},"N/A",{"$f":"IFERROR(National_DP_tables[Column2]/100,\"\")","v":0}]
[null,"Select Service Area Community from List Below"]
[null,null,{"$f":"IFERROR(VLOOKUP($B19,'Place B tables'!A:I,9),\"\")","v":""},{"$f":"IF(OR($B$19=\"\",$C$11=\"\"),\"\",INDEX(API_calls!A$2:A$58,MATCH(C11,API_calls!B2:B58,0)))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place B tables'!E:E,MATCH($C19,'Place B tables'!I:I,0)))=-666666666,VALUE(INDEX('Place B tables'!E:E,MATCH($C19,'Place B tables'!I:I,0)))=2499),\"N/A\",VALUE(INDEX('Place B tables'!E:E,MATCH($C19,'Place B tables'!I:I,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place B tables'!B:B,MATCH($C19,'Place B tables'!I:I,0)))=-666666666,VALUE(INDEX('Place B tables'!B:B,MATCH($C19,'Place B tables'!I:I,0)))=2499),\"N/A\",VALUE(INDEX('Place B tables'!B:B,MATCH($C19,'Place B tables'!I:I,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place B tables'!G:G,MATCH($C19,'Place B tables'!I:I,0)))=-666666666,VALUE(INDEX('Place B tables'!G:G,MATCH($C19,'Place B tables'!I:I,0)))=2499),\"N/A\",VALUE(INDEX('Place B tables'!G:G,MATCH($C19,'Place B tables'!I:I,0)))))","v":""},{"$f":"IF($D19=\"\",\"\",IF(OR(VALUE(INDEX('State B tables'!B:B,MATCH($D19,'State B tables'!A:A,0)))=-666666666,VALUE(INDEX('State B tables'!B:B,MATCH($D19,'State B tables'!A:A,0)))=2499),\"N/A\",VALUE(INDEX('State B tables'!B:B,MATCH($D19,'State B tables'!A:A,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place B tables'!C:C,MATCH($C19,'Place B tables'!I:I,0)))=-666666666,VALUE(INDEX('Place B tables'!C:C,MATCH($C19,'Place B tables'!I:I,0)))=2499),\"N/A\",VALUE(INDEX('Place B tables'!C:C,MATCH($C19,'Place B tables'!I:I,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place S tables'!B:B,MATCH($C19,'Place S tables'!G:G,0)))=-666666666,VALUE(INDEX('Place S tables'!C:C,MATCH($C19,'Place S tables'!G:G,0)))=-666666666,VALUE(INDEX('Place S tables'!B:B,MATCH($C19,'Place S tables'!G:G,0)))=2499,VALUE(INDEX('Place S tables'!C:C,MATCH($C19,'Place S tables'!G:G,0)))=2499),\"N/A\",VALUE(INDEX('Place S tables'!B:B,MATCH($C19,'Place S tables'!G:G,0)))/VALUE(INDEX('Place S tables'!C:C,MATCH($C19,'Place S tables'!G:G,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place S tables'!D:D,MATCH($C19,'Place S tables'!G:G,0)))=-666666666,VALUE(INDEX('Place S tables'!E:E,MATCH($C19,'Place S tables'!G:G,0)))=-666666666,VALUE(INDEX('Place S tables'!D:D,MATCH($C19,'Place S tables'!G:G,0)))=2499,VALUE(INDEX('Place S tables'!E:E,MATCH($C19,'Place S tables'!G:G,0)))=2499),\"N/A\",VALUE(INDEX('Place S tables'!D:D,MATCH($C19,'Place S tables'!G:G,0)))/VALUE(INDEX('Place S tables'!E:E,MATCH($C19,'Place S tables'!G:G,0)))))","v":""},{"$f":"IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place B tables'!$F$2:$F$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))=-666666666,VALUE(INDEX('Place B tables'!$D$2:$D$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))=-666666666,VALUE(INDEX('Place B tables'!$F$2:$F$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))=2499,VALUE(INDEX('Place B tables'!$D$2:$D$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))=2499),\"N/A\",VALUE(INDEX('Place B tables'!$F$2:$F$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))/VALUE(INDEX('Place B tables'!$D$2:$D$4328,MATCH($C19,'Place B tables'!$I$2:$I$4328,0)))))","v":""},{"$f":"IFERROR(IF(B19=\"\",\"\",IF(OR(E19=\"N/A\",INDEX('Place B tables 5 years earlier'!B:B,MATCH(C19,'Place B tables 5 years earlier'!D:D,0))=-666666666,INDEX('Place B tables 5 years earlier'!B:B,MATCH(C19,'Place B tables 5 years earlier'!D:D,0))=2499),\"N/A\",(1+(E19-INDEX('Place B tables 5 years earlier'!B:B,MATCH(C19,'Place B tables 5 years earlier'!D:D,0)))/INDEX('Place B tables 5 years earlier'!B:B,MATCH(C19,'Place B tables 5 years earlier'!D:D,0)))^(1/5)-1)),\"N/A\")","v":""},{"$f":"IFERROR(IF($C19=\"\",\"\",IF(OR(VALUE(INDEX('Place DP tables'!D:D,MATCH($C19,'Place DP tables'!F:F,0)))=-666666666,VALUE(INDEX('Place DP tables'!D:D,MATCH($C19,'Place DP tables'!F:F,0)))=2499),\"N/A\",VALUE(INDEX('Place DP tables'!D:D,MATCH($C19,'Place DP tables'!F:F,0))))/100),\"\")","v":""}]
[null,"Explanation if manually entered:"]

{"sheet":"3. MPS","index":4,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[[39,1,39,4],[41,1,41,4],[40,1,40,4],[37,1,37,4],[49,1,49,4],[38,1,38,4],[58,1,58,4],[56,1,56,4],[61,1,61,4],[59,1,59,4],[50,1,50,4],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[91,1,91,4],[92,3,92,4],[92,1,93,2],[89,1,89,4],[70,1,70,4],[79,1,79,4],[86,1,86,4],[77,1,77,4],[73,1,73,4],[76,1,76,4],[74,1,74,4],[75,1,75,4],[5,1,5,4],[27,1,27,4],[34,1,34,4],[36,1,36,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[11,1,11,4],[10,1,10,4]]}
[]
[null,null,"Green shaded cells are for data entry"]
[null,null," Note: Line numbering in Worksheets B, C, and D are not consecutive; lines start at \"1\" at the beginning of each worksheet."]
[]
[]
[null,"Municipal Preliminary Screener (1995 WQS Guidance Worksheets B, C, C: Option A, and D)"]
[null,"The Municipal Preliminary Screener (MPS) is designed to identify a community that will clearly not experience substantial impacts due to the cost of the propoosed pollutant control project. Calculating the MPS involves three steps:\n\n1. Calculate the total annual cost of the proposed pollutant control project.\n2. Calculate the total annualized pollutant control cost per household.\n3. Calculate and evaluate the municipal preliminary screener score. \n\nBelow is a description of each step followed by cells to enter the data needed to calculate the MPS."]
[]
[null,"Total Annualized Pollutant Control Costs (1995 WQS Guidance Worksheet B)"]
[null,"Calculation of the annual cost of the pollutant control project involves the evaluation of capital costs and operaton and maintanence (O&M) costs.\n\nBecause capital costs typically will be paid over several years, annualized costs are used in the evaluation of economic burden to the community. The capital portion of project costs is typically financed over approximately 20 years by issuing a municipal debt instrument such as a general obligation bond or a revenue bond. Local governments may also finance capital costs using bank loans, state infrastructure loans (revolving funds), or federally subsidized loans (such as those offered by the Farmers' Home Administration).\n\nIt should be noted that interest rates used to annualize costs are dependent on the type of debt instrument used as well as the recipient's credit standing. For example, revenue bonds typically are financed at a slightly higher interest rate because of their dependence on revenues from services as opposed to being guaranteed by the full faith and credit of the jurisdiction. Because interest rates affect the interest payment and thus the annualized capital cost of the project, it is important that the interest rate used in this worksheet reflects the debt instrument (i.e. municipal bond, commercial bank loan, state revolving fund loan, or other instrument) likely to be used by the municipality.\n\nThe tool calculates annual capital cost by summing all capital cost components and deducting the portion of costs to be paid by grants (costs paid by grants will not need to be financed). The tool automatically calculates the annualization factor. The tool then calculates annualized capital cost by multiplying the total capital costs to be financed by the annualization factor.\n\nThe tool calculates total O&M costs by summing the annual operating and maintenance costs components. These costs should include the costs of monitoring, inspection, permitting fees, waste disposal charges, repair, administration, replacement, and any other recurring costs. All recurring costs should be entered as dollars per year. The sum of the annualized capital costs and annual operating costs and maintenance costs is the total annual cost of the pollutant control project.\n\nCalculate the total annualized cost of the project below by entering the appropriate data in the green-shaded cells below."]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"A. Capital Costs",null,{"$f":"IF(D21>D20,\"Capital costs to be paid by grants exceed total capital costs\",\"\")","v":""}]
[null,null,"Capital Cost of Project ($) - Input required"]
[null,null,"Other One-Time Costs of Project (if any)"]
[null,null,"[One-Time Cost of Project, Component A] ($)"]
[null,null,"[One-Time Cost of Project, Component B] ($)"]
[null,null,"[One-Time Cost of Project, Component C] ($)"]
[null,1,"Total Capital Costs",{"$f":"IF(_xlfn.CONCAT(D15:D19)=\"\",\"\",SUM(D15:D19))","v":""}]
[null,2,"Capital Costs to be Paid by Grants ($) - Input required"]
[null,3,"Capital Costs to be Financed (Line 1 - Line 2)",{"$f":"IF(OR(D20=\"\",D21=\"\"),\"\",D20-D21)","v":""}]
[null,null,"Type of Financing (e.g., G.O. bond, revenue bond, SRF loan, bank loan)"]
[null,"i","Interest Rate for Financing (%) - Input required"]
[null,"n","Time Period of Financing (Years) - Input required"]
[null,4,"Annualization Factor",{"$f":"IFERROR(D24/((1+D24)^D25-1)+D24,\"\")","v":""}]
[null,5,"Annualized Capital Cost (Line 3 * Line 4)",{"$f":"IFERROR(D22*D26,\"\")","v":""}]
[null,"B: Operating and Maintenance Costs (at least one \"Annual Operation and Maintenance Expenses Component\" cell below requires input)"]
[null,null,"[Annual Operation and Maintenance Expenses Component A] ($) - Input required"]
[null,null,"[Annual Operation and Maintenance Expenses Component B] ($)"]
[null,null,"[Annual Operation and Maintenance Expenses Component C] ($)"]
[null,null,"[Annual Operation and Maintenance Expenses Component D] ($)"]
[null,null,"[Annual Operation and Maintenance Expenses Component E] ($)"]
[null,6,"Total Annual O&M Costs",{"$f":"IF(_xlfn.CONCAT(D29:D33)=\"\",\"\",SUM(D29:D33))","v":""}]
[null,"C. Total Annual Cost of Pollutant Control Project","[Annual Debt Service Component A]"]
[null,7,"Total Annual Cost of the Pollutant Control Project (Line 5 + Line 6)",{"$f":"IFERROR(D27+D34,\"\")","v":""}]
[]
[null,"Total Annual Pollutant Control Costs per Household (1995 WQS Guidance Worksheet C and Worksheet C Option A)"]
[null,"To assess the economic burden that the total pollutant control cost is expected to have on the community, an average annualized pollutant control cost per household is calculated for households that would bear the cost of the proposed pollutant control project. Such an assessment requires an understanding of which households will actually pay for the costs of the pollutant control project as well as the proportion of costs those households will incur. The apportioned project costs are then added to existing pollutant control costs paid by households to calculate total pollutant control cost per household.\n\nTo assess the cost per household, it is important to first define the affected community. The \"community\" are the households within the governmental jurisdiction responsible for paying compliance costs. In practice, pollutant control projects may serve several communities or just portions of a community. In the case of a sewage agency serving several communities, once project costs are allocated to each community served, the economic analysis is conducted on a community by community basis. In the case of a community in which only a portion of the community is served, the affected community is defined as those who will pay the compliance costs. In such cases, it may be difficult to obtain socioeconomic data for just part of the community and data for the entire community may be used instead. The area that is affected may not be the same as the area that is paying.In such cases, it may be necessary to evaluate widespread impacts, described in Chapter 4 of EPA's 1995 WQS guidance, over a community that is defined differently than the paying community.\n\nIf project costs were estimated for a prior year, these costs should be adjusted upward to reflect current year prices using the average annual national Consumer Price Index (CPI) inflation rate for the period. An adjustment factor can calculated as the current CPI divided by the CPI for the year project costs were estimated. You can obtain the CPI from the Bureau of Labor Statistics website at: https://www.bls.gov/cpi. Likewise, there are engineering cost indices that can be used for this purpose."]
[null,"If project costs are not distributed simply according to wastewater flow or tax revenues, then consideration should be given to separately analyzing the impacts on users who pay a disproportionate share of the costs. This situation can arise, for example, where industrial dischargers to a sewer system are assessed pollutant surcharges to pay for their share of the cost of advanced treatment necessitated by the presence of their pollutants. Remaining costs would then be split among households according to wastewater flow or tax revenues, whichever is appropriate. The total amount of the pollutant control project to be recouped by surcharges should, therefore, be removed from the total project cost before costs are allocated according to wastewater flow or tax revenues. For guidance in estimating impacts on non-household users (e.g., industrial, commercial), refer to Chapter 3 in the 1995 WQS Guidance.\n\nWhen calculating the total annual cost of pollutant control per household, current costs of pollutant control should be considered along with the projected annual costs of the proposed pollutant control project. The existing cost per household usually can be obtained from the most recent municipal records. For example, it can be found in the sewer enterprise fund accounts for communities that maintain a separate enterprise fund. It is not necessary, in such cases, to sum all the cost components. Instead, use the most recent operating revenues, divided by the number of households served. In cases where the community does not maintain a separate enterprise fund for sewers, the cost elements can be summed from the consolidated statement for the community. If the portion of proposed project costs that households are expected to pay is known or is expected to remain unchanged, then use 1995 WQS Guidance Worksheet C to calculate the total annual cost of pollutant control per household. If the portion paid by households is based on flow, then the user should refer to the 1995 WQS Guidance Worksheet C Option A as well.\n\nCalculate the total annual pollutant control costs per household below."]
[]
[null,"Calculation of Total Annual Pollutant Control Costs Per Household (1995 WQS Guidance Worksheet C)"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"A. Current Pollution Control Costs",null,{"$f":"IF(AND(ISNUMBER(D47),D47>1),\"Existing costs paid by households exceed total annual existing costs\",\"\")","v":""}]
[null,1,"Total Annual Cost of Existing Pollution Control ($) - Input required"]
[null,2,"Amount of Existing Costs Paid by Households ($) - Input required"]
[null,3,"Percent of Existing Costs Paid by Households (Line 2 / Line 1)",{"$f":"IF(OR(D46=\"\",D45=\"\"),\"\",D46/D45)","v":""}]
[null,4,"Number of Households",{"$f":"'2. Demographic Data'!E19","v":""}]
[null,5,"Annual Cost per Household (Line 2 / Line 4)",{"$f":"IF(OR(D46=\"\",D48=\"\"),\"\",D46/D48)","v":""}]
[null,"B. New Pollutant Control Costs"]
[null,"If households are expected to provide revenues for the new pollutant control projects in the same proportion that they support existing pollutant control, select the \"Yes\" option in the drop-down list in Line 6 below and continue to the Municipal Preliminary Screener section at the bottom of this worksheet.\n\nIf households are not expected to provide revenues for the new pollutant control project in the same proportion that they support existing pollutant control, you should select one of the \"No\" options from the drop-down list in Line 6 below:\n\n>  If you select \"No, they are expected to pay a different proportion\", enter the proportion as a percentage in line 8.\n\n>  If you select \"No, they are expected to pay based on flow\", the remainder of that section will become inactive and the section below it (1995 WQS Guidance Worksheet C: Option A) will become active. You should then enter the necessary values in that section.\n\nNote: If you select \"No, they are expected to pay a different proportion\" in Line 6 and enter a value in Line 8, but then later change your answer to \"Yes,\" you must manually enter the value from Line 3 (\"Percent of Existing Costs Paid by Households\") into Line 8 because entering a value in Line 8 will remove the formula that retrieves the value in Line 3."]
[null,6,"Are households expected to provide revenues for the new pollutant control projects in the same proportion that they support existing pollutant control? (Selection of the appropriate response from the drop-down list is required)"]
[null,7,"Total Annual Cost of Pollutant Control Project ($)",{"$f":"D36","v":""}]
[null,8,"Percentage of Costs Households are Expected to Pay (if different than percentage in Line 3)"]
[null,9,"Amount to be Paid by Households (Line 7 * Line 8)",{"$f":"IF(D52=\"No, they are expected to pay based on flow\",\"Not applicable\",IF(D54=\"\",\"\",IFERROR(D53*D54,\"\")))","v":""}]
[null,10,"Annual Cost per Household (Line 9 / Line 4)",{"$f":"IF(D52=\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D55/D48,\"\"))","v":""}]
[null,"C. Total Annual Pollutant Control Cost per Household "]
[null,11,"Total Annual Cost of Pollutant Control per Household (Line 5 + Line 10)",{"$f":"IF(D52=\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D49+D56,\"\"))","v":""}]
[]
[null,"Calculation of New Pollutant Control Costs Per Household Based on Flow (1995 WQS Guidance Worksheet C, Option A)"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"A. Calculating Project Costs Incurred by Households Based on Flow"]
[null,1,"Expected Total Usage of Project (e.g., MGD for Wastewater Treatment)"]
[null,2,"Usage due to Household Use (MGD of Household Wastewater)"]
[null,3,"Percent of Usage due to Household Use (Line 2 / Line 1)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D64/D63,\"\"))","v":"Not applicable"}]
[null,4,"Total Annual Cost of Pollutant Control Project (1995 WQS Guidance Worksheet C, Line 7)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",D53)","v":"Not applicable"}]
[null,5,"Industrial Surcharges, if any ($) (Cell requires input)"]
[null,6,"Costs to be Allocated (Line 4 - Line 5)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D66-D67,\"\"))","v":"Not applicable"}]
[null,7,"Amount to be Paid by Households (Line 3 * Line 6)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D65*D68,\"\"))","v":"Not applicable"}]
[null,8,"Annual Project Cost per Household (Line 7 / 1995 WQS Guidance Worksheet C, Line 4)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D69/D48,\"\"))","v":"Not applicable"}]
[null,"C. Total Annual Pollutant Control Cost per Household","Total Current and Projected Costs",{"$f":"IF(AND(#REF!=\"\",#REF!=\"\"),\"\",SUM(#REF!,#REF!))","v":{"$error":"#REF!"}}]
[null,9,"Annual Existing Costs per Household (1995 WQS Guidance Worksheet C, Line 5)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",D49)","v":"Not applicable"}]
[null,10,"Total Annual Cost of Pollutant Control per Household (Line 8 + Line 9)",{"$f":"IF(D52<>\"No, they are expected to pay based on flow\",\"Not applicable\",IFERROR(D70+D72,\"\"))","v":"Not applicable"}]
[]
[null,"Municipal Preliminary Screener"]
[null,"The Municipal Preliminary Screener (MPS) helps establish whether the community can clearly pay for the proposed pollutant control project without incurring substantial impacts. The MPS is an estimate of the total annual pollutant control costs per household (existing costs plus those attributable to the proposed project) as a percentage of median household income. The MPS can be represented as the equation:\n\nMunicipal Preliminary Screener = Average Total pollutant Control Cost per Household / Median Household Income\n\nIf the dollar year of median household income is not available for the current year, it can be adjusted to the current year by calculating an adjustment factor using the Consumer Price Index (CPI) for the year that median household income is available and the current year.\n\nDepending on the results of the MPS, the community is expected to incur little, mid-range, or large economic impacts due to the proposed project (see Worksheet D in the 1995 WQS Guidance). If the total annual cost per household (existing annual cost per household plus the incremental cost related to the proposed project) is less than 1.0 percent of median household income, it is assumed that the project is not expected to impose a substantial economic hardship on households. Communities with screener results of less than 1.0 but still fairly close to 1.0, however, may still want to proceed with the analysis. Communities are expected to incur mid-range impacts when the ratio of total annual compliance costs to median household income is between 1.0 and 2.0 percent. If the average annual cost per household exceeds 2.0 percent of median household income, then the project may place an unreasonable financial burden on many of the households within the community. In either case, communities move on to the Secondary Score, Lowest Quintile Poverty Indicator, and the Financial Alternatives Analysis.\n\nCalculate the MPS below."]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"A. Calculation of the Municipal Preliminary Screener"]
[null,1,"Total Annual Pollutant Control Cost per Household (1995 WQS Guidance Worksheet C, Line 11 or 1995 WQS Guidance Worksheet C: Option A, Line 10)",{"$f":"IF(D52=\"No, they are expected to pay based on flow\",D73,D58)","v":""}]
[null,null,"Median Household Income (from Census Bureau ACS)",{"$f":"'2. Demographic Data'!G19","v":""}]
[null,null,"Current CPI (if necessary)"]
[null,null,"CPI for the year of the Census Bureau (if necessary)"]
[null,null,"Median Household Income Adjustment Factor (Current CPI /CPI for the Census data year)",{"$f":"IFERROR(D83/D84,\"\")","v":""}]
[null,2,"Adjusted Median Household Income (Median Household Income * Adjustment Factor)",{"$f":"IFERROR(IF(D85=\"\",D82,D82*D85),\"\")","v":""}]
[null,"B. Evaluation of the Municipal Preliminary Screener","Permittee MHI",{"$f":"'2. Demographic Data'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Municipal Preliminary Screener (Line 1 / Line 2 * 100)",{"$f":"IFERROR(D81/D86,\"\")","v":""}]
[null,null,"Benchmark Comparison",{"$f":"IF(D88=\"\",\"\",IF(D88>0.02,\"Large Impact\",IF(D88<0.01,\"Little Impact\",\"Mid-Range Impact\")))","v":""}]
[null,"Note: If the MPS is clearly less than 1.0%, then it is assumed that the cost will not impose an undue financial burden. In this case, it is not necessary to continue with the Secondary Test, Lowest Quintile Poverty Indicator, or Financial Alternatives Analysis. Otherwise, it is necessary to continue."]
[]
[null,"Guidance Documentation"]
[null,"Component",null,"1995 WQS Guidance"]
[null,null,null,"Section","Page(s)"]
[null,"Evaluating Substantial Impacts (overview)",null,2,"2-1"]
[null,"Capital Cost","2.1a","2.1a","2-2"]
[null,"Annual Cost of Existing Pollutant Controls","2.1b","2.1b","2-3"]
[null,"Financing","2.1b","2.1b","2-4"]
[null,"Annual Cost of Operations and Maintenance","2.1b","2.1b","2-4"]
[null,"Calculate Total Annualized Pollutant Control Costs per Household",2.2000000000000002,2.2000000000000002,"2-5 to 2-6"]
[null,"Calculate and Evaluate The Municipal Preliminary Screener Value",2.2999999999999998,2.2999999999999998,"2-6 to 2-7"]
[null,"Median Household Income",2.2999999999999998,2.2999999999999998,"2-7"]
[null,"Adjusting Median Household Income","Appendix A","Appendix A","2-7"]

{"sheet":"4. Secondary Test","index":5,"n_rows":121,"n_cols":6,"rows_kept":121,"cut":false,"hidden":false,"merged":[[106,5,108,5],[82,1,82,4],[20,1,21,4],[23,1,23,4],[25,1,25,4],[45,1,45,4],[49,1,49,4],[22,1,22,4],[37,1,37,4],[48,1,48,4],[38,1,38,4],[59,1,59,4],[56,1,56,4],[60,1,60,4],[69,1,69,4],[73,1,73,4],[72,1,72,4],[70,1,70,4],[71,1,71,4],[62,1,62,4],[109,1,109,4],[83,1,83,4],[96,1,96,4],[110,1,110,4],[111,3,111,4],[111,1,112,2],[94,1,94,4],[95,1,95,4],[120,1,120,2],[113,1,113,2],[114,1,114,2],[115,1,115,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[4,1,4,4],[5,1,5,4],[7,1,7,4],[8,1,8,4],[19,1,19,4],[6,1,6,4],[10,1,10,4],[18,1,18,4],[9,1,9,4],[13,5,15,5],[57,1,57,4],[108,1,108,2],[107,1,107,3],[106,2,106,3],[35,1,35,4],[36,1,36,4],[46,1,46,4],[47,1,47,4],[58,1,58,4],[80,1,80,4],[84,1,84,4],[93,1,93,4],[97,1,97,4],[81,1,81,4],[34,1,34,4]]}
[]
[null,null,"Green shaded cells are for data entry"]
[]
[]
[null,"Secondary Test Analysis (Worksheet F in the 1995 WQS Guidance)"]
[null,"The secondary test is designed to build upon the characterization of the financial burden identified in the Municipal Preliminary Screener (MPS) by analyzing the community's ability to obtain financing, describing the socioeconomic health of the community, and characterizing the community's financial management. The secondary test uses the following six indicators in three general categories:\n\n• Debt Indicators\n   - Bond Ratings \n   - Overall Net Debt as a Percent of Full Market Property Value\n• Socioeconomic Indicators\n   - Unemployment Rate\n   - Median Household Income\n• Financial Management Indicators\n   - Property Tax Revenue Collection Rate\n   - Property Tax Revenues as a Percent of Full Market Property Value\n\nDebt Indicators: The debt indicators assess the current debt burden of the community and its ability to issue additional debt to finance pollutant control projects. \n\nSocioeconomic Indicators: The socioeconomic indicators assess the general economic well-being of the community. \n\nFinancial Management Indicators: The financial management indicators evaluate the community's overall ability to manage financial operations.\n\nMore detailed instructions for each indicator are provided below with cells to enter the data necessary to score them.  Line numbers are the same as those in Worksheet E of the 1995 WQS Guidance. The tool automatically scores them and then calculates the average score."]
[]
[null,"Bond Rating"]
[null,"Description\nCurrent ratings for the community summarize a bond rating agency's assessment of a community's credit capacity. The ratings generally reflect current financial conditions. If security enhancements like bond insurance have been used for the bond issue, however, the bond rating on a particular issue may be higher than local conditions justify. Only ratings for uninsured bonds, therefore, should be used.\n\nMany small and medium sized communities have not used debt financing for projects and, as a result, have no bond rating. The absence of a bond rating does not indicate strong or weak financial health. When a bond rating is not available, this indicator should not be included in the analysis of substantial impacts. When available, the rating for the most recent general obligation bond should be used. If a general obligation bond has not been issued recently, the most recent rating for a sewer bond should be used.\n\nWhen available, enter the most recent general obligation bond rating in Line 4. If a general obligation bond has not been issued recently, enter the most recent rating for a sewer bond.\n\nBenchmarks\n\nMoody’s\n• Weak: Below Baa\n• Mid-Range: Baa\n• Strong: Above Baa\n\nStandard & Poor's\n• Weak: Below BBB\n• Mid-Range: BBB\n• Strong: Above BBB"]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,null,"Most Recent General Obligation Bond Rating\n> Note: if a General Obligation Bond has not been issued recently, use the most recent rating for a Sewer Bond. "]
[null,null,"Date (MM/DD/YYYY) - For documentation purposes only. Does not affect any calculations."]
[null,null,"Rating Agency"]
[null,4,"Rating"]
[null,null,"Summary",{"$f":"IF(D18=\"\",\"\",IF(D18=1,\"Weak\",IF(D18=2,\"Mid-Range\",\"Strong\")))","v":""}]
[null,null,"Score",{"$f":"IFERROR(INDEX(BondRating_vlookup!D$2:D$49,MATCH($D$16,BondRating_vlookup!A$2:A$49,0)),\"\")","v":""}]
[]
[null,"Overall Net Debt as a Percent of Full Market Value of Taxable Property"]
[null,"Some states and local jurisdictions may have established legal limits on the amount of property taxes that can be levied as a percent of full market or assessed value of real property. This indicator may not be appropriate in states with statutory limits on property tax collections and/or rates, or where data on full-market value of taxable property are not available. In such cases, this indicator can be replaced with Overall Net Debt per Capita, as discussed in a separate section at the bottom of this worksheet.\n\nDescription\nOverall Net Debt is debt repaid by property taxes. It excludes debt that is repaid by special user fees (e.g. revenue debt). This indicator provides a measure of debt burden on residents within the community and measures the ability of local government jurisdictions to issue additional debt. It includes the debt issued directly by the local jurisdiction and debt of overlapping entities such as school districts. It compares the level of debt owed by the community with the full market value of real property used to support that debt and serves as a measure of the community's wealth.\n\nThe boundary of the affected community generally conforms to one or more community boundaries. Therefore, prorating community data to reflect specific service area boundaries is not normally necessary for evaluating the general financial capability of the affected community.\n\nInstructions\nEnter data as described below.\n\n• Line 1: Enter the community's direct net debt.\n• Line 2: Enter the community's overlapping debt.\n• Line 11: The tool automatically calculates overall net debt by adding Lines 1 and 2.\n• Line 3: Enter the community's market value of taxable property.\n• Line 12: The tool automatically calculates this by dividing Line 11 by Line 3 and multiplying by 100.\n\nBenchmarks\n• Weak: Above 5%\n• Mid-Range: 2-5%\n• Strong: Below 2%"]
[]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"If property tax limitations apply, select \"Yes\" in row 27 and skip this indicator. Then, complete the alternative indicator \"Overall Net Debt per Capita\" at the bottom of this worksheet."]
[null,null,"Skip Indicator?","No"]
[null,1,"Direct Net Debt"]
[null,2,"Overlapping Debt"]
[null,11,"Overall Net Debt (Line 1 + Line 2)",{"$f":"IF(D27=\"Yes\",\"Not applicable\",IF(AND(D28=\"\",D29=\"\"),\"\",SUM(D28:D29)))","v":""}]
[null,3,"Market Value of Property"]
[null,12,"Overall Net Debt as a Percent of Full Market Value of Taxable Property (Line 11 / Line 3 * 100)",{"$f":"IF(D27=\"Yes\",\"Not applicable\",IFERROR(D30/D31,\"\"))","v":""}]
[null,null,"Summary",{"$f":"IF(D27=\"Yes\",\"Not applicable\",IF(D34=\"\",\"\",IF(D34=1,\"Weak\",IF(D34=2,\"Mid-Range\",\"Strong\"))))","v":""}]
[null,null,"Score",{"$f":"IF(D27=\"Yes\",\"\",IF(D32=\"\",\"\",IF(D32>0.05,1,IF(D32<0.02,3,2))))","v":""}]
[]
[null,"Unemployment Rate"]
[null,"Description\nThe unemployment rate is defined as the percent of a community's labor force currently unemployed.\n\nInstructions\nNo input is required. The tool automatically populates unemployment values for the community and nation from the \"2. Demographic Data\" worksheet.\n\nBenchmarks\nThe tool compares the community unemployment rate with the national average. \n• Weak: More than 1 percentage point above the national average.\n• Mid-Range: ± 1 percentage point of the national average.\n• Strong: More than 1 percentage point below national average."]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,5,"Community Unemployment Rate",{"$f":"'2. Demographic Data'!$N$19","v":""}]
[null,6,"National Unemployment Rate",{"$f":"'2. Demographic Data'!N17","v":0}]
[null,null,"Difference Between Community's Unemployment Rate and National Unemployment Rate (Line 5 - Line 6)",{"$f":"IF(OR(D41=\"\",D42=\"\"),\"\",D41-D42)","v":""}]
[null,null,"Summary",{"$f":"IF(D45=\"\",\"\",IF(D45=1,\"Weak\",IF(D45=2,\"Mid-Range\",\"Strong\")))","v":""}]
[null,null,"Score",{"$f":"IF(D43=\"\",\"\",IF(D43>0.01,1,IF(D43<-0.01,3,2)))","v":""}]
[]
[null,"Median Household Income"]
[null,"Description\nMedian household income (MHI) is defined as the median amount of total income dollars received per household during a calendar year in a given area. It serves as an overall indicator of community earning capacity.\n\nInstructions\nNo input is required. The tool automatically populates MHI values for the community and nation from the \"2. Demographic Data\" worksheet. \n\nBenchmarks\nCompare the community's MHI to the state MHI:\n• Weak: More than 10% below state MHI\n• Mid-Range: ± 10% of the state MHI\n• Strong: More than 10% above state MHI"]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,7,"Community MHI",{"$f":"'2. Demographic Data'!G19","v":""}]
[null,8,"State MHI",{"$f":"'2. Demographic Data'!H19","v":""}]
[null,null,"Relationship Between Community's MHI and State MHI \n[(Line 7 - Line 8)] / Line 8)",{"$f":"IFERROR((D52-D53)/D53,\"\")","v":""}]
[null,null,"Summary",{"$f":"IF(D56=\"\",\"\",IF(D56=1,\"Weak\",IF(D56=2,\"Mid-Range\",\"Strong\")))","v":""}]
[null,null,"Score",{"$f":"IF(D54=\"\",\"\",IF(D54>0.1,3,IF(D54<-0.1,1,2)))","v":""}]
[]
[null,"Property Tax Revenues as a Percent of Full Market Value of Taxable Property"]
[null,"This indicator may not be appropriate in states with statutory limits on property tax collections and/or rates, or where data on full-market value of taxable property are not available. However, this indicator has no appropriate substitute. In such cases where the property taxes are at their limit or where full-market value of taxable property cannot be estimated, this indicator should be dropped and the other five factors are assigned equal weights, as discussed in a separate section below.\n\nDescription \nThis indicator can be considered the “property tax burden” because it indicates the funding capacity to support new expenditures based on the wealth of the community.\n\nInstructions\nThe value for full market value of real property is transferred from Line 3 when calculating Overall Net Debt as a Percent of Full Market Value of Taxable Property above. Enter the most recent year's property tax revenues on Line 10. General fund revenues are primarily property tax receipts. The tool will divide the property tax revenue collected by the full market value of taxable property and multiply by 100 to provide the result as a percentage on Line 13.\n\nBenchmarks\n• Weak: Above 4%\n• Mid-Range: 2-4%\n• Strong: Below 2%"]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,"If property tax limitations apply, select \"Yes\" in row 64 and skip this indicator. Property Tax Revenues as a Percent of Full Market Value of Taxable Property has no appropriate substitute in cases where property taxes are at their limit or where full-market value of taxable property cannot be estimated. In such cases, this indicator should be dropped and the other factors are assigned equal weights. "]
[null,null,"Skip Indicator?","No"]
[null,3,"Market Value of Property",{"$f":"IF(D64=\"Yes\",\"Not applicable\",IF(OR(D31=\"\",D31=\"Not applicable\"),\"\",D31))","v":""}]
[null,10,"Property Tax Revenues"]
[null,13,"Property Tax Revenue as a Percent of Full Market Value of Taxable Property  (Line 10 / Line 3 * 100)",{"$f":"IF(D64=\"Yes\",\"Not applicable\",IF(OR(D65=\"\",D66=\"\"),\"\",D66/D65))","v":""}]
[null,null,"Summary",{"$f":"IF(D64=\"Yes\",\"Not applicable\",IF(D69=\"\",\"\",IF(D69=1,\"Weak\",IF(D69=2,\"Mid-Range\",\"Strong\"))))","v":""}]
[null,null,"Score",{"$f":"IF(D64=\"Yes\",\"\",IF(D67=\"\",\"\",IF(D67>0.04,1,IF(D67<0.02,3,2))))","v":""}]
[]
[null,"Property Tax Revenue Collection Rate"]
[null,"Description\nThe property tax revenue collection rate is an indicator of the efficiency of the tax collection system and a measure of how well the local government is administered. It compares the actual amount collected from property taxes to the amount levied. Property taxes levied can be computed by multiplying the assessed value of real property by the property tax rate.\n\nInstructions\nProperty tax revenues is transferred from Line 10 when calculating Property Tax Revenues as a Percent of Full Market Value of Taxable Property above. Enter the property taxes levied below Line 10. The tool will divide the property tax revenues by the property taxes levied and multiply by 100 to provide the collection rate as a percentage.\n\nBenchmarks:\n• Weak: Below 94%\n• Mid-Range: 94-98%\n• Strong: Above 98%"]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,10,"Property Tax Revenues",{"$f":"IF(OR(D66=\"\",D66=\"Not applicable\"),\"\",D66)","v":""}]
[null,null,"Property Taxes Levied"]
[null,9,"Property Tax Revenue Collection Rate \n(Line 10 / Property Taxes Levied * 100)",{"$f":"IFERROR(D76/D77,\"\")","v":""}]
[null,null,"Summary",{"$f":"IF(D80=\"\",\"\",IF(D80=1,\"Weak\",IF(D80=2,\"Mid-Range\",\"Strong\")))","v":""}]
[null,null,"Score",{"$f":"IF(D78=\"\",\"\",IF(D78>0.98,3,IF(D78<0.94,1,2)))","v":""}]
[]
[null,"Alternative Indicator: Overall Net Debt per Capita"]
[null,"Description\nCalculate Overall Net Debt per Capital rather than Overall Net Debt as a Percent of Full Market Value of Taxable Property in cases where states have statutory limits on property tax collections and/or rates, or where data on full-market value of taxable property are not available. This alternative indicator assesses the financial condition of the community, which may impact the ability of the community to finance project expenditures. This section will be disabled when \"Skip indicator?\" is set to \"No\" in the section: \"Overall Net Debt as a Percent of Full Market Value of Taxable Property\" above and will be enabled when set to \"Yes\".\n\nInstructions\nEnter requested data as described below.\n\n• Line 1: Enter the community's direct net debt.\n• Line 2: Enter the community's overlapping debt.\n• Line 11: The tool automatically calculates overall net debt adding Lines 1 and 2. Then, the tool automatically enters the community's population from the \"2. Demographic Data\" tab.\n• Line 12 (Alt.): The tool automatically calculates this by dividing overall net debt by population and multiplying by 100.\n\nBenchmarks\n• Weak: Greater than $3,000\n• Mid-Range: $1,000 to $3,000\n• Strong: Less than $1,000"]
[]
[null,"Calculation"]
[null,"Line","Description","Data","Comments and Sources"]
[null,1,"Direct Net Debt",{"$f":"IF(D27=\"No\",\"Not applicable\",\"\")","v":"Not applicable"}]
[null,2,"Overlapping Debt",{"$f":"IF(D27=\"No\",\"Not applicable\",\"\")","v":"Not applicable"}]
[null,11,"Overall Net Debt (Line 1 + Line 2)",{"$f":"IF(D27=\"No\",\"Not applicable\",IF(AND(D87=\"\",D88=\"\"),\"\",SUM(D87:D88)))","v":"Not applicable"}]
[null,null,"Population",{"$f":"IF(D27=\"No\",\"Not applicable\",'2. Demographic Data'!F19)","v":"Not applicable"}]
[null,12,"Overall Net Debt per Capita (Line 11 / Population) ",{"$f":"IF(D27=\"No\",\"Not applicable\",IFERROR(D89/D90,\"\"))","v":"Not applicable"}]
[null,null,"Summary",{"$f":"IF(D27=\"No\",\"Not applicable\",IF(D93=\"\",\"\",IF(D93=1,\"Weak\",IF(D93=2,\"Mid-Range\",\"Strong\"))))","v":"Not applicable"}]
[null,null,"Score",{"$f":"IF(D27=\"No\",\"\",IF(D91=\"\",\"\",IF(D91>3000,1,IF(D91<1000,3,2))))","v":""}]
[]
[null,"Calculation of Secondary Score"]
[null,"Description\nThe secondary test is used to form a composite assessment of the community's economic health and potential financial impact of the pollutant control project. Each secondary test indicator is assigned a score of 1 (weak), 2 (mid-range), or 3 (strong) based on thresholds specified in Table 2-1 of the 1995 WQS Guidance, and an overall secondary test score is calculated as the average of the separate indicators. The overall secondary test score is evaluated as follows:\n\n• Weak: Less than 1.5\n• Mid-range: 1.5 to 2.5\n• Strong: Greater than 2.5\n\nBecause the goal of the analysis is to measure the overall burden to the community, the debt and socioeconomic indicators are assumed to be better measures of burden than the financial management indicators. Consequently, if one of the debt or socioeconomic indicators is not available, the tool will average the two financial management indicators and use this averaged value as a single indicator with the remaining indicators. This averaging is necessary so that undue weight is not given to the financial management indicators. If this is the case, the EPA recommends providing an explanation of why the indicator is not appropriate or not available.\n\nAfter calcuating the secondary test score, move to the next worksheet to evaluate the Lowest Quintile Poverty Indicator (LQPI)."]
[]
[null,"Calculation"]
[null,"Line(s)","Indicator","Column A: Actual Value","Column B: Score"]
[null,4,"Bond Rating",{"$f":"IF(D16=\"\",\"\",D16)","v":""},{"$f":"D18","v":""}]
[null,12,"Overall Net Debt as a Percent of Full Market Value of Taxable Property",{"$f":"IF(D27=\"Yes\",\"N/A\",IF(D32=\"\",\"\",D32))","v":""},{"$f":"IF(D27=\"Yes\",\"N/A\",IF(D34=\"\",\"\",D34))","v":""}]
[null,"5; 6","Unemployment Rate",{"$f":"IF(D41=\"\",\"\",D41)","v":""},{"$f":"D45","v":""}]
[null,"7; 8","Median Household Income",{"$f":"IF(D52=\"\",\"\",D52)","v":""},{"$f":"D56","v":""}]
[null,13,"Property Tax Revenues as a Percent of Full Market Value of Taxable Property",{"$f":"IF(D67=\"Not applicable\",\"N/A\",D67)","v":""},{"$f":"IF(D68=\"Not applicable\",\"N/A\",D69)","v":""}]
[null,9,"Property Tax Revenue Collection Rate",{"$f":"D78","v":""},{"$f":"D80","v":""}]
[null,"12 (Alt.)","Overall Net Debt per Capita",{"$f":"IF(D27=\"No\",\"N/A\",D91)","v":"N/A"},{"$f":"IF(D27=\"No\",\"N/A\",D93)","v":"N/A"}]
[null,null,"Community Indicators Score (Sum of Column B / Number of Entries)",null,{"$f":"IF(OR(_xlfn.CONCAT(E100:E106)=\"N/AN/A\",_xlfn.CONCAT(E100:E106)=\"N/A\",,_xlfn.CONCAT(E100:E106)=\"\"),\"\",IF(OR(E100=\"\",E101=\"\",E101=\"N/A\",E102=\"\",E103=\"\"),AVERAGE(E100,E101,E102,E103,AVERAGE(E104:E106)),AVERAGE(E100:E106)))","v":""},{"$f":"IF(OR(E100=\"\",E101=\"\",E101=\"N/A\",E102=\"\",E103=\"\"),\"Note: The financial management indicators are being averaged together because one or more of the debt and/or socioeconomic indicators is missing.\",\"\")","v":"Note: The financial management indicators are being averaged together because one or more of the debt and/or socioeconomic indicators is missing."}]
[null,"Secondary Score Benchmarks",null,null,{"$f":"IF(E107<1.5,\"Weak\",IF(E107=\"\",\"\",IF(E107>2.5,\"Strong\",\"Mid-Range\")))","v":""}]
[null,"Weak: Less than 1.5\nMid-Range: 1.5 to 2.5\nStrong: Greater than 2.5"]
[]
[null,"Guidance Documentation"]
[null,"Component",null,"1995 WQS Guidance"]
[null,null,null,"Section","Page"]
[null,"Secondary Test (overview)",null,2.4,"2-7"]
[null,"Bond Rating",2.4,2.4,"2-8"]
[null,"Net and Overlapping Debt",2.4,2.4,"2-9"]
[null,"Unemployment Rate",2.4,2.4,"2-9"]
[null,"Median Household Income",2.4,2.4,"2-10"]
[null,"Property Tax",2.4,2.4,"2-10"]
[null,"Alternative Indicators",2.4,2.4,"2-11"]
[null,"Use of Secondary Test",2.4,2.4,"2-11"]

{"sheet":"5. LQPI","index":6,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,1,16,9],[18,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[17,1,17,9],[18,6,18,9],[19,6,19,7],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[20,6,20,7],[21,6,21,7],[22,6,22,7],[1,1,1,9],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[4,1,4,9],[2,1,2,9],[3,1,3,9]]}
[]
[null,"Lowest Quintile Poverty Indicator Analysis (Section II.a.3 in the FCA Guidance)"]
[null,"Description\nThe next step in the analysis is to calculate the Lowest Quintile Poverty Indicator (LQPI) score. Calculation of the LQPI score aids in assessing the severity and prevalence of poverty in the community.\n\nInstructions\nNo input is needed. Data needed to calculate the LQPI are automatically transferred to this worsheet from appropriate cells in the \"2. Demographic Data\" worksheet. These data correspond to the six indicators in Exhibit 3 of the EPA's FCA Guidance:\n\n • LQPI #1: Upper Limit of Lowest Quintile Income\n • LQPI #2: Percentage of Population with Income Below 200% of Federal Poverty Level\n • LQPI #3: Percentage of Households Receiving Food Stamps/SNAP Benefits \n • LQPI #4: Percentage of Vacant Housing Units\n • LQPI #5: Trend in Household Growth  \n • LQPI #6: Percentage of Unemployed Population 16 and Over in Civilian Labor Force\n\n\n\n"]
[null,"Benchmarks\nThe tool compares the community's indicators with the national average. These indicators (other than “Trend in Household Growth”) are evaluated using a ±25% benchmark to national values. \n\n• Weak: More than 25% above National value (LQPI #2, #3, #4, and #6) or more than 25% below National value (LQPI #1)\n• Mid-Range: ± 25% of the National value\n• Strong: More than 25% below National value (LQPI #2, #3, #4, and #6) or more than 25% above National value (LQPI #1)\n\nThe five-year “Trend in Household Growth,” the fifth indicator, is evaluated using >1%, 0-1%, and <0% benchmarks, as indicated below.\n\n• Weak: Five-year average household growth is negative (less than 0 percent)\n• Mid-Range: Five-year average household growth is 0 percent to 1 percent\n• Strong: Five-year average household growth is greater than 1 percent\n \nReview the data below for accuracy and then move on to the Financial Alternatives Analysis checklist in the next worksheet."]
[]
[null,"Indicator (Census Data Code)","Strong\n(Score = 3)","Mid-Range \n(Score = 2)","Weak\n(Score = 1)","Weight","National\nValue","Community\nValue","Community Compared to National","Score"]
[null,"LQPI #1: Upper Limit of Lowest Quintile Income","More than 25% above national LQI"," ± 25% of national LQI","More than 25% below national LQI",0.5,{"$f":"'2. Demographic Data'!I17","v":0},{"$f":"'2. Demographic Data'!I19","v":""},{"$f":"IFERROR((H7-G7)/G7,\"\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(I7>0.25,3,IF(I7<-0.25,1,2)))","v":""}]
[null,"LQPI #2: Percentage of Population with Income Below 200% of Federal Poverty Level","More than 25% below national value"," ± 25% of national Value","More than 25% above national value",0.1,{"$f":"'2. Demographic Data'!J17","v":""},{"$f":"'2. Demographic Data'!J19","v":""},{"$f":"IFERROR((H8-G8)/G8,\"\")","v":""},{"$f":"IF(I8=\"\",\"\",IF(I8<-0.25,3,IF(I8>0.25,1,2)))","v":""}]
[null,"LQPI #3; Percentage of Households Receiving Food Stamps/SNAP Benefits","More than 25% below national value"," ± 25% of national Value","More than 25% above national value",0.1,{"$f":"'2. Demographic Data'!K17","v":""},{"$f":"'2. Demographic Data'!K19","v":""},{"$f":"IFERROR((H9-G9)/G9,\"\")","v":""},{"$f":"IF(I9=\"\",\"\",IF(I9<-0.25,3,IF(I9>0.25,1,2)))","v":""}]
[null,"LQPI #4: Percentage of Vacant Housing Units","More than 25% below national value"," ± 25% of national Value","More than 25% above national value",0.1,{"$f":"'2. Demographic Data'!L17","v":""},{"$f":"'2. Demographic Data'!L19","v":""},{"$f":"IFERROR((H10-G10)/G10,\"\")","v":""},{"$f":"IF(I10=\"\",\"\",IF(I10<-0.25,3,IF(I10>0.25,1,2)))","v":""}]
[null,"LQPI #5: Trend in Household Growth",">1%","0% - 1%","<0%",0.1,"N/A",{"$f":"'2. Demographic Data'!M19","v":""},"N/A",{"$f":"IF(H11=\"\",\"\",IF(H11>0.01,3,IF(H11<0,1,2)))","v":""}]
[null,"LQPI #6: Percentage of Unemployed Population 16 and Over in Civilian Labor Force","More than 25% below national value"," ± 25% of national Value","More than 25% above national value",0.1,{"$f":"'2. Demographic Data'!N17","v":0},{"$f":"'2. Demographic Data'!N19","v":""},{"$f":"IFERROR((H12-G12)/G12,\"\")","v":""},{"$f":"IF(I12=\"\",\"\",IF(I12<-0.25,3,IF(I12>0.25,1,2)))","v":""}]
[null,"Score for LQPI #1",null,null,null,null,null,null,null,{"$f":"J7","v":""}]
[null,"Average Score for LQPI #2-6 (Sum of LQPI #2 through LQPI #6 divided by 5)",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(J8:J12),\"\")","v":""}]
[null,"Lowest Quintile Poverty Score (sum of two lines above divided by 2)",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(J13:J14),\"\")","v":""}]
[null,"Lowest Quintile Poverty Indicator Benchmarks\nLow Impact (Above 2.5)\nMedium Impact (1.5 to 2.5)\nHigh Impact (Below 1.5)",null,null,null,null,null,null,null,{"$f":"IF(J15=\"\",\"\",IF(J15<1.5,\"High Impact\",IF(J15>2.5,\"Low Impact\",\"Medium Impact\")))","v":""}]
[]
[null,"Guidance Documentation"]
[null,"Component",null,null,null,null,"FCA Guidance"]
[null,null,null,null,null,null,"Section(s)",null,"Page(s)"]
[null,"Lowest Quintile Poverty Indicator Score",null,null,null,null,"II.a.3",null,"9 to 11"]
[null,"Instructions for Calculation of the Lowest Quintile Poverty Indicator Score","II.a.3; Exhibit 3",11,null,null,"II.a.3; Exhibit 3",null,11]
[null,"Weighted Average Calculation Example for Multiple Jurisdictions","Appendix A","A-7 to A-8",null,null,"Appendix A",null,"A-7 to A-8"]

{"sheet":"6. FAA Checklist ","index":7,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,1,35,4],[39,1,39,2],[40,1,40,2],[41,1,41,2],[37,1,38,2],[36,1,36,4],[37,3,37,4],[13,1,13,4],[20,1,20,4],[27,1,27,4],[2,1,2,4],[6,1,6,4],[3,1,3,4],[4,1,4,4]]}
[null,null,"Green shaded cells are for data entry"]
[]
[null,"Example Financial Alternatives Analysis Worksheet"]
[null,"Description\nThe next step EPA recommends for evaluating economic impacts is to perform a Financial Alternatives Analysis (FAA). The goal of the FAA is to seek ways to minimize financial impacts while ensuring residents also enjoy the benefits of improved water quality.   \n\nAn FAA should document whether the community has considered feasible steps to reduce costs and address impacts to low-income households, including use of variable rate structures, customer assistance programs (CAPs), and applications for grants or subsidies from the Clean Water State Revolving Fund (CWSRF)..  \n\nInstructions\nBelow is a “checklist” of financing and funding considerations from Appendix C of EPA's FCA Guidance you may use to help you document consideration of steps that may reduce costs and address impacts to low-income households. You may enter a description of these considerations in the green shaded cells below. Such documentation should describe the programs or steps considered, the actions that would be necessary to put those measures into place, and either the plan for taking those actions or an explanation of why the approach is not being pursued. The analytical outcome recommended in the EPA's FCA Guidance is affected by whether or not a good faith effort was made to perform a comprehensive FAA."]
[]
[null,"Financial Alternatives Analysis","Describe how Financial Alternative has been implemented or considered. Where considered, include any plans from community to pursue Alternative","Where tools not pursued, describe any associated challenges with the Alternative (e.g., impact to bond rating, interest rate not favorable)","Describe outcomes of Alternative (e.g., grant applied for, loan not pursued)"]
[null,"1. Financing Options for Capital Costs:"]
[null,"a) Has the community discussed financing options, including timing, terms, and potential grants or forgiveness, with the responsible State Revolving Fund?"]
[null,"b) What additional funding sources beyond the SRF such as grants, low-cost loans, or extended term loans has the community considered?"]
[null,"c) Has the community considered special assessment districts to finance geographically defined project work?"]
[null,"d) Has the community considered other revenue sources such as sales or property taxes, rental income from water tower leases, or other potential sources of support?"]
[null,"e) Has the community evaluated how it can reduce overall operating and program costs?"]
[null,"> Other Considerations:"]
[null,"2. Rate Design:",null,"Data sources for Residential Indicator, Financial Capability Indicators, and Lowest Quintile Poverty Indicator analyses (see Section II.a.3, Appendix A and Appendix B in the FCA Guidance for further information).","No"]
[null,"a) In what ways has the community evaluated modifications to its rate structure that could increase revenue and/or reduce burden on the lowest income residents?"]
[null,"b) Has the community prepared a forward-looking financial plan and rate analysis within the last five years? If so, was the plan implemented?"]
[null,"c) Does the community have identified separate rate structures for commercial, industrial, and wholesale customers reflecting their particular demands on the collection and treatment system? Has the utility considered tier-based rates?"]
[null,"d) Does the community use inclining block rates that charger higher per gallon rates for higher increments of use?"]
[null,"e) If charging a flat fee, has the community considered switching to a volumetric fee so that high-output customers pay for the wastewater they generate?"]
[null,"> Other Considerations:"]
[null,"3. Ratepayer Support Options for Lower Income Residential Customers:"]
[null,"a) Does the community currently have, or looked into, setting up a CAP?"]
[null,"b) If you have a CAP, what is the enrollment rate? What efforts have been made to ensure low-income households are informed about the program and enroll? Are there ways to make the application process easier for customers to enroll, e.g., by providing for enrollment in-person, online, and mail, in multiple languages, if appropriate; partnering with local organizations to help with outreach and enrollment; allowing for automatic enrollment or using proof of eligibility for other income-qualified benefits?"]
[null,"c) Has the community considered other types of customer support beyond a CAP for lower income residential customers?"]
[null,"d) Are there policies in place to protect customers, including vulnerable populations, from shutoffs?"]
[null,"e) Does the community have reduced rates for vulnerable populations, such as seniors on fixed incomes?"]
[null,"> Other Considerations:"]
[null,"4. Financial and Utility Management:"]
[null,"a) Is the utility accounted for as a proprietary/enterprise fund or a separate independent utility?"]
[null,"b) Are all rate revenues or other user charges used to fund the utility's operations? Do the rates charged recover the full cost of providing wastewater services (taking into consideration capital costs, operation and maintenance expenses, and environmental costs)?"]
[null,"c) Does the utility have programs to optimize maintenance and asset management to reduce life cycle costs?"]
[null,"d) Are partnerships with other utilities, including joint procurement, or shared management and staffing arrangements, regionalization or consolidation options to proved economies of scale and reduce per customer costs feasible in this community?"]
[null,"e) Has the utility or related municipality instituted a stormwater management program when evaluating long-term control plan schedules? If so, are impervious area-based stormwater fees used to fund the stormwater compliance costs?"]
[null,"f) Does the utility provide direct financial assistance (through rebates, upfront subsidies, or direct replacement of fixtures) for efficiency improvements including leak repairs or replacement of inefficient fixtures or appliances?"]
[null,"> Other Considerations:"]
[]
[null,"Guidance Documentation"]
[null,"Component",null,"FCA Guidance"]
[null,null,null,"Section","Page(s)"]
[null,"Financial Alternatives Analysis",null,"II.a.4","12 to 14"]
[null,"Financial Alternatives Analysis Checklist","Appendix C","Appendix C","C-1 to C-14"]
[null,"Financial Alternatives Analysis Example Worksheet","Appendix C","Appendix C","C-15 to C-18"]

{"sheet":"7. Results of Impacts Analysis","index":8,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,1,23,4],[4,1,4,4],[29,2,29,3],[30,2,30,3],[24,1,24,4],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[10,1,10,4],[17,1,17,4],[18,1,19,1],[18,2,18,4],[16,1,16,4],[1,1,1,4],[3,1,3,4],[9,1,9,4],[2,1,2,4],[13,5,15,5],[11,1,12,1],[11,2,11,4]]}
[]
[null,"Results of Expanded Economic Impact Analysis (Section III.d in the FCA Guidance)"]
[null,"Description\nThe next step in the analysis is to combine the Municipal Preliminary Screener, Secondary Test, and Lowest Quintile Poverty Indicator results to assess the overall financial impact to the community. First, the Municipal Preliminary Screener and Secondary Test results are combined using the Initial Economic Impact Matrix (Table 2-2 in the 1995 WQS Guidance; Exhibit 11 in FCA Guidance) to determine the initial economic impact on the community. The results of the Initial Economic Impact Matrix is then combined with the LQPI score using the Expanded Economic Impact Matrix (Exhibit 12 in the FCA Guidance) to determine if the financial impact of the proposed pollutant control project is likely be substantial, not likely to be substantial, or unclear.\n\nInstructions\nThe analytical results from the previous worksheets are evaluated automatically. No input is necessary. Review the analytical results below."]
[]
[null,"Economic Impact Results"]
[null,"Category","Score","Impact","Line in 1995 WQS Guidance"]
[null,"Municipal Preliminary Screener",{"$f":"'3. MPS'!D88","v":""},{"$f":"'3. MPS'!D89","v":""},"Worksheet D, Line 1 / Line 2 * 100"]
[null,"Secondary Score",{"$f":"'4. Secondary Test'!E107","v":""},{"$f":"'4. Secondary Test'!E108","v":""},"Worksheet E, Sum of Column B / Number of Entries"]
[null,"Lowest Quintile Poverty Indicator",{"$f":"'5. LQPI'!J15","v":""},{"$f":"'5. LQPI'!J16","v":""},"N/A"]
[]
[null,"Initial Economic Impact Matrix"]
[null,"Secondary Score (SS)","Municipal Preliminary Screener (MPS)\n(Cost as a Percent of Median Household Income)"]
[null,null,"Below 1.0%","1.0% to 2.0%","Above 2.0%"]
[null,"Above 2.5 (Strong Economy)","Impact Not Likely to be Substantial","Impact Not Likely to be Substantial","Impact Unclear"]
[null,"1.5 to 2.5 (Mid-Range Economy)","Impact Not Likely to be Substantial","Impact Unclear","Substantial Impact"]
[null,"Below 1.5 (Weak Economy)","Impact Unclear","Substantial Impact","Substantial Impact"]
[]
[null,"Expanded Economic Impact Matrix"]
[null,"Initial Economic Impact\n(MPS and SS)","Lowest Quintile Poverty Indicator Score"]
[null,null,"Low Impact","Medium Impact","High Impact"]
[null,"Impact Not Likely to be Substantial","Impact Not Likely to be Substantial","Impact Not Likely to be Substantial","Impact Unclear"]
[null,"Impact Unclear","Impact Not Likely to be Substantial","Impact Unclear","Substantial Impact"]
[null,"Substantial Impact","Impact Unclear","Substantial Impact","Substantial Impact"]
[]
[null,"Guidance Documentation"]
[null,"Component","Section(s)",null,"Page(s)"]
[null,"Initial Economic Impacts Matrix","2.5 (1995 WQS Guidance);\nExhibit 11 (FCA Guidance) ",null,"2-12;\n38"]
[null,"Using Substantial Impacts Matrix","2.5 (1995 WQS Guidance)","2.5 (1995 WQS Guidance)","2-12"]
[null,"Determining Need for Widespread Analysis","2.5, Figure 2-1\n(1995 WQS Guidance)","2.5, Figure 2-1\n(1995 WQS Guidance)","2-12;\n2-14"]
[null,"Expanded Economic Impact Matrix","Exhibit 12 (FCA Guidance)","Exhibit 12 (FCA Guidance)","40"]
[null,"Recommended WQS Decisions","Exhibit 13 (FCA Guidance)","Exhibit 13 (FCA Guidance)",42]

{"sheet":"8. WQS Decision Table","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,1,3,3],[13,1,13,3],[4,1,4,3]]}
[]
[null,null,"Green shaded cells are for data entry"]
[]
[null,"Recommendations for Making WQS Decisions for the Public Sector (Exhibit 13 in the FCA Guidance)"]
[null,"Description\nExhibit 13 in the FCA Guidance shows EPA's recommendations for making WQS decisions after applying the Expanded Economic Impact Matrix, including consideration of financial alternatives where appropriate and additional analyses when evaluating changes to designated uses. EPA notes that Exhibit 13 in the FCA Guidance does not indicate that WQS decisions should be rigidly determined according to the break points between the categories. Information on Other Metrics or analysis of financial and rate models may provide additional information that could influence WQS decisions. Further, EPA recommends that in addition to completing the economic analyses recommended in this section and considering any other financial metrics, states and authorized tribes consider opportunities to mitigate impacts of WQS decisions to areas with potential environmental justice concern (see Section III.b in the FCA Guidance).\n\nThe Financial Alternatives Analysis provides especially critical information to ensure WQS decisions strive to restore and maintain water quality to the greatest extent possible consistent with the objectives of the CWA. Performance of a Financial Alternatives Analysis in accordance with Section III.d.3 and Appendix C in the FCA Guidance including loans, grants, customer assistance programs, and alternative rate structures may reveal the ability to attain the designated use or avoid the need to lower water quality, and the ability to mitigate impacts to low-income communities. An appropriate economic justification for a WQS variance, revision of a designated use, or lowering of water quality associated with an antidegradation review should demonstrate that implementation of feasible financial alternatives under current or reasonably expected future economic conditions (including consideration of future debt capacity) would still result in substantial economic impact that would preclude the designated use from being attained or would justify lowering water quality to accommodate important economic or social development.\n\nPerformance of a Financial Alternatives Analysis provides important information when interpreting the outcome of the Expanded Economic Impact Matrix. As previously noted, without the types of information developed in a Financial Alternatives Analysis, it will likely be more difficult for EPA to assess possible economic impacts and whether those impacts might outweigh the environmental impacts of a WQS variance, the revision of a designated use, or the lowering of water quality through an antidegradation review. Thus, as shown below, recommendations for WQS decisions are more conservative if the state or authorized tribe does not include a Financial Alternatives Analysis in its supporting documentation.\n\nInstructions\nIndicate whether a Financial Alternatives Analysis was completed in the drop-down list. Then, note the recommended WQS decision listed below."]
[]
[null,"Was a Financial Alternatives Analysis completed?"]
[]
[]
[null,"Results of Expanded Economic Impact Matrix","Did Not Perform a Financial Alternatives Analysis","Performed a Comprehensive Financial Alternatives Analysis"]
[null,"Impact Not Likely to be Substantial*","WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6)).","WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6))."]
[null,"Impact Unclear","WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6)).","WQS variances: Substantial impact (40 CFR 131.10(g)(6)) is likely unclear. Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance).\n\nDesignated use revisions: Consider the Expanded Economic Matrix results in concert with the results of the Financial Alternatives Analysis and additional analyses and actions described in Section III.a in the FCA Guidance for use changes. Also, consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance). If substantial impacts remain unclear, consider whether a use change is appropriate at this time."]
[null,"Substantial Impact","WQS variances: Substantial impact is unclear (40 CFR 131.10(g)(6)). Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance).\n\nDesignated use revisions: Substantial impact is unclear (40 CFR 131.10(g)(6)). Consider additional analyses and actions described in Section III.a in the FCA Guidance. Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance). Depending on result of such additional analyses, consider whether a use change is appropriate at this time.","WQS variances: Substantial impacts likely (40 CFR 131.10(g)(6)).\n\nDesignated use revisions: Consider the results of the Expanded Economic Matrix in concert with the results of the Financial Alternatives Analysis and additional analyses and actions described in Section III.a in the FCA Guidance for use changes to determine whether overall results continue to support a demonstration of substantial impact (40 CFR 131.10(g)(6))."]
[null,"* The analysis in this guidance only serves to determine if impacts are \"substantial.\" A state or authorized tribe would still need to conduct an analysis to demonstrate the substantial impacts are \"widespread.\""]

{"sheet":"9. Widespread Impact Analysis","index":10,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,1,5,3],[17,1,18,1],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[14,2,14,3],[17,2,17,3],[7,2,7,3],[16,1,16,3],[6,1,6,3],[15,1,15,3]]}
[]
[null,null,"Green shaded cells are for data entry"]
[]
[]
[null,"Qualitative Description of Estimated Change in Socioeconomic Indicators Due to Pollutant Control Costs (Worksheet M in the 1995 WQS Guidance)"]
[null,"Description\nYou may use this worksheet to help collect and organize information to demonstrate whether substantial economic impacts will also be widespread. The EPA considers substantial economic impacts to be widespread if they will have significant adverse impacts on the local community. See the Guidance documentation referenced below for additional information.\n\nInstructions\nEnter information that could help determine if the substantial economic impacts would result in widespread adverse economic impacts to the local community. Because there are no standard economic tests or benchmarks that evaluate socioeconomic impacts for the widespread demonstration, describe the relative changes in indicators such as unemployment, the local economy, household income, tax revenues, indirect effects on other businesses, and sewer fees. Include any additonal data or information you believe would help demonstrate that the substantial economic impacts would be widespread.\n"]
[]
[null,"Parameter","Description"]
[null,"Estimated Change in Median Household Income (MHI)"]
[null,"Estimated Change in the Unemployment Rate"]
[null,"Estimated Change in Overall Net Debt as a Percent of Full Market Value of Taxable Property"]
[null,"Estimated Change in % of Households Below the Poverty Line"]
[null,"Impact on Commercial Development Potential"]
[null,"Impact on Property Values"]
[null,"Additional Information"]
[]
[null,"Guidance Documentation"]
[null,"Component","1995 WQS Guidance"]
[null,null,"Section(s)","Page(s)"]
[null,"Determination of Widespread Impacts",4,"4-1"]
[null,"Defining Relevant Geographic Area",4.0999999999999996,"4-2"]
[null,"Criteria for Evaluating Widespread Impacts",4.2,"4-2"]
[null,"Secondary Impacts to Community",4.2,"4-3"]
[null,"Multiplier Effect",4.4000000000000004,"4-5"]
[null,"Economic Benefits of Clean Water","4.5; Appendix C","4-6; Appendix C"]

{"sheet":"Potential Data Sources","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
[]
[null,"Data Sources for Secondary Score Analysis"]
[null,"Description\n\nThis worksheet provides potential sources for the financial and socioeconomic data required to perform the calculations in this spreadsheet tool. No input is required."]
[]
[null,"Indicator","Potential Data Source(s)"]
[null,"Most Recent General Obligation Bond Rating","Municipal bond reports from rating agencies (e.g., Moody's Bond Record, Standard & Poor's Corporation) provide recent ratings. Municipal bond prospectuses typically list the bond rating in the upper-right corner of the cover page and within the “Ratings” section of the report. General Obligation Bond prospectuses are available at: https://emma.msrb.org/. Municipalities also may have reports from rating agencies summarizing updates of the rating status."]
[null,"Most Recent Sewer Bond Rating","Municipal bond reports from rating agencies (e.g., Moody's Bond Record, Standard & Poor's Corporation) provide recent ratings. Municipal bond prospectuses typically list the bond rating in the upper-right corner of the cover page and within the “Ratings” section of the report. Revenue Bond prospectuses are available at: https://emma.msrb.org/. Municipalities also may have reports from rating agencies summarizing updates of the rating status."]
[null,"Overall Net Debt (Direct Debt and Overlapping Debt)","Debt information is generally available in the Statistical Section of the community’s Annual Comprehensive Financial Report. In most cases the most recent Annual Comprehensive Financial Report is on file in the finance department of the community’s website. Overlapping debt is also generally provided in a community's Annual Comprehensive Financial Report. See the \"4. Secondary Test\" worksheet for further information."]
[null,"Market Value of Property","Market value of real property is available in the Statistical Section of the community’s Annual Comprehensive Financial Report. If not, the property assessment data should be readily available through the community, county, or State's assessor office. The boundary of most service areas generally conforms to one or more community boundaries. Therefore, prorating community data to reflect specific service area boundaries is not normally necessary for evaluating the general financial capability of the community. "]
[null,"Unemployment Rate","The Secondary Score automatically populates Census Bureau American Community Survey (ACS) 5-year estimates on the civilian unemployment rate (Table DP03) from the \"2. Demographic Data\" tab."]
[null,"Median Household Income","The Secondary Score automatically populates Census Bureau American Community Survey (ACS) 5-year estimates on the number of households (Table B19013) from the \"2. Demographic Data\" tab."]
[null,"Population","The Secondary Score automatically populates Census Bureau American Community Survey (ACS) 5-year estimates for population (Table B01003) from the \"2. Demographic Data\" tab."]
[null,"Property Tax Revenues","Property tax revenue collection data and market value of real property are generally available in the Statistical Section of the community’s Annual Comprehensive Financial Report. If not, property assessment and tax revenue collection data should be readily available through the community, county, or state assessor’s office. Occasionally, the assessment and tax revenue data of communities partially serviced by a wastewater treatment facility may have to be prorated to provide a clearer picture of the community's property tax burden."]
[null,"Property Taxes Levied","Property taxes levied are available in a community’s Annual Comprehensive Financial Report. Property taxes levied can also be computed by multiplying the assessed value of real property by the property tax rate, both of which are available from a community's financial statements or the state assessor's office. Occasionally, the assessment and tax revenue data of a community partially serviced by the wastewater treatment facility may have to be prorated to provide a clearer picture of the community's property tax revenue collection rate."]

{"sheet":"Change Log","index":12,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,4,2]]}
[]
[null,"Change Log"]
[null,"Description\n\nThis worksheet describes bug fixes and other modifications that have been made since the Economic Guidance for Water Quality Standards spreadsheet tool was posted to the EPA website."]
[]
[null,"Documentation of Changes"]
[null,"Date","Notes"]
[null,"2012-10-01","First release."]
[null,"2013-06-01","On “2. MPS Inputs” and “4. Secondary Test Input” worksheets, made minor formatting changes for consistency (bold outline for instruction boxes, and number format in cells F32 and F33).\nOn “5. Secondary Test Score” and “7. Widespread Impact Analysis” worksheets, corrected minor formatting issues (cell borders).\nUnlocked cell B17 (description of missing data) in “4. Secondary Test Inputs” worksheet.\nFixed minor formatting issues for printer compatibility on several worksheets.\nFixed two typos in cells B20 and B21 in “Purpose and Instructions” worksheets.\n\n"]
[null,"2015-07-01","Changed calculation of average in \"5. Secondary Test Score\" to reflect replacement of two financial management indicators with a single average financial management indicator when one debt or socioeconomic indicator is unavailable.\n\n\n"]
[null,"2024-07-01","Major revision to accommodate 2024 FCA update."]

{"sheet":"BondRating_vlookup","index":13,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Rating","Source","Desc","Score",null,null,null,null,"Selected",null,"Rating","Moody's","S&P","source","https://www.contextures.com/xldataval02.html"]
["A","Fitch","STRONG",3,null,null,null,null,{"$f":"IF(SelectedAgency=\"Moody's\",Moodys,IF(SelectedAgency=\"Fitch\",#REF!,IF(SelectedAgency=\"S&P\",SandP,\"\")))","v":""},null,"Moody's","A1","A"]
["AA","Fitch","STRONG",3,null,null,null,null,null,null,"S&P","A2","A-"]
["AAA","Fitch","STRONG",3,null,null,null,null,null,null,null,"A3","A+"]
["BBB","Fitch","MID",2,null,null,null,null,null,null,null,"Aa1","AA"]
["B","Fitch","WEAK",1,null,null,null,null,null,null,null,"Aa2","AA-"]
["BB","Fitch","WEAK",1,null,null,null,null,null,null,null,"Aa3","AA+"]
["C","Fitch","WEAK",1,null,null,null,null,null,null,null,"Aaa","AAA"]
["CC","Fitch","WEAK",1,null,null,null,null,null,null,null,"Baa1","BBB"]
["CCC","Fitch","WEAK",1,null,null,null,null,null,null,null,"Baa2","BBB-"]
["D","Fitch","WEAK",1,null,null,null,null,null,null,null,"Baa3","BBB+"]
["A1","Moody's","STRONG",3,null,null,null,null,null,null,null,"B1","B"]
["A2","Moody's","STRONG",3,null,null,null,null,null,null,null,"B2","BB"]
["A3","Moody's","STRONG",3,null,null,null,null,null,null,null,"B3","BB+"]
["Aa1","Moody's","STRONG",3,null,null,null,null,null,null,null,"Ba1","C"]
["Aa2","Moody's","STRONG",3,null,null,null,null,null,null,null,"Ba2","CC"]
["Aa3","Moody's","STRONG",3,null,null,null,null,null,null,null,"Ba3","CCC"]
["Aaa","Moody's","STRONG",3,null,null,null,null,null,null,null,"C","D"]
["Baa1","Moody's","MID",2,null,null,null,null,null,null,null,"Ca"]
["Baa2","Moody's","MID",2,null,null,null,null,null,null,null,"Caa1"]
["Baa3","Moody's","MID",2,null,null,null,null,null,null,null,"Caa2"]
["B1","Moody's","WEAK",1,null,null,null,null,null,null,null,"Caa3"]
["B2","Moody's","WEAK",1]
["B3","Moody's","WEAK",1]
["Ba1","Moody's","WEAK",1]
["Ba2","Moody's","WEAK",1]
["Ba3","Moody's","WEAK",1]
["C","Moody's","WEAK",1]
["Ca","Moody's","WEAK",1]
["Caa1","Moody's","WEAK",1]
["Caa2","Moody's","WEAK",1]
["Caa3","Moody's","WEAK",1]
["A","S&P","STRONG",3]
["A-","S&P","STRONG",3]
["A+","S&P","STRONG",3]
["AA","S&P","STRONG",3]
["AA-","S&P","STRONG",3]
["AA+","S&P","STRONG",3]
["AAA","S&P","STRONG",3]
["BBB","S&P","MID",2]
["BBB-","S&P","MID",2]
["BBB+","S&P","MID",2]
["B","S&P","WEAK",1]
["BB","S&P","WEAK",1]
["BB+","S&P","WEAK",1]
["C","S&P","WEAK",1]
["CC","S&P","WEAK",1]
["CCC","S&P","WEAK",1]
["D","S&P","WEAK",1]

{"sheet":"Impacts","index":14,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,0,0,4],[5,3,5,4]]}
["DO NOT DELETE THIS TAB - NECESSARY FOR TOOL FUNCTIONALITY"]
[]
["Initial Impact:",{"$f":"IFERROR(IF(OR('7. Results of Impacts Analysis'!C7=\"\",'7. Results of Impacts Analysis'!C8=\"\"),\"\",_xlfn.IFS(AND('7. Results of Impacts Analysis'!C7<=0.02,'7. Results of Impacts Analysis'!C8>2.5), \"Impact Not Likely to be Substantial\", AND('7. Results of Impacts Analysis'!C7<0.01, '7. Results of Impacts Analysis'!C8>=1.5),\"Impact Not Likely to be Substantial\", AND('7. Results of Impacts Analysis'!C7<0.01,'7. Results of Impacts Analysis'!C8<1.5), \"Impact Unclear\", AND('7. Results of Impacts Analysis'!C7>0.02,'7. Results of Impacts Analysis'!C8>2.5), \"Impact Unclear\",  AND(AND('7. Results of Impacts Analysis'!C7<=0.02, '7. Results of Impacts Analysis'!C7>=0.01), AND('7. Results of Impacts Analysis'!C8<=2.5, '7. Results of Impacts Analysis'!C8>=1.5)), \"Impact Unclear\", AND('7. Results of Impacts Analysis'!C7>0.02, '7. Results of Impacts Analysis'!C8<=2.5), \"Substantial Impact\", AND('7. Results of Impacts Analysis'!C7>0.01, '7. Results of Impacts Analysis'!C8<=1.5),  \"Substantial Impact\", TRUE,\"\")), \"\")","v":""}]
[]
["Expanded Impact:",{"$f":"IFERROR(_xlfn.IFS(AND(B3=\"Impact Not Likely to be Substantial\",'7. Results of Impacts Analysis'!C9>2.5), \"Impact Not Likely to be Substantial\", AND(B3=\"Impact Unclear\",'7. Results of Impacts Analysis'!C9>2.5), \"Impact Not Likely to be Substantial\", AND(B3=\"Impact Not Likely to be Substantial\", AND('7. Results of Impacts Analysis'!C9<=2.5, '7. Results of Impacts Analysis'!C9>=1.5)),\"Impact Not Likely to be Substantial\", AND(B3=\"Impact Not Likely to be Substantial\",'7. Results of Impacts Analysis'!C9<1.5), \"Impact Unclear\", AND(B3=\"Substantial Impact\",'7. Results of Impacts Analysis'!C9>2.5), \"Impact Unclear\",  AND(B3=\"Impact Unclear\", AND('7. Results of Impacts Analysis'!C9<=2.5, '7. Results of Impacts Analysis'!C9>=1.5)), \"Impact Unclear\", AND(B3=\"Impact Unclear\", '7. Results of Impacts Analysis'!C9<1.5), \"Substantial Impact\", AND(B3=\"Substantial Impact\", '7. Results of Impacts Analysis'!C9<2.5),  \"Substantial Impact\", TRUE,\"\"), \"\")","v":""}]
[null,null,null,"Financial Alternatives Analysis?"]
[null,null,"Results of Expanded Economic Impact Matrix","No","Yes"]
[null,null,"Impact Not Likely to be Substantial",{"$f":"'8. WQS Decision Table'!C11","v":"WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6))."},{"$f":"'8. WQS Decision Table'!D11","v":"WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6))."}]
[null,null,"Impact Unclear",{"$f":"'8. WQS Decision Table'!C12","v":"WQS variances and designated use revisions: Not likely to demonstrate substantial economic impacts (40 CFR 131.10(g)(6))."},{"$f":"'8. WQS Decision Table'!D12","v":"WQS variances: Substantial impact (40 CFR 131.10(g)(6)) is likely unclear. Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance).\n\nDesignated use revisions: Consider the Expanded Economic Matrix results in concert with the results of the Financial Alternatives Analysis and additional analyses and actions described in Section III.a in the FCA Guidance for use changes. Also, consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance). If substantial impacts remain unclear, consider whether a use change is appropriate at this time."}]
[null,null,"Substantial Impact",{"$f":"'8. WQS Decision Table'!C13","v":"WQS variances: Substantial impact is unclear (40 CFR 131.10(g)(6)). Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance).\n\nDesignated use revisions: Substantial impact is unclear (40 CFR 131.10(g)(6)). Consider additional analyses and actions described in Section III.a in the FCA Guidance. Consider evaluation of other metrics (described in Sections II.c and II.d in the FCA Guidance) or financial and rate models (Alternative 2 in Section II.b.1 in the FCA Guidance). Depending on result of such additional analyses, consider whether a use change is appropriate at this time."},{"$f":"'8. WQS Decision Table'!D13","v":"WQS variances: Substantial impacts likely (40 CFR 131.10(g)(6)).\n\nDesignated use revisions: Consider the results of the Expanded Economic Matrix in concert with the results of the Financial Alternatives Analysis and additional analyses and actions described in Section III.a in the FCA Guidance for use changes to determine whether overall results continue to support a demonstration of substantial impact (40 CFR 131.10(g)(6))."}]

{"sheet":"Dropdown Menus","index":15,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["Jurisdictions (RI inputs)",null,null,"Bond Insurance","States",null,"Inputs MPS (D41)"]
["(a) 1 Jurisdiction",null,null,"Yes","AK",null,"Yes"]
["(b) Multiple (2+) Jurisdictions",null,null,"No","AL",null,"No, they are expected to pay a different proportion"]
[null,null,null,null,"AR",null,"No, they are expected to pay based on flow"]
[null,null,null,null,"AZ"]
[null,null,null,null,"CA"]
[null,null,null,null,"CO"]
[null,null,null,null,"CT"]
[null,null,null,null,"DC"]
[null,null,null,null,"DE"]
[null,null,null,null,"FL"]
[null,null,null,null,"GA"]
[null,null,null,null,"HI"]
[null,null,null,null,"IA"]
[null,null,null,null,"ID"]
[null,null,null,null,"IL"]
[null,null,null,null,"IN"]
[null,null,null,null,"KS"]
[null,null,null,null,"KY"]
[null,null,null,null,"LA"]
[null,null,null,null,"MA"]
[null,null,null,null,"MD"]
[null,null,null,null,"ME"]
[null,null,null,null,"MI"]
[null,null,null,null,"MN"]
[null,null,null,null,"MO"]
[null,null,null,null,"MS"]
[null,null,null,null,"MT"]
[null,null,null,null,"NC"]
[null,null,null,null,"ND"]
[null,null,null,null,"NE"]
[null,null,null,null,"NH"]
[null,null,null,null,"NJ"]
[null,null,null,null,"NM"]
[null,null,null,null,"NV"]
[null,null,null,null,"NY"]
[null,null,null,null,"OH"]
[null,null,null,null,"OK"]
[null,null,null,null,"OR"]
[null,null,null,null,"PA"]
[null,null,null,null,"RI"]
[null,null,null,null,"SC"]
[null,null,null,null,"SD"]
[null,null,null,null,"TN"]
[null,null,null,null,"TX"]
[null,null,null,null,"UT"]
[null,null,null,null,"VA"]
[null,null,null,null,"VT"]
[null,null,null,null,"WA"]
[null,null,null,null,"WI"]
[null,null,null,null,"WV"]
[null,null,null,null,"WY"]

{"sheet":"Place B tables","index":16,"n_rows":594,"n_cols":9,"rows_kept":594,"cut":false,"hidden":true,"merged":[]}
["NAME","B01003_001E","B19080_001E","B25002_001E","B25002_002E","B25002_003E","B19013_001E","state","place"]
["Abanda CDP, Alabama","231","23840","67","67","0","25787","01","00100"]
["Abbeville city, Alabama","2231","15427","1301","922","379","36944","01","00124"]
["Adamsville city, Alabama","4381","17454","1826","1490","336","46150","01","00460"]
["Addison town, Alabama","697","20875","397","296","101","44000","01","00484"]
["Akron town, Alabama","385","20500","175","92","83","28438","01","00676"]
["Alabaster city, Alabama","33133","41538","12195","11656","539","83181","01","00820"]
["Albertville city, Alabama","22268","21258","8071","7409","662","51718","01","00988"]
["Alexander City city, Alabama","14765","16840","7007","5795","1212","41778","01","01132"]
["Alexandria CDP, Alabama","4092","39250","1473","1356","117","88090","01","01180"]
["Aliceville city, Alabama","2244","10440","996","888","108","30411","01","01228"]
["Allgood town, Alabama","867","26778","232","207","25","56250","01","01396"]
["Altoona town, Alabama","1444","11552","577","460","117","40000","01","01660"]
["Andalusia city, Alabama","8764","16216","4054","3148","906","40516","01","01708"]
["Anderson town, Alabama","255","31500","128","112","16","76250","01","01756"]
["Anniston city, Alabama","21455","14344","11516","9322","2194","39928","01","01852"]
["Arab city, Alabama","8462","20564","3603","3280","323","50321","01","02116"]
["Ardmore town, Alabama","1276","22450","619","584","35","37448","01","02260"]
["Argo town, Alabama","4411","40050","1750","1604","146","80733","01","02320"]
["Ariton town, Alabama","660","15412","290","229","61","31406","01","02428"]
["Arley town, Alabama","625","20389","201","182","19","44167","01","02500"]
["Ashford town, Alabama","2476","18189","1016","886","130","47167","01","02836"]
["Ashland town, Alabama","1741","11909","872","737","135","25458","01","02860"]
["Ashville city, Alabama","2096","19048","892","727","165","42875","01","02908"]
["Athens city, Alabama","25213","20002","11154","10211","943","52211","01","02956"]
["Atmore city, Alabama","8734","9330","3437","2638","799","29104","01","03004"]
["Attalla city, Alabama","5872","22591","3109","2463","646","46278","01","03028"]
["Auburn city, Alabama","74637","12236","33374","27656","5718","54700","01","03076"]
["Autaugaville town, Alabama","999","12952","543","432","111","34375","01","03220"]
["Avon town, Alabama","490","22750","230","172","58","61250","01","03364"]
["Axis CDP, Alabama","92","2499","63","63","0","2499","01","03508"]
["Babbie town, Alabama","506","18000","228","192","36","47500","01","03556"]
["Baileyton town, Alabama","1114","24021","466","433","33","53135","01","03676"]
["Bakerhill town, Alabama","216","17375","129","94","35","36250","01","03724"]
["Ballplay CDP, Alabama","1391","28280","657","464","193","54803","01","03820"]
["Banks town, Alabama","249","25875","120","87","33","43558","01","03940"]
["Bay Minette city, Alabama","7824","14031","2698","2416","282","35851","01","04660"]
["Bayou La Batre city, Alabama","2520","9032","1249","1055","194","29099","01","04684"]
["Bear Creek town, Alabama","1574","15298","585","512","73","33833","01","04852"]
["Beatrice town, Alabama","179","13750","124","70","54","28750","01","04900"]
["Beaverton town, Alabama","166","9833","110","72","38","50833","01","04948"]
["Belgreen CDP, Alabama","42","26833","50","33","17","34375","01","05140"]
["Belk town, Alabama","384","22306","142","128","14","39167","01","05164"]
["Bellamy CDP, Alabama","126","13750","103","50","53","16500","01","05188"]
["Belle Fontaine CDP, Alabama","739","9473","287","261","26","41953","01","05212"]
["Benton town, Alabama","50","65286","29","29","0","84063","01","05692"]
["Berlin town, Alabama","639","21167","326","239","87","56563","01","05812"]
["Berry town, Alabama","994","14714","412","360","52","43300","01","05932"]
["Bessemer city, Alabama","26171","14752","13052","10521","2531","32416","01","05980"]
["Billingsley town, Alabama","133","22375","54","54","0","31250","01","06460"]
["Birmingham city, Alabama","202234","15535","107454","85521","21933","39403","01","07000"]
["Black town, Alabama","395","33214","140","135","5","51230","01","07120"]
["Blountsville town, Alabama","1887","14972","789","648","141","41335","01","07456"]
["Blue Ridge CDP, Alabama","1442","54368","627","603","24","110250","01","07588"]
["Blue Springs town, Alabama","85","24583","47","35","12","40625","01","07672"]
["Boaz city, Alabama","10091","17354","4406","3820","586","40732","01","07912"]
["Boligee town, Alabama","242","6000","148","81","67","11445","01","08104"]
["Bon Air town, Alabama","81","10667","51","42","9","18000","01","08248"]
["Bon Secour CDP, Alabama","2500","43254","1160","776","384","72330","01","08272"]
["Boykin CDP, Alabama","330","8667","207","104","103","32500","01","08680"]
["Brantley town, Alabama","966","13436","449","336","113","28125","01","09016"]
["Brantleyville CDP, Alabama","871","21375","342","321","21","46544","01","09064"]
["Brent city, Alabama","3214","8179","905","792","113","22304","01","09136"]
["Brewton city, Alabama","5288","16407","2367","1896","471","44528","01","09208"]
["Bridgeport city, Alabama","2316","12000","1212","1020","192","35551","01","09328"]
["Brighton city, Alabama","2904","13709","1601","1130","471","28125","01","09400"]
["Brilliant town, Alabama","1173","14478","666","564","102","40675","01","09424"]
["Bristow Cove CDP, Alabama","485","32083","402","155","247","52464","01","09457"]
["Brook Highland CDP, Alabama","7754","35614","4003","3742","261","72664","01","09500"]
["Brookside town, Alabama","1252","28889","543","445","98","62321","01","09736"]
["Brookwood town, Alabama","2406","32639","960","885","75","64479","01","09808"]
["Broomtown CDP, Alabama","228","9396","102","91","11","25083","01","09880"]
["Brundidge city, Alabama","2293","14395","1183","817","366","35440","01","10240"]
["Bucks CDP, Alabama","13","-666666666","7","7","0","-666666666","01","10456"]
["Butler town, Alabama","2385","18600","1055","916","139","39553","01","11032"]
["Calera city, Alabama","16126","38319","6155","5971","184","70504","01","11416"]
["Calvert CDP, Alabama","70","-666666666","92","70","22","-666666666","01","11488"]
["Camden city, Alabama","2128","14043","699","551","148","40670","01","11512"]
["Camp Hill town, Alabama","1324","11548","642","496","146","28800","01","11680"]
["Carbon Hill city, Alabama","1522","8819","965","652","313","26481","01","12016"]
["Cardiff town, Alabama","24","10000","15","10","5","-666666666","01","12040"]
["Carlisle-Rockledge CDP, Alabama","2472","23081","920","821","99","37468","01","12070"]
["Carlton CDP, Alabama","54","14333","49","22","27","-666666666","01","12112"]
["Carolina town, Alabama","255","25500","146","112","34","50714","01","12160"]
["Carrollton town, Alabama","1100","15722","428","371","57","28487","01","12304"]
["Castleberry town, Alabama","401","15083","266","151","115","42083","01","12496"]
["Catherine CDP, Alabama","0","-666666666","0","0","0","-666666666","01","12544"]
["Cedar Bluff town, Alabama","1700","17577","1038","694","344","37667","01","12760"]
["Center Point city, Alabama","16422","18839","6652","5784","868","44676","01","13264"]
["Centre city, Alabama","3497","18231","1627","1359","268","38778","01","13648"]
["Centreville city, Alabama","2789","14110","1300","1081","219","35074","01","13672"]
["Chatom town, Alabama","789","16203","416","257","159","52788","01","14008"]
["Chelsea city, Alabama","14710","51393","5201","4847","354","93658","01","14104"]
["Cherokee town, Alabama","911","12833","435","352","83","36406","01","14152"]
["Chickasaw city, Alabama","6421","13018","2785","2316","469","36196","01","14392"]
["Childersburg city, Alabama","4768","14220","2076","1983","93","37043","01","14464"]
["Choccolocco CDP, Alabama","2843","26627","1169","1067","102","65268","01","14728"]
["Chunchula CDP, Alabama","241","30500","90","90","0","35896","01","14968"]
["Citronelle city, Alabama","3940","21836","1640","1397","243","50956","01","15064"]
["Clanton city, Alabama","8715","21659","3980","3510","470","48051","01","15136"]
["Clay city, Alabama","10320","34819","4099","3648","451","74265","01","15256"]
["Clayhatchee town, Alabama","637","25382","327","271","56","45688","01","15304"]
["Clayton town, Alabama","2512","10829","676","508","168","30658","01","15376"]
["Cleveland town, Alabama","1291","28545","511","459","52","46458","01","15472"]
["Clio city, Alabama","1195","11986","658","531","127","24735","01","15640"]
["Coaling town, Alabama","2112","42654","723","634","89","75098","01","16000"]
["Coats Bend CDP, Alabama","1119","23857","581","458","123","45056","01","16080"]
["Coffee Springs town, Alabama","197","24643","161","105","56","41010","01","16240"]
["Coffeeville town, Alabama","240","8500","211","100","111","26786","01","16264"]
["Coker town, Alabama","1068","23900","469","419","50","57404","01","16312"]
["Collinsville town, Alabama","2044","15600","817","616","201","37500","01","16600"]
["Colony town, Alabama","312","18625","155","129","26","41875","01","16684"]
["Columbia town, Alabama","876","17559","397","342","55","51563","01","16744"]
["Columbiana city, Alabama","4197","21341","1627","1406","221","50357","01","16768"]
["Concord CDP, Alabama","1641","24577","785","669","116","70114","01","16936"]
["Coosada town, Alabama","1074","24462","424","391","33","58512","01","17176"]
["Cordova city, Alabama","1709","13850","782","619","163","35764","01","17368"]
["Cottondale CDP, Alabama","3793","26750","1802","1548","254","49516","01","17704"]
["Cottonwood town, Alabama","1155","13105","641","468","173","29375","01","17824"]
["County Line town, Alabama","247","46000","108","91","17","92708","01","17968"]
["Courtland town, Alabama","846","11121","391","300","91","38125","01","18040"]
["Cowarts town, Alabama","2196","22014","899","779","120","52042","01","18088"]
["Creola city, Alabama","2764","29897","947","874","73","56382","01","18304"]
["Crossville town, Alabama","1920","10121","666","598","68","37917","01","18856"]
["Cuba town, Alabama","378","21550","198","166","32","54063","01","18952"]
["Cullman city, Alabama","17892","21165","8332","7577","755","54669","01","18976"]
["Cullomburg CDP, Alabama","263","8672","80","68","12","-666666666","01","19024"]
["Cusseta town, Alabama","101","15500","50","41","9","71250","01","19216"]
["Dadeville city, Alabama","3051","10955","1324","1104","220","24722","01","19336"]
["Daleville city, Alabama","4912","19574","2789","2381","408","43459","01","19360"]
["Daphne city, Alabama","27088","38976","11201","10417","784","74701","01","19648"]
["Dauphin Island town, Alabama","1771","38561","2157","773","1384","62560","01","19744"]
["Daviston town, Alabama","253","21500","94","94","0","44583","01","19816"]
["Dayton town, Alabama","67","22000","22","8","14","45000","01","19912"]
["Deatsville town, Alabama","2114","56692","678","669","9","97868","01","20008"]
["Decatur city, Alabama","57303","23354","25888","23797","2091","52539","01","20104"]
["Deer Park CDP, Alabama","63","2499","44","44","0","2499","01","20152"]
["Delta CDP, Alabama","158","21067","131","64","67","-666666666","01","20272"]
["Demopolis city, Alabama","7134","14488","3628","3042","586","40968","01","20296"]
["Detroit town, Alabama","261","2499","144","107","37","-666666666","01","20392"]
["Dodge City town, Alabama","660","21167","280","254","26","49167","01","20955"]
["Dora city, Alabama","2725","20370","1152","950","202","52592","01","21136"]
["Dothan city, Alabama","70318","20435","32906","27751","5155","49203","01","21184"]
["Double Springs town, Alabama","1753","12012","700","611","89","33987","01","21280"]
["Douglas town, Alabama","1007","22444","355","328","27","43750","01","21328"]
["Dozier town, Alabama","450","18400","196","139","57","-666666666","01","21448"]
["Dunnavant CDP, Alabama","1184","26661","517","498","19","71538","01","21890"]
["Dutton town, Alabama","423","11146","203","180","23","-666666666","01","21952"]
["Eagle Point CDP, Alabama","2794","73957","890","867","23","142250","01","22088"]
["East Brewton city, Alabama","3131","12408","1196","936","260","38587","01","22216"]
["East Point CDP, Alabama","351","42389","86","86","0","70738","01","22504"]
["Eclectic town, Alabama","1274","16000","557","461","96","46339","01","22816"]
["Edgewater CDP, Alabama","836","32214","488","346","142","128333","01","23032"]
["Edwardsville town, Alabama","183","28167","81","73","8","62250","01","23176"]
["Egypt CDP, Alabama","1107","24968","419","372","47","42944","01","23224"]
["Elba city, Alabama","3449","23132","1560","1177","383","39913","01","23296"]
["Elberta town, Alabama","2302","22420","1091","953","138","48657","01","23320"]
["Eldridge town, Alabama","141","38000","51","37","14","49250","01","23344"]
["Elkmont town, Alabama","373","27773","255","168","87","41429","01","23488"]
["Elmore town, Alabama","1572","12267","708","600","108","26650","01","23656"]
["Emelle town, Alabama","66","8615","36","29","7","-666666666","01","23872"]
["Emerald Mountain CDP, Alabama","3456","69579","1042","974","68","102232","01","23880"]
["Enterprise city, Alabama","28242","25672","12409","11175","1234","63859","01","24184"]
["Epes town, Alabama","465","13300","235","196","39","-666666666","01","24256"]
["Equality CDP, Alabama","67","2499","25","25","0","-666666666","01","24280"]
["Ethelsville town, Alabama","105","28833","38","33","5","60938","01","24472"]
["Eufaula city, Alabama","12753","14891","5772","4922","850","35127","01","24568"]
["Eunola CDP, Alabama","137","14200","51","51","0","-666666666","01","24616"]
["Eutaw town, Alabama","2890","11045","1527","1351","176","30331","01","24664"]
["Eva town, Alabama","583","40700","211","202","9","102000","01","24688"]
["Evergreen city, Alabama","3504","14768","1588","1162","426","36021","01","24808"]
["Excel town, Alabama","539","24708","234","178","56","62500","01","24880"]
["Fairfield city, Alabama","10108","16863","4914","3944","970","43914","01","25120"]
["Fairford CDP, Alabama","171","-666666666","53","53","0","-666666666","01","25216"]
["Fairhope city, Alabama","21825","28646","9254","8119","1135","83258","01","25240"]
["Fairview town, Alabama","717","17813","225","225","0","33750","01","25384"]
["Falkville town, Alabama","1347","26250","493","385","108","38281","01","25648"]
["Faunsdale town, Alabama","106","8056","39","25","14","-666666666","01","25816"]
["Fayette city, Alabama","4271","12426","2324","1672","652","34133","01","25840"]
["Fayetteville CDP, Alabama","1329","26461","613","527","86","55284","01","25864"]
["Fitzpatrick CDP, Alabama","0","-666666666","19","0","19","-666666666","01","26152"]
["Five Points town, Alabama","121","25500","66","37","29","56458","01","26200"]
["Flomaton town, Alabama","1728","10919","801","624","177","31522","01","26824"]
["Florala town, Alabama","1779","11549","945","659","286","26696","01","26848"]
["Florence city, Alabama","39709","17957","19493","16827","2666","40944","01","26896"]
["Foley city, Alabama","20170","23161","10610","9243","1367","53817","01","26992"]
["Forestdale CDP, Alabama","9251","27742","4453","3890","563","58706","01","27088"]
["Forkland town, Alabama","886","11347","314","239","75","24375","01","27376"]
["Fort Deposit town, Alabama","1899","12244","713","624","89","26389","01","27520"]
["Fort Payne city, Alabama","14730","16805","6491","5536","955","44330","01","27616"]
["Fort Rucker CDP, Alabama","5912","35381","1519","1461","58","67574","01","27640"]
["Franklin town, Alabama","841","39750","469","359","110","74369","01","28024"]
["Fredonia CDP, Alabama","277","18859","99","87","12","-666666666","01","28120"]
["Frisco City town, Alabama","1668","8250","672","535","137","25804","01","28312"]
["Fruitdale CDP, Alabama","197","2499","110","87","23","-666666666","01","28408"]
["Fruithurst town, Alabama","403","19000","142","104","38","48500","01","28432"]
["Fulton town, Alabama","446","22200","175","136","39","53952","01","28504"]
["Fultondale city, Alabama","9707","34242","4255","3924","331","72766","01","28552"]
["Fyffe town, Alabama","1327","27200","586","499","87","34432","01","28672"]
["Gadsden city, Alabama","34317","14351","16954","13261","3693","35776","01","28696"]
["Gainesville town, Alabama","236","8717","94","56","38","-666666666","01","28768"]
["Gallant CDP, Alabama","835","13164","366","340","26","-666666666","01","28816"]
["Gantt town, Alabama","143","26500","102","58","44","57500","01","28936"]
["Garden City town, Alabama","622","32794","219","205","14","50313","01","29032"]
["Gardendale city, Alabama","15920","35646","6620","6393","227","74608","01","29056"]
["Gaylesville town, Alabama","288","9714","90","82","8","45833","01","29296"]
["Geiger town, Alabama","383","28692","142","136","6","48125","01","29392"]
["Geneva city, Alabama","4208","14468","2252","1933","319","38125","01","29464"]
["Georgiana town, Alabama","1374","12343","812","493","319","29750","01","29560"]
["Geraldine town, Alabama","1266","19286","538","480","58","50208","01","29608"]
["Gilbertown town, Alabama","666","35370","434","322","112","61094","01","29704"]
["Glen Allen town, Alabama","455","25091","171","142","29","41731","01","29944"]
["Glencoe city, Alabama","5360","22201","2445","1998","447","63060","01","29992"]
["Glenwood town, Alabama","221","26667","125","85","40","31875","01","30160"]
["Goldville town, Alabama","74","20400","34","29","5","35313","01","30448"]
["Good Hope city, Alabama","2463","27052","892","794","98","58036","01","30496"]
["Goodwater town, Alabama","1172","18884","811","480","331","32256","01","30640"]
["Gordo town, Alabama","1599","22083","683","590","93","42449","01","30736"]
["Gordon town, Alabama","287","16714","190","139","51","41750","01","30760"]
["Gordonville town, Alabama","326","35125","92","71","21","44688","01","30808"]
["Goshen town, Alabama","352","24200","181","114","67","38750","01","30880"]
["Graham CDP, Alabama","89","31650","49","33","16","39531","01","31000"]
["Grand Bay CDP, Alabama","3433","50146","1874","1400","474","71167","01","31024"]
["Grant town, Alabama","1524","31000","529","470","59","66923","01","31096"]
["Grayson Valley CDP, Alabama","6037","14132","2858","2639","219","53403","01","31348"]
["Graysville city, Alabama","2723","26725","1183","1079","104","50216","01","31384"]
["Greensboro city, Alabama","2484","13693","1255","990","265","25465","01","31720"]
["Greenville city, Alabama","7395","18070","3383","2327","1056","39959","01","31912"]
["Grimes town, Alabama","589","24833","314","224","90","41071","01","32056"]
["Grove Hill town, Alabama","2069","23045","966","746","220","53250","01","32080"]
["Guin city, Alabama","2490","19935","1139","834","305","44634","01","32224"]
["Gulfcrest CDP, Alabama","136","27577","37","37","0","-666666666","01","32248"]
["Gulf Shores city, Alabama","14712","28309","14403","7026","7377","53048","01","32272"]
["Guntersville city, Alabama","8559","17880","3910","3296","614","53750","01","32416"]
["Gurley town, Alabama","601","22821","326","244","82","56250","01","32440"]
["Gu-Win town, Alabama","144","15000","64","50","14","33750","01","32536"]
["Hackleburg town, Alabama","1463","14017","756","587","169","31910","01","32560"]
["Hackneyville CDP, Alabama","524","14139","178","169","9","-666666666","01","32584"]
["Haleburg town, Alabama","116","30833","55","45","10","57083","01","32656"]
["Haleyville city, Alabama","4343","20492","1855","1446","409","47701","01","32704"]
["Hamilton city, Alabama","6974","15710","3388","2831","557","42722","01","32848"]
["Hammondville town, Alabama","393","15700","218","157","61","41042","01","32896"]
["Hanceville city, Alabama","3174","14548","1514","1246","268","34111","01","32968"]
["Hanover CDP, Alabama","61","-666666666","63","23","40","-666666666","01","33064"]
["Harpersville town, Alabama","1589","30324","760","592","168","66303","01","33256"]
["Hartford city, Alabama","2630","17971","1116","907","209","42043","01","33424"]
["Hartselle city, Alabama","15308","25542","6401","5711","690","61557","01","33448"]
["Harvest CDP, Alabama","6655","44800","2485","2284","201","106059","01","33472"]
["Hatton CDP, Alabama","451","74200","152","130","22","250001","01","33544"]
["Hayden town, Alabama","1441","37538","558","491","67","75221","01","33640"]
["Hayneville town, Alabama","1027","12821","471","388","83","26364","01","33712"]
["Hazel Green CDP, Alabama","3811","26734","1475","1376","99","55786","01","33808"]
["Headland city, Alabama","4941","33578","2008","1735","273","72391","01","33856"]
["Heath town, Alabama","274","22188","176","155","21","55747","01","33904"]
["Heflin city, Alabama","3416","14321","1487","1308","179","40368","01","33976"]
["Helena city, Alabama","20680","46217","8016","7520","496","96173","01","34024"]
["Henagar city, Alabama","2436","20608","924","775","149","49688","01","34096"]
["Highland Lake town, Alabama","413","37625","262","182","80","51957","01","34480"]
["Highland Lakes CDP, Alabama","6137","80750","2067","2067","0","148405","01","34490"]
["Hillsboro town, Alabama","678","29000","262","238","24","52035","01","34816"]
["Hissop CDP, Alabama","208","-666666666","90","66","24","-666666666","01","34984"]
["Hobson CDP, Alabama","197","49038","80","80","0","126842","01","35130"]
["Hobson City town, Alabama","947","13600","467","356","111","36250","01","35152"]
["Hodges town, Alabama","377","28400","120","99","21","70750","01","35200"]
["Hokes Bluff city, Alabama","4402","37006","2209","1807","402","56681","01","35392"]
["Hollins CDP, Alabama","758","24214","298","263","35","47634","01","35512"]
["Hollis Crossroads CDP, Alabama","676","22412","266","214","52","51111","01","35536"]
["Holly Pond town, Alabama","819","16412","324","273","51","43594","01","35560"]
["Hollywood town, Alabama","950","27500","477","450","27","39615","01","35632"]
["Holt CDP, Alabama","4793","22819","1612","1365","247","37194","01","35704"]
["Holtville CDP, Alabama","4970","29846","2279","1963","316","61038","01","35752"]
["Homewood city, Alabama","26206","39159","10896","9539","1357","89433","01","35800"]
["Hoover city, Alabama","91371","39708","38131","35222","2909","95970","01","35896"]
["Horn Hill town, Alabama","291","22750","121","111","10","36875","01","36088"]
["Hueytown city, Alabama","16694","32600","6658","5942","716","58151","01","36448"]
["Huguley CDP, Alabama","3017","19218","1137","977","160","39601","01","36592"]
["Huntsville city, Alabama","210081","23915","98740","91048","7692","60959","01","37000"]
["Hurtsboro town, Alabama","429","15100","313","201","112","37083","01","37096"]
["Hytop town, Alabama","528","30583","228","207","21","60625","01","37264"]
["Ider town, Alabama","604","10441","322","255","67","37313","01","37312"]
["Indian Springs Village city, Alabama","2563","56744","875","808","67","124659","01","37465"]
["Irondale city, Alabama","13457","31910","6521","6057","464","63010","01","37864"]
["Ivalee CDP, Alabama","606","13731","337","237","100","36307","01","38032"]
["Jackson city, Alabama","4774","18500","2238","1703","535","49460","01","38152"]
["Jacksons' Gap town, Alabama","707","16357","378","278","100","51071","01","38248"]
["Jacksonville city, Alabama","13076","11800","5833","5124","709","41920","01","38272"]
["Jasper city, Alabama","14370","19508","5936","5186","750","55721","01","38416"]
["Jemison city, Alabama","2631","26041","955","902","53","55333","01","38608"]
["Joppa CDP, Alabama","681","12389","247","247","0","-666666666","01","39064"]
["Kansas town, Alabama","96","16000","67","53","14","44375","01","39280"]
["Kellyton town, Alabama","126","25071","83","46","37","51250","01","39472"]
["Kennedy town, Alabama","383","22125","205","162","43","43158","01","39520"]
["Killen town, Alabama","1209","32071","517","432","85","54261","01","39784"]
["Kimberly city, Alabama","3792","59370","1341","1172","169","98882","01","39856"]
["Kinsey town, Alabama","2364","21627","989","835","154","52734","01","40072"]
["Kinston town, Alabama","793","18417","288","256","32","40278","01","40096"]
["Ladonia CDP, Alabama","3657","21550","1503","1344","159","47849","01","40648"]
["La Fayette city, Alabama","2666","17096","1204","1015","189","30230","01","40672"]
["Lakeview town, Alabama","137","24500","46","43","3","50750","01","40888"]
["Lake View town, Alabama","3357","46602","1127","1127","0","84456","01","40928"]
["Lanett city, Alabama","6821","21321","3156","2480","676","46404","01","41296"]
["Langston town, Alabama","218","27333","223","104","119","50227","01","41368"]
["Leeds city, Alabama","12385","32464","5195","4620","575","62432","01","41968"]
["Leesburg town, Alabama","697","25031","460","276","184","55625","01","42016"]
["Leighton town, Alabama","687","9206","468","306","162","27946","01","42160"]
["Leroy CDP, Alabama","885","28179","385","289","96","68854","01","42304"]
["Lester town, Alabama","167","22625","58","51","7","46250","01","42352"]
["Level Plains town, Alabama","1826","28988","845","742","103","66786","01","42472"]
["Lexington town, Alabama","940","21192","380","331","49","58304","01","42640"]
["Libertyville town, Alabama","70","26500","30","28","2","105000","01","42808"]
["Lillian CDP, Alabama","2114","28606","690","610","80","55192","01","42928"]
["Lincoln city, Alabama","6836","22344","3196","2495","701","63464","01","43120"]
["Linden city, Alabama","1981","12714","927","620","307","40427","01","43240"]
["Lineville city, Alabama","2598","11244","1448","1168","280","36522","01","43264"]
["Lipscomb city, Alabama","2113","20714","997","790","207","41161","01","43336"]
["Lisman town, Alabama","499","9565","280","215","65","44583","01","43384"]
["Littleville town, Alabama","873","29167","413","345","68","48594","01","43648"]
["Livingston city, Alabama","3227","8250","1147","938","209","16321","01","43720"]
["Loachapoka town, Alabama","207","28083","96","87","9","39688","01","43744"]
["Lockhart town, Alabama","264","13692","197","117","80","31477","01","43816"]
["Locust Fork town, Alabama","1532","20451","605","583","22","33775","01","43888"]
["Lookout Mountain CDP, Alabama","1427","18198","626","477","149","-666666666","01","44160"]
["Louisville town, Alabama","562","12870","341","270","71","37679","01","44344"]
["Lowndesboro town, Alabama","113","40750","75","49","26","59375","01","44536"]
["Loxley town, Alabama","3566","27237","1537","1179","358","73125","01","44608"]
["Luverne city, Alabama","2716","20870","1254","927","327","49148","01","44728"]
["Lynn town, Alabama","811","11333","412","362","50","35880","01","44800"]
["McCalla CDP, Alabama","13221","41595","5573","5151","422","73332","01","45040"]
["McDonald Chapel CDP, Alabama","636","24042","270","222","48","45900","01","45208"]
["Macedonia CDP, Alabama","176","26893","177","78","99","44038","01","45316"]
["McIntosh town, Alabama","455","26731","155","135","20","73750","01","45472"]
["McKenzie town, Alabama","917","13158","373","305","68","25781","01","45496"]
["McMullen town, Alabama","16","10615","22","16","6","11538","01","45640"]
["Madison city, Alabama","55551","48249","22020","21357","663","105335","01","45784"]
["Madrid town, Alabama","278","22786","137","99","38","46250","01","45904"]
["Magnolia Springs town, Alabama","1443","25250","603","474","129","81786","01","46072"]
["Malcolm CDP, Alabama","88","-666666666","123","36","87","-666666666","01","46192"]
["Malvern town, Alabama","1711","23667","698","618","80","45167","01","46264"]
["Maplesville town, Alabama","673","20500","272","236","36","44500","01","46504"]
["Marbury CDP, Alabama","1893","21676","762","558","204","66250","01","46600"]
["Margaret town, Alabama","5118","44848","1750","1627","123","64992","01","46696"]
["Marion city, Alabama","3273","14627","1074","794","280","28915","01","46768"]
["Maytown town, Alabama","257","30700","129","107","22","47750","01","47728"]
["Meadowbrook CDP, Alabama","9503","69885","3668","3452","216","128125","01","47740"]
["Megargel CDP, Alabama","0","-666666666","0","0","0","-666666666","01","47848"]
["Memphis town, Alabama","6","2499","11","6","5","2499","01","48052"]
["Mentone town, Alabama","340","14950","384","168","216","38000","01","48064"]
["Meridianville CDP, Alabama","8344","39857","3115","3083","32","85719","01","48112"]
["Midfield city, Alabama","5219","15092","2330","1980","350","46929","01","48376"]
["Midland City town, Alabama","1901","14313","1019","840","179","30987","01","48400"]
["Midway town, Alabama","568","9522","316","248","68","25000","01","48424"]
["Mignon CDP, Alabama","833","13111","455","287","168","44844","01","48616"]
["Millbrook city, Alabama","16675","28892","6914","6420","494","59084","01","48712"]
["Millerville CDP, Alabama","376","29938","117","94","23","-666666666","01","48784"]
["Millport town, Alabama","1181","20500","576","420","156","58906","01","48808"]
["Millry town, Alabama","620","17667","325","237","88","37750","01","48832"]
["Minor CDP, Alabama","1052","21000","407","355","52","47837","01","49072"]
["Mobile city, Alabama","187445","17859","91077","77515","13562","44780","01","50000"]
["Monroeville city, Alabama","5953","13957","2915","2326","589","28718","01","50192"]
["Montevallo city, Alabama","6968","16867","2526","2353","173","43504","01","50312"]
["Montgomery city, Alabama","201022","19080","93136","78791","14345","49989","01","51000"]
["Moody city, Alabama","13100","30035","5325","4988","337","69846","01","51096"]
["Moores Mill CDP, Alabama","5659","43571","2371","2295","76","76392","01","51216"]
["Mooresville town, Alabama","83","38955","35","32","3","-666666666","01","51264"]
["Morris town, Alabama","2248","45132","889","874","15","84375","01","51456"]
["Morrison Crossroads CDP, Alabama","130","14474","92","75","17","21402","01","51469"]
["Mosses town, Alabama","818","7727","332","295","37","27634","01","51520"]
["Moulton city, Alabama","3356","13469","1674","1436","238","36992","01","51600"]
["Moundville town, Alabama","2774","19180","949","860","89","57857","01","51648"]
["Mountain Brook city, Alabama","22184","65692","8868","8365","503","150268","01","51696"]
["Mount Olive CDP (Coosa County), Alabama","214","11792","144","86","58","44464","01","52320"]
["Mount Olive CDP (Jefferson County), Alabama","4178","38857","1655","1485","170","85597","01","52344"]
["Mount Vernon town, Alabama","1567","13750","614","475","139","39129","01","52608"]
["Movico CDP, Alabama","46","12690","55","41","14","13750","01","52680"]
["Mulga town, Alabama","682","15950","389","313","76","33750","01","52776"]
["Munford town, Alabama","1582","16182","710","624","86","27375","01","52848"]
["Muscle Shoals city, Alabama","15969","30364","6738","6201","537","61772","01","53016"]
["Myrtlewood town, Alabama","126","33250","69","38","31","71250","01","53112"]
["Nanafalia CDP, Alabama","54","33250","59","27","32","-666666666","01","53208"]
["Nances Creek CDP, Alabama","590","32545","248","248","0","105700","01","53232"]
["Napier Field town, Alabama","405","22818","199","162","37","47692","01","53256"]
["Natural Bridge town, Alabama","15","14500","26","8","18","100500","01","53376"]
["Nauvoo town, Alabama","185","12400","100","74","26","36875","01","53400"]
["Nectar town, Alabama","454","26500","169","130","39","42955","01","53448"]
["Needham town, Alabama","84","19143","63","33","30","56250","01","53472"]
["Newbern town, Alabama","275","9125","112","84","28","30833","01","53784"]
["New Brockton town, Alabama","1210","17923","633","491","142","59760","01","53856"]
["New Hope city, Alabama","2869","35182","1004","929","75","71917","01","54168"]
["New Market CDP, Alabama","1006","16406","606","465","141","45365","01","54312"]
["New Site town, Alabama","830","18778","406","338","68","55000","01","54432"]
["Newton town, Alabama","1606","23422","665","589","76","58594","01","54480"]
["New Union CDP, Alabama","893","28750","373","325","48","66442","01","54582"]
["Newville town, Alabama","390","19227","251","148","103","31786","01","54600"]
["Nixburg CDP, Alabama","438","32521","166","121","45","45515","01","54696"]
["North Courtland town, Alabama","581","9839","286","256","30","26146","01","55044"]
["North Johns town, Alabama","160","28278","87","74","13","41786","01","55152"]
["Northport city, Alabama","30334","25776","12585","11392","1193","69921","01","55200"]
["Notasulga town, Alabama","1082","30000","474","400","74","48333","01","55440"]
["Oak Grove town, Alabama","1123","36528","429","400","29","51711","01","55752"]
["Oak Hill town, Alabama","24","2499","39","16","23","-666666666","01","55848"]
["Oakman town, Alabama","814","11026","424","345","79","21753","01","55992"]
["Odenville city, Alabama","4800","33074","2016","1799","217","69479","01","56400"]
["Ohatchee town, Alabama","1161","23140","625","532","93","59844","01","56472"]
["Oneonta city, Alabama","6778","13865","3085","2922","163","40391","01","57000"]
["Onycha town, Alabama","139","11800","120","53","67","35536","01","57024"]
["Opelika city, Alabama","30810","19599","13428","12155","1273","51074","01","57048"]
["Opp city, Alabama","6671","16850","3298","2766","532","40372","01","57120"]
["Orange Beach city, Alabama","7847","35308","14512","3581","10931","84838","01","57144"]
["Orrville town, Alabama","139","9000","104","77","27","17321","01","57240"]
["Our Town CDP, Alabama","705","55735","450","252","198","65061","01","57384"]
["Owens Cross Roads town, Alabama","2484","33458","1008","938","70","65100","01","57504"]
["Oxford city, Alabama","22210","27800","8660","7794","866","62226","01","57576"]
["Ozark city, Alabama","14396","16674","6703","5830","873","44014","01","57648"]
["Paint Rock town, Alabama","183","25125","78","66","12","58000","01","57696"]
["Panola CDP, Alabama","109","-666666666","33","18","15","-666666666","01","57912"]
["Parrish town, Alabama","1294","13311","575","442","133","33594","01","58272"]
["Pea Ridge CDP, Alabama","971","30649","334","301","33","42298","01","58680"]
["Pelham city, Alabama","24134","38559","9580","9284","296","81606","01","58848"]
["Pell City city, Alabama","12923","27955","5778","5086","692","58036","01","58896"]
["Pennington town, Alabama","604","17262","306","230","76","25732","01","58968"]
["Penton CDP, Alabama","77","-666666666","46","46","0","-666666666","01","59016"]
["Perdido CDP, Alabama","649","17438","267","238","29","42250","01","59064"]
["Perdido Beach town, Alabama","442","34167","377","230","147","71667","01","59088"]
["Peterman CDP, Alabama","35","31583","45","19","26","-666666666","01","59232"]
["Petrey town, Alabama","47","21000","31","19","12","59583","01","59328"]
["Phenix City city, Alabama","38216","14633","17988","15409","2579","43296","01","59472"]
["Phil Campbell town, Alabama","725","13341","428","332","96","29167","01","59496"]
["Pickensville town, Alabama","790","18500","419","318","101","40833","01","59592"]
["Piedmont city, Alabama","4837","15269","2240","1828","412","45463","01","59640"]
["Pike Road town, Alabama","9193","49468","3380","3093","287","109537","01","59760"]
["Pinckard town, Alabama","666","18022","331","279","52","43750","01","59832"]
["Pine Apple town, Alabama","168","26700","97","82","15","39205","01","59880"]
["Pine Hill town, Alabama","865","11850","394","324","70","36184","01","60240"]
["Pine Level CDP, Alabama","3955","35200","1643","1464","179","80066","01","60264"]
["Pine Ridge town, Alabama","717","26979","199","190","9","73205","01","60372"]
["Pinson city, Alabama","7242","33824","2855","2674","181","70393","01","60648"]
["Pisgah town, Alabama","1134","15550","420","341","79","48795","01","60720"]
["Pleasant Grove city, Alabama","9638","37598","3808","3398","410","67000","01","61008"]
["Pleasant Groves town, Alabama","484","29000","240","201","39","53250","01","61038"]
["Point Clear CDP, Alabama","2043","13238","1113","892","221","62188","01","61488"]
["Pollard town, Alabama","136","13625","64","44","20","-666666666","01","61536"]
["Powell town, Alabama","1029","22885","307","285","22","54009","01","62075"]
["Prattville city, Alabama","37977","31370","15162","14301","861","65932","01","62328"]
["Priceville town, Alabama","3479","49375","1100","1065","35","97845","01","62472"]
["Prichard city, Alabama","19645","14549","8876","6665","2211","32900","01","62496"]
["Providence town, Alabama","88","16700","89","57","32","49583","01","62688"]
["Putnam CDP, Alabama","21","-666666666","83","12","71","-666666666","01","62952"]
["Ragland town, Alabama","1784","12691","814","633","181","35875","01","63216"]
["Rainbow City city, Alabama","10093","22950","4558","3798","760","51765","01","63288"]
["Rainsville city, Alabama","5466","20713","2397","2202","195","49375","01","63336"]
["Ranburne town, Alabama","560","21875","224","190","34","45000","01","63408"]
["Ray CDP, Alabama","399","37054","245","175","70","60703","01","63495"]
["Red Bay city, Alabama","3187","16265","1707","1388","319","30000","01","63576"]
["Redland CDP, Alabama","5301","45983","1911","1849","62","107350","01","63730"]
["Red Level town, Alabama","462","23214","220","160","60","47500","01","63768"]
["Redstone Arsenal CDP, Alabama","1199","65833","384","375","9","105156","01","63912"]
["Reece City town, Alabama","744","21133","324","254","70","53958","01","63984"]
["Reeltown CDP, Alabama","339","9703","286","141","145","-666666666","01","64040"]
["Reform town, Alabama","1929","12711","820","709","111","34647","01","64104"]
["Rehobeth town, Alabama","1713","21375","639","595","44","58967","01","64152"]
["Remlap CDP, Alabama","2520","22243","988","901","87","55446","01","64248"]
["Repton town, Alabama","329","22063","124","93","31","37083","01","64368"]
["Ridgeville town, Alabama","80","16500","63","38","25","26719","01","64656"]
["River Falls town, Alabama","603","21848","325","230","95","31250","01","64776"]
["Riverside city, Alabama","2411","20038","1066","956","110","55417","01","64920"]
["Riverview town, Alabama","198","4083","91","54","37","30833","01","65016"]
["Roanoke city, Alabama","5368","13703","2571","2132","439","38731","01","65040"]
["Robertsdale city, Alabama","6603","26942","2548","2317","231","55707","01","65208"]
["Rock Creek CDP, Alabama","1520","28375","646","584","62","63098","01","65412"]
["Rockford town, Alabama","986","12300","300","261","39","26354","01","65472"]
["Rock Mills CDP, Alabama","577","15875","363","203","160","33185","01","65592"]
["Rockville CDP, Alabama","0","-666666666","20","0","20","-666666666","01","65784"]
["Rogersville town, Alabama","1339","17220","681","577","104","42337","01","66216"]
["Rosa town, Alabama","822","26169","377","358","19","36346","01","66408"]
["Russellville city, Alabama","10691","18759","3990","3400","590","43829","01","67056"]
["Rutledge town, Alabama","473","13250","201","162","39","33500","01","67176"]
["St. Florian town, Alabama","510","17326","275","249","26","46250","01","67536"]
["St. Stephens CDP, Alabama","422","28000","151","127","24","-666666666","01","67584"]
["Saks CDP, Alabama","10504","23314","4975","4041","934","51135","01","67608"]
["Samson city, Alabama","1567","12024","836","661","175","28884","01","67800"]
["Sand Rock town, Alabama","798","38125","329","265","64","63698","01","67920"]
["Sanford town, Alabama","235","9071","101","81","20","20341","01","68016"]
["Saraland city, Alabama","15942","26139","7040","6216","824","61216","01","68160"]
["Sardis City town, Alabama","1818","32313","716","652","64","61944","01","68280"]
["Satsuma city, Alabama","6704","34851","2532","2384","148","88312","01","68352"]
["Scottsboro city, Alabama","15446","17503","7239","6241","998","43672","01","68736"]
["Section town, Alabama","953","12393","397","344","53","31667","01","69000"]
["Selma city, Alabama","18429","12247","9319","7239","2080","29656","01","69120"]
["Selmont-West Selmont CDP, Alabama","1995","19541","1053","637","416","31745","01","69180"]
["Semmes city, Alabama","4969","20280","2475","2205","270","55409","01","69240"]
["Sheffield city, Alabama","9305","14101","5191","4202","989","36642","01","69648"]
["Shelby CDP, Alabama","847","14638","392","321","71","54896","01","69672"]
["Shiloh town, Alabama","426","25125","186","171","15","54417","01","69840"]
["Shoal Creek CDP, Alabama","1308","56150","580","508","72","119018","01","69978"]
["Shorter town, Alabama","306","13154","192","147","45","39583","01","70128"]
["Silas town, Alabama","535","25333","255","202","53","45952","01","70416"]
["Silverhill town, Alabama","704","26789","342","308","34","49375","01","70536"]
["Sims Chapel CDP, Alabama","0","-666666666","14","0","14","-666666666","01","70632"]
["Sipsey town, Alabama","267","9225","133","94","39","20526","01","70704"]
["Skyline town, Alabama","1078","22652","456","385","71","36826","01","70896"]
["Slocomb city, Alabama","1816","14938","872","732","140","37596","01","71040"]
["Smiths Station city, Alabama","5420","24524","1921","1777","144","53096","01","71190"]
["Smoke Rise CDP, Alabama","1657","54955","444","444","0","108200","01","71201"]
["Snead town, Alabama","1211","15091","567","487","80","50956","01","71280"]
["Somerville town, Alabama","616","22571","337","257","80","39904","01","71496"]
["Southside city, Alabama","9253","37547","3309","2976","333","66692","01","71832"]
["South Vinemont town, Alabama","440","15475","230","179","51","27625","01","71900"]
["Spanish Fort city, Alabama","9720","38946","4032","3556","476","89504","01","71976"]
["Spring Garden CDP, Alabama","169","9525","81","81","0","29267","01","72408"]
["Springville city, Alabama","4747","37389","2169","1951","218","56106","01","72600"]
["Spruce Pine CDP, Alabama","81","2499","148","63","85","46250","01","72672"]
["Standing Rock CDP, Alabama","78","-666666666","19","19","0","-666666666","01","72720"]
["Stapleton CDP, Alabama","2527","40441","728","660","68","140038","01","72816"]
["Steele town, Alabama","1299","25077","554","462","92","43182","01","72888"]
["Sterrett CDP, Alabama","771","10033","365","353","12","26007","01","73056"]
["Stevenson city, Alabama","2712","17435","1221","1007","214","41348","01","73080"]
["Stewartville CDP, Alabama","1804","33717","885","631","254","55045","01","73152"]
["Stockton CDP, Alabama","371","17466","380","143","237","127699","01","73272"]
["Sulligent city, Alabama","1611","11558","868","695","173","22837","01","73728"]
["Sumiton city, Alabama","2676","26879","1252","1054","198","58578","01","73848"]
["Summerdale town, Alabama","1512","35450","602","534","68","60500","01","73872"]
["Susan Moore town, Alabama","1254","24050","450","406","44","50000","01","74160"]
["Sweet Water town, Alabama","189","26000","104","72","32","63000","01","74304"]
["Sylacauga city, Alabama","12512","15088","5781","5170","611","41864","01","74352"]
["Sylvania town, Alabama","1848","22788","765","691","74","46615","01","74400"]
["Sylvan Springs town, Alabama","1614","38618","574","543","31","75250","01","74424"]
["Talladega city, Alabama","15782","13721","6757","5500","1257","31795","01","74592"]
["Talladega Springs town, Alabama","165","15600","83","71","12","43750","01","74616"]
["Tallassee city, Alabama","5199","19953","2439","2179","260","47405","01","74688"]
["Tarrant city, Alabama","6137","14897","2571","2234","337","36927","01","74976"]
["Taylor town, Alabama","2581","21118","1085","930","155","49394","01","75096"]
["Theodore CDP, Alabama","5949","26659","2362","2142","220","57524","01","75768"]
["Thomaston town, Alabama","469","10417","302","185","117","-666666666","01","75936"]
["Thomasville city, Alabama","3653","22415","1836","1273","563","41417","01","75960"]
["Thorsby town, Alabama","2483","32385","838","762","76","58194","01","76080"]
["Tibbie CDP, Alabama","61","-666666666","15","15","0","-666666666","01","76200"]
["Tidmore Bend CDP, Alabama","1036","19741","428","401","27","45469","01","76208"]
["Tillmans Corner CDP, Alabama","18313","20234","7456","6669","787","45769","01","76320"]
["Town Creek town, Alabama","1006","19950","608","438","170","36824","01","76584"]
["Toxey town, Alabama","150","14032","117","95","22","26875","01","76632"]
["Trafford town, Alabama","446","9476","214","183","31","21146","01","76680"]
["Triana town, Alabama","2784","32438","1204","989","215","71202","01","76824"]
["Trinity town, Alabama","2498","30806","932","844","88","78621","01","76872"]
["Troy city, Alabama","17765","13960","8330","6287","2043","36409","01","76920"]
["Trussville city, Alabama","25027","58545","9110","8699","411","108070","01","76944"]
["Tuscaloosa city, Alabama","99252","15320","48877","36763","12114","44880","01","77256"]
["Tuscumbia city, Alabama","8977","18953","4250","3608","642","42692","01","77280"]
["Tuskegee city, Alabama","9125","11918","4449","3027","1422","32024","01","77304"]
["Twin town, Alabama","396","14214","232","179","53","43125","01","77352"]
["Underwood-Petersville CDP, Alabama","2647","24917","1462","1318","144","38214","01","77580"]
["Union town, Alabama","397","15468","115","94","21","-666666666","01","77616"]
["Union Grove town, Alabama","69","13531","55","38","17","-666666666","01","77784"]
["Union Springs city, Alabama","3389","9375","1511","1140","371","20476","01","77880"]
["Uniontown town, Alabama","2045","8996","1029","756","273","22159","01","77904"]
["Uriah CDP, Alabama","300","42565","149","83","66","-666666666","01","78120"]
["Valley city, Alabama","10498","23424","4925","4011","914","51476","01","78204"]
["Valley Grande city, Alabama","4137","30227","1802","1475","327","64721","01","78232"]
["Valley Head town, Alabama","833","28692","317","296","21","39367","01","78240"]
["Vance town, Alabama","1851","29100","718","646","72","62794","01","78264"]
["Vandiver CDP, Alabama","995","11723","438","438","0","24070","01","78312"]
["Vernon city, Alabama","1919","9809","1139","841","298","34181","01","78480"]
["Vestavia Hills city, Alabama","38504","51665","16317","15066","1251","118539","01","78552"]
["Vina town, Alabama","514","14056","171","143","28","36450","01","78984"]
["Vincent town, Alabama","1807","11335","814","698","116","38571","01","79008"]
["Vinegar Bend CDP, Alabama","158","12892","144","105","39","-666666666","01","79032"]
["Vredenburgh town, Alabama","131","2499","65","23","42","-666666666","01","79272"]
["Wadley town, Alabama","829","8225","303","244","59","21346","01","79344"]
["Waldo town, Alabama","305","15667","168","134","34","36731","01","79488"]
["Walnut Grove town, Alabama","901","18265","372","332","40","36875","01","79728"]
["Warrior city, Alabama","3211","14424","1532","1361","171","44075","01","79944"]
["Waterloo town, Alabama","118","18750","126","60","66","36250","01","80064"]
["Waverly town, Alabama","245","30250","128","111","17","64583","01","80256"]
["Weaver city, Alabama","3364","22018","1378","1120","258","66990","01","80352"]
["Webb town, Alabama","1378","21023","603","525","78","39688","01","80376"]
["Wedowee town, Alabama","863","12654","516","374","142","35750","01","80496"]
["Weogufka CDP, Alabama","308","35929","110","89","21","43850","01","80736"]
["West Blocton town, Alabama","1361","16529","520","434","86","37330","01","80928"]
["West End-Cobb Town CDP, Alabama","3065","18339","1514","1164","350","40143","01","81084"]
["West Jefferson town, Alabama","547","18728","286","245","41","44531","01","81336"]
["Westover town, Alabama","1991","38529","705","665","40","79362","01","81504"]
["West Point town, Alabama","472","20417","198","175","23","52321","01","81528"]
["Wetumpka city, Alabama","7025","30253","2660","2368","292","49146","01","81720"]
["Whatley CDP, Alabama","315","8303","168","143","25","-666666666","01","81744"]
["White Hall town, Alabama","603","12122","330","272","58","31944","01","81912"]
["White Plains CDP, Alabama","646","14675","294","248","46","53796","01","82104"]
["Whitesboro CDP, Alabama","2150","25438","831","696","135","57880","01","82176"]
["Wilsonville town, Alabama","2167","25149","931","786","145","61111","01","82848"]
["Wilton town, Alabama","879","18273","276","257","19","53594","01","82872"]
["Winfield city, Alabama","4807","19938","2096","1627","469","68109","01","82992"]
["Woodland town, Alabama","542","38667","175","152","23","145227","01","83400"]
["Woodstock town, Alabama","1232","19325","488","393","95","56146","01","83640"]
["Woodville town, Alabama","1011","20775","398","371","27","48750","01","83664"]
["Yellow Bluff town, Alabama","178","10577","105","75","30","16250","01","83976"]
["York city, Alabama","2371","12475","1245","993","252","30307","01","84096"]

{"sheet":"Place B tables 5 years earlier","index":17,"n_rows":586,"n_cols":4,"rows_kept":586,"cut":false,"hidden":true,"merged":[]}
["NAME","B25002_002E","state","place"]
["Fairhope city, Alabama","6791","01","25240"]
["Point Clear CDP, Alabama","835","01","61488"]
["Robertsdale city, Alabama","1975","01","65208"]
["Garden City town, Alabama","182","01","29032"]
["Georgiana town, Alabama","599","01","29560"]
["Brookwood town, Alabama","728","01","09808"]
["Walnut Grove town, Alabama","252","01","79728"]
["Dothan city, Alabama","26166","01","21184"]
["Kinsey town, Alabama","814","01","40072"]
["Theodore CDP, Alabama","2249","01","75768"]
["Eldridge town, Alabama","44","01","23344"]
["Jasper city, Alabama","5485","01","38416"]
["Kansas town, Alabama","72","01","39280"]
["Fultondale city, Alabama","3848","01","28552"]
["Foley city, Alabama","7245","01","26992"]
["Underwood-Petersville CDP, Alabama","1399","01","77580"]
["Guin city, Alabama","1076","01","32224"]
["Daphne city, Alabama","9154","01","19648"]
["Silverhill town, Alabama","303","01","70536"]
["Leesburg town, Alabama","459","01","42016"]
["Rainsville city, Alabama","1933","01","63336"]
["Panola CDP, Alabama","5","01","57912"]
["Penton CDP, Alabama","101","01","59016"]
["Peterman CDP, Alabama","74","01","59232"]
["Pine Level CDP, Alabama","1537","01","60264"]
["Putnam CDP, Alabama","54","01","62952"]
["Ray CDP, Alabama","128","01","63495"]
["Redland CDP, Alabama","1596","01","63730"]
["Reeltown CDP, Alabama","178","01","64040"]
["Perdido Beach town, Alabama","281","01","59088"]
["Rockville CDP, Alabama","17","01","65784"]
["St. Stephens CDP, Alabama","119","01","67584"]
["Shelby CDP, Alabama","390","01","69672"]
["Shoal Creek CDP, Alabama","543","01","69978"]
["Sims Chapel CDP, Alabama","24","01","70632"]
["Spring Garden CDP, Alabama","45","01","72408"]
["Spruce Pine CDP, Alabama","47","01","72672"]
["Standing Rock CDP, Alabama","32","01","72720"]
["Sterrett CDP, Alabama","311","01","73056"]
["Stewartville CDP, Alabama","713","01","73152"]
["Tibbie CDP, Alabama","18","01","76200"]
["Tidmore Bend CDP, Alabama","456","01","76208"]
["Uriah CDP, Alabama","108","01","78120"]
["Vandiver CDP, Alabama","447","01","78312"]
["Vinegar Bend CDP, Alabama","103","01","79032"]
["Weogufka CDP, Alabama","106","01","80736"]
["Whatley CDP, Alabama","12","01","81744"]
["White Plains CDP, Alabama","381","01","82104"]
["Whitesboro CDP, Alabama","772","01","82176"]
["Excel town, Alabama","329","01","24880"]
["Greenville city, Alabama","3025","01","31912"]
["Meridianville CDP, Alabama","2537","01","48112"]
["Redstone Arsenal CDP, Alabama","314","01","63912"]
["Ladonia CDP, Alabama","1187","01","40648"]
["York city, Alabama","1026","01","84096"]
["McKenzie town, Alabama","174","01","45496"]
["Columbiana city, Alabama","1435","01","16768"]
["Centreville city, Alabama","896","01","13672"]
["Luverne city, Alabama","1159","01","44728"]
["Rutledge town, Alabama","138","01","67176"]
["Yellow Bluff town, Alabama","32","01","83976"]
["Semmes city, Alabama","1402","01","69240"]
["Delta CDP, Alabama","130","01","20272"]
["Dunnavant CDP, Alabama","354","01","21890"]
["Egypt CDP, Alabama","309","01","23224"]
["Emerald Mountain CDP, Alabama","1045","01","23880"]
["Eunola CDP, Alabama","171","01","24616"]
["Fairford CDP, Alabama","51","01","25216"]
["East Point CDP, Alabama","60","01","22504"]
["Fayetteville CDP, Alabama","500","01","25864"]
["Fitzpatrick CDP, Alabama","27","01","26152"]
["Fredonia CDP, Alabama","122","01","28120"]
["Fruitdale CDP, Alabama","48","01","28408"]
["Gallant CDP, Alabama","307","01","28816"]
["Graham CDP, Alabama","73","01","31000"]
["Gulfcrest CDP, Alabama","79","01","32248"]
["Hackneyville CDP, Alabama","161","01","32584"]
["Hatton CDP, Alabama","65","01","33544"]
["Highland Lakes CDP, Alabama","1637","01","34490"]
["Hissop CDP, Alabama","303","01","34984"]
["Hobson CDP, Alabama","103","01","35130"]
["Hollins CDP, Alabama","176","01","35512"]
["Hollis Crossroads CDP, Alabama","278","01","35536"]
["Holtville CDP, Alabama","1627","01","35752"]
["Ivalee CDP, Alabama","300","01","38032"]
["Leroy CDP, Alabama","316","01","42304"]
["Lookout Mountain CDP, Alabama","483","01","44160"]
["Macedonia CDP, Alabama","105","01","45316"]
["Malcolm CDP, Alabama","88","01","46192"]
["Marbury CDP, Alabama","655","01","46600"]
["Megargel CDP, Alabama","31","01","47848"]
["Millerville CDP, Alabama","95","01","48784"]
["Mount Olive CDP (Coosa County), Alabama","117","01","52320"]
["Mount Olive CDP (Jefferson County), Alabama","1546","01","52344"]
["Movico CDP, Alabama","57","01","52680"]
["Nanafalia CDP, Alabama","19","01","53208"]
["Nances Creek CDP, Alabama","133","01","53232"]
["New Union CDP, Alabama","389","01","54582"]
["Our Town CDP, Alabama","237","01","57384"]
["Piedmont city, Alabama","2012","01","59640"]
["Huntsville city, Alabama","80000","01","37000"]
["Owens Cross Roads town, Alabama","659","01","57504"]
["Abbeville city, Alabama","1014","01","00124"]
["Eclectic town, Alabama","378","01","22816"]
["Castleberry town, Alabama","265","01","12496"]
["Brewton city, Alabama","2257","01","09208"]
["Flomaton town, Alabama","594","01","26824"]
["Five Points town, Alabama","79","01","26200"]
["Oxford city, Alabama","7835","01","57576"]
["Cowarts town, Alabama","733","01","18088"]
["Prichard city, Alabama","7511","01","62496"]
["Satsuma city, Alabama","2200","01","68352"]
["Maytown town, Alabama","144","01","47728"]
["Morris town, Alabama","731","01","51456"]
["Pleasant Grove city, Alabama","3758","01","61008"]
["Glencoe city, Alabama","2085","01","29992"]
["Hokes Bluff city, Alabama","1751","01","35392"]
["Gordonville town, Alabama","131","01","30808"]
["Lockhart town, Alabama","161","01","43816"]
["Autaugaville town, Alabama","401","01","03220"]
["Arab city, Alabama","3150","01","02116"]
["Pell City city, Alabama","5582","01","58896"]
["Rogersville town, Alabama","483","01","66216"]
["Sheffield city, Alabama","3933","01","69648"]
["Lipscomb city, Alabama","862","01","43336"]
["Sumiton city, Alabama","1065","01","73848"]
["West Jefferson town, Alabama","162","01","81336"]
["Needham town, Alabama","49","01","53472"]
["Silas town, Alabama","177","01","70416"]
["Jacksonville city, Alabama","4545","01","38272"]
["Weaver city, Alabama","1164","01","80352"]
["Gordon town, Alabama","106","01","30760"]
["Taylor town, Alabama","896","01","75096"]
["Webb town, Alabama","511","01","80376"]
["Bayou La Batre city, Alabama","738","01","04684"]
["Mooresville town, Alabama","28","01","51264"]
["Tillmans Corner CDP, Alabama","6670","01","76320"]
["Carbon Hill city, Alabama","698","01","12016"]
["Tuscaloosa city, Alabama","33933","01","77256"]
["Oneonta city, Alabama","2346","01","57000"]
["Susan Moore town, Alabama","280","01","74160"]
["Fulton town, Alabama","75","01","28504"]
["Gaylesville town, Alabama","87","01","29296"]
["Glenwood town, Alabama","89","01","30160"]
["Marion city, Alabama","807","01","46768"]
["Abanda CDP, Alabama","63","01","00100"]
["Axis CDP, Alabama","286","01","03508"]
["Ballplay CDP, Alabama","556","01","03820"]
["Belgreen CDP, Alabama","50","01","05140"]
["Bellamy CDP, Alabama","284","01","05188"]
["Belle Fontaine CDP, Alabama","212","01","05212"]
["Boykin CDP, Alabama","102","01","08680"]
["Brantleyville CDP, Alabama","374","01","09064"]
["Bristow Cove CDP, Alabama","183","01","09457"]
["Brook Highland CDP, Alabama","3165","01","09500"]
["Broomtown CDP, Alabama","76","01","09880"]
["Bucks CDP, Alabama","26","01","10456"]
["Calvert CDP, Alabama","166","01","11488"]
["Carlisle-Rockledge CDP, Alabama","825","01","12070"]
["Carlton CDP, Alabama","24","01","12112"]
["Russellville city, Alabama","3288","01","67056"]
["Vina town, Alabama","133","01","78984"]
["Providence town, Alabama","114","01","62688"]
["Grant town, Alabama","351","01","31096"]
["Daviston town, Alabama","88","01","19816"]
["Clanton city, Alabama","3349","01","15136"]
["Gurley town, Alabama","319","01","32440"]
["Moores Mill CDP, Alabama","2434","01","51216"]
["New Hope city, Alabama","1070","01","54168"]
["New Market CDP, Alabama","482","01","54312"]
["Hurtsboro town, Alabama","229","01","37096"]
["Haleburg town, Alabama","46","01","32656"]
["Newville town, Alabama","215","01","54600"]
["Louisville town, Alabama","185","01","44344"]
["Orrville town, Alabama","73","01","57240"]
["Cuba town, Alabama","208","01","18952"]
["Gainesville town, Alabama","78","01","28768"]
["Alabaster city, Alabama","10706","01","00820"]
["Harpersville town, Alabama","642","01","33256"]
["Gantt town, Alabama","71","01","28936"]
["Libertyville town, Alabama","59","01","42808"]
["Glen Allen town, Alabama","219","01","29944"]
["Franklin town, Alabama","80","01","28024"]
["Blue Springs town, Alabama","40","01","07672"]
["Hobson City town, Alabama","321","01","35152"]
["Cottonwood town, Alabama","526","01","17824"]
["West Blocton town, Alabama","427","01","80928"]
["Gordo town, Alabama","706","01","30736"]
["Brent city, Alabama","1081","01","09136"]
["Section town, Alabama","361","01","69000"]
["Skyline town, Alabama","346","01","70896"]
["South Vinemont town, Alabama","257","01","71900"]
["Carolina town, Alabama","137","01","12160"]
["River Falls town, Alabama","248","01","64776"]
["Gu-Win town, Alabama","57","01","32536"]
["Winfield city, Alabama","1817","01","82992"]
["Billingsley town, Alabama","55","01","06460"]
["Addison town, Alabama","346","01","00484"]
["Arley town, Alabama","181","01","02500"]
["Allgood town, Alabama","219","01","01396"]
["Rosa town, Alabama","141","01","66408"]
["Brantley town, Alabama","362","01","09016"]
["Deatsville town, Alabama","348","01","20008"]
["Courtland town, Alabama","305","01","18040"]
["Aliceville city, Alabama","1118","01","01228"]
["Montgomery city, Alabama","80286","01","51000"]
["Frisco City town, Alabama","521","01","28312"]
["Bridgeport city, Alabama","1033","01","09328"]
["Dutton town, Alabama","104","01","21952"]
["Pleasant Groves town, Alabama","177","01","61038"]
["Fayette city, Alabama","1818","01","25840"]
["Notasulga town, Alabama","442","01","55440"]
["Baileyton town, Alabama","317","01","03676"]
["West Point town, Alabama","272","01","81528"]
["Oak Hill town, Alabama","10","01","55848"]
["Eutaw town, Alabama","998","01","24664"]
["Florala town, Alabama","806","01","26848"]
["Reform town, Alabama","738","01","64104"]
["Springville city, Alabama","1519","01","72600"]
["Stevenson town, Alabama","719","01","73080"]
["Uniontown town, Alabama","786","01","77904"]
["Pike Road town, Alabama","2967","01","59760"]
["Jemison city, Alabama","918","01","38608"]
["Goodwater town, Alabama","562","01","30640"]
["Henagar city, Alabama","836","01","34096"]
["Indian Springs Village city, Alabama","865","01","37465"]
["Fruithurst town, Alabama","104","01","28432"]
["Bakerhill town, Alabama","91","01","03724"]
["Center Point city, Alabama","6265","01","13264"]
["Kennedy town, Alabama","204","01","39520"]
["Hytop town, Alabama","139","01","37264"]
["Pisgah town, Alabama","286","01","60720"]
["Coffeeville town, Alabama","137","01","16264"]
["Blountsville town, Alabama","658","01","07456"]
["Locust Fork town, Alabama","438","01","43888"]
["Smoke Rise CDP, Alabama","769","01","71201"]
["Thomasville city, Alabama","1696","01","75960"]
["Memphis town, Alabama","19","01","48052"]
["Colony town, Alabama","119","01","16684"]
["Hanceville city, Alabama","1094","01","32968"]
["Wedowee town, Alabama","308","01","80496"]
["Loxley town, Alabama","642","01","44608"]
["Sylvania town, Alabama","698","01","74400"]
["St. Florian town, Alabama","185","01","67536"]
["Somerville town, Alabama","297","01","71496"]
["Oak Grove town, Alabama","222","01","55752"]
["Vincent town, Alabama","754","01","79008"]
["Camp Hill town, Alabama","415","01","11680"]
["Brilliant town, Alabama","472","01","09424"]
["Harvest CDP, Alabama","1766","01","33472"]
["Evergreen city, Alabama","1370","01","24808"]
["Repton town, Alabama","72","01","64368"]
["East Brewton city, Alabama","1109","01","22216"]
["Auburn city, Alabama","22061","01","03076"]
["Opelika city, Alabama","11723","01","57048"]
["Leighton town, Alabama","403","01","42160"]
["Fort Rucker CDP, Alabama","1153","01","27640"]
["Midland City town, Alabama","855","01","48400"]
["Black town, Alabama","77","01","07120"]
["Geneva city, Alabama","1636","01","29464"]
["Jacksons' Gap town, Alabama","311","01","38248"]
["Maplesville town, Alabama","284","01","46504"]
["Edgewater CDP, Alabama","325","01","23032"]
["McDonald Chapel CDP, Alabama","200","01","45208"]
["Mountain Brook city, Alabama","7336","01","51696"]
["North Johns town, Alabama","72","01","55152"]
["Rock Creek CDP, Alabama","572","01","65412"]
["Babbie town, Alabama","274","01","03556"]
["Shorter town, Alabama","215","01","70128"]
["Pine Hill town, Alabama","296","01","60240"]
["Tuskegee city, Alabama","3226","01","77304"]
["Clayton town, Alabama","529","01","15376"]
["Heath town, Alabama","103","01","33904"]
["Opp city, Alabama","2598","01","57120"]
["Hayneville town, Alabama","394","01","33712"]
["Carrollton town, Alabama","362","01","12304"]
["Boaz city, Alabama","3286","01","07912"]
["Odenville town, Alabama","1361","01","56400"]
["Brundidge city, Alabama","892","01","10240"]
["Roanoke city, Alabama","2441","01","65040"]
["Rock Mills CDP, Alabama","291","01","65592"]
["Smiths Station city, Alabama","2021","01","71190"]
["Fyffe town, Alabama","479","01","28672"]
["Ider town, Alabama","348","01","37312"]
["Pine Ridge town, Alabama","79","01","60372"]
["Sand Rock town, Alabama","232","01","67920"]
["Valley Head town, Alabama","261","01","78240"]
["Waterloo town, Alabama","75","01","80064"]
["Eva town, Alabama","214","01","24688"]
["Falkville town, Alabama","385","01","25648"]
["Priceville town, Alabama","1032","01","62472"]
["Childersburg city, Alabama","2320","01","14464"]
["Attalla city, Alabama","2312","01","03028"]
["Avon town, Alabama","176","01","03364"]
["West End-Cobb Town CDP, Alabama","1273","01","81084"]
["Kinston town, Alabama","250","01","40096"]
["Rehobeth town, Alabama","585","01","64152"]
["Munford town, Alabama","492","01","52848"]
["Langston town, Alabama","104","01","41368"]
["Hazel Green CDP, Alabama","1209","01","33808"]
["Madison city, Alabama","17305","01","45784"]
["Edwardsville town, Alabama","65","01","23176"]
["Lake View town, Alabama","871","01","40928"]
["Nectar town, Alabama","121","01","53448"]
["Snead town, Alabama","337","01","71280"]
["Vance town, Alabama","444","01","78264"]
["Pelham city, Alabama","8597","01","58848"]
["Linden city, Alabama","1010","01","43240"]
["Ethelsville town, Alabama","48","01","24472"]
["Pine Apple town, Alabama","48","01","59880"]
["Haleyville city, Alabama","1663","01","32704"]
["County Line town, Alabama","148","01","17968"]
["Nauvoo town, Alabama","76","01","53400"]
["Holt CDP, Alabama","1127","01","35704"]
["Northport city, Alabama","9240","01","55200"]
["Hillsboro town, Alabama","238","01","34816"]
["Highland Lake town, Alabama","180","01","34480"]
["Elmore town, Alabama","541","01","23656"]
["Tallassee city, Alabama","2103","01","74688"]
["Elkmont town, Alabama","184","01","23488"]
["Trussville city, Alabama","7518","01","76944"]
["Elba city, Alabama","1387","01","23296"]
["Columbia town, Alabama","257","01","16744"]
["Grand Bay CDP, Alabama","1247","01","31024"]
["Sipsey town, Alabama","173","01","70704"]
["Brighton city, Alabama","1092","01","09400"]
["Chickasaw city, Alabama","2145","01","14392"]
["Saraland city, Alabama","5141","01","68160"]
["Cordova city, Alabama","862","01","17368"]
["Parrish town, Alabama","354","01","58272"]
["Adamsville city, Alabama","1738","01","00460"]
["Concord CDP, Alabama","730","01","16936"]
["Fairfield city, Alabama","4392","01","25120"]
["Homewood city, Alabama","9628","01","35800"]
["Irondale city, Alabama","5124","01","37864"]
["Wilsonville town, Alabama","825","01","82848"]
["Rainbow City city, Alabama","3950","01","63288"]
["Lowndesboro town, Alabama","45","01","44536"]
["Alexandria CDP, Alabama","1420","01","01180"]
["Brookside town, Alabama","490","01","09736"]
["Forestdale CDP, Alabama","3774","01","27088"]
["Gardendale city, Alabama","5498","01","29056"]
["Grayson Valley CDP, Alabama","2261","01","31348"]
["Graysville city, Alabama","778","01","31384"]
["Hueytown city, Alabama","6017","01","36448"]
["Trafford town, Alabama","265","01","76680"]
["Reece City town, Alabama","277","01","63984"]
["Fort Deposit town, Alabama","528","01","27520"]
["Toxey town, Alabama","73","01","76632"]
["Altoona town, Alabama","315","01","01660"]
["Benton town, Alabama","10","01","05692"]
["Mosses town, Alabama","435","01","51520"]
["Ohatchee town, Alabama","433","01","56472"]
["Saks CDP, Alabama","4230","01","67608"]
["New Brockton town, Alabama","459","01","53856"]
["Madrid town, Alabama","132","01","45904"]
["Oakman town, Alabama","296","01","55992"]
["Sylvan Springs town, Alabama","673","01","74424"]
["Birmingham city, Alabama","90479","01","07000"]
["Helena city, Alabama","6289","01","34024"]
["Hoover city, Alabama","32929","01","35896"]
["Midfield city, Alabama","1859","01","48376"]
["Vestavia Hills city, Alabama","13452","01","78552"]
["Andalusia city, Alabama","3661","01","01708"]
["Horn Hill town, Alabama","108","01","36088"]
["Onycha town, Alabama","54","01","57024"]
["Red Level town, Alabama","151","01","63768"]
["Berry town, Alabama","580","01","05932"]
["Belk town, Alabama","90","01","05164"]
["Anniston city, Alabama","9518","01","01852"]
["Atmore city, Alabama","3262","01","03004"]
["Lineville city, Alabama","939","01","43264"]
["Heflin city, Alabama","1358","01","33976"]
["Akron town, Alabama","107","01","00676"]
["Moundville town, Alabama","889","01","51648"]
["Guntersville city, Alabama","3302","01","32416"]
["Pollard town, Alabama","69","01","61536"]
["Goshen town, Alabama","137","01","30880"]
["Bay Minette city, Alabama","2795","01","04660"]
["Elberta town, Alabama","627","01","23320"]
["Orange Beach city, Alabama","2559","01","57144"]
["Kimberly city, Alabama","947","01","39856"]
["Cottondale CDP, Alabama","1130","01","17704"]
["Moody city, Alabama","4835","01","51096"]
["Selma city, Alabama","7624","01","69120"]
["Paint Rock town, Alabama","76","01","57696"]
["Hayden town, Alabama","426","01","33640"]
["McMullen town, Alabama","5","01","45640"]
["Thomaston town, Alabama","106","01","75936"]
["Geraldine town, Alabama","303","01","29608"]
["Powell town, Alabama","313","01","62075"]
["Hartselle city, Alabama","5351","01","33448"]
["Mignon CDP, Alabama","439","01","48616"]
["Triana town, Alabama","280","01","76824"]
["Meadowbrook CDP, Alabama","3125","01","47740"]
["Dayton town, Alabama","9","01","19912"]
["Demopolis city, Alabama","2978","01","20296"]
["Sweet Water town, Alabama","113","01","74304"]
["Huguley CDP, Alabama","1051","01","36592"]
["Shiloh town, Alabama","118","01","69840"]
["Ozark city, Alabama","5967","01","57648"]
["Goldville town, Alabama","11","01","30448"]
["Waverly town, Alabama","100","01","80256"]
["Valley city, Alabama","3670","01","78204"]
["Littleville town, Alabama","387","01","43648"]
["Bear Creek town, Alabama","476","01","04852"]
["La Fayette city, Alabama","1133","01","40672"]
["Lanett city, Alabama","2631","01","41296"]
["Tuscumbia city, Alabama","3498","01","77280"]
["Boligee town, Alabama","244","01","08104"]
["Malvern town, Alabama","698","01","46264"]
["Thorsby town, Alabama","783","01","76080"]
["Steele town, Alabama","476","01","72888"]
["Mentone town, Alabama","149","01","48064"]
["Fort Payne city, Alabama","5075","01","27616"]
["Florence city, Alabama","17575","01","26896"]
["Hamilton city, Alabama","2585","01","32848"]
["Banks town, Alabama","58","01","03940"]
["Wadley town, Alabama","237","01","79344"]
["Wilton town, Alabama","219","01","82872"]
["Faunsdale town, Alabama","21","01","25816"]
["Ariton town, Alabama","248","01","02428"]
["Clayhatchee town, Alabama","205","01","15304"]
["Level Plains town, Alabama","734","01","42472"]
["Newbern town, Alabama","74","01","53784"]
["Phil Campbell town, Alabama","506","01","59496"]
["Blue Ridge CDP, Alabama","525","01","07588"]
["Millbrook city, Alabama","5710","01","48712"]
["Prattville city, Alabama","13356","01","62328"]
["Wetumpka city, Alabama","2630","01","81720"]
["Town Creek town, Alabama","383","01","76584"]
["Rockford town, Alabama","246","01","65472"]
["Douglas town, Alabama","317","01","21328"]
["Daleville city, Alabama","2086","01","19360"]
["Napier Field town, Alabama","197","01","53256"]
["Fairview town, Alabama","166","01","25384"]
["Vredenburgh town, Alabama","49","01","79272"]
["Scottsboro city, Alabama","5937","01","68736"]
["Eufaula city, Alabama","4790","01","24568"]
["Warrior city, Alabama","1443","01","79944"]
["Double Springs town, Alabama","376","01","21280"]
["Natural Bridge town, Alabama","13","01","53376"]
["Selmont-West Selmont CDP, Alabama","798","01","69180"]
["North Courtland town, Alabama","381","01","55044"]
["Margaret town, Alabama","1152","01","46696"]
["Killen town, Alabama","434","01","39784"]
["McIntosh town, Alabama","94","01","45472"]
["Muscle Shoals city, Alabama","5477","01","53016"]
["Forkland town, Alabama","227","01","27376"]
["Albertville city, Alabama","7315","01","00988"]
["Hartford city, Alabama","1026","01","33424"]
["Beatrice town, Alabama","108","01","04900"]
["Cedar Bluff town, Alabama","852","01","12760"]
["Union Springs city, Alabama","1285","01","77880"]
["Collinsville town, Alabama","637","01","16600"]
["Sylacauga city, Alabama","5054","01","74352"]
["Lester town, Alabama","41","01","42352"]
["Grove Hill town, Alabama","595","01","32080"]
["Headland city, Alabama","1811","01","33856"]
["Dozier town, Alabama","117","01","21448"]
["Hodges town, Alabama","135","01","35200"]
["Lynn town, Alabama","215","01","44800"]
["Petrey town, Alabama","26","01","59328"]
["Centre city, Alabama","1625","01","13648"]
["Moulton city, Alabama","1511","01","51600"]
["Ridgeville town, Alabama","49","01","64656"]
["Cullman city, Alabama","6002","01","18976"]
["Ragland town, Alabama","718","01","63216"]
["Enterprise city, Alabama","10440","01","24184"]
["Ranburne town, Alabama","177","01","63408"]
["Troy city, Alabama","7040","01","76920"]
["Crossville town, Alabama","737","01","18856"]
["Grimes town, Alabama","252","01","32056"]
["Coosada town, Alabama","461","01","17176"]
["Calera city, Alabama","4832","01","11416"]
["Talladega Springs town, Alabama","74","01","74616"]
["Pickensville town, Alabama","307","01","59592"]
["Dadeville city, Alabama","1265","01","19336"]
["Loachapoka town, Alabama","98","01","43744"]
["Vernon city, Alabama","1083","01","78480"]
["Red Bay city, Alabama","1284","01","63576"]
["Union town, Alabama","97","01","77616"]
["Pennington town, Alabama","91","01","58968"]
["Samson city, Alabama","875","01","67800"]
["Mount Vernon town, Alabama","504","01","52608"]
["Gadsden city, Alabama","14162","01","28696"]
["Creola city, Alabama","618","01","18304"]
["Ashford town, Alabama","801","01","02836"]
["Ashland town, Alabama","955","01","02860"]
["Ashville city, Alabama","748","01","02908"]
["Butler town, Alabama","969","01","11032"]
["Camden city, Alabama","815","01","11512"]
["Chelsea city, Alabama","3889","01","14104"]
["Clio city, Alabama","374","01","15640"]
["Coaling town, Alabama","509","01","16000"]
["Morrison Crossroads CDP, Alabama","187","01","51469"]
["Joppa CDP, Alabama","226","01","39064"]
["Midway town, Alabama","264","01","48424"]
["Lakeview town, Alabama","39","01","40888"]
["Bon Air town, Alabama","33","01","08248"]
["Waldo town, Alabama","86","01","79488"]
["Newton town, Alabama","546","01","54480"]
["Coffee Springs town, Alabama","111","01","16240"]
["Sardis City town, Alabama","616","01","68280"]
["White Hall town, Alabama","372","01","81912"]
["Mulga town, Alabama","341","01","52776"]
["Monroeville city, Alabama","2164","01","50192"]
["Minor CDP, Alabama","463","01","49072"]
["Tarrant city, Alabama","2487","01","74976"]
["Talladega city, Alabama","5741","01","74592"]
["Lexington town, Alabama","284","01","42640"]
["Decatur city, Alabama","22279","01","20104"]
["Lincoln city, Alabama","2466","01","43120"]
["Woodland town, Alabama","77","01","83400"]
["Gilbertown town, Alabama","79","01","29704"]
["Alexander City city, Alabama","5860","01","01132"]
["New Site town, Alabama","317","01","54432"]
["Riverside town, Alabama","759","01","64920"]
["Holly Pond town, Alabama","421","01","35560"]
["Hollywood town, Alabama","438","01","35632"]
["Emelle town, Alabama","18","01","23872"]
["Woodville town, Alabama","288","01","83664"]
["Montevallo city, Alabama","2197","01","50312"]
["Myrtlewood town, Alabama","61","01","53112"]
["Chatom town, Alabama","398","01","14008"]
["Millry town, Alabama","208","01","48832"]
["Millport town, Alabama","483","01","48808"]
["Sulligent city, Alabama","889","01","73728"]
["Anderson town, Alabama","108","01","01756"]
["Hackleburg town, Alabama","567","01","32560"]
["Gulf Shores city, Alabama","4762","01","32272"]
["Summerdale town, Alabama","316","01","73872"]
["Hammondville town, Alabama","210","01","32896"]
["Trinity town, Alabama","749","01","76872"]
["Slocomb city, Alabama","680","01","71040"]
["Livingston city, Alabama","1102","01","43720"]
["Spanish Fort city, Alabama","3137","01","71976"]
["Epes town, Alabama","74","01","24256"]
["Geiger town, Alabama","103","01","29392"]
["Pinckard town, Alabama","202","01","59832"]
["Greensboro city, Alabama","1123","01","31720"]
["Union Grove town, Alabama","35","01","77784"]
["Riverview town, Alabama","59","01","65016"]
["Phenix City city, Alabama","14351","01","59472"]
["Cherokee town, Alabama","376","01","14152"]
["Cleveland town, Alabama","443","01","15472"]
["Sanford town, Alabama","91","01","68016"]
["Southside city, Alabama","3285","01","71832"]
["Dora city, Alabama","828","01","21136"]
["Kellyton town, Alabama","81","01","39472"]
["Woodstock town, Alabama","566","01","83640"]
["Valley Grande city, Alabama","1406","01","78232"]
["Westover town, Alabama","482","01","81504"]
["Magnolia Springs town, Alabama","357","01","46072"]
["Clay city, Alabama","3652","01","15256"]
["Pinson city, Alabama","2988","01","60648"]
["Twin town, Alabama","161","01","77352"]
["Cusseta town, Alabama","52","01","19216"]
["Lisman town, Alabama","207","01","43384"]
["Coker town, Alabama","280","01","16312"]
["Jackson city, Alabama","1897","01","38152"]
["Dodge City town, Alabama","231","01","20955"]
["Good Hope town, Alabama","834","01","30496"]
["Beaverton town, Alabama","115","01","04948"]
["Detroit town, Alabama","99","01","20392"]
["Bon Secour CDP, Alabama","434","01","08272"]
["Lillian CDP, Alabama","535","01","42928"]
["Perdido CDP, Alabama","233","01","59064"]
["Stapleton CDP, Alabama","525","01","72816"]
["Stockton CDP, Alabama","241","01","73272"]
["Catherine CDP, Alabama","8","01","12544"]
["Choccolocco CDP, Alabama","1021","01","14728"]
["Chunchula CDP, Alabama","64","01","14968"]
["Coats Bend CDP, Alabama","550","01","16080"]
["Cullomburg CDP, Alabama","50","01","19024"]
["Deer Park CDP, Alabama","52","01","20152"]
["Ardmore town, Alabama","573","01","02260"]
["Athens city, Alabama","9315","01","02956"]
["Citronelle city, Alabama","1380","01","15064"]
["Dauphin Island town, Alabama","499","01","19744"]
["Mobile city, Alabama","76217","01","50000"]
["Argo town, Alabama","1530","01","02320"]
["Bessemer city, Alabama","10512","01","05980"]
["Cardiff town, Alabama","18","01","12040"]
["Leeds city, Alabama","4468","01","41968"]

{"sheet":"Place DP tables","index":18,"n_rows":594,"n_cols":6,"rows_kept":594,"cut":false,"hidden":true,"merged":[]}
["NAME","DP03_0051E","DP03_0062E","DP03_0009PE","state","place"]
["Abanda CDP, Alabama","67","25787","30.3","01","00100"]
["Abbeville city, Alabama","922","36944","7.6","01","00124"]
["Adamsville city, Alabama","1490","46150","11.5","01","00460"]
["Addison town, Alabama","296","44000","0.6","01","00484"]
["Akron town, Alabama","92","28438","2.3","01","00676"]
["Alabaster city, Alabama","11656","83181","3.9","01","00820"]
["Albertville city, Alabama","7409","51718","4.0","01","00988"]
["Alexander City city, Alabama","5795","41778","5.2","01","01132"]
["Alexandria CDP, Alabama","1356","88090","1.1","01","01180"]
["Aliceville city, Alabama","888","30411","22.8","01","01228"]
["Allgood town, Alabama","207","56250","25.2","01","01396"]
["Altoona town, Alabama","460","40000","2.1","01","01660"]
["Andalusia city, Alabama","3148","40516","7.4","01","01708"]
["Anderson town, Alabama","112","76250","9.9","01","01756"]
["Anniston city, Alabama","9322","39928","6.3","01","01852"]
["Arab city, Alabama","3280","50321","2.9","01","02116"]
["Ardmore town, Alabama","584","37448","1.7","01","02260"]
["Argo town, Alabama","1604","80733","0.5","01","02320"]
["Ariton town, Alabama","229","31406","10.6","01","02428"]
["Arley town, Alabama","182","44167","0.8","01","02500"]
["Ashford town, Alabama","886","47167","4.1","01","02836"]
["Ashland town, Alabama","737","25458","8.6","01","02860"]
["Ashville city, Alabama","727","42875","5.7","01","02908"]
["Athens city, Alabama","10211","52211","4.1","01","02956"]
["Atmore city, Alabama","2638","29104","8.4","01","03004"]
["Attalla city, Alabama","2463","46278","3.9","01","03028"]
["Auburn city, Alabama","27656","54700","2.8","01","03076"]
["Autaugaville town, Alabama","432","34375","7.9","01","03220"]
["Avon town, Alabama","172","61250","4.0","01","03364"]
["Axis CDP, Alabama","63","2499","55.6","01","03508"]
["Babbie town, Alabama","192","47500","0.0","01","03556"]
["Baileyton town, Alabama","433","53135","3.8","01","03676"]
["Bakerhill town, Alabama","94","36250","7.1","01","03724"]
["Ballplay CDP, Alabama","464","54803","5.2","01","03820"]
["Banks town, Alabama","87","43558","16.9","01","03940"]
["Bay Minette city, Alabama","2416","35851","10.4","01","04660"]
["Bayou La Batre city, Alabama","1055","29099","1.7","01","04684"]
["Bear Creek town, Alabama","512","33833","13.1","01","04852"]
["Beatrice town, Alabama","70","28750","18.3","01","04900"]
["Beaverton town, Alabama","72","50833","16.7","01","04948"]
["Belgreen CDP, Alabama","33","34375","0.0","01","05140"]
["Belk town, Alabama","128","39167","25.7","01","05164"]
["Bellamy CDP, Alabama","50","16500","0.0","01","05188"]
["Belle Fontaine CDP, Alabama","261","41953","19.3","01","05212"]
["Benton town, Alabama","29","84063","0.0","01","05692"]
["Berlin town, Alabama","239","56563","0.0","01","05812"]
["Berry town, Alabama","360","43300","6.4","01","05932"]
["Bessemer city, Alabama","10521","32416","12.8","01","05980"]
["Billingsley town, Alabama","54","31250","16.2","01","06460"]
["Birmingham city, Alabama","85521","39403","8.0","01","07000"]
["Black town, Alabama","135","51230","1.0","01","07120"]
["Blountsville town, Alabama","648","41335","2.1","01","07456"]
["Blue Ridge CDP, Alabama","603","110250","1.9","01","07588"]
["Blue Springs town, Alabama","35","40625","0.0","01","07672"]
["Boaz city, Alabama","3820","40732","2.5","01","07912"]
["Boligee town, Alabama","81","11445","72.3","01","08104"]
["Bon Air town, Alabama","42","18000","0.0","01","08248"]
["Bon Secour CDP, Alabama","776","72330","0.0","01","08272"]
["Boykin CDP, Alabama","104","32500","0.0","01","08680"]
["Brantley town, Alabama","336","28125","4.3","01","09016"]
["Brantleyville CDP, Alabama","321","46544","10.1","01","09064"]
["Brent city, Alabama","792","22304","13.6","01","09136"]
["Brewton city, Alabama","1896","44528","6.7","01","09208"]
["Bridgeport city, Alabama","1020","35551","10.3","01","09328"]
["Brighton city, Alabama","1130","28125","13.8","01","09400"]
["Brilliant town, Alabama","564","40675","12.3","01","09424"]
["Bristow Cove CDP, Alabama","155","52464","0.0","01","09457"]
["Brook Highland CDP, Alabama","3742","72664","1.5","01","09500"]
["Brookside town, Alabama","445","62321","10.7","01","09736"]
["Brookwood town, Alabama","885","64479","1.4","01","09808"]
["Broomtown CDP, Alabama","91","25083","8.2","01","09880"]
["Brundidge city, Alabama","817","35440","8.9","01","10240"]
["Bucks CDP, Alabama","7","-666666666","-666666666.0","01","10456"]
["Butler town, Alabama","916","39553","1.6","01","11032"]
["Calera city, Alabama","5971","70504","1.4","01","11416"]
["Calvert CDP, Alabama","70","-666666666","-666666666.0","01","11488"]
["Camden city, Alabama","551","40670","12.9","01","11512"]
["Camp Hill town, Alabama","496","28800","20.2","01","11680"]
["Carbon Hill city, Alabama","652","26481","4.6","01","12016"]
["Cardiff town, Alabama","10","-666666666","0.0","01","12040"]
["Carlisle-Rockledge CDP, Alabama","821","37468","6.5","01","12070"]
["Carlton CDP, Alabama","22","-666666666","0.0","01","12112"]
["Carolina town, Alabama","112","50714","0.0","01","12160"]
["Carrollton town, Alabama","371","28487","13.1","01","12304"]
["Castleberry town, Alabama","151","42083","7.3","01","12496"]
["Catherine CDP, Alabama","0","-666666666","-666666666.0","01","12544"]
["Cedar Bluff town, Alabama","694","37667","5.8","01","12760"]
["Center Point city, Alabama","5784","44676","10.4","01","13264"]
["Centre city, Alabama","1359","38778","11.3","01","13648"]
["Centreville city, Alabama","1081","35074","5.6","01","13672"]
["Chatom town, Alabama","257","52788","4.6","01","14008"]
["Chelsea city, Alabama","4847","93658","4.8","01","14104"]
["Cherokee town, Alabama","352","36406","8.6","01","14152"]
["Chickasaw city, Alabama","2316","36196","3.8","01","14392"]
["Childersburg city, Alabama","1983","37043","10.0","01","14464"]
["Choccolocco CDP, Alabama","1067","65268","1.2","01","14728"]
["Chunchula CDP, Alabama","90","35896","0.0","01","14968"]
["Citronelle city, Alabama","1397","50956","3.2","01","15064"]
["Clanton city, Alabama","3510","48051","5.7","01","15136"]
["Clay city, Alabama","3648","74265","2.3","01","15256"]
["Clayhatchee town, Alabama","271","45688","9.7","01","15304"]
["Clayton town, Alabama","508","30658","3.1","01","15376"]
["Cleveland town, Alabama","459","46458","7.0","01","15472"]
["Clio city, Alabama","531","24735","4.8","01","15640"]
["Coaling town, Alabama","634","75098","9.6","01","16000"]
["Coats Bend CDP, Alabama","458","45056","2.5","01","16080"]
["Coffee Springs town, Alabama","105","41010","0.0","01","16240"]
["Coffeeville town, Alabama","100","26786","6.0","01","16264"]
["Coker town, Alabama","419","57404","1.0","01","16312"]
["Collinsville town, Alabama","616","37500","1.2","01","16600"]
["Colony town, Alabama","129","41875","8.1","01","16684"]
["Columbia town, Alabama","342","51563","5.6","01","16744"]
["Columbiana city, Alabama","1406","50357","1.3","01","16768"]
["Concord CDP, Alabama","669","70114","3.0","01","16936"]
["Coosada town, Alabama","391","58512","4.3","01","17176"]
["Cordova city, Alabama","619","35764","5.0","01","17368"]
["Cottondale CDP, Alabama","1548","49516","5.6","01","17704"]
["Cottonwood town, Alabama","468","29375","3.4","01","17824"]
["County Line town, Alabama","91","92708","0.0","01","17968"]
["Courtland town, Alabama","300","38125","2.5","01","18040"]
["Cowarts town, Alabama","779","52042","3.4","01","18088"]
["Creola city, Alabama","874","56382","8.7","01","18304"]
["Crossville town, Alabama","598","37917","2.0","01","18856"]
["Cuba town, Alabama","166","54063","4.0","01","18952"]
["Cullman city, Alabama","7577","54669","1.9","01","18976"]
["Cullomburg CDP, Alabama","68","-666666666","8.4","01","19024"]
["Cusseta town, Alabama","41","71250","0.0","01","19216"]
["Dadeville city, Alabama","1104","24722","27.4","01","19336"]
["Daleville city, Alabama","2381","43459","5.5","01","19360"]
["Daphne city, Alabama","10417","74701","2.9","01","19648"]
["Dauphin Island town, Alabama","773","62560","15.4","01","19744"]
["Daviston town, Alabama","94","44583","0.0","01","19816"]
["Dayton town, Alabama","8","45000","29.2","01","19912"]
["Deatsville town, Alabama","669","97868","4.3","01","20008"]
["Decatur city, Alabama","23797","52539","5.8","01","20104"]
["Deer Park CDP, Alabama","44","2499","0.0","01","20152"]
["Delta CDP, Alabama","64","-666666666","0.0","01","20272"]
["Demopolis city, Alabama","3042","40968","2.1","01","20296"]
["Detroit town, Alabama","107","-666666666","10.8","01","20392"]
["Dodge City town, Alabama","254","49167","0.0","01","20955"]
["Dora city, Alabama","950","52592","8.7","01","21136"]
["Dothan city, Alabama","27751","49203","5.4","01","21184"]
["Double Springs town, Alabama","611","33987","7.7","01","21280"]
["Douglas town, Alabama","328","43750","2.4","01","21328"]
["Dozier town, Alabama","139","-666666666","5.7","01","21448"]
["Dunnavant CDP, Alabama","498","71538","0.0","01","21890"]
["Dutton town, Alabama","180","-666666666","3.0","01","21952"]
["Eagle Point CDP, Alabama","867","142250","1.6","01","22088"]
["East Brewton city, Alabama","936","38587","22.5","01","22216"]
["East Point CDP, Alabama","86","70738","0.0","01","22504"]
["Eclectic town, Alabama","461","46339","8.4","01","22816"]
["Edgewater CDP, Alabama","346","128333","17.5","01","23032"]
["Edwardsville town, Alabama","73","62250","0.0","01","23176"]
["Egypt CDP, Alabama","372","42944","2.9","01","23224"]
["Elba city, Alabama","1177","39913","10.0","01","23296"]
["Elberta town, Alabama","953","48657","5.2","01","23320"]
["Eldridge town, Alabama","37","49250","1.8","01","23344"]
["Elkmont town, Alabama","168","41429","3.1","01","23488"]
["Elmore town, Alabama","600","26650","6.0","01","23656"]
["Emelle town, Alabama","29","-666666666","0.0","01","23872"]
["Emerald Mountain CDP, Alabama","974","102232","3.7","01","23880"]
["Enterprise city, Alabama","11175","63859","5.2","01","24184"]
["Epes town, Alabama","196","-666666666","24.0","01","24256"]
["Equality CDP, Alabama","25","-666666666","-666666666.0","01","24280"]
["Ethelsville town, Alabama","33","60938","4.8","01","24472"]
["Eufaula city, Alabama","4922","35127","8.3","01","24568"]
["Eunola CDP, Alabama","51","-666666666","33.7","01","24616"]
["Eutaw town, Alabama","1351","30331","0.0","01","24664"]
["Eva town, Alabama","202","102000","0.3","01","24688"]
["Evergreen city, Alabama","1162","36021","7.6","01","24808"]
["Excel town, Alabama","178","62500","0.0","01","24880"]
["Fairfield city, Alabama","3944","43914","7.5","01","25120"]
["Fairford CDP, Alabama","53","-666666666","0.0","01","25216"]
["Fairhope city, Alabama","8119","83258","5.3","01","25240"]
["Fairview town, Alabama","225","33750","13.9","01","25384"]
["Falkville town, Alabama","385","38281","4.3","01","25648"]
["Faunsdale town, Alabama","25","-666666666","0.0","01","25816"]
["Fayette city, Alabama","1672","34133","17.5","01","25840"]
["Fayetteville CDP, Alabama","527","55284","0.0","01","25864"]
["Fitzpatrick CDP, Alabama","0","-666666666","-666666666.0","01","26152"]
["Five Points town, Alabama","37","56458","0.0","01","26200"]
["Flomaton town, Alabama","624","31522","11.5","01","26824"]
["Florala town, Alabama","659","26696","2.9","01","26848"]
["Florence city, Alabama","16827","40944","6.0","01","26896"]
["Foley city, Alabama","9243","53817","4.1","01","26992"]
["Forestdale CDP, Alabama","3890","58706","10.3","01","27088"]
["Forkland town, Alabama","239","24375","14.7","01","27376"]
["Fort Deposit town, Alabama","624","26389","21.5","01","27520"]
["Fort Payne city, Alabama","5536","44330","6.9","01","27616"]
["Fort Rucker CDP, Alabama","1461","67574","11.8","01","27640"]
["Franklin town, Alabama","359","74369","19.5","01","28024"]
["Fredonia CDP, Alabama","87","-666666666","0.0","01","28120"]
["Frisco City town, Alabama","535","25804","26.0","01","28312"]
["Fruitdale CDP, Alabama","87","-666666666","0.0","01","28408"]
["Fruithurst town, Alabama","104","48500","0.0","01","28432"]
["Fulton town, Alabama","136","53952","5.5","01","28504"]
["Fultondale city, Alabama","3924","72766","3.4","01","28552"]
["Fyffe town, Alabama","499","34432","3.1","01","28672"]
["Gadsden city, Alabama","13261","35776","9.6","01","28696"]
["Gainesville town, Alabama","56","-666666666","0.0","01","28768"]
["Gallant CDP, Alabama","340","-666666666","2.6","01","28816"]
["Gantt town, Alabama","58","57500","0.0","01","28936"]
["Garden City town, Alabama","205","50313","11.6","01","29032"]
["Gardendale city, Alabama","6393","74608","2.5","01","29056"]
["Gaylesville town, Alabama","82","45833","22.2","01","29296"]
["Geiger town, Alabama","136","48125","9.5","01","29392"]
["Geneva city, Alabama","1933","38125","4.3","01","29464"]
["Georgiana town, Alabama","493","29750","7.3","01","29560"]
["Geraldine town, Alabama","480","50208","2.4","01","29608"]
["Gilbertown town, Alabama","322","61094","5.0","01","29704"]
["Glen Allen town, Alabama","142","41731","3.6","01","29944"]
["Glencoe city, Alabama","1998","63060","1.6","01","29992"]
["Glenwood town, Alabama","85","31875","0.0","01","30160"]
["Goldville town, Alabama","29","35313","0.0","01","30448"]
["Good Hope city, Alabama","794","58036","6.6","01","30496"]
["Goodwater town, Alabama","480","32256","4.7","01","30640"]
["Gordo town, Alabama","590","42449","7.6","01","30736"]
["Gordon town, Alabama","139","41750","27.8","01","30760"]
["Gordonville town, Alabama","71","44688","3.0","01","30808"]
["Goshen town, Alabama","114","38750","11.6","01","30880"]
["Graham CDP, Alabama","33","39531","0.0","01","31000"]
["Grand Bay CDP, Alabama","1400","71167","4.5","01","31024"]
["Grant town, Alabama","470","66923","1.7","01","31096"]
["Grayson Valley CDP, Alabama","2639","53403","8.5","01","31348"]
["Graysville city, Alabama","1079","50216","10.9","01","31384"]
["Greensboro city, Alabama","990","25465","7.5","01","31720"]
["Greenville city, Alabama","2327","39959","7.8","01","31912"]
["Grimes town, Alabama","224","41071","21.8","01","32056"]
["Grove Hill town, Alabama","746","53250","9.3","01","32080"]
["Guin city, Alabama","834","44634","12.5","01","32224"]
["Gulfcrest CDP, Alabama","37","-666666666","0.0","01","32248"]
["Gulf Shores city, Alabama","7026","53048","3.5","01","32272"]
["Guntersville city, Alabama","3296","53750","4.7","01","32416"]
["Gurley town, Alabama","244","56250","3.4","01","32440"]
["Gu-Win town, Alabama","50","33750","21.4","01","32536"]
["Hackleburg town, Alabama","587","31910","9.2","01","32560"]
["Hackneyville CDP, Alabama","169","-666666666","12.4","01","32584"]
["Haleburg town, Alabama","45","57083","10.9","01","32656"]
["Haleyville city, Alabama","1446","47701","5.6","01","32704"]
["Hamilton city, Alabama","2831","42722","4.9","01","32848"]
["Hammondville town, Alabama","157","41042","3.7","01","32896"]
["Hanceville city, Alabama","1246","34111","12.9","01","32968"]
["Hanover CDP, Alabama","23","-666666666","0.0","01","33064"]
["Harpersville town, Alabama","592","66303","5.0","01","33256"]
["Hartford city, Alabama","907","42043","0.8","01","33424"]
["Hartselle city, Alabama","5711","61557","3.0","01","33448"]
["Harvest CDP, Alabama","2284","106059","2.1","01","33472"]
["Hatton CDP, Alabama","130","250001","0.0","01","33544"]
["Hayden town, Alabama","491","75221","1.0","01","33640"]
["Hayneville town, Alabama","388","26364","12.7","01","33712"]
["Hazel Green CDP, Alabama","1376","55786","6.3","01","33808"]
["Headland city, Alabama","1735","72391","3.7","01","33856"]
["Heath town, Alabama","155","55747","9.4","01","33904"]
["Heflin city, Alabama","1308","40368","7.6","01","33976"]
["Helena city, Alabama","7520","96173","2.7","01","34024"]
["Henagar city, Alabama","775","49688","6.1","01","34096"]
["Highland Lake town, Alabama","182","51957","4.9","01","34480"]
["Highland Lakes CDP, Alabama","2067","148405","2.5","01","34490"]
["Hillsboro town, Alabama","238","52035","3.4","01","34816"]
["Hissop CDP, Alabama","66","-666666666","0.0","01","34984"]
["Hobson CDP, Alabama","80","126842","14.7","01","35130"]
["Hobson City town, Alabama","356","36250","6.0","01","35152"]
["Hodges town, Alabama","99","70750","4.7","01","35200"]
["Hokes Bluff city, Alabama","1807","56681","2.4","01","35392"]
["Hollins CDP, Alabama","263","47634","15.8","01","35512"]
["Hollis Crossroads CDP, Alabama","214","51111","0.0","01","35536"]
["Holly Pond town, Alabama","273","43594","3.8","01","35560"]
["Hollywood town, Alabama","450","39615","2.1","01","35632"]
["Holt CDP, Alabama","1365","37194","10.8","01","35704"]
["Holtville CDP, Alabama","1963","61038","6.5","01","35752"]
["Homewood city, Alabama","9539","89433","2.6","01","35800"]
["Hoover city, Alabama","35222","95970","4.4","01","35896"]
["Horn Hill town, Alabama","111","36875","2.0","01","36088"]
["Hueytown city, Alabama","5942","58151","8.8","01","36448"]
["Huguley CDP, Alabama","977","39601","2.6","01","36592"]
["Huntsville city, Alabama","91048","60959","4.9","01","37000"]
["Hurtsboro town, Alabama","201","37083","0.0","01","37096"]
["Hytop town, Alabama","207","60625","3.8","01","37264"]
["Ider town, Alabama","255","37313","7.5","01","37312"]
["Indian Springs Village city, Alabama","808","124659","2.1","01","37465"]
["Irondale city, Alabama","6057","63010","9.0","01","37864"]
["Ivalee CDP, Alabama","237","36307","0.0","01","38032"]
["Jackson city, Alabama","1703","49460","14.4","01","38152"]
["Jacksons' Gap town, Alabama","278","51071","9.9","01","38248"]
["Jacksonville city, Alabama","5124","41920","6.9","01","38272"]
["Jasper city, Alabama","5186","55721","4.9","01","38416"]
["Jemison city, Alabama","902","55333","5.5","01","38608"]
["Joppa CDP, Alabama","247","-666666666","9.4","01","39064"]
["Kansas town, Alabama","53","44375","0.0","01","39280"]
["Kellyton town, Alabama","46","51250","3.2","01","39472"]
["Kennedy town, Alabama","162","43158","3.0","01","39520"]
["Killen town, Alabama","432","54261","3.7","01","39784"]
["Kimberly city, Alabama","1172","98882","1.5","01","39856"]
["Kinsey town, Alabama","835","52734","4.4","01","40072"]
["Kinston town, Alabama","256","40278","22.9","01","40096"]
["Ladonia CDP, Alabama","1344","47849","1.2","01","40648"]
["La Fayette city, Alabama","1015","30230","3.6","01","40672"]
["Lakeview town, Alabama","43","50750","0.0","01","40888"]
["Lake View town, Alabama","1127","84456","4.5","01","40928"]
["Lanett city, Alabama","2480","46404","4.7","01","41296"]
["Langston town, Alabama","104","50227","19.8","01","41368"]
["Leeds city, Alabama","4620","62432","2.1","01","41968"]
["Leesburg town, Alabama","276","55625","5.8","01","42016"]
["Leighton town, Alabama","306","27946","7.1","01","42160"]
["Leroy CDP, Alabama","289","68854","14.2","01","42304"]
["Lester town, Alabama","51","46250","7.5","01","42352"]
["Level Plains town, Alabama","742","66786","3.1","01","42472"]
["Lexington town, Alabama","331","58304","5.2","01","42640"]
["Libertyville town, Alabama","28","105000","0.0","01","42808"]
["Lillian CDP, Alabama","610","55192","3.2","01","42928"]
["Lincoln city, Alabama","2495","63464","6.0","01","43120"]
["Linden city, Alabama","620","40427","12.7","01","43240"]
["Lineville city, Alabama","1168","36522","5.3","01","43264"]
["Lipscomb city, Alabama","790","41161","8.0","01","43336"]
["Lisman town, Alabama","215","44583","7.1","01","43384"]
["Littleville town, Alabama","345","48594","2.1","01","43648"]
["Livingston city, Alabama","938","16321","4.5","01","43720"]
["Loachapoka town, Alabama","87","39688","6.1","01","43744"]
["Lockhart town, Alabama","117","31477","11.2","01","43816"]
["Locust Fork town, Alabama","583","33775","5.4","01","43888"]
["Lookout Mountain CDP, Alabama","477","-666666666","5.8","01","44160"]
["Louisville town, Alabama","270","37679","4.9","01","44344"]
["Lowndesboro town, Alabama","49","59375","0.0","01","44536"]
["Loxley town, Alabama","1179","73125","2.1","01","44608"]
["Luverne city, Alabama","927","49148","2.9","01","44728"]
["Lynn town, Alabama","362","35880","3.6","01","44800"]
["McCalla CDP, Alabama","5151","73332","2.2","01","45040"]
["McDonald Chapel CDP, Alabama","222","45900","43.7","01","45208"]
["Macedonia CDP, Alabama","78","44038","0.0","01","45316"]
["McIntosh town, Alabama","135","73750","1.4","01","45472"]
["McKenzie town, Alabama","305","25781","3.7","01","45496"]
["McMullen town, Alabama","16","11538","100.0","01","45640"]
["Madison city, Alabama","21357","105335","3.3","01","45784"]
["Madrid town, Alabama","99","46250","0.0","01","45904"]
["Magnolia Springs town, Alabama","474","81786","2.0","01","46072"]
["Malcolm CDP, Alabama","36","-666666666","0.0","01","46192"]
["Malvern town, Alabama","618","45167","2.4","01","46264"]
["Maplesville town, Alabama","236","44500","4.2","01","46504"]
["Marbury CDP, Alabama","558","66250","3.5","01","46600"]
["Margaret town, Alabama","1627","64992","2.7","01","46696"]
["Marion city, Alabama","794","28915","21.7","01","46768"]
["Maytown town, Alabama","107","47750","4.1","01","47728"]
["Meadowbrook CDP, Alabama","3452","128125","2.6","01","47740"]
["Megargel CDP, Alabama","0","-666666666","-666666666.0","01","47848"]
["Memphis town, Alabama","6","2499","-666666666.0","01","48052"]
["Mentone town, Alabama","168","38000","0.0","01","48064"]
["Meridianville CDP, Alabama","3083","85719","10.0","01","48112"]
["Midfield city, Alabama","1980","46929","9.6","01","48376"]
["Midland City town, Alabama","840","30987","5.0","01","48400"]
["Midway town, Alabama","248","25000","18.9","01","48424"]
["Mignon CDP, Alabama","287","44844","4.1","01","48616"]
["Millbrook city, Alabama","6420","59084","3.5","01","48712"]
["Millerville CDP, Alabama","94","-666666666","0.0","01","48784"]
["Millport town, Alabama","420","58906","1.8","01","48808"]
["Millry town, Alabama","237","37750","2.9","01","48832"]
["Minor CDP, Alabama","355","47837","12.0","01","49072"]
["Mobile city, Alabama","77515","44780","6.4","01","50000"]
["Monroeville city, Alabama","2326","28718","11.7","01","50192"]
["Montevallo city, Alabama","2353","43504","6.4","01","50312"]
["Montgomery city, Alabama","78791","49989","6.9","01","51000"]
["Moody city, Alabama","4988","69846","6.1","01","51096"]
["Moores Mill CDP, Alabama","2295","76392","1.7","01","51216"]
["Mooresville town, Alabama","32","-666666666","0.0","01","51264"]
["Morris town, Alabama","874","84375","4.0","01","51456"]
["Morrison Crossroads CDP, Alabama","75","21402","0.0","01","51469"]
["Mosses town, Alabama","295","27634","10.2","01","51520"]
["Moulton city, Alabama","1436","36992","5.7","01","51600"]
["Moundville town, Alabama","860","57857","2.6","01","51648"]
["Mountain Brook city, Alabama","8365","150268","1.4","01","51696"]
["Mount Olive CDP (Coosa County), Alabama","86","44464","0.0","01","52320"]
["Mount Olive CDP (Jefferson County), Alabama","1485","85597","0.9","01","52344"]
["Mount Vernon town, Alabama","475","39129","5.2","01","52608"]
["Movico CDP, Alabama","41","13750","0.0","01","52680"]
["Mulga town, Alabama","313","33750","6.7","01","52776"]
["Munford town, Alabama","624","27375","11.3","01","52848"]
["Muscle Shoals city, Alabama","6201","61772","3.3","01","53016"]
["Myrtlewood town, Alabama","38","71250","2.5","01","53112"]
["Nanafalia CDP, Alabama","27","-666666666","0.0","01","53208"]
["Nances Creek CDP, Alabama","248","105700","10.0","01","53232"]
["Napier Field town, Alabama","162","47692","9.8","01","53256"]
["Natural Bridge town, Alabama","8","100500","0.0","01","53376"]
["Nauvoo town, Alabama","74","36875","5.6","01","53400"]
["Nectar town, Alabama","130","42955","9.8","01","53448"]
["Needham town, Alabama","33","56250","0.0","01","53472"]
["Newbern town, Alabama","84","30833","29.4","01","53784"]
["New Brockton town, Alabama","491","59760","3.3","01","53856"]
["New Hope city, Alabama","929","71917","7.8","01","54168"]
["New Market CDP, Alabama","465","45365","8.2","01","54312"]
["New Site town, Alabama","338","55000","3.5","01","54432"]
["Newton town, Alabama","589","58594","4.5","01","54480"]
["New Union CDP, Alabama","325","66442","0.0","01","54582"]
["Newville town, Alabama","148","31786","11.6","01","54600"]
["Nixburg CDP, Alabama","121","45515","0.0","01","54696"]
["North Courtland town, Alabama","256","26146","14.5","01","55044"]
["North Johns town, Alabama","74","41786","0.0","01","55152"]
["Northport city, Alabama","11392","69921","5.4","01","55200"]
["Notasulga town, Alabama","400","48333","0.9","01","55440"]
["Oak Grove town, Alabama","400","51711","8.0","01","55752"]
["Oak Hill town, Alabama","16","-666666666","0.0","01","55848"]
["Oakman town, Alabama","345","21753","8.5","01","55992"]
["Odenville city, Alabama","1799","69479","3.0","01","56400"]
["Ohatchee town, Alabama","532","59844","7.9","01","56472"]
["Oneonta city, Alabama","2922","40391","6.5","01","57000"]
["Onycha town, Alabama","53","35536","0.0","01","57024"]
["Opelika city, Alabama","12155","51074","4.4","01","57048"]
["Opp city, Alabama","2766","40372","8.8","01","57120"]
["Orange Beach city, Alabama","3581","84838","3.3","01","57144"]
["Orrville town, Alabama","77","17321","21.6","01","57240"]
["Our Town CDP, Alabama","252","65061","0.0","01","57384"]
["Owens Cross Roads town, Alabama","938","65100","4.5","01","57504"]
["Oxford city, Alabama","7794","62226","4.4","01","57576"]
["Ozark city, Alabama","5830","44014","11.5","01","57648"]
["Paint Rock town, Alabama","66","58000","5.9","01","57696"]
["Panola CDP, Alabama","18","-666666666","0.0","01","57912"]
["Parrish town, Alabama","442","33594","21.2","01","58272"]
["Pea Ridge CDP, Alabama","301","42298","0.0","01","58680"]
["Pelham city, Alabama","9284","81606","1.9","01","58848"]
["Pell City city, Alabama","5086","58036","6.4","01","58896"]
["Pennington town, Alabama","230","25732","8.8","01","58968"]
["Penton CDP, Alabama","46","-666666666","0.0","01","59016"]
["Perdido CDP, Alabama","238","42250","10.5","01","59064"]
["Perdido Beach town, Alabama","230","71667","3.7","01","59088"]
["Peterman CDP, Alabama","19","-666666666","0.0","01","59232"]
["Petrey town, Alabama","19","59583","0.0","01","59328"]
["Phenix City city, Alabama","15409","43296","8.5","01","59472"]
["Phil Campbell town, Alabama","332","29167","3.6","01","59496"]
["Pickensville town, Alabama","318","40833","6.8","01","59592"]
["Piedmont city, Alabama","1828","45463","8.3","01","59640"]
["Pike Road town, Alabama","3093","109537","2.8","01","59760"]
["Pinckard town, Alabama","279","43750","0.0","01","59832"]
["Pine Apple town, Alabama","82","39205","0.0","01","59880"]
["Pine Hill town, Alabama","324","36184","0.4","01","60240"]
["Pine Level CDP, Alabama","1464","80066","4.5","01","60264"]
["Pine Ridge town, Alabama","190","73205","3.5","01","60372"]
["Pinson city, Alabama","2674","70393","4.8","01","60648"]
["Pisgah town, Alabama","341","48795","4.3","01","60720"]
["Pleasant Grove city, Alabama","3398","67000","3.8","01","61008"]
["Pleasant Groves town, Alabama","201","53250","4.3","01","61038"]
["Point Clear CDP, Alabama","892","62188","3.4","01","61488"]
["Pollard town, Alabama","44","-666666666","0.0","01","61536"]
["Powell town, Alabama","285","54009","2.1","01","62075"]
["Prattville city, Alabama","14301","65932","2.5","01","62328"]
["Priceville town, Alabama","1065","97845","0.7","01","62472"]
["Prichard city, Alabama","6665","32900","9.8","01","62496"]
["Providence town, Alabama","57","49583","17.1","01","62688"]
["Putnam CDP, Alabama","12","-666666666","0.0","01","62952"]
["Ragland town, Alabama","633","35875","17.5","01","63216"]
["Rainbow City city, Alabama","3798","51765","8.1","01","63288"]
["Rainsville city, Alabama","2202","49375","3.1","01","63336"]
["Ranburne town, Alabama","190","45000","6.9","01","63408"]
["Ray CDP, Alabama","175","60703","0.0","01","63495"]
["Red Bay city, Alabama","1388","30000","5.7","01","63576"]
["Redland CDP, Alabama","1849","107350","3.0","01","63730"]
["Red Level town, Alabama","160","47500","15.5","01","63768"]
["Redstone Arsenal CDP, Alabama","375","105156","3.7","01","63912"]
["Reece City town, Alabama","254","53958","2.5","01","63984"]
["Reeltown CDP, Alabama","141","-666666666","17.8","01","64040"]
["Reform town, Alabama","709","34647","1.8","01","64104"]
["Rehobeth town, Alabama","595","58967","3.2","01","64152"]
["Remlap CDP, Alabama","901","55446","11.5","01","64248"]
["Repton town, Alabama","93","37083","4.4","01","64368"]
["Ridgeville town, Alabama","38","26719","5.4","01","64656"]
["River Falls town, Alabama","230","31250","28.2","01","64776"]
["Riverside city, Alabama","956","55417","2.9","01","64920"]
["Riverview town, Alabama","54","30833","0.0","01","65016"]
["Roanoke city, Alabama","2132","38731","5.3","01","65040"]
["Robertsdale city, Alabama","2317","55707","2.0","01","65208"]
["Rock Creek CDP, Alabama","584","63098","5.5","01","65412"]
["Rockford town, Alabama","261","26354","8.8","01","65472"]
["Rock Mills CDP, Alabama","203","33185","7.3","01","65592"]
["Rockville CDP, Alabama","0","-666666666","-666666666.0","01","65784"]
["Rogersville town, Alabama","577","42337","3.8","01","66216"]
["Rosa town, Alabama","358","36346","1.5","01","66408"]
["Russellville city, Alabama","3400","43829","3.7","01","67056"]
["Rutledge town, Alabama","162","33500","3.8","01","67176"]
["St. Florian town, Alabama","249","46250","1.3","01","67536"]
["St. Stephens CDP, Alabama","127","-666666666","0.0","01","67584"]
["Saks CDP, Alabama","4041","51135","7.5","01","67608"]
["Samson city, Alabama","661","28884","11.8","01","67800"]
["Sand Rock town, Alabama","265","63698","4.4","01","67920"]
["Sanford town, Alabama","81","20341","3.1","01","68016"]
["Saraland city, Alabama","6216","61216","5.5","01","68160"]
["Sardis City town, Alabama","652","61944","1.9","01","68280"]
["Satsuma city, Alabama","2384","88312","6.6","01","68352"]
["Scottsboro city, Alabama","6241","43672","3.8","01","68736"]
["Section town, Alabama","344","31667","3.7","01","69000"]
["Selma city, Alabama","7239","29656","11.7","01","69120"]
["Selmont-West Selmont CDP, Alabama","637","31745","3.3","01","69180"]
["Semmes city, Alabama","2205","55409","4.2","01","69240"]
["Sheffield city, Alabama","4202","36642","5.9","01","69648"]
["Shelby CDP, Alabama","321","54896","0.0","01","69672"]
["Shiloh town, Alabama","171","54417","1.9","01","69840"]
["Shoal Creek CDP, Alabama","508","119018","2.6","01","69978"]
["Shorter town, Alabama","147","39583","15.2","01","70128"]
["Silas town, Alabama","202","45952","7.5","01","70416"]
["Silverhill town, Alabama","308","49375","0.3","01","70536"]
["Sims Chapel CDP, Alabama","0","-666666666","-666666666.0","01","70632"]
["Sipsey town, Alabama","94","20526","11.3","01","70704"]
["Skyline town, Alabama","385","36826","5.3","01","70896"]
["Slocomb city, Alabama","732","37596","5.9","01","71040"]
["Smiths Station city, Alabama","1777","53096","6.1","01","71190"]
["Smoke Rise CDP, Alabama","444","108200","8.1","01","71201"]
["Snead town, Alabama","487","50956","1.0","01","71280"]
["Somerville town, Alabama","257","39904","10.0","01","71496"]
["Southside city, Alabama","2976","66692","3.3","01","71832"]
["South Vinemont town, Alabama","179","27625","6.2","01","71900"]
["Spanish Fort city, Alabama","3556","89504","3.6","01","71976"]
["Spring Garden CDP, Alabama","81","29267","0.0","01","72408"]
["Springville city, Alabama","1951","56106","0.0","01","72600"]
["Spruce Pine CDP, Alabama","63","46250","0.0","01","72672"]
["Standing Rock CDP, Alabama","19","-666666666","0.0","01","72720"]
["Stapleton CDP, Alabama","660","140038","0.0","01","72816"]
["Steele town, Alabama","462","43182","7.3","01","72888"]
["Sterrett CDP, Alabama","353","26007","13.6","01","73056"]
["Stevenson city, Alabama","1007","41348","5.0","01","73080"]
["Stewartville CDP, Alabama","631","55045","0.6","01","73152"]
["Stockton CDP, Alabama","143","127699","0.0","01","73272"]
["Sulligent city, Alabama","695","22837","1.3","01","73728"]
["Sumiton city, Alabama","1054","58578","6.7","01","73848"]
["Summerdale town, Alabama","534","60500","1.3","01","73872"]
["Susan Moore town, Alabama","406","50000","4.6","01","74160"]
["Sweet Water town, Alabama","72","63000","11.6","01","74304"]
["Sylacauga city, Alabama","5170","41864","10.1","01","74352"]
["Sylvania town, Alabama","691","46615","1.2","01","74400"]
["Sylvan Springs town, Alabama","543","75250","7.5","01","74424"]
["Talladega city, Alabama","5500","31795","12.0","01","74592"]
["Talladega Springs town, Alabama","71","43750","2.7","01","74616"]
["Tallassee city, Alabama","2179","47405","18.6","01","74688"]
["Tarrant city, Alabama","2234","36927","8.6","01","74976"]
["Taylor town, Alabama","930","49394","3.8","01","75096"]
["Theodore CDP, Alabama","2142","57524","2.2","01","75768"]
["Thomaston town, Alabama","185","-666666666","9.0","01","75936"]
["Thomasville city, Alabama","1273","41417","11.5","01","75960"]
["Thorsby town, Alabama","762","58194","8.7","01","76080"]
["Tibbie CDP, Alabama","15","-666666666","0.0","01","76200"]
["Tidmore Bend CDP, Alabama","401","45469","1.3","01","76208"]
["Tillmans Corner CDP, Alabama","6669","45769","9.6","01","76320"]
["Town Creek town, Alabama","438","36824","4.3","01","76584"]
["Toxey town, Alabama","95","26875","6.0","01","76632"]
["Trafford town, Alabama","183","21146","7.0","01","76680"]
["Triana town, Alabama","989","71202","12.6","01","76824"]
["Trinity town, Alabama","844","78621","1.3","01","76872"]
["Troy city, Alabama","6287","36409","4.1","01","76920"]
["Trussville city, Alabama","8699","108070","3.2","01","76944"]
["Tuscaloosa city, Alabama","36763","44880","6.5","01","77256"]
["Tuscumbia city, Alabama","3608","42692","2.4","01","77280"]
["Tuskegee city, Alabama","3027","32024","12.1","01","77304"]
["Twin town, Alabama","179","43125","6.0","01","77352"]
["Underwood-Petersville CDP, Alabama","1318","38214","5.3","01","77580"]
["Union town, Alabama","94","-666666666","37.1","01","77616"]
["Union Grove town, Alabama","38","-666666666","0.0","01","77784"]
["Union Springs city, Alabama","1140","20476","5.0","01","77880"]
["Uniontown town, Alabama","756","22159","27.8","01","77904"]
["Uriah CDP, Alabama","83","-666666666","0.0","01","78120"]
["Valley city, Alabama","4011","51476","2.1","01","78204"]
["Valley Grande city, Alabama","1475","64721","0.5","01","78232"]
["Valley Head town, Alabama","296","39367","5.8","01","78240"]
["Vance town, Alabama","646","62794","0.6","01","78264"]
["Vandiver CDP, Alabama","438","24070","9.5","01","78312"]
["Vernon city, Alabama","841","34181","3.1","01","78480"]
["Vestavia Hills city, Alabama","15066","118539","1.6","01","78552"]
["Vina town, Alabama","143","36450","0.0","01","78984"]
["Vincent town, Alabama","698","38571","12.5","01","79008"]
["Vinegar Bend CDP, Alabama","105","-666666666","0.0","01","79032"]
["Vredenburgh town, Alabama","23","-666666666","45.5","01","79272"]
["Wadley town, Alabama","244","21346","15.5","01","79344"]
["Waldo town, Alabama","134","36731","13.9","01","79488"]
["Walnut Grove town, Alabama","332","36875","1.2","01","79728"]
["Warrior city, Alabama","1361","44075","12.3","01","79944"]
["Waterloo town, Alabama","60","36250","0.0","01","80064"]
["Waverly town, Alabama","111","64583","0.7","01","80256"]
["Weaver city, Alabama","1120","66990","10.6","01","80352"]
["Webb town, Alabama","525","39688","4.6","01","80376"]
["Wedowee town, Alabama","374","35750","0.8","01","80496"]
["Weogufka CDP, Alabama","89","43850","0.0","01","80736"]
["West Blocton town, Alabama","434","37330","11.4","01","80928"]
["West End-Cobb Town CDP, Alabama","1164","40143","15.9","01","81084"]
["West Jefferson town, Alabama","245","44531","5.4","01","81336"]
["Westover town, Alabama","665","79362","3.9","01","81504"]
["West Point town, Alabama","175","52321","9.7","01","81528"]
["Wetumpka city, Alabama","2368","49146","6.5","01","81720"]
["Whatley CDP, Alabama","143","-666666666","22.1","01","81744"]
["White Hall town, Alabama","272","31944","8.3","01","81912"]
["White Plains CDP, Alabama","248","53796","28.2","01","82104"]
["Whitesboro CDP, Alabama","696","57880","4.2","01","82176"]
["Wilsonville town, Alabama","786","61111","14.9","01","82848"]
["Wilton town, Alabama","257","53594","14.3","01","82872"]
["Winfield city, Alabama","1627","68109","2.0","01","82992"]
["Woodland town, Alabama","152","145227","4.0","01","83400"]
["Woodstock town, Alabama","393","56146","15.0","01","83640"]
["Woodville town, Alabama","371","48750","13.1","01","83664"]
["Yellow Bluff town, Alabama","75","16250","50.0","01","83976"]
["York city, Alabama","993","30307","8.8","01","84096"]

{"sheet":"Place S tables","index":19,"n_rows":594,"n_cols":7,"rows_kept":594,"cut":false,"hidden":true,"merged":[]}
["NAME","S1701_C01_042E","S1701_C01_001E","S2201_C03_001E","S2201_C01_001E","state","place"]
["Abanda CDP, Alabama","173","231","0","67","01","00100"]
["Abbeville city, Alabama","1037","2069","202","922","01","00124"]
["Adamsville city, Alabama","1862","4326","348","1490","01","00460"]
["Addison town, Alabama","227","697","37","296","01","00484"]
["Akron town, Alabama","178","385","10","92","01","00676"]
["Alabaster city, Alabama","6318","32810","753","11656","01","00820"]
["Albertville city, Alabama","9998","21901","890","7409","01","00988"]
["Alexander City city, Alabama","5801","14430","1351","5795","01","01132"]
["Alexandria CDP, Alabama","558","4092","69","1356","01","01180"]
["Aliceville city, Alabama","1481","2244","248","888","01","01228"]
["Allgood town, Alabama","392","863","28","207","01","01396"]
["Altoona town, Alabama","729","1399","120","460","01","01660"]
["Andalusia city, Alabama","3719","8278","401","3148","01","01708"]
["Anderson town, Alabama","54","255","6","112","01","01756"]
["Anniston city, Alabama","9297","20706","2094","9322","01","01852"]
["Arab city, Alabama","2788","8346","373","3280","01","02116"]
["Ardmore town, Alabama","472","1276","63","584","01","02260"]
["Argo town, Alabama","907","4411","91","1604","01","02320"]
["Ariton town, Alabama","379","660","63","229","01","02428"]
["Arley town, Alabama","286","624","40","182","01","02500"]
["Ashford town, Alabama","1031","2473","176","886","01","02836"]
["Ashland town, Alabama","975","1622","166","737","01","02860"]
["Ashville city, Alabama","940","2005","135","727","01","02908"]
["Athens city, Alabama","7994","24696","1207","10211","01","02956"]
["Atmore city, Alabama","3633","6240","652","2638","01","03004"]
["Attalla city, Alabama","1922","5674","253","2463","01","03028"]
["Auburn city, Alabama","25547","69242","1360","27656","01","03076"]
["Autaugaville town, Alabama","593","999","155","432","01","03220"]
["Avon town, Alabama","171","490","25","172","01","03364"]
["Axis CDP, Alabama","63","92","0","63","01","03508"]
["Babbie town, Alabama","243","502","51","192","01","03556"]
["Baileyton town, Alabama","452","1114","47","433","01","03676"]
["Bakerhill town, Alabama","96","216","12","94","01","03724"]
["Ballplay CDP, Alabama","586","1391","67","464","01","03820"]
["Banks town, Alabama","90","249","16","87","01","03940"]
["Bay Minette city, Alabama","3234","6507","511","2416","01","04660"]
["Bayou La Batre city, Alabama","1491","2492","398","1055","01","04684"]
["Bear Creek town, Alabama","812","1570","196","512","01","04852"]
["Beatrice town, Alabama","89","179","2","70","01","04900"]
["Beaverton town, Alabama","57","166","10","72","01","04948"]
["Belgreen CDP, Alabama","9","42","0","33","01","05140"]
["Belk town, Alabama","179","384","27","128","01","05164"]
["Bellamy CDP, Alabama","99","126","9","50","01","05188"]
["Belle Fontaine CDP, Alabama","359","739","100","261","01","05212"]
["Benton town, Alabama","0","50","1","29","01","05692"]
["Berlin town, Alabama","353","639","22","239","01","05812"]
["Berry town, Alabama","359","966","73","360","01","05932"]
["Bessemer city, Alabama","14038","25696","2946","10521","01","05980"]
["Billingsley town, Alabama","89","133","16","54","01","06460"]
["Birmingham city, Alabama","94518","194797","18538","85521","01","07000"]
["Black town, Alabama","276","395","64","135","01","07120"]
["Blountsville town, Alabama","812","1887","96","648","01","07456"]
["Blue Ridge CDP, Alabama","93","1442","20","603","01","07588"]
["Blue Springs town, Alabama","47","85","5","35","01","07672"]
["Boaz city, Alabama","4125","9894","496","3820","01","07912"]
["Boligee town, Alabama","228","242","29","81","01","08104"]
["Bon Air town, Alabama","54","78","7","42","01","08248"]
["Bon Secour CDP, Alabama","759","2476","186","776","01","08272"]
["Boykin CDP, Alabama","316","330","35","104","01","08680"]
["Brantley town, Alabama","499","966","145","336","01","09016"]
["Brantleyville CDP, Alabama","320","871","59","321","01","09064"]
["Brent city, Alabama","1180","1960","316","792","01","09136"]
["Brewton city, Alabama","1826","4910","352","1896","01","09208"]
["Bridgeport city, Alabama","1406","2316","178","1020","01","09328"]
["Brighton city, Alabama","1684","2838","206","1130","01","09400"]
["Brilliant town, Alabama","651","1173","145","564","01","09424"]
["Bristow Cove CDP, Alabama","133","485","0","155","01","09457"]
["Brook Highland CDP, Alabama","1148","7754","77","3742","01","09500"]
["Brookside town, Alabama","321","1251","93","445","01","09736"]
["Brookwood town, Alabama","461","2403","30","885","01","09808"]
["Broomtown CDP, Alabama","193","228","31","91","01","09880"]
["Brundidge city, Alabama","1265","2280","207","817","01","10240"]
["Bucks CDP, Alabama","0","13","0","7","01","10456"]
["Butler town, Alabama","953","2272","95","916","01","11032"]
["Calera city, Alabama","3407","16117","327","5971","01","11416"]
["Calvert CDP, Alabama","0","70","0","70","01","11488"]
["Camden city, Alabama","1071","2063","161","551","01","11512"]
["Camp Hill town, Alabama","953","1324","146","496","01","11680"]
["Carbon Hill city, Alabama","792","1512","238","652","01","12016"]
["Cardiff town, Alabama","7","24","1","10","01","12040"]
["Carlisle-Rockledge CDP, Alabama","1233","2472","44","821","01","12070"]
["Carlton CDP, Alabama","6","54","0","22","01","12112"]
["Carolina town, Alabama","71","255","4","112","01","12160"]
["Carrollton town, Alabama","596","984","67","371","01","12304"]
["Castleberry town, Alabama","222","397","28","151","01","12496"]
["Catherine CDP, Alabama","0","0","0","0","01","12544"]
["Cedar Bluff town, Alabama","776","1698","129","694","01","12760"]
["Center Point city, Alabama","7575","16270","1001","5784","01","13264"]
["Centre city, Alabama","1285","3235","232","1359","01","13648"]
["Centreville city, Alabama","1200","2675","223","1081","01","13672"]
["Chatom town, Alabama","263","677","31","257","01","14008"]
["Chelsea city, Alabama","1274","14613","90","4847","01","14104"]
["Cherokee town, Alabama","495","911","91","352","01","14152"]
["Chickasaw city, Alabama","3658","6401","651","2316","01","14392"]
["Childersburg city, Alabama","2684","4768","295","1983","01","14464"]
["Choccolocco CDP, Alabama","791","2843","60","1067","01","14728"]
["Chunchula CDP, Alabama","118","241","10","90","01","14968"]
["Citronelle city, Alabama","1830","3878","157","1397","01","15064"]
["Clanton city, Alabama","3185","8258","420","3510","01","15136"]
["Clay city, Alabama","2642","10166","301","3648","01","15256"]
["Clayhatchee town, Alabama","212","637","43","271","01","15304"]
["Clayton town, Alabama","630","993","193","508","01","15376"]
["Cleveland town, Alabama","568","1291","38","459","01","15472"]
["Clio city, Alabama","866","1195","117","531","01","15640"]
["Coaling town, Alabama","735","2106","143","634","01","16000"]
["Coats Bend CDP, Alabama","387","1119","8","458","01","16080"]
["Coffee Springs town, Alabama","45","197","11","105","01","16240"]
["Coffeeville town, Alabama","96","233","12","100","01","16264"]
["Coker town, Alabama","282","1057","12","419","01","16312"]
["Collinsville town, Alabama","1471","1871","141","616","01","16600"]
["Colony town, Alabama","107","312","19","129","01","16684"]
["Columbia town, Alabama","281","876","39","342","01","16744"]
["Columbiana city, Alabama","1493","3165","177","1406","01","16768"]
["Concord CDP, Alabama","427","1631","62","669","01","16936"]
["Coosada town, Alabama","324","1074","40","391","01","17176"]
["Cordova city, Alabama","847","1610","184","619","01","17368"]
["Cottondale CDP, Alabama","1448","3724","150","1548","01","17704"]
["Cottonwood town, Alabama","775","1155","95","468","01","17824"]
["County Line town, Alabama","72","247","0","91","01","17968"]
["Courtland town, Alabama","412","846","81","300","01","18040"]
["Cowarts town, Alabama","907","2187","119","779","01","18088"]
["Creola city, Alabama","1118","2764","117","874","01","18304"]
["Crossville town, Alabama","771","1788","94","598","01","18856"]
["Cuba town, Alabama","108","378","0","166","01","18952"]
["Cullman city, Alabama","4382","17377","863","7577","01","18976"]
["Cullomburg CDP, Alabama","39","263","12","68","01","19024"]
["Cusseta town, Alabama","36","101","2","41","01","19216"]
["Dadeville city, Alabama","1539","2819","346","1104","01","19336"]
["Daleville city, Alabama","1854","4897","587","2381","01","19360"]
["Daphne city, Alabama","6822","26819","434","10417","01","19648"]
["Dauphin Island town, Alabama","260","1737","8","773","01","19744"]
["Daviston town, Alabama","140","253","14","94","01","19816"]
["Dayton town, Alabama","53","67","4","8","01","19912"]
["Deatsville town, Alabama","335","2114","52","669","01","20008"]
["Decatur city, Alabama","21401","56246","3224","23797","01","20104"]
["Deer Park CDP, Alabama","35","63","0","44","01","20152"]
["Delta CDP, Alabama","136","158","0","64","01","20272"]
["Demopolis city, Alabama","3076","7053","508","3042","01","20296"]
["Detroit town, Alabama","173","261","38","107","01","20392"]
["Dodge City town, Alabama","235","660","36","254","01","20955"]
["Dora city, Alabama","1113","2725","128","950","01","21136"]
["Dothan city, Alabama","26056","69246","4073","27751","01","21184"]
["Double Springs town, Alabama","994","1583","176","611","01","21280"]
["Douglas town, Alabama","596","998","65","328","01","21328"]
["Dozier town, Alabama","148","450","80","139","01","21448"]
["Dunnavant CDP, Alabama","194","1184","0","498","01","21890"]
["Dutton town, Alabama","239","423","76","180","01","21952"]
["Eagle Point CDP, Alabama","147","2794","0","867","01","22088"]
["East Brewton city, Alabama","1899","3131","226","936","01","22216"]
["East Point CDP, Alabama","96","351","7","86","01","22504"]
["Eclectic town, Alabama","512","1272","64","461","01","22816"]
["Edgewater CDP, Alabama","261","836","54","346","01","23032"]
["Edwardsville town, Alabama","68","183","3","73","01","23176"]
["Egypt CDP, Alabama","456","1107","54","372","01","23224"]
["Elba city, Alabama","1578","3074","258","1177","01","23296"]
["Elberta town, Alabama","1107","2285","171","953","01","23320"]
["Eldridge town, Alabama","83","129","1","37","01","23344"]
["Elkmont town, Alabama","135","373","18","168","01","23488"]
["Elmore town, Alabama","988","1572","181","600","01","23656"]
["Emelle town, Alabama","50","66","15","29","01","23872"]
["Emerald Mountain CDP, Alabama","154","3456","41","974","01","23880"]
["Enterprise city, Alabama","8911","27931","1145","11175","01","24184"]
["Epes town, Alabama","243","465","46","196","01","24256"]
["Equality CDP, Alabama","60","67","9","25","01","24280"]
["Ethelsville town, Alabama","23","105","0","33","01","24472"]
["Eufaula city, Alabama","6627","12568","1424","4922","01","24568"]
["Eunola CDP, Alabama","79","137","15","51","01","24616"]
["Eutaw town, Alabama","1306","2779","421","1351","01","24664"]
["Eva town, Alabama","123","583","3","202","01","24688"]
["Evergreen city, Alabama","2613","3466","290","1162","01","24808"]
["Excel town, Alabama","131","539","13","178","01","24880"]
["Fairfield city, Alabama","3544","9338","693","3944","01","25120"]
["Fairford CDP, Alabama","0","171","0","53","01","25216"]
["Fairhope city, Alabama","4163","21581","387","8119","01","25240"]
["Fairview town, Alabama","424","717","46","225","01","25384"]
["Falkville town, Alabama","479","1034","19","385","01","25648"]
["Faunsdale town, Alabama","14","106","8","25","01","25816"]
["Fayette city, Alabama","2028","4046","476","1672","01","25840"]
["Fayetteville CDP, Alabama","435","1329","80","527","01","25864"]
["Fitzpatrick CDP, Alabama","0","0","0","0","01","26152"]
["Five Points town, Alabama","17","121","5","37","01","26200"]
["Flomaton town, Alabama","977","1728","170","624","01","26824"]
["Florala town, Alabama","796","1779","150","659","01","26848"]
["Florence city, Alabama","17450","38001","2795","16827","01","26896"]
["Foley city, Alabama","5701","20002","534","9243","01","26992"]
["Forestdale CDP, Alabama","2716","9159","488","3890","01","27088"]
["Forkland town, Alabama","641","886","48","239","01","27376"]
["Fort Deposit town, Alabama","979","1894","180","624","01","27520"]
["Fort Payne city, Alabama","6252","14246","983","5536","01","27616"]
["Fort Rucker CDP, Alabama","1823","4851","0","1461","01","27640"]
["Franklin town, Alabama","161","821","25","359","01","28024"]
["Fredonia CDP, Alabama","169","277","44","87","01","28120"]
["Frisco City town, Alabama","789","1668","81","535","01","28312"]
["Fruitdale CDP, Alabama","129","197","0","87","01","28408"]
["Fruithurst town, Alabama","314","403","34","104","01","28432"]
["Fulton town, Alabama","107","446","19","136","01","28504"]
["Fultondale city, Alabama","2855","9646","162","3924","01","28552"]
["Fyffe town, Alabama","648","1327","71","499","01","28672"]
["Gadsden city, Alabama","16985","33528","3077","13261","01","28696"]
["Gainesville town, Alabama","178","236","40","56","01","28768"]
["Gallant CDP, Alabama","519","835","59","340","01","28816"]
["Gantt town, Alabama","35","143","9","58","01","28936"]
["Garden City town, Alabama","360","622","37","205","01","29032"]
["Gardendale city, Alabama","2462","15112","266","6393","01","29056"]
["Gaylesville town, Alabama","155","288","25","82","01","29296"]
["Geiger town, Alabama","199","383","41","136","01","29392"]
["Geneva city, Alabama","1957","4054","423","1933","01","29464"]
["Georgiana town, Alabama","697","1374","158","493","01","29560"]
["Geraldine town, Alabama","503","1259","124","480","01","29608"]
["Gilbertown town, Alabama","212","666","24","322","01","29704"]
["Glen Allen town, Alabama","251","455","21","142","01","29944"]
["Glencoe city, Alabama","1042","5360","87","1998","01","29992"]
["Glenwood town, Alabama","110","221","8","85","01","30160"]
["Goldville town, Alabama","47","74","3","29","01","30448"]
["Good Hope city, Alabama","1091","2463","125","794","01","30496"]
["Goodwater town, Alabama","651","1121","124","480","01","30640"]
["Gordo town, Alabama","589","1599","114","590","01","30736"]
["Gordon town, Alabama","138","287","37","139","01","30760"]
["Gordonville town, Alabama","176","326","24","71","01","30808"]
["Goshen town, Alabama","175","352","25","114","01","30880"]
["Graham CDP, Alabama","21","89","3","33","01","31000"]
["Grand Bay CDP, Alabama","992","3362","73","1400","01","31024"]
["Grant town, Alabama","544","1492","38","470","01","31096"]
["Grayson Valley CDP, Alabama","2377","5967","521","2639","01","31348"]
["Graysville city, Alabama","927","2707","185","1079","01","31384"]
["Greensboro city, Alabama","1440","2403","426","990","01","31720"]
["Greenville city, Alabama","3710","7215","451","2327","01","31912"]
["Grimes town, Alabama","303","589","70","224","01","32056"]
["Grove Hill town, Alabama","525","1961","108","746","01","32080"]
["Guin city, Alabama","1177","2426","180","834","01","32224"]
["Gulfcrest CDP, Alabama","53","136","0","37","01","32248"]
["Gulf Shores city, Alabama","3356","14705","360","7026","01","32272"]
["Guntersville city, Alabama","3101","8278","552","3296","01","32416"]
["Gurley town, Alabama","232","596","37","244","01","32440"]
["Gu-Win town, Alabama","50","143","10","50","01","32536"]
["Hackleburg town, Alabama","834","1445","126","587","01","32560"]
["Hackneyville CDP, Alabama","321","524","40","169","01","32584"]
["Haleburg town, Alabama","38","116","4","45","01","32656"]
["Haleyville city, Alabama","2194","4217","394","1446","01","32704"]
["Hamilton city, Alabama","3234","6682","430","2831","01","32848"]
["Hammondville town, Alabama","145","393","5","157","01","32896"]
["Hanceville city, Alabama","1580","2822","180","1246","01","32968"]
["Hanover CDP, Alabama","0","61","9","23","01","33064"]
["Harpersville town, Alabama","398","1589","77","592","01","33256"]
["Hartford city, Alabama","1368","2552","251","907","01","33424"]
["Hartselle city, Alabama","4096","15259","756","5711","01","33448"]
["Harvest CDP, Alabama","1238","6655","158","2284","01","33472"]
["Hatton CDP, Alabama","0","451","9","130","01","33544"]
["Hayden town, Alabama","246","1413","51","491","01","33640"]
["Hayneville town, Alabama","553","954","127","388","01","33712"]
["Hazel Green CDP, Alabama","1370","3764","121","1376","01","33808"]
["Headland city, Alabama","1055","4657","159","1735","01","33856"]
["Heath town, Alabama","95","274","7","155","01","33904"]
["Heflin city, Alabama","1248","3271","242","1308","01","33976"]
["Helena city, Alabama","2854","20596","187","7520","01","34024"]
["Henagar city, Alabama","1088","2416","107","775","01","34096"]
["Highland Lake town, Alabama","64","413","6","182","01","34480"]
["Highland Lakes CDP, Alabama","609","6137","29","2067","01","34490"]
["Hillsboro town, Alabama","126","669","29","238","01","34816"]
["Hissop CDP, Alabama","0","208","0","66","01","34984"]
["Hobson CDP, Alabama","0","197","0","80","01","35130"]
["Hobson City town, Alabama","574","939","97","356","01","35152"]
["Hodges town, Alabama","76","375","19","99","01","35200"]
["Hokes Bluff city, Alabama","792","4356","58","1807","01","35392"]
["Hollins CDP, Alabama","314","758","33","263","01","35512"]
["Hollis Crossroads CDP, Alabama","330","676","32","214","01","35536"]
["Holly Pond town, Alabama","366","819","30","273","01","35560"]
["Hollywood town, Alabama","330","947","50","450","01","35632"]
["Holt CDP, Alabama","3529","4793","358","1365","01","35704"]
["Holtville CDP, Alabama","1485","4910","154","1963","01","35752"]
["Homewood city, Alabama","4671","24038","179","9539","01","35800"]
["Hoover city, Alabama","15675","90875","1585","35222","01","35896"]
["Horn Hill town, Alabama","142","291","10","111","01","36088"]
["Hueytown city, Alabama","5628","16319","643","5942","01","36448"]
["Huguley CDP, Alabama","1072","3001","79","977","01","36592"]
["Huntsville city, Alabama","63583","200911","10683","91048","01","37000"]
["Hurtsboro town, Alabama","146","429","38","201","01","37096"]
["Hytop town, Alabama","152","527","30","207","01","37264"]
["Ider town, Alabama","291","604","53","255","01","37312"]
["Indian Springs Village city, Alabama","252","2563","0","808","01","37465"]
["Irondale city, Alabama","3541","13408","606","6057","01","37864"]
["Ivalee CDP, Alabama","228","606","22","237","01","38032"]
["Jackson city, Alabama","1720","4669","284","1703","01","38152"]
["Jacksons' Gap town, Alabama","250","707","33","278","01","38248"]
["Jacksonville city, Alabama","5341","11437","963","5124","01","38272"]
["Jasper city, Alabama","5223","13759","847","5186","01","38416"]
["Jemison city, Alabama","797","2589","145","902","01","38608"]
["Joppa CDP, Alabama","295","681","53","247","01","39064"]
["Kansas town, Alabama","23","96","5","53","01","39280"]
["Kellyton town, Alabama","41","126","6","46","01","39472"]
["Kennedy town, Alabama","128","383","27","162","01","39520"]
["Killen town, Alabama","424","1208","35","432","01","39784"]
["Kimberly city, Alabama","573","3773","17","1172","01","39856"]
["Kinsey town, Alabama","1106","2359","108","835","01","40072"]
["Kinston town, Alabama","538","776","43","256","01","40096"]
["Ladonia CDP, Alabama","1462","3657","284","1344","01","40648"]
["La Fayette city, Alabama","1118","2359","291","1015","01","40672"]
["Lakeview town, Alabama","70","137","11","43","01","40888"]
["Lake View town, Alabama","806","3357","92","1127","01","40928"]
["Lanett city, Alabama","3304","6688","525","2480","01","41296"]
["Langston town, Alabama","72","218","5","104","01","41368"]
["Leeds city, Alabama","3371","12337","414","4620","01","41968"]
["Leesburg town, Alabama","315","697","29","276","01","42016"]
["Leighton town, Alabama","358","687","123","306","01","42160"]
["Leroy CDP, Alabama","481","885","26","289","01","42304"]
["Lester town, Alabama","80","167","0","51","01","42352"]
["Level Plains town, Alabama","389","1826","102","742","01","42472"]
["Lexington town, Alabama","339","937","49","331","01","42640"]
["Libertyville town, Alabama","7","70","2","28","01","42808"]
["Lillian CDP, Alabama","1334","2114","43","610","01","42928"]
["Lincoln city, Alabama","2287","6836","303","2495","01","43120"]
["Linden city, Alabama","1049","1861","123","620","01","43240"]
["Lineville city, Alabama","1103","2495","241","1168","01","43264"]
["Lipscomb city, Alabama","1130","2089","190","790","01","43336"]
["Lisman town, Alabama","279","499","52","215","01","43384"]
["Littleville town, Alabama","333","873","54","345","01","43648"]
["Livingston city, Alabama","1611","2565","347","938","01","43720"]
["Loachapoka town, Alabama","93","207","0","87","01","43744"]
["Lockhart town, Alabama","143","264","12","117","01","43816"]
["Locust Fork town, Alabama","823","1532","72","583","01","43888"]
["Lookout Mountain CDP, Alabama","668","1377","67","477","01","44160"]
["Louisville town, Alabama","271","562","55","270","01","44344"]
["Lowndesboro town, Alabama","37","113","0","49","01","44536"]
["Loxley town, Alabama","1098","3566","135","1179","01","44608"]
["Luverne city, Alabama","823","2529","199","927","01","44728"]
["Lynn town, Alabama","340","811","57","362","01","44800"]
["McCalla CDP, Alabama","2142","13098","369","5151","01","45040"]
["McDonald Chapel CDP, Alabama","169","636","75","222","01","45208"]
["Macedonia CDP, Alabama","20","176","6","78","01","45316"]
["McIntosh town, Alabama","94","455","11","135","01","45472"]
["McKenzie town, Alabama","408","885","81","305","01","45496"]
["McMullen town, Alabama","15","16","3","16","01","45640"]
["Madison city, Alabama","6279","55258","877","21357","01","45784"]
["Madrid town, Alabama","117","269","5","99","01","45904"]
["Magnolia Springs town, Alabama","305","1432","0","474","01","46072"]
["Malcolm CDP, Alabama","38","88","0","36","01","46192"]
["Malvern town, Alabama","750","1711","51","618","01","46264"]
["Maplesville town, Alabama","255","673","59","236","01","46504"]
["Marbury CDP, Alabama","496","1893","88","558","01","46600"]
["Margaret town, Alabama","1242","5118","187","1627","01","46696"]
["Marion city, Alabama","1194","2469","139","794","01","46768"]
["Maytown town, Alabama","75","256","25","107","01","47728"]
["Meadowbrook CDP, Alabama","952","9503","112","3452","01","47740"]
["Megargel CDP, Alabama","0","0","0","0","01","47848"]
["Memphis town, Alabama","4","6","0","6","01","48052"]
["Mentone town, Alabama","131","340","5","168","01","48064"]
["Meridianville CDP, Alabama","1057","8344","114","3083","01","48112"]
["Midfield city, Alabama","1741","5219","459","1980","01","48376"]
["Midland City town, Alabama","981","1896","204","840","01","48400"]
["Midway town, Alabama","242","568","110","248","01","48424"]
["Mignon CDP, Alabama","495","833","91","287","01","48616"]
["Millbrook city, Alabama","5176","16617","622","6420","01","48712"]
["Millerville CDP, Alabama","239","376","0","94","01","48784"]
["Millport town, Alabama","382","1181","67","420","01","48808"]
["Millry town, Alabama","286","620","29","237","01","48832"]
["Minor CDP, Alabama","433","1052","40","355","01","49072"]
["Mobile city, Alabama","76176","182743","14644","77515","01","50000"]
["Monroeville city, Alabama","3133","5713","446","2326","01","50192"]
["Montevallo city, Alabama","2070","5579","242","2353","01","50312"]
["Montgomery city, Alabama","78610","193852","16250","78791","01","51000"]
["Moody city, Alabama","3220","13029","396","4988","01","51096"]
["Moores Mill CDP, Alabama","1057","5659","213","2295","01","51216"]
["Mooresville town, Alabama","11","83","0","32","01","51264"]
["Morris town, Alabama","397","2248","66","874","01","51456"]
["Morrison Crossroads CDP, Alabama","79","130","0","75","01","51469"]
["Mosses town, Alabama","554","818","142","295","01","51520"]
["Moulton city, Alabama","1014","3086","284","1436","01","51600"]
["Moundville town, Alabama","993","2714","95","860","01","51648"]
["Mountain Brook city, Alabama","1567","22080","0","8365","01","51696"]
["Mount Olive CDP (Coosa County), Alabama","110","214","24","86","01","52320"]
["Mount Olive CDP (Jefferson County), Alabama","683","4178","52","1485","01","52344"]
["Mount Vernon town, Alabama","778","1476","95","475","01","52608"]
["Movico CDP, Alabama","35","46","0","41","01","52680"]
["Mulga town, Alabama","341","682","79","313","01","52776"]
["Munford town, Alabama","774","1576","94","624","01","52848"]
["Muscle Shoals city, Alabama","3864","15719","453","6201","01","53016"]
["Myrtlewood town, Alabama","9","126","1","38","01","53112"]
["Nanafalia CDP, Alabama","0","54","0","27","01","53208"]
["Nances Creek CDP, Alabama","113","590","38","248","01","53232"]
["Napier Field town, Alabama","168","405","23","162","01","53256"]
["Natural Bridge town, Alabama","3","15","0","8","01","53376"]
["Nauvoo town, Alabama","124","185","17","74","01","53400"]
["Nectar town, Alabama","322","454","9","130","01","53448"]
["Needham town, Alabama","11","84","0","33","01","53472"]
["Newbern town, Alabama","146","275","23","84","01","53784"]
["New Brockton town, Alabama","374","1201","57","491","01","53856"]
["New Hope city, Alabama","655","2859","73","929","01","54168"]
["New Market CDP, Alabama","300","1006","42","465","01","54312"]
["New Site town, Alabama","329","830","45","338","01","54432"]
["Newton town, Alabama","766","1594","142","589","01","54480"]
["New Union CDP, Alabama","99","893","6","325","01","54582"]
["Newville town, Alabama","264","390","30","148","01","54600"]
["Nixburg CDP, Alabama","135","438","17","121","01","54696"]
["North Courtland town, Alabama","356","581","52","256","01","55044"]
["North Johns town, Alabama","31","160","7","74","01","55152"]
["Northport city, Alabama","8089","29511","1275","11392","01","55200"]
["Notasulga town, Alabama","437","1082","60","400","01","55440"]
["Oak Grove town, Alabama","394","1123","50","400","01","55752"]
["Oak Hill town, Alabama","7","24","5","16","01","55848"]
["Oakman town, Alabama","464","814","54","345","01","55992"]
["Odenville city, Alabama","1007","4800","184","1799","01","56400"]
["Ohatchee town, Alabama","346","1153","27","532","01","56472"]
["Oneonta city, Alabama","2348","6426","313","2922","01","57000"]
["Onycha town, Alabama","107","139","29","53","01","57024"]
["Opelika city, Alabama","13098","30353","1773","12155","01","57048"]
["Opp city, Alabama","2816","6607","356","2766","01","57120"]
["Orange Beach city, Alabama","1202","7835","132","3581","01","57144"]
["Orrville town, Alabama","79","139","24","77","01","57240"]
["Our Town CDP, Alabama","69","705","32","252","01","57384"]
["Owens Cross Roads town, Alabama","571","2409","36","938","01","57504"]
["Oxford city, Alabama","7621","21956","1160","7794","01","57576"]
["Ozark city, Alabama","6498","14104","1271","5830","01","57648"]
["Paint Rock town, Alabama","80","183","9","66","01","57696"]
["Panola CDP, Alabama","74","109","18","18","01","57912"]
["Parrish town, Alabama","811","1289","160","442","01","58272"]
["Pea Ridge CDP, Alabama","412","971","14","301","01","58680"]
["Pelham city, Alabama","3840","24058","263","9284","01","58848"]
["Pell City city, Alabama","4158","12746","482","5086","01","58896"]
["Pennington town, Alabama","343","604","64","230","01","58968"]
["Penton CDP, Alabama","77","77","0","46","01","59016"]
["Perdido CDP, Alabama","315","649","44","238","01","59064"]
["Perdido Beach town, Alabama","84","442","4","230","01","59088"]
["Peterman CDP, Alabama","11","35","0","19","01","59232"]
["Petrey town, Alabama","5","47","0","19","01","59328"]
["Phenix City city, Alabama","15144","37413","2936","15409","01","59472"]
["Phil Campbell town, Alabama","442","725","90","332","01","59496"]
["Pickensville town, Alabama","420","790","91","318","01","59592"]
["Piedmont city, Alabama","1731","4820","336","1828","01","59640"]
["Pike Road town, Alabama","1206","9149","127","3093","01","59760"]
["Pinckard town, Alabama","250","666","51","279","01","59832"]
["Pine Apple town, Alabama","53","168","0","82","01","59880"]
["Pine Hill town, Alabama","498","865","104","324","01","60240"]
["Pine Level CDP, Alabama","775","3955","41","1464","01","60264"]
["Pine Ridge town, Alabama","173","710","15","190","01","60372"]
["Pinson city, Alabama","1972","7227","251","2674","01","60648"]
["Pisgah town, Alabama","438","1133","51","341","01","60720"]
["Pleasant Grove city, Alabama","2092","9468","223","3398","01","61008"]
["Pleasant Groves town, Alabama","143","484","9","201","01","61038"]
["Point Clear CDP, Alabama","408","2043","12","892","01","61488"]
["Pollard town, Alabama","62","136","4","44","01","61536"]
["Powell town, Alabama","544","1029","38","285","01","62075"]
["Prattville city, Alabama","10436","37554","1335","14301","01","62328"]
["Priceville town, Alabama","355","3413","37","1065","01","62472"]
["Prichard city, Alabama","12958","19044","2334","6665","01","62496"]
["Providence town, Alabama","24","88","6","57","01","62688"]
["Putnam CDP, Alabama","14","21","0","12","01","62952"]
["Ragland town, Alabama","735","1784","207","633","01","63216"]
["Rainbow City city, Alabama","3199","10074","508","3798","01","63288"]
["Rainsville city, Alabama","2255","5439","385","2202","01","63336"]
["Ranburne town, Alabama","186","560","25","190","01","63408"]
["Ray CDP, Alabama","12","399","0","175","01","63495"]
["Red Bay city, Alabama","1653","3160","278","1388","01","63576"]
["Redland CDP, Alabama","630","5285","117","1849","01","63730"]
["Red Level town, Alabama","171","462","27","160","01","63768"]
["Redstone Arsenal CDP, Alabama","181","948","5","375","01","63912"]
["Reece City town, Alabama","277","744","22","254","01","63984"]
["Reeltown CDP, Alabama","260","339","86","141","01","64040"]
["Reform town, Alabama","940","1891","208","709","01","64104"]
["Rehobeth town, Alabama","467","1707","34","595","01","64152"]
["Remlap CDP, Alabama","787","2488","65","901","01","64248"]
["Repton town, Alabama","221","329","7","93","01","64368"]
["Ridgeville town, Alabama","32","80","6","38","01","64656"]
["River Falls town, Alabama","249","579","19","230","01","64776"]
["Riverside city, Alabama","844","2411","150","956","01","64920"]
["Riverview town, Alabama","158","198","7","54","01","65016"]
["Roanoke city, Alabama","2362","5198","523","2132","01","65040"]
["Robertsdale city, Alabama","1682","6462","382","2317","01","65208"]
["Rock Creek CDP, Alabama","568","1520","28","584","01","65412"]
["Rockford town, Alabama","509","902","90","261","01","65472"]
["Rock Mills CDP, Alabama","392","577","47","203","01","65592"]
["Rockville CDP, Alabama","0","0","0","0","01","65784"]
["Rogersville town, Alabama","411","1339","55","577","01","66216"]
["Rosa town, Alabama","399","820","10","358","01","66408"]
["Russellville city, Alabama","5144","10530","929","3400","01","67056"]
["Rutledge town, Alabama","372","473","35","162","01","67176"]
["St. Florian town, Alabama","124","510","40","249","01","67536"]
["St. Stephens CDP, Alabama","302","422","15","127","01","67584"]
["Saks CDP, Alabama","4254","10462","765","4041","01","67608"]
["Samson city, Alabama","930","1567","172","661","01","67800"]
["Sand Rock town, Alabama","215","798","12","265","01","67920"]
["Sanford town, Alabama","173","235","12","81","01","68016"]
["Saraland city, Alabama","4381","15888","389","6216","01","68160"]
["Sardis City town, Alabama","459","1818","41","652","01","68280"]
["Satsuma city, Alabama","1180","6657","194","2384","01","68352"]
["Scottsboro city, Alabama","6548","15038","883","6241","01","68736"]
["Section town, Alabama","419","953","42","344","01","69000"]
["Selma city, Alabama","10233","17935","2153","7239","01","69120"]
["Selmont-West Selmont CDP, Alabama","1205","1995","177","637","01","69180"]
["Semmes city, Alabama","1518","4969","145","2205","01","69240"]
["Sheffield city, Alabama","4383","9286","792","4202","01","69648"]
["Shelby CDP, Alabama","232","835","30","321","01","69672"]
["Shiloh town, Alabama","203","421","52","171","01","69840"]
["Shoal Creek CDP, Alabama","156","1308","0","508","01","69978"]
["Shorter town, Alabama","136","306","30","147","01","70128"]
["Silas town, Alabama","119","535","43","202","01","70416"]
["Silverhill town, Alabama","211","700","5","308","01","70536"]
["Sims Chapel CDP, Alabama","0","0","0","0","01","70632"]
["Sipsey town, Alabama","219","267","31","94","01","70704"]
["Skyline town, Alabama","590","1078","51","385","01","70896"]
["Slocomb city, Alabama","1058","1816","184","732","01","71040"]
["Smiths Station city, Alabama","2381","5400","263","1777","01","71190"]
["Smoke Rise CDP, Alabama","159","1657","61","444","01","71201"]
["Snead town, Alabama","474","1211","42","487","01","71280"]
["Somerville town, Alabama","325","616","70","257","01","71496"]
["Southside city, Alabama","2663","9101","6","2976","01","71832"]
["South Vinemont town, Alabama","315","440","43","179","01","71900"]
["Spanish Fort city, Alabama","1316","9686","90","3556","01","71976"]
["Spring Garden CDP, Alabama","87","169","20","81","01","72408"]
["Springville city, Alabama","572","4747","150","1951","01","72600"]
["Spruce Pine CDP, Alabama","22","81","0","63","01","72672"]
["Standing Rock CDP, Alabama","60","78","11","19","01","72720"]
["Stapleton CDP, Alabama","304","2527","0","660","01","72816"]
["Steele town, Alabama","667","1299","49","462","01","72888"]
["Sterrett CDP, Alabama","382","771","32","353","01","73056"]
["Stevenson city, Alabama","1110","2712","97","1007","01","73080"]
["Stewartville CDP, Alabama","508","1804","33","631","01","73152"]
["Stockton CDP, Alabama","49","371","0","143","01","73272"]
["Sulligent city, Alabama","851","1611","180","695","01","73728"]
["Sumiton city, Alabama","726","2618","120","1054","01","73848"]
["Summerdale town, Alabama","411","1463","40","534","01","73872"]
["Susan Moore town, Alabama","407","1254","57","406","01","74160"]
["Sweet Water town, Alabama","21","189","1","72","01","74304"]
["Sylacauga city, Alabama","5409","12280","962","5170","01","74352"]
["Sylvania town, Alabama","598","1848","162","691","01","74400"]
["Sylvan Springs town, Alabama","425","1611","35","543","01","74424"]
["Talladega city, Alabama","6803","13056","1318","5500","01","74592"]
["Talladega Springs town, Alabama","51","165","9","71","01","74616"]
["Tallassee city, Alabama","2106","5109","333","2179","01","74688"]
["Tarrant city, Alabama","3366","5974","730","2234","01","74976"]
["Taylor town, Alabama","1096","2525","97","930","01","75096"]
["Theodore CDP, Alabama","2649","5861","453","2142","01","75768"]
["Thomaston town, Alabama","148","464","59","185","01","75936"]
["Thomasville city, Alabama","1913","3584","295","1273","01","75960"]
["Thorsby town, Alabama","1030","2474","54","762","01","76080"]
["Tibbie CDP, Alabama","0","49","0","15","01","76200"]
["Tidmore Bend CDP, Alabama","392","1036","34","401","01","76208"]
["Tillmans Corner CDP, Alabama","8519","18150","1245","6669","01","76320"]
["Town Creek town, Alabama","481","1006","126","438","01","76584"]
["Toxey town, Alabama","98","150","32","95","01","76632"]
["Trafford town, Alabama","276","446","47","183","01","76680"]
["Triana town, Alabama","409","2784","49","989","01","76824"]
["Trinity town, Alabama","728","2498","76","844","01","76872"]
["Troy city, Alabama","7285","16019","817","6287","01","76920"]
["Trussville city, Alabama","3161","24917","158","8699","01","76944"]
["Tuscaloosa city, Alabama","38397","89882","4734","36763","01","77256"]
["Tuscumbia city, Alabama","3751","8737","642","3608","01","77280"]
["Tuskegee city, Alabama","3326","6898","803","3027","01","77304"]
["Twin town, Alabama","155","396","26","179","01","77352"]
["Underwood-Petersville CDP, Alabama","1164","2639","191","1318","01","77580"]
["Union town, Alabama","178","394","11","94","01","77616"]
["Union Grove town, Alabama","23","69","2","38","01","77784"]
["Union Springs city, Alabama","2658","3356","469","1140","01","77880"]
["Uniontown town, Alabama","1534","2045","375","756","01","77904"]
["Uriah CDP, Alabama","151","300","3","83","01","78120"]
["Valley city, Alabama","4552","10478","542","4011","01","78204"]
["Valley Grande city, Alabama","1096","4137","90","1475","01","78232"]
["Valley Head town, Alabama","565","833","120","296","01","78240"]
["Vance town, Alabama","436","1841","65","646","01","78264"]
["Vandiver CDP, Alabama","539","995","158","438","01","78312"]
["Vernon city, Alabama","1015","1870","307","841","01","78480"]
["Vestavia Hills city, Alabama","4915","38390","199","15066","01","78552"]
["Vina town, Alabama","363","514","35","143","01","78984"]
["Vincent town, Alabama","902","1807","85","698","01","79008"]
["Vinegar Bend CDP, Alabama","67","158","13","105","01","79032"]
["Vredenburgh town, Alabama","95","131","7","23","01","79272"]
["Wadley town, Alabama","414","573","55","244","01","79344"]
["Waldo town, Alabama","108","290","30","134","01","79488"]
["Walnut Grove town, Alabama","560","901","34","332","01","79728"]
["Warrior city, Alabama","929","3204","351","1361","01","79944"]
["Waterloo town, Alabama","63","118","7","60","01","80064"]
["Waverly town, Alabama","51","245","0","111","01","80256"]
["Weaver city, Alabama","804","3352","147","1120","01","80352"]
["Webb town, Alabama","499","1376","72","525","01","80376"]
["Wedowee town, Alabama","387","774","84","374","01","80496"]
["Weogufka CDP, Alabama","27","308","11","89","01","80736"]
["West Blocton town, Alabama","703","1361","105","434","01","80928"]
["West End-Cobb Town CDP, Alabama","1436","3065","278","1164","01","81084"]
["West Jefferson town, Alabama","187","547","27","245","01","81336"]
["Westover town, Alabama","481","1976","25","665","01","81504"]
["West Point town, Alabama","204","472","11","175","01","81528"]
["Wetumpka city, Alabama","1591","5887","442","2368","01","81720"]
["Whatley CDP, Alabama","149","315","89","143","01","81744"]
["White Hall town, Alabama","331","597","84","272","01","81912"]
["White Plains CDP, Alabama","156","646","0","248","01","82104"]
["Whitesboro CDP, Alabama","797","2150","70","696","01","82176"]
["Wilsonville town, Alabama","705","2158","160","786","01","82848"]
["Wilton town, Alabama","570","879","36","257","01","82872"]
["Winfield city, Alabama","1608","4702","181","1627","01","82992"]
["Woodland town, Alabama","56","542","8","152","01","83400"]
["Woodstock town, Alabama","524","1232","60","393","01","83640"]
["Woodville town, Alabama","507","1003","67","371","01","83664"]
["Yellow Bluff town, Alabama","130","175","46","75","01","83976"]
["York city, Alabama","1220","2201","203","993","01","84096"]

{"sheet":"State B tables","index":20,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3"]

{"sheet":"National B tables","index":21,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6","Column7"]

{"sheet":"National S tables","index":22,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6"]

{"sheet":"National DP tables","index":23,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3","Column4"]

{"sheet":"API_calls","index":24,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["State","State abbreviation","FIPS code",null,"API calls"]
["Alabama","AL","01",null,"Place B tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5?get=NAME,B01003_001E,B19080_001E,B25002_001E,B25002_002E,B25002_003E,B19013_001E&for=place:*&in=state:\"&INDEX($C$2:$C$58,MATCH('2. Demographic Data'!$C$11,$B$2:$B$59,0))","v":{"$error":"#N/A"}}]
["Alaska","AK","02",null,"Place B tables 5 years earlier",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12-5&\"/acs/acs5?get=NAME,B25002_002E&for=place:*&in=state:\"&INDEX($C$2:$C$58,MATCH('2. Demographic Data'!$C$11,$B$2:$B$59,0))","v":{"$error":"#N/A"}}]
["Arizona","AZ","04",null,"State B tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5?get=NAME,B19013_001E&for=state:*\"","v":"https://api.census.gov/data//acs/acs5?get=NAME,B19013_001E&for=state:*"}]
["Arkansas","AR","05",null,"Place DP tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5/profile?get=NAME,DP03_0051E,DP03_0062E,DP03_0009PE&for=place:*&in=state:\"&INDEX($C$2:$C$58,MATCH('2. Demographic Data'!$C$11,$B$2:$B$59,0))","v":{"$error":"#N/A"}}]
["California","CA","06",null,"Place S tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5/subject?get=NAME,S1701_C01_042E,S1701_C01_001E,S2201_C03_001E,S2201_C01_001E&for=place:*&in=state:\"&INDEX($C$2:$C$58,MATCH('2. Demographic Data'!$C$11,$B$2:$B$59,0))","v":{"$error":"#N/A"}}]
["Colorado","CO","08",null,"National B tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5?get=NAME,B01003_001E,B19080_001E,B25002_001E,B25002_003E,B19013_001E&for=us:*\"","v":"https://api.census.gov/data//acs/acs5?get=NAME,B01003_001E,B19080_001E,B25002_001E,B25002_003E,B19013_001E&for=us:*"}]
["Connecticut","CT","09",null,"National S tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5/subject?get=NAME,S1701_C01_042E,S1701_C01_001E,S2201_C03_001E,S2201_C01_001E&for=us:*\"","v":"https://api.census.gov/data//acs/acs5/subject?get=NAME,S1701_C01_042E,S1701_C01_001E,S2201_C03_001E,S2201_C01_001E&for=us:*"}]
["Delaware","DE","10",null,"National DP tables",{"$f":"\"https://api.census.gov/data/\"&'2. Demographic Data'!C12&\"/acs/acs5/profile?get=NAME,DP03_0009PE,DP03_0062E&for=us:*\"","v":"https://api.census.gov/data//acs/acs5/profile?get=NAME,DP03_0009PE,DP03_0062E&for=us:*"}]
["District of Columbia","DC","11"]
["Florida","FL","12"]
["Georgia","GA","13"]
["Hawaii","HI","15"]
["Idaho","ID","16"]
["Illinois","IL","17"]
["Indiana","IN","18"]
["Iowa","IA","19"]
["Kansas","KS","20"]
["Kentucky","KY","21"]
["Louisiana","LA","22"]
["Maine","ME","23"]
["Maryland","MD","24"]
["Massachusetts","MA","25"]
["Michigan","MI","26"]
["Minnesota","MN","27"]
["Mississippi","MS","28"]
["Missouri","MO","29"]
["Montana","MT","30"]
["Nebraska","NE","31"]
["Nevada","NV","32"]
["New Hampshire","NH","33"]
["New Jersey","NJ","34"]
["New Mexico","NM","35"]
["New York","NY","36"]
["North Carolina","NC","37"]
["North Dakota","ND","38"]
["Ohio","OH","39"]
["Oklahoma","OK","40"]
["Oregon","OR","41"]
["Pennsylvania","PA","42"]
["Rhode Island","RI","44"]
["South Carolina","SC","45"]
["South Dakota","SD","46"]
["Tennessee","TN","47"]
["Texas","TX","48"]
["Utah","UT","49"]
["Vermont","VT","50"]
["Virginia","VA","51"]
["Washington","WA","53"]
["West Virginia","WV","54"]
["Wisconsin","WI","55"]
["Wyoming","WY","56"]
["American Samoa","AS","60"]
["Guam","GU","66"]
["Northern Mariana Islands","MP","69"]
["Palau","PW","70"]
["Puerto Rico","PR","72"]
["U.S. Virgin Islands","VI","78"]