Category Archives: Public Use Microdata Areas

American Community Survey 2018: Geography & Access

.. there are 519 core-Based Statistical Areas (metros & micros) included as American Community Survey (ACS) 2018 tabulation areas. 2018 demographic-economic estimates are included for these and many other types of political/statistical areas — the subject of this section. This is the first in a series of posts about accessing, integrating and using the ACS 2018 data. Learn more about effective ways to use these and related data. See the main web section for more detail and access to the interactive table. The release date for the ACS 2018 data is September 26, 2019.

ACS 2018 1-year Tabulation Areas: 519 Core-Based Statistical Areas
— MSAs and MISAs

– view developed using ProximityOne CV XE GIS and related GIS project.
– geospatial analyze ACS 2018 1 year estimates integrated with your data to examine patterns; gain insights.

The 2018 American Community Survey (ACS 2018 main) is a nationwide survey designed to provide annually updated demographic-economic data for national and sub-national geography. ACS provides a wide range of important data about people and housing for every community across the nation. The results are used by everyone from planners to retailers to homebuilders and issue stakeholders like you. ACS is a primary source of local data for most of the 40 topics it covers, such as income, education, occupation, language and housing.

Determining What Data are Tabulated
The graphics below illustrate 1) the scroll section that lists the types of tabulation areas (summary levels) and 2) use of the interactive table to display a selection of CBSAs/metros (summary level 310).

ACS 2018 1-Year Summary Levels
The scroll section (see in web page) shows the summary level code (left column), part or component if applicable and summary level name.

ACS 2018 1-Year Estimates — Areas Published — Interactive Table
The interactive table (click link to view actual interactive table) enables you to list the geographic areas tabulated. This graphic shows CBSAs (MSAs and MISAs) tabulated. GeoID1 shows the unique tabulation area geocode for an area among all areas. GeoID1 inlcudes the summary level (first 3 characters), followed by state FIPS code where applicable, ‘US’ and finally the geocode for the specific area.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics 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.

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 — http://proximityone.com/acs2013.htm.

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:

Applications
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.

Registration
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.
http://

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.