sfo_passengers {sfo}

SFO Airport Air Traffic Passenger Statistics

Description

Monthly summary of number of passengers in San Francisco International Airport (SFO)

Usage

sfo_passengers

Format

A data frame with 12 variables.

activity_period

Activity year and month in YYYYMM format

operating_airline

Airline name for the aircraft operator

operating_airline_iata_code

The International Air Transport Association (IATA) two-letter designation for the Operating Airline

published_airline

Airline name that issues the ticket and books revenue for passenger activity

published_airline_iata_code

The International Air Transport Association (IATA) two-letter designation for the Published Airline

geo_summary

The flights’ classification by domestic for flights that arrived from or departed to a destination within the United States and international for destinations outside the United States

geo_region

The flight origin/destination geographic region details

activity_type_code

A description of the physical action a passenger took in relation to a flight, which includes boarding a flight (“enplanements”), getting off a flight (“deplanements”) and transiting to another location (“intransit”)

price_category_code

A categorization of whether a Published Airline is a low-cost carrier or not a low-cost carrier

terminal

The airport’s terminal designations at SFO where passenger activity took place

boarding_area

The airport’s boarding area designations at SFO where passenger activity took place

passenger_count

The number of monthly passengers associated with the above attribute fields

Details

The dataset contains the monthly summary of number of passengers in San Francisco International Airport (SFO)

Source

San Francisco data portal (DataSF) website.

Examples

data(sfo_passengers)

require(dplyr)

# Get summary of total number of passengers by activity type
# in most recent month
sfo_passengers %>%
  filter(activity_period == max(activity_period)) %>%
  group_by(activity_type_code) %>%
  summarise(total = sum(passenger_count), .groups = "drop")

# Get summary of total number of passengers by
# activity type and geo region in most recent month
sfo_passengers %>%
filter(activity_period == max(activity_period)) %>%
  group_by(activity_type_code, geo_region) %>%
  summarise(total = sum(passenger_count), .groups = "drop")