Baselight
Sign In

Air Traffic Passenger Statistics

City of San Francisco

@usgov.city_of_san_francisco_air_traffic_passenger_statistics

About this Dataset

Air Traffic Passenger Statistics

A. SUMMARY San Francisco International Airport Report on Monthly Passenger Traffic Statistics by Airline. B. HOW THE DATASET IS CREATED Data is self-reported by airlines and is only available at a monthly level C. UPDATE PROCESS Data updated quarterly D. HOW TO USE THIS DATASET Airport data is seasonal in nature, therefore any comparative analyses should be done on a period-over-period basis (i.e. January 2010 vs. January 2009) as opposed to period-to-period (i.e. January 2010 vs. February 2010). It is also important to note that fact and attribute field relationships are not always 1-to-1. For example, Passenger Counts belonging to United Airlines will appear in multiple attribute fields and are additive, which provides flexibility for the user to derive categorical Passenger Counts as desired.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:52.477098
Tags: airport, passengers, travel

Tables

Table 1

@usgov.city_of_san_francisco_air_traffic_passenger_statistics.table_1
  • 248.93 KB
  • 37682 rows
  • 15 columns
Loading...
 

CREATE TABLE table_1 (
  "activity_period" BIGINT,
  "activity_period_start_date" TIMESTAMP,
  "operating_airline" VARCHAR,
  "operating_airline_iata_code" VARCHAR,
  "published_airline" VARCHAR,
  "published_airline_iata_code" VARCHAR,
  "geo_summary" VARCHAR,
  "geo_region" VARCHAR,
  "activity_type_code" VARCHAR,
  "price_category_code" VARCHAR,
  "terminal" VARCHAR,
  "boarding_area" VARCHAR,
  "passenger_count" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);