Data Share Usage Example Q1: Los Angeles Market Daily Van LT Ratio Trend – 2018 to Present Published Load-to-Truck ratio since 2018 (Note: Actual field and view names may vary from those displayed below.) SELECT * FROM .DAT.”user_view” WHERE CALC_DATE >= TO_DATE(‘20180101’,’YYYYM
DAT’s Load-to-Truck Ratio data is a dataset built from the hundreds of millions of annual freight-matching transactions taking place in the DAT One ecosystem. Load and Truck posts are aggregated daily at a variety of geographic granularities to provide the industry’s best raw measure of spot market capacity demands in the continental United States and Canada. Features of this dataset: – Outbound (explicit origin) posted load and truck volumes down to the three-digit postal code level – Lane-based (explicit origin and destination) posted load volumes down to the three-digit postal code – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Daily aggregations reported – Daily history back to 2013 – Search aggregations also available Fields Include: – Type of Trailer – Origin Geography Code – Load-to-Truck Ratio – Equipment Posts – Load Posts