Query the public-use (non-confidential) Carload Waybill Sample rail dataset programmatically via USDA's Socrata API

domain: agtransport.usda.gov · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Locate the "Public Use Carload Waybill Sample" dataset on USDA's Agricultural Transportation Open Data Platform at agtransport.usda.gov/Rail/Public-Use-Carload-Waybill-Sample/xve5-xb56.
  2. Use the Socrata Open Data API (SODA) endpoint documented on the dataset's Socrata API Foundry page to query rows via HTTP GET with SoQL query parameters.
  3. Optionally register for a free Socrata app token to raise your throttling limits for repeated queries.
  4. For BI-tool access instead of raw API calls, connect via the dataset's OData endpoint (e.g., Excel or Tableau's OData v2 option) for on-demand refresh.
  5. Reference the "Creation of the Public Use Waybill Sample" documentation linked from the dataset page to understand how the public sample was derived from STB's confidential sample.

Known gotchas

Related routes

Request access to the Surface Transportation Board's confidential Carload Waybill Sample data
stb.gov · 5 steps · unrated
query nyc dohmh public pool inspection results via the nyc open data socrata api
data.cityofnewyork.us · 5 steps · unrated
Query USDA ERS Agricultural Resource Management Survey (ARMS) farm income and financial data programmatically via the ARMS Data API.
ers.usda.gov · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans