search

covid19india / api

Moved to https://github.com/covid19india/data/
https://api.covid19india.org
MIT License
678 stars 605 forks source link

District data is too large to import into Google Sheets #462

Closed a-baheti closed 3 years ago

a-baheti commented 3 years ago

Using the function =IMPORTDATA("https://api.covid19india.org/csv/latest/districts.csv") gives the following error: Resource at URL contents exceeded maximum size, because the data has too many rows.

Can this data be put in a wide format, similar to State Wise Daily (_https://api.covid19india.org/csv/latest/state_wise_daily.csv_) data? If every district were a column, it would be possible to import the live data into Google Sheets.

sudevschiz commented 3 years ago

Hi, Wide format was found to be impractical as the are 700+ districts. Since the format has been established, it would be problematic to change it now as it might break some other applications.

There are custom Google Scripts available to import large data to Google Sheets. Otherwise, consider downloading the csv and imorting it.

Thank you.