Housing Value Appreciation

.. U.S. housing prices rose nationwide in August, up 1.5% from the previous month, based on the FHFA Housing Price Index (HPI). Housing prices rose 8.0% from August 2019 to August 2020.

If you purchased a housing unit in 2019Q2 at $260,200 (the ACS 2019 median housing value), the value of the unit in 2020Q2 would be $271,000, an increase of 4.2%. A good deal in this era of low interest rates.

U.S. housing prices posted a strong increase in August .. the 1.5% increase is the largest one-month price increase observed since the start of the HPI measurement in 1991. This large month-over-month gain contributes to an already strong increase in prices over the summer. These price gains can be attributed to the historically low interest rates, rebounding housing demand and continued supply constraints.

The HPI has various limitations as a measure to assess the housing market. One important limitation is that it a measure in isolation; other related demographic-economic measures are not included. This is unlike the American Community Survey (ACS) estimates of the median housing value ($MHV), used as an annual, year-over-year measure of housing value appreciation.

Median Housing Value
The U.S. ACS 1-year estimate of median housing value ($MHV) increased from $229,700 in 2018 to $240,500 in 2019. The ACS 2020 estimate, which will be impacted by the pandemic, will not be available until September 2021. The ProximityOne 2020 estimate of $MHV is $270,500.

Click this API link to view a CSV-like file showing the 2019 median household income and median housing value by state. Join me in a Data Analytics Web Session (see below) to integrate these data into a map view like shown below. Add other data.

Patterns of Median Housing Value by State

– view developed using ProximityOne CV XE GIS
– click graphic for larger view

An advantage of using the ACS or ACS-like $MHV data is that this measure is synchronized with other related measures, like total population, total housing units, housing units by tenure and age built and so on. Though a popular measure to assess geographically comparable housing values, the $MHV has many limitations. A key limitation is that few survey responders really know the value of their home. Other limitations have to do with the definition itself and how the data are collected/developed. ACS $MHV measures value of only occupied housing units and excludes houses on 10 or more acres and housing units in multi-unit structures. See more. While there are other Federal sources of $MHV, it remains that the usabilty aspects of the ACS or ACS-like measures are second to none.

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.

Tip of the Day – Examining Median Housing Value – 2020 Update

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

.. in this era of uncertainly, we ponder the risk and opportunity associated with changing housing value.  Median housing value by ZIP Code area is one metric of great interest to examine levels and change.  While only one measure useful to examine housing characteristics, it is part of a broader set of demographic-economic data that enable analysis of the housing infrastructure and change in a more wholistic manner. How is housing value trending at the neighborhood level in 2020 and beyond? See more about the Situation & Outlook.

.. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. based on the American Community Survey (ACS) 5-year estimates. See related Web section.

Option 1. View the data as a thematic pattern map
Option 1 is presented as Option 1A (using CV XE GIS) and Option 1B (using Visual Data Analytics VDA Mapserver). See more about GIS.

Option 1A. View $MHV as a thematic pattern map; using CV XE GIS:
— Median Housing Value by ZIP Code Area; Los Angeles Area
Click graphic for larger view with more detail.

Click graphic for larger view.
Use the Mapping ZIP Code Demographics resources to develop similar views anywhere in U.S.

Option 1B. View $MHV (ACS 2018) as a thematic pattern map; using VDA Mapserver:
— Median Housing Value by ZIP Code Area; Phoenix/Scottsdale, AZ area
Click graphic for larger view with more detail.

Click graphic for larger view. Expand window to full screen for best quality view. View features:
– profile of ZIP 85258 (blue crosshatch highlight) shown in Attributes panel at left
– values-colors shown in Legend panel at left
– transparency setting allows “see through” to view ground topology below.
Use VDA Mapserver: to develop similar views anywhere in U.S. using only a browser. Nothing to install.

Option 2. Use the interactive table:
– go to http://proximityone.com/zip18dp4.htm (5-year estimates)
– median housing value is item H089; see item list above interactive table.
– scroll left on the table until H089 appears in the header column.
– that column shows the 2018 ACS H089 estimate for for all ZIP codes.
– click column header to sort; click again to sort other direction.
– see usage notes below table.

Option 3. Use the API operation:
– develop file containing $MHV for all ZIP code areas in U.S.
– load into Excel, other software; link with other data.
– median housing value ($MHV) is item B25077_001E.
– click this link to get B25077_001E ($MHV) using the API tool.
– this API call retrieves U.S. national scope data.
– a new page displays showing a line/row for each ZIP code.
– median housing value appears on the left, then ZIP code.
– optionally save this file and import the data into a preferred program.
– more about API tools.
Extending option 3 … accessing race, origin and $MHV for each ZIP code …
click on these example APIs to access data for all ZIP codes
.. get extended subject matter for all ZIP codes
.. get extended subject matter for two selected ZIP codes (64112 and 65201)

Items used in these API calls:
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_023E — Housing units value $500,000 to $749,999
.. B25075_024E — Housing units with value $750,000 to $999,999
.. B25075_025E — Housing units with value $1,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

View additional subject matter options.

Option 4. View the $MHV in context of other attributes for a ZIP code.
Using – ACS demographic-economic profiles. Example for ZIP 85258:
– General Demographics ACS 2018 .. ACS 2017
– Social Characteristics ACS 2018 .. ACS 2017
– Economic Characteristics ACS 2018 .. ACS 2017
– Housing Characteristics ACS 2018 .. ACS 2017 .. $MHV shown in this profile.

Option 5. View 5- and 10-mile circular area profile from ZIP center.
– profile for ZIP 80204 dynamically made using SiteReport tool.
– with SiteReport running, enter the ZIP code, radii and click Run.
– comparative analysis report is generated in HTML and Excel structure.
– Click this link to view resulting profile.
– from the profile, site 2 is 1.9 times the population of site 1.
– Site 1 $MHV is $296,998 compared to Site 2 $MHV $269,734.
– GIS view with integrated radius shown below.

This section is focused on median housing value and ZIP code areas. Many other subject matter items will be apparent when these methods are used. Optionally adjust above details to view different subject matter for ZIP codes.

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.

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.

America’s Cities: Situation & Outlook

.. the path forward .. planning for the future .. in April 2019, the employment in Houston, TX was 1,111,283 with an unemployment rate of 3.2%. In April 2020, the employment in Houston, TX was 927,105 with an unemployment rate of 14.9%. What will the 2020 annual look like? 2021? There are many paths to get to 2021 and beyond. What policy and action measures might work best? What about your cities of interest? See the related Web section for more details.

Houston characteristics: Demographic .. Social .. Economic .. Housing
Get for any city/area .. e-mail your request

The pandemic impacts on America’s cities in different ways .. some experiencing little change, others with massive change. When, where and how will these disparate patterns change in cities and communities of interest? How might this change impact you and your community? A comprehensive plan needs to be developed and set in motion to achieve best outcomes. This section provides access to tools and data that stakeholders can use to examine America’s cities demographic-economic characteristics and trends. Examine cities of interest. Use ProximityOne data, tools, methods and advisory services to achieve improved results.

Of the nation’s 327.2 million people, an estimated 206.0 million (62.9%) live within an incorporated place. Of approximately 19,500 incorporated places, about 76 percent had fewer than 5,000 people and nearly 50 percent had fewer than 1,000 people. Examine characteristics of individual city population trends and compare cities in states, regions and peer groups using the interactive table below.

Patterns of Economic Prosperity; Cities 50,000 Population or More
The following view shows cities with 2019 population of 50,000 or more as markers .. mainly principal cities of metropolitan statistical areas (MSAs). Nationally, there are 69 cities with 2019 population of 5,000 or more (determine using interactive table below). The marker color shows the median household income; see inset legend. Click graphic for larger view; expand window to full screen.

– View developed using the ProximityOne CV XE GIS software.

Patterns of Economic Prosperity; Cities 5,000 Population or More
– zoom-in to Dallas Metro
The following view shows cities with 2019 population of 5,000 or more as polygons/city boundary-area in the Dallas metro area. There are 201 cities that intersect with the Dallas metro (code 19100); 96 of these cities have a population greater than 5,000 (determine using interactive table below). The color patterns show the median household income range; see inset legend. Click graphic for larger view; expand window to full screen.

Patterns of Economic Prosperity by Neighborhood & Adjacent Areas
The following view shows patterns of median household income by block group (sub-neighborhoods) within city (bold black boundary) in the Dallas County, TX area. In examining the situation & outlook for a city it is important to examine characteristics of drill-down geography and adjacent cities/areas. Inset legend shows median household income color intervals. Click graphic for larger view; expand window to full screen. In the larger view, a cross-hatch pattern is applied to Dallas city. It is easier to see how Dallas city is comprised of a core area as well as outlying areas and extends into adjacent counties.

Interactive Analysis of Cities: Demographic-Economic Patterns & Trends
Use the interactive table to view, rank, compare cities based on demographic-economic trends and characteristics. The following static graphics provide two examples.

 

Largest 15 U.S. Cities Ranked on 2019 Population

California Cities Ranked on Educational Attainment

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.

How & Why County Demographics are Changing

.. the pandemic impact on population change remains in flux. For many counties it will impact each component of population change: births, deaths and migration. The magnitude and duration of the impact on each component will vary by county and become more measurable in the months ahead. The “How & Why County Demographics are Changing” will be updated later in 2020.

Here we look at population and components of change by county for the period 2010 to 2019 .. tools and data to examine how the U.S. by county population is changing. These latest 2019 estimates were released this spring. See more in the related web section.

Top 25 Counties with Largest Population Change 2010-2019
Create a table similar to the one shown below using the interactive table. Sort on selected criteria and within a selected state or metro.

Patterns of Population Change by County, 2010-2019
The following graphic shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2019. Click graphic for larger view; expand browser window for best quality view.

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

Examining Population Components of Change
Population change can be examined in terms of components of change. There are three components of change: births, deaths, and migration. The change in the population from births and deaths is often combined and referred to as natural increase or natural change. Populations grow or shrink depending on if they gain people faster than they lose them. Examining a county’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring. The above graphic shows these relationships.

County Population & Components of Change 2010-2019 – Interactive Table
View/analyze county population and components of change characteristics and trends in a tabular manner using the interactive table. The following static graphic shows net migration 2010-2019 by year for Houston, TX metro component counties. Rows have been ranked in descending order based on 2010 population. It is easy to see how the net migration in Harris County has been decreasing annually since 2015.

Try it yourself. Use the interactive table to examine counties/areas of interest.

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.

Patterns of Income in America’s Largest Cities

The retreat in personal and household income resulting from the pandemic will be historic and substantial. How long term? Which cities of what size and location will be affected the most? We start to study patterns and trends as new data become available in the next several weeks.

America’s largest 629 cities accounted for a group population of 121,228,560, or 37.1%, of the total U.S. population (327,167,434) in 2018. All of these cities are in Metropolitan Statistical Areas (MSAs). With contiguous cities and places, these urban areas account for more than 80% of the U.S. population. These cities, each with 65,000 population or more, are shown as markers in the thematic pattern view below. See more about cities/places and city/place 2010-2018 demographic trends.

Patterns of Economic Prosperity: America’s Largest Cities
– cities with 2018 population 65,000+ shown as markers
– markers show level of 2018 median household income
– data used to develop this veiw were extracted using GeoFinder.
– click map for larger view; expand browser to full screen for best quality view.

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

Top 25 Largest Cities based on Median Household Income

About America’s Largest Cities & Economic Characteristics
The set of the 629 America’s largest cities is based on data from the 2018 American Community Survey 1-year estimates (ACS 2018). ACS 2018 1-year estimates, by design, provide data only for areas 65,000 population or more. The ACS 2018 data are the only source of income and related economic data for national scope each/all cities/places (29,853) on an annual and more recent basis. These data will update with 2019 estimates in September 2020. ACS-based data reflecting the impact of the pandemic will not be available until September 2021.

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.

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.

Neighborhood Median Family Income: Measuring Economic Well-Being

.. Median Family Income ($MFI) and Median Household Income ($MHI) are two measures of economic well-being. Based on the 2018 American Community Survey 1-year (ACS) data, the U.S. 2018 $MFI was estimated to be $76,401 while the $MHI was estimated to be $61,937 .. both in 2018/current dollars. Create insights into patterns of well-being by neighborhood using geospatial analysis. $MFI patterns are illustrated by the following thematic pattern map.

Patterns of Economic Prosperity by Neighborhood/Census Tract
The following view shows patterns of $MFI by census tract for the inner beltway area of Houston/Harris County, TX. Income interval color patterns are shown in the inset legend. Tracts are labeled with $MFI. Click graphic for larger view. Expand browser window for best quality view. Larger view shows tracts labeled with tract code. It is easy to see how west Houston and east Houston areas differ.

– view developed with ProximityOne CV XE GIS software and related GIS project.
– these $MFI data are based on the 2018 ACS 5-year estimates.

This section focuses on $MFI but could just as well focus on $MHI and yet other related income measures. $MFI will almost always be greater that $MHI, generally by a large margin. See the U.S. 2018 $MFI and $MHI in context of related demographic-economic measure here. See more about the distinctions/definitions of families and and households below.

The ACS data are a unique source of income and related data at the neighborhood or sub-county level. View more about accessing and using the 2018 ACS 5-year estimates.

Family Definition
A family is a group of two people or more (one of whom is the householder) related by birth, marriage, or adoption and residing together; all such people (including related subfamily members) are considered as members of one family. The number of families is equal to the number of family households. However, the count of family members differs from the count of family household members because family household members include any non-relatives living in the household.

Related … an unmarried partner, also known as a domestic partner, is specifically defined as a person who shares a close personal relationship with the reference person. … Same-sex unmarried-partner families or households – reference person and unmarried partner are both male or female.

Household Definition
A household consists of all the people who occupy a housing unit. A house, an apartment or other group of rooms, or a single room, is regarded as a housing unit when it is occupied or intended for occupancy as separate living quarters; that is, when the occupants do not live with any other persons in the structure and there is direct access from the outside or through a common hall.

A household includes the related family members and all the unrelated people, if any, such as lodgers, foster children, wards, or employees who share the housing unit. A person living alone in a housing unit, or a group of unrelated people sharing a housing unit such as partners or roomers, is also counted as a household. The count of households excludes group quarters. There are two major categories of households, “family” and “nonfamily”.

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.