Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 6 hours ago

Consumer Airfare Report: Table 7 - Fare Premiums for Select Cities with More Than 20 Passengers per Day

Provides fare premiums for airports in the top 1,000 city pairs, and demonstrates the impact of low-fare service and hub domination on fare levels.

All records are aggregated as directionless city pair markets. Air traffic in each direction is combined.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/consumer-airfare-report-table-7-fare-premiums-for-d6nc-s8v6\".\"consumer_airfare_report_table_7_fare_premiums_for\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • consumer_airfare_report_table_7_fare_premiums_for
Upstream Metadata