Category Archives: Census 2010

State of the States: 2019

.. the State of the States reports and information service provide insights into demographic, economic & business characteristics.  Unique in their composition,  updated daily/weekly, the reports summarize what’s changing where & when and assessing what’s ahead. It organizes disparate Federal statistical data and presents those data in an organized, consumable manner. A resource to help determine how change might affect you, it is an indispensable resource for investors, leaders, policymakers, researchers and decision-makers. See State of the States main section for more information.  Your briefing notes, organized by state.

Some details .. the U.S. economy is slowing, dragged down by trade tensions and weak growth overseas. But there are few signs that the decade-long expansion is on the verge of stalling out. Real Gross Domestic Product (RGDP), the broadest measure of goods and services produced in the economy, rose at a 2.1 percent annual rate in 2019Q2, down from 3.1 percent in 2019Q1, according to preliminary data released by the Bureau of Economic Analysis on 7/26/19.

But what about the states, and what about related measures? In Texas, the 2019Q1 change from 2018Q4 was 5.1 percent annual rate. Texas ranked 2nd among all states. The 2019Q2 state GDP will be posted in section 6.5 on Nov. 7, 2019 (see in scheduled updates). How does Texas compare to other states and the U.S.  Answers are organized in the reports.  Create insights. Share with others.

Part of a multi-dimensional information resource, the state of the states report has been derived from the Situation & Outlook (S&O) database, updated daily. ProximityOne uses the historical S&O database to develop current demographic-economic estimate and projections.

View the U.S. or a State Report .. click a link
.. illustrative reports .. see more about report structure & options in report.
United States
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin

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.

Employment by Occupation by Census Tract; 5-Year Trends

.. data and tools to examine patterns of employment by occupation by census tract and 5-year change .. the U.S. civilian employed population increased from 142.9 million in 2012 to 155.1 million in 2017, an increase of 12.1 million (8.5%) based on the American Community Survey (ACS) 1-year estimates. See this table to see how the employed population were distributed by occupation in 2012, 2017 and the 5-year change. How did your neighborhoods or market/service areas of interest change over the past 5 years? How will occupational employment patterns by tract/neighborhood change between now and 2023?

Patterns of Percent Employed in Health Occupations by Census Tract
The following graphic shows patterns of the employed population in health occupations as a percent of total civilian employed population ages 16 and over in the Minneapolis-St. Paul metro. This view uses the occupational category MBSA40 Healthcare practitioners and technical listed in scroll section below. Tracts with blue or green pattern exceed the national average as shown in national table. Click graphic for larger view, more detail (shows schools layer) and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools. View related graphic showing tract with the largest employment in the “Healthcare practitioners and technical” occupational group among all tracts.

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

Drill-down to Census Tract Level
Examining patterns of employment by occupation, for the same scope of subject matter, at the sub-county level can provide more insights. What is the size of the employment for a selected occupation in a neighborhood or market/service area of interest? How has the size of an occupational group by census tract changed over the past five years? How do these patterns rank/compare by tract in a particular state, metro or county? Data on employment by occupational category from the Federal statistical system on a U.S. national scale for counties, cities and census tracts are only available from the American Community Survey (ACS).

Use tools, resources and methods described here to access, integrate and analyze employment by occupation for the U.S. by census tract. Use the interactive table to view, query, rank, compare census tract occupational characteristics, patterns and trends. Data are based on the American Community Survey (ACS) 2017 5-year estimates.

Related sections with census tract interactive tables:
– General Demographics .. Social .. Economic .. Housing 

Current Estimates & Projections
ACS tract/small area estimates lag by four years or more between the current year and reference year. ACS does not produce current year annual estimates but estimates based on a 5-year period. The 2017 ACS estimates are centric to 2015. Use the ProximityOne annual tract estimates and projections 2010 through 2023 for current year (e.g., characteristics as of 2018) estimates and anticipated change 5 years ahead.

Using the Interactive Table
An example of using the interactive table to view, query, rank, compare census tract occupational characteristics, patterns and trends is shown by the graphic presented below. The table shows 6 columns of employment data for all tracts in Harris County, TX. The table is ranked on the ACS 2017 health occupations employment (MBSA40) column. Tract 48-201-312600 had largest ACS 2017 health employment of 1,078 among all tracts in the county. Compare to 2012 patterns. Use settings below table to develop a similar view your geography and occupations of interest.

Occupational Categories
The interactive table includes occupational categories listed below.
Total population
Total Civilian employed population 16 years and over
MBSA00 . Management, business, science, and arts
MBSA10 . . Management, business, and financial
MBSA11 . . . Management
MNSA12 . . . Business and financial operations
MBSA20 . . Computer, engineering, and science
MBSA21 . . . Computer and mathematical
MBSA22 . . . Architecture and engineering
MBSA23 . . . Life, physical, and social science
MBSA30 .. Education, legal, community service, arts, and media
MBSA31 … Community and social service
MBSA32 … Legal
MBSA34 … Education, training, and library
MBSA35 … Arts, design, entertainment, sports, and media
MBSA40 .. Healthcare practitioners and technical
MBSA41 … Health diagnosing & treating practitioners & other tech
MBSA42 … Health technologists and technicians
SVC00 . Service
SVC10 . . Healthcare support
SVC20 . . Protective service
SVC21 . . . Fire fighting/prevention & other protective services
SVC22 . . . Law enforcement workers including supervisors
SVC30 . . Food preparation and serving related
SVC40 . . Building and grounds cleaning and maintenance
SVC50 . . Personal care and service
SOF00 . Sales and office
SOF10 . . Sales and related
SOF20 . . Office and administrative support
NRC00 . Natural resources, construction, and maintenance
NRC10 . . Farming, fishing, and forestry
NRC20 . . Construction and extraction
NRC30 . . Installation, maintenance, and repair
PTM00 . Production, transportation, and material moving
PTM10 . . Transportation
PTM20 . . Material moving

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.

Census 2020 P.L. 94-171 Redistricting Data Updates

.. we are just two years away from the first census block level data from Census 2020.  The initial block level data will be the P.L. 94-171 redistricting data.  But before that, the initial Census 2020 TIGER/Line shapefiles/GIS files, the geography, will become available in November 2020, maybe earlier.  Stakeholders will be able to see how block and tract codes and geography have changed in many areas since 2010.  The prototype P.L. 94-171 data (see final file layout and subject matter items) are expected in the last week of March 2019 and will cover the Providence County, RI area. This post shows illustrative views and related details about the area. The Census 2020 P.L. 94-171 program and plans are reviewed in this Federal Register notice.

The applications/views shown below have been developed using the ProximityOne CV XE GIS software and related GIS project.

Census 2020 Data Access and Use Program
ProximityOne operates a comprehensive Census 2020 Data Access and Use Program providing tools to integrate and analyze these data with other data for redistricting, planning, evaluation, management, general analysis and policy-related applications. Contact us for more information; mention Census 2020 Data Access and Use Program in text section.

Providence, RI Census 2020 P.L. 94-171 Prototype
The Census 2020 P.L. 94-171 prototype covers Providence County, RI, part of the Providence-Warwick, RI-MA MSA (39300) — see Situation& Outlook report. Providence County is shown with cross-hatch pattern in the following graphic.

The next graphic shows a zoom-in to the county with cities/places shown with green fill pattern.

The next graphic shows patterns of economic prosperity for the county based on ACS 2017 median household income by census tract — blue, higher and red, lower.

The next graphic shows Census 2010 blocks for the county. Demographics described in the P.L. 94-171 file described about will be provided at the census block level.

Census block boundaries are primarily defined by roads. Providence County roads are shown in the next view.

The next view shows a zoom-in to the downtown Providence city area. Census blocks are shown with red boundaries and labeled with the 15-character U.S. national scope unique census block code. The pointer is located in census block 440070012001001, or 44-007-001200-1001, expressed as SS-CCC_TTTTTT-BBBB. Access these Census 2010 data (an example) using the Census FactFinder tool via this link. This is the “P1 RACE” table. The Census 2010 population of the block was 598. This census block is one of 13,597 Census 2010 census blocks comprising Providence County.

Rhode Island 116th Congressional Districts 01 and 02 (labeled) split Providence city (cross-hatch pattern) as shown in the graphic below. Pointer shows CD boundary.

Similar to above, the graphic below shows census blocks in context of Providence city (bold green boundary) and CDs 01 and 02.

Next Steps
This section provides a geographic orientation the Census 2020 P.L. 94-171 prototype area. A subsequent post (March 2019) will extend on this post with Census 2020 P.L. 94-171 data and related details. Use the downloadable project and software to examine geodemographics and redistricting operations.

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.

 

How the New York Metro is Changing

.. or more precisely, how the New York Metropolitan Statistical Area (MSA) is changing. As of Census 2010 the New York MSA (officially the New York-Newark-Jersey City, NY-NJ-PA MSA) consisted of 20 counties. With the new OMB metropolitan statistical areas defined as of February 2013, the New York MSA became 22 counties, absorbing the Poughkeepsie, NY MSA two counties (Dutchess and Orange). The Poughkeepie MSA was removed from the official MSAs. The delineation remained that way until the new September 2018 delineations when the Census 2010 delineation was restored. Now, the Poughkeepsie, NY MSA exists as a 2 county area and the New York MSA exists as a 20 county area (both as they existed geographically in Census 2010).

These metro-county relationships are shown in the graphic presented below. The Poughkeepsie, NY MSA is shown with the blue cross-hatch to the north and the New York MSA is shown with the salmon color pattern.

– view developed using the CV XE GIS software and related GIS project.
– see the related New York Metro Situation & Outlook report.

What Difference Does it Make?
A lot! First, during the interim period 2013-2018, the Poughkeepsie, NY MSA lost the metropolitan area identity/status as conferred by the OMB delineations. It might have been omitted from size class market development and research analyses. Related, that metro was not included as a tabulation or estimation area of MSAs by Federal statistical agencies. An example of the impact is that the official demographic estimates for the Poughkeepsie, NY MSA developed by the Census Bureau were not tabulated as such and omitted from various statistical reports. Also, the removal of designation and now adding the designation back, creates a hiccup in the time series — affecting both the Poughkeepsie NY MSA and the New York MSA.

Detailed Demographic Profiles for New York MSA and Poughkeepsie, NY MSA
.. click link to view profile.

New York-Newark-Jersey City, NY-NJ-PA MSA
  Bergen County, NJ (34003)
  Essex County, NJ (34013)
  Hudson County, NJ (34017)
  Hunterdon County, NJ (34019)
  Middlesex County, NJ (34023)
  Monmouth County, NJ (34025)
  Morris County, NJ (34027)
  Ocean County, NJ (34029)
  Passaic County, NJ (34031)
  Somerset County, NJ (34035)
  Sussex County, NJ (34037)
  Union County, NJ (34039)
  Bronx County, NY (36005)
  Kings County, NY (36047)
  Nassau County, NY (36059)
  New York County, NY (36061)
  Putnam County, NY (36079)
  Queens County, NY (36081)
  Richmond County, NY (36085)
  Rockland County, NY (36087)
  Suffolk County, NY (36103)
  Westchester County, NY (36119)
  Pike County, PA (42103)

Poughkeepsie-Newburgh-Middletown, NY (CBSA 39100)
  Dutchess County, NY (36027)
  Orange County, NY (36071)

Looking Forward
The September 2018 CBSA delineations define counties that will be used for Census 2020 (likely, there could be yet further changes) — 384 MSAs in the U.S. In the cases of the New York MSA and the Poughkeepsie, NY MSA, it appears that the geography (component counties) used for Census 2010 will be the same as for Census 2020. Going forward, ProximityOne estimates and projections will use the most current vintage of CBSAs.

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.

U.S. House of Representatives 2020 Apportionment

.. Congressional Apportionment by State .. 2010 & projected 2020 state by state congressional seats.

What will the results of Census 2020 tell us us about how the House of Representatives will be reapportioned, state by state? This section examines scenarios which might occur based on state population projections. See related Web section http://proximityone.com/apportionment.htm for more detail and interactive table.

Use the GIS tools and project to make your own map views … see details
.. use in classroom .. research .. reference .. collaboration.

This section has been developed using
– 2020 apportionment population projections
.. part of the ProximityOne Situation & Outlook (S&O)
– the reapportionment/redistricting feature of the CV XE GIS software
The 2020 population projections reflect anticipated change under one scenario. Those values are then used in the CV XE GIS reapportionment operation to compute the number of House seats shown in the related table.

Apportionment of the U.S. House of Representatives
— based on the 2010 Census

– view created with CV XE GIS. Click graphic for larger view with more detail.

Apportionment of the U.S. House of Representatives
— based on ProximityOne 2020 Population Projections

– view created with CV XE GIS. Click graphic for larger view with more detail.

Congressional apportionment is the process of dividing the 435 memberships, or seats, in the House of Representatives among the 50 states based on the population figures collected during the decennial census. The number of seats in the House has grown with the country. Congress sets the number in law and increased the number to 435 in 1913. The Constitution set the number of representatives at 65 from 1787 until the first Census of 1790, when it was increased to 105 members. More about apportionment.

Initial Census 2020 demographic data, the apportionment data, will be released by December 31, 2020. See related Census 2010 Apportionments.

Apportionment totals were calculated by a congressionally defined formula, in accordance with Title 2 of the U.S. Code, to divide among the states the 435 seats in the U.S. House of Representatives. The apportionment population consists of the resident population of the 50 states, plus the overseas military and federal civilian employees and their dependents living with them who could be allocated to a state. Each member of the House represents, on average, about 710,767 people for Census 2010.

Using the Interactive table
The following graphic illustrates use of the 2010 & 2020 apportionment by state and historical apportionment 1910 to 2010. Sort on any column; compare apportionment patterns over time. Click graphic for larger view.
Use the interactive table at http://proximityone.com/apportionment.htm#table.

Congressional District/State Legislative District Group
Join the CDSLD Group (http://proximityone.com/cdsld.htm), a forum intended for individuals interested in accessing and using geodemographic data and analytical tools relating to voting districts, congressional districts & state legislative districts and related geography with drill-down to intersection/street segment and census block level. Receive updates on topics like that of this section.

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.

Census Block, Block Group & Census Tract GeoDemographics

Census tracts, block groups and blocks are the important small area statistical geographic areas for which data from Census 2010 are tabulated. Data for census tracts and block groups are also tabulated annually from the American Community Survey. For example. in December 2018, we will have new “richer demographics” annual estimates centric to each year 2008 through 2015 for Census 2010 tracts and block groups … data such as educational attainment, language spoken, housing and household characteristics,  income characteristics and employment and other demographic-economic attributes.

Largest Population New York City (NYC) Census Blocks
The following graphic shows the NYC Census 2010 census block having the largest Census 2010 population that is not a group quarters population block. The Lincoln Center census block shown in the graphic (red boundary) has 4,067 population and 2,922 housing units.

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

This block (36 061 015500 6000) occupies 0.033 square miles. It has a population density of 122,333 (population per square mile). The NYC block with the largest population is on Rikers Island and has a group quarters population of 8,634 and 0 housing units. For Census 2010, there were 350,169 census blocks covering the state of New York; 13,356 census blocks were water blocks. For the State of New York, as of Census 2010 the average census block population was 55 (57 excluding water blocks).

Census 2010 and Census 2020
These geographies have generally stable geographic areas and codes from one decennial census (e.g., Census 2010) to the next (e.g., Census 2020). Many of these areas will change in terms of code and area for Census 2020, though the geographic changes will typically be small or not at all.

Census 2020 block, block group and tract codes and geometry will be available in late 2020. Initial block level demographics will be available in March 2021.

Census 2010 & Current GeoDemographics
These areas cover the U.S. from wall-to-wall and generally non-changing in terms of boundary and geographic code (geocode) until Census 2020. This section provides a summary of new Web pages with more detail about each of these geographies:
census tracts and tract codes .. 73,056 areas
census block groups and block group codes .. 217,740 areas
census blocks and block codes .. 11,078,297 areas

Each of these pages provides an interactive table to view tallies of Census 2010 for each of these small area geographies.

Combining Address Data with Small Area Geography
The address of the Office of the California Secretary of State, located at 1500 11th St, Sacramento, CA 95814, was geocoded using the APIGeocoder and converted into a shapefile for Geographic Information System applications.  The location is shown as a red marker in the map views shown below, illustrating each type of small area geography: tracts. block groups and blocks.

Census Tracts
Tracts are labeled with green tract codes. Address 1500 11th St, Sacramento, CA 95814 is shown by red marker.  The address is in tract 06067001101.

View created using CV XE GIS.

Block Groups
Block groups are labeled with red block group codes.  Tract 06067001101 is comprised of block groups: 060670011011 and 060670011012.  See pointer in map view; the block group within tract boundary.

View created using CV XE GIS.

Zoom-in to Census Block
Blocks are labeled with yellow block codes. The address is located in block 060670011011085.

View created using CV XE GIS.

Further Zoom-in Showing Streets
Streets are labeled with street names. Identify tool is used to show mini-profile for 1500 block of 11th Street.

View created using CV XE GIS.

Is the tract code 11.01 or 001101?
Both. Census tracts within a county are identified by a 4-digit basic code between 0001 and 9999, and may have a 2-digit suffix ranging from .01 to .98; for example, 6059.02. The decimal point separating the 4-digit basic tract code from the 2-digit suffix is shown in Census Bureau printed reports and maps. For geo-referencing, the decimal point is implied and does not appear; the 6-character tract code with lead zeroes is used — a character string with no blanks and all numbers.

Accessing and Using these Geographies & Related Demographics
There are several ways these geographies can be used.
• The geocodes are the “handles” to access demographic-economic statistical data.
• The geographies may be visually, geospatially, related as shapefiles.
.. the Census Bureau makes these shapefiles available for use in user appications.
.. the shapefiles typically do not include demographic-economic data.

Access Census 2010 Census Block (and Block Group/Tract) data:
• P.L. 94-171 Redistricting Data — http://proximityone.com/cen2010_pl94171.htm
• Summary File 1 — http://proximityone.com/cen2010_sf1.htm

Access Census Block Group and Tract richer demographics:
• 2016 American Community Survey (ACS) 5-year estimates
  — http://proximityone.com/acs1216.htm
• Access annual counterparts to above section
• Census blocks — http://proximityone.com/cenblk.htm
• Census block groups — http://proximityone.com/blockgroups.htm
• Census tracts — http://proximityone.com/tracts.htm

Alternatively use the Census Bureau APIs or CV XE GIS APIGateway.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
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.

Redistricting & Census 2020

.. most states will not have new redistricting plans until after Census 2020. Redistricting is the process of developing a redistricting plan for 2 or more areas (districts) disjoint and contiguous that are contained within the collective area of all districts based on some criteria. Redistricting is perhaps most familiar with regard to congressional districts and state legislative districts based on a set of demographic characteristics … but may apply to many other types of geographies. This post briefly reviews the Census 2020 & Redistricting Program.

Redrawing the Pennsylvania 115th Congressional Districts
The following views show Pennsylvania 115th Congressional Districts in their gerrymandered configuration (old) and the redrawn configuration (February 2018, new). Counties shown with light gray boundary. Click graphic for larger view. Expand browser window for best quality view.
Pennsylvania 115th CDs — Old

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

Pennsylvania 115th CDs — New, redrawn February 2018

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

Census 2020 & Redistricting Program
The ProximityOne Census 2020 & Redistricting Program enables participants to engage now in preparation for redistricting based on Census 2020. Use resources and processes provided by ProximityOne and the Congressional Districts/State Legislative Districts Group (CDSLD) .. participate in hands-on redistricting for your areas of interest. We start now using Census 2010 redistricting data, current congressional districts and state legislative districts, and related data/tools. Progressively, we move toward accessing the live Census 2020 redistricting data (March 2021). There is no cost to participate. See more about the Census 2020 & Redistricting Program at http://proximityone.com/cen2020_redistricting.htm. Join the CDSLD Group via this form to receive updates on the program and begin participation.

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 the Census 2020 redistricting Program. 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.