Context

As per latest report from WHO : 23 states/UTs including New Delhi have issued orders allowing only essential services to operate in 75 districts with confirmed COVID-19 cases until 31 March 2020. The focus is on closure of all activities except essential services such as hospitals, telecom, pharmacy, provision stores. • PM Modi called for 'Janata curfew' on 22 March from 7 AM-9 PM, urging people to stay home except those in essential services, enforcing publicled social distancing interventions. • In consultation with medical professionals, detailed advisory has been issued for all health establishments to avoid non-urgent hospitalization and minimize elective surgeries.

Content

A very simple dataset, clearly understanding, containing 3 csv files, one each for death, cured and confirmed cases of COVID-19. The rows contains states and the columns are dates. Here the data is the number of cases.

Acknowledgements

1. Ministry of Health & Family Welfare
2. covid19india.org

Inspiration

I was working on a datascience project related to covid-19, and was using dataset available on kaggle. Then I thought, it would be great if i can make my own dataset, that is easy to use, without much cleaning.

Datasets in this publication report the number of diagnoses with coronavirus disease (COVID-19) based on RIVM reports in The Netherlands. Since 3 March, RIVM reports the number of diagnoses with the coronavirus and their municipality of residence on a daily base. The data contains the total number of positively tested patients. It is not a dataset with the current number of sick people in the Netherlands. The RIVM does not currently provide data on people who have been cured.

RIVM provides daily updates of the data. The data is not stored in a persistent way and is updated on the fly. RIVM removes data from previous days from their website. Therefore, it is not possible to monitor the spread of the coronavirus disease in the Netherlands on this data standalone. The data in this publication is composed of hourly downloads of the data of the website of RIVM. All code to compose the data was found on https://github.com/J535D165/CoronaWatchNL as well as graphs based on the data.

Context

This dataset has been collected from multiple sources provided by MVCR on their websites and contains daily summarized statistics as well as details statistics up to age & sex level.

Content

What's inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too.

Columns description

Date - Calendar date when data were collected Daily tested - Sum of tests performed Daily infected - Sum of confirmed cases those were positive Daily cured - Sum of cured people that does not have Covid-19 anymore Daily deaths - Sum of people those died on Covid-19 Daily cum tested - Cumulative sum of tests performed Daily infected - Cumulative sum of confirmed cases those were positive Daily cured - Cumulative sum of cured people that does not have Covid-19 anymore Daily deaths - Cumulative sum of people those died on Covid-19 Region - Region of Czech republic Sub-Region - Sub-Region of Czech republic Region accessories qty - Quantity of health care accessories delivered to region for all the time Age - Age of person Sex - Sex of person Infected - Sum of infected people for specific date, region, sub-region, age and sex Cured - Sum of cured people for specific date, region, sub-region, age and sex Death - Sum of people those dies on Covid-19 for specific date, region, sub-region, age and sex Infected abroad - Identifies if person was infected by Covid-19 in Czech republic or abroad Infected in country - code of country from where person came (origin country of Covid-19)

Data granularity

Dataset contains data on different level of granularities. Make sure you do not mix different granularities. Let's suppose you have loaded data into pandas dataframe called df.

Day level

df_daily = df.groupby(['date']).max()[['daily_tested','daily_infected','daily_cured','daily_deaths','daily_cum_tested','daily_cum_infected','daily_cum_cured','daily_cum_deaths']].reset_index()

Region level

df_region = df[df['region'] != ''].groupby(['region']).agg(
  region_accessories_qty=pd.NamedAgg(column='region_accessories_qty', aggfunc='max'), 
  infected=pd.NamedAgg(column='infected', aggfunc='sum'),
  cured=pd.NamedAgg(column='cured', aggfunc='sum'),
  death=pd.NamedAgg(column='death', aggfunc='sum')
).reset_index()

Detail level

df_detail = df[['date','region','sub_region','age','sex','infected','cured','death','infected_abroad','infected_in_country']].reset_index(drop=True)

Acknowledgements

Thanks to websites of MVCR for sharing such great information.

Inspiration

Can you see relation between health care accessories delivered to region and number of cured/infected in that region? Why Czech Republic belongs to pretty safe countries when talking about Covid-19 Pandemic? Can you find out what is difference of pandemic evolution in Czech Republic comparing to other surrounding coutries, like Germany or Slovakia?

TL;DR

Our free COVID-19 Stats and New API lets you send a web-based query to Smartable AI and get back details about global and regional coronavirus data, including latest numbers, historic values, and geo-breakdowns. It is the same API that powers our popular COVID-19 stats pages. Developers can take the returned information and display it in their own tools, apps and visualizations. Different from other coronavirus data sources that produce breaking changes from time to time, the data from our API are more stable, **detailed **and close to real-time, as we leverage AI to gather information from many credible sources. With a few clicks in our API try-it experience, developers can get it running quickly and unleash their creativity.

Click here to get started

Our Mission

“We’re not just fighting an epidemic; we’re fighting an infodemic” – WHO Director-General Tedros Adhanom Ghebreyesus

In Smartable AI, our mission is to use AI to help you be smart in this infodemic world. Information is exploded, and mis-information has impacted the decisions of governments, businesses, and citizens around the world, as well as individuals’ lives. In 2018, The World Economic Forum identified it as one of the top 10 global risks. In a recent study, the economic impact has been estimated to be upwards of 80-100 Billion Dollars. Everything we do is focused on fighting misinformation, curating quality content, putting information in order and leveraging technology to bring clean, organized information through our APIs. Everyone wins when they can make sense of the world around them.

Our Free API and Daily Data Dump

The coronavirus stats and news API offers the latest and historic COVID-19 stats and news information per country or state. The stats are refreshed every hour using credible data sources, including the country/state’s official government websites, data available on wikipedia pages, latest news reports, Johns Hopkins University CSSE 2019-nCoV Dashboard, WHO Situation Reports, CDC Situation Updates, and DXY.cn.

The API takes the location ISO code as input (e.g. US, US-MA), and returns the latest numbers (confirmed, deaths, recovered), the delta from yesterday, the full history in that location, and geo-breakdown when applicable. We offer detailed API documentation, a try-it experience, and code examples in many different programming languages.

https://smartable.azureedge.net/media/2020/03/coronavirus-api-documentation.webp" alt="API Documentation">

We upload a daily dump of the data in the csv format here.

We want it to be a collaborative effort. If you have any additional requirements for the API or observe anything wrong with the data, we welcome you to report issues in our GitHub account. The team will jump in right away. All our team members are ex-Microsoft employees, so you can trust the quality of support, I guess 🙂

Our Example Apps powered by the API

We have developed two example apps by using the API.

• COVID-19 Live Stats+News
• COVID-19 Android app