U.S. Rail Tariff Rates for Grain and Soybeans
internal.agtransport.usda.gov | Last Updated 6 Jun 2024This data set contains rail tariff rates by railroad, commodity (corn, soybeans, and wheat), and train type, for select origin/destination pairs. These data are collected monthly from individual railroad websites.
This dataset has the following 22 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Date | date | calendar_date | Date to represent month-long period for rate. Railroad websites require a day-level date to determine the applicable tariff. However, data is collected only monthly. Therefore, Date is accurate to the month and year level. | 2010-06-15T00:00:00.000 2010-07-15T00:00:00.000 2010-08-15T00:00:00.000 2010-09-15T00:00:00.000 2010-10-15T00:00:00.000 view top 100 |
Year | year | number | Year extracted from Date field. 2010 to the present. | 2020 2022 2018 2012 2011 view top 100 |
Month | month | number | Month extracted from Date field. 1 through 12, where 1 refers to January, 2 to February, etc. | 6 5 9 2 11 view top 100 |
Commodity | commodity | text | Name of commodity used to determine applicable tariff (e.g., corn, soybeans, or wheat). | Corn Wheat Soybeans view top 100 |
Origin_City | origin_city | text | Origin city used to determine applicable tariff. | Indianapolis Des Moines Minneapolis Wichita Toledo view top 100 |
Origin_State | origin_state | text | Origin state used to determine applicable tariff. | IA KS ND IN MN view top 100 |
Destination_City | destination_city | text | Destination city used to determine applicable tariff. | New Orleans Portland Galveston-Houston Tacoma Los Angeles view top 100 |
Destination_State | destination_state | text | Destination state used to determine applicable tariff. | LA TX OR WA CA view top 100 |
train_type | train_type | text | Train type, either unit or shuttle. Different railroads have different definitions of shuttle and unit, including the number of cars per train. A typical break is unit trains have fewer than 75 cars and shuttle trains have greater than 75 cars. | unit shuttle view top 100 |
Railroad | railroad | text | Railroad name (one of 7 Class I railroads). | BNSF UP CSX CN view top 100 |
Mileage | mileage | number | Distance between Origin and Destination in Miles | 1006 1851 1695 613 1899 view top 100 |
Tariff per Car | tariff_car | number | The tariff rate reported by the railroad based on the shipment characteristics | 5000 5180 5121 4960 4000 view top 100 |
FSC per Car-Mile | fsc_mile | number | Applicable fuel surcharge, based on the railroad and date. This is measured as "per mile per car." | 0 0.37 0.36 0.35 0.38 view top 100 |
Tariff per MT | tariff_mt | number | Calculated based on Tariff per Car and a typical 286,000-lb car size of 100.7 metric tons per car. | 49.652432969 51.439920556 50.854021847 49.255213505 39.721946375 view top 100 |
Tariff per BU | tariff_bushel | number | Calculated based on Tariff per MT and a commodity-specific values of bushels per metric ton (e.g., 56 lbs/bu for corn, 60 lbs/bu for soybeans, and 60 lbs/bu for wheat). | 1.2612612613 1.3066666667 1.3840540541 1.009009009 1.2511711712 view top 100 |
FSC_car | fsc_car | number | Calculated based on FSC per car-mile and mileage. | 0 362.16 382.28 372.22 201.2 view top 100 |
Tariff plus FSC, per Car | tariffplusfsc_car | number | Sum of Tariff per Car and FSC per Car. | 5000 5180 4143 4960 3880 view top 100 |
Tariff plus FSC, per MT | tariffplusfsc_mt | number | Sum of Tariff per MT and FSC per MT. | 49.652432969 51.439920556 41.142005958 49.255213505 57.100297915 view top 100 |
Tariff plus FSC, per BU | tariffplusfsc_bushel | number | Sum of Tariff per BU and FSC per BU. | 1.2612612613 1.3066666667 1.1197297297 1.2511711712 0.9787387387 view top 100 |
Origin Point | origin_point | point | Geocode of origin state. | {"coordinates":[-93.499972411,42.074698104],"type":"Point"} {"coordinates":[-98.380170629,38.484726713],"type":"Point"} {"coordinates":[-94.200790583,46.348855766],"type":"Point"} {"coordinates":[-89.158650902,40.11404657],"type":"Point"} {"coordinates":[-100.46938737,47.44627334],"type":"Point"} view top 100 |
Destination Point | destination_point | point | Geocode of destination state. | {"coordinates":[-99.33305009,31.462733046],"type":"Point"} {"coordinates":[-91.42642,30.185846167],"type":"Point"} {"coordinates":[-120.558560912,43.938780241],"type":"Point"} {"coordinates":[-120.556263187,47.411251843],"type":"Point"} {"coordinates":[-119.27023,36.374105693],"type":"Point"} view top 100 |
OD Line | od_line | line | Line shape from origin and destination point. | view top 100 |