{"success":true,"data":{"carriers":[{"usdot":3589128,"mc_number":null,"legal_name":"A-CROWN EXPRESS LLC","dba_name":"0","phy_street":null,"phy_city":"FORT WORTH","phy_state":"TX","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"N","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-20T01:28:05.992055+00:00","updated_at":"2025-08-20T01:28:05.911+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":0,"total_power_units":0,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":null,"ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":null,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":null,"operation_classification":null,"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":3574843,"mc_number":null,"legal_name":"ADIAN DORTA","dba_name":"ADH TRUCKING","phy_street":null,"phy_city":"KATY","phy_state":"TX","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:04.794689+00:00","updated_at":"2025-08-22T18:19:05.381185+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:05.192+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":3574843,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":3574843,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2650887,"mc_number":null,"legal_name":"ALFRED M AVENDANO","dba_name":"A AND H TRUCKING","phy_street":null,"phy_city":"SANTA PAULA","phy_state":"CA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:19.953257+00:00","updated_at":"2025-08-22T18:18:22.179956+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:22+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[],"operation_classification":[{"id":{"dotNumber":2650887,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":1408820,"mc_number":null,"legal_name":"ANTHONY D HOLEMAN","dba_name":"ADH TRUCKING","phy_street":null,"phy_city":"FREELANDVILLE","phy_state":"IN","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"I","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:04.937591+00:00","updated_at":"2025-08-22T18:19:05.692705+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:05.507+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":1408820,"cargoClassId":6},"cargoClassDesc":"Logs, Poles, Beams, Lumber"}],"operation_classification":[{"id":{"dotNumber":1408820,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2698383,"mc_number":null,"legal_name":"B AND H TRUCKING","dba_name":"ABRAHAMIAN TRUCKING","phy_street":null,"phy_city":"VAN NUYS","phy_state":"CA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:20.342433+00:00","updated_at":"2025-08-22T18:18:22.494238+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:22.309+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[],"operation_classification":[{"id":{"dotNumber":2698383,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":1583765,"mc_number":null,"legal_name":"CATHRYN D HURT AND JOHN D HURT","dba_name":"CDH TRUCKING","phy_street":null,"phy_city":"NEW PALESTINE","phy_state":"IN","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:05.524245+00:00","updated_at":"2025-08-22T18:19:06.101682+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":0,"total_power_units":0,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:05.918+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":1583765,"cargoClassId":30},"cargoClassDesc":"Dirt  And Gravel"}],"operation_classification":[{"id":{"dotNumber":1583765,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":694721,"mc_number":null,"legal_name":"CHARLES B TYSON","dba_name":"C AND H TRUCKING","phy_street":null,"phy_city":"GRAHAM","phy_state":"WA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"I","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:20.597733+00:00","updated_at":"2025-08-22T18:18:22.810188+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":2,"total_power_units":2,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:22.542+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":694721,"cargoClassId":1},"cargoClassDesc":"General Freight"},{"id":{"dotNumber":694721,"cargoClassId":10},"cargoClassDesc":"Fresh Produce"},{"id":{"dotNumber":694721,"cargoClassId":12},"cargoClassDesc":"Intermodal Containers"},{"id":{"dotNumber":694721,"cargoClassId":18},"cargoClassDesc":"Meat"},{"id":{"dotNumber":694721,"cargoClassId":22},"cargoClassDesc":"Commodities Dry Bulk"},{"id":{"dotNumber":694721,"cargoClassId":23},"cargoClassDesc":"Refrigerated Food"},{"id":{"dotNumber":694721,"cargoClassId":24},"cargoClassDesc":"Beverages"},{"id":{"dotNumber":694721,"cargoClassId":25},"cargoClassDesc":"Paper Products"},{"id":{"dotNumber":694721,"cargoClassId":30},"cargoClassDesc":"Seafood"}],"operation_classification":[{"id":{"dotNumber":694721,"operationClassId":12},"operationClassDesc":"Other"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":3107368,"mc_number":null,"legal_name":"CHRISTOPHER HERNANDEZ","dba_name":"CDH TRUCKING","phy_street":null,"phy_city":"SYLMAR","phy_state":"CA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:05.272234+00:00","updated_at":"2025-08-22T18:19:05.841205+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:05.665+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":3107368,"cargoClassId":30},"cargoClassDesc":"Appliances"}],"operation_classification":[{"id":{"dotNumber":3107368,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":790866,"mc_number":null,"legal_name":"CLIFF HARTMAN","dba_name":"CDH TRUCKING","phy_street":null,"phy_city":"BRADLEY","phy_state":"SD","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:05.33912+00:00","updated_at":"2025-08-22T18:19:05.900513+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:05.722+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":790866,"cargoClassId":15},"cargoClassDesc":"Livestock"},{"id":{"dotNumber":790866,"cargoClassId":16},"cargoClassDesc":"Grain, Feed, Hay"}],"operation_classification":[{"id":{"dotNumber":790866,"operationClassId":2},"operationClassDesc":"Exempt For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":866243,"mc_number":null,"legal_name":"CLIFTY E VANZANDT","dba_name":"C AND H TRUCKING","phy_street":null,"phy_city":"SELIGMAN","phy_state":"MO","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"A","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:20.780016+00:00","updated_at":"2025-08-22T18:18:22.961948+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:22.792+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":866243,"cargoClassId":1},"cargoClassDesc":"General Freight"},{"id":{"dotNumber":866243,"cargoClassId":6},"cargoClassDesc":"Logs, Poles, Beams, Lumber"},{"id":{"dotNumber":866243,"cargoClassId":7},"cargoClassDesc":"Building Materials"},{"id":{"dotNumber":866243,"cargoClassId":9},"cargoClassDesc":"Machinery, Large Objects"},{"id":{"dotNumber":866243,"cargoClassId":10},"cargoClassDesc":"Fresh Produce"},{"id":{"dotNumber":866243,"cargoClassId":15},"cargoClassDesc":"Livestock"},{"id":{"dotNumber":866243,"cargoClassId":16},"cargoClassDesc":"Grain, Feed, Hay"},{"id":{"dotNumber":866243,"cargoClassId":22},"cargoClassDesc":"Commodities Dry Bulk"},{"id":{"dotNumber":866243,"cargoClassId":27},"cargoClassDesc":"Farm Supplies"},{"id":{"dotNumber":866243,"cargoClassId":30},"cargoClassDesc":"Lumber From Sawmill"}],"operation_classification":[{"id":{"dotNumber":866243,"operationClassId":1},"operationClassDesc":"Authorized For Hire"},{"id":{"dotNumber":866243,"operationClassId":2},"operationClassDesc":"Exempt For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":615599,"mc_number":null,"legal_name":"CONDICT HALL","dba_name":"D & H TRUCKING","phy_street":null,"phy_city":"PLANTATION","phy_state":"FL","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:53.53199+00:00","updated_at":"2025-08-22T18:18:54.118385+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:53.936+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":615599,"cargoClassId":10},"cargoClassDesc":"Fresh Produce"}],"operation_classification":[{"id":{"dotNumber":615599,"operationClassId":2},"operationClassDesc":"Exempt For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2388232,"mc_number":null,"legal_name":"CRISTIAN HERNANDEZ","dba_name":"CDH TRUCKING","phy_street":null,"phy_city":"HAYWARD","phy_state":"CA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:05.872318+00:00","updated_at":"2025-08-22T18:19:06.429833+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:06.241+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":2388232,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":2388232,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":1775117,"mc_number":null,"legal_name":"D & H TRUCKING RICHARD BROWN","dba_name":"D&H TRUCKING","phy_street":null,"phy_city":"COLUMBUS","phy_state":"GA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:14.792225+00:00","updated_at":"2025-08-22T18:19:15.50736+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:15.245+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":1775117,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":1775117,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":3418106,"mc_number":null,"legal_name":"D AND H TRUCKING LLC","dba_name":null,"phy_street":null,"phy_city":"STERLING","phy_state":"KS","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"N","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:37.641148+00:00","updated_at":"2025-08-22T18:18:38.223933+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:38.049+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":3418106,"cargoClassId":1},"cargoClassDesc":"General Freight"},{"id":{"dotNumber":3418106,"cargoClassId":16},"cargoClassDesc":"Grain, Feed, Hay"},{"id":{"dotNumber":3418106,"cargoClassId":22},"cargoClassDesc":"Commodities Dry Bulk"}],"operation_classification":[{"id":{"dotNumber":3418106,"operationClassId":1},"operationClassDesc":"Authorized For Hire"},{"id":{"dotNumber":3418106,"operationClassId":2},"operationClassDesc":"Exempt For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2056025,"mc_number":null,"legal_name":"D AND H TRUCKING LLC","dba_name":null,"phy_street":null,"phy_city":"ETHEL","phy_state":"LA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:37.566344+00:00","updated_at":"2025-08-22T18:18:38.107458+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":0,"total_power_units":0,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:37.94+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[],"operation_classification":[],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2468624,"mc_number":null,"legal_name":"D AND H TRUCKING LLC","dba_name":null,"phy_street":null,"phy_city":"RIDGEWAY","phy_state":"VA","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"A","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:18:37.266538+00:00","updated_at":"2025-08-22T18:18:37.829443+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":1,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:18:37.653+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":2468624,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":2468624,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":3311698,"mc_number":null,"legal_name":"D&H TRANSPORTATION LLC","dba_name":null,"phy_street":null,"phy_city":"CYPRESS","phy_state":"TX","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"I","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:32.293996+00:00","updated_at":"2025-08-22T18:19:32.849448+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":2,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:32.665+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":3311698,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":3311698,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":2997068,"mc_number":null,"legal_name":"D&H TRANSPORTATION SERVICES INC","dba_name":"DRUMM INC","phy_street":null,"phy_city":"PRIOR LAKE","phy_state":"MN","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"UNKNOWN","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:32.227631+00:00","updated_at":"2025-08-22T18:19:32.824874+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":3,"total_power_units":5,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:32.634+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":2997068,"cargoClassId":11},"cargoClassDesc":"Liquids/Gases"},{"id":{"dotNumber":2997068,"cargoClassId":30},"cargoClassDesc":"Railcar Repair Equip"}],"operation_classification":[{"id":{"dotNumber":2997068,"operationClassId":3},"operationClassDesc":"Private Property"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":134532,"mc_number":null,"legal_name":"D&H TRUCKING COMPANY","dba_name":null,"phy_street":null,"phy_city":"NAMPA","phy_state":"ID","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":true,"out_of_service_date":null,"authority_status":"N","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:15.38546+00:00","updated_at":"2025-08-22T18:19:15.929339+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":0,"total_power_units":0,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:15.745+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[],"operation_classification":[{"id":{"dotNumber":134532,"operationClassId":12},"operationClassDesc":"Other"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null},{"usdot":3844834,"mc_number":null,"legal_name":"D&H TRUCKING LLC","dba_name":null,"phy_street":null,"phy_city":"MINEOLA","phy_state":"NY","phy_zip":null,"phy_country":null,"telephone":null,"location":null,"allow_to_operate":null,"out_of_service":false,"out_of_service_date":null,"authority_status":"N","last_qc_pull":null,"last_bulk_seen":null,"raw_snapshot":null,"created_at":"2025-08-22T18:19:15.452868+00:00","updated_at":"2025-08-22T18:19:16.046637+00:00","mx_number":null,"carrier_operation":null,"hm_flag":null,"pc_flag":null,"entity_type":null,"operating_status":null,"authority_revocation_date":null,"total_drivers":2,"total_power_units":1,"geocoded_address":null,"geocode_accuracy":null,"geocode_source":null,"fmcsa_data":null,"last_fmcsa_update":"2025-08-22T18:19:15.848+00:00","ingest_batch_id":null,"data_source":"FMCSA_CENSUS","mailing_address":null,"mailing_city":null,"mailing_state":null,"mailing_zip_code":null,"mailing_country":"US","email":null,"ein":null,"mcs150_outdated":false,"review_date":null,"review_type":null,"safety_rating":null,"safety_rating_date":null,"safety_review_date":null,"safety_review_type":null,"allowed_to_operate":null,"carrier_operation_code":null,"carrier_operation_desc":null,"is_passenger_carrier":null,"crash_total":0,"fatal_crash":0,"injury_crash":0,"tow_away_crash":0,"driver_inspections":0,"driver_oos_inspections":0,"driver_oos_rate":null,"vehicle_inspections":0,"vehicle_oos_inspections":0,"vehicle_oos_rate":null,"hazmat_inspections":0,"hazmat_oos_inspections":0,"hazmat_oos_rate":null,"iss_score":null,"common_authority_status":null,"contract_authority_status":null,"broker_authority_status":null,"bipd_insurance_required":null,"bipd_insurance_on_file":null,"bipd_required_amount":null,"cargo_insurance_required":null,"cargo_insurance_on_file":null,"bond_insurance_required":null,"bond_insurance_on_file":null,"cargo_carried":[{"id":{"dotNumber":3844834,"cargoClassId":1},"cargoClassDesc":"General Freight"}],"operation_classification":[{"id":{"dotNumber":3844834,"operationClassId":1},"operationClassDesc":"Authorized For Hire"}],"qc_mobile_snapshot_date":null,"data_source_details":null,"raw_snapshot_url":null,"snapshot_migrated_at":null,"snapshot_storage_version":1,"google_place_id":null,"google_rating":null,"google_user_ratings_total":null,"google_website":null,"google_formatted_phone":null,"google_opening_hours":null,"google_photos":null,"google_reviews":null,"google_business_status":null,"google_last_updated":null,"google_enriched_at":null}],"total":80,"pagination":{"page":1,"limit":20,"total":80,"totalPages":4,"hasMore":true},"filters":{}},"meta":{"timestamp":"2026-06-13T10:15:25.650Z"}}