Tag Archives: interactive data access

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive table

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.

Using ACS County Data

… we are always seeking the most current data for areas of interest. This section provides an update on accessing unpublished ACS 1-year data for many counties.  Learn about how you can access ACS 1-year estimates for 85 counties for which Census released only as 5-year estimates … and why it matters. See the corresponding full Web section.

Data are tabulated from the Census Bureau American Community Survey (ACS) as 1-year estimates (for areas with population 65,000 and over) and as 5-year estimates (for areas under 65,000 population). See more about ACS 1-year versus 5-year estimates in this section.

ACS 2014 1-year tabulation areas, as released by the Census Bureau included 817 of 3142 counties and 508 of 917 metros/CBSAs. There are 85 counties for which ACS 2914 1-year estimates were not released by Census but are derivable by subtracting the aggregate county components from metro totals in selected metros.

County & Metro ACS 2014 1-year Estimates
The following graphic shows Texas and adjacent areas:
• ACS 2014 1-year estimates metros with bold brown boundaries
• Counties for which ACS 2014 1-year data were tabulated and released (green).
• Counties for which ACS 2014 1-year data are derivable but not released as tabulation areas (blue).

… view developed using the CV XE GIS software.
… click map for larger view and details.

The next view shows a zoom-in to the Austin, TX metro. The four green shaded counties had ACS 2014 1-year estimates tabulated and released. The fifth Austin metro county, Caldwell shaded blue, was not tabulated but the ACS 1-year data are derivable by subtracting the sum of the four counties from the metro totals. Tabulated data for Caldwell was released only as ACS 2014 5-year estimates. A similar situation exists in many metros across the country.

Why this Matters
There are 85 counties for which ACS 2014 1 year data are available but not released/made available by Census as separately tabulated areas. This is important due to these considerations:
• these are true annual estimates (as opposed to the other 5-year estimated counties)
• they are more recent that 5-year estimates
• they reflect conditions centric to one year
• they enable time series/trend analysis
• [as it turns out] they enable access to 1 year estimates for all counties (instead of some) in some metros

Using API Tools to Examine these Data
Create CSV-like files by clicking these links. When a link is clicked a new page will show the ACS 2014 1-year estimates tabulations areas. The area name, code and ACS 2014 1-year total population estimate is shown.
Click to retrieve county data
Click to retrieve metro data

Items used in these API calls:
.. B01001_001E – Total population
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
.. B19301_001E – Per capita income

Create/derive these data on your own; learn about which counties are derivable …

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.

 

Interactive Location-Based Demographics Tool

.. have you wondered how Web sites determine the demographic-economic attributes for a location/address? Are those data for the corresponding block group, census tract, city or something else? Was it the “ZIP code area”? These areas can be 100,000 population or more making them so large that alternative geographies might be preferred. Often those important particulars — which geography and data sourcing — are vague or unknown. This section reviews use of the interactive Location-Based Demographics Tool to access data for a location based multiple, alternative types of address “container areas”. See more details in this related web section.

Any given address or location is contained with several types of statistical areas (e.g. census tract or block group) and political areas (e.g. city or county). We may want to know the demographic-economic characteristics of a location for any one or several of these geographies. Use the interactive tool on this page to access those data. For example, access/view the median household income of the location/address block group or the median household income the location/address city. Key in the address of interest, select the type of geography and click Find — see graphic below. The results are displayed on the same page.

Click this graphic to view address entry form

Profile for Census Tract
When Tract is selected as Type of Area, this profile is displayed:
(median household income is $118,827)

Profile for Block Group
When Block Group is selected as Type of Area, this profile is displayed:
(median household income is $139,342)

Creating Maps for These Geographies
See this related web section about using the MapCompiler to create map views for these block group and census tract areas in the vicinity of the default address used above (1 Infinite Loop, Cupertino, CA). Use the CV XE MapCompiler (GeoGateway feature) to create similar maps for any area 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.