Name: COVID-19 In India
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

COVID-19 In India

Context

Coronaviruses are a large family of viruses which may cause illness in animals or humans. In humans, several coronaviruses are known to cause respiratory infections ranging from the common cold to more severe diseases such as Middle East Respiratory Syndrome (MERS) and Severe Acute Respiratory Syndrome (SARS). The most recently discovered coronavirus causes coronavirus disease COVID-19 - World Health Organization

The number of new cases are increasing day by day around the world. This dataset has information from the states and union territories of India at daily level.

State level data comes from Ministry of Health & Family Welfare

Testing data and vaccination data comes from covid19india. Huge thanks to them for their efforts!

Update on April 20, 2021: Thanks to the Team at ISIBang, I was able to get the historical data for the periods that I missed to collect and updated the csv file.

Content

COVID-19 cases at daily level is present in covid_19_india.csv file

Statewise testing details in StatewiseTestingDetails.csv file

Travel history dataset by @dheerajmpai - https://www.kaggle.com/dheerajmpai/covidindiatravelhistory

Acknowledgements

Thanks to Indian Ministry of Health & Family Welfare for making the data available to general public.

Thanks to covid19india.org for making the individual level details, testing details, vaccination details available to general public.

Thanks to Wikipedia for population information.

Thanks to the Team at ISIBang

Photo Courtesy - https://hgis.uw.edu/virus/

Inspiration

Looking for data based suggestions to stop / delay the spread of virus

Tables

Covid 19 India

@kaggle.sudalairajkumar_covid19_in_india.covid_19_india

366.01 KB
18110 rows
9 columns


CREATE TABLE covid_19_india (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "state_unionterritory" VARCHAR,
  "confirmedindiannational" VARCHAR,
  "confirmedforeignnational" VARCHAR,
  "cured" BIGINT,
  "deaths" BIGINT,
  "confirmed" BIGINT
);

Covid Vaccine Statewise

@kaggle.sudalairajkumar_covid19_in_india.covid_vaccine_statewise

610.73 KB
7845 rows
24 columns


CREATE TABLE covid_vaccine_statewise (
  "updated_on" TIMESTAMP,
  "state" VARCHAR,
  "total_doses_administered" DOUBLE,
  "sessions" DOUBLE,
  "n__sites" DOUBLE,
  "first_dose_administered" DOUBLE,
  "second_dose_administered" DOUBLE,
  "male_doses_administered" DOUBLE,
  "female_doses_administered" DOUBLE,
  "transgender_doses_administered" DOUBLE,
  "n__covaxin_doses_administered" DOUBLE,
  "covishield_doses_administered" DOUBLE,
  "sputnik_v_doses_administered" DOUBLE,
  "aefi" DOUBLE,
  "n_18_44_years_doses_administered" DOUBLE,
  "n_45_60_years_doses_administered" DOUBLE,
  "n_60_years_doses_administered" DOUBLE,
  "n_18_44_years_individuals_vaccinated" DOUBLE,
  "n_45_60_years_individuals_vaccinated" DOUBLE,
  "n_60_years_individuals_vaccinated" DOUBLE,
  "male_individuals_vaccinated" DOUBLE,
  "female_individuals_vaccinated" DOUBLE,
  "transgender_individuals_vaccinated" DOUBLE,
  "total_individuals_vaccinated" DOUBLE
);

Statewisetestingdetails

@kaggle.sudalairajkumar_covid19_in_india.statewisetestingdetails

216.83 KB
16336 rows
5 columns


CREATE TABLE statewisetestingdetails (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "totalsamples" DOUBLE,
  "negative" VARCHAR,
  "positive" DOUBLE
);