v1_intro.Rmd
The sfo package provides a monthly statistics of San Francisco International (SFO) airport air traffic between July 2005 and December 2020. That includes the following two datasets:
sfo_passengers
- air traffic passengers statisticssfo_stats
- air traffic landing statisticsThe sfo_passengers
dataset focusing on monthly air passengers statistics, and it contains the following fields:
activity_period
- Activity year and month in YYYYMM formatoperating_airline
-Airline name for the operator of aircraftoperating_airline_iata_code
-The International Air Transport Association (IATA) two-letter designation for the Operating Airlinepublished_airline
-Airline name that issues the ticket and books revenue for passenger activitypublished_airline_iata_code
-The International Air Transport Association (IATA) two-letter designation for the Published Airlinegeo_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 stopsgeo_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 stopsactivity_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 placeboarding_area
-The airport boarding area designations at SFO where passenger activity took placepassenger_count
-The number of monthly passengers associated with the above attribute fieldsData source: San Francisco data portal (DataSF) API
library(sfo) data("sfo_passengers") str(sfo_passengers) #> 'data.frame': 22869 obs. of 12 variables: #> $ activity_period : int 202012 202012 202012 202012 202012 202012 202012 202012 202012 202012 ... #> $ 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 "Domestic" "Domestic" "International" "International" ... #> $ geo_region : chr "US" "US" "Asia" "Asia" ... #> $ activity_type_code : chr "Enplaned" "Thru / Transit" "Deplaned" "Enplaned" ... #> $ price_category_code : chr "Other" "Other" "Other" "Other" ... #> $ terminal : chr "Terminal 3" "Terminal 3" "International" "International" ... #> $ boarding_area : chr "F" "F" "G" "G" ... #> $ passenger_count : int 117260 61 12763 16050 2733 2878 3913 3587 11735 585 ... head(sfo_passengers) #> activity_period operating_airline operating_airline_iata_code #> 1 202012 United Airlines UA #> 2 202012 United Airlines UA #> 3 202012 United Airlines UA #> 4 202012 United Airlines UA #> 5 202012 United Airlines UA #> 6 202012 United Airlines UA #> published_airline published_airline_iata_code geo_summary #> 1 United Airlines UA Domestic #> 2 United Airlines UA Domestic #> 3 United Airlines UA International #> 4 United Airlines UA International #> 5 United Airlines UA International #> 6 United Airlines UA International #> geo_region activity_type_code price_category_code terminal #> 1 US Enplaned Other Terminal 3 #> 2 US Thru / Transit Other Terminal 3 #> 3 Asia Deplaned Other International #> 4 Asia Enplaned Other International #> 5 Australia / Oceania Deplaned Other International #> 6 Australia / Oceania Enplaned Other International #> boarding_area passenger_count #> 1 F 117260 #> 2 F 61 #> 3 G 12763 #> 4 G 16050 #> 5 G 2733 #> 6 G 2878
The sfo_stats
dataset focusing on monthly landing statistics, and it contains the following fields:
activity_period
- Activity year and month in YYYYMM formatoperating_airline
-Airline name for the operator of aircraftoperating_airline_iata_code
-The International Air Transport Association (IATA) two-letter designation for the Operating Airlinepublished_airline
-Airline name that issues the ticket and books revenue for passenger activitypublished_airline_iata_code
-The International Air Transport Association (IATA) two-letter designation for the Published Airlinegeo_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 stopsgeo_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 stopslanding_aircraft_type
- A designation for three types of aircraft that landed at SFO, which includes passenger aircraft, cargo only aircraft (“freighters”) or combination aircraft (“combi”)aircraft_body_type
- A designation that is independent from Landing Aircraft Type, which determines whether commercial aircraft landed at SFO is a wide body jet, narrow body jet, regional jet or a propeller operated aircraftaircraft_manufacturer
- Manufacturer name for the aircraft that landed at SFOaircraft_model
- Model designation of aircraft by the manufactureraircraft_version
- Variations of the Aircraft Model, also known as the “dash number”, designated by the manufacturer to segregate unique versions of the same modellanding_count
- The number of aircraft landings associated with General and Landings Statistics attribute fieldstotal_landed_weight
- The aircraft landed weight (in pounds) associated with General and Landings Statistics attribute fieldsData source: San Francisco data portal (DataSF) API
library(sfo) data("sfo_stats") str(sfo_stats) #> 'data.frame': 25765 obs. of 14 variables: #> $ activity_period : int 202012 202012 202012 202012 202012 202012 202012 202012 202012 202012 ... #> $ 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 "Domestic" "Domestic" "Domestic" "International" ... #> $ geo_region : chr "US" "US" "US" "Asia" ... #> $ landing_aircraft_type : chr "Passenger" "Passenger" "Passenger" "Passenger" ... #> $ aircraft_body_type : chr "Narrow Body" "Wide Body" "Wide Body" "Wide Body" ... #> $ aircraft_manufacturer : chr "Boeing" "Boeing" "Boeing" "Boeing" ... #> $ aircraft_model : chr "B753" "B763" "B772" "B772" ... #> $ aircraft_version : chr "-" "-" "-" "-" ... #> $ landing_count : int 78 19 96 1 8 35 44 43 33 1 ... #> $ total_landed_weight : int 17472000 6080000 43500000 460000 3680000 19390000 24376000 16340000 12540000 380000 ... head(sfo_stats) #> activity_period operating_airline operating_airline_iata_code #> 1 202012 United Airlines UA #> 2 202012 United Airlines UA #> 3 202012 United Airlines UA #> 4 202012 United Airlines UA #> 5 202012 United Airlines UA #> 6 202012 United Airlines UA #> published_airline published_airline_iata_code geo_summary geo_region #> 1 United Airlines UA Domestic US #> 2 United Airlines UA Domestic US #> 3 United Airlines UA Domestic US #> 4 United Airlines UA International Asia #> 5 United Airlines UA International US #> 6 United Airlines UA Domestic US #> landing_aircraft_type aircraft_body_type aircraft_manufacturer aircraft_model #> 1 Passenger Narrow Body Boeing B753 #> 2 Passenger Wide Body Boeing B763 #> 3 Passenger Wide Body Boeing B772 #> 4 Passenger Wide Body Boeing B772 #> 5 Passenger Wide Body Boeing B772 #> 6 Passenger Wide Body Boeing B773 #> aircraft_version landing_count total_landed_weight #> 1 - 78 17472000 #> 2 - 19 6080000 #> 3 - 96 43500000 #> 4 - 1 460000 #> 5 - 8 3680000 #> 6 - 35 19390000