Refrigerated Truck Rates and Availability, Latest Week of Data
internal.agtransport.usda.gov | Last Updated 10 Apr 2019Query from the full refrigerated truck rate and availability data, filtered to include only the latest week of data.
This dataset has the following 14 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| date | date | calendar_date | Week ending date. | 2024-05-21T00:00:00.000 view top 100 |
| year | year | number | Year number calculated from the reported week ending date (Date field). Week ending dates falling on or after January 4 correspond to the calendar year of the reported week. Week ending dates falling on or before January 3 correspond to the previous calendar year. For example, a week ending date falling on January 2, 2018 would be “2017.” Values range from 2000 to the present. | 2024 view top 100 |
| quarter | quarter | number | Calendar quarter extracted from month. | 2 view top 100 |
| month | month | number | Month number calculated from the reported week ending date (Date field). Week ending dates falling before the fourth day of the month are assigned to the previous month. For example, a week ending date falling on February 1st, 2nd, or 3rd would correspond to “1” (January), since there are less than four days in the reported week that fall in February. Values range from 1 through 12, where 1 refers to January, 2 to February, etc. | 5 view top 100 |
| region | region | text | TSD assigned region from destination. Nine regional crop origination markets: Arizona, California, Florida, the Great Lakes (Michigan, Minnesota, and Wisconsin), imports across the Mexico-Arizona border, imports across the Mexico-Texas border, New York, the Pacific Northwest (Idaho, Oregon, and Washington) and the Southeast (North Carolina, South Carolina, and Georgia). | CALIFORNIA PNW SOUTHEAST FLORIDA GREAT LAKES view top 100 |
| origin | origin | text | AMS designated district. | YAKIMA VALLEY AND WENATCHEE DISTRICT, WASHINGTON SALINAS-WATSONVILLE CALIFORNIA VIDALIA DISTRICT GEORGIA SOUTH AND CENTRAL DISTRICT CALIFORNIA UPPER VALLEY, TWIN FALLS-BURLEY DISTRICT IDAHO view top 100 |
| destination | destination | text | The ten cities of destination are Atlanta, Georgia; Baltimore, Maryland; Boston, Massachusetts; Chicago, Illinois; Dallas, Texas; Los Angeles, California; Miami, Florida; New York, New York; Philadelphia, Pennsylvania; and Seattle, Washington. | ATLANTA CHICAGO BALTIMORE MIAMI BOSTON view top 100 |
| distance | distance | number | TSD estimated distance between origin and destination in miles. | 2700 1100 2600 2350 500 view top 100 |
| commodity | commodity | text | Commodity mix applicable to rate and availability. | POTATOES APPLES, ASPARAGUS, PEARS, RHUBARB BROCCOLI, CABBAGE, CAULIFLOWER, ENDIVE, ESCAROLE, KALE GREENS, BOSTON LETTUCE, GREEN LETTUCE LEAF, ICEBERG LETTUCE, RED LETTUCE LEAF, ROMAINE LETTUCE, GREEN ONIONS, PARSLEY, SPINACH DRY ONIONS GRAPEFRUIT, LEMONS, ORANGES view top 100 |
| weeklow | weeklow | number | Minimum truck rate during week. | 6800 5200 4000 3800 1200 view top 100 |
| weekhigh | weekhigh | number | Maximum truck rate during week. | 6000 4400 4200 8700 8600 view top 100 |
| midpoint | midpoint | number | Average of Week Low and High | 8000 5200 4000 3500 4200 view top 100 |
| rpm | rpm | number | Ratio of Midpoint to Distance | 2.5 3.1153846154 2.6666666667 3.3333333333 2.5365853659 view top 100 |
| availability | availability | number | Integer between 1 and 5, with 1 representing a surplus, 5 representing a shortage, and 3 representing an adequate truck supply. | 3 4 1 2 5 view top 100 |