- API
Coal Unit Train Loadings
internal.agtransport.usda.gov | Last Updated 2024-08-02T01:02:20.000ZWeekly actual and planned coal loadings from the Surface Transportation Board's (STB) Rail Service Metrics. Railroads provide the average daily count (per week) of unit train coal traffic from major coal producing regions. They have the option of providing this metric on a train- or carload basis. For example, BNSF reports the average daily loadings for the week of coal unit trains. CSX, on the other hand, reports on a carload basis. Data are broken out by coal production region.
- API
Grain Prices
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:38:40.000ZPrices are a fundamental component of exchange and have long been important to the functioning of agricultural markets. Grain prices are closely related to grain transportation, where the supply and demand for grain simultaneously determines both the price of grain, as well as the demand for grain transportation. This data has corn, soybean, and wheat prices for a variety of locations. These include origins—such as Iowa, Minnesota, Nebraska, and many others—and destinations, such as the Pacific Northwest, Louisiana Gulf, Texas Gulf, and Atlantic Coast. The data come from three sources: USDA-AMS Market News price reports, GeoGrain, and U.S. Wheat Associates. Links are included below. GeoGrain offers granular data for purchase. The GeoGrain data here is an average of those granular prices for a given state (and the "Southeast" region, which combines Arkansas, Mississippi, and Alabama). This is one of three companion datasets. The other two are grain basis (https://agtransport.usda.gov/d/v85y-3hep) and grain price spreads (https://agtransport.usda.gov/d/an4w-mnp7). These datasets are separate, because the coverage lengths differ and missing values are removed (e.g., there needs to be a cash price and a futures price to have a basis price).
- API
Commodity Price Spreads
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:44:19.000ZThe data shows grain prices at select inland origin points and export destination ports and the price spread between them. More specifically, this dataset compares interior prices of corn in Illinois and Nebraska with the Gulf; Iowa and Gulf soybean prices; Kansas and Gulf hard red winter wheat; and North Dakota and Portland hard red spring wheat.
- API
Grain Price Spreads
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:38:44.000ZA "spread" can have multiple meanings, but it generally implies a difference between two comparable measures. These can be differences across space, across time, or across anything with a similar attribute. For example, in the stock market, there is a spread between the highest price a buyer is willing to pay and the lowest price a seller is willing to accept. In this dataset, spread refers to differences in prices between two locations, an origin (e.g., Illinois, Iowa, etc.) and a destination (e.g., Louisiana Gulf, Pacific Northwest, etc.). Mathematically, it is the destination price minus the origin price. Price spreads are closely linked to transportation. They tend to reflect the costs of moving goods from one point to another, all else constant. Fluctuations in spreads can change the flow of goods (where it may be more profitable to ship to a different location), as well as indicate changes in transportation availability (e.g., disruptions). For more information on how price spreads are linked to transportation, see the story, "Grain Prices, Basis, and Transportation" (https://agtransport.usda.gov/stories/s/sjmk-tkh6). This is one of three companion datasets. The other two are grain prices (https://agtransport.usda.gov/d/g92w-8cn7) and grain basis (https://agtransport.usda.gov/d/v85y-3hep). These datasets are separate, because the coverage lengths differ and missing values are removed (e.g., there needs to be a cash price and a futures price to have a basis price, and there needs to be both an origin and a destination to have a price spread). The origin and destination prices come from the grain prices dataset.
- API
Public Use Carload Waybill Sample
internal.agtransport.usda.gov | Last Updated 2024-06-17T18:06:00.000ZThe Surface Transportation Board's Carload Waybill Sample is perhaps the most comprehensive dataset available on railroad movements and trends. More technically, it is a stratified sample of carload waybills for all U.S. rail traffic submitted by those rail carriers terminating 4,500 or more revenue carloads annually. See 49 C.F.R. §§ 1244.1 to 1244.5. Waybill data have broad applications and usage in national railroad policy and regulations, such as rate cases, costing systems, productivity studies, exemption decisions, and analyses supporting regulations. Waybill data are used by transportation practitioners, consultants, and law firms in preparing verified statements to be submitted in formal proceedings before the Board or other public agencies. Various federal agencies use the Waybill Sample as part of their informational and decision-making framework, and many states use it as a source of information for developing state transportation plans. STB creates the Public Use Waybill file from the confidential Waybill Sample file. See the attached documents for more information. The "Reference Guide" document contains additional details on the variables and Standard Transportation Commodity Codes (STCC). In the "Creation of the Public Use Waybill Sample" document, STB provides more detail on the public use sample and how it is created. There is also a map of Bureau of Economic Analysis (BEA) Areas and a document describing the Waybill sampling instructions.
- API
Grain Basis
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:38:44.000ZBasis reflects both local and global supply and demand forces. It is calculated as the difference between the local cash price and the futures price. It affects when and where many grain producers and shippers buy and sell grain. Many factors affect basis—such as local supplies, storage and transportation availability, and global demand—and they interact in complex ways. How changes in basis manifest in transportation is likewise complex and not always direct. For instance, an increase in current demand will drive cash prices up relative to future prices, and increase basis. At the same time, grain will enter the transportation system to fulfill that demand. However, grain supplies also affect basis, but will have the opposite effect on transportation. During harvest, the increase in the supply of grain pushes down cash prices relative to futures prices, and basis weakens, but the demand for transportation increases to move the supplies. For more information on how basis is linked to transportation, see the story, "Grain Prices, Basis, and Transportation" (https://agtransport.usda.gov/stories/s/sjmk-tkh6), and links below for research on the topic. This data has corn, soybean, and wheat basis for a variety of locations. These include origins—such as Iowa, Minnesota, Nebraska, and many others—and destinations, such as the Pacific Northwest, Louisiana Gulf, Texas Gulf, and Atlantic Coast. This is one of three companion datasets. The other two are grain prices (https://agtransport.usda.gov/d/g92w-8cn7) and grain price spreads (https://agtransport.usda.gov/d/an4w-mnp7). These datasets are separate, because the coverage lengths differ and missing values are removed (e.g., there needs to be a cash price and a futures price to have a basis price). The cash price comes from the grain prices dataset and the futures price comes from the appropriate futures market, which is Chicago Board of Trade (CME Group) for corn, soybeans, and soft red winter wheat; Kansas City Board of Trade (CME Group) for hard red winter wheat; and the Minneapolis Grain Exchange for hard red spring wheat.
- API
Rail Cars Not Moved
internal.agtransport.usda.gov | Last Updated 2024-08-02T01:02:22.000ZWeekly "cars held" data from the Surface Transportation Board's (STB) Rail Service Metrics. As part of their submission to the STB, railroads provide data on the average daily number of loaded and empty cars, operating in normal movement and billed to an origin or destination, which have not moved in more than 48 hours. The data is broken out by service type: intermodal, grain, coal, crude oil, automotive, ethanol, fertilizer, or all other. In order to derive the daily averages for the reporting week, carriers are requested to run a same-time snapshot each day of the reporting week, capturing cars within each category that have not moved in 48 hours or more. The number of cars captured on the daily snapshot for each category should be added, and then divided by the number of days in the reporting week (typically seven days). In deriving this data, carriers should include cars in normal service anywhere on their system, but should not include cars placed at a customer facility; in constructive placement; placed for interchange to another carrier; in bad order status; in storage; or operating in railroad service (e.g., ballast). Fertilizer is defined by the following 14 Standard Transportation Commodity Codes (STCCs): 2871236, 2871235, 2871238, 2819454, 2812534, 2818426, 2819815, 2818170, 2871315, 2818142, 2818146, 2871244, 2819173, and 2871451. STCC 287 covers agricultural chemicals and STCC 281 covers industrial inorganic or organic chemicals (excluding pesticides).
- API
Panamax Bulk Fleet Size and Rates
internal.agtransport.usda.gov | Last Updated 2021-05-12T19:24:40.000ZThis data shows the Panamax vessel fleet size over time and ocean freight rates for shipping a metric ton of grain from the U.S. Gulf and Pacific Northwest to Japan.
- API
Export Sales
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:45:15.000ZThis data is reported by USDA's Foreign Agricultural Service (FAS). USDA's Export Sales Reporting Program monitors U.S. agricultural export sales on a daily and weekly basis. Export sales reporting provides a constant stream of up-to-date market information for 40 U.S. agricultural commodities sold abroad. A single statistic reveals the significance of the program: in a typical year, the program monitors more than 40 percent of total U.S. agricultural exports. The program also serves as an early alert on the possible impact foreign sales have on U.S. supplies and prices. The weekly U.S. Export Sales report is the most current available source of U.S. export sales data. The data is used to analyze the overall level of export demand, determine where markets exist, and assess the relative position of U.S. commodities in foreign markets. The date field in export sales is weekly, based on the calendar year. However, the dataset also keeps track of marketing year export sales. Be cautious when aggregating the export sales data over the date variable to properly account for these factors. The turn of the marketing year often falls on a different day of the week then the weekly calendar year reporting. In this case, FAS adds an additional row (two total) to the dataset for that calendar week. One row represents that week's values which fell in the previous marketing year, while the other row captures that week's values which fell in the new marketing year. The "Marketing Year Start or End" variable labels these rows as "ENDING MY" and "STARTING MY", respectively, and is otherwise empty. This creates a double counting issue when aggregating some of the variables by calendar week. See our view, https://agtransport.usda.gov/d/885i-uek7, for an example of avoiding double counting to show total outstanding sales over time.
- API
Grain Vessel Loading Activity
internal.agtransport.usda.gov | Last Updated 2024-08-01T16:44:21.000ZThis data describes the weekly ocean-going grain vessel loading activity in the U.S. Gulf and the Pacific Northwest. This data is collected weekly from the local grain export elevators.