Groupweek6
Report III 3
Compare the charts and graphs that your Learning Team members created for the Reports I, II, and III assignments and come to a consensus of the analysis of the data.
Select a health care facility or service (e.g., hospital, physician practice, long-term care facility, ambulance service, pharmacy, or skilled nursing facility).
Create a 2slides powerpoint (speaker note) one of which should be a chart of how your selected health care facility or service can benefit from the information you gathered and analyzed in the Reports III assignments. Be sure to include any conflicts of interest, ethical considerations, or community health effects that may factor into the benefits identified.
Cite 3 reputable APA references to support your assignment (e.g., trade or industry publications, government or agency websites, scholarly works, or other sources of similar quality).
This report III has the chart on an excel sheet
Cities with High or Low Risks
According to the data some states or cities have a high number of cases brought about by the pandemic. Some other cities have a low number of cases than others. These numbers show the rate at which the various states are at risk of experiencing very high risks than others. Jacksonville recorded the highest number of cases in April at 322 which is the highest in the entire data. This puts the city at a very high risk of getting very many other cases as the disease spreads. Miami follows Jacksonville at 299 cases showing that the state is at high risk of getting a serious outbreak. The leading states are followed by Phoenix that recorded 289 cases, Austin 281 cases, Houston 272 cases, San Diego 258, New Orleans 248 cases, Mesa 231, Atlanta 220, and Long Beach recording 215. These cases prove that these states are at very high risk of recording many other cases. Omaha is an example of a state that is at low risk of experiencing a major outbreak as it recorded 3 cases in April. This number of cases is then followed by Virginia Beach 4, Colorado Springs 5, Philadelphia 5, Indianapolis at 7 cases, Raleigh 8, Minneapolis 9, and Arlington 11 cases.
Evaluation
The map showcases that in February the number of reported cases on the disease on each city or state was very low compared to the cases reported in April. For instance, in the state of Raleigh, the number of cases in February was 0 which doubled by March and multiplied to 8 by April. The number of cases is increasing every month rather than slowing showing that the disease is spreading at a very high rate than the projected number. For example, in Jacksonville, the number of cases was 10 in February, reported cases in March were 91 which shoot to 322 by April. The map shows that in February many states had not yet discovered that they had contracted the diseases and the small number of cases reported was from a few individuals that took themselves to the hospital because of signs and symptoms. The numbers get worse in March and April as many people are being admitted with the same type of symptoms but very few can be traced to where they contracted the disease from. The Line for April has very many high points showing the states whose cases are high in April.
The data shows that the rate at which the disease is spreading is very fast. This is depicted by the line curve of April where the cities whose cases are high have very sharp points. Contact tracing of cases reported increased gradually during the three months as cases kept rising. The map shows that the cases multiplied every month showing that contact tracing of reported was conducted very late after asymptomatic individuals had already spread the disease to other people. States with few cases such as Raleigh and Omaha, show that they receive very few visitors or people do not travel regularly thus the small number of cases. Jacksonville and Miami represent states that receive a high number of visitors or people traveling in and out of the state.
Reference
Geographic Differences in COVID-19 Cases, Deaths, and Incidence United States, February (2020). MMWR Morb Mortal Wkly Rep 2020;69:465471. DOI: http://dx.doi.org/10.15585/mmwr.mm6915e4
Killerby ME, Link-Gelles R, Haight SC, (2020). Characteristics Associated with Hospitalization Among Patients with COVID-19 Metropolitan Atlanta, Georgia, MarchApril 2020. MMWR Morb Mortal Wkly Rep DOI: http://dx.doi.org/10.15585/mmwr.mm6925e1
This report III has the chart on an excel sheet Running head: Report III 1
Report III 8
Report III
From the previous reports, we used the total number of infected people in the major cities and categorized the individual into age groups varying from the age of under 18 to the individuals of age sixty and over. The people of age below 18 and the people age 60 and over got infected from the data collected. Whereas, the majority of the people aged between 19-30 years seem to be least infected.
Gathered Data
In this section of the report, we will be using the data gathered from the excel sheets to produce 3D maps to demonstrate which regions are highly contagious and which regions have a lower level risk to the disease. The level of the risk and the cities are all seen from the 3D maps generated in excel. It is imperative to derive these results because depending upon the risk of getting the disease, the precautions and the lockdown procedures will get implemented strictly to ensure the disease does not spread further (Patel et al., 2020). The figure below shows the 3D map of the infected cities.
Figure 1: Infected Cities
For the results of the report, we will be using the data collected from five major cities, which have a considerable contribution to the percentage of infected individuals. The table below shows the infected cases from each of the five major cities during February, March, and April.
City
Number of cases
Jacksonville
429
Miami
392
Phoenix
390
Austin
368
Houston
310
Table 1: Infected cases in 5 major cities
Besides these five significant cities, New Orleans is another region with a high risk of infection, having a total number of 361 cases in the recorded months. Other than that, the regions of moderate infection risks shown in the table below. Following that, table 3 shows the regions with a slight risk of infection with having less than 50 cases in the past three months.
City
Number of cases
New York
264
Los Angeles
219
San Antonio
110
San Diego
299
San Jose
142
132
169
Tucson
125
Fresno
245
Long Beach
247
Mesa
268
Atlanta
266
Oakland
102
Tulsa
178
Table 2: Cities with moderate risk
City
Number of cases
Philadelphia
17
Indianapolis
6
Columbus
9
Charlotte
20
Denver
22
43
Boston
36
Memphis
31
Nashville
40
Portland
28
Oklahoma City
25
Baltimore
13
Louisville
35
Milwaukee
34
Colorado Springs
16
Virginia Beach
5
Raleigh
4
Omaha
10
Minneapolis
3
Arlington
13
Table 3: Cities with Low Risk
Conclusion
From the 3D map generated and the data analyzed from the cases recorded in the cities during the past months of February, March, and April we see that a few cities are having a very high risk of infection having more than 300 cases among which all the major cities like, Miami, Jacksonville, Phoenix, Austin, and New Orleans get included. We can also derive from the results that the precaution to contaminate the disease is not getting followed strictly. On the other side, we see several cities having cases less than 50 in the past month, which include Minneapolis with the least cases, just three. Then there are other cities like Columbus and Boston, with very few patients less than 40 in the past three months. This data shows that the regions with less infection risk are correctly following the precaution measures, and they are correctly applying social distancing measures (Khan, 2020). MHA507_r1_wk5_Tableau_High_Risk
City Feb. Cases March Cases April Cases
New York 19 56 189
Los Angeles 6 12 201
Chicago 0 3 14
Houston 19 19 272
Philadelphia 0 1 5
Phoenix 23 78 289
San Antonio 6 9 95
San Diego 3 38 258
Dallas 4 13 83
San Jose 10 23 109
Austin 28 59 281
Jacksonville 10 97 322
San Francisco 2 13 76
Indianapolis 0 2 7
Columbus 1 5 14
Fort Worth 8 26 98
Charlotte 1 2 19
Seattle 1 10 65
Denver 2 11 30
El Paso 3 4 29
Detroit 4 14 35
Washington D.C. 2 18 61
Boston 1 2 28
Memphis 2 7 31
Nashville 1 4 23
Portland 1 6 18
Oklahoma City 1 1 11
Las Vegas 1 22 146
Baltimore 1 8 26
Louisville 2 15 17
Milwaukee 1 3 12
Albuquerque 2 15 51
Tucson 2 9 114
Fresno 13 45 187
Sacramento 2 9 51
Kansas City 3 13 38
Long Beach 13 19 215
Mesa 2 35 231
Atlanta 11 35 220
Colorado Springs 0 0 5
Virginia Beach 0 0 4
Raleigh 0 2 8
Omaha 0 0 3
Miami 21 72 299
Oakland 3 15 84
Minneapolis 1 3 9
Tulsa 8 43 127
Wichita 1 12 83
New Orleans 12 101 248
Arlington 1 2 11
OUTBREAK DATA
Feb. Cases New York Los Angeles Chicago Houston Philadelphia Phoenix San Antonio San Diego Dallas San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fo rt Worth Charlotte Seattle Denver El Paso Detroit Washington D.C. Boston Memphis Nashville Portland Oklahoma City Las Vegas Baltimore Louisville Milwaukee Albuquerque Tucson Fresno Sacramento Kansas City Long Beach Mesa Atlanta Colorado Springs Virginia Beach Raleigh Omaha Miami Oakland Minneapolis Tulsa Wichita New Orleans Arlington 19 6 0 19 0 23 6 3 4 10 28 10 2 0 1 8 1 1 2 3 4 2 1 2 1 1 1 1 1 2 1 2 2 13 2 3 13 2 11 0 0 0 0 21 3 1 8 1 12 1 March Cases New York Los Angeles Chicago Houston Philadelphia Phoenix San Antonio San Diego Dallas San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fort Worth Charlotte Seattle Denver El Paso Detroit Washington D.C. Boston Memphis Nashville Portland Oklahoma City Las Vegas Baltimore Louisville Milwaukee Albuquerque Tucson Fresno Sacramento Kansas City Long Beach Mesa Atlanta Colorado Springs Virginia Beach Raleigh Omaha Miami Oakland Minneapolis Tulsa Wichita New Orleans Arlington 56 12 3 19 1 78 9 38 13 23 59 97 13 2 5 26 2 10 11 4 14 18 2 7 4 6 1 22 8 15 3 15 9 45 9 13 19 35 35 0 0 2 0 72 15 3 43 12 101 2 April Cases New York Los Angeles Chicago Houston Philadelphia Phoenix San Antonio San Diego Dallas San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fort Worth Charlotte Seattle Denver El Paso Detroit Washington D.C. Boston Memphis Nashville Portland Oklahoma City Las Vegas Baltimore Louisville Milwaukee Albuquerque Tucson Fresno Sacramento Kansas City Long Beach Mesa Atlanta Colorado Springs Virginia Beach Raleigh Omaha Miami Oakland Minneapolis Tulsa Wichita New Orleans Arlington 189 201 14 272 5 289 95 258 83 109 281 322 76 7 14 98 19 65 30 29 35 61 28 31 23 18 11 146 26 17 12 51 114 187 51 38 215 231 220 5 4 8 3 299 84 9 127 83 248 11 Report I
The dangerous virus has affected most of the cities with the highest infected population in Jacksonville, with an infected population of 322 and the least infected city being Omaha with a total of 3 cases. Miami is the second city with the highest number of infections, with 299 cases. Among all the cities with the virus, the top five cities with the more cases of the infected population are Jacksonville, Miami, Phoenix, Austin, and Houston. Phoenix, on the other hand, has 289 cases of the dangerous virus, while Austin has recorded 281 cases of people infected with the deadly virus. The individuals infected with the dangerous virus in Houston adds up to 272 cases. The difference between the numbers of cases in these five cities is small, portraying how vulnerable the populations in these cities are to the virus.
Report II: outbreak analysis.
The total cases of viral infection for April 2017 as indicated by the given data was 4952. The prevalence of viral infection among different age groups during the month as per the above bar graphs shows that those who are below 18years of age represent about 50% of all cases, followed by the elderly above 60 years of age with 1731 cases within the month. 19 to 30 have the least reported viral infection cases (323) while those between 31 and 60 have 809 reported cases. It is also important to realize that after the active age group of 19-30, the cases begin to rise indicating the beginning of the bodys immune response to subside. The age relation to immune response or exposure to viruses can also be deduced from the data.
Cases by cities
Cases New York Los Angeles Chicago Houston Philadelphia Phoenix San Antonio San Diego Dallas San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fort Worth Charlotte Seattle Denver El Paso Detroit Washington D.C. Boston Memphis Nashville Portland Oklahoma City Las Vegas Baltimore Louisville Milwaukee Albuquerque Tucson Fresno Sacramento Kansas City Long Beach Mesa Atlanta Colorado Springs Virginia Beach Raleigh Omaha Miami Oakland Minneapolis Tulsa Wichita New Orleans Arlington 189 201 14 272 5 289 95 258 83 109 281 322 76 7 14 98 19 65 30 29 35 61 28 31 23 18 11 146 26 17 12 51 114 187 51 38 215 231 220 5 4 8 3 299 84 9 127 83 248 11
A side-by-side bar graph showing age groups against virus infections
Frequency
< 18 19-30 31-60 61+ 2089 323 809 1731 Age Groups (years)
Number of virus infection cases
