Exporting Covid Act Now Data to a Spreadsheet

If you’re more familiar with editing or manipulating a spreadsheet than you are with code, we have good news! You can now export the data from Covid Act Now‘s model to your favorite spreadsheet, such as Google Sheets or Microsoft Excel.

The Covid Act Now API, which we launched yesterday, exports in CSV (comma separated value) format. This format can be easily imported into a spreadsheet.

We offer forward projections on the effects of COVID-19 for 50 U.S. States and more than 2,000 U.S. Counties. The projections are available by intervention type. (For more on “inference projections,” see this blog post.)

No Action TakenSocial DistancingShelter-in-Place“Inference Projections”
U.S. StatesDownloadDownloadDownloadDownload
U.S. CountiesDownloadDownloadDownloadDownload

To import into Microsoft Excel, first open Excel and select the File Menu. Then, choose Open (File => Open). Navigate and select the CSV you just downloaded.

To import into Google Sheets, first create a new blank Google Sheet. Then choose File => Open. Choose Upload and drag-and-drop the CSV file you just downloaded.

The data is updated at least every three days, and we include a “last updated” field in the download so you can ensure your data is fresh.

If you are in the government using our data to plan your response to COVID, you can reach out to us at gov@covidactnow.org. Or if you’d like to provide general feedback, thoughts, or questions, you can email us at info@covidactnow.org.

Return to covidactnow.org


Recent Posts