datahub-transportation-gov/consumer-airfare-report-table-1a-all-us-airport-tfrh-tu9e
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 15 minutes ago

Consumer Airfare Report: Table 1a - All U.S. Airport Pair Markets

Available only on the web, provides information for airport pair markets rather than city pair markets. This table only lists airport markets where the origin or destination airport is an airport that has other commercial airports in the same city. Midway Airport (MDW) and O'Hare (ORD) are examples of this. All records are aggregated as directionless markets. The combination of Airport_1 and Airport_2 define the airport pair market. All traffic traveling in both directions is added together.

https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

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-transportation-gov/consumer-airfare-report-table-1a-all-us-airport-tfrh-tu9e\".\"consumer_airfare_report_table_1a_all_us_airport\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • consumer_airfare_report_table_1a_all_us_airport
     
     
     
     
     
Upstream Metadata