datahub-transportation-gov/consumer-airfare-report-table-2-top-1000-citypair-wqw2-rjgd
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 6 hours ago

Consumer Airfare Report: Table 2 - Top 1,000 City-Pair Markets

Data summarized by city, includes the number of city-pair markets in the top 1,000 in either comparison period that involve each city, the number of passengers traveling to and from each city, the average fare, average fare per mile (yield), and average distance traveled. 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-2-top-1000-citypair-wqw2-rjgd\".\"consumer_airfare_report_table_2_top_1000_citypair\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • consumer_airfare_report_table_2_top_1000_citypair
     
     
     
     
     
Upstream Metadata