Examining How & Why Counties are Changing
- County Age-Race/Ethnicity-Gender Population Patterns & Trends
Age-Race/Ethnicity-Gender (AREG) population group data are a subset of the total population based on age, race/ethnicity and gender. Envision these data for an area (e.g., state or county) structured as a cube with these three dimensions. These data provide a composite view of how the basic demographics are structured in an area. Developed annually as estimates and projections they provide insights into how foundational elements of the population have changed, how characteristics are changing and how they might change into the future.
View illustrative reports and applications below.
Visual Analysis of County AREG Population Patterns
The following graphics illustrate how how the AREG data may be used to visually analyze the population by age-race/ethnicity-gender or the total population by race/ethnicity. The Hispanic population group is used to illustrate; similar views for any age-race/ethnicity-gender can be developed using the AREG GIS project - details below.
The graphic below shows patterns of the Hispanic population, age 25-29, as a percent of total population age 25-29 based on the 2017 estimate for the U.S. by county. Use the AREG GIS project, see below in this section, to create similar views for any combination of 5-year age group by race/origin by gender.
- Click graphic for larger view. View developed with CV XE GIS software.
The graphic below shows patterns of the total Hispanic population as a percent of total population based on the 2017 estimate for the U.S. by county. Use the AREG GIS project, see below in this section, to create similar views for any combination of 5-year age group by race/origin by gender.
- Click graphic for larger view. View developed with CV XE GIS software.
The focus of this section. The Census Bureau develops annual U.S. by county population estimates by population group. The 2017 estimates were released in June 2018. The 2018 estimates will be released in June 2019. With each annual release, the estimates are available annually for the period starting with 2010. With the June 2018 release, annual estimates are available for 2010 through 2018.
Augmenting the Census-Sourced Data
Census releases these more detailed estimates by population group by county. It is left to the user to aggregate these data into various county groups and regions.
We have restructured the data and developed a single national file that includes the data for each county, CBSA/Metro, state and the U.S. Using the PopTrends Windows tool, the data can be, for example, loaded for any area, e.g. county, as a data cube. The data cube dimensions can be/are represnted as array P[1..10,0..18,1..73] where the cell P[i,j,k] is the ith data year, jth 5-year age group and kth race-ethnicity/gender combination (see list of 73 combinations below). P[10,18,1] is the 2017 population (i=10) for age group 18 (ages 85 up, j=18) for the total population (k=1) which is for all race-ethnicity/gender combinations.
Projections. We further augment the P array for i=11 (2018) to i=53 (2060) iterated for each of the 18 age groups iterated for 17 of the race/ethnicity-gender combinations.
PopTrends Software. The PopTrends Windows software is used in combination with the AREG database. The PopTrends software can load the P array for any geographic area. As a result, the P array cells maybe be access and used analytically down to a cell, for a single, two or three dimension array. Part or all of the P array can be used in combination with the P array for selected or all geographic areas.
PopTrends Profiles/Tables/Extracts. The following examples illustrate how the data can be output for simple tabular displays in HTML format. Alternatively access in Excel structure. Use PopTrends to:
- view these structured data in a spreadgrid dynamically (no need to save as file).
- use comparative analysis feature to view one area (e.g. county) in context of another area (e.g., metro).
- export selected data, integrated with shapefile, for pattern maps and geospatial analysis.
- export a P array as an Excel file for selected areas.
Table 1. -- Age (rows) by Race/Origin (cols) for a gender for a year/period
Harris County, TX (Houston) 2017 Estimates Table 1T - total population
Harris County, TX (Houston) 2017 Estimates Table 1M - male
Harris County, TX (Houston) 2017 Estimates Table 1F - female
.. above illustrations use 2017 data; choose any year 2010 forward
Table 2. -- Age (rows) by Year, 2010-2017 (cols) for a gender for a race/origin
Harris County, TX Table 2T - total population
Harris County, TX Table 2M - male
Harris County, TX Table 2WT - White alone - total
Harris County, TX Table 2WM - White alone - male
Harris County, TX Table 2BT - Black alone - total
Harris County, TX Table 2BM - Black alone - male
Harris County, TX Table 2AIANT - AIAN alone - total
Harris County, TX Table 2AIANM - AIAN alone - male
Harris County, TX Table 2AsianT - Asian alone - total
Harris County, TX Table 2AsianM - Asian alone - male
Harris County, TX Table 2NHOPIT - NHOPI alone - total
Harris County, TX Table 2NHOPIM - NHOPI alone - male
Harris County, TX Table 2Two+T - NHOPI alone - total
Harris County, TX Table 2Two+M - NHOPI alone - male
Harris County, TX Table 2HispanicT - Hispanic - total
Harris County, TX Table 2HispanicM - Hispanic - male
Table 3. -- Race/Origin (rows) by Year, 2010-2017 (cols) for a gender
Table 4. -- Across user selected geography; one row per area. 2010-2017 (cols) for a gender for a race/origin
AIAN -- American Indian/Alaska Native
NHOPI -- Native Hawaiian & Other Pacific Islander
Race/Origin by Gender Population Groups
Notes about these categories.
"In combination" -- refers to a population of one race in combination with one or more other races.
Hispanic origin is considered an ethnicity, not a race. Hispanics may be of any race.
1 = 4/1/2010 Census population
2 = 4/1/2010 population estimates base
3 = 7/1/2010 population estimate
4 = 7/1/2011 population estimate
5 = 7/1/2012 population estimate
6 = 7/1/2013 population estimate
7 = 7/1/2014 population estimate
8 = 7/1/2015 population estimate
9 = 7/1/2016 population estimate
10 = 7/1/2017 population estimate
00 = Total
01 = Age 0 to 4 years
02 = Age 5 to 9 years
03 = Age 10 to 14 years
04 = Age 15 to 19 years
05 = Age 20 to 24 years
06 = Age 25 to 29 years
07 = Age 30 to 34 years
08 = Age 35 to 39 years
09 = Age 40 to 44 years
10 = Age 45 to 49 years
11 = Age 50 to 54 years
12 = Age 55 to 59 years
13 = Age 60 to 64 years
14 = Age 65 to 69 years
15 = Age 70 to 74 years
16 = Age 75 to 79 years
17 = Age 80 to 84 years
18 = Age 85 years or older
AREG GIS Project & Datasets -- Creating Map Pattern Views & Visual Analysis .. goto top
1. Available to members of the MSDGroup
... assumes CV XE GIS Level 1 or higher installed
2. Download the U.S. by County AREG GIS project fileset
... requires your MSDGroup ID
... create the local folder local folder c:\msd\areg
... unzip AREG GIS project files to local folder c:\msd\areg
3. Open the AREG GIS project
... after completing the above steps, click File>Open>Dialog
... open the file named c:\msd\areg\us1_areg2017.gis
4. Done. The start-up view is similar to the view shown at the top of this section.
ProximityOne User Group
Join the ProximityOne User Group to keep up-to-date with new developments relating to metros and component geography decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group.
Support Using these Resources
Learn more about census tract demographic economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.
ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact ProximityOne (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.