datahub-transportation-gov/consumer-airfare-report-table-6-contiguous-state-yj5y-b2ir
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 day ago
Indexed 2 hours ago

Consumer Airfare Report: Table 6 - Contiguous State City-Pair Markets That Average At Least 10 Passengers Per Day

Available on the internet only, this table is an expanded version of Table 1 that lists all city-pair markets in the contiguous United States that average at least 10 passengers each day. All records are aggregated as directionless city pair markets. 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-6-contiguous-state-yj5y-b2ir\".\"consumer_airfare_report_table_6_contiguous_state\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • consumer_airfare_report_table_6_contiguous_state
     
     
     
     
     
Upstream Metadata