#googlecharts

As an organization engaging in clinical research, knowing where to run your trials is critical to success. As a person interested in a health condition, you may like to know the current volume of research in your home county, as it compares to other counties across the U.S.

Fortunately, the ClinicalTrials.gov database is a rich source of data spanning back more than 10 years. Plotting this data geographically and temporally may expose some useful insights.

As we explore the following hypertension example, keep in mind that you’ll be able to choose other health conditions via the application link at the end of this post.

Bubble Chart of U.S. Hypertension Clinical Trials

By County Population, People/Trial, and Volatility

// jsData function gvisDataBubbleChartID258f6e7fd3f7 () { var data = new google.visualization.DataTable(); var datajson = [ [ "Allegheny PA", 1231527, 51.58, "<100k people/trial", 4.47 ], [ "Baltimore City MD", 823015, 48.17, "<100k people/trial", 3.38 ], [ "Broward FL", 1838844, 27, "<100k people/trial", 10.88 ], [ "Cook IL", 5240700, 65.42, "<100k people/trial", 9.75 ], [ "Cuyahoga OH", 1263154, 49.17, "<100k people/trial", 3.34 ], [ "Fulton GA", 984293, 42, "<100k people/trial", 3.36 ], [ "Hamilton OH", 804520, 45.67, "<100k people/trial", 3.73 ], [ "Harris TX", 4336853, 55.83, "<100k people/trial", 11.72 ], [ "Kings NY", 2592149, 86.92, "<100k people/trial", 5.41 ], [ "Miami-dade FL", 2617176, 47.75, "<100k people/trial", 18.47 ], [ "Philadelphia PA", 1553165, 53.67, "<100k people/trial", 7.75 ], [ "San Diego CA", 3211252, 39.92, "<100k people/trial", 8.22 ], [ "St Louis City MO", 318416, 41.83, "<100k people/trial", 4.67 ], [ "Suffolk MA", 755503, 88.92, "<100k people/trial", 8.32 ], [ "Los Angeles CA", 10017068, 88, "100k-200k people/trial", 21.35 ], [ "Maricopa AZ", 4009412, 27.92, "100k-200k people/trial", 10.1 ], [ "Orange CA", 3114363, 28, "100k-200k people/trial", 10.34 ] ]; data.addColumn('string','CountyState'); data.addColumn('number','Population'); data.addColumn('number','Trials'); data.addColumn('string','PPT'); data.addColumn('number','Volatility'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartBubbleChartID258f6e7fd3f7() { var data = gvisDataBubbleChartID258f6e7fd3f7(); var options = {}; options["vAxis"] = {minValue:0, title:'Average Number of Trials in 2013'}; options["hAxis"] = {title: 'County Population in 2013'}; options["bubble"] = {textStyle: {fontSize: 11}}; options["colors"] = ['#FFCC00','#ff9900','#ff6600','#FF3300']; options["height"] = 500; var chart = new google.visualization.BubbleChart( document.getElementById('BubbleChartID258f6e7fd3f7') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "corechart"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartBubbleChartID258f6e7fd3f7); })(); function displayChartBubbleChartID258f6e7fd3f7() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: Bubbles • Chart ID: BubbleChartID258f6e7fd3f7

Definitions of each statistic are as follows:

Number of Trials - # of active clinical trials in 2013, averaged by month

County Population - Predicted county population in 2013, based on U.S. Census data

People/Trial (PPT) - County population divided by # of trials (potential indicators of trial saturation and/or disease prevalence)

Volatility - Standard deviation of active trials from 2009-2013

// jsData function gvisDataTableID258fa3535ce () { var data = new google.visualization.DataTable(); var datajson = [ [ "Allegheny County, Pennsylvania", 1231527, 51.58, 23876, 4.47, "Pittsburgh" ], [ "Baltimore City County, Maryland", 823015, 48.17, 17086, 3.38, "Baltimore" ], [ "Broward County, Florida", 1838844, 27, 68105, 10.88, "Fort Lauderdale" ], [ "Cook County, Illinois", 5240700, 65.42, 80109, 9.75, "Chicago" ], [ "Cuyahoga County, Ohio", 1263154, 49.17, 25690, 3.34, "Cleveland" ], [ "Fulton County, Georgia", 984293, 42, 23436, 3.36, "Atlanta" ], [ "Hamilton County, Ohio", 804520, 45.67, 17616, 3.73, "Cincinnati" ], [ "Harris County, Texas", 4336853, 55.83, 77680, 11.72, "Houston" ], [ "Kings County, New York", 2592149, 86.92, 29822, 5.41, "New York" ], [ "Miami-dade County, Florida", 2617176, 47.75, 54810, 18.47, "Miami" ], [ "Philadelphia County, Pennsylvania", 1553165, 53.67, 28939, 7.75, "Philadelphia" ], [ "San Diego County, California", 3211252, 39.92, 80442, 8.22, "San Diego" ], [ "St Louis City County, Missouri", 318416, 41.83, 7612, 4.67, "St. Louis" ], [ "Suffolk County, Massachusetts", 755503, 88.92, 8496, 8.32, "Boston" ], [ "Los Angeles County, California", 10017068, 88, 113830, 21.35, "Los Angeles" ], [ "Maricopa County, Arizona", 4009412, 27.92, 143604, 10.1, "Phoenix" ], [ "Orange County, California", 3114363, 28, 111227, 10.34, "Santa Ana" ] ]; data.addColumn('string','County, State'); data.addColumn('number','2013 Population'); data.addColumn('number','2013 Average Trials/Month'); data.addColumn('number','People Per Trial'); data.addColumn('number','Volatility'); data.addColumn('string','Largest City in County'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartTableID258fa3535ce() { var data = gvisDataTableID258fa3535ce(); var options = {}; options["allowHtml"] = true; var dataFormat1 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat1.format(data, 1); var dataFormat2 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat2.format(data, 3); var chart = new google.visualization.Table( document.getElementById('TableID258fa3535ce') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "table"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartTableID258fa3535ce); })(); function displayChartTableID258fa3535ce() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: theTable • Chart ID: TableID258fa3535ce

Counties chosen for the bubble plot are based on these criteria:

Top 5 in population

Top 5 in # of trials

Top 5 in volatility

Top 10 most atypical counties based on PPT

Top 25 U.S. Counties for Hypertension Trials

// jsData function gvisDataGeoChartID258f2b5f6c9e () { var data = new google.visualization.DataTable(); var datajson = [ [ "Allegheny County, Pennsylvania", "Allegheny County Pop: 1231527, Largest City: Pittsburgh", 51.58 ], [ "Arapahoe County, Colorado", "Arapahoe County Pop: 607070, Largest City: Aurora", 30.75 ], [ "Baltimore City County, Maryland", "Baltimore City County Pop: 823015, Largest City: Baltimore", 48.17 ], [ "Broward County, Florida", "Broward County Pop: 1838844, Largest City: Fort Lauderdale", 27 ], [ "Cook County, Illinois", "Cook County Pop: 5240700, Largest City: Chicago", 65.42 ], [ "Cuyahoga County, Ohio", "Cuyahoga County Pop: 1263154, Largest City: Cleveland", 49.17 ], [ "Dallas County, Texas", "Dallas County Pop: 2480331, Largest City: Dallas", 47.42 ], [ "Durham County, North Carolina", "Durham County Pop: 288133, Largest City: Durham", 31.25 ], [ "Franklin County, Ohio", "Franklin County Pop: 1212263, Largest City: Columbus", 39.75 ], [ "Fulton County, Georgia", "Fulton County Pop: 984293, Largest City: Atlanta", 42 ], [ "Hamilton County, Ohio", "Hamilton County Pop: 804520, Largest City: Cincinnati", 45.67 ], [ "Harris County, Texas", "Harris County Pop: 4336853, Largest City: Houston", 55.83 ], [ "Jefferson County, Alabama", "Jefferson County Pop: 659479, Largest City: Birmingham", 35.58 ], [ "Jefferson County, Kentucky", "Jefferson County Pop: 756832, Largest City: Louisville", 35.17 ], [ "Kings County, New York", "Kings County Pop: 2592149, Largest City: New York", 86.92 ], [ "Los Angeles County, California", "Los Angeles County Pop: 10017068, Largest City: Los Angeles", 88 ], [ "Maricopa County, Arizona", "Maricopa County Pop: 4009412, Largest City: Phoenix", 27.92 ], [ "Miami-dade County, Florida", "Miami-dade County Pop: 2617176, Largest City: Miami", 47.75 ], [ "Milwaukee County, Wisconsin", "Milwaukee County Pop: 956023, Largest City: Milwaukee", 31.83 ], [ "Multnomah County, Oregon", "Multnomah County Pop: 766135, Largest City: Portland", 30.08 ], [ "Orange County, California", "Orange County Pop: 3114363, Largest City: Santa Ana", 28 ], [ "Philadelphia County, Pennsylvania", "Philadelphia County Pop: 1553165, Largest City: Philadelphia", 53.67 ], [ "San Diego County, California", "San Diego County Pop: 3211252, Largest City: San Diego", 39.92 ], [ "St Louis City County, Missouri", "St Louis City County Pop: 318416, Largest City: St. Louis", 41.83 ], [ "Suffolk County, Massachusetts", "Suffolk County Pop: 755503, Largest City: Boston", 88.92 ] ]; data.addColumn('string','County..State'); data.addColumn('string','hover'); data.addColumn('number','Trials'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartGeoChartID258f2b5f6c9e() { var data = gvisDataGeoChartID258f2b5f6c9e(); var options = {}; options["width"] = 600; options["height"] = 400; options["region"] = "US"; options["displayMode"] = "markers"; options["resolution"] = "provinces"; var chart = new google.visualization.GeoChart( document.getElementById('GeoChartID258f2b5f6c9e') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "geochart"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartGeoChartID258f2b5f6c9e); })(); function displayChartGeoChartID258f2b5f6c9e() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: top25 • Chart ID: GeoChartID258f2b5f6c9e

The following tables will show that there are clearly other factors besides population that influence where trials are run.

5 Most Trialed Counties in 2013 Based On Population

// jsData function gvisDataTableID258f5d40f51 () { var data = new google.visualization.DataTable(); var datajson = [ [ "Allegheny County, Pennsylvania", 1231527, 51.58, 23876, 4.47, "Pittsburgh" ], [ "Baltimore City County, Maryland", 823015, 48.17, 17086, 3.38, "Baltimore" ], [ "Kings County, New York", 2592149, 86.92, 29822, 5.41, "New York" ], [ "St Louis City County, Missouri", 318416, 41.83, 7612, 4.67, "St. Louis" ], [ "Suffolk County, Massachusetts", 755503, 88.92, 8496, 8.32, "Boston" ] ]; data.addColumn('string','County, State'); data.addColumn('number','2013 Population'); data.addColumn('number','2013 Average Trials/Month'); data.addColumn('number','People Per Trial'); data.addColumn('number','Volatility'); data.addColumn('string','Largest City in County'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartTableID258f5d40f51() { var data = gvisDataTableID258f5d40f51(); var options = {}; options["allowHtml"] = true; var dataFormat1 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat1.format(data, 1); var dataFormat2 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat2.format(data, 3); var chart = new google.visualization.Table( document.getElementById('TableID258f5d40f51') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "table"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartTableID258f5d40f51); })(); function displayChartTableID258f5d40f51() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: theTable • Chart ID: TableID258f5d40f51

At only 7,612 people per trial, the St. Louis area takes the top spot. Is this because of disease prevalence, availability of research centers, or something else?

5 Least Trialed Counties in 2013 Based On Population

// jsData function gvisDataTableID258f253991d4 () { var data = new google.visualization.DataTable(); var datajson = [ [ "Los Angeles County, California", 10017068, 88, 113830, 21.35, "Los Angeles" ], [ "New York County, New York", 1626159, 1, 1626159, 0.59, "New York City" ], [ "Queens County, New York", 2296175, 1.08, 2126088, 0.17, "Flushing" ], [ "Riverside County, California", 2292507, 4.08, 561889, 3.14, "Riverside" ], [ "San Bernardino County, California", 2088371, 3, 696124, 2.18, "San Bernardino" ] ]; data.addColumn('string','County, State'); data.addColumn('number','2013 Population'); data.addColumn('number','2013 Average Trials/Month'); data.addColumn('number','People Per Trial'); data.addColumn('number','Volatility'); data.addColumn('string','Largest City in County'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartTableID258f253991d4() { var data = gvisDataTableID258f253991d4(); var options = {}; options["allowHtml"] = true; var dataFormat1 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat1.format(data, 1); var dataFormat2 = new google.visualization.NumberFormat({pattern:"#,###"}); dataFormat2.format(data, 3); var chart = new google.visualization.Table( document.getElementById('TableID258f253991d4') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "table"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartTableID258f253991d4); })(); function displayChartTableID258f253991d4() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: theTable • Chart ID: TableID258f253991d4

This table may be most useful for shortlisting locations for future clinical trial sites. Why do these counties have atypically low numbers of hypertension trials?

5 Most Volatile Counties For Hypertension Clinical Trials

// jsData function gvisDataAnnotationChartID258f66950863 () { var data = new google.visualization.DataTable(); var datajson = [ [ new Date(2016,3,1), 10, 17, 21, 8, 2 ], [ new Date(2016,11,1), 5, 13, 9, 2, 1 ], [ new Date(2017,0,1), 4, 11, 7, 2, null ], [ new Date(2016,2,1), 10, 18, 22, 9, 4 ], [ new Date(2017,4,1), 4, 10, 7, 2, null ], [ new Date(2016,5,1), 7, 13, 17, 5, 2 ], [ new Date(2017,2,1), 4, 10, 7, 2, null ], [ new Date(2016,6,1), 5, 13, 12, 4, 1 ], [ new Date(2016,7,1), 5, 13, 12, 3, 1 ], [ new Date(2016,4,1), 10, 16, 21, 7, 2 ], [ new Date(2007,1,1), 31, 52, 85, 37, 28 ], [ new Date(2016,10,1), 5, 13, 9, 2, 1 ], [ new Date(2008,10,1), 43, 49, 114, 64, 48 ], [ new Date(2008,11,1), 45, 52, 120, 66, 50 ], [ new Date(2017,1,1), 4, 10, 7, 2, null ], [ new Date(2008,0,1), 28, 45, 93, 41, 36 ], [ new Date(2017,3,1), 4, 10, 7, 2, null ], [ new Date(2009,3,1), 56, 57, 126, 70, 49 ], [ new Date(2009,4,1), 49, 53, 109, 60, 42 ], [ new Date(2009,5,1), 51, 56, 109, 61, 42 ], [ new Date(2009,6,1), 53, 57, 104, 62, 41 ], [ new Date(2009,7,1), 54, 55, 103, 61, 40 ], [ new Date(2016,8,1), 5, 13, 12, 3, 1 ], [ new Date(2016,9,1), 5, 13, 9, 2, 1 ], [ new Date(2008,9,1), 40, 50, 115, 63, 49 ], [ new Date(2009,11,1), 39, 52, 92, 44, 27 ], [ new Date(2010,0,1), 39, 55, 96, 47, 30 ], [ new Date(2010,1,1), 41, 56, 99, 49, 31 ], [ new Date(2010,2,1), 42, 53, 95, 47, 30 ], [ new Date(2010,3,1), 40, 53, 96, 41, 25 ], [ new Date(2010,4,1), 39, 54, 97, 41, 26 ], [ new Date(2010,5,1), 29, 50, 93, 38, 23 ], [ new Date(2010,6,1), 28, 53, 98, 53, 28 ], [ new Date(2010,7,1), 22, 56, 91, 47, 21 ], [ new Date(2010,8,1), 21, 57, 88, 47, 21 ], [ new Date(2009,8,1), 48, 50, 94, 56, 37 ], [ new Date(2009,9,1), 45, 49, 86, 57, 33 ], [ new Date(2009,10,1), 43, 48, 88, 55, 29 ], [ new Date(2011,0,1), 24, 69, 109, 63, 32 ], [ new Date(2011,1,1), 24, 69, 109, 63, 31 ], [ new Date(2011,2,1), 22, 66, 107, 61, 31 ], [ new Date(2011,3,1), 24, 64, 108, 62, 29 ], [ new Date(2011,4,1), 27, 68, 108, 64, 31 ], [ new Date(2008,1,1), 27, 44, 93, 41, 34 ], [ new Date(2008,2,1), 33, 44, 101, 44, 40 ], [ new Date(2008,3,1), 34, 49, 105, 48, 41 ], [ new Date(2008,4,1), 35, 51, 110, 57, 45 ], [ new Date(2008,5,1), 35, 52, 111, 57, 45 ], [ new Date(2010,9,1), 26, 67, 109, 65, 33 ], [ new Date(2010,10,1), 25, 66, 108, 64, 31 ], [ new Date(2010,11,1), 26, 67, 111, 67, 33 ], [ new Date(2012,1,1), 50, 87, 145, 96, 50 ], [ new Date(2012,2,1), 46, 83, 142, 94, 49 ], [ new Date(2012,3,1), 45, 82, 144, 93, 47 ], [ new Date(2009,0,1), 50, 55, 120, 67, 54 ], [ new Date(2009,1,1), 54, 56, 121, 70, 54 ], [ new Date(2009,2,1), 58, 60, 132, 73, 56 ], [ new Date(2012,9,1), 41, 76, 136, 87, 49 ], [ new Date(2012,10,1), 40, 77, 137, 87, 50 ], [ new Date(2012,11,1), 41, 77, 133, 89, 49 ], [ new Date(2013,0,1), 40, 75, 131, 91, 49 ], [ new Date(2013,1,1), 36, 71, 123, 86, 47 ], [ new Date(2013,2,1), 34, 59, 96, 58, 33 ], [ new Date(2013,3,1), 22, 53, 85, 34, 25 ], [ new Date(2013,4,1), 24, 53, 85, 35, 26 ], [ new Date(2013,5,1), 22, 53, 77, 35, 21 ], [ new Date(2013,6,1), 22, 51, 74, 35, 21 ], [ new Date(2013,7,1), 22, 51, 71, 36, 22 ], [ new Date(2013,8,1), 22, 49, 75, 36, 21 ], [ new Date(2013,9,1), 26, 51, 80, 42, 24 ], [ new Date(2013,10,1), 27, 52, 80, 43, 23 ], [ new Date(2013,11,1), 27, 52, 79, 42, 24 ], [ new Date(2014,0,1), 26, 49, 76, 37, 23 ], [ new Date(2014,1,1), 26, 50, 77, 37, 23 ], [ new Date(2014,2,1), 24, 47, 76, 36, 22 ], [ new Date(2014,3,1), 24, 44, 74, 35, 22 ], [ new Date(2014,4,1), 26, 44, 76, 36, 24 ], [ new Date(2014,5,1), 27, 46, 78, 34, 24 ], [ new Date(2014,6,1), 27, 49, 80, 28, 23 ], [ new Date(2014,7,1), 27, 48, 78, 26, 22 ], [ new Date(2014,8,1), 22, 47, 67, 18, 17 ], [ new Date(2014,9,1), 22, 46, 63, 17, 15 ], [ new Date(2014,10,1), 22, 46, 65, 17, 15 ], [ new Date(2014,11,1), 21, 44, 60, 16, 14 ], [ new Date(2015,0,1), 20, 39, 45, 16, 10 ], [ new Date(2015,1,1), 19, 36, 41, 16, 10 ], [ new Date(2015,2,1), 19, 36, 40, 16, 10 ], [ new Date(2015,3,1), 15, 33, 37, 15, 9 ], [ new Date(2008,6,1), 36, 53, 115, 55, 44 ], [ new Date(2008,7,1), 43, 53, 120, 63, 53 ], [ new Date(2008,8,1), 41, 51, 123, 66, 49 ], [ new Date(2015,7,1), 15, 29, 35, 13, 11 ], [ new Date(2015,8,1), 14, 25, 32, 10, 9 ], [ new Date(2015,9,1), 14, 25, 31, 9, 9 ], [ new Date(2015,10,1), 14, 25, 30, 9, 9 ], [ new Date(2015,11,1), 14, 25, 29, 9, 9 ], [ new Date(2016,0,1), 10, 20, 23, 9, 5 ], [ new Date(2016,1,1), 10, 19, 22, 9, 4 ], [ new Date(2005,9,1), 14, 32, 59, 22, 20 ], [ new Date(2005,10,1), 14, 29, 56, 23, 19 ], [ new Date(2005,11,1), 14, 30, 56, 22, 20 ], [ new Date(2006,0,1), 14, 30, 56, 22, 20 ], [ new Date(2006,1,1), 14, 30, 54, 23, 20 ], [ new Date(2006,2,1), 14, 35, 57, 22, 21 ], [ new Date(2006,3,1), 21, 39, 65, 24, 25 ], [ new Date(2006,4,1), 25, 42, 74, 25, 27 ], [ new Date(2006,5,1), 31, 43, 79, 29, 29 ], [ new Date(2006,6,1), 34, 43, 82, 37, 31 ], [ new Date(2006,7,1), 29, 44, 81, 37, 29 ], [ new Date(2006,8,1), 31, 52, 89, 42, 30 ], [ new Date(2006,9,1), 30, 56, 94, 40, 30 ], [ new Date(2006,10,1), 31, 54, 93, 39, 31 ], [ new Date(2006,11,1), 37, 53, 94, 40, 32 ], [ new Date(2007,0,1), 34, 54, 91, 41, 33 ], [ new Date(2020,7,1), 2, 6, 4, null, null ], [ new Date(2007,2,1), 32, 51, 82, 38, 29 ], [ new Date(2017,5,1), 2, 10, 7, 1, null ], [ new Date(2017,6,1), 2, 9, 7, null, null ], [ new Date(2017,7,1), 2, 9, 7, null, null ], [ new Date(2017,8,1), 2, 9, 7, null, null ], [ new Date(2017,9,1), 2, 9, 7, null, null ], [ new Date(2017,10,1), 2, 9, 6, null, null ], [ new Date(2017,11,1), 2, 9, 6, null, null ], [ new Date(2018,0,1), 2, 9, 5, null, null ], [ new Date(2018,1,1), 2, 8, 5, null, null ], [ new Date(2018,2,1), 2, 8, 5, null, null ], [ new Date(2018,3,1), 2, 8, 5, null, null ], [ new Date(2018,4,1), 2, 8, 5, null, null ], [ new Date(2015,4,1), 15, 30, 37, 15, 9 ], [ new Date(2015,5,1), 15, 32, 37, 15, 11 ], [ new Date(2015,6,1), 15, 32, 37, 13, 11 ], [ new Date(2018,8,1), 2, 8, 4, null, null ], [ new Date(2018,9,1), 2, 8, 4, null, null ], [ new Date(2018,10,1), 2, 8, 4, null, null ], [ new Date(2018,11,1), 2, 8, 4, null, null ], [ new Date(2019,0,1), 2, 7, 4, null, null ], [ new Date(2019,1,1), 2, 7, 4, null, null ], [ new Date(2019,2,1), 2, 7, 4, null, null ], [ new Date(2019,3,1), 2, 7, 4, null, null ], [ new Date(2019,4,1), 2, 7, 4, null, null ], [ new Date(2019,5,1), 2, 7, 4, null, null ], [ new Date(2019,6,1), 2, 7, 4, null, null ], [ new Date(2019,7,1), 2, 7, 4, null, null ], [ new Date(2019,8,1), 2, 7, 4, null, null ], [ new Date(2019,9,1), 2, 7, 4, null, null ], [ new Date(2019,10,1), 2, 7, 4, null, null ], [ new Date(2019,11,1), 2, 7, 4, null, null ], [ new Date(2020,0,1), 2, 7, 4, null, null ], [ new Date(2020,1,1), 2, 7, 4, null, null ], [ new Date(2020,2,1), 2, 7, 4, null, null ], [ new Date(2020,3,1), 2, 7, 4, null, null ], [ new Date(2020,4,1), 2, 7, 4, null, null ], [ new Date(2020,5,1), 2, 7, 4, null, null ], [ new Date(2020,6,1), 2, 6, 4, null, null ], [ new Date(2003,7,1), 9, 17, 36, 4, 8 ], [ new Date(2020,8,1), 2, 6, 4, null, null ], [ new Date(2020,9,1), 2, 6, 4, null, null ], [ new Date(2020,10,1), 2, 6, 4, null, null ], [ new Date(2020,11,1), 2, 6, 4, null, null ], [ new Date(2021,0,1), 1, 3, 2, null, null ], [ new Date(2021,1,1), 1, 3, 2, null, null ], [ new Date(2021,2,1), 1, 3, 2, null, null ], [ new Date(2021,3,1), 1, 3, 2, null, null ], [ new Date(2021,4,1), 1, 3, 2, null, null ], [ new Date(2011,5,1), 24, 67, 107, 57, 28 ], [ new Date(2011,6,1), 24, 69, 107, 57, 28 ], [ new Date(2011,7,1), 31, 76, 118, 67, 35 ], [ new Date(2011,8,1), 31, 78, 122, 69, 36 ], [ new Date(2018,5,1), 2, 8, 5, null, null ], [ new Date(2018,6,1), 2, 8, 5, null, null ], [ new Date(2018,7,1), 2, 8, 5, null, null ], [ new Date(2012,0,1), 48, 86, 142, 94, 47 ], [ new Date(2001,10,1), 2, 5, 6, 3, 4 ], [ new Date(2001,11,1), 2, 5, 6, 3, 3 ], [ new Date(2002,0,1), 2, 6, 7, 3, 3 ], [ new Date(2012,4,1), 46, 81, 146, 91, 46 ], [ new Date(2012,5,1), 42, 80, 142, 88, 46 ], [ new Date(2012,6,1), 43, 80, 141, 88, 46 ], [ new Date(2012,7,1), 41, 77, 138, 86, 47 ], [ new Date(2012,8,1), 41, 76, 138, 86, 47 ], [ new Date(2002,5,1), 2, 6, 7, 3, 3 ], [ new Date(2002,6,1), 4, 10, 12, 5, 4 ], [ new Date(2002,7,1), 4, 10, 12, 5, 4 ], [ new Date(2002,8,1), 2, 10, 11, 5, 3 ], [ new Date(2002,9,1), 3, 12, 20, 5, 5 ], [ new Date(2002,10,1), 3, 12, 20, 5, 5 ], [ new Date(2002,11,1), 3, 13, 25, 5, 5 ], [ new Date(2003,0,1), 9, 13, 29, 5, 6 ], [ new Date(2003,1,1), 9, 14, 29, 6, 7 ], [ new Date(2003,2,1), 9, 15, 30, 6, 7 ], [ new Date(2003,3,1), 9, 15, 30, 6, 7 ], [ new Date(2003,4,1), 9, 16, 30, 6, 7 ], [ new Date(2003,5,1), 9, 17, 30, 7, 7 ], [ new Date(2003,6,1), 11, 18, 38, 7, 9 ], [ new Date(2004,8,1), 12, 39, 55, 12, 12 ], [ new Date(2003,8,1), 13, 23, 45, 8, 10 ], [ new Date(2003,9,1), 13, 22, 45, 7, 10 ], [ new Date(2003,10,1), 13, 22, 45, 7, 10 ], [ new Date(2003,11,1), 13, 23, 42, 7, 10 ], [ new Date(2004,0,1), 12, 29, 43, 7, 8 ], [ new Date(2004,1,1), 12, 29, 43, 8, 8 ], [ new Date(2004,2,1), 13, 29, 45, 8, 9 ], [ new Date(2004,3,1), 13, 33, 48, 8, 10 ], [ new Date(2004,4,1), 13, 34, 48, 8, 10 ], [ new Date(2004,5,1), 13, 34, 50, 8, 10 ], [ new Date(2004,6,1), 9, 37, 49, 8, 8 ], [ new Date(2004,7,1), 9, 37, 48, 8, 8 ], [ new Date(2002,4,1), 2, 6, 7, 3, 3 ], [ new Date(2004,9,1), 14, 40, 59, 13, 13 ], [ new Date(2004,10,1), 13, 40, 57, 14, 12 ], [ new Date(2004,11,1), 13, 35, 53, 14, 12 ], [ new Date(2005,0,1), 7, 35, 51, 15, 12 ], [ new Date(2005,1,1), 7, 35, 52, 15, 12 ], [ new Date(2005,2,1), 7, 36, 52, 15, 12 ], [ new Date(2005,3,1), 7, 33, 51, 16, 11 ], [ new Date(2005,4,1), 11, 34, 58, 20, 17 ], [ new Date(2005,5,1), 8, 34, 57, 20, 15 ], [ new Date(2005,6,1), 7, 36, 57, 21, 16 ], [ new Date(2005,7,1), 7, 36, 57, 20, 16 ], [ new Date(2005,8,1), 14, 32, 59, 22, 20 ], [ new Date(2002,3,1), 2, 6, 7, 3, 3 ], [ new Date(2007,4,1), 25, 57, 73, 37, 24 ], [ new Date(2007,5,1), 28, 54, 76, 37, 27 ], [ new Date(2011,9,1), 31, 78, 122, 71, 36 ], [ new Date(2007,3,1), 24, 53, 72, 34, 26 ], [ new Date(2007,8,1), 31, 45, 83, 41, 33 ], [ new Date(2007,9,1), 31, 46, 89, 42, 35 ], [ new Date(2007,6,1), 27, 50, 74, 36, 25 ], [ new Date(2007,7,1), 28, 50, 78, 36, 26 ], [ new Date(2011,10,1), 31, 76, 125, 72, 35 ], [ new Date(2011,11,1), 32, 77, 126, 72, 36 ], [ new Date(2007,10,1), 27, 47, 90, 41, 35 ], [ new Date(2007,11,1), 28, 46, 94, 42, 36 ], [ new Date(2002,2,1), 2, 6, 7, 3, 3 ], [ new Date(2001,9,1), 2, 5, 6, 3, 4 ], [ new Date(2002,1,1), 2, 6, 7, 3, 3 ], [ new Date(2022,4,1), null, 1, null, null, null ], [ new Date(2022,5,1), null, 1, null, null, null ], [ new Date(2021,5,1), null, 2, null, null, null ], [ new Date(2021,11,1), null, 1, null, null, null ], [ new Date(2022,0,1), null, 1, null, null, null ], [ new Date(2021,9,1), null, 1, null, null, null ], [ new Date(2021,10,1), null, 1, null, null, null ], [ new Date(2022,3,1), null, 1, null, null, null ], [ new Date(2022,6,1), null, 1, null, null, null ], [ new Date(2021,6,1), null, 2, null, null, null ], [ new Date(2021,7,1), null, 1, null, null, null ], [ new Date(2021,8,1), null, 1, null, null, null ], [ new Date(2022,1,1), null, 1, null, null, null ], [ new Date(2022,2,1), null, 1, null, null, null ], [ new Date(1995,9,1), null, 1, null, null, null ], [ new Date(1995,10,1), null, 1, null, null, null ], [ new Date(1995,11,1), null, 1, null, null, null ], [ new Date(1996,0,1), null, 1, null, null, null ], [ new Date(2000,10,1), null, 6, 4, 3, 3 ], [ new Date(2000,11,1), null, 6, 4, 3, 3 ], [ new Date(2001,0,1), null, 7, 4, 4, 3 ], [ new Date(2001,1,1), null, 7, 4, 4, 3 ], [ new Date(2001,2,1), null, 7, 4, 4, 3 ], [ new Date(2001,3,1), null, 7, 4, 4, 3 ], [ new Date(2001,4,1), null, 7, 4, 4, 3 ], [ new Date(2001,5,1), null, 5, 4, 3, 3 ], [ new Date(2001,6,1), null, 5, 4, 3, 3 ], [ new Date(2001,7,1), null, 5, 4, 3, 3 ], [ new Date(2001,8,1), null, 5, 4, 3, 3 ], [ new Date(1996,1,1), null, 1, null, null, null ], [ new Date(1996,2,1), null, 1, null, null, null ], [ new Date(1996,3,1), null, 1, null, null, null ], [ new Date(1996,4,1), null, 1, null, null, null ], [ new Date(1997,6,1), null, 1, null, 1, 2 ], [ new Date(1997,7,1), null, 1, null, 1, 2 ], [ new Date(1997,8,1), null, 1, null, 1, 2 ], [ new Date(1997,9,1), null, 1, null, 1, 2 ], [ new Date(1997,10,1), null, 1, null, 1, 2 ], [ new Date(1997,11,1), null, 1, null, 1, 2 ], [ new Date(1998,0,1), null, 1, null, 1, 2 ], [ new Date(1998,1,1), null, 1, null, 1, 2 ], [ new Date(1998,2,1), null, 1, null, 1, 2 ], [ new Date(1998,3,1), null, 1, null, 1, 2 ], [ new Date(1998,4,1), null, 1, null, 1, 2 ], [ new Date(1998,5,1), null, 1, null, 1, 2 ], [ new Date(1998,6,1), null, 2, 2, 1, 4 ], [ new Date(1998,7,1), null, 4, 2, 2, 4 ], [ new Date(1998,8,1), null, 4, 2, 2, 4 ], [ new Date(1998,9,1), null, 4, 2, 2, 4 ], [ new Date(1998,10,1), null, 4, 2, 2, 4 ], [ new Date(1998,11,1), null, 5, 2, 2, 4 ], [ new Date(1999,0,1), null, 5, 2, 2, 4 ], [ new Date(1999,1,1), null, 5, 2, 2, 4 ], [ new Date(1999,2,1), null, 5, 2, 2, 4 ], [ new Date(1999,3,1), null, 5, 2, 2, 4 ], [ new Date(1999,4,1), null, 5, 2, 2, 4 ], [ new Date(1999,5,1), null, 5, 2, 2, 4 ], [ new Date(1999,6,1), null, 4, 3, 2, 2 ], [ new Date(1999,7,1), null, 4, 3, 2, 2 ], [ new Date(1999,8,1), null, 4, 2, 2, 2 ], [ new Date(1999,9,1), null, 5, 3, 3, 2 ], [ new Date(1999,10,1), null, 5, 3, 3, 2 ], [ new Date(1999,11,1), null, 5, 3, 3, 2 ], [ new Date(2000,0,1), null, 5, 4, 3, 3 ], [ new Date(2000,1,1), null, 5, 4, 3, 3 ], [ new Date(2000,2,1), null, 5, 4, 3, 3 ], [ new Date(2000,3,1), null, 5, 4, 3, 3 ], [ new Date(2000,4,1), null, 5, 4, 3, 3 ], [ new Date(2000,5,1), null, 5, 4, 3, 3 ], [ new Date(2000,6,1), null, 5, 4, 3, 3 ], [ new Date(2000,7,1), null, 5, 4, 3, 3 ], [ new Date(2000,8,1), null, 6, 4, 3, 3 ], [ new Date(2000,9,1), null, 6, 4, 3, 3 ], [ new Date(1993,0,1), null, null, 1, null, null ], [ new Date(1993,1,1), null, null, 1, null, null ], [ new Date(1993,2,1), null, null, 1, null, null ], [ new Date(1993,3,1), null, null, 1, null, null ], [ new Date(1993,4,1), null, null, 1, null, null ], [ new Date(1993,5,1), null, null, 1, null, null ], [ new Date(1993,6,1), null, null, 1, null, null ], [ new Date(1993,7,1), null, null, 1, null, null ], [ new Date(1993,8,1), null, null, 1, null, null ], [ new Date(1993,9,1), null, null, 1, 1, null ], [ new Date(1993,10,1), null, null, 1, 1, null ], [ new Date(1993,11,1), null, null, 1, 1, null ], [ new Date(1994,0,1), null, null, 1, 1, null ], [ new Date(1994,1,1), null, null, 1, 1, null ], [ new Date(1997,2,1), null, null, null, 1, null ], [ new Date(1997,3,1), null, null, null, 1, null ], [ new Date(1997,4,1), null, null, null, 1, null ], [ new Date(1997,5,1), null, null, null, 1, null ], [ new Date(1994,2,1), null, null, null, 1, null ], [ new Date(1994,3,1), null, null, null, 1, null ], [ new Date(1994,4,1), null, null, null, 1, null ], [ new Date(1994,5,1), null, null, null, 1, null ], [ new Date(1994,6,1), null, null, null, 1, null ], [ new Date(1994,7,1), null, null, null, 1, null ], [ new Date(1994,8,1), null, null, null, 1, null ], [ new Date(1994,9,1), null, null, null, 1, null ], [ new Date(1994,10,1), null, null, null, 1, null ], [ new Date(1994,11,1), null, null, null, 1, null ], [ new Date(1996,11,1), null, null, null, 1, null ], [ new Date(1997,0,1), null, null, null, 1, null ], [ new Date(1997,1,1), null, null, null, 1, null ] ]; data.addColumn('date','yearMon'); data.addColumn('number','Broward County, Florida'); data.addColumn('number','Harris County, Texas'); data.addColumn('number','Los Angeles County, California'); data.addColumn('number','Miami-dade County, Florida'); data.addColumn('number','Orange County, California'); data.addRows(datajson); return(data); } // jsDrawChart function drawChartAnnotationChartID258f66950863() { var data = gvisDataAnnotationChartID258f66950863(); var options = {}; options["width"] = 600; options["height"] = 700; options["vAxis"] = {minValue:0, title:'Volatility (Standard Deviation of Trials 2009-2013)'}; options["title"] = "Top 5 Most Volatile Counties"; options["dateFormat"] = "MMMM yyyy"; options["displayZoomButtons"] = false; options["fill"] = 10; options["displayExactValues"] = true; var chart = new google.visualization.AnnotationChart( document.getElementById('AnnotationChartID258f66950863') ); chart.draw(data,options); } // jsDisplayChart (function() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; var chartid = "annotationchart"; // Manually see if chartid is in pkgs (not all browsers support Array.indexOf) var i, newPackage = true; for (i = 0; newPackage && i < pkgs.length; i++) { if (pkgs[i] === chartid) newPackage = false; } if (newPackage) pkgs.push(chartid); // Add the drawChart function to the global list of callbacks callbacks.push(drawChartAnnotationChartID258f66950863); })(); function displayChartAnnotationChartID258f66950863() { var pkgs = window.__gvisPackages = window.__gvisPackages || []; var callbacks = window.__gvisCallbacks = window.__gvisCallbacks || []; window.clearTimeout(window.__gvisLoad); // The timeout is set to 100 because otherwise the container div we are // targeting might not be part of the document yet window.__gvisLoad = setTimeout(function() { var pkgCount = pkgs.length; google.load("visualization", "1", { packages:pkgs, callback: function() { if (pkgCount != pkgs.length) { // Race condition where another setTimeout call snuck in after us; if // that call added a package, we must not shift its callback return; } while (callbacks.length > 0) callbacks.shift()(); } }); }, 100); } // jsFooter

Data: top5 • Chart ID: AnnotationChartID258f66950863

Why are these counties particularly variable when it comes to trials run over time?

More Health Conditions

See plots for other conditions on my Shiny App.

Currently there are plots for 5 of the most prevalent health conditions in the U.S. today:

Hypertension

Arteriosclerosis

Prostate Cancer

Asthma

Alzheimer’s

Want plots produced for another health condition? Just let me know. Server load limits prohibit me from allowing the public to generate these plots.

Credits