Show how many hospitals have filed weekly reports in a state.

This query finds the number of weekly reports filed in a given state. Enter the state's two digit postal code below and hit 'Run SQL'.

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 collection_week, count(*) from hosp_capacity where state = :state group by  1    order by collection_week desc;

Query parameters

Edit SQL

0 results

Powered by Datasette · Query took 0.844ms