internal-agtransport-usda-gov/railroad-fuel-surcharges-f883-g4tq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

Railroad Fuel Surcharges

Fuel surcharge data is collected monthly from individual railroad websites. Fuel surcharges apply per mile per car. They are typically billed on top of tariff rates, but note that tariff- and contract-specific fuel surcharges may differ from the reported surcharge. For instance, BNSF publishes three separate fuel surcharge series, based on different strike prices. Their $1.25 strike price was in effect on some grain tariffs prior to March 2011, when the $2.50 strike price calculation went into effect. In February 2015, BNSF removed the fuel surcharge from its grain tariffs. In January 2021, BNSF added the fuel surcharge back to its grain tariffs at the $3.25 strike price. All three series are included in this dataset.

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 \"internal-agtransport-usda-gov/railroad-fuel-surcharges-f883-g4tq\".\"railroad_fuel_surcharges\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • railroad_fuel_surcharges
     
     
     
     
     
Upstream Metadata