Measuring & Analyzing Households by Social Class by PUMA

.. a social class is a population or household group typically referred to as a lower, middle and upper class. The size of the population or households in a social class is often determined in relationship to an interval related to the median household income of an area — from two-thirds of median household income to twice the median household income (MHI). Subsequent blog posts will address a broader definition for class determination. By better understanding composition and determinants of social class for an area, we might better understand and improve on income inequality and create new opportunities. This is a multi-part blog post on social class analytics. Click Follow at right to receive updates.

Percent Population in Households by Social Class by PUMA
.. Los Angeles area .. click for larger view.

Los Angeles metro area by social class .. PUMAs shown with black boundaries; pointer at Los Angeles-Orange County line

Percent of Households by Social Class by PUMA
.. Los Angeles area .. click for larger view.

Los Angeles metro area by social class .. PUMAs shown with black boundaries; pointer at Los Angeles-Orange County line

Using American Community Survey Microdata
We use of the American Community Survey microdata or “public use microdata samples” (PUMS) http://proximityone.com/pums.htm to develop estimates of population and households by middle class, lower class and upper class by “public use microdata area” (PUMA) http://proximityone.com/puma.htm. Microdata files are comprised of anonymized individual respondent data within PUMAs. The approximate 2,800 PUMAs cover the U.S. wall-to-wall and must have 100,000 population or more. 2010 and 2020 vintages PUMAs may be examined and compared with other geography using the VDA Web GIS http://proximityone.com/vda.htm with the MetroDynamics Project.

Social Class Participation by PUMA
Using custom software, the PUMA (ACS 2021 1 year data in this case), individual housing records are summarized for each PUMA. An estimate is developed for the lower, middle and upper class based on an algorithm.

Examine patterns of social class stratification using VDA Web GIS anywhere in U.S.
The estimates are then integrated into a PUMA shapefile. The PUMA shapefile is added to a Geographic Information System (GIS). Access this shapefile/layers using VDA Web GIS to examine patterns of social class, such as the graphics shown above, or in combination with other geography and subject matter.

About VDA GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

Data Analytics Web Sessions
Join us in the every Tuesday, Thursday Data Analytics Web Sessions. See how you can use VDA Web GIS and access different subject matter for related geography. Get your geographic, demographic, data access & use questions answered. Discuss applications with others.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

118th Congressional District Demographic Characteristics

.. what are the geographic, demographic, economic characteristics of a congressional district of interest? What are peer group congressional districts based on these characteristics? How might coalitions on selected topics better evolve? How can you communicate more effectively on policy issues to your congressional district leadership? How can you vote in a more informed manner by better understanding these matters? Use the VDA Web GIS Congressional Districts project to get these answers using only a Web browser. Learn more about Geographic Information Systems (GIS). This is a multi-part blog post on congressional district analytics. Click Follow at right to receive updates.

The November 2022 elections determined the representatives for the 118th Congressional Districts (CDs). The 118th Congress is in session from January 2023 to December 2024. The 118th Congressional District boundaries reflect the redistricting process based on Census 2020 results. While CDs have about the same population size within a state, the demographic composition varies widely. Use the VDA Web GIS Congressional Districts project to examine CD demographic-economic characteristics. Selected highlights are reviewed below.

These illustrative thematic pattern maps are based on data from the American Community Survey 2021 1-year estimates. Create your own maps and perform geospatial analyses using the VDA Web GIS with the Congressional Districts project. Nothing to install. Access using a Web browser. Start here. Sign up and login. Select the Congressional Districts project.

General Demographics — Percent Majority-Minority
Examine general demographics characteristics like topics on age and race/origin.

Social Characteristics — Educational Attainment
Examine social characteristics like household composition, mobility, enrollment, educational attainment.

Economic Characteristics — Economic Prosperity
Examine economic characteristics like labor force attributes, employment by occupation industry, income and benefits.

Housing Characteristics — Housing Value
Examine housing characteristics like owner/renter, units in structure, year structure built, housing value, rent, housing cost burden.

What’s Ahead — Upcoming Congressional District Blog Posts
This section has introduced tools to examine congressional districts at the national/regional level. The same tools and Congressional District project can be used to drill-down to the neighborhood level. Examine how characteristics within a congressional district vary within the district .. to be covered in subsequent posts. Learn more about examining these data in a tabular manner and geospatial analysis.

Upcoming topics .. drill-down analytics like this illustrative view
.. Atlanta, GA area .. CDs bold boundary labeled with CD code.
.. patterns of economic prosperity (median household income) by census tract
.. pointer & Atlanta city in GA05
.. easy to see how GA05 and GA06 radically different

About VDA GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

Data Analytics Web Sessions
Join us in the every Tuesday, Thursday Data Analytics Web Sessions. See how you can use VDA Web GIS and access different subject matter for related geography. Get your geographic, demographic, data access & use questions answered. Discuss applications with others.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

Examining City GeoDemographic Drilldown; Intersecting Tracts and Places

.. how can “our city” do a better job of providing housing for low-income individuals and families? One part of a successful program involves looking at attributes of the neighborhood, or census tract, geography across the city. We need to analyze needs by city component census tracts, areas averaging 4,000 population. Here is how that might be approached — determining which census tracts. And while this applies to low income housing, it applies to many other planning topics.

Relate census tract geography to city/place geography using GIS tools for analytical purposes … determine which tracts intersect a city/place. This section considers intersecting tracts and places for illustrative purposes. But the methodology, and tools to do this, involve many, many other types of geography .. geographic spatial intersection. The inputs in this case are U.S. national scope 2020 census tracts (85,190 areas covering the U.S. wall-to-wall) and U.S. national scope 2020 places (32,188 areas). The output from the process of intersecting these geographies are tract-place intersecting parts (119,906 areas). There are 32,146 tracts that are wholly contained in places.

Developing Intersect Files
Tracts intersecting with cities can be determined using the VDAGIS Intersect tool. Select the two input shapefiles and name the intersect output shapefile. The intersect shapefile is added to the GIS project being used.

Focusing on a City
What tracts intersect a city of interest? By having this information, stakeholders, policymakers can study and better understand inequities, differences and needs across the city. Consider Santa Ana, CA (Orange County). There are 65 tracts that intersect with the city of Santa Ana. This could be any city across America. The following view shows Santa Ana with intersecting tracts.

By viewing the intersecting file in VDAGIS, intersecting tracts can be examined. The graphic below shows a zoom-in to tract 06059089102 (blue boundary). This tract is shown at the pointer in the above graphic. in the following zoom-in view, the white label shows the tract code for the whole tract and the two split parts are shown with the same code. The part to the right in Santa Ana city, the part to the left is in Garden Grove city.

Using the intersecting file, the list (a partial list) of these tracts and tract codes can be determined as shown below. By knowing the tract codes, detailed demographic-economic data can be pulled using DEDE and tract characteristics can be studied. Inequities ab be examined, special needs can be determined, east versus west tract groups might identify patterns to facilitate collaboration and policy development. What are the patterns of affordable housing across the city?

About VDAGIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

Census 2020 – First Results

.. the first results of Census 2020, the apportionment data, were released on April 26, 2021.  Based on the decennial census, the United States total resident population increased from 308,745,538 (2010) to 331,449,281 (2020), a change of 22,703,743 (7.3%). For now, these data should be trusted and assumed accurate.  The apportionment data provide only total population counts at the state level.  More will be revealed about the accuracy of these data when the redistricting data are released in August 2021.

Apportionment of the U.S. House of Representatives
Congressional apportionment is the process of dividing the 435 members, or seats, in the House of Representatives among the 50 states based on the population data from the decennial census. See more about congressional districts and demographic-economic characteristics. See this related web section for detailed information on apportionment. Use the interactive table to view/analyze the Census 2010 and Census 2020 apportionment data. The following view shows patterns of congressional seats based on the decennial census. Labels show the number of seats based on the 2020 Census. Color patterns show the change in seats, 2010 to 2020.

Census 2020: the Process & Challenges
Counting the total population and selected population attributes in a pandemic is not only challenging but not possible.  During 2020, as the data were collected, it seemed good news that more than two-thirds of the potential respondents had completed the questionnaire.  But then the questions set in.  Bureau public announcements frequently made reference to the number or housing units and the number of households (occupied housing units) “accounted for” reaching 90 percent and progressively more.  By observation, using administrative record data, and other methods, housing units can be much more easily counted than the population and population attributes.  Likewise, determining the number households is  easier than determining the population count and characteristics.

The fact that the state population counts were unexpectedly different from the Bureau’s model based estimates is troubling.  We seek more assurance that the count of  population and population characteristics — by location — are as represented by the apportionment data.

Census Bureau 2020 Model-Based Estimates
New Census Bureau sourced U.S. by county model-based population estimates by age/gender/race-origin as of July 1, 2020 will be released by the Bureau in May 2021.  These estimates are independent of Census 2020 and make use of methods used annually throughout the 2010-2020 period.  An upcoming blog will report on ProximityOne’s analysis of these estimates in comparison with the Census 2020 data.

ProximityOne Estimates & Projections to 2060
ProximityOne annual demographic estimates and projections 2010-2060 by county will begin a new update cycle in May 2021.  The schedule is shown here.  

Starting with the May updates, two base projection series will be developed and progressively updated: one controlled to the Census 2020 data and one based on continued use of 2020 model-based estimates. As more information is released from Census 2020. Follow this blog for more information on evolving developments.

Learn more — Join me in the Data Analytics Web Sessions
Join me in a Accessing & Using GeoDemographics Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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.

New Monthly Residential Construction

.. staying ahead of how and where demographics are changing. Among all monthly new authorized residential construction permit issuing cities/places, Raleigh, NC led the U.S. with 1,749 total units followed by Austin, TX with 1,563 total units in February 2021. See more about this leading economic indicator for cities/places using interactive table below. Data on housing patterns and trends are essential for wide-ranging decision-making applications. Using ProximityOne resources to examine housing characteristics and trends ..

We post monthly and more frequent updates on what New Authorized Residential Construction data are telling us. The March 2021 city/county data will be released this week. Access the latest data for your areas of interest. Click the Follow button at right to keep up-to-date.

Monthly New Authorized Residential Construction
ProximityOne maintains a national monthly time-series database providing access to new authorized residential construction data.  The table presented below summaries key subject matter items available at the city and county level.. These data are one of eleven leading economic indicators. The housing market is often one of the first economic sectors to expand or contract when economic conditions improve or decline. With only a one month lag from reference data to availability date, these measures are early indicators of housing market change. This change typically leads to other types of economic change.

Patterns of New Residential Construction: February 2021; Phoenix Area
Using GIS tools to examine new authorized residential construction .. as an example, the following graphic shows that the City of Phoenix had 1,373 new authorized total units in February 2021. Cities/places shown with black outline.

View Most Month in Tabular Form
Use the interactive table to view these data in a tabular form as shown below.

Scope of Subject Matter
The database is updated monthly and contains monthly and annual data. The scope of subject matter is illustrated as shown below — the number of new units authorized and value by type of structure for Fresno County, CA.

Learn more — Join me in the Data Analytics Web Sessions
Join me in a Accessing & Using GeoDemographics Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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.

VDA Mapserver: Comparing Census Tracts & ZIP Codes

.. for small area demographic-economic analysis, census tracts and ZIP code areas both have their advantages and disadvantages.  While the same scope of subject matter data are available from the American Community Survey (ACS) and ProximityOne current estimates and projections for these geographies, it can be difficult to view how the geographic areas visually relate or intersect in a map.  A flexible solution, accessible by any Web browser, is the Virtual Data Analytics (VDA) Mapserver.  See details.  You can start using VDA immediately with nothing to install.

Visual Data Analytics Mapserver
The VDA Mapserver is a learning resource, a tool that you can use for interactive mapping and geospatial analysis using only Internet and a browser. The VDA Mapserver is set apart from related tools due to the scope and style of accessing data for wide-ranging geography and frequently updated demographic-economic subject matter data. Use the unique combination of Federal statistical data with proprietary current estimates and projections.

Other geographies and subject matter will be reviewed in subject posts.

An Illustration: ZIP Code Area 85258, Scottsdale, AZ

– click for larger view.

The above shows a zoom-in to ZIP code area 85258 in Scottsdale, AZ. A step-by-by description of how to develop this view is shown in this section of the VDA guide.

As shown in the graphic, ZIP Code area 85258 intersects with 8 census tracts. ZIP code areas and tracts are not coterminous. On average there are approximately 2.5 tracts per ZIP code area. But there are more than 150,000 intersecting combinations of ZIP Code areas and tracts. See intersecting areas and interactive table.

Learn more — Join me in the Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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.

Business Establishment Characteristics by County

.. what are the number and types of businesses underlying county economies of interest? What is the employment size by type of business establishment? What scope of wages, earnings do they contribute? Learn more here.

The pandemic impact on businesses remains in flux .. this post tools and data that can be used to examine pre-pandemic business establishments and employment pattern characteristics by county. By examining pre-pandemic conditions, we can better assess the impact of how and why business, demographic and economic change and impact as we move forward. The magnitude and duration of the impact on businesses will vary by community/area and become more measurable in the months ahead. The “How & Where of Business Establishment/Employment Change” will be updated later in 2020. See related, more detailed web section. See related section focused business establishments by ZIP code.

Where Things are Made by County
The following graphic shows patterns of the number of manufacturing establishments (NAICS 31) by county for the U.S. 48 contiguous states. Inset legend in map view shows number of establishments by interval/color. View/examine all U.S. states and areas using the related GIS project. Create custom maps similar to this view for your regions of interest depicting establishments, employment or payroll for your type of business selection(s). Click graphic for larger view with more detail; expand browser window for best quality view.

– view developed with ProximityOne CV XE GIS software and related GIS project.

The above view shows patterns for only one type of business. Data are tabulated more than 2,000 NAICS/type of business codes. These data may be examined by county using the interactive table. Use the GIS tools and related GIS project to develop variations of the views shown here.

Using the Interactive Table
The 10 largest counties based on the number of manufacturing establishments are shown in the static graphic below. Click for larger view.

Use the interactive table to dynamically create similar rankings on employment size or payroll. Set a query for a county, metro or state of interest.

Updates
These data update in June 2020. Follow the blog (click button at upper right) to receive updates.

Learn more — Join us in the Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

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.

Financing America’s Schools

.. as we look to restarting America’s economy, the nation’s public school systems face many questions and logistical issues.  Among these issues are a wide range of financial challenges.  Financing America’s public K-12 schools is supported by a mix of Federal, state and local funding.  In FY 2017, 13,311 regular public school districts reported total revenues of $679,925 billion derived from $51,212 billion federal (7.5%), $317,434 billion state (46.7%) and $311,278 billion local (45.8%) sources. These data are based on the school district finances (F-33) program data released by the Census Bureau in May 2019. States and individual school districts vary widely on the make-up/distribution of these federal, state and local sources.  See more about this topic and related K-12 schools topics in the ProximityOne K-12 schools main Web section.

Use tools and data reviewed here to examine K-12 school district finances — sources and uses of funds for FY 2017. View, sort, query, compare school district sources and uses of funds using the interactive table below in this section. Create/view profiles for district(s) of interest.

Data and resources reviewed here update in early May 2020 with new FY 2018 sources and uses of funds data and related school/school district financial data. We examine the implications of COVID-19 for school systems as we look to Restarting the Economy. Join the User Group to receive updates.

Percent Federal Revenue by School District, FY 2017
The following graphic shows patterns of percent Federal revenue by school district (unified and secondary), FY 2017. Click graphic for larger view. Expand browser to full window for best quality view.

– view developed using ProximityOne CV XE GIS software and related GIS project.
– use these tools on your computer to examine these data & related data.

Percent State Revenue by School District, FY 2017
The following graphic shows patterns of percent State revenue by school district (unified and secondary), FY 2017. Click graphic for larger view. Expand browser to full window for best quality view.

– view developed using ProximityOne CV XE GIS software and related GIS project.
– use these tools on your computer to examine these data & related data.

Interactive Table
The following static graphic shows the 10 Texas school districts having the largest Federal revenue. Sources of Federal revenue by program are also shown. Create views like this for any of the sources and uses of funds items for your selection of school districts. Use the interactive table (separate page) for dynamic analysis of individual school districts in context of U.S. overall, states or metros. Select by state or metro and rank based on any of several selected revenue by source and per student expenditure by category.

– click graphic for larger view

Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

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.

Census 2020 Residential Address Counts by Block

.. using Census 2020 residential address count data to examine change since 2010 .. the Census Bureau has released preliminary Census 2020 residential address counts by Census 2010 census block. These data, count of residential addresses and group quarters addresses, reflect updates as of October 2019 and do not represent final Census 2020 counts. The data will continue to be updated to support Census 2020. See related Web section with more detail and updates.

Importance and Use
These data are of immediate value in determining and analyzing how the number of housing units have changed, 2010 to 2019. Since the data are at the census block level, they may be aggregated to any other Census-defined summary level/type of geographic area such as block group, tract, ZIP code, city, county, school district, etc. These data are also important as they give us a “year in advance look” at how small area demographics are changing since 2010. Before this, the most recent census block data were from Census 2010. A lot has happened in many areas. These data provide insights into that change. The Census 2020 block level data will be released in early 2021 for Census 2020 census block geography. So, another important feature of these data is that they are summarized for Census 2010 census block boundaries. Census 2010 and 2020 block boundaries may differ, particularly in areas experiencing larger demographic growth/change. An important limitation is that they are counts, subject to change as the Census data are collected/tabulated.

Comparing Census 2010 Housing Units with Census 2020 Address Counts
The following graphic shows patterns of Census 2010 housing counts with the Census 2020 (late 2019 vintage) residential address counts by census block. This view is focused on census tract 3608100700 (tract 000700) in Queens County, NY (code shown near center of graphic). Individual blocks are labeled with block code (4 digits) with the Census 2010 housing units (yellow label) and Census 2020 residential address count (green label) shown below the block code. As an example, the block located at the pointer has block code 3006 (or full national scope unique block code 36-081-00700-3006) with a Census 2010 count 44 housing units and a Census 2020 (late 2019 count) of 232 residential addresses. Click graphic for larger view. Expand browser window to full screen for best quality view.

.. view created with ProximityOne CV XE GIS software and related GIS project.

More About Using these Data
We have summarized these data at the census tract level and are evaluating their use, in combination with other data, to develop current estimates and projections to 2025.

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

Relating ZIP Codes and Census Tracts

.. what census tracts intersect with a ZIP code of interest? There are many reasons for the underlying the need to convert/equivalence ZIP codes to/from census tracts. Some organizations have to provide census tract codes for addresses/ZIP codes of clients to be in compliance with a law or regulation. Some organizations have addresses/ZIP codes of clients/locations for which they would like to determine the corresponding census tract codes to analyze census tract demographics. This post reviews tools and options for these operations. See related Web section to access interactive table and learn more about mapping and geospatially relating these two geographies.

Phoenix/Scottsdale, AZ ZIP Code-Census Tract Relationship
The following graphic illustrates the relationship between ZIP code area 85258 (orange fill pattern) with census tracts (green boundaries and geocode labels).
(StCtyTract=04013216813).
.. view created with ProximityOne CV XE GIS software and related GIS project.

Create your own maps of areas relating ZIP codes and census tract, in context of other geography. Use the CV XE GIS with shapefiles.

Using the Interactive Table
Use the ZIP code to census tract interactive table (opens new page) to answer questions such as:
• Which census tracts intersect with a ZIP code of interest?
• Which ZIP code(s) intersect with census tract(s) of interest?
• What is the Census 2010 population for a census tract and ZIP code combination?

The interactive equivalence/look-up table shows a row for each unique combination of a Census 2010 ZIP code area and Census 2010 census tract. The start-up view is sorted on the State-County-Tract column (StCtyTract). View ZIP codes in one state using the State selection button. To locate a ZIP code of interest, either use the Find ZIP query or sort on the ZIP code column and then scroll down the table until the ZIP of interest is located.

Example. Click Find ZIP button using the interactive table (opens new page) to view only the tracts intersecting with ZIP code 85258 (as shown in map view above). The Location 1 marker (see pointer in map) is located in the area intersecting ZIP code 85258 and census tract 2168.13. The refreshed table view is shown by the graphic below. There are nine tracts intersecting with this ZIP code; see the tract codes in the table.

Try this for a ZIP of interest:
• View the interactive table (opens new page).
• Click the Showall button below table.
• Key in your 5-digit ZIP code in edit box where 85258 now shows.
• Click Find ZIP button.
• Table refreshes showing only tracts intersecting with this ZIP code.

Scope of Tracts and ZIPs in Table
There are 150,806 rows in the table, each showing a unique combination of a census tract (73,057 Census 2010 tracts) and ZIP code area (33,120 Census 2010 ZCTAs). Each row represents an intersection of the specified census tract and ZIP code area and corresponds to a geographic area of one census block or more. The total population and housing units values have been derived by summing component census block values. The sum of the population column is 308,745,538, the United States Census 2010 total population.

Situation & Outlook Weekly Web Sessions
Join me in a Situation & Outlook web session to discuss more details about demographic-economic estimates and projections.

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.