tsadata
TSA Passenger Screening Data for R.
Provides easy access to Transportation Security Administration (TSA) passenger screening data. The package streams data directly from cloud storage into DuckDB, enabling efficient analysis of daily passenger volumes and detailed hourly checkpoint throughput.
Installation
remotes::install_git("https://codeberg.org/usrbinr/tsadata")Usage
library(tsadata)
# Connect to TSA data
db <- create_tsa_duckdb()
# Daily screening totals (2021-present)
db$daily |> head()
# Hourly checkpoint throughput (2010-present, ~10 million rows)
db$throughput |>
dplyr::filter(Airport == "LAX") |>
head()
# Launch interactive DuckDB UI
launch_ui(db$con)
# Clean up when done
DBI::dbDisconnect(db$con, shutdown = TRUE)Data Sources
- Daily totals: TSA Passenger Volumes
- Hourly throughput: TSA FOIA Electronic Reading Room