Dataset: SFO Air Traffic Passenger And Cargo Statistics

About this Dataset

SFO Air Traffic Passenger And Cargo Statistics

Inspiration

SFO is one of the busiest airports in the United States and also an important transpacific gateway for international passenger / cargo travel. It would be interesting to use the data for the following

Study the passenger travel and cargo movement patterns during COVID-19 pandemic
Use the tabular data for clustering algorithms
Perform traffic forecasting

Check out my notebook for details and EDA

Dataset

This dataset consists of two files;

Air_Traffic_Passenger_Statistics.csv - Details here
Air_Traffic_Cargo_Statistics.csv - Details here

Acknowledgements

Data source : https://data.sfgov.org

Cover Photo by Ken Yam on Unsplash

Tables

Air Traffic Cargo Statistics

@kaggle.rajsengo_sfo_air_traffic_passenger_and_cargo_statistics.air_traffic_cargo_statistics

583.59 KB
34037 rows
12 columns


CREATE TABLE air_traffic_cargo_statistics (
  "activity_period" BIGINT,
  "operating_airline" VARCHAR,
  "operating_airline_iata" VARCHAR,
  "published_airline" VARCHAR,
  "published_airline_iata" VARCHAR,
  "geo_summary" VARCHAR,
  "geo_region" VARCHAR,
  "activity_type" VARCHAR,
  "cargo_type" VARCHAR,
  "cargo_aircraft_type" VARCHAR,
  "cargo_weight_lbs" BIGINT,
  "cargo_metric_tons" DOUBLE
);

Air Traffic Passenger Statistics

@kaggle.rajsengo_sfo_air_traffic_passenger_and_cargo_statistics.air_traffic_passenger_statistics

160.86 KB
22869 rows
12 columns


CREATE TABLE air_traffic_passenger_statistics (
  "activity_period" BIGINT,
  "operating_airline" VARCHAR,
  "operating_airline_iata" VARCHAR,
  "published_airline" VARCHAR,
  "published_airline_iata" VARCHAR,
  "geo_summary" VARCHAR,
  "geo_region" VARCHAR,
  "activity_type" VARCHAR,
  "price_category" VARCHAR,
  "terminal" VARCHAR,
  "boarding_area" VARCHAR,
  "passenger_count" BIGINT
);