Skip to content

Import Covid-19 data from Johns Hopkins University into Microsoft Excel and Google Sheets.

License

Notifications You must be signed in to change notification settings

flexiodata/functions-covid-19-feed

Repository files navigation

Covid-19 Data Google Sheets & Excel Spreadsheet Add-on

A variety of data about Covid-19 is available on GitHub in CSV format. Three important sources include Github Repositories with data from John's Hopkin's University, the New York Times, and Our World In Data.

The Flex.io Covid-19 spreadsheet functions allow data from these sources to be easily accessed in a spreadsheet as a function with search capabilities. Here are some examples:

  • Return rows containing "Illinois" and "Cook" between 2020-04-01 and 2020-04-30 with all information from John's Hopkin's Covid-19 incident data:
=FLEX("covid-19-cases-jhu", "*", "+Illinois +Cook +date:[2020-04-01 TO 2020-04-30]")
  • Return rows containing "Illinois" for "2020-04-01" with all information from New York Times Covid-19 incident data:
=FLEX("covid-19-cases-nyt", "*", "+Illinois +date:2020-04-01")
  • Return rows containing "CDC" and "United States" with all information from "Our World In Data" Covid-19 test data:
=FLEX("covid-19-tests-owid", "*", "+CDC +\"United States\"")

This repository contains the code that implements the data feed to pull data from the various repositories to populate an index that powers the functions in the Flex.io Covid-19 integration. The actual functions are available in the Flex.io Covid-19 Repository. See below for information about how to install the functions to access data from this feed.

Prerequisites

The Flex.io Covid-19 spreadsheet functions utilize Flex.io. To use these functions, you'll need:

Installing the Functions

Once you've signed up for Flex.io and have the Flex.io Add-on installed, you're ready to install the function pack. To install the function pack, go to the Flex.io Covid-19 Integration and click "TRY IT NOW".

If you prefer, you can also install these functions directly by mounting this repository in Flex.io:

  1. Sign in to Flex.io
  2. In the Functions area, click the "New" button in the upper-left and select "Function Mount" from the list
  3. In the function mount dialog, select "GitHub", then authenticate with your GitHub account
  4. In the respository URL box, enter the name of this repository, which is "flexiodata/functions-covid-19"
  5. Click "Create Function Mount"

Using the Functions

Once you've installed the function pack, you're ready to use the functions.

  1. Open Microsoft Excel or Google Sheets
  2. Open the Flex.io Add-in:
    • In Microsoft Excel, select Home->Flex.io
    • In Google Sheets, select Add-ons->Flex.io
  3. In the Flex.io side bar, log in to Flex.io and you’ll see the functions you have installed
  4. For any function, click on the “details” in the function list to open a help dialog with some examples you can try at the bottom
  5. Simply copy/paste the function into a cell, then edit the formula with a value you want to use

Sources

The data for the Flex.io Add-on is pulled from data curated by John's Hopkins University, the New York Times, and Our World In Data. The data for each of these is available per the individual licenses in each of the respective repositories. Here are links to the sources and related information.

Data from Johns Hopkins Center for Systems Science and Engineering:

Data from The New York Times, based on reports from state and local health agencies:

Data from Our World In Data, based on data collected by the Our World in Data team from official reports:

Documentation

Here are some additional resources:

  • Flex.io Covid-19 Function Documentation. Here, you'll find a list of the functions available, their syntax and parameters, as well as examples for how to use them.
  • Flex.io Covid-19 Integration and Templates. Here, you'll find more information about the Flex.io Covid-19 integration as well as templates you can use to start using the integration easily.
  • Flex.io Add-ons. Here, you'll find more information about the Flex.io Add-ons for Microsoft Excel and Google Sheets, including how to install them and use them.
  • Flex.io Integrations. Here, you'll find out more information about other spreadsheet function packs available.

Help

If you have question or would like more information, please feel free to live chat with us at our website or contact us via email.

License

This project is licensed under the MIT License. See the LICENSE file for details.

Releases

No releases published

Packages

No packages published

Languages