Show how many hospitals anticipate a staffing shortage this week in a state

Enter the state's two letter postal abbreviation in capital letters.Note that not all hospitals answer this question. Refer to the corresponding _coverage variables for specifics.

This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.

Custom SQL query (hide)

select date, sum(critical_staffing_shortage_anticipated_within_week_yes) as shortage_anticipated, sum(critical_staffing_shortage_anticipated_within_week_no) as no_shortage_anticipated, sum(critical_staffing_shortage_anticipated_within_week_not_reported) as not_reported from hospitals_state where date > '2020/10/01' and state = :state group by date order by date desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 17.803ms