The sfo package provides a monthly summary of San Francisco International (SFO) Airport air traffic passengers.

The sfo_passengers dataset contains the following fields:

  • activity_period - Activity year and month in YYYYMM format
  • operating_airline -Airline name for the operator of aircraft
  • 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 -Designates whether the passenger activity in relation to SFO arrived from or departed to a location within the United States (“domestic”), or outside the United States (“international”) without stops
  • geo_region -Provides a more detailed breakdown of the GEO Summary field to designate the region in the world where activity in relation to SFO arrived from or departed to without stops
  • 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 terminal designations at SFO where passenger activity took place
  • boarding_area -The airport boarding area designations at SFO where passenger activity took place
  • passenger_count -The number of monthly passengers associated with the above attribute fields

Data source: San Francisco data portal (DataSF) API

library(sfo)

data("sfo_passengers")

str(sfo_passengers)
#> 'data.frame':    22576 obs. of  12 variables:
#>  $ activity_period            : int  202009 202009 202009 202009 202009 202009 202009 202009 202009 202009 ...
#>  $ operating_airline          : chr  "United Airlines" "United Airlines" "United Airlines" "United Airlines" ...
#>  $ operating_airline_iata_code: chr  "UA" "UA" "UA" "UA" ...
#>  $ published_airline          : chr  "United Airlines" "United Airlines" "United Airlines" "United Airlines" ...
#>  $ published_airline_iata_code: chr  "UA" "UA" "UA" "UA" ...
#>  $ geo_summary                : chr  "International" "International" "International" "International" ...
#>  $ geo_region                 : chr  "Mexico" "Mexico" "Mexico" "Mexico" ...
#>  $ activity_type_code         : chr  "Enplaned" "Enplaned" "Enplaned" "Deplaned" ...
#>  $ price_category_code        : chr  "Other" "Other" "Other" "Other" ...
#>  $ terminal                   : chr  "Terminal 3" "Terminal 3" "International" "International" ...
#>  $ boarding_area              : chr  "F" "E" "G" "G" ...
#>  $ passenger_count            : int  6712 396 376 6817 3851 3700 71 83 65 45 ...

head(sfo_passengers)
#>   activity_period operating_airline operating_airline_iata_code
#> 1          202009   United Airlines                          UA
#> 2          202009   United Airlines                          UA
#> 3          202009   United Airlines                          UA
#> 4          202009   United Airlines                          UA
#> 5          202009   United Airlines                          UA
#> 6          202009   United Airlines                          UA
#>   published_airline published_airline_iata_code   geo_summary geo_region
#> 1   United Airlines                          UA International     Mexico
#> 2   United Airlines                          UA International     Mexico
#> 3   United Airlines                          UA International     Mexico
#> 4   United Airlines                          UA International     Mexico
#> 5   United Airlines                          UA International     Europe
#> 6   United Airlines                          UA International     Europe
#>   activity_type_code price_category_code      terminal boarding_area
#> 1           Enplaned               Other    Terminal 3             F
#> 2           Enplaned               Other    Terminal 3             E
#> 3           Enplaned               Other International             G
#> 4           Deplaned               Other International             G
#> 5           Enplaned               Other International             G
#> 6           Deplaned               Other International             G
#>   passenger_count
#> 1            6712
#> 2             396
#> 3             376
#> 4            6817
#> 5            3851
#> 6            3700