Early Warning for Karnataka Districts




Our primary aim is to understand infection spread across the states in India and districts of Karnataka. At the State level we provide run time monitoring of $R_t$, Active Cases, and provide an Early warning system for each state. For Karnataka, our analysis is detailed at the district level: we track Deceased data, Active cases, $R_t$, provide a one week prediction for them and an Early warning system for each.

Raw Data from Media Bulletins
  • Summary for All India
  • This csv file contains the counts of infected [both Indian and Foreign nationals], recovered and deceased for each state with at least one COVID-19 case. The rows correspond to different states and the columns represent the daily counts. Each day corresponds to four columns: Total Confirmed cases of Indian Nationals [TCIN], Total Confirmed cases of Foreign Nationals [TCFN], Recoveries [Cured] and Deaths [Death] for that day. This file is updated from the MOHFW website.

    Plots: Active Cases
  • Karnataka Vaccination Data
  • This csv file contains information about weekly dose 1 and dose 2 vaccination across all districts in Karnataka. The columns have data on:

    1. The district name.
    2. The dose 1 percentage with respect to adult population.
    3. The dose 2 percentage with respect to adult population.
    4. The number of people who have taken 1st dose of vaccination.
    5. The number of people who have taken 2nd dose of vaccination.
    6. 2020 projected population.
    7. 2011 census (above 18) population.
    8. Factor used to obtain the projected population from the census population.
    [Plots]
  • Karnataka District Timeline
  • This csv file contains counts of the infected, recovered and deceased patients districtwise in Karnataka. The data is organized as follows:
    1. Each row represents a District.
    2. For each date, there are 3 columns representing the total number of infected patients, the total number of recoveries and the total number of deceased patients.

    Plots: Active Cases
  • Karnataka Deceased Information
  • This csv file contains information on each patient who has passed away due to COVID-19 in Karnataka. The columns have data on:
    1. The district that the patient belongs to.
    2. The State P Code for that patient.
    3. The age of the patient, given in years.
    4. The sex of the patient.
    5. The description of the patient including why they were tested and which cluster they fall in.
    6. The symptoms of the patients.
    7. Any co-morbidities that the patients might have had.
    8. The date at which they were admitted to the hospital. For the patients who were brought dead or passed away at their residence, that has been mentioned.
    9. The date on which they passed away.
    10. The date of the media bulletin they appeared in.

    [Plots]
  • Karnataka Testing information
  • This csv file contains information on the testing and screening done by the Karnataka government. The rows represent dates from 12th March, 2020 onwards. The columns have data on:
    1. Samples tested on that day
    2. Among those samples returned that day, those that tested negative
    3. Among those samples returned that day, those that tested positive
    4. The count of people in observation
    5. The number of passengers screened at the KIA airport [when it was available]
    6. The number of passengers screened at the Mangalore airport [till it was available]
    7. The number of patients screened at the seaports in Mangalore and Karwar [till it was available]

    Plots: Positivity Rate
  • Karnataka Hospitalization Consolidated
  • The media bulletins on 9th May, 10th May and 11th May, and from 15th May onward, did not have patient-wise data of patients in ICU and the patients discharged. However, the consolidated counts had been given.Hence we have created a new csv file containing the total counts of Active, Recovered, Discharged and ICU patients. This file has the following information:

    1. Date- From 9th March onward.
    2. Active cases- The number of patients that are hospitalized on the given date, but do not require ICU, ICUV or ICUO.
    3. Discharged cases- The total number of patients discharged till the corresponding date.
    4. Deceased patients- The total number of deceased patients till the corresponding date.
    5. ICU Requirement- The count of patients in ICU, ICUV or ICUO on the given date. ICU stands for Intensive Care Unit, ICUV stands for ICU and ventilator and ICUO stands for ICU and oxygen.



  • Karnataka Hospitalization information
  • (FROZEN-May15th 2021)

    This csv file contains information on the patients regarding their hospitalization. Each row corresponds to a patient as indexed by the Media Bulletins and the columns correspond to different days, starting from 9th March, 2020. The entries in the cells are either H [implying they were hospitalized on that day], C [Cured], D [Deceased], ICU [required an ICU], ICUO [ICU and required Oxygen] or ICUV [ICU and required Ventilator support].


Derived Statistics from Media Bulletins
  • India-States $R_t$
  • This csv file contains information about weekly reproduction numbers across all states and union territories in India. The columns have data on:

    1. The date under consideration.
    2. The rest of the columns contain the state/union territory name.
    [Plots]
  • Karnataka-Districts- $R_t$
  • This csv file contains information about weekly reproduction numbers across all districts in Karnataka. The columns have data on:

    1. The date under consideration.
    2. The rest of the columns contain the district names.
    [Plots]
  • Karnataka-Districts- Early Warning System
  • This CSV file containscontains information on every district in Karnataka, with the columns having data on:
    1. The name of the district.
    2. The date.
    3. The current active cases.
    4. The rate(lamda-t).
    5. The days to 50 per million cases of the total population.
    6. The days to 1000 per million cases of the total population.
    7. The days to 1500 per million cases of the total population.
    8. The days to 0.2% of population cases.
    9. The population as on 2011.
    10. The projected Population on 2020.
    11. Population-50 per million.
    12. Population-1000 per million.
    13. Population-1500 per million.
    14. 0.2% of total population.
    [Plots]
  • India-States- Early Warning System
  • This CSV file containscontains information on every Indian state and union territory, with the columns having data on:
    1. The name of state/union territory.
    2. The date.
    3. The current active cases.
    4. The rate(lamda-t).
    5. The days to 50 per million cases of the total population.
    6. The days to 1000 per million cases of the total population.
    7. The days to 1500 per million cases of the total population.
    8. The days to 0.2% of population cases.
    9. The population as on 2011.
    10. The projected Population on 2020.
    11. Population-50 per million.
    12. Population-1000 per million.
    13. Population-1500 per million.
    14. 0.2% of total population.
    [Plots]
  • Karnataka District $7$-day prediction
  • This CSV filecontains information about the forth coming week's predictions of expected daily cases and cumulative cases across all districts in Karnataka. The columns have data on:
    1. The district name.
    2. The next set of the columns contain the predicted cases across the next 7 days.
    3. The last set of the columns contain the one-standard deviation values for each day in the coming week, corresponding to the particular district.
    [Plots]
  • Karnataka Trace History
  • (FROZEN-July26th, 2021) In this csv file, one row corresponds to one case of coronavirus in Karnataka. For each patient [case], the columns contain the following information:
    1. Case number - As recognized by the Karnataka Government
    2. Date - When they tested positive
    3. Age
    4. Sex
    5. City - Contains both the city where a patient is held and the city of their residence.
    6. State- Karnataka for all cases
    7. Cluster - Divided according to the clusters we have in the Karnataka trace history.
    8. Further information on the clusters
      • From USA : The patients who had travel history to USA and their contacts.
      • From United Kingdom : The patients with travel history to UK and their contacts.
      • From the rest of Europe : The patients with travel history to Europe but not to UK and their contacts.
      • From Middle East : The patients with travel to the Middle East and their contacts.
      • Unknown : The patients who have been listed in the Media Bulletins as "Contact Under Tracing"and their contacts.
      • From South America : The patients with travel history to South America and their contacts.
      • Pharmaceutical Company in Nanjangud : This patients who were workers of a Pharmaceutical Company in Nanjangud, Mysore along with their contacts.
      • From the Southern States : The patients with travel to Kerala, Tamil Nadu, Andhra Pradesh or Telengana and their contacts. This doesn't contain patients with interdistrict travel in Karnataka
      • Others : The patients who had interdistrict travel in Karnataka, travel to countries / states, healthcare workers and policemen on COVID-19 duty and their contacts. The numbers for these reasons were too few to form separate clusters.
      • TJ Congregation from 13th to 18th March in Delhi : The patients with travel history to the TJ Congregation in Delhi and their contacts.
      • Severe Acute Respiratory Infection: This includes patients with a history of Severe Acute Respiratory Infection whose symptoms have resurfaced and their contacts.
      • Influenza like illness : The patients showing influenza like symptoms and their contacts.
      • From Gujarat : The patients with travel history to Gujarat and their contacts.
      • Containment Zones : The patients who were contacts of Conatinment Zones and their contacts. Some patients have the Ward represented in the Reason column.
      • From Maharashtra : The patients with travel history to Maharashtra and their contacts.
      • From Rajasthan : The patients with travel history to Rajasthan and their contacts.
      • 27-June Trace History Absent : On this day, no trace history information was given for the patients. Patients who were contacts of these individuals are also in this cluster.
      • 28-June Trace History Absent : On this day, no trace history information was given for the patients. Patients who were contacts of these individuals are also in this cluster.
      • 29-June Trace History Absent : On this day, no trace history information was given for the patients. Patients who were contacts of these individuals are also in this cluster.
      • Domestic Travel History Absent : The patients for whom the information was given as "Travel History-Domestic"
      • International Travel History Absent : The patients for whom the information was given as "Travel History-International"
      • Second Generation Contact Absent : The patients whose information was given as "Contact" without giving the patient ID of the individual they were a contact of.
    9. Reason - This mentions the patients place of travel or their relationship with the person they contracted the disease from.
    10. Nationality - India for all the cases
    11. Status as of today - in terms of Cured/Deceased. If nothing is mentioned, they are currently hospitalized.
    12. In case the patient they contracted the virus from is known, this column mentions the case number of the "parent."
    13. Indicator of secondary infections caused - The entries of this column are either 0 or 1 and indicate if the patient has caused any [known] secondary infections.
    14. Relationship - Their relationship with any other infected individual, listed as the type of relationship along with the case number of the other infected individual. The different classifications are:
      • C represents close contact.
      • S represents spouse.
      • T represents travel companion.
      • F represents family.

    [Trace History Plots]

The data are sourced from the Ministry of Health and Family Welfare (MOHFW) website and Media Bulletins published regularly by the Karnataka government. The data available on these websites is in the form of PDF files where it's difficult to extract automatically. We have collected this data and collated it to form the following csv files from where it can used easily by the public. Below we provide all the data in csv format.