BTS Open Data SODA API

The BTS Open Data portal powered by Socrata provides programmatic access to transportation datasets via the Socrata Open Data API (SODA). Supports filtering, querying, and aggregation across aviation, freight, and transportation economics datasets. Also supports OData V2/V4 for tools like Tableau and Excel.

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/bts-open-data-soda-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

API entry from apis.yml

apis.yml Raw ↑
aid: bureau-of-transportation-statistics:bts-open-data-soda-api
name: BTS Open Data SODA API
tags:
- Federal-Government
- Transportation
- Open Data
- Statistics
tags_raw:
- Federal Government
- Transportation
- Open Data
- Statistics
humanURL: https://data.bts.gov/
baseURL: https://data.bts.gov/resource/
properties:
- url: https://data.bts.gov/
  type: Portal
- url: https://dev.socrata.com/
  type: Documentation
- url: https://catalog.data.gov/dataset?organization=dot-gov&q=bts
  type: DataAPI
- url: odata/bureau-of-transportation-statistics-odata-metadata.xml
  type: OData
  name: OData 4.0 CSDL ($metadata) — 184 entity sets
- url: https://data.bts.gov/data.json
  type: DataCatalog
  name: DCAT-US 1.1 catalog — 418 datasets
- url: https://data.bts.gov/catalog.rss
  type: ChangeLog
  name: Dataset change feed (RSS)
- url: https://dev.socrata.com/docs/endpoints.html
  type: APIReference
- url: https://dev.socrata.com/consumers/getting-started.html
  type: GettingStarted
description: The BTS Open Data portal powered by Socrata provides programmatic access to transportation
  datasets via the Socrata Open Data API (SODA). Supports filtering, querying, and aggregation across
  aviation, freight, and transportation economics datasets. Also supports OData V2/V4 for tools like Tableau
  and Excel.
features:
- SODA Query Language (SOQL)
- OData V2 and V4 Endpoints
- JSON and CSV Formats
- Filtering and Aggregation
- Pagination
- Dataset Downloads
useCases:
- Aviation performance analysis
- Freight activity monitoring
- Transportation economics research
- Supply chain analytics