Category Archives: ProximityOne

116th Congressional Districts & Patterns of Economic Prosperity

.. Congressional District Analysis and Insights .. tools to examine patterns of median household income .. median household income is one measure of economic prosperity. This section reviews patterns of median household income (MHI) by 116th Congressional Districts based on the 2018 American Community Survey 1-year estimates (ACS 2018). View, rank, compare the MHI by congressional district, among related demographic attributes using the interactive table on the main Congressional Districts page.

116th Congressional District Analysis & Insights
.. patterns of household income & economic prosperity:
Based on the ACS 2018 median household income (MHI):
• the MHI among all districts was $60,291
• the U.S. overall MHI was $61,937
As of November 2019:
• the 19 districts with highest MHI have Democrat incumbents
• the 10 districts with the highest Gini Index have Democrat incumbents
• there are 69 Republican incumbent districts above the all districts MHI
• there are 149 Democrat incumbent districts above the all districts MHI
• the MHI of the 236 Democrat incumbent districts is $66,829
• the MHI of the 199 Republican incumbent districts is $56,505
Median household income is only one measure of economic prosperity.
See more at http://proximityone.com/cd.htm.

Patterns of Economic Prosperity 116th Congressional District
The following graphic shows patterns of 2018 median household income by 116th Congressional District. Use GIS tools/data to generate similar views for any state and/or drill-down. Click graphic for larger view with more detail. Expand browser window for best quality view.

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

Using the Interactive Table
— view, rank, compare districts based on your criteria.
— example,which districts have the highest median household income?
Use the interactive table to examine incumbency and and demographic characteristics of the 116th Congressional Districts (CDs). The following view illustrates use of the table. This view shows use a query to show the ten CDs having highest 2018 median household income.

Try using the interactive table to existing districts and categories of interest.

Congressional District/State Legislative District Group
Join in .. be a part of the Congressional Districts/State Legislative District (CDSLD) group. Access analytical tools and data. Learn about CDSLD analytics, patterns and trends. Share insights with like-minded stakeholders.

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.

Personal Consumption Expenditures by Type & State

.. using Personal Consumption Expenditures (PCE) measures to monitor/examine the strength of a regional economy and consumer buying trends in that region and compare among regions … PCE estimates released in October 2019, show that state personal consumption expenditures increased 5.1 percent in 2018, an acceleration from the 4.4 percent increase in 2017. The percent change in PCE across all states ranged from 7.3 percent in Utah to 3.6 percent in West Virginia.

In 2018, across all states and D.C., per capita PCE was $42,757. Per capita PCE by state ranged from a high of $55,095 (MA) to a low of $31,083 (MS). Per capita PCE in D.C. $63,151. Use the interactive table to example per capita and total PCE by state for 24 categories annually 2010 to 2018.

Per Capita Personal Consumption Expenditures by Category; U.S. 2018
— how does your situation and areas of interest compare to U.S. overall?
— view, sort, query by state and year in the interactive table

Goods and services purchased by people are personal consumption expenditures (PCE). These data provide insights into the strength of a state economy and consumer buying trends. As a major component of GDP, PCE growth has recently accounted for much of the GDP growth. The data reviewed in this section are developed by the Bureau of Economic Analysis (BEA, released each October). ProximityOne develops regional PCE estimates by metro and county. More about PCE.

See related sections:
• State Real Median Household Income
• State Annual Gross Domestic Product by Industry

Per Capita Consumption Expenditures by State, 2018
The following graphic shows patterns of 2018 per capita personal income expenditures (PCE). Intervals show distribution in quintiles, equal number of states per interval. The 2018 U.S. per capita PCE was $42,757. Use CV XE GIS project to examine PCE by types, per cpaita vs total, different years and change. Integrate additional subject matter and types of geography. Click graphic for larger view with details. Expand browser window for bets quality view.

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

Using the Interactive Table
— which areas have the highest health care expenditures?
Use the interactive table to examine personal consumption expenditures by type and state annually for the period 2010-2018. The following view illustrates use of the table. This view shows use a query to examine only health care expenditures. The table was then sorted in descending order to show the areas with the highest per capita health care expenditures in 2018.

Try using the interactive table to existing states or categories 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.

Examining HMDA/CRA Census Tract Demographics

.. the ability to effectively analyze low, moderate, middle, and upper income 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. See the main Web page for more detail.

This section reviews the scope and use of the FFIEC 2019 HMDA/CRA census tract data (released September 2019). Use the interactive table to view, rank, compare selected items from these updated data for any/all tracts. Use GIS tools with these data to map and geospatially analyze these data as illustrated and further described as illustrated here. See more about banking, CRA and LMI tracts and more about these data.

Visual Analysis of Banks in Context Census Tract Demographics
Click graphic for larger view; expand browser window for best quality view.

– view developed using CV XE GIS and related GIS project.
– install this GIS tool and related GIS project on your computer to examines patterns, market share and more.

Low & Moderate Income Population by Census Tract
Low, moderate, middle, upper income classification by census tract is based on the median family income of a specific census tract relative to the metropolitan statistical area (MSA) or non-MSA area in which the tract is located. The FFIEC data include a “low and moderate income indicator”:
1 – Low — MFI is less than 50% of the MSA/parent area MFI
2 – Moderate — MFI is from 50% to 80% of the MSA/parent area MFI
3 – Middle — MFI is from 80% to 120% of the MSA/parent area MFI
4 – Upper — MFI is 120% or more of the MSA/parent area MFI
0 – NA — MFI is 0 or not available
where MFI is the Median Family Income

Low and moderate income designation is closely associated with implementation of the Home Mortgage Disclosure Act (HMDA) and the Community Reinvestment Act (CRA) and is a widely used in many other applications as a measure of economic prosperity.

Using the Interactive Table
Use the interactive table to examine individual tracts or sets of tracts as to their low and moderate income status and related demographics. The following view illustrates use of the table. Clicking buttons below table, this sequence of steps was used to obtain this view:
– click ShowAll
– click “Find CBSA; Low & Mod Tracts”
  >this selects tract in CBSA 26420 (Houston) that are low or mod
– click “Status Cols”
The table refreshes to show 470 tracts that are low/mod in this metro.
Finally, click the column header “Tract MFI %Region” to sort in descending order.

View your areas of interest. Start the steps over and use your CBSA code for a metro of interest.

Bankers Analytics Tools Web Sessions
Join me in a Bankers Analytic Tools Lab session (every Wednesday 3:00 pm ET) 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.
Topics:
• mapping and geospatially analyzing your data with FFIEC data
• tract demographic vintages and trends
• issues regarding MSA/MD vintage, change; about the 2018 vintage CBSAs
• defining and using assessment area geography
• examining the community & neighborhoods in context of assessment areas
• using the FDIC bank location/deposits data with FFIEC/ACS demographics
• using the FFIEC/ACS interactive table below
• alternative methods of accessing census tract ACS data

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.

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.

Census Tract Demographic-Economic Characteristics & Trends

..  Census tract demographics are used in wide-ranging public and private sector applications to examine patterns and characteristics of sub-county areas. Tract level data from Census 2000Census 2010 and the American Community Survey (ACS) can be used to analyze trade/market areas, neighborhoods and other small area study areas. But what about more current data and trends since 2010? What about business establishment data and other subject matter not included in either the census or ACS data?

There are no current demographic-economic census tract data available from the Census Bureau or other Federal statistical programs. Annually released ACS 5-year estimates are available by census tract but are for 5-year periods and dated. The most recent census tract level ACS data are based on the ACS 2017 5-year estimates (ACS 1317). Those data are not for the year 2017 but estimates for ACS survey respondents for the 5 year period 2013-2017; centric to mid-2015.

Patterns of Median Household Income %Change by Census Tract
The graphic below shows patterns of economic prosperity change based on median household income percent change ACS 2012 to ACS 2017 by tract in the Dallas metro area.

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

Using the Interactive Table
Use the interactive table .. click this link .. to view, query, rank, compare selected characteristics of the population, housing, educational attainment and income for census tracts based on ACS 2012 5-year, and ACS 2017 5-year data. Hundreds of additional items are available. See about related census tract data resources and applications.

Try it yourself ..
Tracts with ACS 2017 population 3,500-4,500 ranked on change in $MHI:
Replicate the following graphic using the interactive table. This view was produced by clicking the Pop17 button below the table to select only tracts with a ACS 2017 population between 3,500 and 4,500. Then the $MHI columns button was clicked to view only selected columns. Finally the qualifying tracts were sorted in descending order by clicking the $MHI Change column header cell.

Based on these estimates, tract 04013105004 in Maricopa County, AZ is top ranked, where the $MHI increased by $97,723 from the ACS 2012 5-year period to the ACS 2017 5-year period.

Corresponding API calls to access the $MHI for this tract (click links to access data):
ACS 2012 $MHIACS 2017 $MHI
Join us in an upcoming Data Analytics Web Session (see below) to learn more about using APIs to access these data and similar data.

Access more detailed ACS 2017 tract interactive tables:
  General demographics .. Social .. Economic .. Housing

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

Examining Economic Well-Being by Metro

.. examining the state of economic well-being: 2008-2017 .. expanding insights through data analytics .. tools and data to examine how and where the U.S. by metropolitan area real personal income is changing.  Real per capita personal income (RPCPI) is the best single measure of personal economic-well being. By examining RPCPI trends over a period, stakeholders can better determine if the area in improving, stable or declining. Still, RPCPI is but one important measure among many others, such as the Regional Price Parities (RPP). Use the interactive table, and related GIS tools, to examine these and other real personal income measures for the Nation’s 383 Metropolitan Statistical Areas (MSAs). See related Web section for more detail.

Based on data released by the Bureau of Economic Analysis in May 2019, see about in statistical release dates, real state personal income grew 2.6 percent in 2017, after increasing 1.5 percent in 2016. Real state personal income is a state’s current-dollar personal income adjusted by the state’s regional price parity and the national personal consumption expenditures price index. Across metropolitan areas, the percent change ranged from 14.8 percent in Midland, MI to -5.9 percent in Enid, OK

Visually Examining Patterns of Economic Well-Being
Geographic Information Systems (GIS) tools provide a powerful to explore these data. The following graphic shows a view of real per capita personal income (RPCPI), 2017, for Texas MSAs. Color patterns for levels of RPCPI are shown in the inset legend. MSAs are labeled with the 2017 RPCPI rank among all U.S. MSAs. Click graphic for larger view; expand browser window for best quality view. The larger view shows MSAs labeled with short name and a mini-profile for Harris County (pointer).

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

Using the Interactive table
The interactive table (click link to view/use) includes a row for the U.S., U.S. nonmetro area and each Metropolitan Statistical Area (383). Each row provides a 2008-17 annual time series for four items (and derived items): real per capita personal income, regional prices parities-all items, total real personal income, implicit regional price deflator.

The following graphic shows these areas ranked on RPCPI in 2017. See rightmost column rank. Click graphic for larger view. Midland, TX MSA has the 4th highest 2017 RPCPI (shown in blue; also shown in blue in the map graphic above). But … that metro experienced a decrease of 12.1 percent over the period 2010-2017 .. and down from a high RPCPI of $115,069 in 2014. The dynamics of the oil industry!

Data Analytics Web Sessions
See these applications live/demoed. Run the applications on your own computer.
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.