Skip to contents

Download HCUP Summary Trend Tables

Source: R/download_trend_tables.R
download_trend_tables.Rd

Downloads HCUP Summary Trend Tables from the HCUP website. These tables provide information on hospital utilization derived from HCUP databases, including trends in inpatient and emergency department utilization.

Usage

download_trend_tables(table_id = NULL, dest_dir = NULL, cache = TRUE)

Arguments

table_id

Character string or numeric specifying which table to download. Can be:

  • A table number (e.g., "1", "2a", "6b", "11c") for specific tables

  • "all" to download all available tables as a ZIP file

  • NULL (default) to show an interactive menu for selecting a table (in interactive sessions), or return a list of available tables (in non-interactive sessions)

dest_dir

Character string specifying the destination directory for the downloaded file(s). If NULL (default), files are saved to a temporary directory.

cache

Logical. If TRUE (default), downloaded files are cached to avoid re-downloading on subsequent calls.

Value

If table_id is NULL and session is non-interactive, returns a data frame listing available tables. Otherwise, returns the path(s) to the downloaded file(s).

Details

The HCUP Summary Trend Tables include information on:

  • Overview of trends in inpatient and emergency department utilization

  • All inpatient encounter types

  • Inpatient encounter types (normal newborns, deliveries, elective/non-elective stays)

  • Inpatient service lines (maternal/neonatal, mental health, injuries, surgeries, etc.)

  • ED treat-and-release visits

Each table is available as an Excel file with state-specific, region-specific, and national statistics.

The function automatically discovers available tables by scraping the HCUP website, so it will automatically adapt to new tables or version changes.

For more information, see: https://hcup-us.ahrq.gov/reports/trendtables/summarytrendtables.jsp

Examples

# \donttest{
# List available tables
available_tables <- download_trend_tables()
#> Warning: Could not fetch trend tables from HCUP website: Failed to perform HTTP request.
#> Caused by error in `curl::curl_fetch_memory()`:
#> ! Timeout was reached [hcup-us.ahrq.gov]:
#> Connection timed out after 30002 milliseconds. Using fallback method.
print(available_tables)
#> NULL

# Download a specific table
table_path <- download_trend_tables("2a")
#> Warning: Could not fetch trend tables from HCUP website: Failed to perform HTTP request.
#> Caused by error in `curl::curl_fetch_memory()`:
#> ! Timeout was reached [hcup-us.ahrq.gov]:
#> Connection timed out after 30001 milliseconds. Using fallback method.
#> Error in download_trend_tables("2a"): Invalid table_id. Use download_trend_tables() to see available tables.

# Bulk ZIP (\code{table_id = "all"}) is only available when HCUP publishes a
# combined file; otherwise use individual IDs from the listing above.
# }