D3 is excited to announce a new version of State of the Detroit Child (SDC) tool which features an updated home page, new capabilities, and access to new datasets! The new capabilities will include time trend data for the geographic profiles and tools to draw your own geography on a map to create a custom profile! The new datasets span health and education data from elevated blood lead levels and immunization rates to college readiness and progression. There are also some new Wayne County and Detroit focused geographies built into the tool now such as Wayne County Commissioner districts. You can jump right into the tool, learn how to use it, or keep reading to find out what we added!
The new homepage requires less scrolling so you can get to the data you need faster. You can now toggle between the three main methods of accessing data. First, explore critical questions facing Detroit kids and jump straight to the data that provides the answers. Second, explore the data yourself by searching for a city, zipcode, or other geography in the search bar, searching by a street address or creating your own geographic profile, or browsing a gallery of custom profiles other users have created with the new drawing tool. Third, explore the topic areas that are included in SDC to better understand our data sources and what is available in the tool.
Time Series Data
Our early user testing and workshops highlighted that many people wanted to compare trends over time, especially when considering neighborhood-specific programming. Understanding these changes is important for contextualizing certain problems and measuring progress.
The addition of time series data to SDC’s profiles allows you to compare the most recent year of data with its 5 year comparison, i.e. when we start showing 2018 data, it will be compared to 2013 data where available. All American Community Survey datasets will be included in the time series profiles. Non-ACS datasets (e.g. Michigan Department of Health and Human Services or Great Start to Quality) will be added in future iterations of the tool.
The functionality of the profile pages remains the same so you’ll be able to explore the data at a more granular level by clicking “show data”. You’ll also be able to download both years of data after clicking on the “show table” option. These datasets can be used to allow you to dig deeper into the questions you’re trying to answer or help build out graphics in your organization’s style requirements.
Draw a Geography
Regardless of where you work and who you work with, there’s a decent chance that census geographies don’t always align with your organizational service areas. The beta SDC version further complicated the issue by not allowing for easy aggregations of multiple geographies. For example, if an organization served two census tracts, aggregations had to be done manually.
We’re rolling out a new feature in SDC 2.0 that will automatically aggregate geographies based on your selection. All you have to do is select the aggregation level (i.e. census tract, zip code, school district, city, etc.) and then trace the outline of the area you’re interested in!
The tool will autoselect included geographies and give you a chance to refine the selection before creating a customized profile page. You must name your profile page, which creates a custom URL that enables you to return to the profile whenever you need to. You can also create a profile for non-contiguous areas.
You’ll also be able to explore a gallery of the geographic profiles that other people have created!
We’ve been busy adding additional data sources since the launch of SDC in March 2018. Many of these state-level data sets are publicly available already, but now they are cleaned and aggregated to the geography of your choice and ready to go!
The newer datasets cover a number of topics related to health and education for kids and young people. New health datasets include hospital visits through Medicaid, immunization rates, and children with elevated blood lead levels. Education data in this release includes college readiness and progression, child care facilities, chronic absenteeism, student mobility, and 8th grade math proficiencies.
We hope these new datasets and features will help you further your important work in Detroit and in Michigan. We would love for you to share with us how you’re using this new data in your work!
Since these features are brand new, we would love your feedback on what works and what doesn’t. Please submit questions and issues to email@example.com.
Keep an eye on our social media accounts over the next few months as we explore some of the different ways this data can be used across Michigan.