Based on a comparison of coronavirus deaths in 210 countries relative to their population, Peru had the most losses to COVID-19 up until July 13, 2022. As of the same date, the virus had infected over 557.8 million people worldwide, and the number of deaths had totaled more than 6.3 million. Note, however, that COVID-19 test rates can vary per country. Additionally, big differences show up between countries when combining the number of deaths against confirmed COVID-19 cases. The source seemingly does not differentiate between "the Wuhan strain" (2019-nCOV) of COVID-19, "the Kent mutation" (B.1.1.7) that appeared in the UK in late 2020, the 2021 Delta variant (B.1.617.2) from India or the Omicron variant (B.1.1.529) from South Africa.

The difficulties of death figures

This table aims to provide a complete picture on the topic, but it very much relies on data that has become more difficult to compare. As the coronavirus pandemic developed across the world, countries already used different methods to count fatalities, and they sometimes changed them during the course of the pandemic. On April 16, for example, the Chinese city of Wuhan added a 50 percent increase in their death figures to account for community deaths. These deaths occurred outside of hospitals and went unaccounted for so far. The state of New York did something similar two days before, revising their figures with 3,700 new deaths as they started to include “assumed” coronavirus victims. The United Kingdom started counting deaths in care homes and private households on April 29, adjusting their number with about 5,000 new deaths (which were corrected lowered again by the same amount on August 18). This makes an already difficult comparison even more difficult. Belgium, for example, counts suspected coronavirus deaths in their figures, whereas other countries have not done that (yet). This means two things. First, it could have a big impact on both current as well as future figures. On April 16 already, UK health experts stated that if their numbers were corrected for community deaths like in Wuhan, the UK number would change from 205 to “above 300”. This is exactly what happened two weeks later. Second, it is difficult to pinpoint exactly which countries already have “revised” numbers (like Belgium, Wuhan or New York) and which ones do not. One work-around could be to look at (freely accessible) timelines that track the reported daily increase of deaths in certain countries. Several of these are available on our platform, such as for Belgium, Italy and Sweden. A sudden large increase might be an indicator that the domestic sources changed their methodology.

Where are these numbers coming from?

The numbers shown here were collected by Johns Hopkins University, a source that manually checks the data with domestic health authorities. For the majority of countries, this is from national authorities. In some cases, like China, the United States, Canada or Australia, city reports or other various state authorities were consulted. In this statistic, these separately reported numbers were put together. For more information or other freely accessible content, please visit our dedicated Facts and Figures page.

As of December 22, 2022, Austria had the highest rate of COVID-19 cases among the countries most affected by the pandemic. This statistic shows the rate of COVID-19 cases per million population in the 30 countries with the highest total number of cases, as of December 22, 2022.

On March 10, 2023, the Johns Hopkins Coronavirus Resource Center ceased its collecting and reporting of global COVID-19 data. For updated cases, deaths, and vaccine data please visit: World Health Organization (WHO)For more information, visit the Johns Hopkins Coronavirus Resource Center.COVID-19 Trends MethodologyOur goal is to analyze and present daily updates in the form of recent trends within countries, states, or counties during the COVID-19 global pandemic. The data we are analyzing is taken directly from the Johns Hopkins University Coronavirus COVID-19 Global Cases Dashboard, though we expect to be one day behind the dashboard’s live feeds to allow for quality assurance of the data.DOI: https://doi.org/10.6084/m9.figshare.125529863/7/2022 - Adjusted the rate of active cases calculation in the U.S. to reflect the rates of serious and severe cases due nearly completely dominant Omicron variant.6/24/2020 - Expanded Case Rates discussion to include fix on 6/23 for calculating active cases.6/22/2020 - Added Executive Summary and Subsequent Outbreaks sectionsRevisions on 6/10/2020 based on updated CDC reporting. This affects the estimate of active cases by revising the average duration of cases with hospital stays downward from 30 days to 25 days. The result shifted 76 U.S. counties out of Epidemic to Spreading trend and no change for national level trends.Methodology update on 6/2/2020: This sets the length of the tail of new cases to 6 to a maximum of 14 days, rather than 21 days as determined by the last 1/3 of cases. This was done to align trends and criteria for them with U.S. CDC guidance. The impact is areas transition into Controlled trend sooner for not bearing the burden of new case 15-21 days earlier.Correction on 6/1/2020Discussion of our assertion of an abundance of caution in assigning trends in rural counties added 5/7/2020. Revisions added on 4/30/2020 are highlighted.Revisions added on 4/23/2020 are highlighted.Executive SummaryCOVID-19 Trends is a methodology for characterizing the current trend for places during the COVID-19 global pandemic. Each day we assign one of five trends: Emergent, Spreading, Epidemic, Controlled, or End Stage to geographic areas to geographic areas based on the number of new cases, the number of active cases, the total population, and an algorithm (described below) that contextualize the most recent fourteen days with the overall COVID-19 case history. Currently we analyze the countries of the world and the U.S. Counties. The purpose is to give policymakers, citizens, and analysts a fact-based data driven sense for the direction each place is currently going. When a place has the initial cases, they are assigned Emergent, and if that place controls the rate of new cases, they can move directly to Controlled, and even to End Stage in a short time. However, if the reporting or measures to curtail spread are not adequate and significant numbers of new cases continue, they are assigned to Spreading, and in cases where the spread is clearly uncontrolled, Epidemic trend.We analyze the data reported by Johns Hopkins University to produce the trends, and we report the rates of cases, spikes of new cases, the number of days since the last reported case, and number of deaths. We also make adjustments to the assignments based on population so rural areas are not assigned trends based solely on case rates, which can be quite high relative to local populations.Two key factors are not consistently known or available and should be taken into consideration with the assigned trend. First is the amount of resources, e.g., hospital beds, physicians, etc.that are currently available in each area. Second is the number of recoveries, which are often not tested or reported. On the latter, we provide a probable number of active cases based on CDC guidance for the typical duration of mild to severe cases.Reasons for undertaking this work in March of 2020:The popular online maps and dashboards show counts of confirmed cases, deaths, and recoveries by country or administrative sub-region. Comparing the counts of one country to another can only provide a basis for comparison during the initial stages of the outbreak when counts were low and the number of local outbreaks in each country was low. By late March 2020, countries with small populations were being left out of the mainstream news because it was not easy to recognize they had high per capita rates of cases (Switzerland, Luxembourg, Iceland, etc.). Additionally, comparing countries that have had confirmed COVID-19 cases for high numbers of days to countries where the outbreak occurred recently is also a poor basis for comparison.The graphs of confirmed cases and daily increases in cases were fit into a standard size rectangle, though the Y-axis for one country had a maximum value of 50, and for another country 100,000, which potentially misled people interpreting the slope of the curve. Such misleading circumstances affected comparing large population countries to small population counties or countries with low numbers of cases to China which had a large count of cases in the early part of the outbreak. These challenges for interpreting and comparing these graphs represent work each reader must do based on their experience and ability. Thus, we felt it would be a service to attempt to automate the thought process experts would use when visually analyzing these graphs, particularly the most recent tail of the graph, and provide readers with an a resulting synthesis to characterize the state of the pandemic in that country, state, or county.The lack of reliable data for confirmed recoveries and therefore active cases. Merely subtracting deaths from total cases to arrive at this figure progressively loses accuracy after two weeks. The reason is 81% of cases recover after experiencing mild symptoms in 10 to 14 days. Severe cases are 14% and last 15-30 days (based on average days with symptoms of 11 when admitted to hospital plus 12 days median stay, and plus of one week to include a full range of severely affected people who recover). Critical cases are 5% and last 31-56 days. Sources:U.S. CDC. April 3, 2020 Interim Clinical Guidance for Management of Patients with Confirmed Coronavirus Disease (COVID-19). Accessed online. Initial older guidance was also obtained online. Additionally, many people who recover may not be tested, and many who are, may not be tracked due to privacy laws. Thus, the formula used to compute an estimate of active cases is: Active Cases = 100% of new cases in past 14 days + 19% from past 15-25 days + 5% from past 26-49 days - total deaths. On 3/17/2022, the U.S. calculation was adjusted to: Active Cases = 100% of new cases in past 14 days + 6% from past 15-25 days + 3% from past 26-49 days - total deaths. Sources: https://www.cdc.gov/mmwr/volumes/71/wr/mm7104e4.htm https://covid.cdc.gov/covid-data-tracker/#variant-proportions If a new variant arrives and appears to cause higher rates of serious cases, we will roll back this adjustment. We’ve never been inside a pandemic with the ability to learn of new cases as they are confirmed anywhere in the world. After reviewing epidemiological and pandemic scientific literature, three needs arose. We need to specify which portions of the pandemic lifecycle this map cover. The World Health Organization (WHO) specifies six phases. The source data for this map begins just after the beginning of Phase 5: human to human spread and encompasses Phase 6: pandemic phase. Phase six is only characterized in terms of pre- and post-peak. However, these two phases are after-the-fact analyses and cannot ascertained during the event. Instead, we describe (below) a series of five trends for Phase 6 of the COVID-19 pandemic.Choosing terms to describe the five trends was informed by the scientific literature, particularly the use of epidemic, which signifies uncontrolled spread. The five trends are: Emergent, Spreading, Epidemic, Controlled, and End Stage. Not every locale will experience all five, but all will experience at least three: emergent, controlled, and end stage.This layer presents the current trends for the COVID-19 pandemic by country (or appropriate level). There are five trends:Emergent: Early stages of outbreak. Spreading: Early stages and depending on an administrative area’s capacity, this may represent a manageable rate of spread. Epidemic: Uncontrolled spread. Controlled: Very low levels of new casesEnd Stage: No New cases These trends can be applied at several levels of administration: Local: Ex., City, District or County – a.k.a. Admin level 2State: Ex., State or Province – a.k.a. Admin level 1National: Country – a.k.a. Admin level 0Recommend that at least 100,000 persons be represented by a unit; granted this may not be possible, and then the case rate per 100,000 will become more important.Key Concepts and Basis for Methodology: 10 Total Cases minimum threshold: Empirically, there must be enough cases to constitute an outbreak. Ideally, this would be 5.0 per 100,000, but not every area has a population of 100,000 or more. Ten, or fewer, cases are also relatively less difficult to track and trace to sources. 21 Days of Cases minimum threshold: Empirically based on COVID-19 and would need to be adjusted for any other event. 21 days is also the minimum threshold for analyzing the “tail” of the new cases curve, providing seven cases as the basis for a likely trend (note that 21 days in the tail is preferred). This is the minimum needed to encompass the onset and duration of a normal case (5-7 days plus 10-14 days). Specifically, a median of 5.1 days incubation time, and 11.2 days for 97.5% of cases to incubate. This is also driven by pressure to understand trends and could easily be adjusted to 28 days. Source

Trends in Covid total deaths per million. The latest data for over 100 countries around the world.

As of January 13, 2023, there had been over 270 million confirmed cases of COVID-19 across the whole of Europe since the first confirmed case in January, 2020. Cyprus has the highest incidence of COVID-19 cases among its population in Europe at 71,853 per 100,000 people, followed by a rate of 64,449 in Austria. Slovenia has recorded the third highest rate of cases in Europe at 62,834 cases per 100,000. With almost 38.3 million confirmed cases, France has been the worst affected country in Europe, which translates into a rate of 58,945 cases per 100,000 population.

Current infection rate in Europe San Marino had the highest rate of cases per 100,000 in the past week at 336, as of January 16, 2023. Cyprus and Slovenia had seven day rates of infections at 278 and 181 respectively.

Coronavirus deaths in Europe There have been 2,169,191 recorded COVID-19 deaths in Europe since the beginning of the pandemic. Russia has the highest number of deaths recorded in a European country at over 394 thousand. Bulgaria has the highest death rate from the virus in Europe with approximately 549 deaths per 100,000 as of January 13, followed by Hungary with 496 deaths per 100,000. For further information about the coronavirus pandemic, please visit our dedicated Facts and Figures page.

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. We are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak.

Since late January, The Times has tracked cases of coronavirus in real time as they were identified after testing. Because of the widespread shortage of testing, however, the data is necessarily limited in the picture it presents of the outbreak.

We have used this data to power our maps and reporting tracking the outbreak, and it is now being made available to the public in response to requests from researchers, scientists and government officials who would like access to the data to better understand the outbreak.

The data begins with the first reported coronavirus case in Washington State on Jan. 21, 2020. We will publish regular updates to the data in this repository.

As of May 2, 2023, the outbreak of the coronavirus disease (COVID-19) had spread to almost every country in the world, and more than 6.86 million people had died after contracting the respiratory virus. Over 1.16 million of these deaths occurred in the United States.

Waves of infections Almost every country and territory worldwide have been affected by the COVID-19 disease. At the end of 2021 the virus was once again circulating at very high rates, even in countries with relatively high vaccination rates such as the United States and Germany. As rates of new infections increased, some countries in Europe, like Germany and Austria, tightened restrictions once again, specifically targeting those who were not yet vaccinated. However, by spring 2022, rates of new infections had decreased in many countries and restrictions were once again lifted.

What are the symptoms of the virus? It can take up to 14 days for symptoms of the illness to start being noticed. The most commonly reported symptoms are a fever and a dry cough, leading to shortness of breath. The early symptoms are similar to other common viruses such as the common cold and flu. These illnesses spread more during cold months, but there is no conclusive evidence to suggest that temperature impacts the spread of the SARS-CoV-2 virus. Medical advice should be sought if you are experiencing any of these symptoms.

Manually collected daily snapshots of worldometer COVID-19 data (since April 18)

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F128750%2F66baee67b3e35bf9656ff816e692527e%2Fsnapshot_worldometer_july4.png?generation=1593988535797227&alt=media" alt="">

Content

The dataset contains data about the numbers of tests, cases, deaths, serious/critical cases, active cases and recovered cases in each country for every day since April 18, and also contains the population of each country to calculate per-capita penetration of the virus

I've removed data from the "Diamond Princess" and "MS Zaandam" since they are not countries

Additionally, an auxiliray table with information about the fraction of the general population at different age groups for every country is added (taken from Wikipedia). This is specifically relevant since COVID-19 death rate is very much age dependent.

Acknowledgements

The people at "www.worldometers.info" collecting and maintaining this site really are doing very important work "https://www.worldometers.info/coronavirus/#countries">https://www.worldometers.info/coronavirus/#countries

Data about age structure for every country comes from wikipedia

Inspiration

It's possible to use this dataset for various purposes and analyses My goal will be to use the additional data about the number of tests performed in each country to estimate the true death and infection rates of COVID-19

As of May 2, 2023, the outbreak of the coronavirus disease (COVID-19) had been confirmed in almost every country in the world. The virus had infected over 687 million people worldwide, and the number of deaths had reached almost 6.87 million. The most severely affected countries include the U.S., India, and Brazil.

COVID-19: background information COVID-19 is a novel coronavirus that had not previously been identified in humans. The first case was detected in the Hubei province of China at the end of December 2019. The virus is highly transmissible and coughing and sneezing are the most common forms of transmission, which is similar to the outbreak of the SARS coronavirus that began in 2002 and was thought to have spread via cough and sneeze droplets expelled into the air by infected persons.

Naming the coronavirus disease Coronaviruses are a group of viruses that can be transmitted between animals and people, causing illnesses that may range from the common cold to more severe respiratory syndromes. In February 2020, the International Committee on Taxonomy of Viruses and the World Health Organization announced official names for both the virus and the disease it causes: SARS-CoV-2 and COVID-19, respectively. The name of the disease is derived from the words corona, virus, and disease, while the number 19 represents the year that it emerged.

Updates

• Notice of data discontinuation: Since the start of the pandemic, AP has reported case and death counts from data provided by Johns Hopkins University. Johns Hopkins University has announced that they will stop their daily data collection efforts after March 10. As Johns Hopkins stops providing data, the AP will also stop collecting daily numbers for COVID cases and deaths. The HHS and CDC now collect and visualize key metrics for the pandemic. AP advises using those resources when reporting on the pandemic going forward.

  • CDC Weekly case and death counts (national and state level)
  • CDC County level cases and deaths
  • HHS New hospital admissions
  • CDC NowCast COVID variant proportions (national and regional level)

• April 9, 2020

  • The population estimate data for New York County, NY has been updated to include all five New York City counties (Kings County, Queens County, Bronx County, Richmond County and New York County). This has been done to match the Johns Hopkins COVID-19 data, which aggregates counts for the five New York City counties to New York County.

• April 20, 2020

  • Johns Hopkins death totals in the US now include confirmed and probable deaths in accordance with CDC guidelines as of April 14. One significant result of this change was an increase of more than 3,700 deaths in the New York City count. This change will likely result in increases for death counts elsewhere as well. The AP does not alter the Johns Hopkins source data, so probable deaths are included in this dataset as well.

• April 29, 2020

  • The AP is now providing timeseries data for counts of COVID-19 cases and deaths. The raw counts are provided here unaltered, along with a population column with Census ACS-5 estimates and calculated daily case and death rates per 100,000 people. Please read the updated caveats section for more information.

• September 1st, 2020

  • Johns Hopkins is now providing counts for the five New York City counties individually.

• February 12, 2021

  • The Ohio Department of Health recently announced that as many as 4,000 COVID-19 deaths may have been underreported through the state’s reporting system, and that the "daily reported death counts will be high for a two to three-day period."
  • Because deaths data will be anomalous for consecutive days, we have chosen to freeze Ohio's rolling average for daily deaths at the last valid measure until Johns Hopkins is able to back-distribute the data. The raw daily death counts, as reported by Johns Hopkins and including the backlogged death data, will still be present in the new_deaths column.

• February 16, 2021

  - Johns Hopkins has reconciled Ohio's historical deaths data with the state.

  Overview

The AP is using data collected by the Johns Hopkins University Center for Systems Science and Engineering as our source for outbreak caseloads and death counts for the United States and globally.

The Hopkins data is available at the county level in the United States. The AP has paired this data with population figures and county rural/urban designations, and has calculated caseload and death rates per 100,000 people. Be aware that caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.

This data is from the Hopkins dashboard that is updated regularly throughout the day. Like all organizations dealing with data, Hopkins is constantly refining and cleaning up their feed, so there may be brief moments where data does not appear correctly. At this link, you’ll find the Hopkins daily data reports, and a clean version of their feed.

The AP is updating this dataset hourly at 45 minutes past the hour.

To learn more about AP's data journalism capabilities for publishers, corporations and financial institutions, go here or email kromano@ap.org.

Queries

Use AP's queries to filter the data or to join to other datasets we've made available to help cover the coronavirus pandemic

• Filter cases by state here

• Rank states by their status as current hotspots. Calculates the 7-day rolling average of new cases per capita in each state: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=481e82a4-1b2f-41c2-9ea1-d91aa4b3b1ac

• Find recent hotspots within your state by running a query to calculate the 7-day rolling average of new cases by capita in each county: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=b566f1db-3231-40fe-8099-311909b7b687&showTemplatePreview=true

• Join county-level case data to an earlier dataset released by AP on local hospital capacity here. To find out more about the hospital capacity dataset, see the full details.

• Pull the 100 counties with the highest per-capita confirmed cases here

• Rank all the counties by the highest per-capita rate of new cases in the past 7 days here. Be aware that because this ranks per-capita caseloads, very small counties may rise to the very top, so take into account raw caseload figures as well.

Interactive

The AP has designed an interactive map to track COVID-19 cases reported by Johns Hopkins.

@(https://datawrapper.dwcdn.net/nRyaf/15/)

Interactive Embed Code

<iframe title="USA counties (2018) choropleth map Mapping COVID-19 cases by county" aria-describedby="" id="datawrapper-chart-nRyaf" src="https://datawrapper.dwcdn.net/nRyaf/10/" scrolling="no" frameborder="0" style="width: 0; min-width: 100% !important;" height="400"></iframe><script type="text/javascript">(function() {'use strict';window.addEventListener('message', function(event) {if (typeof event.data['datawrapper-height'] !== 'undefined') {for (var chartId in event.data['datawrapper-height']) {var iframe = document.getElementById('datawrapper-chart-' + chartId) || document.querySelector("iframe[src*='" + chartId + "']");if (!iframe) {continue;}iframe.style.height = event.data['datawrapper-height'][chartId] + 'px';}}});})();</script>

Caveats

• This data represents the number of cases and deaths reported by each state and has been collected by Johns Hopkins from a number of sources cited on their website.
• In some cases, deaths or cases of people who've crossed state lines -- either to receive treatment or because they became sick and couldn't return home while traveling -- are reported in a state they aren't currently in, because of state reporting rules.
• In some states, there are a number of cases not assigned to a specific county -- for those cases, the county name is "unassigned to a single county"
• This data should be credited to Johns Hopkins University's COVID-19 tracking project. The AP is simply making it available here for ease of use for reporters and members.
• Caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.
• Population estimates at the county level are drawn from 2014-18 5-year estimates from the American Community Survey.
• The Urban/Rural classification scheme is from the Center for Disease Control and Preventions's National Center for Health Statistics. It puts each county into one of six categories -- from Large Central Metro to Non-Core -- according to population and other characteristics. More details about the classifications can be found here.

Johns Hopkins timeseries data - Johns Hopkins pulls data regularly to update their dashboard. Once a day, around 8pm EDT, Johns Hopkins adds the counts for all areas they cover to the timeseries file. These counts are snapshots of the latest cumulative counts provided by the source on that day. This can lead to inconsistencies if a source updates their historical data for accuracy, either increasing or decreasing the latest cumulative count. - Johns Hopkins periodically edits their historical timeseries data for accuracy. They provide a file documenting all errors in their timeseries files that they have identified and fixed here

Attribution

This data should be credited to Johns Hopkins University COVID-19 tracking project

ABSTRACT Background : The Covid-19 pandemic associated with the SARS-CoV-2 has caused very high death tolls in many countries, while it has had less prevalence in other countries of Africa and Asia. Climate and geographic conditions, as well as other epidemiologic and demographic conditions, were a matter of debate on whether or not they could have an effect on the prevalence of Covid-19. Objective : In the present work, we sought a possible relevance of the geographic location of a given country on its Covid-19 prevalence. On the other hand, we sought a possible relation between the history of epidemiologic and demographic conditions of the populations and the prevalence of Covid-19 across four continents (America, Europe, Africa, and Asia). We also searched for a possible impact of pre-pandemic alcohol consumption in each country on the two year death tolls across the four continents. Methods : We have sought the death toll caused by Covid-19 in 39 countries and obtained the registered deaths from specialized web pages. For every country in the study, we have analysed the correlation of the Covid-19 death numbers with its geographic latitude, and its associated climate conditions, such as the mean annual temperature, the average annual sunshine hours, and the average annual UV index. We also analyzed the correlation of the Covid-19 death numbers with epidemiologic conditions such as cancer score and Alzheimer score, and with demographic parameters such as birth rate, mortality rate, fertility rate, and the percentage of people aged 65 and above. In regard to consumption habits, we searched for a possible relation between alcohol intake levels per capita and the Covid-19 death numbers in each country. Correlation factors and determination factors, as well as analyses by simple linear regression and polynomial regression, were calculated or obtained by Microsoft Exell software (2016). Results : In the present study, higher numbers of deaths related to Covid-19 pandemic were registered in many countries in Europe and America compared to other countries in Africa and Asia. The analysis by polynomial regression generated an inverted bell-shaped curve and a significant correlation between the Covid-19 death numbers and the geographic latitude of each country in our study. Higher death numbers were registered in the higher geographic latitudes of both hemispheres, while lower scores of deaths were registered in countries located around the equator line. In a bell shaped curve, the latitude levels were negatively correlated to the average annual levels (last 10 years) of temperatures, sunshine hours, and UV index of each country, with the highest scores of each climate parameter being registered around the equator line, while lower levels of temperature, sunshine hours, and UV index were registered in higher latitude countries. In addition, the linear regression analysis showed that the Covid-19 death numbers registered in the 39 countries of our study were negatively correlated with the three climate factors of our study, with the temperature as the main negatively correlated factor with Covid-19 deaths. On the other hand, cancer and Alzheimer's disease scores, as well as advanced age and alcohol intake, were positively correlated to Covid-19 deaths, and inverted bell-shaped curves were obtained when expressing the above parameters against a country’s latitude. Instead, the (birth rate/mortality rate) ratio and fertility rate were negatively correlated to Covid-19 deaths, and their values gave bell-shaped curves when expressed against a country’s latitude. Conclusion : The results of the present study prove that the climate parameters and history of epidemiologic and demographic conditions as well as nutrition habits are very correlated with Covid-19 prevalence. The results of the present study prove that low levels of temperature, sunshine hours, and UV index, as well as negative epidemiologic and demographic conditions and high scores of alcohol intake may worsen Covid-19 prevalence in many countries of the northern hemisphere, and this phenomenon could explain their high Covid-19 death tolls. Keywords : Covid-19, Coronavirus, SARS-CoV-2, climate, temperature, sunshine hours, UV index, cancer, Alzheimer disease, alcohol.

Overview

This is the data repository for the 2019 Novel Coronavirus Visual Dashboard operated by the Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE). This database was created in response to the Coronavirus public health emergency to track reported cases in real-time. The data include the location and number of confirmed COVID-19 cases, deaths and recoveries for all affected countries, aggregated at the appropriate province or state. It was developed to enable researchers, public health authorities and the general public to track the outbreak as it unfolds. Additional information is available in the blog post, Mapping 2019-nCoV (https://systems.jhu.edu/research/public-health/ncov/), and included data sources are listed here: https://github.com/CSSEGISandData/COVID-19

Sample Query 1

How many confirmed COVID-19 cases were there in the US, by state? This query determines the total number of cases by province in February. A "province_state" can refer to any subset of the US in this particular dataset, including a county or state. SELECT province_state, confirmed AS feb_confirmed_cases, FROM bigquery-public-data.covid19_jhu_csse.summary WHERE country_region = "US" AND date = '2020-02-29' ORDER BY feb_confirmed_cases desc

Sample Query 2

Which countries with the highest number of confirmed cases have the most per capita? This query joins the Johns Hopkins dataset with the World Bank's global population data to determine which countries among those with the highest total number of confirmed cases have the most confirmed cases per capita.

with country_pop AS( SELECT IF(country = "United States","US",IF(country="Iran, Islamic Rep.","Iran",country)) AS country, year_2018 FROM bigquery-public-data.world_bank_global_population.population_by_country)

SELECT cases.date AS date, cases.country_region AS country_region, SUM(cases.confirmed) AS total_confirmed_cases, SUM(cases.confirmed)/AVG(country_pop.year_2018) * 100000 AS confirmed_cases_per_100000 FROM bigquery-public-data.covid19_jhu_csse.summary cases JOIN country_pop ON cases.country_region LIKE CONCAT('%',country_pop.country,'%') WHERE cases.country_region = "US" AND country_pop.country = "US" AND cases.date = DATE_SUB(current_date(),INTERVAL 1 day) GROUP BY country_region, date

UNION ALL

SELECT cases.date AS date, cases.country_region AS country_region, SUM(cases.confirmed) AS total_confirmed_cases, SUM(cases.confirmed)/AVG(country_pop.year_2018) * 100000 AS confirmed_cases_per_100000 FROM bigquery-public-data.covid19_jhu_csse.summary cases JOIN country_pop ON cases.country_region LIKE CONCAT('%',country_pop.country,'%') WHERE cases.country_region = "France" AND country_pop.country = "France" AND cases.date = DATE_SUB(current_date(),INTERVAL 1 day) GROUP BY country_region, date

UNION ALL

SELECT cases.date AS date, cases.country_region AS country_region, SUM(cases.confirmed) AS total_confirmed_cases, SUM(cases.confirmed)/AVG(country_pop.year_2018) * 100000 AS confirmed_cases_per_100000 FROM bigquery-public-data.covid19_jhu_csse.summary cases JOIN country_pop ON cases.country_region LIKE CONCAT('%',country_pop.country,'%') WHERE cases.country_region = "China" AND country_pop.country = "China" AND cases.date = DATE_SUB(current_date(),INTERVAL 1 day)

GROUP BY country_region, date

UNION ALL

SELECT cases.date AS date, cases.country_region AS country_region, cases.confirmed AS total_confirmed_cases, cases.confirmed/country_pop.year_2018 * 100000 AS confirmed_cases_per_100000 FROM bigquery-public-data.covid19_jhu_csse.summary cases JOIN country_pop ON cases.country_region LIKE CONCAT('%',country_pop.country,'%') WHERE cases.country_region IN ("Italy", "Spain", "Germany", "Iran") AND cases.date = DATE_SUB(current_date(),INTERVAL 1 day) ORDER BY confirmed_cases_per_100000 desc

Dataset source

JHU CSSE

Update frequency

Daily

As of March 10, 2023, the state with the highest rate of COVID-19 cases was Rhode Island followed by Alaska. Around 103.9 million cases have been reported across the United States, with the states of California, Texas, and Florida reporting the highest numbers of infections.

From an epidemic to a pandemic The World Health Organization declared the COVID-19 outbreak as a pandemic on March 11, 2020. The term pandemic refers to multiple outbreaks of an infectious illness threatening multiple parts of the world at the same time; when the transmission is this widespread, it can no longer be traced back to the country where it originated. The number of COVID-19 cases worldwide is roughly 683 million, and it has affected almost every country in the world.

The symptoms and those who are most at risk Most people who contract the virus will suffer only mild symptoms, such as a cough, a cold, or a high temperature. However, in more severe cases, the infection can cause breathing difficulties and even pneumonia. Those at higher risk include older persons and people with pre-existing medical conditions, including diabetes, heart disease, and lung disease. Those aged 85 years and older have accounted for around 27 percent of all COVID deaths in the United States, although this age group makes up just two percent of the total population

COVID-19 Stats & Trends

Context

This dataset seeks to provide insights into what has changed due to policies aimed at combating COVID-19 and evaluate the changes in community activities and its relation to reduced confirmed cases of COVID-19. The reports chart movement trends, compared to an expected baseline, over time (from 2020/02/15 to 2020/02/05) by geography (across 133 countries), as well as some other stats about the country that might help explain the evolution of the disease.

Content

1. Grocery & Pharmacy: Mobility trends for places like grocery markets, food warehouses, farmers' markets, specialty food shops, drug stores, and pharmacies.
2. Parks: Mobility trends for places like national parks, public beaches, marinas, dog parks, plazas, and public gardens.
3. Residential: Mobility trends for places of residence.
4. Retail & Recreation: Mobility trends for places like restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters.
5. Transit stations: Mobility trends for places like public transport hubs such as subway, bus, and train stations.
6. Workplaces: Mobility trends for places of work.
7. Total Cases: Total number of people infected with the SARS-CoV-2.
8. Fatalities: Total number of deaths caused by CoV-19.
9. Government Response Stringency Index: Additive score of nine indicators of government response to CoV-19: School closures, workplace closures, cancellation of public events, public information campaigns, stay at home policies, restrictions on internal movement, international travel controls, testing policy, and contact tracing.
10. COVID-19 Testing: Total number of tests performed.
11. Total Vaccinations: Total number of shots given.
12. Total People Vaccinated: Total number of people given a shot.
13. Total People Fully Vaccinated: Total number of people fully vaccinated (might require two shots of some vaccines).
14. Population: Total number of inhabitants.
15. Population Density per km2: Number of human inhabitants per square kilometer.
16. Health System Index: Overall performance of the health system.
17. Human Development Index (HDI): Summary index based on life expectancy at birth, expected years of schooling for children and mean years of schooling for adults, and GNI per capita.
18. GDP (PPP) per capita: Gross Domestic Product (GDP) per capita based on Purchasing Power Parity (PPP), taking into account the relative cost of local goods, services and inflation rates of the country, rather than using international market exchange rates, which may distort the real differences in per capita income.
19. Elderly Population (percentage): Percentage of the population above the age of 65 years old.

References & Acknowledgements

Bing COVID-19 data. Available at: https://github.com/microsoft/Bing-COVID-19-Data COVID-19 Community Mobility Report. Available at: https://www.google.com/covid19/mobility/ COVID-19: Government Response Stringency Index. Available at: https://ourworldindata.org/grapher/covid-stringency-index Coronavirus (COVID-19) Testing. Available at: https://github.com/owid/covid-19-data/blob/master/public/data/testing/covid-testing-all-observations.csv Coronavirus (COVID-19) Vaccination. Available at: https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/vaccinations/vaccinations.csv List of countries and dependencies by population. Available at: https://www.kaggle.com/tanuprabhu/population-by-country-2020 List of countries and dependencies by population density. Available at: https://www.kaggle.com/tanuprabhu/population-by-country-2020 List of countries by Human Development Index. Available at: http://hdr.undp.org/en/data Measuring Overall Health System Performance. Available at: https://www.who.int/healthinfo/paper30.pdf?ua=1 List of countries by GDP (PPP) per capita. Available at: https://data.worldbank.org/indicator/NY.GDP.PCAP.PP.CD List of countries by age structure (65+). Available at: https://data.worldbank.org/indicator/SP.POP.65UP.TO.ZS

Authors

• Diogo Silva, up201706892@fe.up.pt

This file contains the dataset and the results of the statistical analyses to identify the national factors related to the number of COVID-19 infections and COVID-19 deaths in each country. The dataset includes the dependent variables (the cumulative number of COVID-19 infections and the cumulative number of COVID-19 deaths as of March 31, April 30, May 31, and June 30, 2020), independent variables (national culture, The degree of corruption in the country and the policy on COVID-19, temperature and precipitation of each country, and GDP per capita), and control variables (population density, median age, and obesity rates of the country, the number of days that COVID-19 has been detected for the first time in a country, and the presence or absence of forced BCG vaccination policy). This file also contains the descriptive statistics of all variables, the results of the correlation analyses, and the results of the regression analyses.

Mexico SALUD: COVID-19: No. of Deaths: To Date: Baja California Sur data was reported at 2,748.000 Person in 24 Oct 2022. This stayed constant from the previous number of 2,748.000 Person for 23 Oct 2022. Mexico SALUD: COVID-19: No. of Deaths: To Date: Baja California Sur data is updated daily, averaging 1,506.000 Person from Feb 2020 (Median) to 24 Oct 2022, with 970 observations. The data reached an all-time high of 2,748.000 Person in 24 Oct 2022 and a record low of 0.000 Person in 31 Mar 2020. Mexico SALUD: COVID-19: No. of Deaths: To Date: Baja California Sur data remains active status in CEIC and is reported by Ministry of Health. The data is categorized under High Frequency Database’s Disease Outbreaks – Table MX.D001: Ministry of Health: Coronavirus Disease 2019 (COVID-2019) (Discontinued). Current day data is released daily between 7PM and 11PM Mexico City Time. Weekend data are updated following Monday morning, Hong Kong Time. Number of Deaths are based on the state where it is reported.

As of January 13, 2023, Bulgaria had the highest rate of COVID-19 deaths among its population in Europe at 548.6 deaths per 100,000 population. Hungary had recorded 496.4 deaths from COVID-19 per 100,000. Furthermore, Russia had the highest number of confirmed COVID-19 deaths in Europe, at over 394 thousand.

Number of cases in Europe During the same period, across the whole of Europe, there have been over 270 million confirmed cases of COVID-19. France has been Europe's worst affected country with around 38.3 million cases, this translates to an incidence rate of approximately 58,945 cases per 100,000 population. Germany and Italy had approximately 37.6 million and 25.3 million cases respectively.

Current situation In March 2023, the rate of cases in Austria over the last seven days was 224 per 100,000 which was the highest in Europe. Luxembourg and Slovenia both followed with seven day rates of infections at 122 and 108 respectively.

Background : Substantial differences between countries were observed in terms of Covid-19 death tolls during the past two years. It was of interest to find out how the epidemiologic and/or demographic history of the population may have had a role in the high prevalence of the Covid-19 in some countries. Objective : This observational study aimed to investigate possible relations between Covid-19 death numbers in 39 countries and the prepandemic history of epidemiologic and demographic conditions. Methods : We sought the Covid-19 death toll in 39 countries in Europe, America, Africa, and Asia. Records (2019) of epidemiologic (Cancer, Alzheimer's disease) and demographic (natality, mortality, and fetility rates, percentage of people aged 65 and over) parameters as well as data on alcohol intake per capita were retrieved from official web pages. Data was analysed by simple linear or polynomial regression by the mean of Microsoft Excell software (2016). Results : When Covid-19 death numbers were plotted against the geographic latitude of each country, a bell-shaped curve was obtained for both the first and second years (coefficient of determination R2=0.38) of the pandemic. In a similar manner, bell-shaped curves were obtained when latitudes were plotted against the scores of (cancer plus Alzheimer's disease, R² = 0,65,), the percentage of advanced age (R² = 0,52,) and the alcohol intake level (R² = 0,64,). Covid-19 death numbers were positively correlated to the scores of (cancer plus Alzheimer's disease) (R2= 0.41, P= 1.61x10-5), advanced age (R2= 0.38, P= 4.09x10-5) and alcohol intake (R2= 0.48, P= 1.55x10-6). Instead, inverted bell-shaped curves were obtained when latitudes were plotted against the birth rate/mortality rate ratio (R² = 0,51) and the fetility rate (R² = 0,33). In addition, Covid-19 deaths were negatively correlated with the birth rate/mortality rate ratio (R2= 0.67) and fertility rate (R2= 0.50). Conclusion : The results show that the 39 countries in both hemisphers in this study have different patterns of epidemiologic and demographic factors, and that the negative history of epidemiologic and demographic factors of the northern hemisphere countries, as well as their high alcohol intake, were very correlated with their Covid-19 death tolls. Hence, also nutritional habits may have had a role in the general health status of people in regard to their immunity against the coronavirus.

Stepwiseb'*' multiple regression for covid-19 cases and deaths.