COVID-19 Hospital Data Coverage for Hospital in Suspense

This report shows facilities currently in suspense regarding CoP requirements due to being in a work plan or other related reasons is shown if any facilities are currently in suspense. These CCNs will not be included in the tab listing all other hospitals or included in any summary counts while in suspense.<br>

01/05/2024 – As of FAQ 6, the following optional fields have been added to this report:

<li>total_adult_patients_hospitalized_confirmed_influenza<li>total_pediatric_patients_hospitalized_confirmed_influenza<li>previous_day_admission_adult_influenza_confirmed<li>previous_day_admission_pediatric_influenza_confirmed<li>staffed_icu_adult_patients_confirmed_influenza<li>staffed_icu_pediatric_patients_confirmed_influenza<li>total_adult_patients_hospitalized_confirmed_rsv<li>total_pediatric_patients_hospitalized_confirmed_rsv<li>previous_day_admission_adult_rsv_confirmed<li>previous_day_admission_pediatric_rsv_confirmed<li>staffed_icu_adult_patients_confirmed_rsv<li>staffed_icu_pediatric_patients_confirmed_rsv<li>6/17/2023 - With the new 28-day compliance reporting period, CoP reports will be posted <b>every 4 weeks</b>.</li><li>9/12/2021 - To view other COVID-19 Hospital Data Coverage datasets, follow this link to view summary page:

https://healthdata.gov/stories/s/ws49-ddj5 </li>

As of FAQ3, the following field are federally inactive and will no longer be included in this report:

<li>previous_week_personnel_covid_vaccinated_doses_administered</li><li>total_personnel_covid_vaccinated_doses_none</li><li>total_personnel_covid_vaccinated_doses_one</li><li>total_personnel_covid_vaccinated_doses_all</li><li>total_personnel</li><li>previous_week_patients_covid_vaccinated_doses_one</li><li>previous_week_patients_covid_vaccinated_doses_all</li>

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"healthdata-gov/covid19-hospital-data-coverage-for-hospital-in-a6za-z3xi\".\"covid19_hospital_data_coverage_for_hospital_in\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.