bayareametro-gov/vital-signs-airport-activity-passengers-by-metro-qjxy-tngv
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 4 years ago
Indexed 1 month ago

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.

 
Preview
  • vital_signs_airport_activity_passengers_by_metro