cdc-gov/covid19-hospital-data-from-the-national-hospital-q3t8-zr7t
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 6 months ago
Indexed 1 month ago

COVID-19 Hospital Data from the National Hospital Care Survey

The National Hospital Care Survey (NHCS) collects data on patient care in hospital-based settings to describe patterns of health care delivery and utilization in the United States. Settings currently include inpatient and emergency departments (ED). Additionally, the NHCS contributes data that may inform public health emergencies as the survey is designed to capture emerging diseases and viruses that require hospitalizations, including COVID-19 encounters. The 2020 - 2023 NHCS are not yet fully operational so it is important to note that these data are not nationally representative.

The data are from 25 hospitals submitting inpatient and 25 hospitals submitting ED Uniform Bill (UB)-04 administrative claims from March 18, 2020-May 23, 2023. Even though the data are not nationally representative, they can provide insight on the impact of COVID-19 on various types of hospitals throughout the country. This information is not available in other hospital reporting systems. The NHCS data from these hospitals can show results by a combination of indicators related to COVID-19, such as length of inpatient stay, in-hospital mortality, comorbidities, and intubation or ventilator use. NHCS data allow for reporting on patient conditions and treatments within the hospital over time.

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 \"cdc-gov/covid19-hospital-data-from-the-national-hospital-q3t8-zr7t\".\"covid19_hospital_data_from_the_national_hospital\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_hospital_data_from_the_national_hospital
     
     
     
     
     
Upstream Metadata