Demographic Data in Data Library

INTRODUCTION

In the Data Library, we have Demographic data going back to 2001. This way users can quickly look at changes by Year for a geography. Data Library also has expanded demographics data for the 2020 and 2021 Data Year from the United States Census Bureau. 

OVERVIEW

The Demographic data are available for all counties and states in the U.S. for all IMPLAN Data Set Years. The data include, for each region and year, the number of households by 9 income categories, land area, population, population density, and Shannon-Weaver Index (S-W Index). The Shannon-Weaver Index is an index of economic diversity based on the distribution of employment among all possible Industries. Population counts are obtained from the Census Bureau's Population and Housing Unit Estimates Datasets. The number of households by income group is calculated using the population data combined with data from Census tables “Household Income In The Past 12 Months” and “Average Household Size of Occupied Housing Units by Tenure”.

The Enhanced Demographic Dataset are available for all counties and states in the U.S. for all IMPLAN Data Set Years. They consist of estimates for the splits on population data related to factors such as age, sex, race, ethnicity, language spoken at home, and educational attainment. They also include estimates on Housing Occupancy and Vacancy, and Labor Force Participation Rates and Unemployment Rates by Age and Race. Note that currently this expanded demographic data is only for the 2020 and 2021 IMPLAN Data Year. 

DASHBOARDS

DEMOGRAPHICS COMPARE DASHBOARD

This Dashboard includes 4 tiles:  

  • Year over Year is a line chart showing the filtered Metric over Data Years for the filter Region(s).  
  • County View is a map chart of the filtered Metric by Five Digit Fips (this is the county code Looker uses to map the data). 
  • Demographics Table is a table chart of each possible Measure/Metric by state.
  • Households by Income Range is a table chart of the number of households in each Household Income Range by state.

 

When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:

  • Dollar Type: by default dollars are displayed in Real dollars, see Dollar Year
  • Data Year: most recent Data Year by default in County View and Commodity Table tiles. All available Data Years are displayed in the Year over Year tile (filter does not apply to this tile).
  • Dollar Year: by default dollars are shown in current-year dollars 
  • State: no default set. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.
  • County: no county filter is set by default
  • Metric: by default Households, options include all Measures in this Data Library Section

DEMOGRAPHICS DASHBOARD

This Dashboard includes 10 tiles:  

  • Language Spoken at home is a table chart for the language spoken by the population within the filtered Region.
  • Housing: Occupancy and Vacancy is a table chart for the occupancy/vacancy of the population within the filtered Region.
  • Age and Sex is a table chart for the age and sex of the population within the filtered Region.
  • Race and Ethnicity is a table chart for the race and ethnicity of the population within the filtered Region. 
  • Educational Attainment Ages 18-24 is a table chart for the educational attainment of the population ages 18-24 within the filtered Region. 
  • Educational Attainment Ages 25+ is a table chart for the educational attainment of the population ages 25+ within the filtered Region. 
  • Labor Force Participation: By Race is a table chart for the labor force participation rates by race for the population within the filtered Region.
  • Unemployment: Rate by Race is a table chart for the unemployment rates by race for the population within the filtered Region.
  • Labor Force Participation Rate: By Age is a table chart for the labor force participation rates by age for the population within the filtered Region.
  • Unemployment Rate: By Age is a table chart for the unemployment rates by age for the population within the filtered Region.

When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:

  • Region: by default set to North Carolina

The Dashboard Actions in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Tile actions (a series of three vertical dots that appear in the upper right of a tile when hovering over it with a cursor) for the option to download the data within that tile. Select Explore from here within the Tile actions to access more data query options. Exploring from the Dashboard allows users to dig into the data starting from the settings within the Dashboard tile. 

EXPLORE

Explore the Demographic Data by selecting Demographic Data from the Explore dropdown menu, or by selecting Explore from here from a Demographic Data Dashboard Tile or Look. Note that while the expanded demographic data within the Demographics Dashboard can be Explored, there will be no expanded Demographic Dimensions or Measures within the Demographics Explore itself. 

By default in Explore, the Dollar Type is Real, the Dollar Year is the current year, and the Data Year is the most recent Data Year. With this setting, all dollar values included in a data query will be adjusted for inflation and displayed in current year dollars. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years. Region Type is by default State. Data queries will include State level tax data with this setting. 

FILTER-ONLY FIELDS

DOLLAR TYPE

When Dollar Type is Real, Nominal dollar values are adjusted for inflation/deflation such that each dollar value Measures will be displayed in the selected Dollar Year(s).  Dollar Year only applies when Dollar Type is Real. 

When Dollar Type is Nominal, dollar value Measures will be unadjusted, therefore they will be displayed in the same Dollar Year as the Data Year.

FIELD PICKER

The Field Picker allows users to pick any one of the Measures from the filter dropdown menu. The Measure titled “Metric” to do so is tied to the Field Picker.  Select, filter, and/or pivot on this measure in order to include in data query. 

DIMENSIONS

Select a Dimension to include as a column with all Dimension possibilities.

 

Click Filter on a Dimension to specify which Dimension possibilities appear in the data query. 

Click Pivot on a Dimension to transpose the Dimension rows into columns. 

Dimensions Details
County

All U.S. counties are possible Dimensions. 

When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected.

County Fips

A County Fips is a three digit county code designated to counties within a given state. 

All U.S. County Fips are possible Dimensions. Note, County Fips are not state specific, therefore it is recommended to include and/or filter on the State Dimension in addition to this Dimension. A list of FIPS codes can be found at the following link: 

https://www.census.gov/library/reference/code-lists/ansi.html#top

Data Year All IMPLAN Data Years are possible Dimensions.
Dollar Year Years 1997 through 2060 are possible Dimensions. Dollar Year only applies when Dollar Type is Real. 
Five Digit Fips

A Five Digit Fips is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit Fips codes are possible Dimensions. 

This Dimension is used to map the data in the County View Map Chart found on the Dashboard.  A list of FIPS codes can be found at the following link: 

 

https://www.census.gov/library/reference/code-lists/ansi.html#top

Household All Household Income groups (Code and Description) are possible Dimensions.
Household Code  All Household Income group codes are possible Dimensions.
Household Description  All Household Income group Descriptions (listing income ranges by group) are possible Dimensions.
Region 

All 50 States plus the District of Columbia are possible Dimensions. 

 

Pivoting or selecting Region will display filtered states when filtering on state and will display filtered counties when filtering on county. 

Shannon Weaver Index County level Shannon Weaver Indexes are possible Dimensions. This is not available at the State level. 
State All 50 States plus the District of Columbia are possible Dimensions. 
State Fips

A State Fips is a two digit state code. State Fips for all 50 States plus the District of Columbia are possible Dimensions. A list of FIPS codes can be found at the following link: 

https://www.census.gov/library/reference/code-lists/ansi.html#top

 

 

MEASURES

Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query. 

Measures Details
Households Count of households.
Land Area Area in square miles.
Metric Metric is recommended to be selected in conjunction with a Field Picker filter (a Filter-Only Field). This is a helpful Dashboard option. 
Population Count of residents.
Population Density Ratio of population to land area. Count of residents per square mile.
Total Personal Income

Total Personal Income is based on the Bureau of Economic Analysis (BEA) definition of Personal Income. Personal Income is all household income receipts except from commodity sales and borrowing. BEA Personal Income includes imputed income, adjustments for misreporting and under-reporting, and employment paid benefits. 

 

 

RELATED ARTICLES

IMPLAN Data Library

Explores - Looks - Dashboards

2021 Demographic Expansion Release Notes

Written August 30, 2023