Housing Price Index by ZIP Code – How Housing Markets are Trending

.. housing prices can impact residential investment and affect economic growth, business opportunities and the housing market. The Housing Price Index (HPI) is one measure of how housing prices are changing. The HPI by ZIP code, as reviewed here, is an index based on the year 2000=100. Changing trends in the HPI can used used the determine the relative costs of housing and change in housing valuation. Hosing prices, and the HPI, are only one part of determining how housing markets are trending. Other measures important to examine include building permits and new construction.

Examining Housing Price Trends
Use the VDA Web GIS tool to examine the Housing Price Index for ZIP Codes of interest. Create maps and tabular profiles such as the one shown below.

Video of Steps to Explore HPI by ZIP Code
Click graphic to view video showing how to use VDA Web GIS to access a ZIP Code profile.

About VDA Web GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

About the Housing Price Index
The Housing Price Index used here is developed by the Federal Housing Fiance Agency (FHFA). The FHFA House Price Index is the nation’s only public, freely available house price indexes that measure changes in single-family home values based on data from all states that extend back to the mid-1970s.

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.

The Local Area Monthly Employment Situation

.. in June 2019, the local area unemployment rate ranged from 1.3% (Lyon County, IA) to 19.6% (Yuma County, AZ) among the lower 48 states. 133 counties had an unemployment rate of 7% or more during June 2018 through June 2019. Over the past year, as shown in the this interactive table, the unemployment rate has generally decreased among all counties. We track the local area employment situation historically and develop alternative scenario projections. See the related Web page for more information.

Patterns of Unemployment Rate by County
The following graphic shows patterns of the estimated June 2019 unemployment rate by county. Use the GIS tools and data to develop variations of this view optionally integrated with other data. Click graphic for larger view. Expand browser window for best quality view.

— view created using the ProximityOne CV XE GIS and associated GIS Project

Examine Areas of Interest
This graphic illustrates the monthly over the year employment situation for the Houston, TX metro using the interactive table.

Click graphic for larger view.

Create a similar table for any metro:
Open the interactive table (green and white table midway down).
Click ShowAll button below table.
Key in a 5-character metro code in edit box at right of FindCBSACode.
    … get from scroll list at upper right of table.
    … e.g., 19100 for Dallas, TX metro.
Click FindCBSACode; table refreshes showing only counties in this metro.
Click Current Situation button below table; table refreshes with selected columns.
Click the Pop2018 column header cell twice to rank-order the columns.
Done .. try these steps for an area of interest.

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.

New 2018 Vintage Metropolitan Areas

.. new, September 14, 2018 vintage, Core-Based Statistical Area (CBSA) delineations have been released by the U.S. Office of Management and Budget (OMB).  Among other things, the new delineations specify which counties are included in each CBSA.  CBSAs. an OMB standards term, are metropolitan areas comprised of Metropolitan Statistical Areas (now 384 MSAs in the U.S.) and Micropolitan Statistical Areas (now 542 MISAs in the U.S.).

How Metros Change Geographically
The following graphic, focused on the Charlotte, NC-SC MSA region, illustrates how MSAs are changing. 2017 vintage MSAs are shown with bold green boundary, yellow fill pattern. Cross-hatched areas are 2018 vintage MSA counties. As of the 2018 vintage, note that …
• Anson County, NC (to right of pointer) has been added to the Charlotte, NC-SC MSA.
• Union County, SC has been removed from the Spartanburg, SC MSA.
• Harnett County, NC has been added to the Fayetteville, NC MSA.

— graphic developed using CV XE GIS software and related GIS project.

What About My MSAs of Interest?
See detailed information about the 2018 vintage CBSAs/MSAs and their component counties at http://proximityone.com/cbsa2018.htm.

Impact of the 2018 Delineations
The new delineations take place immediately and have numerous impacts.  Going forward, Federal statistical agencies will develop statistics and use the new names and geocodes as set forth in the new delineations (most names and geocodes remain the same).  For CBSAs affected, which are numerous, this will result in challenges for longitudinal analyses where consistently defined geography over time is required.  The total 2017 official population estimates are affected for three of the largest 10 CBSAs using the 2018 delineations compared to the 2017 delineations.  More immediately, it may become confusing whether the 2018, 2017, 2015, or an earlier vintage CBSA geography is being referenced.  On a positive note, the 2018 vintage CBSAs are believed to best reflect the set of counties comprising a CBSA as an entity of highly related demographic-economic conditions.

Keeping Up-to-Date with Metro Demographic-Economic Data
Metropolitan Statistical Areas (MSAs/metros), comprised of one or more contiguous counties, are important for many reasons. Business, demographic and economic data for these 384 areas, each developed around an area of large population concentration, provide a “10,000 foot” view of these characteristics and how they are changing. As they are comprised of county groups, much of the subject matter data are also available for drill-down analysis at the county and sub-county levels. Metro boundaries change some over time … as more peripheral counties are added or removed depending on their demographic-economic affinity with central county(s).

Metros are an important part of the ProximityOne Situation & Outlook program. Metro demographic-economic estimates and projections are updated to reflect 2018 vintage metros. This includes all elements of the Census-sourced age-race/ethnicity-gender annual estimates and American Community Survey demographic-economic subject matter.

Designating Metros and Delineating Metro County Components
More detail … in consultation with Federal statistical agencies, OMB defines metropolitan statistical area boundaries. This section provides a summary of Metropolitan Statistical Areas (MSAs), and component Metropolitan Division and Counties/County Equivalents, as delineated in OMB Bulletin 18-04 issued September 14, 2018. These delineations take place immediately. This is a significant update affecting approximately 20-percent of previous MSA delineations (one or more county addition or removal).

Under the September 14, 2018 delineation, there are 938 Metropolitan Statistical Areas (MSAs) and Micropolitan Statistical Areas (MISAs) in the U.S. and Puerto Rico, collectively referred to as Core-Based Statistical Areas (CBSAs). There are 392 MSAs (384 in the U.S. and 8 in Puerto Rico). 11 MSAs contain a total of 31 Metropolitan Divisions. There are 546 MISAs (542 in the United States and 4 in Puerto Rico).

The 384 U.S. MSAs comprise 1,181 counties of total 3,142 U.S. counties. The total 2017 population of these metros was 280,468,904 of total 325,719,178 U.S. population (86.1%).

See related sections:
• Metros Main Section
• Metros Situation & Outlook Reports
.. click link in column 3 in table in above page to view detailed report
• Metro Demographic-Economic Interactive Tables
• County Population/Components of Change Interactive Table

Data Analytics Web Sessions
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.

Metropolitan Area New Residential Construction in 2017

.. understanding the housing situation; examining housing supply and demand market conditions; assessing trends for metropolitan areas … and how metros of interest are changing .. tools and data to examine patterns and change.

During 2017, cities and counties in permit issuing places authorized the construction of 1,281,977 new privately owned housing units with a total valuation of $258.5 billion. This was 1.4 percent above the annual estimate of 1,264,051 housing units and is a 6.2 percent increase from the 2016 total of 1,206,642.

Patterns of New Residential Construction by Metropolitan Area
The following graphic shows the 20 largest metropolitan statistical areas (MSAs) based on the number of new residential housing units authorized in 2017. Click graphic for larger view showing MSAs labeled with rank and name.

View created with CV XE GIS. Click graphic for larger view.

Residential Construction Data Analytics — Using Tools & Data
Visit the related Web section to access interactive table and GIS/GeoSpatial analytical tools and data.

Data Analytics Web Sessions
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.
 

Housing Price Index Updates & Trends

.. this past week we have updated Housing Price Index data and tools to examine patterns and trends for the U.S., states, metros and counties .. the Housing Price Index (HPI) is one of many measures useful to gain insights into the housing market. The HPI provides information on how housing value appreciation is changing for areas of interest. Use the interactive table to view, compare, sort metros/CBSAs based on annual HPI 2010-2017 and housing value appreciation during the period. These annual data, with a 2000 base index value of 100, provide insights into longer term patterns.  The HPI is alos updated quarterly for U.S./state/metro areas quarterly for analyses requiring more recent data.  These data are new as of February 2018.

Visual Analysis of Housing Price Appreciation
The following graphic shows housing value appreciation as of 2017 based on the HPI with 2000 base of 100 by county in the Charlotte, NC-SC metro area. See more about by HPI by county for the Charlotte metro.

– view developed using CV XE GIS and related GIS project.
– Click graphic for larger view and details.

See similar HPI 2017 patterns view for the Houston, TX metro.

Housing Price Appreciation 2010-2017 — Largest 10 Metros
This table, derived from the  interactive table, shows the largest 10 metros based on total population. the HPI 2010, HPI 2017, housing price appreciation 2010-2017 and total population are presented in the table. Click the CBSA code link to view HPI by county component for the metro and an extended series.

Metro	CBSA	HPI2010	HPI2017	HPA1017	Pop2016
New York	35620	159.53	172.76	8.29	20,153,634
Los Angeles	31080	169.83	242.78	42.95	13,310,447
Chicago	16980	117.48	124.58	6.04	9,512,999
Dallas	19100	120.89	175.35	45.05	7,233,323
Houston	26420	134.02	183.52	36.93	6,772,470
Washington	47900	166.82	198.74	19.13	6,131,977
PhiladelphiaA	37980	157.26	162.91	3.59	6,070,500
Miami	33100	140.43	213.91	52.33	6,066,387
Atlanta	12060	103.95	129.24	24.33	5,789,700
Boston	14460	134.33	165.27	23.03	4,794,447

– Metro names abbreviated; use table to view full name and code.

Using the HPI Annual 2010-2017 Interactive Table
The following graphic illustrates use of the HPI Annual 2010-2017 interactive table. Click graphic for larger view. This view shows metros in the 250,000-300,000 population peer group. Set your own criteria using tools below the table. There are 23 metros in this group. The table has been sorted on housing price appreciation (HPA) from 2010-2017 (second column from right). It shows that the Merced, CA metro had the highest HPA — 82.13% di=uring this period.

Use the interactive table and examine areas of interest.

Data Analytics Web Sessions
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.

 

 

Metro 2016 Demographic-Economic Data Analytics: Social Characteristics

.. part one of four parts focused Metro 2016 Demographic-Economic Data Analytics.  This post is on Social Characteristics; ahead: general demographics, economic characteristics and housing characteristics. See related Web section.

Patterns of Educational Attainment by Metro
The following graphic shows patterns of educational attainment (percent college graduate) by Metropolitan Statistical Area (MSA). Legend shows color patterns associated with percent college graduate values.

– View developed using CV XE GIS software and associated GIS project.
– use these resources to develop similar views for any area.
– modify subjects, zoom, colors, labels, add your data.

A Selected Social Characteristic & How Metros Vary
In 2016, the U.S. percent college graduates was 31.3 percent (of the population ages 25 and over) while Metropolitan Statistical Areas (MSAs) ranged from 11.3% (Lake Havasu City-Kingman, AZ MSA) to 60.6% (Boulder, CO MSA). See item/column S067 in the interactive table to view, rank, compare, analyze metros based on this measure for 2016 … in context of related social characteristics. These data uniquely provide insights into many of the most important social characteristics.

Social Characteristics – Subject Matter Covered
– Households by Type
– Relationship
– Marital Status
– Fertility
– Grandparents
– School Enrollment
– Educational Attainment
– Veteran Status
– Disability Status
– Mobility; Residence 1 Year Ago
– Place of Birth
– Citizenship Status
– Year of Entry
– Region of Birth
– Language Spoken at Home
– Ancestry
– Computers & Internet Use

Metro Data Analytics
Use tools, resources and methods to access, integrate and analyze social characteristics for metropolitan areas or Core-Based Statistical Areas (CBSAs). The table includes data for 382 Metropolitan Statistical Areas (MSAs) and 129 Micropolitan Statistical Areas (MISAs). These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics — reviewed here
• Economic Characteristics
• Housing Characteristics
See related Metro Areas Population & Components of Change time series data.

Focusing on Specific Metros & Integrated Multi-sourced Data
While these data provide a good cross section of data on social characteristics, this access structure is a) for one time period and b) data sourced from one statistical program. Also, there is a lot going on in metros; these are typically large areas with many important and diverse smaller geographies such as cities, counties and neighborhoods among other others.

Use the Metropolitan Situation & Outlook (S&O) reports to develop extended insights. See this example of the Washington, DC MSA S&O Report. Examine trends and projections to 2030. Inegrate your own data.

Using the Interactive Table
The following example illustrates use of the metro social characteristics interactive table … try using it on areas of interest. This view, showing metros partly or entirely in Arizona, was first developed by using the state selection tool below the table Next the selected columns button the table is used to examine educational attainment columns/items. The final step was to click the header cell on the “S067” item to sort metros on percent college graduates. It is easy to determine that the Flagstaff metro has the highest percent college graduates (home to Northern Arizona University).

Data Analytics Web Sessions
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.

Examining America’s 10 Largest Urban Areas

.. why it matters .. among other reasons, these 10 areas have 24% of the total U.S. population. Three have increased by more than 20% in the past 5 years.

More than 80-percent of America’s population is urban, but far more than 80-percent of America’s geography is rural. Census 2010 shows that America’s urban population increased by 12.1 percent from 2000 to 2010, compared to the national overall growth rate of 9.7 percent. Urban areas now account for 80.7 percent of the U.S. population, compared to 79.0 percent in 2000.

America’s 10 Largest Urbanized Areas
The following table shows the largest 10 Urbanized Areas (UAs) based on the American Community Survey 2011 and 2016 1-year estimates (ACS2016) and change over the period. UAs are sorted in descending order based on the 2016 population estimate. Note that Atlanta, Dallas and Houston moved up in rank.

Geodemographic relationships vary widely between the urbanized areas (UAs). Some, such as Miami, comprise most or all of the urban area within the corresponding metropolitan statistical area. Others, such as Philadelphia, are nested within a mix of adjacent urban areas interspersed with rural areas. Among other things, these different geodemographic structures reflect how planning, needs assessment and market development vary widely from associated metro-to-metro. These data show the importance and need to consider the urban/rural population distribution even in the largest metros.

Visual Analysis — Dallas Urbanized Area
The urbanized area (UA) of the corresponding metropolitan statistical area (MSA) generally occupies less than half of the MSA.
See the Dallas-Fort Worth-Arlington, TX MSA Situation and Outlook Report

… View developed using CV XE GIS.

Map Views for Each of the Largest 10 Urbanized Areas
Maps for each of the 10 largest UAs are shown at
http://proximityone.com/urbanareas_2016.htm.

Each graphic shows the designated urbanized area in a darker salmon color fill pattern, associated metropolitan statistical area with bold brown boundary, and other urban areas with a lighter shade of salmon fill color, counties black boundaries and yellow labels. The ACS 2016 UA population is shown as a white label under the UA name. The ACS 2016 estimates are the most recent data available and will update with 2017 estimates in late 2018.

More About Analyzing Urban/Rural Patterns and Characteristics
See the related section on America’s urban/rural population and geography:
http://proximityone.com/urbanpopulation.htm.

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 L

Creating Custom Demographic Datasets with API Tools

.. develop national scale spreadsheet files with virtually no learning time .. easy-to-use API operations to create national scope demographic-economic datasets based on American Community Survey 2016 1-year estimates .. custom subject matter selections. See more detail in related web sections ACS2016 and ACS2016_API.

Benefits and utility … how to acquire a spreadsheet showing the population of all cities with population estimates based on the ACS 2016 1-year data? … or, housing units, median household income, median housing value, etc.? Variations of this need frequently arise — what is the list of largest California counties sorted on total population: What are the 25 metros having the highest median household income? Which 10 congressional districts have the highest poverty incidence? Which urban areas have the highest educational attainment?

Use simple API calls described below to get answers to these types of questions — and more.  Create files that can be used for recurring applications. An example …

Urban Areas with 2016 Population 65,000+ Population
… results from using the API downloaded data … the following graphic shows urban areas with 65,000 or more 2016 population; zoom-in to Texas. The full national scope GIS project is available as described below; examine U.S. or any region. The file used to develop this view was created using the results of the API call reviewed below (requires integration of those data into the urban areas shapefile). Click graphic for larger view; expand browser window. Larger view shows urban areas labeled with name and mini profile for Dallas UA showing all subject matter items downloaded (via API) as described below.

… View developed using CV XE GIS.
… See more about Urban Population & Urban Areas.

Access ACS 2016 1-Year Data Using API Tools
Here are the API links … use these API calls to access/download selected items for selected geographies. See more about using API tools. Click a link and receive a return page with CSV-like structured data. See usage notes below. As these are ACS 2016 1 year estimates; geographies are only available for areas 65,000+ population.
Click a link:
• All U.S. cities/places
• All U.S. counties
• All U.S. CBSAs
• All U.S. Urban Areas
• All 115th Congressional Districts
• All U.S. states
• U.S. only

The following data retrieval operations are by state. These are examples using Arizona (FIPS state code 04).
• All [within state] Elementary School Districts
• All [within state] Secondary School Districts
• All [within state] Unified School Districts

API Call Returned Data Usage Notes
Clicking the All U.S. cities/places link above generates a new page with content very much like a CSV file. Try it .. click an above link.

See the related ACS2016_API web section for more details.

Items Retrieved in the API Calls
The sample header record above shows the subject matter item listed at the left in the following set of items. Modify API call and use other subject matter items. See full array of subject matter – xlsx file.
.. 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_025E — Housing units value $1,000,000 to $1,499,999
.. B25075_026E — Housing units with value $1,500,000 to $1,999,999
.. B25075_027E — Housing units with value $2,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

The rightmost fields/columns in the rows/records contain the area name and geographic codes.

Using API Tools for Data Analytics
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 L

Important Upcoming Data Releases: September 2017

.. monthly updates on recent & upcoming data analytics tools & resources .. this section provides a monthly update on important new data developments and applications/developments to further their use in data analytics. A focus of this section is on new or revised geographic, demographic and economic data. Most of these data are used to develop and update ProximityOne census tract-level up demographic-economic projections to 2022 and county-level up population by single year of age projections to 2060. See about September projection updates below on this page. This section is organized into recent past data updates and upcoming (month ahead) data releases and may be updated to reflect new or extended details. See related news and updates:
• What’s New daily updates
• Situation & Outlook Calendar

See related Web section.

Recent Past Data Releases/Access

U.S. by Census Tract 2017 HMDA Low & Moderate Income (FFIEC)
• Release date — 8/17; next update — mid 2018
• 2017 annual HMDA data — covers all income levels not only LMI
• New 2017 HMDA data
• See more information – access data.

U.S. by County Population by Single Year of Age (NCHS)
• Release date — 8/22/17; next update — mid 2018
• 2010 through 2016 annual population by single year of age
• New 2016 data extending annual series 2010 forward
• See more information – access updates.

Housing Price Index (FHFA)
• Release date — 8/22/17; next update — 11/28/17
• Quarterly HPI
• New 2017Q2 data extending quarterly time series.
• See more information – access updates.

Quarterly Gross Domestic Product by State (BEA)
• Release date — 9/20/17; next update — 11/21/17
• Quarterly GDP by Industry
• New 2017Q1 data extending quarterly time series.
• See more information – access data.

Upcoming Data Releases/Access 

2017 TIGER Digital Map Database (Census)
• Expected ~ 9/7/17
• Topologically Integrated Geographic Encoding & Referencing (TIGER) data.
• Geographic data; predominately shapefiles.
.. intersection to intersection road segment geography and attributes.
• New 2017 GIS/mapping shapefiles for use with wide-ranging data
.. including with Census 2010, ACS 2016 & other subject matter.
• See more information – updates to access summarized in that section.

Census of Employment and Wages (BLS/CEW)
• Release date — 9/6/17; next update — 12/5/17
• AKA ES-202 data — establishments, employment & wages by NAICS code/type of business
• U.S. by county.
• New 2017Q1 data extending quarterly time series.
• See more information.

2016 American Community Survey 1-year estimates (Census/ACS)
• Release date — 9/14/17
• Wide-ranging demographic-economic data for areas having population 65,000+
.. all states, CDs, PUMAs, MSAs and larger cities/CBSAs/school districts/counties (817 of 3142)
• New 2016 estimates.
• See more information – updates to access summarized in that section.

SY 2015-16 Annual School & School District Characteristics (NCES)
• Expected ~ 9/14/17
• National school school & school district characteristics.
• New 2015-16 school year administratively reported data.
• Schools … see more information – access updates.
• School District … see more information – access updates.

2016 Annual Gross Domestic Product by Metro (BEA)
• Release date — 9/20/17
• GDP by Industry by Metro
• New 2016 data extending time series
• See more information – access updates.

Census Tract Estimates and Projections to 2022 — ProximityOne
• Release data ~ 9/27/17
• National census tract and higher level geography demographic-economic updates
• Annual estimates & projections; 2010 through 2022
• Updated to reflect/integrate data released through 9/2017 as summarized above   • See more information.

County Population by Single Year of Age Projections to 2060 — ProximityOne
• Release data ~ 9/27/17
• National county and higher level geography demographic updates
• Annual estimates & projections; 2010 through 2060
• Updated to reflect/integrate data released through 9/2017 as summarized above.   • See more information.

Notes [goto top]
– BEA – Bureau of Economic Analysis
– BLS – Bureau of Labor Statistics
– Census – Census Bureau
– FFIEC – Federal Financial Institutions Examination Council
– FHFA – Federal Housing Finance Agency
– NCES – National Center for Education Statistics
– NCHS – National Center for Health Statistics

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.

Low & Moderate Income Census Tracts; 2017 Update

..  data and tools to analyze characteristics and patterns of census tract geography with a focus on low and moderate income.   See related Web page for more detail.

Of the total 75,883 census tracts for which low and moderate income data were tabulated in the HMDA 2017 data, 6,023 (8.7%) were low income, 16,873 (24.5%) were moderate income, 32,509 (47.1%) were middle income and 19,159 (27.8%) were upper income. See more about these classifications. Find out about your tracts/neighborhoods of interest and how they compare to others using data and tools provided in this section.

Analysis of the low, moderate, middle, and upper income of the population and households by small area geography is important to housing market stakeholders, lenders, investors, cities/neighborhoods and others. Low and moderate income data by block group and census tract are used for compliance, eligibility determination and program performance in many Federal programs and agencies.

• Use the interactive table below to view, query, compare, sort census tracts.
• Use tract estimates & projections to examine changing characteristics.
– extended demographic-economic measures, annual 2010-2022

Low & Moderate Income by Census Tract
The following view shows census tracts designated as low and moderate income (orange fill pattern) in the the Houston, TX MSA (bold brown boundary) area. These are tracts having income level with codes 1 and 2 in the interactive table. A wide range of market insights can be created zoom-in views for counties, cities and neighborhoods and linking these with other data. Make variations of this view using ProximityOne data and tools described in this section.

– View developed using CV XE GIS and related GIS project.

View similar maps for these areas:
.. Atlanta metro
.. Chicago, IL metro
.. Dallas, TX metro
.. Knoxville, TN metro
.. with drill-down views for Knoxville city
.. Los Angeles, CA metro
.. San Francisco, CA metro

Using the Interactive Table
  – Examining LMI Tracts in Your Metro
Use the interactive table to view, query, sort compare tracts based on various demographic and LMI characteristitcs. The following graphic illustrates how the table can be used to view low and moderate income tracts for the Charlotte, NC-SC metro.
– click ShowAll button below table.
– enter a CBSA code in the edit box at right of Find CBSA LMI>.
– click the Find CBSA LMI button.
Resulting display of Charlotte metro LMI tracts only.

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