USDA award lanes as a CSV for your TMS or CRM

The columns

The file starts with this header row, in this order. Every value is copied from USDA's award notice, Bid Array or solicitation [source 1]; nothing is estimated.

One row per lane and contract: a lane split across contracts has one row per contract, side by side, so the file can have more rows than lanes (the 862 Texas lanes are 920 rows as of Nov 7, 2026).

vendor,plant_city,plant_state,destinations,commodity,deliveries_or_lines,quantity_total,uom,window_start,window_end,award_date,contract,fob_destination_stated,usda_pca_url,bid_array_url,finding_id,data_as_of

Examples below are from one real Texas lane (al-9f4c60e76009), data as of Nov 7, 2026.

vendor

The vendor's name as the award notice prints it (completed from USAspending when the notice cuts it at 35 characters).

Example: WESTSTAR FOOD CO LLC

plant_city

The plant's city as USDA printed it. Blank when the printed city isn't a Census place or is a street address. When the city is the vendor's own location, the cell says so: (vendor location, not the shipping point).

Example: CORPUS CHRISTI

plant_state

The plant's state.

Example: TX

destinations

Each destination city once as CITY, ST, in stop order, separated by semicolons. When a multi-stop LOT stops in the same city more than once, the stop count follows, such as (2 stops).

Example: HOUSTON, TX

commodity

USDA's commodity name as printed, pack size included.

Example: BEANS BLACK TURTLE DRY PKG-12/2 LB

deliveries_or_lines

The count in words: "N deliveries" when every line is the award's standard line size, otherwise "N award lines"; a multi-stop LOT reads "1 multi-stop LOT (N stops)". "(N left)" follows when only some of them are still open on the snapshot date.

Example: 20 deliveries

quantity_total

Total awarded quantity across the lane's lines, in the unit below.

Example: 33600

uom

The unit USDA printed, such as CS (cases) or LB (pounds).

Example: CS

window_start

First day of the delivery window, from the "Required by" periods of the lines still open (YYYY-MM-DD).

Example: 2026-11-01

window_end

Last day of that window.

Example: 2027-03-31

award_date

The award date on the award notice.

Example: 2026-09-24

contract

USDA's contract number.

Example: 12-3J14-26-C-1997

fob_destination_stated

Y when the award notice says f.o.b. destination for this commodity (the vendor pays the freight); N when it doesn't say.

Example: Y

usda_pca_url

Link to the award notice PDF, opened at this lane's page.

Example: https://portal.wbscm.usda.gov/ppp/doc/Solicitation/12-3J14-26-B-0386-0001/12-3J14-26-B-0386-0001-PCA.pdf#page=106

bid_array_url

Link to USDA's Bid Array spreadsheet; blank when USDA didn't post one.

Example: https://portal.wbscm.usda.gov/ppp/doc/Solicitation/12-3J14-26-B-0386-0001/Bid%20Abstract_2000011488.xls

finding_id

Our id for the row (one per lane and contract), made from the award's own fields. Two rows can look the same when one contract has two multi-stop LOTs to the same cities; their ids differ. Use it as the unique key when you re-import.

Example: al-9f4c60e76009

data_as_of

The date of the weekly snapshot the row came from.

Example: 2026-11-07

How to import it

1. Download the CSV for your states (above).
2. In your TMS or CRM's import screen, map the columns once: vendor to the company, plant_city and plant_state to the origin, destinations to the destination, the window to dates, and usda_pca_url to a link or note field.
3. Set finding_id as the external id, so next week's file updates rows instead of adding duplicates.
4. Keep data_as_of: a row from an older file may have changed or ended since.

What the file doesn't have

• No rates. The prices in an award are delivered food prices, not freight, so we leave them out.
• No truck counts and no pickup dates: neither is in the parsed record. The window is when deliveries are due.
• No promise of a load. An award is USDA's contract with the vendor; the vendor may already have a carrier, and USDA can change or cut a contract [source 2].
• Some USDA awards are left out: we drop lanes when USDA's two files disagree, when the contract moved by more than 10%, and lanes outside the 48 contiguous states and DC [source 3]. See where the data comes from.

As of Nov 7, 2026, Texas has 862 lanes, and the 48 contiguous states and DC together have 7,982 [source 3].

Questions brokers ask

Rather see them on screen first?

Open the sample with no sign-up, or start the trial for your own states.

Sources

1. USDA WBSCM public procurement portal (award notices, Bid Arrays, solicitations)
2. USDA AMS Master Solicitation for Commodity Procurement (MSCP-D), effective Sep 18, 2025
3. awardlanes data snapshot as of Nov 7, 2026: counts of the engine's published findings, each copied from USDA's award notices (PCA), Bid Arrays and solicitations