Insights Library

Quickly find the information you need with the Insights Resource Library. Search, filter and explore resources such as Data for Decision Makers, Retail Trade Analysis, interactive dashboards and tools, all designed to provide insights to support your community.

City Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for cities in Iowa.

Population & Demographics

Housing

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
County Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for counties in Iowa.

Population & Demographics

Housing

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
County Health Data for Decision Makers

A profile of key health risk factors, conditions, status, providers and socioeconomic factors for counties in Iowa.

Health

Open in new tab Download File

Explore Data for Decision Makers
County Housing Data for Decision Makers

A profile of key housing conditions, affordability measures, and housing market characteristics for counties in Iowa.

Housing

Open in new tab Download File

Explore Data for Decision Makers
County Youth & Families Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics of Iowa.

Population & Demographics

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
State Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics of Iowa.

Population & Demographics

Housing

Income & Poverty

Open File in New Tab Download File

Explore Data for Decision Makers
City Data for Decision Makers User Guide

An overview with background information and additional resources for the topics and indicators provided in the City DDM.

Population & Demographics

Housing

Income & Poverty

Open File in New Tab Download File

Explore Data for Decision Makers
County Data for Decision Makers User Guide

An overview with background information and additional resources for the topics and indicators provided in the County DDM.

Population & Demographics

Housing

Income & Poverty

Open File in New Tab Download File

Explore Data for Decision Makers
County Health Data for Decision Makers User Guide

An overview with background information and additional resources for the topics and indicators in the health DDM.

Health

Open File in New Tab Download File

Explore Data for Decision Makers
Extension Region Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for ISU Extension and Outreach Regions.

Population & Demographics

Housing

Open in new tab Download File

Explore Data for Decision Makers
Iowa House District Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for Iowa House legislative districts.

Population & Demographics

Housing

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
Iowa Senate District Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for Iowa Senate legislative districts.

Population & Demographics

Housing

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
U.S. Congressional District Data for Decision Makers

A profile of key demographic, economic, social, and community characteristics for U.S. Congressional Districts in Iowa.

Population & Demographics

Housing

Income & Poverty

Open in new tab Download File

Explore Data for Decision Makers
City Retail Trade Analysis

Reports that provide data on the local retail conditions in Iowa's cities.

Retail Trade

Open in new tab Download File

Explore Retail Trade Analysis
County Retail Trade Analysis

Reports that provide data on the local retail conditions in Iowa's counties.

Retail Trade

Open in new tab Download File

Explore Retail Trade Analysis
Health Dashboard

An interactive dashboard showing health indicators for counties and the state of Iowa.

Health

Open File in New Tab

Explore Topic Area Dashboards
Housing Dashboard

An interactive dashboard showing housing indicators for counties and the state of Iowa.

Housing

Open File in New Tab

Explore Topic Area Dashboards
Income & Poverty Dashboard

An interactive dashboard showing income and poverty indicators for counties and the state of Iowa.

Income & Poverty

Open File in New Tab

Explore Topic Area Dashboards
Population & Demographics Dashboard

An interactive dashboard showing population and demographics indicators for counties and the state of Iowa.

Population & Demographics

Open File in New Tab

Explore Topic Area Dashboards
Workforce & Jobs Dashboard

An interactive dashboard showing indicators on workforce and jobs for counties and the state of Iowa.

Workforce & Jobs

Open File in New Tab

Explore Topic Area Dashboards
City Annual Fiscal Conditions Reports

Reports showing legislative updates, socioeconomic conditions, and revenues & expenditures trends for Iowa’s cities.

Local Government Finance

Open in new tab Download File

Explore Iowa Government Finance Initiative
City General Fund Revenues and Expenditures Reports

Reports provide a breakdown of city revenues and expenditures, in aggregate, by population ranges, and by individual community.

Local Government Finance

Open in new tab Download File

Explore Iowa Government Finance Initiative
County Annual Fiscal Conditions Reports

Reports showing legislative updates, socioeconomic conditions, and revenue & expenditure trends for Iowa’s counties.

Local Government Finance

Open in new tab Download File

Explore Iowa Government Finance Initiative
Outstanding Debt Obligation Reports

Reports break down the categories for which cities in Iowa hold debt in fiscal year 2020 reporting.

Local Government Finance

Open in new tab Download File

Explore Iowa Government Finance Initiative
The Dollar Bill Planning Tool

An Interactive dashboard that enables users to plan and visualize budgeted expenditures.

Local Government Finance

Open File in New Tab

Explore Dollar Bill Tools
The Dollar Bill Tool

An interactive dashboard that visually represents how each dollar of city revenue is allocated across budget categories.

Local Government Finance

Open File in New Tab

Explore Dollar Bill Tools
K-12 English Learners by County

An interactive dashboard showing the number of English learners by language at the county level with trends over time.

Population & Demographics

Education

Open File in New Tab

Explore Languages Spoken in Iowa
K-12 English Learners by School District

An interactive dashboard showing the number of English learners by language and school district.

Population & Demographics

Education

Open File in New Tab

Explore Languages Spoken in Iowa
Language Spoken at Home

An interactive dashboard showing languages spoken other than English at the county level.

Population & Demographics

Open File in New Tab

Explore Languages Spoken in Iowa
Languages Spoken in Iowa by K-12 English Learners

A map showing the world languages spoken by K-12 English learners by Counties in Iowa.

Population & Demographics

Open File in New Tab Download File

Explore Languages Spoken in Iowa
Migration to Iowa by Birth Country

An interactive dashboard showing the country of origin for foreign-born individuals living in Iowa and trends over time.

Population & Demographics

Open File in New Tab

Explore Languages Spoken in Iowa
Educational Attainment in Iowa: 1940 – 2021

Eighty years of education levels for Iowans are analyzed for the state and counties through visuals and tables.

Education

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Income Trends in Iowa: 1949 – 2023

This report provides, through visuals and tables, an overview of Iowa’s statewide and county-level income trends.

Income & Poverty

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Iowa Housing Trends: 1940 – 2017

This housing report explores trends for Iowa, both statewide and county-level, with maps, visuals, and tables.

Housing

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Population in Iowa, 1840 – 2020

Iowa’s statewide trends in total population since 1840 are charted in this report.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Population in Iowa’s Counties, 2000 – 2020

County-level total population changes in Iowa since the year 2000 are analyzed with maps and tables.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Population in Iowa’s Extension Regions, 2000 – 2020

This report reviews, with maps and tables, total population changes since the year 2000 in Iowa’s Extension regions.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Population in the United States, 2000 – 2020

U.S. and state total population changes since the year 2000 are analyzed using visuals and tables.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Race and Hispanic Origin in Iowa, 1980 - 2020

Visual and tables show Iowa’s forty-year population trends in race and Hispanic Origin.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Race and Hispanic or Latino in Iowa’s Counties, 2000 - 2020

Twenty years of county-level trends in race and Hispanic Origin in Iowa are reviewed with maps and tables.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
Urban and Rural Population in Iowa’s Counties, 1940 - 2020

Iowa’s statewide and county-level urban and rural populations are analyzed for sixty years with visuals and tables.

Population & Demographics

Open File in New Tab Download File

Explore Data Trend Reports & Datasets
City Data, Decennial Census 2020

This Excel file shows the 2020 and 2010 populations for Iowa’s cities along with numerical and percentage change.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
County Data, Decennial Census 2020

This Excel file shows the 2020 and 2010 populations for Iowa’s counties along with numerical and percentage change.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
Decennial Census Population Counts

Historical counts of the total population for U.S. states, Iowa’s counties, and Iowa’s incorporated cities by decade from 1850-2020.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
Detailed Census Counts by Hispanic Origin and Race Group 1980-2010

Total population by race group and race group breakouts by Hispanic origin for Iowa’s counties for 1980-2010.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
Elderly Percentage of the Population, Historical

Percentage of the total population age 65 years or older in Iowa’s counties by decade from 1930-2010.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
Urban Percentage of the Population, Historical

Percentage of the total population living in areas designated as “urban” in Iowa’s counties and states by decade from 1900-2010.

Population & Demographics

Download File

Explore Data Trend Reports & Datasets
Apples Commodity Report

Reports on production, pricing, market and consumer trends for Apples across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Avocados Commodity Report

Reports on production, pricing, market and consumer trends for Avocados across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Cheese Commodity Report

Reports on production, pricing, market and consumer trends for Cheese across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Cherries Commodity Report

Reports on production, pricing, market and consumer trends for Cherries across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Cranberries Commodity Report

Reports on production, pricing, market and consumer trends for Cranberries across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Edible Insects

Report on innovative value-added product with a focus on market potential, production considerations and opportunities for sustainable economic growth.

Food & Commodities

Open File in New Tab Download File

Explore Innovative Value-Added Product Reports
Fermented Products

Report on innovative value-added product with a focus on market potential, production considerations and opportunities for sustainable economic growth.

Food & Commodities

Open File in New Tab Download File

Explore Innovative Value-Added Product Reports
Grapes Commodity Report

Reports on production, pricing, market and consumer trends for Grapes across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Honey Commodity Report

Reports on production, pricing, market and consumer trends for Honey across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Lettuce Commodity Report

Reports on production, pricing, market and consumer trends for Lettuce across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Macadamia Commodity Report

Reports on production, pricing, market and consumer trends for Macadamia Nuts across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Millet Commodity Report

Reports on production, pricing, market and consumer trends for Millet across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Nut and Seed Butters

Report on innovative value-added product with a focus on market potential, production considerations and opportunities for sustainable economic growth.

Food & Commodities

Open File in New Tab Download File

Explore Innovative Value-Added Product Reports
Pea Protein

Report on innovative value-added product with a focus on market potential, production considerations and opportunities for sustainable economic growth.

Food & Commodities

Open File in New Tab Download File

Explore Innovative Value-Added Product Reports
Pecans Commodity Report

Reports on production, pricing, market and consumer trends for Pecans across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Potatoes Commodity Report

Reports on production, pricing, market and consumer trends for Potatoes across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Strawberries Commodity Report

Reports on production, pricing, market and consumer trends for Strawberries across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Sweet Corn Commodity Report

Reports on production, pricing, market and consumer trends for Sweet Corn across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
Tomatoes Commodity Report

Reports on production, pricing, market and consumer trends for Tomatoes across the U.S.

Food & Commodities

Open File in New Tab

Explore AgMRC Commodity Reports
1875 Andreas Atlas

Historical map layer provided and hosted by the Iowa Geographic Map Server.

Reference File

Open External Site

Explore Spatial Data Files
ArcGIS Pro: ArcGIS and Python

In this tutorial, you will run a python script that counts the number of points within a polygon.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Changing Text Case

This task sheet will go through the process of changing the text case using the field calculator and Python functions.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Connecting to ArcGIS Server

In this tasksheet you will be connecting to a REST Service and downloading data.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Connecting to Web Map Services

In this tutorial, you will be using Web Map Services (WMS) in ArcGIS Pro by connecting to the Iowa Geographic Map Server (Orthoserver).

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Creating a Layout

In this tutorial you will learn how to create and export a layout in ArcGIS Pro.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Creating a Spatial Map Series

This task sheet will utilize the Map Series tool to create a spatial map series.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Creating Random Points

In this tutorial, you will create random points with tools in ArcGIS Pro.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro Field Calculations: Area and Length

In this tutorial, you will practice adding a field to an attribute table and learn how to calculate area and length for a given polygon or line feature.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro Field Calculations: Coordinates

This task sheet will take you through the process of calculating the geometry (i.e., determining Latitude and Longitude) of the points in a shapefile.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Generating A Service Area Layer

Generating a Service Area is one method of calculating driving distance from businesses to customers and vice versa. This task sheet will be using Network Analyst tools to calculate driving distances.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Generating Desire Lines

The Desire Lines tool (available in the Business Analyst extension), helps to generate a series of line from each “customer” point to a desired “store” location.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Georeferencing a Raster Dataset

This task sheet will take you through the steps of georeferencing using the georeferencing toolbar in ArcGIS Pro.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Geotagged Photos to Point

In this tutorial you will test out the Geotagged Photos to Points tool on your own photos and learn how to match .gpx logs to photos without location metadata.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Hillshade, Slope, and Contour

In this tutorial, you will be building on a previous project to create derived images for hillshade, slope and contour lines.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Joining U.S. Census Data to a Shapefile

This tutorial will take you through the steps of joining county-level income data to a shapefile of Iowa counties.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Mapping Strava GPX Data

In this task sheet, you will learn how to download a GPX file associated with an activity from Strava and import the data into ArcGIS Pro where you will visualize the location data.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: Working with Lidar Data

For this tutorial you will be processing lidar (light detection and ranging) data.

Reference File

Open External Site

Explore Task Sheet Series
ArcGIS Pro: XY Data Points

In this tasksheet you will turn a CSV file containing UTM coordinates into points on the map.

Reference File

Open External Site

Explore Task Sheet Series
Current Iowa School Districts

Current Iowa School Districts boundary file hosted on the Iowa Geospatial Data Clearinghouse.

Reference File

Open External Site

Explore Spatial Data Files
Downloading and Preparing U.S. Census Data for Mapping

This task sheet will take you through the steps of downloading U.S. Census Bureau data and preparing the file for mapping using ArcGIS Pro.

Reference File

Open External Site

Explore Task Sheet Series
Downloading Iowa Lidar Data

In this tutorial, you will learn how to navigate and use the GeoTREE website to download lidar data.

Reference File

Open External Site

Explore Task Sheet Series
Essential Data Science: Introduction to Tableau Products

In this tutorial, you will learn about several popular Tableau products to help you choose which will be most helpful for your use cases.

Reference File

Open External Site

Explore Task Sheet Series
Getting Started with ArcGIS Online

In this tutorial, you will learn how to sign in and navigate an ArcGIS online map, find data through the ArcGIS Living Atlas of the World, edit symbology and layers, and save a project.

Reference File

Open External Site

Explore Task Sheet Series
Google Sheets: Import Tables and Lists from Websites

this tutorial details the process of how to use the ImportHTML formula and exporting the data to another file type.

Reference File

Open External Site

Explore Task Sheet Series
Intro to USGS topoBuilder

In this task sheet you will learn how to use the topoBuilder application to generate a customized map.

Reference File

Open External Site

Explore Task Sheet Series
Iowa County Boundaries

This file originated from the US Census TIGER County Boundary data. Additional attributes were added and the file hosted on the Iowa Geospatial Data Clearinghouse.

Reference File

Open External Site

Explore Spatial Data Files
Iowa Geographic Map Server Layers

free access to Iowa geographic map data through online map viewers and web map services.

Reference File

Open External Site

Explore Spatial Data Files
ISU Extension Regions Shapefile

simplified shapefile of the boundaries of the ISU Extension Regions.

Reference File

Download File

Explore Spatial Data Files
QGIS: Improving Table Joins with CSVT Files

This task sheet will teach you how to manage your comma separated value (CSV) files and improve joins by creating a CSVT file.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: An Introduction to the Tidyverse

This task sheet will briefly introduce each of the core packages of the tidyverse.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Filtering and Selecting Data with dplyr

In this task sheet you will install the Tidyverse packages, install a dataset containing demographic data and learn how to use dplyr to subset your data.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Getting Started with R and RStudio

This task sheet is the first in a series of tutorials introducing spatial data science concepts using the R programming language.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Importing CSV and Excel into Data Frames

In this task sheet you will learn how to import two common data file types into your R environment: comma separated value (CSV) files and Microsoft Excel spreadsheets.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Installing Packages with RStudio

This task sheet will show you how to install packages from CRAN and GitHub, how to load a package for use in your R session.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Joining Spatial Data with dplyr

This task sheet will cover a common action in geospatial workflows: using a join operation to enrich spatial data with non-spatial attribute data.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Mutating and Piping Data with dplyr

In this task sheet you will learn how to add new columns to a dataset with the mutate function. As well as introduce the pipe operator, %>%, which allows you to chain together functions.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Overview of the RStudio Interface

This task sheet will give an overview of the user interface and some key features of RStudio.

Reference File

Open External Site

Explore Task Sheet Series
Spatial Data Science with R: Plotting a Shapefile with sf

In this task sheet you will install and use the sf package in R to work with spatial data.

Reference File

Open External Site

Explore Task Sheet Series
ZIP Code Tabulation Areas

Iowa Extract of US Census ZIP Code Tabulation Areas or ZCTA boundary file hosted on the Iowa Geospatial Data Clearinghouse.

Reference File

Open External Site

Explore Spatial Data Files