About this Dataset

Air Traffic Cargo Statistics

A. SUMMARY This dataset consists of San Francisco International Airport (SFO) air traffic cargo dataset contains data about cargo volume into and out of SFO, in both metric tons and pounds, with monthly totals by airline, region and aircraft type. B. HOW THE DATASET IS CREATED Data is self-reported by airlines and is only available at a monthly level. C. UPDATE PROCESS Data is available starting in July 1999 and will be updated monthly. 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, Cargo Statistics belonging to United Airlines will appear in multiple attribute fields and are additive, which provides flexibility for the user to derive categorical Cargo Statistics as desired. E. RELATED DATASETS A summary of monthly comparative air-traffic statistics is also available on SFO’s internet site at https://www.flysfo.com/about/media/facts-statistics/air-traffic-statistics
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:57.122706

Tables

Table 1

@usgov.city_of_san_francisco_air_traffic_cargo_statistics.table_1

982.52 kB
56,841 rows
15 columns

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,
  "cargo_type_code" VARCHAR,
  "cargo_aircraft_type" VARCHAR,
  "cargo_weight_lbs" BIGINT,
  "cargo_metric_tons" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);