Snowflake Marketplace Listing

U.S. Commercial Fleet & Carrier Intelligence

4.4M carriers + 2.5M VIN-decoded commercial vehicles with safety ratings, inspection history, contact info, and cargo type — updated quarterly.

The most comprehensive U.S. commercial trucking and carrier dataset available in the Snowflake Data Cloud. Built directly from Federal Motor Carrier Safety Administration (FMCSA) public records and enriched with NHTSA VIN decoding, this dataset gives you instant, query-ready access to the complete U.S. commercial carrier ecosystem — 4.4 million registered carriers and 2.5 million inspected vehicles, all in your existing Snowflake environment.

No ETL pipelines. No API wrangling. No CSV downloads. Just SQL.

What's Included

ObjectRowsDescription
COMPANY_CENSUS_FULL4,417,174Every FMCSA-registered carrier — identity, location, contact, safety rating, fleet size
FLEET_VEHICLES_FULL2,535,869Commercial vehicles with inspection records, VIN-decoded specs
FLEET_CARRIERS_COMBINED2,535,869Pre-joined view — vehicles + carrier data, no JOIN required

Key Data Points

Carrier Data (COMPANY_CENSUS_FULL)

Vehicle Data (FLEET_VEHICLES_FULL)

By the Numbers

4,417,174Registered carriers
2,535,869Vehicles with inspections
1.5MTruck-tractors
90%Diesel fuel type

Who Uses This Data

Data Sources

Both are U.S. government public datasets with no restrictions on commercial use or redistribution. Full methodology: datawizards.ai/methodology

Refresh Schedule

PlanRefresh Frequency
StarterQuarterly
ProfessionalQuarterly
EnterpriseMonthly

All versions are date-stamped. Subscribers are notified by email when new data is available.

Sample Queries

1. Active carriers in Florida with 10+ power units

SELECT DOT_NUMBER, LEGAL_NAME, PHONE, EMAIL_ADDRESS,
       POWER_UNITS, SAFETY_RATING
FROM COMPANY_CENSUS_FULL
WHERE PHY_STATE = 'FL'
  AND STATUS_CODE = 'A'
  AND TRY_CAST(POWER_UNITS AS INT) >= 10
ORDER BY TRY_CAST(POWER_UNITS AS INT) DESC;

2. Diesel truck-tractors by state

SELECT REPORT_STATE, COUNT(*) AS vehicle_count
FROM FLEET_VEHICLES_FULL
WHERE FUEL_TYPE = 'Diesel'
  AND BODY_CLASS = 'Truck-Tractor'
GROUP BY REPORT_STATE
ORDER BY vehicle_count DESC;

3. Carriers with Unsatisfactory safety rating — full contact info

SELECT DOT_NUMBER, LEGAL_NAME, PHY_STATE,
       PHONE, EMAIL_ADDRESS, SAFETY_RATING, SAFETY_RATING_DATE,
       POWER_UNITS, RECORDABLE_CRASH_RATE
FROM COMPANY_CENSUS_FULL
WHERE SAFETY_RATING = 'U'
  AND STATUS_CODE = 'A';

4. Fleet composition for a specific carrier (vehicles + carrier info)

SELECT LEGAL_NAME, PHY_STATE, SAFETY_RATING,
       VIN, MAKE_FINAL, MODEL, YEAR, BODY_CLASS,
       FUEL_TYPE, VEHICLE_OOS_TOTAL, LAST_INSP_DATE
FROM FLEET_CARRIERS_COMBINED
WHERE DOT_NUMBER = '1234567'
ORDER BY LAST_INSP_DATE DESC;

5. EV and alternative fuel commercial vehicles by state

SELECT REPORT_STATE, FUEL_TYPE, COUNT(*) AS vehicle_count
FROM FLEET_VEHICLES_FULL
WHERE FUEL_TYPE NOT IN ('Diesel', 'Gasoline', 'Not Applicable')
GROUP BY REPORT_STATE, FUEL_TYPE
ORDER BY vehicle_count DESC;

6. Hazmat carriers by state with contact info

SELECT PHY_STATE, COUNT(*) AS hazmat_carriers
FROM COMPANY_CENSUS_FULL
WHERE HM_IND = '1'
  AND STATUS_CODE = 'A'
GROUP BY PHY_STATE
ORDER BY hazmat_carriers DESC;

Pricing

Free Trial
$0 / 30 days

Florida carriers + vehicles (full schema, limited geography)

Starter
$500 / month

Full national dataset — all 3 objects, quarterly refresh

Professional
$1,500 / month

Full dataset + email notification on refresh + priority support

Enterprise
Contact us

Monthly refresh + SLA + custom data pulls

All paid plans include unlimited queries against the shared dataset within your Snowflake account.

Support

Provider

DataWizards.ai — U.S.-based commercial data company specializing in transportation and logistics intelligence derived from federal public records.

Tags & Categories

Transportation & Logistics Compliance & Risk B2B Data Fleet Management Insurance Government Data FMCSA DOT Trucking Commercial Vehicles Safety Data United States