{"current_page":1,"data":[{"id":11883567,"change_date":"2026-05-12 21:39:00","inspection_id":"87821319","dot_number":"243891","report_state":"AR","report_number":"7230001085","insp_date":"2026-05-12 00:00:00","insp_start_time":"0752","insp_end_time":"0836","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EMERSON AR","county_code_state":"AR","county_code":"027","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BILL & RALPH'S","shipping_paper_number":"19798","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3304496","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:26.000000Z","updated_at":"2026-05-23T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20661986,"change_date":"2026-05-12 21:39:00","inspection_id":"87821319","insp_unit_id":"213500132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"761169","insp_unit_license":"3971673","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV4TSWT3541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:25.000000Z","updated_at":"2026-05-23T09:03:15.000000Z"},{"id":20661987,"change_date":"2026-05-12 21:39:00","inspection_id":"87821319","insp_unit_id":"213500133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"25","insp_unit_license":"L882907","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS1324GM755501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:25.000000Z","updated_at":"2026-05-23T09:03:15.000000Z"}]},{"id":11582458,"change_date":"2026-04-07 21:38:00","inspection_id":"87507017","dot_number":"243891","report_state":"AR","report_number":"7450000640","insp_date":"2026-04-07 00:00:00","insp_start_time":"1239","insp_end_time":"1312","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FORDYCE AR","county_code_state":"AR","county_code":"039","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3124823","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2026-04-07 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-07 21:38:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:09.000000Z","updated_at":"2026-04-17T09:52:03.000000Z","inspection_violations":[{"id":19587758,"change_date":"2026-04-07 21:38:00","inspection_id":"87507017","insp_violation_id":"272911062","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:38.000000Z","updated_at":"2026-04-18T10:42:17.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19852315,"change_date":"2026-04-07 21:38:00","inspection_id":"87507017","insp_unit_id":"212576904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"28","insp_unit_license":"3964962","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV8TSWT3558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:22.000000Z","updated_at":"2026-04-18T09:28:21.000000Z"},{"id":19852316,"change_date":"2026-04-07 21:38:00","inspection_id":"87507017","insp_unit_id":"212576905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"28T","insp_unit_license":"P928698","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2365M6175201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:22.000000Z","updated_at":"2026-04-18T09:28:21.000000Z"}]},{"id":10593702,"change_date":"2026-01-08 21:39:00","inspection_id":"86732630","dot_number":"243891","report_state":"AR","report_number":"7150001003","insp_date":"2026-01-07 00:00:00","insp_start_time":"1155","insp_end_time":"1240","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MENA AR","county_code_state":"AR","county_code":"113","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2734771","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2026-01-08 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-08 21:39:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:38.000000Z","updated_at":"2026-01-19T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17759706,"change_date":"2026-01-08 21:39:00","inspection_id":"86732630","insp_unit_id":"210965720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"274655","insp_unit_license":"2927243","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG7LDLY8236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:07.000000Z","updated_at":"2026-01-19T10:00:17.000000Z"},{"id":17759707,"change_date":"2026-01-08 21:39:00","inspection_id":"86732630","insp_unit_id":"210965721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"676799","insp_unit_license":"L931309","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS236XH6132401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:07.000000Z","updated_at":"2026-01-19T10:00:17.000000Z"}]},{"id":10544581,"change_date":"2025-12-31 21:37:00","inspection_id":"86681164","dot_number":"243891","report_state":"AR","report_number":"8180000455","insp_date":"2025-12-30 00:00:00","insp_start_time":"1320","insp_end_time":"1421","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CROSSETT AR","county_code_state":"AR","county_code":"003","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2710236","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2025-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-12-31 21:37:00","snet_input_date":"2025-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-31 21:37:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-03T10:35:04.000000Z","updated_at":"2026-01-11T10:30:11.000000Z","inspection_violations":[{"id":17713065,"change_date":"2025-12-31 21:37:00","inspection_id":"86681164","insp_violation_id":"270963800","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W000197","created_at":"2026-01-03T10:38:57.000000Z","updated_at":"2026-01-11T10:30:25.000000Z","normalized_code":"3922SLLS2"},{"id":17713066,"change_date":"2025-12-31 21:37:00","inspection_id":"86681164","insp_violation_id":"270963801","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"W000197","created_at":"2026-01-03T10:38:57.000000Z","updated_at":"2026-01-11T10:30:25.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":17664600,"change_date":"2025-12-31 21:37:00","inspection_id":"86681164","insp_unit_id":"210861332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"761165","insp_unit_license":"3965052","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV8TSWT3557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:50.000000Z","updated_at":"2026-01-11T10:00:12.000000Z"},{"id":17664601,"change_date":"2025-12-31 21:37:00","inspection_id":"86681164","insp_unit_id":"210861333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"290784","insp_unit_license":"P948949","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2365M6209301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:50.000000Z","updated_at":"2026-01-11T10:00:12.000000Z"}]},{"id":10262725,"change_date":"2025-11-21 21:39:00","inspection_id":"86386508","dot_number":"243891","report_state":"TX","report_number":"V252121886","insp_date":"2025-11-20 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3340 US259 BUS SB","county_code_state":"TX","county_code":"401","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BILL & RALPHS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9766252","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2025-11-21 21:39:00","snet_input_date":"2025-11-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-21 21:39:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0024496","created_at":"2025-11-24T10:31:49.000000Z","updated_at":"2025-11-25T10:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17109480,"change_date":"2025-11-21 21:39:00","inspection_id":"86386508","insp_unit_id":"210181846","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"761167","insp_unit_license":"761167","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV6TSWT3539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:02:00.000000Z","updated_at":"2025-11-25T10:01:03.000000Z"},{"id":17109481,"change_date":"2025-11-21 21:39:00","inspection_id":"86386508","insp_unit_id":"210181847","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"884636","insp_unit_license":"P869458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2369L6911801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-24T10:02:00.000000Z","updated_at":"2025-11-25T10:01:03.000000Z"}]},{"id":9619331,"change_date":"2025-09-08 21:38:00","inspection_id":"85709849","dot_number":"243891","report_state":"LA","report_number":"LAAAS00168","insp_date":"2025-09-04 00:00:00","insp_start_time":"0911","insp_end_time":"0935","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LENA LA","county_code_state":"LA","county_code":"079","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2235916","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-09-08 21:38:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-08 21:38:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:46:10.000000Z","updated_at":"2025-09-11T10:46:18.000000Z","inspection_violations":[{"id":15731752,"change_date":"2025-09-08 21:38:00","inspection_id":"85709849","insp_violation_id":"268519710","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:06.000000Z","updated_at":"2025-09-12T10:50:05.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":15889195,"change_date":"2025-09-08 21:38:00","inspection_id":"85709849","insp_unit_id":"208798888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6","insp_unit_license":"Z409681","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC8PDUA5119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:40.000000Z","updated_at":"2025-09-12T10:46:57.000000Z"}]},{"id":9480074,"change_date":"2025-08-22 21:38:00","inspection_id":"85563736","dot_number":"243891","report_state":"AR","report_number":"5270001364","insp_date":"2025-08-22 00:00:00","insp_start_time":"1012","insp_end_time":"1035","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FOREMAN AR","county_code_state":"AR","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BILL & RALPHS","shipping_paper_number":"458850","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2165314","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-08-22 21:38:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-22 21:38:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:13.000000Z","updated_at":"2025-08-26T10:45:30.000000Z","inspection_violations":[{"id":15451919,"change_date":"2025-08-22 21:38:00","inspection_id":"85563736","insp_violation_id":"268188187","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W004719","created_at":"2025-08-25T10:45:34.000000Z","updated_at":"2025-08-26T10:46:56.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15637931,"change_date":"2025-08-22 21:38:00","inspection_id":"85563736","insp_unit_id":"208530044","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"17","insp_unit_license":"3286168","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV4PDNZ2095","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:39.000000Z","updated_at":"2025-08-26T09:45:38.000000Z"},{"id":15637932,"change_date":"2025-08-22 21:38:00","inspection_id":"85563736","insp_unit_id":"208530045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"17","insp_unit_license":"P869459","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2360L6911802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:39.000000Z","updated_at":"2025-08-26T09:45:38.000000Z"}]},{"id":9321977,"change_date":"2025-08-04 21:38:00","inspection_id":"85397519","dot_number":"243891","report_state":"MS","report_number":"7644009436","insp_date":"2025-08-01 00:00:00","insp_start_time":"1234","insp_end_time":"1252","registration_date":null,"region":"CT","ci_status_code":"C","location":"43","location_desc":"LINCOLN COUNTY","county_code_state":"MS","county_code":"085","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114423","transaction_code":"A","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:49.000000Z","updated_at":"2025-08-08T10:00:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15351542,"change_date":"2025-08-04 21:38:00","inspection_id":"85397519","insp_unit_id":"208223433","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"513200","insp_unit_license":"3159962","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV2NSNF0267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:30.000000Z","updated_at":"2025-08-08T09:45:46.000000Z"},{"id":15351543,"change_date":"2025-08-04 21:38:00","inspection_id":"85397519","insp_unit_id":"208223434","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2996424","insp_unit_license":"P998708","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2360M6385401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:30.000000Z","updated_at":"2025-08-08T09:45:46.000000Z"}]},{"id":9316286,"change_date":"2025-08-03 21:33:00","inspection_id":"85391499","dot_number":"243891","report_state":"AR","report_number":"7450000482","insp_date":"2025-08-01 00:00:00","insp_start_time":"1306","insp_end_time":"1329","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FORDYCE AR","county_code_state":"AR","county_code":"039","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2079476","transaction_code":"A","transaction_date":"2025-08-03 00:00:00","upload_date":"2025-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-08-03 21:33:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-03 21:33:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-06T10:43:42.000000Z","updated_at":"2025-08-07T10:44:38.000000Z","inspection_violations":[{"id":15114140,"change_date":"2025-08-03 21:33:00","inspection_id":"85391499","insp_violation_id":"267809283","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W000008","created_at":"2025-08-06T10:44:09.000000Z","updated_at":"2025-08-07T10:45:17.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15341607,"change_date":"2025-08-03 21:33:00","inspection_id":"85391499","insp_unit_id":"208212680","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"17","insp_unit_license":"3286168","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV4PDNZ2095","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-06T09:45:20.000000Z","updated_at":"2025-08-07T09:45:20.000000Z"},{"id":15341608,"change_date":"2025-08-03 21:33:00","inspection_id":"85391499","insp_unit_id":"208212681","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"17T","insp_unit_license":"P869459","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1UYVS2360L6911802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-06T09:45:20.000000Z","updated_at":"2025-08-07T09:45:20.000000Z"}]},{"id":9196073,"change_date":"2025-07-20 21:33:00","inspection_id":"85264918","dot_number":"243891","report_state":"AR","report_number":"7200000714","insp_date":"2025-07-15 00:00:00","insp_start_time":"1134","insp_end_time":"1202","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOUNT IDA AR","county_code_state":"AR","county_code":"097","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2015813","transaction_code":"A","transaction_date":"2025-07-19 00:00:00","upload_date":"2025-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-07-20 21:33:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-20 21:33:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-23T10:40:39.000000Z","updated_at":"2025-07-25T10:44:56.000000Z","inspection_violations":[{"id":14856036,"change_date":"2025-07-20 21:33:00","inspection_id":"85264918","insp_violation_id":"267516056","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-23T10:41:08.000000Z","updated_at":"2025-07-25T10:46:11.000000Z","normalized_code":"3922SLLTL"},{"id":14856037,"change_date":"2025-07-20 21:33:00","inspection_id":"85264918","insp_violation_id":"267516057","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-23T10:41:08.000000Z","updated_at":"2025-07-25T10:46:11.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15113334,"change_date":"2025-07-20 21:33:00","inspection_id":"85264918","insp_unit_id":"207966058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"577938","insp_unit_license":"Z409502","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC2PDUA4998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-23T09:45:22.000000Z","updated_at":"2025-07-24T09:45:08.000000Z"}]},{"id":9150714,"change_date":"2025-07-15 21:40:00","inspection_id":"85217331","dot_number":"243891","report_state":"AR","report_number":"8060000675","insp_date":"2025-07-14 00:00:00","insp_start_time":"1124","insp_end_time":"1146","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GURDON AR","county_code_state":"AR","county_code":"019","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BILL AND RALPHS INC","shipping_paper_number":"02","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1992978","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:01.000000Z","updated_at":"2025-07-19T10:41:47.000000Z","inspection_violations":[{"id":14765061,"change_date":"2025-07-15 21:40:00","inspection_id":"85217331","insp_violation_id":"267407108","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W000840","created_at":"2025-07-18T10:48:10.000000Z","updated_at":"2025-07-18T10:48:10.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15029498,"change_date":"2025-07-15 21:40:00","inspection_id":"85217331","insp_unit_id":"207873402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"YAR660","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC2JDKA1939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:36.000000Z","updated_at":"2025-07-19T09:45:28.000000Z"}]},{"id":8623744,"change_date":"2025-05-14 21:41:00","inspection_id":"84660583","dot_number":"243891","report_state":"AR","report_number":"7940000702","insp_date":"2025-05-12 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"CD","ci_status_code":"C","location":"501","location_desc":"WEST MEMPHIS AR","county_code_state":"AR","county_code":"035","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"BILL AND RALPH INC","shipping_paper_number":"37","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1722311","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-05-14 21:41:00","snet_input_date":"2025-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-14 21:41:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:41.000000Z","updated_at":"2025-05-18T10:03:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14081615,"change_date":"2025-05-14 21:41:00","inspection_id":"84660583","insp_unit_id":"206842183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"809313","insp_unit_license":"3350873","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG0KLKG4861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:36.000000Z","updated_at":"2025-05-18T09:48:51.000000Z"},{"id":14081616,"change_date":"2025-05-14 21:41:00","inspection_id":"84660583","insp_unit_id":"206842184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"274934","insp_unit_license":"P928698","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2365M6175201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:48:36.000000Z","updated_at":"2025-05-18T09:48:51.000000Z"}]},{"id":8261560,"change_date":"2025-04-01 21:40:00","inspection_id":"84279161","dot_number":"243891","report_state":"LA","report_number":"LAFZS00140","insp_date":"2025-03-31 00:00:00","insp_start_time":"1234","insp_end_time":"1257","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"COLUMBIA LA","county_code_state":"LA","county_code":null,"insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1536757","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-04-01 21:40:00","snet_input_date":"2025-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-01 21:40:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-04T10:21:06.000000Z","updated_at":"2025-04-06T10:18:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13371237,"change_date":"2025-04-01 21:40:00","inspection_id":"84279161","insp_unit_id":"206092057","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"274655","insp_unit_license":"2927243","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG7LDLY8236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:06:04.000000Z","updated_at":"2025-04-05T09:53:50.000000Z"},{"id":13371238,"change_date":"2025-04-01 21:40:00","inspection_id":"84279161","insp_unit_id":"206092058","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"676799","insp_unit_license":"L931309","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS236XH6132401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:06:04.000000Z","updated_at":"2025-04-05T09:53:50.000000Z"}]},{"id":8224028,"change_date":"2025-03-27 21:41:00","inspection_id":"84239553","dot_number":"243891","report_state":"MS","report_number":"7649010815","insp_date":"2025-03-25 00:00:00","insp_start_time":"1532","insp_end_time":"1604","registration_date":null,"region":"CT","ci_status_code":"C","location":"57","location_desc":"US-51 @ MS-48","county_code_state":"MS","county_code":"113","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CORNER MARKET","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1095415","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-26 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:25.000000Z","updated_at":"2025-03-31T10:29:22.000000Z","inspection_violations":[{"id":12906096,"change_date":"2025-03-27 21:41:00","inspection_id":"84239553","insp_violation_id":"265286706","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"500322614","created_at":"2025-03-29T10:49:25.000000Z","updated_at":"2025-03-31T10:48:47.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":13303340,"change_date":"2025-03-27 21:41:00","inspection_id":"84239553","insp_unit_id":"206019637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"3159962","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV2NSNF0267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:20:53.000000Z","updated_at":"2025-03-31T09:58:47.000000Z"},{"id":13303341,"change_date":"2025-03-27 21:41:00","inspection_id":"84239553","insp_unit_id":"206019638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"23","insp_unit_license":"P998708","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2360M6385401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:20:53.000000Z","updated_at":"2025-03-31T09:58:47.000000Z"}]},{"id":8009762,"change_date":"2025-03-03 21:38:00","inspection_id":"84014043","dot_number":"243891","report_state":"MS","report_number":"3003010809","insp_date":"2025-02-28 00:00:00","insp_start_time":"1431","insp_end_time":"1523","registration_date":null,"region":"CT","ci_status_code":"C","location":"75","location_desc":"WARREN COUNTY","county_code_state":"MS","county_code":"149","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"DELTA PRIDE","shipping_paper_number":"0402236-JR","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1092298","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-03-03 21:38:00","snet_input_date":"2025-03-03 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-03-03 21:38:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:30.000000Z","updated_at":"2025-03-17T21:04:30.000000Z","inspection_violations":[{"id":12516421,"change_date":"2025-03-03 21:38:00","inspection_id":"84014043","insp_violation_id":"264798418","seq_no":"1","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:07:09.000000Z","updated_at":"2025-03-17T22:07:09.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":12931174,"change_date":"2025-03-03 21:38:00","inspection_id":"84014043","insp_unit_id":"205594576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"809262","insp_unit_license":"2733202","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGADV8KDKG4856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:51.000000Z","updated_at":"2025-03-17T23:57:51.000000Z"},{"id":12931175,"change_date":"2025-03-03 21:38:00","inspection_id":"84014043","insp_unit_id":"205594577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"290784","insp_unit_license":"P948949","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2365M6209301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:51.000000Z","updated_at":"2025-03-17T23:57:51.000000Z"}]},{"id":7827324,"change_date":"2025-02-10 21:39:00","inspection_id":"83822726","dot_number":"243891","report_state":"AR","report_number":"5860000330","insp_date":"2025-02-07 00:00:00","insp_start_time":"0900","insp_end_time":"0919","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"STAMPS AR","county_code_state":"AR","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BILL & RALPH'S INC","shipping_paper_number":"05220","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1345752","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-02-10 21:39:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-10 21:39:00","insp_carrier_name":"BILL & RALPH'S INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:45.000000Z","updated_at":"2025-03-17T21:00:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12632440,"change_date":"2025-02-10 21:39:00","inspection_id":"83822726","insp_unit_id":"205241534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"778334","insp_unit_license":"YAR660","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3ALACWFC2JDKA1939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:33.000000Z","updated_at":"2025-03-17T23:54:33.000000Z"}]},{"id":7533240,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","dot_number":"243891","report_state":"AR","report_number":"5270000740","insp_date":"2025-01-02 00:00:00","insp_start_time":"1058","insp_end_time":"1137","registration_date":null,"region":"CS","ci_status_code":"C","location":"TWRMTN","location_desc":"DIERKS AR","county_code_state":"AR","county_code":"061","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BEN & RALPHS","shipping_paper_number":"MULTIPLE USE MA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211079","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2025-01-02 21:38:00","snet_input_date":"2025-01-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[{"id":11773759,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","insp_violation_id":"263722940","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"204619973","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922SLLIRP"},{"id":11773760,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","insp_violation_id":"263722941","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"204619973","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"3922SLLUCR"},{"id":11773761,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","insp_violation_id":"263722942","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204619973","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"39395A1"},{"id":11773762,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","insp_violation_id":"263722943","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204619973","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:22.000000Z","updated_at":"2025-03-17T22:03:22.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":12153529,"change_date":"2025-01-02 21:38:00","inspection_id":"83513630","insp_unit_id":"204619973","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"577938","insp_unit_license":"Z409502","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC2PDUA4998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":7053691,"change_date":"2024-10-27 21:33:00","inspection_id":"83007852","dot_number":"243891","report_state":"AR","report_number":"7540000386","insp_date":"2024-10-24 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"VARIOUS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"988879","transaction_code":"A","transaction_date":"2024-10-27 00:00:00","upload_date":"2024-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2024-10-27 21:33:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-27 21:33:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:03.000000Z","updated_at":"2025-03-17T20:43:03.000000Z","inspection_violations":[{"id":11010011,"change_date":"2024-10-27 21:33:00","inspection_id":"83007852","insp_violation_id":"262574992","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W000970","created_at":"2025-03-17T21:59:24.000000Z","updated_at":"2025-03-17T21:59:24.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":11376092,"change_date":"2024-10-27 21:33:00","inspection_id":"83007852","insp_unit_id":"203602367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"778334","insp_unit_license":"Z714708","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC2JDKA1939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:48.000000Z","updated_at":"2025-03-17T23:40:48.000000Z"}]},{"id":5188470,"change_date":"2024-03-01 21:39:00","inspection_id":"80998742","dot_number":"243891","report_state":"AR","report_number":"D527007896","insp_date":"2024-02-29 00:00:00","insp_start_time":"1452","insp_end_time":"1526","registration_date":null,"region":"CT","ci_status_code":"C","location":"41","location_desc":"LITTLE RIVER COUNTY","county_code_state":"AR","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"PILGRIMS PRIDE","shipping_paper_number":"65081","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1502636","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-02-29 00:00:00","source_office":"2ARS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7996330,"change_date":"2024-03-01 21:39:00","inspection_id":"80998742","insp_violation_id":"258150727","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199707896","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8354108,"change_date":"2024-03-01 21:39:00","inspection_id":"80998742","insp_unit_id":"199707896","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"22","insp_unit_license":"3500179","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG9KLKG4860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"},{"id":8354109,"change_date":"2024-03-01 21:39:00","inspection_id":"80998742","insp_unit_id":"199707897","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"299629","insp_unit_license":"P9998709","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484M6385501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4461739,"change_date":"2023-11-20 21:40:00","inspection_id":"80203835","dot_number":"243891","report_state":"MS","report_number":"2013011495","insp_date":"2023-11-16 00:00:00","insp_start_time":"1456","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":"14","location_desc":"COAHOMA COUNTY","county_code_state":"MS","county_code":"027","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1053476","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2023-11-20 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:23.000000Z","updated_at":"2025-03-17T19:51:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7175276,"change_date":"2023-11-20 21:40:00","inspection_id":"80203835","insp_unit_id":"198141757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"513200","insp_unit_license":"3159962","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHSDV2NSNF0267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"},{"id":7175277,"change_date":"2023-11-20 21:40:00","inspection_id":"80203835","insp_unit_id":"198141758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"919","insp_unit_license":"P998708","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2360M6385401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"}]},{"id":3606692,"change_date":"2023-07-27 21:40:00","inspection_id":"79253744","dot_number":"243891","report_state":"AR","report_number":"D745000978","insp_date":"2023-07-27 00:00:00","insp_start_time":"0629","insp_end_time":"0652","registration_date":null,"region":"CT","ci_status_code":"C","location":"13","location_desc":"CLEVELAND COUNTY","county_code_state":"AR","county_code":"025","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BILL AND RALPHS INC","shipping_paper_number":"04","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1468130","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5561900,"change_date":"2023-07-27 21:40:00","inspection_id":"79253744","insp_violation_id":"254310561","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W001033","created_at":"2025-03-17T21:32:48.000000Z","updated_at":"2025-03-17T21:32:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5798777,"change_date":"2023-07-27 21:40:00","inspection_id":"79253744","insp_unit_id":"196221451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"809305","insp_unit_license":"2814792","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGADV3KDKG4859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5798778,"change_date":"2023-07-27 21:40:00","inspection_id":"79253744","insp_unit_id":"196221452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"25","insp_unit_license":"L882907","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS1324GM755501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3582064,"change_date":"2023-07-24 21:42:00","inspection_id":"79226347","dot_number":"243891","report_state":"TX","report_number":"V231080068","insp_date":"2023-07-21 00:00:00","insp_start_time":"0910","insp_end_time":"0939","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 449","county_code_state":"TX","county_code":"203","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEAR CREEK","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9035270","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0024496","created_at":"2025-03-17T19:33:50.000000Z","updated_at":"2025-03-17T19:33:50.000000Z","inspection_violations":[{"id":5523821,"change_date":"2023-07-24 21:42:00","inspection_id":"79226347","insp_violation_id":"254247989","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196167035","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5760038,"change_date":"2023-07-24 21:42:00","inspection_id":"79226347","insp_unit_id":"196167035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"3537410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGADVKDKG4857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:29.000000Z","updated_at":"2025-03-17T22:48:29.000000Z"},{"id":5760039,"change_date":"2023-07-24 21:42:00","inspection_id":"79226347","insp_unit_id":"196167036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"884636","insp_unit_license":"P869458","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2369L6911801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:29.000000Z","updated_at":"2025-03-17T22:48:29.000000Z"}]},{"id":2962162,"change_date":"2023-05-04 21:41:00","inspection_id":"78527598","dot_number":"243891","report_state":"AR","report_number":"A708002343","insp_date":"2023-05-04 00:00:00","insp_start_time":"0606","insp_end_time":"0631","registration_date":null,"region":"CT","ci_status_code":"C","location":"35","location_desc":"JEFFERSON COUNTY","county_code_state":"AR","county_code":"069","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BILL & RALPH'S INC","shipping_paper_number":"37","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1455948","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2023-05-04 21:41:00","snet_input_date":"2023-05-04 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-05-04 21:41:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:49.000000Z","updated_at":"2025-03-17T19:21:49.000000Z","inspection_violations":[{"id":4546664,"change_date":"2023-05-04 21:41:00","inspection_id":"78527598","insp_violation_id":"252615069","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W000860","created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4766116,"change_date":"2023-05-04 21:41:00","inspection_id":"78527598","insp_unit_id":"194742902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"809313","insp_unit_license":"3350873","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG0KLKG4861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:35.000000Z","updated_at":"2025-03-17T22:40:35.000000Z"},{"id":4766117,"change_date":"2023-05-04 21:41:00","inspection_id":"78527598","insp_unit_id":"194742903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"274934","insp_unit_license":"P928698","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2365M6175201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:35.000000Z","updated_at":"2025-03-17T22:40:35.000000Z"}]},{"id":2395141,"change_date":"2023-02-17 21:39:00","inspection_id":"77883441","dot_number":"243891","report_state":"LA","report_number":"LAPA002109","insp_date":"2023-02-16 00:00:00","insp_start_time":"1217","insp_end_time":"1242","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1158400","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2023-02-17 21:39:00","snet_input_date":"2023-02-17 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-02-17 21:39:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:45.000000Z","updated_at":"2025-03-17T19:10:45.000000Z","inspection_violations":[{"id":3688427,"change_date":"2023-02-17 21:39:00","inspection_id":"77883441","insp_violation_id":"251200169","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193454359","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3854030,"change_date":"2023-02-17 21:39:00","inspection_id":"77883441","insp_unit_id":"193454359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"274655","insp_unit_license":"2927243","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG7LDLY8236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:35.000000Z","updated_at":"2025-03-17T22:33:35.000000Z"},{"id":3854031,"change_date":"2023-02-17 21:39:00","inspection_id":"77883441","insp_unit_id":"193454360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"676799","insp_unit_license":"L931309","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS236XH6132401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:35.000000Z","updated_at":"2025-03-17T22:33:35.000000Z"}]},{"id":2030135,"change_date":"2023-01-02 21:31:00","inspection_id":"77466153","dot_number":"243891","report_state":"TX","report_number":"6H4B0XRBU9","insp_date":"2022-12-23 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0037 IN FRANKLIN CO. (226-2","county_code_state":"TX","county_code":"159","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RK","shipping_paper_number":"001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8862770","transaction_code":"C","transaction_date":"2023-01-02 00:00:00","upload_date":"2023-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-12-28 21:40:00","snet_input_date":"2022-12-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-28 21:40:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"118 B & R DRIVE","insp_carrier_city":"SAREPTA","insp_carrier_state":"LA","insp_carrier_zip_code":"71071","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0024496","created_at":"2025-03-17T19:04:01.000000Z","updated_at":"2025-03-17T19:04:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3266468,"change_date":"2023-01-02 21:31:00","inspection_id":"77466153","insp_unit_id":"192656687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"2814792","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBGADV3KDKG4859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:23.000000Z","updated_at":"2025-03-17T22:29:23.000000Z"},{"id":3266469,"change_date":"2023-01-02 21:31:00","inspection_id":"77466153","insp_unit_id":"192656688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5662","insp_unit_license":"L882907","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:23.000000Z","updated_at":"2025-03-17T22:29:23.000000Z"}]},{"id":1310313,"change_date":"2022-09-18 21:30:00","inspection_id":"76638568","dot_number":"243891","report_state":"AR","report_number":"D527006906","insp_date":"2022-09-15 00:00:00","insp_start_time":"1247","insp_end_time":"1321","registration_date":null,"region":"CT","ci_status_code":"C","location":"31","location_desc":"HOWARD COUNTY","county_code_state":"AR","county_code":"061","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"THE WILDCAT DEN","shipping_paper_number":"265079A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-18 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1420773","transaction_code":"A","transaction_date":"2022-09-18 00:00:00","upload_date":"2022-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-09-18 21:30:00","snet_input_date":"2022-09-18 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-09-18 21:30:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:51.000000Z","updated_at":"2025-03-17T18:50:51.000000Z","inspection_violations":[{"id":2074728,"change_date":"2022-09-18 21:30:00","inspection_id":"76638568","insp_violation_id":"248488488","seq_no":"1","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"190961043","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":2109317,"change_date":"2022-09-18 21:30:00","inspection_id":"76638568","insp_unit_id":"190961043","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"577940","insp_unit_license":"Z409604","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC5PDUA5000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":1122137,"change_date":"2022-08-24 21:39:00","inspection_id":"76420096","dot_number":"243891","report_state":"AR","report_number":"D700002956","insp_date":"2022-08-23 00:00:00","insp_start_time":"1715","insp_end_time":"1750","registration_date":null,"region":"CT","ci_status_code":"C","location":"50","location_desc":"NEVADA COUNTY","county_code_state":"AR","county_code":"099","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BILL & RALPH'S INC","shipping_paper_number":"261067A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1417641","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:32.000000Z","updated_at":"2025-03-17T18:47:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1804745,"change_date":"2022-08-24 21:39:00","inspection_id":"76420096","insp_unit_id":"190510165","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"577939","insp_unit_license":"409536","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWFC4PDUA4999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":591647,"change_date":"2022-06-13 21:41:00","inspection_id":"75797758","dot_number":"243891","report_state":"MS","report_number":"U053005042","insp_date":"2022-06-08 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"MADISON COUNTY","county_code_state":"MS","county_code":"089","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CPU","shipping_paper_number":"73159","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"971677","transaction_code":"A","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:06.000000Z","updated_at":"2025-03-17T18:38:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":950647,"change_date":"2022-06-13 21:41:00","inspection_id":"75797758","insp_unit_id":"189199796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"514423","insp_unit_license":"3159964","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJHLDVXNSNF0275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"},{"id":950648,"change_date":"2022-06-13 21:41:00","inspection_id":"75797758","insp_unit_id":"189199797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"884638","insp_unit_license":"P869460","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L6911901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"}]},{"id":392202,"change_date":"2022-05-16 21:42:00","inspection_id":"75560869","dot_number":"243891","report_state":"AR","report_number":"D700002774","insp_date":"2022-05-16 00:00:00","insp_start_time":"1040","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":"55","location_desc":"PIKE COUNTY","county_code_state":"AR","county_code":"109","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BILL & RALPH'S INC","shipping_paper_number":"242829B","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1406811","transaction_code":"A","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-05-16 21:42:00","snet_input_date":"2022-05-16 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-05-16 21:42:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:26.000000Z","updated_at":"2025-03-17T18:34:26.000000Z","inspection_violations":[{"id":613047,"change_date":"2022-05-16 21:42:00","inspection_id":"75560869","insp_violation_id":"245796140","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W001738","created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"3922"},{"id":613048,"change_date":"2022-05-16 21:42:00","inspection_id":"75560869","insp_violation_id":"245796141","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188689055","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39360C"},{"id":613049,"change_date":"2022-05-16 21:42:00","inspection_id":"75560869","insp_violation_id":"245796142","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188689055","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":633399,"change_date":"2022-05-16 21:42:00","inspection_id":"75560869","insp_unit_id":"188689055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5","insp_unit_license":"C335996","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWDT5GDHN0845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:04.000000Z","updated_at":"2025-03-17T22:12:04.000000Z"}]},{"id":298242,"change_date":"2022-05-04 21:41:00","inspection_id":"75448892","dot_number":"243891","report_state":"LA","report_number":"LACG010327","insp_date":"2022-04-29 00:00:00","insp_start_time":"1135","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SCALES","county_code_state":"LA","county_code":"017","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1129740","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-05-02 21:40:00","snet_input_date":"2022-05-02 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-05-02 21:40:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:38.000000Z","updated_at":"2025-03-17T18:32:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":482325,"change_date":"2022-05-04 21:41:00","inspection_id":"75448892","insp_unit_id":"188497546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16","insp_unit_license":"C335704","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3ALACWDT9GDHN0850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:09.000000Z","updated_at":"2025-03-17T22:11:09.000000Z"}]},{"id":275587,"change_date":"2022-05-04 21:41:00","inspection_id":"75421770","dot_number":"243891","report_state":"LA","report_number":"LAFM014808","insp_date":"2022-04-27 00:00:00","insp_start_time":"1614","insp_end_time":"1636","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"073","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1129550","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-28 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:16.000000Z","updated_at":"2025-03-17T18:32:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":446057,"change_date":"2022-05-04 21:41:00","inspection_id":"75421770","insp_unit_id":"188497627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"274655","insp_unit_license":"2927243","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG7LDLY8236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"},{"id":446058,"change_date":"2022-05-04 21:41:00","inspection_id":"75421770","insp_unit_id":"188497628","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"676799","insp_unit_license":"L931309","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1UYVS236XH6132401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:57.000000Z","updated_at":"2025-03-17T22:10:57.000000Z"}]},{"id":108465,"change_date":"2022-04-05 21:39:00","inspection_id":"75220459","dot_number":"243891","report_state":"AR","report_number":"D700002718","insp_date":"2022-04-04 00:00:00","insp_start_time":"0700","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"29","location_desc":"HEMPSTEAD COUNTY","county_code_state":"AR","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BILL AND RALPH'S INC","shipping_paper_number":"25915","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1403168","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00243891","upload_search_indicator":"M","census_search_date":"2022-04-05 21:39:00","snet_input_date":"2022-04-04 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-04-05 21:39:00","insp_carrier_name":"BILL & RALPHS INC","insp_carrier_street":"PO BOX 1125","insp_carrier_city":"SPRINGHILL","insp_carrier_state":"LA","insp_carrier_zip_code":"71075-1125","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:28.000000Z","updated_at":"2025-03-17T18:29:28.000000Z","inspection_violations":[{"id":159278,"change_date":"2022-04-05 21:39:00","inspection_id":"75220459","insp_violation_id":"244961536","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W001701","created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"3922"},{"id":159279,"change_date":"2022-04-05 21:39:00","inspection_id":"75220459","insp_violation_id":"244961537","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"187985372","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":175331,"change_date":"2022-04-05 21:39:00","inspection_id":"75220459","insp_unit_id":"187985372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"247390","insp_unit_license":"2923975","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML9LL847124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:17.000000Z","updated_at":"2025-03-17T22:09:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/243891\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/243891\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/243891\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/243891\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}