Hello,

I am writing to follow up on the PMCC project and to request some additional information. I would be grateful if you could share further details to ensure a clear understanding and deliver the desired outcome.

Best,
Sazal

project

we are an academic research group. We need data visualizations of raw data to insert grant applications and negotiate with other academics. Here are examples of data set we need visualized.

1. Cardiology EConsults
Since the beginning of the cardiology eConsult program, total of 2158 eConsults ordered.
 
1895/2158  (~88%) of all cards eConsults were ordered for patients living in 1 of 6 Denver metro or Colorado Springs counties. These are of course classified as “urban” counties. So we can easily say that the majority of all cards eConsults are for patients living in the front range and in urban counties.
 
Across the entire state, 2085/2158 (96.7%) of all cards eConsults were ordered for patients living in an urban county (this would include urban areas a little outside of Denver such as Ft. Collins).
 
24 (1.1%) eConsults ordered for patients living in rural counties. There were only 9 rural counties represented in our data. The state of Colorado has a total of 24 counties classified as rural.
 

 
2. Distribution of EConsults by County and urban rural
Denver Urban 600
Arapahoe Urban 520
Douglas Urban 264
El Paso Urban 188
Adams Urban 172
Jefferson Urban 151
Weld Urban 60
Larimer Urban 53
NA NA 48
Boulder Urban 26
Elbert Urban 21
Broomfield Urban 17
Teller Urban 6
Morgan Rural 5
Pueblo Urban 5
Chaffee Rural 4
Routt Rural 4
Eagle Rural 3
Fremont Rural 2
Grand Rural 2
Logan Rural 2
Park Urban 2
Garfield Rural 1
Pitkin Rural 1
San Miguel Frontier 1
A bad effort to. graphic Colorado EConsult penetration

the first graphic needs to be a map of Colorado, urban rural and frontier counties, and amount of EConsults in each.

hi, I updated project data and sent edits. Great first effort. rodger