analyze the american community survey (acs) with r and monetdb experimental. think of the american community survey (acs) as the united states' census for off-years - the ones that don't end in zero. every year, one percent of all americans respond, making it the largest complex sample administered by the u.s. government (the decennial census has a much broader reach, but since it attempts to contact 100% of the population, it's not a sur vey). the acs asks how people live and although the questionnaire only includes about three hundred questions on demography, income, insurance, it's often accurate at sub-state geographies and - depending how many years pooled - down to small counties. households are the sampling unit, and once a household gets selected for inclusion, all of its residents respond to the survey. this allows household-level data (like home ownership) to be collected more efficiently and lets researchers examine family structure. the census bureau runs and finances this behemoth, of course. the dow nloadable american community survey ships as two distinct household-level and person-level comma-separated value (.csv) files. merging the two just rectangulates the data, since each person in the person-file has exactly one matching record in the household-file. for analyses of small, smaller, and microscopic geographic areas, choose one-, three-, or fiv e-year pooled files. use as few pooled years as you can, unless you like sentences that start with, "over the period of 2006 - 2010, the average american ... [insert yer findings here]." rather than processing the acs public use microdata sample line-by-line, the r language brazenly reads everything into memory by default. to prevent overloading your computer, dr. thomas lumley wrote the sqlsurvey package principally to deal with t his ram-gobbling monster. if you're already familiar with syntax used for the survey package, be patient and read the sqlsurvey examples carefully when something doesn't behave as you expect it to - some sqlsurvey commands require a different structure (i.e. svyby gets called through svymean) and others might not exist anytime soon (like svyolr). gimme some good news: sqlsurvey uses ultra-fast monetdb (click here for speed tests), so follow the monetdb installation instructions before running this acs code. monetdb imports, writes, recodes data slowly, but reads it hyper-fast . a magnificent trade-off: data exploration typically requires you to think, send an analysis command, think some more, send another query, repeat. importation scripts (especially the ones i've already written for you) can be left running overnight sans hand-holding. the acs weights generalize to the whole united states population including individuals living in group quarters, but non-residential respondents get an abridged questionnaire, so most (not all) analysts exclude records with a relp variable of 16 or 17 right off the bat. this new github repository contains four scripts: 2005-2011 - download all microdata.R create the batch (.bat) file needed to initiate the monet database in the future download, unzip, and import each file for every year and size specified by the user create and save household- and merged/person-level replicate weight complex sample designs create a well-documented block of code to re-initiate the monet db server in the future fair warning: this full script takes a loooong time. run it friday afternoon, commune with nature for the weekend, and if you've got a fast processor and speedy internet connection, monday morning it should be ready for action. otherwise, either download only the years and sizes you need or - if you gotta have 'em all - run it, minimize it, and then don't disturb it for a week. 2011 single-year - analysis e xamples.R run the well-documented block of code to re-initiate the monetdb server load the r data file (.rda) containing the replicate weight designs for the single-year 2011 file perform the standard repertoire of analysis examples, only this time using sqlsurvey functions 2011 single-year - variable reco de example.R run the well-documented block of code to re-initiate the monetdb server copy the single-year 2011 table to maintain the pristine original add a new age category variable by hand add a new age category variable systematically re-create then save the sqlsurvey replicate weight complex sample design on this new table close everything, then load everything back up in a fresh instance of r replicate a few of the census statistics. no muss, no fuss replicate census estimates - 2011.R run the well-documented block of code to re-initiate the monetdb server load the r data file (.rda) containing the replicate weight designs for the single-year 2011 file match every nation wide statistic on the census bureau's estimates page, using sqlsurvey functions click here to view these four scripts for more detail about the american community survey (acs), visit: < ul> the us census...

The Decennial Census provides population estimates and demographic information on residents of the United States.

The Census Summary Files contain detailed tables on responses to the decennial census. Data tables in Summary File 1 provide information on population and housing characteristics, including cross-tabulations of age, sex, households, families, relationship to householder, housing units, detailed race and Hispanic or Latino origin groups, and group quarters for the total population. Summary File 2 contains data tables on population and housing characteristics as reported by housing unit.

Researchers at NYU Langone Health can find guidance for the use and analysis of Census Bureau data on the Population Health Data Hub (listed under "Other Resources"), which is accessible only through the intranet portal with a valid Kerberos ID (KID).

The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, as well as many new variables that were derived after the fact from multiple survey responses (such as poverty status).Each record in the file represents a single person, or, in the household-level dataset, a single housing unit. In the person-level file, individuals are organized into households, making possible the study of people within the contexts of their families and other household members. Individuals living in Group Quarters, such as nursing facilities or college facilities, are also included on the person file. ACS PUMS data are available at the nation, state, and Public Use Microdata Area (PUMA) levels. PUMAs are special non-overlapping areas that partition each state into contiguous geographic units containing roughly 100,000 people each. ACS PUMS files for an individual year, such as 2019, contain data on approximately one percent of the United States population.

Decennial Census: 2020 Decennial Self-Response Rates Data sourced from the 2020 Census Response Rates API and filtered for tract level data for Travis, Bastrop, Caldwell, Hays, and Williamson Counties. Source API Documentation: https://api.census.gov/data/2020/dec/responserate.html More info about data columns: https://api.census.gov/data/2020/dec/responserate/variables.html

Analysis of ‘Census 2020 Response Rates’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/de9e1d7d-e769-4184-b185-3c186f791007 on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Decennial Census: 2020 Decennial Self-Response Rates

Data sourced from the 2020 Census Response Rates API and filtered for tract level data for Travis, Bastrop, Caldwell, Hays, and Williamson Counties.

Source API Documentation: https://api.census.gov/data/2020/dec/responserate.html

More info about data columns: https://api.census.gov/data/2020/dec/responserate/variables.html

--- Original source retains full ownership of the source dataset ---

Daily Decennial Self-Response Rates

Tempe Census Census Tracts and internet access by household. Data source: U.S. Census Bureau, 2013-2017 American Community Survey 5-Year Estimates, table BD28011 (Internet Subscription in Household). Also includes "low response scores" from the the Census Bureau's data from the 2018 Planning Database (PDB), which was established to prepare for the upcoming 2020 Census.For more information on the low response score, see the United States Census Bureau 2018 Planning Database:https://www.census.gov/topics/research/guidance/planning-databases.htmlLayer generally supports 2020 Census story map Ensuring a Complete Count in the 2020 Census.

This layer shows demographic context for emergency response efforts. This is shown by tract, county, and state centroids. This service is updated annually to contain the most currently released American Community Survey (ACS) 5-year data, and contains estimates and margins of error. There are also additional calculated attributes related to this topic, which can be mapped or used within analysis.

DO NOT DELETE OR MODIFY THIS ITEM. This item is managed by the ArcGIS Hub application. To make changes to this site, please visit https://hub.arcgis.com/admin/

Data pulled from the US Census Bureau for response rates by City/Place for the US decennial 2020 census.

Household Pulse Survey (HPS): HPS is a rapid-response survey of adults ages ≥18 years led by the U.S. Census Bureau, in partnership with seven other federal statistical agencies, to measure household experiences during the COVID-19 pandemic. Detailed information on probability sampling using the U.S. Census Bureau’s Master Address File, questionnaires, response rates, and bias assessment is available on the Census Bureau website (https://www.census.gov/data/experimental-data-products/household-pulse-survey.html).

Data from adults age ≥18 years are collected by 20-minute online survey from randomly sampled households stratified by state and the top 15 metropolitan statistical areas (MSAs). Data are weighted to represent total persons age 18 and older living within households and to mitigate possible bias that can result from non-responses and incomplete survey frame. Data from adults age ≥18 years are collected by 20-minute online survey from randomly sampled households stratified by state and the top 15 metropolitan statistical areas (MSAs). For more information on this survey, see https://www.census.gov/programs-surveys/household-pulse-survey.html.

Data are weighted to represent total persons age 18 and older living within households and to mitigate possible bias that can result from non-responses and incomplete survey frame. Responses in the Household Pulse Survey (https://www.census.gov/programs-surveys/household-pulse-survey.html) are self-reported. Estimates of vaccination coverage may differ from vaccine administration data reported at COVID-19 Vaccinations in the United States (https://covid.cdc.gov/covid-data-tracker/#vaccinations).

Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of housing units for states and counties..Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Technical Documentation section.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2021 American Community Survey 1-Year Estimates.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..Employment and unemployment estimates may vary from the official labor force data released by the Bureau of Labor Statistics because of differences in survey design and data collection. For guidance on differences in employment and unemployment estimates from different sources go to Labor Force Guidance..Workers include members of the Armed Forces and civilians who were at work last week..Industry titles and their 4-digit codes are based on the 2017 North American Industry Classification System. The Industry categories adhere to the guidelines issued in Clarification Memorandum No. 2, "NAICS Alternate Aggregation Structure for Use By U.S. Statistical Agencies," issued by the Office of Management and Budget..Occupation titles and their 4-digit codes are based on the 2018 Standard Occupational Classification..Logical coverage edits applying a rules-based assignment of Medicaid, Medicare and military health coverage were added as of 2009 -- please see https://www.census.gov/library/working-papers/2010/demo/coverage_edits_final.html for more details. Select geographies of 2008 data comparable to the 2009 and later tables are available at https://www.census.gov/data/tables/time-series/acs/1-year-re-run-health-insurance.html. The health insurance coverage category names were modified in 2010. See https://www.census.gov/topics/health/health-insurance/about/glossary.html#par_textimage_18 for a list of the insurance type definitions..Beginning in 2017, selected variable categories were updated, including age-categories, income-to-poverty ratio (IPR) categories, and the age universe for certain employment and education variables. See user note entitled "Health Insurance Table Updates" for further details..The categories for relationship to householder were revised in 2019. For more information see Revisions to the Relationship to Household item..In 2019, methodological changes were made to the class of worker question. These changes involved modifications to the question wording, the category wording, and the visual format of the categories on the questionnaire. The format for the class of worker categories are now listed under the headings "Private Sector Employee," "Government Employee," and "Self-Employed or Other." Additionally, the category of Active Duty was added as one of the response categories under the "Government Employee" section for the mail questionnaire. For more detailed information about the 2019 changes, see the 2016 American Community Survey Content Test Report for Class of Worker located at http://www.census.gov/library/working-papers/2017/acs/2017_Martinez_01.html..Beginning in data year 2019, respondents to the Weeks Worked question provided an integer value for the number of weeks worked. For data years 2008 through 2018, respondents selected a category corresponding to the number of weeks worked..The 2021 American Community Survey (ACS) data generally reflect the March 2020 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas. In certain instances the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineations due to differences in the effective dates of the geographic entities..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on Census 2010 data. As a result, data for urban and rural areas from the ACS...

The Community Resilience Estimates (CRE) program provides an easily understood metric for how socially vulnerable every neighborhood in the United States is to the impacts of disasters.This ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. Please cite the Census, CRE, and ACS when using this data.Overview:Community resilience is the capacity of individuals and households within a community to prepare, absorb, respond, and recover from a disaster. Local planners, policy makers, public health officials, emergency managers, and community stakeholders need a variety of estimates to help assess the potential resiliency and vulnerabilities of communities and their constituent populations to help prepare and plan mitigation, recovery, and response strategies. Community Resilience Estimates (CRE) focuses on developing a tool to identify socio-economic vulnerabilities within populations. The 2022 Community Resilience Estimates (CRE) are produced using information on individuals and households from the 2022 American Community Survey (ACS) and the Census Bureau’s Population Estimates Program (PEP). The CRE uses small area modeling techniques that can be used for a broad range of disaster related events (hurricanes, tornadoes, floods, economic shocks, etc.) to identify population concentrations likely to be relatively more impacted by and have greater difficulties overcoming disasters. The end result is a data product which measures vulnerability more accurately and timely.Data:The ACS is a nationally representative survey with data on the characteristics of the U.S. population. The sample is selected from all counties and county-equivalents and has a sample size of about 3.5 million housing units each year. It is the premier source for timely and detailed population and housing information about our nation and its communities. We also use auxiliary data from the PEP, the Census Bureau’s program that produces and publishes estimates of the population living at a given time within a geographic entity in the U.S. and Puerto Rico. We use population data from the PEP by age group, race and ethnicity, and sex. Since the PEP does not go down to the census tract level, the CRE uses the Public Law 94-171 summary files (PL94) and Demographic Housing Characteristics File (DHC) tables from the 2020 Decennial Census to help produce the population base estimates. Once the weighted estimates are tabulated, small area modeling techniques are used to create the estimates for the CRE. Components of Social Vulnerability (SV): Resilience to a disaster is partly determined by the components of social vulnerability exhibited within a community’s population. To measure these components and construct the community resilience estimates, we designed population estimates based on individual- and household-level components of social vulnerability. These components are binary indicators or variables that add up to a maximum of 10 possible components using data from the ACS. The specific ACS-defined measures we use are as follows: Components of Social Vulnerability (SV) for Households (HH) and Individuals (I):SV 1: Income-to-Poverty Ratio (IPR) < 130 percent (HH). SV 2: Single or zero caregiver household - only one or no individuals living in the household who are 18-64 (HH). SV 3: Unit-level crowding with >= 0.75 persons per room (HH). SV 4: Communication barrier defined as either: Limited English-speaking households1 (HH) orNo one in the household over the age of 16 with a high school diploma (HH). SV 5: No one in the household is employed full-time, year-round. The flag is not applied if all residents of the household are aged 65 years or older (HH). SV 6: Disability posing constraint to significant life activity. Persons who report having any one of the six disability types (I): hearing difficulty, vision difficulty, cognitive difficulty, ambulatory difficulty, self-care difficulty, and independent living difficulty. SV 7: No health insurance coverage (I). SV 8: Being aged 65 years or older (I). SV 9: No vehicle access (HH). SV 10: Households without broadband internet access (HH). Each individual is assigned a 0 or 1 for each of the components based upon their individual or household attributes listed above. It is important to note that SV 4 is not double flagged. An individual will be assigned a 1, if either of the characteristics is true for their household. For example, if a household is linguistically isolated and no one over the age of 16 has attained a high school diploma or more education, the household members are only flagged once. The result is an index that produces aggregate-level (tract, county, and state) small area estimates: the CRE. The CRE provide an estimate for the number of people with a specific number of social vulnerabilities. In its current data file layout form, the estimates are categorized into three groups: zero , one-two, or three plus social vulnerability components. Differences with CRE 2021:The number of census tracts have increased from 84,414 in CRE 2021 to 84,415 in CRE 2022. This is due to the boundary changes in Connecticut implemented in 2022 census data products. To accommodate the boundary change, Connecticut also now has nine planning regions instead of eight counties in CRE 2022.To avoid confusion, the modeled rates are now set to equal zero in CRE 2022 for geographic areas with zero population in universe. To improve the population base estimates, CRE 2022 uses more detailed decennial estimates from the 2020 DHC in addition to PL94, whereas CRE 2021 just used PL94 due to availability at the time. See “2022 Community Resilience Estimates: Detailed Technical Documentation” for more information. Data Processing Notes:Boundaries come from the Cartographic Boundaries via US Census TIGER geodatabases. Boundaries are updated at the same time as the data updates, and the boundary vintage appropriately matches the data vintage as specified by the Census. These are Census boundaries with water and/or coastlines clipped for cartographic purposes. For state and county boundaries, the water and coastlines are derived from the coastlines of the 500k TIGER Cartographic Boundary Shapefiles. The original AWATER and ALAND fields are still available as attributes within the data table (units are square meters). This dataset does not contain values for Puerto Rico or Island Areas at any level of geography.Further Information:Community Resilience Estimates Program Website https://www.census.gov/programs-surveys/community-resilience-estimates.htmlCommunity Resilience Estimates Technical Documentation https://census.gov/programs-surveys/community-resilience-estimates/technical-documentation.htmlFor Data Questionssehsd.cre@census.gov

More than 39 million people and 14.2 million households span more than 163,000 square miles of Californian’s urban, suburban and rural communities. California has the fifth largest economy in the world and is the most populous state in the nation, with nation-leading diversity in race, ethnicity, language and socioeconomic conditions. These characteristics make California amazingly unique amongst all 50 states, but also present significant challenges to counting every person and every household, no matter the census year. A complete and accurate count of a state’s population in a decennial census is essential. The results of the 2020 Census will inform decisions about allocating hundreds of billions of dollars in federal funding to communities across the country for hospitals, fire departments, school lunch programs and other critical programs and services. The data collected by the United States Census Bureau (referred hereafter as U.S. Census Bureau) also determines the number of seats each state has in the U.S. House of Representatives and will be used to redraw State Assembly and Senate boundaries. California launched a comprehensive Complete Count Census 2020 Campaign (referred to hereafter as the Campaign) to support an accurate and complete count of Californians in the 2020 Census. Due to the state’s unique diversity and with insights from past censuses, the Campaign placed special emphasis on the hardest-tocount Californians and those least likely to participate in the census. The California Complete Count – Census 2020 Office (referred to hereafter as the Census Office) coordinated the State’s operations to complement work done nationally by the U.S. Census Bureau to reach those households most likely to be missed because of barriers, operational or motivational, preventing people from filling out the census. The Campaign, which began in 2017, included key phases, titled Educate, Motivate and Activate. Each of these phases were designed to make sure all Californians knew about the census, how to respond, their information was safe and their participation would help their communities for the next 10 years.

The Economic Census is the U.S. Government's official five-year measure of American business and the economy. It is conducted by the U.S. Census Bureau, and response is required by law. In October through December of the census year, forms are sent out to nearly 4 million businesses, including large, medium and small companies representing all U.S. locations and industries. Respondents were asked to provide a range of operational and performance data for their companies. This dataset presents company, establishments, value of shipments, value of product shipments, percentage of product shipments of the total value of shipments, and percentage of distribution of value of product shipments.

Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, the decennial census is the official source of population totals for April 1st of each decennial year. In between censuses, the Census Bureau's Population Estimates Program produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of housing units for states and counties..Information about the American Community Survey (ACS) can be found on the ACS website. Supporting documentation including code lists, subject definitions, data accuracy, and statistical testing, and a full list of ACS tables and table shells (without estimates) can be found on the Technical Documentation section of the ACS website.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2018-2022 American Community Survey 5-Year Estimates.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..Foreign born excludes people born outside the United States to a parent who is a U.S. citizen..Workers include members of the Armed Forces and civilians who were at work last week..Industry titles and their 4-digit codes are based on the 2017 North American Industry Classification System. The Industry categories adhere to the guidelines issued in Clarification Memorandum No. 2, "NAICS Alternate Aggregation Structure for Use By U.S. Statistical Agencies," issued by the Office of Management and Budget..Occupation titles and their 4-digit codes are based on the 2018 Standard Occupational Classification..When information is missing or inconsistent, the Census Bureau logically assigns an acceptable value using the response to a related question or questions. If a logical assignment is not possible, data are filled using a statistical process called allocation, which uses a similar individual or household to provide a donor value. The "Allocated" section is the number of respondents who received an allocated value for a particular subject..Several means of transportation to work categories were updated in 2019. For more information, see: Change to Means of Transportation..In 2019, methodological changes were made to the class of worker question. These changes involved modifications to the question wording, the category wording, and the visual format of the categories on the questionnaire. The format for the class of worker categories are now listed under the headings "Private Sector Employee," "Government Employee," and "Self-Employed or Other." Additionally, the category of Active Duty was added as one of the response categories under the "Government Employee" section for the mail questionnaire. For more detailed information about the 2019 changes, see the 2016 American Community Survey Content Test Report for Class of Worker located at http://www.census.gov/library/working-papers/2017/acs/2017_Martinez_01.html..The 2018-2022 American Community Survey (ACS) data generally reflect the March 2020 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas. In certain instances, the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineation lists due to differences in the effective dates of the geographic entities..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on 2020 Census data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Explanation of Symbols:- The estimate could not be computed because there were an insufficient number of sample observations. For a ratio of medians estimate, one or both of the median estimates falls in the lowest interval or highest interval of an open-ended distribution. For a 5-year median estimate, the margin of error associated with a median was larger than the median itself.N The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area. (X) The estimate or margin of error is not applicable or no...

Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, for 2020, the 2020 Census provides the official counts of the population and housing units for the nation, states, counties, cities, and towns. For 2016 to 2019, the Population Estimates Program provides estimates of the population for the nation, states, counties, cities, and towns and intercensal housing unit estimates for the nation, states, and counties..Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Technical Documentation section.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..Data about computer and Internet use were collected by asking respondents to select "Yes" or "No" to each type of computer and each type of Internet subscription. Therefore, respondents were able to select more than one type of computer and more than one type of Internet subscription..In 2016, changes were made to the computer and Internet use questions, involving the wording as well as the response options. A crosswalk was used to map pre-2016 data to the post-2016 categories, enabling creation of 5-year data. For more detailed information about the 2016 changes, see the 2016 American Community Survey Content Test Report for Computer and Internet Use located at https://www.census.gov/library/working-papers/2017/acs/2017_Lewis_01.html or the user note regarding changes in the 2016 questions located at https://www.census.gov/programs-surveys/acs/technical-documentation/user-notes/2017-03.html. For more detailed information about the crosswalk, see the user note regarding the crosswalk located at https://www.census.gov/programs-surveys/acs/technical-documentation/user-notes.html..When information is missing or inconsistent, the Census Bureau logically assigns an acceptable value using the response to a related question or questions. If a logical assignment is not possible, data are filled using a statistical process called allocation, which uses a similar individual or household to provide a donor value. The "Allocated" section is the number of respondents who received an allocated value for a particular subject..The 2016-2020 American Community Survey (ACS) data generally reflect the September 2018 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas. In certain instances, the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineation lists due to differences in the effective dates of the geographic entities..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on Census 2010 data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Explanation of Symbols:- The estimate could not be computed because there were an insufficient number of sample observations. For a ratio of medians estimate, one or both of the median estimates falls in the lowest interval or highest interval of an open-ended distribution.N The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area. (X) The estimate or margin of error is not applicable or not available.median- The median falls in the lowest interval of an open-ended distribution (for example "2,500-")median+ The median falls in the highest interval of an open-ended distribution (for example "250,000+").** The margin of error could not be computed because there were an insufficient number of sample observations.*** The margin of error could not be computed because the median falls in the lowest interval or highest interval of an open-ended distribution.***** A margin of error is not appropriate because the corresponding estimate is controlled to an independent population or housing estimate. Effectively, the correspon...

Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, the decennial census is the official source of population totals for April 1st of each decennial year. In between censuses, the Census Bureau's Population Estimates Program produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of housing units for states and counties..Information about the American Community Survey (ACS) can be found on the ACS website. Supporting documentation including code lists, subject definitions, data accuracy, and statistical testing, and a full list of ACS tables and table shells (without estimates) can be found on the Technical Documentation section of the ACS website.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2018-2022 American Community Survey 5-Year Estimates.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..The age dependency ratio is derived by dividing the combined under-18 and 65-and-over populations by the 18-to-64 population and multiplying by 100..The old-age dependency ratio is derived by dividing the population 65 and over by the 18-to-64 population and multiplying by 100..The child dependency ratio is derived by dividing the population under 18 by the 18-to-64 population and multiplying by 100..When information is missing or inconsistent, the Census Bureau logically assigns an acceptable value using the response to a related question or questions. If a logical assignment is not possible, data are filled using a statistical process called allocation, which uses a similar individual or household to provide a donor value. The "Allocated" section is the number of respondents who received an allocated value for a particular subject..The 2018-2022 American Community Survey (ACS) data generally reflect the March 2020 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas. In certain instances, the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineation lists due to differences in the effective dates of the geographic entities..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on 2020 Census data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Explanation of Symbols:- The estimate could not be computed because there were an insufficient number of sample observations. For a ratio of medians estimate, one or both of the median estimates falls in the lowest interval or highest interval of an open-ended distribution. For a 5-year median estimate, the margin of error associated with a median was larger than the median itself.N The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area. (X) The estimate or margin of error is not applicable or not available.median- The median falls in the lowest interval of an open-ended distribution (for example "2,500-")median+ The median falls in the highest interval of an open-ended distribution (for example "250,000+").** The margin of error could not be computed because there were an insufficient number of sample observations.*** The margin of error could not be computed because the median falls in the lowest interval or highest interval of an open-ended distribution.***** A margin of error is not appropriate because the corresponding estimate is controlled to an independent population or housing estimate. Effectively, the corresponding estimate has no sampling error and the margin of error may be treated as zero.

Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, the decennial census is the official source of population totals for April 1st of each decennial year. In between censuses, the Census Bureau's Population Estimates Program produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of housing units and the group quarters population for states and counties..Information about the American Community Survey (ACS) can be found on the ACS website. Supporting documentation including code lists, subject definitions, data accuracy, and statistical testing, and a full list of ACS tables and table shells (without estimates) can be found on the Technical Documentation section of the ACS website.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2019-2023 American Community Survey 5-Year Estimates.ACS data generally reflect the geographic boundaries of legal and statistical areas as of January 1 of the estimate year. For more information, see Geography Boundaries by Year..Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..Users must consider potential differences in geographic boundaries, questionnaire content or coding, or other methodological issues when comparing ACS data from different years. Statistically significant differences shown in ACS Comparison Profiles, or in data users' own analysis, may be the result of these differences and thus might not necessarily reflect changes to the social, economic, housing, or demographic characteristics being compared. For more information, see Comparing ACS Data..Foreign born excludes people born outside the United States to a parent who is a U.S. citizen..Workers include members of the Armed Forces and civilians who were at work last week..Occupation titles and their 4-digit codes are based on the 2018 Standard Occupational Classification..Industry titles and their 4-digit codes are based on the North American Industry Classification System (NAICS). The Census industry codes for 2023 and later years are based on the 2022 revision of the NAICS. To allow for the creation of multiyear tables, industry data in the multiyear files (prior to data year 2023) were recoded to the 2022 Census industry codes. We recommend using caution when comparing data coded using 2022 Census industry codes with data coded using Census industry codes prior to data year 2023. For more information on the Census industry code changes, please visit our website at https://www.census.gov/topics/employment/industry-occupation/guidance/code-lists.html..When information is missing or inconsistent, the Census Bureau logically assigns an acceptable value using the response to a related question or questions. If a logical assignment is not possible, data are filled using a statistical process called allocation, which uses a similar individual or household to provide a donor value. The "Allocated" section is the number of respondents who received an allocated value for a particular subject..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on 2020 Census data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Explanation of Symbols:- The estimate could not be computed because there were an insufficient number of sample observations. For a ratio of medians estimate, one or both of the median estimates falls in the lowest interval or highest interval of an open-ended distribution. For a 5-year median estimate, the margin of error associated with a median was larger than the median itself.N The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area. (X) The estimate or margin of error is not applicable or not available.median- The median falls in the lowest interval of an open-ended distribution (for example "2,500-")median+ The median falls in the highest interval of an open-ended distribution (for example "250,000...

The data is extracted from the census web site (https://www.census.gov/) using their API. This is then joined to 2019 U.S. census places, also obtained from the census site. This results in a spatial feature that is suitable for mapping the various methods of census response. The data is updated daily from the census.