Category Archives: Public Use Microdata Areas

Analyzing ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Using the New Census 2010 PUMS Data

.. you can now create/use custom demographic estimates by Public Use Microdata Area (PUMA), state and the U.S. based on the Census 2010 Public Use Microdata Sample (PUMS) data.  The Census Bureau released the Census 2010 PUMS data this week (November 12, 2014). Use custom estimates to enhance knowledge about the demographic size and composition not otherwise possible. Learn more about your markets, clientele served and previously unknown opportunities.

The Census 2010 PUMS is a 10-percent sample, making the sampling rate 10 times larger that the American Community Survey 1-year PUMS data.  For example, there are 135,513 unweighted person records in the Census 2010 Hawaii PUMS and 14,286 unweighted person records in the ACS 2013 1-Year PUMS. As a result, many more detailed population and housing attributes can be estimated using the Census 2010 PUMS compared to ACS 1-year PUMS.  For example, using the Census 2010 PUMS, it is possible to develop usable estimates of the Native Hawaiian alone or in combination with other races population crossed by age and other attributes by PUMA … or the Asian Indian alone or in combination with other races population crossed by age and other attributes by PUMA.

Southern California Percent Asian Population by PUMA

Public Use Microdata Sample (PUMS) files provide a way to develop custom estimates of demographic summary statistics for PUMAs, states and the U.S. Both Census 2010 and American Community Survey (ACS) PUMS files are comprised of samples of individual respondent person and housing unit records. The ACS PUMS files are released annually providing a means to develop similar custom estimates with annual updates.

There are 2,378 2010 Public Use Microdata Areas (PUMAs) covering the U.S. wall-to-wall. PUMAs have a minimum of 100,000 population and where possible coterminous with a set of census tracts and county boundaries. As an example, there are 69 PUMAs that comprise Los Angeles County. See more about 2010 PUMAs.

See the related Web section Census 2010 PUMS.

Support Using these Resources
Learn more about demographic economic data and related analytical tools. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Easy Access to ACS 2013 Demographics

… 4 clicks away from a demographic profile for your selected area …  the American Community Survey (ACS) 2013 1 year estimates provide the most current demographic-economic data for wide-ranging geography having population 65,000 and over.  These geographies include the U.S., regions, divisions, states, counties, county subdivisions, cities/places, native american areas, metros, congressional districts, school districts, public use microdata areas, among others.

These data provide a unique and rich set of data resources for decision-making. They provides analysts and stakeholders with current information they need to plan investments and services. Retailers, homebuilders, police departments, school districts, and town/city planners are among the many private- and public-sector decision makers who count on these annual results.  These data can be made more powerful by integrating them with other data and visually/geospatially analyzing patterns with GIS and modeling tools.

Accessing the Data
The following steps illustrate how you can access data for areas of interest. We use the example of Scottsdale, AZ.
1 – view the table ACS2013.
2 – below the table, replace San Diego with Scottsdale.
3 – click the Find in Name button to the left of Scottsdale.
4 – table refreshes; click get data link in Scottsdale city row.

A new page displays with selected items retrieved:
Area name: Scottsdale city, Arizona
  Total population: 226,909
  One race alone: White: 200,920
  One race alone: Black: 5,017
  One race alone: AI/AN: 2,008
  One race alone: Asian: 9,298
  One race alone: NHOPI: 44
  Hispanic population: 24,961
  Total housing units: 129,434
  Occupied housing units/households: 99,860
  Median household income: $69,690
  Percent high school graduate: 96.7
  Percent college graduate: 54.2
  Median housing value: $382,300
  Median gross rent: $1,134

Optionally import the displayed data into a spreadsheet. Retrieve data for other areas of interest and easily compare attributes for multiple areas.

See details on the main web page —

Support Using these Resources
Learn more about accessing and using ACS data integrated with other data; examine characteristics and patterns for your study areas and applications. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Computer & Internet Usage Patterns

.. new data resources on computer and Internet usage .. mandated by the 2008 Broadband Data Improvement Act, questions on computer and Internet usage are included in the American Community Survey 2013 for the first time. Initially computer and Internet usage data will be available from the ACS 2013 1-year estimates (September 2014). These estimates are available for areas 65,000 population and over — the September 2014 data are tabulated for the U.S. and all states, metropolitan statistical areas (MSAs), Public Use Microdata Areas (PUMAs), and 113th Congressional Districts as well as large cities, counties and school districts. See related Web section for more detail.

Questions; Scope of Analytical Potential … scroll section
The ACS data are based on two questions on the ACS questionnaire:

The Federal Communications Commission (FCC) will use these data to measure the nationwide development of broadband access, as well as the successful deployment of the next generation of broadband technology. The data will also enable the FCC to develop measures to increase access to broadband technology and decrease barriers. The National Telecommunications and Information Administration (NTIA) will use the data to provide grants that help expand public access to broadband service and fund broadband education and support, particularly to groups that have traditionally underutilized broadband technology.

State and local governments can use the data to evaluate access to broadband in their communities, and institute policies and programs that increase access to areas with less connectivity.

Businesses, investors and other organizations can use the data to analyze computer and Internet usage in their markets and communities. Knowing how many people have access to computers and the Internet helps these groups communicate more effectively with their customers and plan outreach, infrastructure development, ecommerce and more. University researchers and other analysts have a wide range of new ways to examine the how, who and where of computer and Internet usage.

Summary Data Available
There are many new summary statistic tables based on the new questions.
B28001 .. Types of Computers in Household
B28002 .. Presence and Types of Internet Subscriptions in Household
B28003 .. Presence of a Computer and Type of Internet Subscription in Household
B28004 .. Household Income in the Last 12 Months by Presence and Type of Internet Subscription in Household
B28005 .. Age by Presence of a Computer and Types of Internet Subscription in Household
B28006 .. Educational Attainment by Presence of a Computer and Types of Internet Subscription in Household
B28007 .. Labor Force Status by Presence of a Computer and Types of Internet Subscription in Household
B28008 .. Presence of a Computer and Type of Internet Subscription in Household
B28009A-I .. Presence of a Computer and Type of Internet Subscription in Household (By Race and Hispanic Origin)

Related items are included in the Public Use Microdata Sample files and create many new possibilities to develop custom estimates of computer & Internet usage crossed by other population and housing attributes.

Related Data
The report Computer and Internet Use (May 2013) provides household and individual level analysis of computer usage and Internet use. The report is based on data collected in a July 2011 supplement to the Current Population Survey (CPS), which includes questions about computer ownership, Internet use both inside and outside the home, and the additional devices that people use to go online. The U.S. Census Bureau has asked questions in the CPS about computer use since 1984 and Internet use since 1997. The report provides limited scope state-level data and no sub-state data.

Support Using these Resources
Learn more about accessing and using ACS data integrated with other data; examine characteristics and patterns for your study areas and applications. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Decision-Making Information Web Sessions

Join us in an upcoming DMI Web Session … how to improve our ability to understand where we are … and where we are going? How can we use data to better understand patterns, where and how change will occur … and how change will impact us? Have we got the best data to answer the right questions?

The one hour informal sessions are focused on selected topics regarding development, integration and use of decision-making information.  Ask your questions about DMI tools, resources and their use … whether on the focus session or otherwise. There is no fee to participate.

Some of the most important data resources are developed/made accessible through stove-piped channels. Data are often difficult to access and integrate with other data. Media, form and format of publication differ widely. Changing technology, geography and subject matter universes over time create challenges to examine what the data are telling us. Methods, tools and resources are reviewed in the these sessions to make analytical endeavors and resulting insights more effective.

Upcoming Sessions
Using API Technology: Integrating Multi-sourced Data 3/18/14
Examining the School District Community & Infrastructure 3/25/14
State Legislative District & Congressional District Demographics 4/1/14
Metropolitan Area Characteristics & Trends 4/8/14
Developing Custom Estimates using ACS Public Use Microdata Samples 4/15/14
Situation & Outlook Quarterly Briefing 4/17/14
Using TIGER/Line Shapefiles; Visual Data Analysis 4/22/14
Census Block, Block Group & Census Tract Pattern Analysis 4/29/14

See additional details about each session.

Use the registration form to register for sessions. There is no fee. Check back for new/additional sessions.

Community Decision-Making Information

Community decision-making information, as used here, refers to the set of geographic, demographic and economic data that can be used with tools to assess community needs and develop agendas to advance the welfare of community residents and stakeholders. The geographic hub of the community is a city or place — a place of population concentration.

There are approximately 30,000 incorporated cities or census designated places in the U.S. (about cities/places). The focus here is on those incorporated cities, ones with “city limits” and boundaries and government powers designated by the corresponding state.

The concept of the city being a “hub” remains. Geographically, a community is often broader, sometimes narrower, that its defined corporate limits. The graphic shown below shows the combined Jefferson City, MO city, school district and county. The city boundaries differ from those of the school district, a typical scenario with wide ranging variations across the U.S. Typically, residents of the school district have a sense of community centric to the associated city.

Jefferson City, Missouri

Click graphic for larger view. Counties shown with bold gray boundary (white solid label). Cities appear with green fill pattern (white label). The primary school district is shown with bold blue boundary (yellow label); other school districts have lighter blue boundary. Schools appear as red markers.

Community Decision-Making Information
While the leadership, budget, authorizations and related items differ between the school district, city and county, they share the need for a common set of decision-making information. There is a common set of geographic, demographic, and economic data needed by each entity — and neighborhoods throughout the community.

To assess needs, examine change and plan for the future requires data for several types of geography in and around the community. Frequently updated and longitudinal demographic-economic data are needed for geographies including the city, school district(s), schools, county(s), census tracts, ZIP codes, block groups, census blocks, roads and topological structures. Attributes of broader geographic areas including metropolitan areas, Public Use Microdata Areas, state legislative districts and congressional districts are also essential.

These diverse subject matter for diverse geography can often be most effectively assembled and used in a Geographic Information System (GIS).  The view shown below illustrates use of GIS resources to view the location and attributes of low and moderate income neighborhoods.

Affordable Housing; Low & Moderate Income Neighborhoods
See related document for more information.

Organized Access to Key Data
The America’s Communities database and information system assembles selected key data for selected types of geography organized around individual communities. As an example, the Missouri Communities Program provides access to frequently Web-based data with ready-to-use GIS resources. These resources are made available to participating cities and counties at no fee. View the Jefferson City, MO community access Web section to examine the scope and content.

Using Community Decision-Making Information
Participants in the Missouri Community Program are automatically enrolled as members in the ProximityOne User Group — open to anyone at no fee. Join now. The combination of these resources provide a powerful base for community decision-making.

Join us in weekly decision-making information Web sessions where we cover selected data access and use topics as well as Q&A relating to use of the community-focused data profiles and resources.  View sessions  and sign-up here.

Analyzing Social Characteristics Patterns

How does educational attainment vary by congressional district? or by city/place, school district or a range of other geographies? Educational attainment is one of several social characteristics measures. This section reviews the scope of social characteristics measures and how you can access and use these data for different types of geographies. About the data.

Visual Analysis of Educational Attainment by Congressional District
The map presented below shows percent college graduates by congressional district (yellow labels) in the vicinity of Houston, Texas (counties bold black; county names shown as labels). The thematic pattern shows item S067 shown in the DP2 interactive table and further discussed below. Click graphic for larger view and details.

Social Characteristics Measures
A selection of primary social characteristics measures available for wide ranging geographies is shown in the following scroll section. In the scroll section, subject matter items are organized into to mini-tables with related items. The number at the left of the subject matter item is also used as the short name for the subject matter item in the column header in the interactive tables and further described below.

S001     Total households
S002 Family households (families)
S003         With own children under 18 years
S004     Married-couple family
S005         With own children under 18 years
S006     Male householder, no wife present, family
S007         With own children under 18 years
S008     Female householder, no husband present, family
S009         With own children under 18 years
S010 Nonfamily households
S011     Householder living alone
S012           65 years and over
S013   Households with one or more people under 18 years
S014   Households with one or more people 65 years and over
S015   Average household size
S016   Average family size
S017       Population in households
S018   Householder
S019   Spouse
S020   Child
S021   Other relatives
S022   Nonrelatives
S023       Unmarried partner
S024     Males 15 years and over
S025   Never married
S026   Now married, except separated
S027   Separated
S028   Widowed
S029   Divorced
S030     Females 15 years and over
S031   Never married
S032   Now married, except separated
S033   Separated
S034   Widowed
S035   Divorced
S036     Number of women 15 to 50 years old who had a birth in the past 12 months
S037 Unmarried women (widowed, divorced, and never married)
S038     Per 1,000 unmarried women
S039 Per 1,000 women 15 to 50 years old
S040     Per 1,000 women 15 to 19 years old
S041     Per 1,000 women 20 to 34 years old
S042     Per 1,000 women 35 to 50 years old
S043     Number of grandparents living with own grandchildren under 18 years
S044 Responsible for grandchildren
Years responsible for grandchildren
S045         Less than 1 year
S046         1 or 2 years
S047         3 or 4 years
S048         5 or more years
S049     Number of grandparents responsible for own grandchildren under 18 years
S050 Who are female
S051 Who are married
S052     Population 3 years and over enrolled in school
S053 Nursery school, preschool
S054 Kindergarten
S055 Elementary school (grades 1-8)
S056 High school (grades 9-12)
S057 College or graduate school
S058     Population 25 years and over
S059 Less than 9th grade
S060 9th to 12th grade, no diploma
S061 High school graduate (includes equivalency)
S062 Some college, no degree
S063 Associate’s degree
S064 Bachelor’s degree
S065 Graduate or professional degree
S066 Percent high school graduate or higher
S067 Percent bachelor’s degree or higher
S068     Civilian population 18 years and over
S069 Civilian veterans
S070     Total Civilian Noninstitutionalized Population
S071 With a disability
S072     Under 18 years
S073 With a disability
S074     18 to 64 years
S075 With a disability
S076     65 years and over
S077 With a disability
S078     Population 1 year and over
S079 Same house
S080 Different house in the U.S.
S081     Same county
S082     Different county
S083         Same state
S084         Different state
S085 Abroad
S086     Total population
S087 Native
S088     Born in United States
S089         State of residence
S090         Different state
S091     Born in Puerto Rico, U.S. Island areas, or born abroad to American parent(s)
S092 Foreign born
S093     Foreign-born population
S094 Naturalized U.S. citizen
S095 Not a U.S. citizen
S096     Population born outside the United States
S097     Native
S098 Entered 2010 or later
S099 Entered before 2010
S100     Foreign born
S101 Entered 2010 or later
S102 Entered before 2010
S103     Foreign-born population, excluding population born at sea
S104 Europe
S105 Asia
S106 Africa
S107 Oceania
S108 Latin America
S109 Northern America
S110     Population 5 years and over
S111 English only
S112 Language other than English
S113         Speak English less than “very well”
S114     Spanish
S115         Speak English less than “very well”
S116     Other Indo-European languages
S117         Speak English less than “very well”
S118     Asian and Pacific Islander languages
S119         Speak English less than “very well”
S120     Other languages
S121         Speak English less than “very well”
S122     Total population
S123 American
S124 Arab
S125 Czech
S126 Danish
S127 Dutch
S128 English
S129 French (except Basque)
S130 French Canadian
S131 German
S132 Greek
S133 Hungarian
S134 Irish
S135 Italian
S136 Lithuanian
S137 Norwegian
S138 Polish
S139 Portuguese
S140 Russian
S141 Scotch-Irish
S142 Scottish
S143 Slovak
S144 Subsaharan African
S145 Swedish
S146 Swiss
S147 Ukrainian
S148 Welsh
S149 West Indian (excluding Hispanic origin groups)

Social Characteristics Interactive Tables
The U.S. national scope interactive tables provide access to approximately 150 items, updated annually, for a range of geographic levels. Most of these tables include the the primary geography as well as related geography.
Estimates centric to 2012
• U.S.-States-Metros
• Congressional Districts
• Public Use Microdata Areas
Estimates centric to 2010
• U.S.-States-Metros-Counties
• Census Tracts
• ZIP Codes
• School Districts
• Cities/Places

Using the Interactive Tables
Use the interactive tables to view, query, rank, compare social characteristics of the population for these areas. The interactive tables listed above are structured and operate similarly. Items listed in the subject matter scroll box shown above are available for each area via the interactive table.

An example. This short tutorial illustrates use of the interactive tables to examine educational attainment patterns for the Atlanta, Georgia. See a summary of key usage notes below this example.
• Click on U.S.-States-Metros-Counties
• Each row is a summary for the U.S. or a state, metro or county.
• Educational attainment as measured by %high school graduates is item S066.
• Educational attainment as measured by %college graduates is item S067.
• Scroll right to view columns S066 and S067.
• Dbl-click S067 column header cell to rank in descending order.
• Click ShowAll button below table to reset start-up view.
• Examine educational attainment for a metro by county …
• Click the FindCBSA button below the table.
– only rows for the Atlanta metro and Atlanta metro counties appears.
• Click the ColSet1 button below the table.
– ColSet1: shows only AvgHHSize.AvgFamSize.%HSGrad.%CollGrad
– only selected columns appear (and include S066 and S067).
– you are able to examine the educational attainment for each area.
• Click the column header cell for column S067.
– the rows sort ascending on %college graduates.
– you are able to see how educational attainment ranks by area.
• Click the column header cell for column S067 again to sort in other directions.
• Click ShowAll button and repeat process for a different metro.

Related Usage Notes
• All items are estimates centric to mid-2010 or 2012 depending on the table.
• Click ShowAll button between Find/Queries.
• Use mouseover on column header to view column description.
• See ranking table below ranking table. See related ranking tables —
• Cells with -1 value could not be estimated.

About the Data
The American Community Survey (ACS) estimates and ProximityOne projections provide “richer” demographic-economic characteristics for national scope geography. Census 2010 provides data similar to those items in the General Demographics section. Only the ACS 2011 estimates, ACS 2012 estimates and ProximityOne projections provide details on topics such as income and poverty, labor force and employment, housing value and costs, educational participation and attainment, language spoken at home, among many related items. The approximate 600 items accessible via the dataset are supplemented by a wide range of additional subject matter.

Join the ProximityOne User Group to access extended data and more tools;
integrate your own data; use GIS tools to create your own map views.
(join now, no fee).