Vital Signs: Airport Activity (Passengers) – by metro area
VITAL SIGNS INDICATOR
Airport Activity (EC17)
FULL MEASURE NAME
Enplanements or tonnage at airports
LAST UPDATED
August 2019
DESCRIPTION
Airport activity refers to the number of passenger boardings at Bay Area commercial airports and to the quantity of goods – measured in tons – that arrive in the region as air cargo.
DATA SOURCE
Federal Aviation Administration: Passenger Boarding (Enplanement) and All-Cargo Data for U.S. Airports
2001-2017
http://www.faa.gov/airports/planning_capacity/passenger_allcargo_stats/passenger/
Note: Passenger only
CONTACT INFORMATION
vitalsigns.info@bayareametro.gov
METHODOLOGY NOTES (across all datasets for this indicator)
Depending on airport size, the enplanement (or boarding) data for passengers comes from either the Primary or Commercial Airport data tables produced annually by FAA, as some smaller airports shift between these designations over time.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"bayareametro-gov/vital-signs-airport-activity-passengers-by-metro-qjxy-tngv\".\"vital_signs_airport_activity_passengers_by_metro\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.