Skip to content

pawangupta5167/api-1

 
 

Repository files navigation

COVID19-India API

Announcement

We have stopped capturing testing data at a district level. Please check the status of the API endpoints below.

CSV

Sometimes, having files in a spreadsheet format is more useful for analysts and scientists. We have provided the files as downloadable csv files as below.

Files available

Latest data from the google sheet (10-20 minutes delayed) is available through the latest end-point. These are the files available

Raw Data

Status Sheet Name Link to CSV Description
💚 raw_data1 https://api.covid19india.org/csv/latest/raw_data1.csv Till Apr 19th
💚 raw_data2 https://api.covid19india.org/csv/latest/raw_data2.csv Apr 20th to Apr 26th
💚 raw_data3 https://api.covid19india.org/csv/latest/raw_data3.csv Apr 27th to May 9th
💚 raw_data4 https://api.covid19india.org/csv/latest/raw_data4.csv May 10th to May 23rd
💚 raw_data5 https://api.covid19india.org/csv/latest/raw_data5.csv May 24th to Jun 4th
💚 raw_data6 https://api.covid19india.org/csv/latest/raw_data6.csv Jun 05th to Jun 19th
💚 raw_data7 https://api.covid19india.org/csv/latest/raw_data7.csv Jun 20th to Jun 30th
💚 raw_data8 https://api.covid19india.org/csv/latest/raw_data8.csv Jul 01st to Jul 7th
💚 raw_data9 https://api.covid19india.org/csv/latest/raw_data9.csv Jul 08th to Jul 13th
💚 raw_data10 https://api.covid19india.org/csv/latest/raw_data10.csv Jul 14th to Jul 17th
💚 raw_data11 https://api.covid19india.org/csv/latest/raw_data11.csv Jul 18th to Jul 22nd
💚 raw_data12 https://api.covid19india.org/csv/latest/raw_data12.csv Jul 23th to Aug 06th
💚 raw_data13 https://api.covid19india.org/csv/latest/raw_data13.csv Aug 07th to Aug 21st
💚 raw_data14 https://api.covid19india.org/csv/latest/raw_data14.csv Aug 22nd to Sep 05th
💚 raw_data15 https://api.covid19india.org/csv/latest/raw_data15.csv Sep 06th to Sep 21st
💚 raw_data16 https://api.covid19india.org/csv/latest/raw_data16.csv Sep 22nd to Oct 08th
💚 raw_data17 https://api.covid19india.org/csv/latest/raw_data17.csv Oct 09th to Oct 26th
💚 raw_data18 https://api.covid19india.org/csv/latest/raw_data18.csv Oct 27th to Nov 12th
💚 raw_data19 https://api.covid19india.org/csv/latest/raw_data19.csv Nov 13th to Nov 30th
💚 raw_data20 https://api.covid19india.org/csv/latest/raw_data20.csv Dec 01st to Dec 19th
💚 raw_data21 https://api.covid19india.org/csv/latest/raw_data21.csv Dec 20th to Jan 08th
💚 raw_data22 https://api.covid19india.org/csv/latest/raw_data22.csv Jan 09th to Jan 31st
💚 raw_data23 https://api.covid19india.org/csv/latest/raw_data23.csv Feb 01st onwards

Other Sheets

Status Sheet Name Link to CSV Description
💚 case_time_series https://api.covid19india.org/csv/latest/case_time_series.csv Time series of Confirmed, Recovered and Deceased cases in India
💚 state_wise https://api.covid19india.org/csv/latest/state_wise.csv The latest State-wise situation
💚 district_wise https://api.covid19india.org/csv/latest/district_wise.csv The latest District-wise situation
💚 state_wise_daily https://api.covid19india.org/csv/latest/state_wise_daily.csv Statewise timeseries of Confirmed, Recovered and Deceased numbers.
💚 states https://api.covid19india.org/csv/latest/states.csv Statewise timeseries of Confirmed, Recovered and Deceased numbers in long format
💚 districts https://api.covid19india.org/csv/latest/districts.csv Districtwise timeseries of Confirmed, Recovered and Deceased numbers in long format
💚 statewise_tested_numbers_data https://api.covid19india.org/csv/latest/statewise_tested_numbers_data.csv Number of tests conducted in each state, ventilators ,hospital bed occupany reported in state bulletins
💚 tested_numbers_icmr_data https://api.covid19india.org/csv/latest/tested_numbers_icmr_data.csv Number of tests reported by ICMR
💚 icmr_labs_statewise https://api.covid19india.org/csv/latest/icmr_labs_statewise.csv Number of Labs in each state as per ICMR
💚 sources_list https://api.covid19india.org/csv/latest/sources_list.csv List of sources that we are using.
💚 rtpcr_samples_collected http://api.covid19india.org/csv/latest/icmr_rtpcr_tests_daily.csv Number of RTPCR samples collected statewise in ICMR Application

Note

  • Use raw data files only if you need to analyze the demographics or notes related at a patient level
  • Always try to use the aggregated numbers above as they have been treated for discrepancies

How to

If you prefer working on a Google Sheet instead of downloading the files and would like the data to reflect the latest version - below is an example to live fetch this CSV to a spreadsheet.

🚀 Quick example : Apply the formula =IMPORTDATA("https://api.covid19india.org/csv/latest/state_wise.csv") in A1 cell of a Google Sheets to get the state data for analysis :)

How this works

  • Data in this repository is generated from Google Sheets
  • Volunteers collect data from trusted sources and update the sheet
  • Github Actions periodically fetch the data from the sheet and upload static json and csv files into gh-pages branch of this repo
  • gh-pages serves the json/csv files at https://api.covid19india.org

License

This repository contains both the code that routinely fetches the data from Google Sheet and convert it into JSON files in the required format and the data itself (in the gh-pages branch). So, the content of this repository is licensed in two ways : Code and Data

License for Code (Consider this as everything in the master branch) : MIT License (Detailed in LICENSE_CODE.txt)
License for Data (Consider this as everything in the gh-pages branch) : CC-BY-4.0 License (Detailed in LICENSE_DATA.txt)

Citation

You can cite us in your work in the following format

@misc{covid19indiaorg2020tracker,
  author = {COVID-19 India Org Data Operations Group},
  title = {{Dataset for tracking COVID-19 spread in India}},
  howpublished = {Accessed on yyyy-mm-dd from \url{https://api.covid19india.org/}},
  year = 2020
}

Contributing

Quick Links


Team Projects Using This API

..............................................

About

Our Database

Resources

License

MIT, CC-BY-4.0 licenses found

Licenses found

MIT
LICENSE_CODE
CC-BY-4.0
LICENSE_DATA

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 72.6%
  • JavaScript 26.0%
  • Shell 1.4%