Pinpointing Diabetes Prevalence and Clinical Research Sites 4

Click the image to view the full interactive map.

Did you know that in 2013 approximately 382 million people worldwide were living with diabetes? Prevalence is third highest in the U.S., where 22.1 million people were living with diabetes in 2011. That’s an increase of 39.5 percent since 2004. Though diabetes is common and rising in prevalence, individual awareness is low, both internationally and in the U.S. Awareness is key to preventing and managing diabetes. Internationally, 46 percent of diabetes cases are undiagnosed. In the U.S., one in four diabetics do not know they have diabetes. And only one in 10 of the 86 million pre-diabetic U.S. adults know about their condition.  Without weight loss and moderate physical activity, 15 to 30 percent of those with pre-diabetes will develop Type 2 diabetes within five years. Once people become diabetic, they are at higher risk of serious health complications and their medical expenses become twice as high.

Celebrating World Diabetes Day and American Diabetes Month

Two diabetes advocacy efforts—American Diabetes Month and World Diabetes Day— occur every November. The International Diabetes Federation (IDF) and World Health Organization (WHO) founded World Diabetes Day in 1991 to bring greater awareness to diabetes and help increase advocacy on behalf of those who are experiencing it. It  is celebrated every year on November 14th, marking the birthday of Frederick Banting. Banting, along with Charles Best, conceived of the idea which led to the discovery of insulin. The American Diabetes Association developed American Diabetes Month to “focus the nation’s attention on the issues surrounding diabetes and the many people who are impacted by the disease.”  This year, their focus is on educating the public about healthy cooking and healthy meals. In honor of this year’s World Diabetes Day and American Diabetes Month we created an interactive map illustrating the U.S. prevalence of diabetes and the locations of recruiting clinical research studies. The map was created using two open, public data sources, the Centers for Disease Control (CDC) diabetes prevalence dataset and Lilly COI’s API (The Lilly COI API).

How to Use the Interactive Map

Here are some basic instructions for using our Diabetes Prevalence & Clinical Research in the U.S. interactive map:

  • The shaded areas represent county by county diabetes prevalence. If you click on a shaded area, county-level statistics appear.
  • Pins mark the locations of recruiting clinical research study sites. If an area has more than one recruiting study site, the pin contains a number representing the total sites.
  • When you click a pin with a number, the map zooms in for a more detailed view of study sites in that location. Alternatively, when you click a pin without a number, details about studies at that individual research site appear.

To customize the data that is presented to you, use the map options tab:

  • The overlay option allows you to select the type of prevalence data presented — prevalence by percent, diabetes density per square mile, or raw number of cases.
  • To filter by study intervention type, click more. You’ll then be presented with eight filtering options, including behavioral, biological, device, dietary supplement, drug, genetic, procedure, other, and none.

What did you notice while interacting with the map? What other kinds of open data mashups might be valuable? How can we make the map more useful? Share your thoughts in the comments below.


  1. Pingback: Pinpointing Diabetes Prevalence and Clinical Research Sites | CLINYS – operational excellence for life science companies

  2. Very helpful illustration for World Diabetes Day. This would be great on a global scale. Can you try mashing up Diet, Income, Education, and Weather data? It would be helpful for patients to filter trials by disease type I or II. It would also be interesting to see it by ethnicity considering the science behind intrensic and extrensic factors that may lead to the causes. Great job!

  3. Thanks Matt. The beauty of open APIs and the increasing availability of open data brings a broad spectrum of possibilities for anyone to do these sorts of mashups, with whatever open data sets are available. We did explore filtering by type 1 or 2, but unfortunately the source data was not so clean to enable that very well. Only as good as the data available, ya know. Thanks for taking a look and the kind words.

  4. Pingback: A Look Back at the Top 5 Posts of 2014 « Lilly Clinical Open Innovation

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s