Strategic Measure_Annual Passenger Seats

The data set indicates the maximum number of seats available for passengers to fly. These are seats scheduled, but not necessarily filled. The success of AUS and all airports is driven by passenger demand, government restrictions, and airline business models. Data on available passenger seats in the Official Airline Guide is collected and distributed by the Campbell-Hill Aviation Schedule Report. The report data is then combined to create the total annual passenger seats for the year.

This dataset supports measure M.A.7 of SD23.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/Number-of-AUS-passenger-seats-available-for-purcha/26rp-vy2b/

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 \"datahub-austintexas-gov/strategic-measureannual-passenger-seats-cvz8-iv5k\".\"strategic_measureannual_passenger_seats\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.