Bulk Data Feed - Dept. of Transportation
A BrightQuery dataset with 50 fields. View the BrightQuery profile.
Product details
| API type | BulkFeed |
|---|---|
| Match keys | bq_id, company_name, domain |
| Geo coverage | US |
| Refresh cadence | Monthly |
| Historical depth | Point-in-time + MR/TS/TSQ/TSM time-series |
| PII sensitivity | Firmographic |
| Compliance | Government-filing-sourced (IRS/SEC/SoS/SBA/DOT/CMS); public record |
| Delivery | Bulk file (S3/Snowflake) |
| Lifecycle | GA |
| Pricing model | bulk_flat - Flat bulk licence (uncredited) |
| Last verified | 2026-07-18 |
Bulk Data Feed - Dept. of Transportation fields
| Field | API name | Category | Type | Fill rate | Description |
|---|---|---|---|---|---|
| Broker Authority Status | bq_broker_authority_status | Government Filings & Loans | String | 29% | Whether the carrier holds an FMCSA-issued broker authority license to arrange transportation of cargo using for-hire carriers. |
| Alternative Company Names | bq_dot_dba_name | Firmographic | String | 27% | Name used by the Carrier to do business. Also called trade name. |
| DOT Cargo Carried Classification | bq_dot_cargo_carried | Government Filings & Loans | String | 90% | Classification of commercial vehicles that transport cargo in interstate commerce. |
| DOT Inspection Count | bq_dot_inspections | Government Filings & Loans | Number (Integer) | 100% | Number of inspections the carrier has filed with the DOT. |
| NAICS Codes | bq_dot_naics_codes_all | Industry Classification | String | 86% | Code/ID of the entry. |
| DOT Total Power Unit Count | bq_dot_total_power_units | Government Filings & Loans | Number (Integer) | 99% | Total number of power units registered under the carrier's name per DOT records. |
| Address County | bq_dot_address_county_fips | Location & Geography | Number (Integer) | 92% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Record Date Attribute | bq_dot_rating_date | Data Quality & Metadata | Date | 3% | Date on which the Legal Entity was registered with the Secretary of State . |
| Record Date Attribute | bq_dot_out_of_service_date | Data Quality & Metadata | Date | 75% | Date on which the Legal Entity was registered with the Secretary of State . |
| Address Line 1 | bq_dot_address_line1 | Location & Geography | String | 92% | The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP. |
| EIN (Tax ID) | bq_dot_ein | Identity & Identifiers | Number (Integer) | 69% | Unique number issued by the IRS given to the Organization which is used to identify the business and certain other related entities. An organization may have multiple EINs; this is the primary EIN. |
| Address City | bq_dot_address_city | Location & Geography | String | 92% | City of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_dot_address_state_name | Location & Geography | String | 92% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_dot_address_state | Location & Geography | String | 92% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Zip | bq_dot_address_zip5 | Location & Geography | Number (Integer) | 92% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Cargo Insurance Amount on File | bq_cargo_insurance_on_file | Government Filings & Loans | Number (Integer) | 29% | Dollar amount of motor carrier cargo liability insurance on file for the carrier. |
| DOT Registration Number | bq_dot_usdot_number | Government Filings & Loans | Number (Integer) | 100% | A DOT number is a number assigned to the Carrier by the FMCSA and is used for multiple different purposes in the fleet. |
| Address Line 2 | bq_dot_address_line2 | Location & Geography | String | 3% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Vehicle Out-of-Service Rate (National Average) | bq_vehicle_oos_rate_national_average | Government Filings & Loans | Number (Decimal) | 92% | National average vehicle out-of-service (OOS) rate, calculated by the FMCSA from carrier crash history. |
| Common Authority Status | bq_common_authority_status | Government Filings & Loans | String | 29% | Whether the carrier complies with FMCSA common-carrier requirements to provide for-hire truck transportation to the general public. |
| Cargo Insurance Required Flag | bq_cargo_insurance_required | Government Filings & Loans | Number (Decimal) | 92% | Whether the carrier is required to carry motor carrier cargo liability insurance (Y/N). |
| Company Phone | bq_dot_phone | Contact Information | Phone (String) | 99% | Phone of the prior company. |
| DOT Crash Count | bq_dot_crashes | Government Filings & Loans | Number (Integer) | 100% | Total number of crashes the carrier has registered per DOT records. |
| Record Date Attribute | bq_dot_mcs_150_form_date | Data Quality & Metadata | Date | 89% | Date on which the Legal Entity was registered with the Secretary of State . |
| DOT Out-of-Service Count | bq_dot_out_of_service | Government Filings & Loans | Number (Integer) | 100% | Number of inspections resulting in vehicles, drivers, hazmat, or intermodal equipment being deemed non-compliant and prohibited from operating. |
| Driver Out-of-Service Rate (National Average) | bq_driver_oos_rate_national_average | Government Filings & Loans | Number (Decimal) | 92% | National average driver out-of-service (OOS) rate, calculated by the FMCSA from carrier crash history. |
| Address Zip | bq_dot_address_zip9 | Location & Geography | String | 92% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| DOT Total Driver Count | bq_dot_total_drivers | Government Filings & Loans | Number (Integer) | 94% | Total number of drivers registered under the carrier's name as reported to the DOT. |
| Address Zip Classification (Carrier) | bq_dot_address_ziptype | Location & Geography | String | 92% | Vendor-specific classification of the ZIP code associated with an address (meaning not confirmed against vendor documentation; flagged for verification). |
| Record Date Attribute | bq_dot_review_date | Data Quality & Metadata | Date | 5% | Date on which the Legal Entity was registered with the Secretary of State . |
| Address County | bq_dot_address_county_name | Location & Geography | Number (Integer) | 92% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Company Legal Name | bq_dot_legal_name | Firmographic | String | 100% | Legal Name of the Carrier |
| DOT Safety Rating | bq_dot_rating | Government Filings & Loans | String | 3% | Safety rating given to the carrier by the DOT (e.g. Conditional). |
| DOT Carrier Operation Classification | bq_dot_carrier_operation | Government Filings & Loans | Number (Decimal) | 95% | Registration classification allowing a carrier to move household goods for compensation, dictating operation type and cargo carried. |
| Contract Authority Status | bq_contract_authority_status | Government Filings & Loans | String | 29% | Whether the carrier holds an FMCSA contract authority for for-hire transportation to specific shippers under contract. |
| DOT Entity Type | bq_dot_entity_type | Government Filings & Loans | String | 100% | Type of classification of the carrier based on its legal entity filing. |
| Bond Insurance Required Flag | bq_bond_insurance_required | Government Filings & Loans | String | 29% | Whether the carrier is required to maintain surety bonds or trust funds (Y/N). |
| DOT MC/MX/FF Number | bq_dot_mc_mx_ff_numbers | Government Filings & Loans | String | 27% | Docket number assigned to the carrier (FF for freight forwarders, MX for Mexico-domiciled carriers, MC for all others). |
| Bond Insurance Amount on File | bq_bond_insurance_on_file | Government Filings & Loans | Number (Integer) | 29% | Dollar amount of surety bond/trust fund insurance on file for the carrier. |
| Allowed to Operate Flag | bq_allowed_to_operate | Government Filings & Loans | Number (Decimal) | 92% | Whether the carrier is permitted to carry passenger, property, or household goods (Y/N). |
| BIPD Insurance Amount on File | bq_bipd_insurance_on_file | Government Filings & Loans | Number (Integer) | 29% | Dollar amount of BIPD (bodily injury and property damage) liability insurance on file for the carrier. |
| DOT MCS-150 Mileage Year | bq_dot_mcs_150_mileage_year | Government Filings & Loans | Number (Integer) | 60% | Vehicle miles travelled as listed on the carrier's MCS-150 form filing. |
| DOT Passenger Carrier Flag | bq_dot_passenger_carrier_indicator | Government Filings & Loans | Boolean | 92% | Flag indicating the registered vehicle can be classified as a passenger carrier. |
| DOT Out-of-Service Percentage | bq_dot_out_of_service_perc | Government Filings & Loans | Number (Integer) | 100% | Percentage of vehicle inspections over the past 12 months resulting in an out-of-service condition. |
| BIPD Insurance Required Flag | bq_bipd_insurance_required | Government Filings & Loans | String | 29% | Whether the carrier is required to carry bodily injury and property damage (BIPD) liability insurance (Y/N). |
| DOT Status Code | bq_dot_status_code | Government Filings & Loans | String | 92% | Status code indicating whether the carrier is active ('A') or inactive ('I'). |
| Hazmat Out-of-Service Rate (National Average) | bq_hazmat_oos_rate_national_average | Government Filings & Loans | Number (Decimal) | 92% | National average hazmat out-of-service (OOS) rate, calculated by the FMCSA from carrier crash history. |
| DOT Operation Classification | bq_dot_operation_classification | Government Filings & Loans | Number (Decimal) | 99% | Classification based on the type of business the carrier is engaged in, determining applicable FMCSA regulations (e.g. Authorized For Hire, Exempt For Hire). |
| BIPD Insurance Required Amount | bq_bipd_required_amount | Government Filings & Loans | Number (Integer) | 29% | Dollar amount of BIPD (bodily injury and property damage) liability insurance required to be carried by the carrier. |
| DOT Operating Status | bq_dot_operating_status | Government Filings & Loans | String | 100% | Status indicating whether the carrier is allowed to operate (e.g. 'ACTIVE', 'AUTHORIZED FOR PROPERTY'). |
More from BrightQuery
- Bulk Data Feed - Organization Executives
- Bulk Data Feed - Organization Contacts
- Bulk Data Feed - Franchise: Franchisor Affiliates
- Bulk Data Feed - Stock Filings: Legal Entity
- Bulk Data Feed - Healthcare: Provider Individuals
- Bulk Data Feed - Organization All Names
- Bulk Data Feed - Firmographics
- Bulk Data Feed - Legal Entity Officers & Directors
- Bulk Data Feed - Financials & Employment (Most Recent)
- Bulk Data Feed - Franchise: Franchisee / Controlled Entity
- Bulk Data Feed - Family Tree / Legal Entity
- Bulk Data Feed - Address Universe: Building Unit Address
- Bulk Data Feed - Establishments
- Bulk Data Feed - Organization Locations
- Bulk Data Feed - Stock Filings: Transaction Filing Types
- Bulk Data Feed - Stock Filings: Class Series (Time Series)
- Bulk Data Feed - Stock Filings: Corporate Status & Fees
- Bulk Data Feed - Healthcare: Provider Organization Firmographics
- Bulk Data Feed - Stock Filings: Stock Events
- Bulk Data Feed - Employment (Monthly Time Series)
- Bulk Data Feed - Stock Filings: Classes of Stock Issued
- Bulk Data Feed - Stock Filings: Stock Group (Time Series)
- Bulk Data Feed - Franchise: Franchisor / Controlling Entity
- Bulk Data Feed - Franchise: Brand & Franchisor Parent
- Bulk Data Feed - Healthcare: Provider Location
- Bulk Data Feed - Healthcare: Individual Details
- Bulk Data Feed - SBA 7(a) & 504 Loans
- Bulk Data Feed - Franchise: Brands
- Bulk Data Feed - Address Universe: Building Address
- Bulk Data Feed - Organization Mapping
- Bulk Data Feed - Stock Filings: Event Timeline
- Bulk Data Feed - Franchise: Affiliates Mapping
- Bulk Data Feed - Address Universe: Unit-Organization Mapping
- Bulk Data Feed - Address Universe: Unit-Location Mapping
- Bulk Data Feed - Healthcare: Group-Individual Mapping
- Bulk Data Feed - Address Universe: Unit-Legal Entity Mapping
- Bulk Data Feed - Healthcare: Group Practice
- Bulk Data Feed - Healthcare: Org-Individual Mapping
Bulk Data Feed - Dept. of Transportation FAQ
What fields are in Bulk Data Feed - Dept. of Transportation?
Bulk Data Feed - Dept. of Transportation from BrightQuery has 50 fields across government filings & loans, firmographic, industry classification, location & geography and data quality & metadata, including DOT Inspection Count, DOT Registration Number and DOT Crash Count. Average fill rate: 71%.
What do I need to match against Bulk Data Feed - Dept. of Transportation?
Bulk Data Feed - Dept. of Transportation matches on bq_id, company_name and domain.
How is Bulk Data Feed - Dept. of Transportation priced?
bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.