This dataset, titled "Global COVID-19 Statistics - Jan 2025," contains the latest COVID-19 statistics collected from the Worldometer website on Jan 09, 2025. The data includes crucial metrics such as the total number of cases, deaths, recoveries, and active cases for countries around the world. The information is extracted from the comprehensive table provided by Worldometer, which is widely regarded as a reliable source for real-time coronavirus statistics. Source and Collection Date Source: Worldometer Coronavirus Page Date of Collection: Jan 09, 2025

Embark on a journey of COVID-19 data analysis with this meticulously crafted Kaggle database, sourced from the trusted Worldometers website (https://www.worldometers.info/coronavirus/). In this solo project, I've taken on the task of uploading, cleaning, and preparing the data to ensure it meets the highest standards of quality and readability for visualization.

Key Features:

1. Self-Sourced Data: As a solo project, I've personally gathered and maintained the COVID-19 data from Worldometers. This dataset is a testament to my dedication to delivering accurate and up-to-date information on the global pandemic.

2. Data Cleaning with Power Query: Leveraging the power of Power Query, I've meticulously cleaned and structured the data. Addressing issues such as missing values, data inconsistencies, and numerical formatting, I've taken extra care to enhance data reliability.

3. Data Quality Assurance: Ensuring data integrity is paramount. I've conducted rigorous quality checks to guarantee the dataset's accuracy and reliability. This dataset is a reflection of my commitment to providing trustworthy data.

4. User-Friendly Visualization: Recognizing the importance of visualizing data, I've formatted the dataset for easy visualization. It's primed for creating informative charts, graphs, and dashboards. The structured data simplifies the process, making it accessible even for solo analysts.

5. Comprehensive COVID-19 Insights: Covering various facets of the pandemic, including daily new cases, deaths, recovered cases, total cases, and more, this dataset serves as a valuable resource for tracking global and regional trends.

6. Frequent Updates: In my solo endeavor, I aim to keep this dataset regularly updated to reflect the latest pandemic developments. You can trust this dataset as a reliable source for your ongoing research and analysis.

Context

Learning Web Scraping in order to build my own datasets, and this is the first one in the learning process. Let's try and build great datasets in the future for better analysis and predictions.

Content

Scraped the data on March 10, 2020, from https://www.worldometers.info/world-population/population-by-country/ Dataset represents the population count country-wise for a specific time period.

Acknowledgements

Firstly, Thanks to the Content creator on the website https://www.worldometers.info, who provides reliable data on the internet. Secondly, To the Tutor who taught me how to scrape websites.

Inspiration

Is this dataset valuable? Where can we utilize this dataset in data science?

Analysis of ‘Population by Country - 2020’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/tanuprabhu/population-by-country-2020 on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Context

I always wanted to access a data set that was related to the world’s population (Country wise). But I could not find a properly documented data set. Rather, I just created one manually.

Content

Now I knew I wanted to create a dataset but I did not know how to do so. So, I started to search for the content (Population of countries) on the internet. Obviously, Wikipedia was my first search. But I don't know why the results were not acceptable. And also there were only I think 190 or more countries. So then I surfed the internet for quite some time until then I stumbled upon a great website. I think you probably have heard about this. The name of the website is Worldometer. This is exactly the website I was looking for. This website had more details than Wikipedia. Also, this website had more rows I mean more countries with their population.

Once I got the data, now my next hard task was to download it. Of course, I could not get the raw form of data. I did not mail them regarding the data. Now I learned a new skill which is very important for a data scientist. I read somewhere that to obtain the data from websites you need to use this technique. Any guesses, keep reading you will come to know in the next paragraph.

https://fiverr-res.cloudinary.com/images/t_main1,q_auto,f_auto/gigs/119580480/original/68088c5f588ec32a6b3a3a67ec0d1b5a8a70648d/do-web-scraping-and-data-mining-with-python.png" alt="alt text">

You are right its, Web Scraping. Now I learned this so that I could convert the data into a CSV format. Now I will give you the scraper code that I wrote and also I somehow found a way to directly convert the pandas data frame to a CSV(Comma-separated fo format) and store it on my computer. Now just go through my code and you will know what I'm talking about.

Below is the code that I used to scrape the code from the website

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F3200273%2Fe814c2739b99d221de328c72a0b2571e%2FCapture.PNG?generation=1581314967227445&alt=media" alt="">

Acknowledgements

Now I couldn't have got the data without Worldometer. So special thanks to the website. It is because of them I was able to get the data.

Inspiration

As far as I know, I don't have any questions to ask. You guys can let me know by finding your ways to use the data and let me know via kernel if you find something interesting

--- Original source retains full ownership of the source dataset ---

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.

Analysis of ‘World Population by Year’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/sansuthi/world-population-by-year on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Variables:

• Year: 1951 to 2020
• Population: World Population
• ChangePerc: Yearly Change in Percentage
• NetChange: Total Yearly Change
• Density: Density in P/Km²
• Urban: Urban Population
• UrbanPerc: Urban Population Percentage

Source of content: www.worldometers.info

--- Original source retains full ownership of the source dataset ---

Context

I would love to see notebooks! Keep bringin' em.

Content

Worldometer manually analyzes, validates, and aggregates data from thousands of sources in real time and provides global COVID-19 live statistics for a wide audience of caring people around the world.

Our data is also trusted and used by the UK Government, Johns Hopkins CSSE, the Government of Thailand, the Government of Vietnam, the Government of Pakistan, Financial Times, The New York Times, Business Insider, BBC, and many others.

Acknowledgements

Acknowledge Sujay S

Inspiration

Thanks to blogs out there on medium! That made me do this!

In this dataset we can find information related to the population of all the countries listed in the website Worldometers. The dataset is composed, among others, with information like Country, Total Cases, New Cases or TotalDeaths. The dataset was created with the idea to implement it in any project where this information could help to fight against 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.

Coronavirus disease 2019 (COVID-19) has developed into a global pandemic, affecting every nation and territory in the world. Machine learning-based approaches are useful when trying to understand the complexity behind the spread of the disease and how to contain its spread effectively. The unsupervised learning method could be useful to evaluate the shortcomings of health facilities in areas of increased infection as well as what strategies are necessary to prevent disease spread within or outside of the country. To contribute toward the well-being of society, this paper focusses on the implementation of machine learning techniques for identifying common prevailing public health care facilities and concerns related to COVID-19 as well as attitudes to infection prevention strategies held by people from different countries concerning the current pandemic situation. Regression tree, random forest, cluster analysis and principal component machine learning techniques are used to analyze the global COVID-19 data of 133 countries obtained from the Worldometer website as of April 17, 2020. The analysis revealed that there are four major clusters among the countries. Eight countries having the highest cumulative infected cases and deaths, forming the first cluster. Seven countries, United States, Spain, Italy, France, Germany, United Kingdom, and Iran, play a vital role in explaining the 60% variation of the total variations by us of the first component characterized by all variables except for the rate variables. The remaining countries explain only 20% of the variation of the total variation by use of the second component characterized by only rate variables. Most strikingly, the analysis found that the variable number of tests by the country did not play a vital role in the prediction of the cumulative number of confirmed cases.

Context

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F1843297%2F662051bd1966c60846f34eea7ed837a3%2FScreenshot%20from%202020-04-20%2023-08-44.png?generation=1587655709318285&alt=media" alt="">

I created a few models for predicting the COVID-19 Total Cases, Total Deaths, and Total Active Cases. The model can be download here. I also created a website to display predicted charts for major countries that has great number of infection.

Content

The rows are showing the Date and the Total. The columns are showing how much total (e.g. cases) over time.

Acknowledgements

The data was extracted and scrapped from [worldometers.info)[https://worldometers.info] website into CSV file format.

Inspiration

I hope these extracted data can help others in their model faster.

COVID-19 Dataset for Epidemic Model Development

I combined several data sources to gain an integrated dataset involving country-level COVID-19 confirmed, recovered and fatalities cases which can be used to build some epidemic models such as SIR, SIR with mortality. Adding information regarding population which can be used for calculating incidence rate and prevalence rate. One of my applications based on this dataset is published at https://dylansp.shinyapps.io/COVID19_Visualization_Analysis_Tool/.

Content

My approach is to retrieve cumulative confirmed cases, fatalities and recovered cases since 2020-01-22 onwards from the Johns Hopkins University Center for Systems Science and Engineering (JHU CSSE) COVID-19 dataset, merged with country code as well as population of each country. For the purpose of building epidemic models, I calculated information regarding daily new confirmed cases, recovered cases, and fatalities, together with remaining confirmed cases which equal to cumulative confirmed cases - cumulative recovered cases - cumulative fatalities. I haven't yet to find creditable data sources regarding probable cases of various countries yet. I'll add them once I found them.

• Date: The date of the record.
• Country_Region: The name of the country/region. -alpha-3_code: country code for that can be used for map visualization.
• Population: The population of the given country/region.
• Total_Confirmed_Cases: Cumulative confirmed cases.
• Total_Fatalities: Cumulative fatalities.
• Total_Recovered_Cases: Cumulative recovered cases.
• New_Confirmed_Cases: Daily new confirmed cases.
• New_Fatalities: Daily new fatalities.
• New_Recovered_Cases: Daily new recovered cases.
• Remaining_Confirmed_Cases: Remaining infected cases which equal to (cumulative confirmed cases - cumulative recovered cases - cumulative fatalities).

Acknowledgements

1. The data source of confirmed cases, recovered cases and deaths is JHU CSSE https://github.com/CSSEGISandData/COVID-19;
2. The data source of the country-level population mainly comes from https://storage.guidotti.dev/covid19/data/ and Worldometer (https://www.worldometers.info/population/).

Inspiration

1. Building up the country-level COVID-19 case track dashboard.
2. Insights regarding the incidence rate, prevalence rate, mortality and recovery rate of various countries.
3. Building up epidemic models for forecasting.

Context

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). Also, Supported by ESRI Living Atlas Team and the Johns Hopkins University Applied Physics Lab (JHU APL).

Data Source

• World Health Organization (WHO): https://www.who.int/
• DXY.cn. Pneumonia. 2020. http://3g.dxy.cn/newh5/view/pneumonia.
• BNO News: https://bnonews.com/index.php/2020/02/the-latest-coronavirus-cases/
• National Health Commission of the People’s Republic of China (NHC):
• http://www.nhc.gov.cn/xcs/yqtb/list_gzbd.shtml
• China CDC (CCDC): http://weekly.chinacdc.cn/news/TrackingtheEpidemic.htm
• Hong Kong Department of Health: https://www.chp.gov.hk/en/features/102465.html
• Macau Government: https://www.ssm.gov.mo/portal/
• Taiwan CDC: https://sites.google.com/cdc.gov.tw/2019ncov/taiwan?authuser=0
• US CDC: https://www.cdc.gov/coronavirus/2019-ncov/index.html
• Government of Canada: https://www.canada.ca/en/public-health/services/diseases/coronavirus.html
• Australia Government Department of Health: https://www.health.gov.au/news/coronavirus-update-at-a-glance
• European Centre for Disease Prevention and Control (ECDC): https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases
• Ministry of Health Singapore (MOH): https://www.moh.gov.sg/covid-19
• Italy Ministry of Health: http://www.salute.gov.it/nuovocoronavirus
• 1Point3Arces: https://coronavirus.1point3acres.com/en
• WorldoMeters: https://www.worldometers.info/coronavirus/
• COVID Tracking Project: https://covidtracking.com/data. (US Testing and Hospitalization Data. We use the maximum reported value from "Currently" and - - - "Cumulative" Hospitalized for our hospitalization number reported for each state.)
• French Government: https://dashboard.covid19.data.gouv.fr/

Terms of Use

This GitHub repo and its contents herein, including all data, mapping, and analysis, copyright 2020 Johns Hopkins University, all rights reserved, is provided to the public strictly for educational and academic research purposes. The Website relies upon publicly available data from multiple sources, that do not always agree. The Johns Hopkins University hereby disclaims any and all representations and warranties with respect to the Website, including accuracy, fitness for use, and merchantability. Reliance on the Website for medical guidance or use of the Website in commerce is strictly prohibited.

Context

This data set contains details about the total number of COVID patients in each country, which will help in a better understanding of how each country coped with COVID, how many tests each country conducted, and so on.

Content

The data set contains information about total COVID patients, recovered cases, active cases, new cases, new deaths, total deaths, the total number of tests conducted by the government, and the total population of each country.

Acknowledgements

I have collected this data from the website worldometer.com, where latest updates on COVID is available country-wise.

Inspiration

I created this data set to analyze how each country has coped with the pandemic, and which countries have been successfully able to halt or stop the spread of the virus.

Context

A dataset of all recorded Covid-19 related figures from 12th March 2020 to 27th August 2020. I scraped the data from https://www.worldometers.info/coronavirus/country/ghana/ with python. The source of that data is https://www.ghanahealthservice.org/covid19/latest.php

Note At the moment, there seems to be a problem with the data the ghana health service updated on the 8th and 9th April. The data, I scraped did not contain the recovered cases. So I got the recovered cases by Recovered Cases = Total Cumulative Cases - Active Cases - Deaths On the 8th April 2020, this is how things stood Total Cases: 313, Total Deaths: 6, Active Cases: 273 Hence the cumulative recovered cases was at the time: 313 - 273 - 6 = 34

On the 9th April 2020, this is how things stood Total Cases: 378, Total Deaths: 6, Active Cases: 369 Hence the cumulative recovered cases were: 378 - 369 - 6 = 3 ??

This has lead to there being -31 daily recovered cases on 9th April 2020.

I crossed checked the dataset with a popular repository of COVID-19 cases on github with almost 24k stars (https://github.com/CSSEGISandData/COVID-19) 8th April: (https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_daily_reports/04-08-2020.csv), 9th April:(https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_daily_reports/04-09-2020.csv) and I realized that the anomaly still prevailed. This has therefore led me to have some doubts about the data released by the Ghana Health Service to the general public.

Context

Covid-19 Data collected from various sources on the internet. This dataset has daily level information on the number of affected cases, deaths, and recovery from the 2019 novel coronavirus. Please note that this is time-series data and so the number of cases on any given day is the cumulative number.

Content

The dataset includes 28 files scrapped from various data sources mainly the John Hopkins GitHub repository, the ministry of health affairs India, worldometer, and Our World in Data website. The details of the files are as follows

• countries-aggregated.csv A simple and cleaned data with 5 columns with self-explanatory names. -covid-19-daily-tests-vs-daily-new-confirmed-cases-per-million.csv A time-series data of daily test conducted v/s daily new confirmed case per million. Entity column represents Country name while code represents ISO code of the country. -covid-contact-tracing.csv Data depicting government policies adopted in case of contact tracing. 0 -> No tracing, 1-> limited tracing, 2-> Comprehensive tracing. -covid-stringency-index.csv The nine metrics used to calculate the Stringency Index are school closures; workplace closures; cancellation of public events; restrictions on public gatherings; closures of public transport; stay-at-home requirements; public information campaigns; restrictions on internal movements; and international travel controls. The index on any given day is calculated as the mean score of the nine metrics, each taking a value between 0 and 100. A higher score indicates a stricter response (i.e. 100 = strictest response). -covid-vaccination-doses-per-capita.csv A total number of vaccination doses administered per 100 people in the total population. This is counted as a single dose, and may not equal the total number of people vaccinated, depending on the specific dose regime (e.g. people receive multiple doses). -covid-vaccine-willingness-and-people-vaccinated-by-country.csv Survey who have not received a COVID vaccine and who are willing vs. unwilling vs. uncertain if they would get a vaccine this week if it was available to them. -covid_india.csv India specific data containing the total number of active cases, recovered and deaths statewide. -cumulative-deaths-and-cases-covid-19.csv A cumulative data containing death and daily confirmed cases in the world. -current-covid-patients-hospital.csv Time series data containing a count of covid patients hospitalized in a country -daily-tests-per-thousand-people-smoothed-7-day.csv Daily test conducted per 1000 people in a running week average. -face-covering-policies-covid.csv Countries are grouped into five categories: 1->No policy 2->Recommended 3->Required in some specified shared/public spaces outside the home with other people present, or some situations when social distancing not possible 4->Required in all shared/public spaces outside the home with other people present or all situations when social distancing not possible 5->Required outside the home at all times regardless of location or presence of other people -full-list-cumulative-total-tests-per-thousand-map.csv Full list of total tests conducted per 1000 people. -income-support-covid.csv Income support captures if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. 0->No income support, 1->covers less than 50% of lost salary, 2-> covers more than 50% of the lost salary. -internal-movement-covid.csv Showing government policies in restricting internal movements. Ranges from 0 to 2 where 2 represents the strictest. -international-travel-covid.csv Showing government policies in restricting international movements. Ranges from 0 to 2 where 2 represents the strictest. -people-fully-vaccinated-covid.csv Contains the count of fully vaccinated people in different countries. -people-vaccinated-covid.csv Contains the total count of vaccinated people in different countries. -positive-rate-daily-smoothed.csv Contains the positivity rate of various countries in a week running average. -public-gathering-rules-covid.csv Restrictions are given based on the size of public gatherings as follows: 0->No restrictions 1 ->Restrictions on very large gatherings (the limit is above 1000 people) 2 -> gatherings between 100-1000 people 3 -> gatherings between 10-100 people 4 -> gatherings of less than 10 people -school-closures-covid.csv School closure during Covid. -share-people-fully-vaccinated-covid.csv Share of people that are fully vaccinated. -stay-at-home-covid.csv Countries are grouped into four categories: 0->No measures 1->Recommended not to leave the house 2->Required to not leave the house with exceptions for daily exercise, grocery shopping, and ‘essent...