Evolving data and assumptions: Why we are removing our old hospital projections

Covid Act Now (CAN) began as a spreadsheet model to forecast when hospitals would be overwhelmed, based on whether or not interventions (e.g. shelter-at-home) were put in place. We’ve come a long way since then. As of today, we’ll no longer be showing “Future Hospitalization Projections.”

These projections were focused on hospital bed capacity, but we’ve since learned that the number of staffed ICU beds is the critical limiting resource. We already have a key indicator for COVID ICU Headroom, which is designed to alert when ICUs might be running out of beds while leaving sufficient time for policymakers to react.

We will maintain the projections in our API.

Check out our Youtube Channel for our educational videos.

To learn more about Covid Act Now, visit our about page. For more information please reach out on our contact page or by email at info@covidactnow.org.

Sign up to our alerts to stay up-to-date on the COVID risk level in your area.

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. StatesDownloadDownloadDownloadDownloadU.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