HCUPtools (version 1.0.0)

download_trend_tables: 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)

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

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

Examples

# \donttest{
# List available tables
available_tables <- download_trend_tables()
print(available_tables)

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

# Download all tables
all_tables <- download_trend_tables("all")
# }