Open data repositories

Free, Publicly Available Data for Download

Stand Alone data

• Adolescent Health Data
  • We will use this data on Day 2 and Day 5 see Add Health

Points of Interest (POI) data

• Safegraph Places
  • Google Places API

Mobility data

• Google Mobility Indices
• Apple Mobility Indices
• Safegraph Mobility Indices

Data with a specific focus

• Liquor licenses
  • Ohio : Liquor Control : Web Database Search
    • Let's look carefully at this data, we will illustrate the search tool and download option
  • Licensing Reports | Alcoholic Beverage Control (ca.gov)
  • Search google for other states
• Household Debt and Credit Report - FEDERAL RESERVE BANK of NEW YORK (newyorkfed.org)) data
• Consumer Complaint Database | Consumer Financial Protection Bureau
  • This is a very cool website that is totally underutilized in our field.
  • Here is an example of what we can do with the Consumer Complaints database!!
• Government sponsored racism data
  • Gentrification & Displacement
    • This website has a github repository where the data are stored. It is called the Urban Displacement Project’s GitHub
    • They have made maps for several cities including this map of Gentrification in Cleveland
    • Following their example requires really advanced programming skills, but you can still download and use the data in
  • Redlining
    • Mapping Inequality (richmond.edu)
    • Historic Redlining Scores for 2010 and 2020 US Census Tracts (openicpsr.org)
    • Mapping Redlining Grades to Today's Neighborhoods | diversitydatakids.org
  • Police data
    • Police residence: https://github.com/fivethirtyeight/data/tree/master/police-locals
    • Police killings: https://github.com/fivethirtyeight/data/tree/master/police-killings --> see how I have used these data
    • Police deaths: https://github.com/fivethirtyeight/data/tree/master/police-deaths
• Housing & Transportation data
  • Welcome to The H+T Affordability Index
    • Click here to see my explanation of this data and the maps I made of Franklin County
  • Eviction Map & Data (Version 2.0) | Eviction Lab
    • Note: it is not always easy to find the data, but you must persist. This website is no exception. See if you can locate the link to download the data before simply clicking here To access the data, you need to provide your email, a small price to pay for this rich data.
    • The data can be found in the Bootcamp/ex/Eviction folder, open it now.
  • Home Mortgage Disclosure Act (HMDA) Data | Consumer Financial Protection Bureau (consumerfinance.gov)
  • Ohio Crash Statistics System
  • The National Walkability Index
• Food
  • USDA ERS - Food Access Research Atlas
  • SNAP Retailer Data | Food and Nutrition Service (usda.gov)
• Health data
  • Center for Health and Environmental Data | Department of Public Health & Environment (colorado.gov)
  • Data | Centers for Disease Control and Prevention (cdc.gov)
    • See my note on about Analyzing Places Data
  • New Mexico Community Data Collaborative
• Housing and Urban Development
  • HUD Open Data Site (arcgis.com)
    • Racially or Ethnically Concentrated Areas of Poverty (R/ECAPs)
    • Low-Income Housing Tax Credit (LIHTC): Property Level Data
    • Location Affordability Index v1, v2 and v3
  • Urbanization index: https://github.com/fivethirtyeight/data/tree/master/urbanization-index
  • National Center for Homelessness: https://nche.ed.gov/data/
• SAMSHA Home - FindTreatment.gov
  • I used these data to calculate accessibility to SAMSHA behavioral health centers for a 20 min travel time by public transit + walking in San Francisco
• Environmental Health Hazards Index
• Child Maltreatment
  •  Child Opportunity Index: COI
  • National Data Archive on Child Abuse and Neglect (you need to request access but it is not a difficult process)
    • NSCAW I and II
      • I used this data for this paper Trajectories of post-traumatic stress and externalizing psychopathology among maltreated foster care youth_ A parallel process latent growth curve model (sciencedirectassets.com) and also here Longitudinal growth of post-traumatic stress and depressive symptoms following a child maltreatment allegation: An examination of violence exposure, family risk and placement type - ScienceDirect
    • AFCARS (multiple years)
    • Multisite Evaluation of Foster Youth Programs (Chaffee Independent Living Evaluation Project (2001-2010))
      • I used this data for this paper A network analysis of post-traumatic stress among youth aging out of the foster care system - ScienceDirect and also here Early Child Adversity and Delinquent Behavior in Foster Care Youth: Do Future Expectations and Sexual Identity Moderate the Mediating Role of Posttraumatic Stress? | SpringerLink
• Census Bureau
  • National Survey of Child Health - Data Resource Center for Child and Adolescent Health NSCH
  • Household Pulse Survey Data Tables
    • I was working on a project about debt in Colorado and I wanted to use these files, but I did not want to download and unzip them by hand, so I wrote a script in R that automatically finds the data on the webpage, downloads it for each year, unzips them after they are downloaded, and makes a couple of graphs. You can take a look at the script here Household Pulse Survey Data Tables
  • Georeferenced Census Data
    • Neighborhood Atlas - Home (wisc.edu)
    • CDC/ATSDR Social Vulnerability Index (SVI)
• Migration data portal: https://migrationdataportal.org/data?i=stockabs&t=2019
• Global data on human trafficking: https://www.ctdatacollaborative.org
• The Innocence Project
• The national registry of exonerations: https://www.law.umich.edu/special/exoneration/Pages/detaillist.aspx
• Gun violence archive: https://www.gunviolencearchive.org/charts-and-maps

Data Collections

• ICPSR (umich.edu)
• Government open data portals
  • LA: Information, Insights, and Analysis from the City of Angels | Los Angeles - Open Data Portal
    • See A note on data mining with an example using this data
  • Open Data | City of Austin Texas | Open Data | City of Austin Texas
  • Open Data DC
• Environmental Data
  • Open Data | US EPA
  • Ohio Environmental Protection Agency (arcgis.com)
  • Environmental Mapping Tools and Data | CalEPA
    • My favorite: Pollution and Prejudice (arcgis.com)
• Data repositories
  • San Diego Regional Data Library – Providing Data For Civic and Social Development (sandiegodata.org)
    • Here is an example of how I used this data: San Diego Regional Data Library data example
  • Data and evidence to advance upward mobility and equity | Urban Institute
    • Education data explorer: https://educationdata.urban.org/data-explorer/
    • Rental Assistance Priority Index
    • Estimated Low Income Jobs Lost to COVID-19
    • State-by-State Spending on Kids Dataset
    • Medicaid Spending and Prescriptions for the Treatment of Opioid Use Disorder and Opioid Overdose

Examples of Datasets and their Uses