download_trend_tables: Download HCUP Summary Trend Tables

In HCUPtools: Access and Work with HCUP Resources and Datasets

Download HCUP Summary Trend Tables

Description

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.

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

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).

Examples

# List available tables
available_tables <- download_trend_tables()
print(available_tables)

# Download a specific table
table_path <- download_trend_tables("2a")

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

HCUPtools documentation built on July 13, 2026, 9:06 a.m.