{"current_page":1,"data":[{"id":10404185,"change_date":"2025-12-11 21:44:00","inspection_id":"86534560","dot_number":"700452","report_state":"MO","report_number":"4427001855","insp_date":"2025-12-09 00:00:00","insp_start_time":"0757","insp_end_time":"0831","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SAPPINGTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","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-12-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2640492","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER AVE","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:37.000000Z","updated_at":"2025-12-15T10:30:28.000000Z","inspection_violations":[{"id":17440175,"change_date":"2025-12-11 21:44:00","inspection_id":"86534560","insp_violation_id":"270607964","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"210540381","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-14T10:32:23.000000Z","updated_at":"2025-12-15T10:31:30.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":17400159,"change_date":"2025-12-11 21:44:00","inspection_id":"86534560","insp_unit_id":"210540381","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2","insp_unit_license":"17KS7C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVXAMBD77DX80377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:52.000000Z","updated_at":"2025-12-15T10:00:36.000000Z"},{"id":17400160,"change_date":"2025-12-11 21:44:00","inspection_id":"86534560","insp_unit_id":"210540382","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"482L","insp_unit_license":"66M9NG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2485AM889501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:52.000000Z","updated_at":"2025-12-15T10:00:36.000000Z"}]},{"id":8755080,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","dot_number":"700452","report_state":"MO","report_number":"W124002246","insp_date":"2025-05-28 00:00:00","insp_start_time":"1239","insp_end_time":"1349","registration_date":null,"region":"CD","ci_status_code":"C","location":"A3E","location_desc":"MAYVIEW MO","county_code_state":"MO","county_code":"107","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"135812","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","viol_total":"3","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":"1792004","transaction_code":"C","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER AVE","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:34.000000Z","updated_at":"2025-07-27T10:40:39.000000Z","inspection_violations":[{"id":14898865,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","insp_violation_id":"267565109","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208005688","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:28.000000Z","updated_at":"2025-07-26T10:42:13.000000Z","normalized_code":"39355EB"},{"id":14898866,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","insp_violation_id":"267565110","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"208005687","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:28.000000Z","updated_at":"2025-07-26T10:42:13.000000Z","normalized_code":"39345B2BAIR"},{"id":14898867,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","insp_violation_id":"267565111","seq_no":"3","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208005687","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:28.000000Z","updated_at":"2025-07-26T10:42:13.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":15149651,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","insp_unit_id":"208005687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"3","insp_unit_license":"84KS6B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9TJ66N408265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:38.000000Z","updated_at":"2025-07-26T09:45:37.000000Z"},{"id":15149652,"change_date":"2025-07-22 21:42:00","inspection_id":"84799069","insp_unit_id":"208005688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"558273","insp_unit_license":"41K0GP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25359M655602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:38.000000Z","updated_at":"2025-07-26T09:45:37.000000Z"}]},{"id":7881917,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","dot_number":"700452","report_state":"MO","report_number":"W147000386","insp_date":"2025-02-13 00:00:00","insp_start_time":"1740","insp_end_time":"1810","registration_date":null,"region":"CS","ci_status_code":"C","location":"W147","location_desc":"WENTZVILLE MO","county_code_state":"MO","county_code":"183","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"132588","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-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","viol_total":"3","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":"1368099","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:56.000000Z","updated_at":"2025-03-17T21:01:56.000000Z","inspection_violations":[{"id":12318492,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","insp_violation_id":"264543345","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"205347555","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"3963A1BALAC"},{"id":12318493,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","insp_violation_id":"264543346","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"205347554","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"3922SLLIRP"},{"id":12318494,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","insp_violation_id":"264543347","seq_no":"3","part_no":"393","part_no_section":"40A-B","insp_viol_unit":"1","insp_unit_id":"205347554","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"39340AB"}],"inspection_per_units":[{"id":12722087,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","insp_unit_id":"205347554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"84KS6B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9TJ66N408265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"},{"id":12722088,"change_date":"2025-02-17 21:35:00","inspection_id":"83879949","insp_unit_id":"205347555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"41K0GP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25359M655602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"}]},{"id":7334279,"change_date":"2024-12-04 21:41:00","inspection_id":"83304590","dot_number":"700452","report_state":"MO","report_number":"4427001036","insp_date":"2024-12-03 00:00:00","insp_start_time":"0717","insp_end_time":"0744","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"130322","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-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1117551","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:00.000000Z","updated_at":"2025-03-17T20:49:00.000000Z","inspection_violations":[{"id":11469156,"change_date":"2024-12-04 21:41:00","inspection_id":"83304590","insp_violation_id":"263221371","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204170756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"3939ALCL"},{"id":11469157,"change_date":"2024-12-04 21:41:00","inspection_id":"83304590","insp_violation_id":"263221372","seq_no":"2","part_no":"392","part_no_section":"16B-DPASS","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-03-17T22:01:48.000000Z","updated_at":"2025-03-17T22:01:48.000000Z","normalized_code":"39216BDPASS"}],"inspection_per_units":[{"id":11831522,"change_date":"2024-12-04 21:41:00","inspection_id":"83304590","insp_unit_id":"204170756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2","insp_unit_license":"17KS7C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVXAMBD77DX80377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"},{"id":11831523,"change_date":"2024-12-04 21:41:00","inspection_id":"83304590","insp_unit_id":"204170757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"482L","insp_unit_license":"73K1GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2485AM889501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"}]},{"id":6427862,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","dot_number":"700452","report_state":"MO","report_number":"3725000805","insp_date":"2024-08-08 00:00:00","insp_start_time":"0825","insp_end_time":"0924","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FENTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"126388","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-08-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","viol_total":"5","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":"730952","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-08-09 21:37:00","snet_input_date":"2024-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-09 21:37:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:17.000000Z","updated_at":"2025-03-17T20:30:17.000000Z","inspection_violations":[{"id":9981023,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_violation_id":"261102395","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202311515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:18.000000Z","updated_at":"2025-03-17T21:54:18.000000Z","normalized_code":"39345B2"},{"id":9981024,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_violation_id":"261102396","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202311515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:18.000000Z","updated_at":"2025-03-17T21:54:18.000000Z","normalized_code":"3939A"},{"id":9981025,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_violation_id":"261102397","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202311516","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:18.000000Z","updated_at":"2025-03-17T21:54:18.000000Z","normalized_code":"39375C"},{"id":9981026,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_violation_id":"261102398","seq_no":"4","part_no":"392","part_no_section":"2","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-03-17T21:54:18.000000Z","updated_at":"2025-03-17T21:54:18.000000Z","normalized_code":"3922"},{"id":9981027,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_violation_id":"261102399","seq_no":"5","part_no":"392","part_no_section":"2","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-03-17T21:54:18.000000Z","updated_at":"2025-03-17T21:54:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10359405,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_unit_id":"202311515","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2","insp_unit_license":"17KS7C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVXAMBD77DX80377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:21.000000Z","updated_at":"2025-03-17T23:30:21.000000Z"},{"id":10359406,"change_date":"2024-08-09 21:37:00","inspection_id":"82341649","insp_unit_id":"202311516","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"73K1GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2485AM889501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:21.000000Z","updated_at":"2025-03-17T23:30:21.000000Z"}]},{"id":6072787,"change_date":"2024-07-02 21:42:00","inspection_id":"81960947","dot_number":"700452","report_state":"KS","report_number":"HP04090123","insp_date":"2024-06-22 00:00:00","insp_start_time":"1417","insp_end_time":"1505","registration_date":"2024-07-02 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"U 75 MP 187","county_code_state":"KS","county_code":"131","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"124789","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":"2024-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1329090","transaction_code":"C","transaction_date":"2024-06-22 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:00.000000Z","updated_at":"2025-03-17T20:23:00.000000Z","inspection_violations":[{"id":9421741,"change_date":"2024-07-02 21:42:00","inspection_id":"81960947","insp_violation_id":"260440335","seq_no":"1","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39522G"},{"id":9421742,"change_date":"2024-07-02 21:42:00","inspection_id":"81960947","insp_violation_id":"260440336","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":9780931,"change_date":"2024-07-02 21:42:00","inspection_id":"81960947","insp_unit_id":"201707243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"003","insp_unit_license":"84K56B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9TJ66N408265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"},{"id":9780932,"change_date":"2024-07-02 21:42:00","inspection_id":"81960947","insp_unit_id":"201707244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"558273","insp_unit_license":"41KOGP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25359M655602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"}]},{"id":6012654,"change_date":"2024-06-18 21:41:00","inspection_id":"81896065","dot_number":"700452","report_state":"MO","report_number":"3698000944","insp_date":"2024-06-17 00:00:00","insp_start_time":"1620","insp_end_time":"1640","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2024-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","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":"577308","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-06-18 21:41:00","snet_input_date":"2024-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-18 21:41:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:53.000000Z","updated_at":"2025-03-17T20:21:53.000000Z","inspection_violations":[{"id":9328328,"change_date":"2024-06-18 21:41:00","inspection_id":"81896065","insp_violation_id":"260157962","seq_no":"1","part_no":"392","part_no_section":"16(a)","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-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"39216A"},{"id":9328329,"change_date":"2024-06-18 21:41:00","inspection_id":"81896065","insp_violation_id":"260157963","seq_no":"2","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201456276","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"39378A"},{"id":9328330,"change_date":"2024-06-18 21:41:00","inspection_id":"81896065","insp_violation_id":"260157964","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201456276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9684222,"change_date":"2024-06-18 21:41:00","inspection_id":"81896065","insp_unit_id":"201456276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6","insp_unit_license":"91AS0N","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FUJF0CVX5LU91816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:21.000000Z","updated_at":"2025-03-17T23:23:21.000000Z"}]},{"id":5891059,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","dot_number":"700452","report_state":"MO","report_number":"W153000213","insp_date":"2024-05-30 00:00:00","insp_start_time":"1143","insp_end_time":"1218","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WENTZVILLE MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","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":"2024-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"532588","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-06-03 21:41:00","snet_input_date":"2024-05-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-03 21:41:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:28.000000Z","updated_at":"2025-03-17T20:19:28.000000Z","inspection_violations":[{"id":9133602,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_violation_id":"259847650","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201187654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3939A"},{"id":9133603,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_violation_id":"259847651","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201187654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3939A"},{"id":9133604,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_violation_id":"259847652","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201187655","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39375C"},{"id":9133605,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_violation_id":"259847653","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201187654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9488561,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_unit_id":"201187654","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"36AN9U","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5D69X81N539580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:25.000000Z","updated_at":"2025-03-17T23:21:25.000000Z"},{"id":9488562,"change_date":"2024-06-03 21:41:00","inspection_id":"81763807","insp_unit_id":"201187655","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"71J5ZE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS24848M281401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:25.000000Z","updated_at":"2025-03-17T23:21:25.000000Z"}]},{"id":5013719,"change_date":"2024-02-09 21:40:00","inspection_id":"80808385","dot_number":"700452","report_state":"MO","report_number":"4427000372","insp_date":"2024-02-09 00:00:00","insp_start_time":"0831","insp_end_time":"0857","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SAPPINGTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"232394","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-02-09 21:40:00","snet_input_date":"2024-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-09 21:40:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:03.000000Z","updated_at":"2025-03-17T20:02:03.000000Z","inspection_violations":[{"id":7723441,"change_date":"2024-02-09 21:40:00","inspection_id":"80808385","insp_violation_id":"257749680","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199344989","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39617CPI"},{"id":7723442,"change_date":"2024-02-09 21:40:00","inspection_id":"80808385","insp_violation_id":"257749681","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199344988","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":8069645,"change_date":"2024-02-09 21:40:00","inspection_id":"80808385","insp_unit_id":"199344988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1","insp_unit_license":"81KS0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSDHSJR3DJ466340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"},{"id":8069646,"change_date":"2024-02-09 21:40:00","inspection_id":"80808385","insp_unit_id":"199344989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"362L","insp_unit_license":"73K4GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7228BB705764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:07.000000Z","updated_at":"2025-03-17T23:08:07.000000Z"}]},{"id":5004416,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","dot_number":"700452","report_state":"MO","report_number":"W113000215","insp_date":"2024-02-06 00:00:00","insp_start_time":"1027","insp_end_time":"1104","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"VANDALIA MO","county_code_state":"MO","county_code":"007","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"120061","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":"2024-02-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"229339","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:00.000000Z","updated_at":"2025-03-17T20:02:00.000000Z","inspection_violations":[{"id":7709431,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_violation_id":"257727896","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199325159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39347E"},{"id":7709432,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_violation_id":"257727897","seq_no":"2","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"199325160","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39311BCSSRR"},{"id":7709433,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_violation_id":"257727898","seq_no":"3","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"2","insp_unit_id":"199325160","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39345B2B"},{"id":7709434,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_violation_id":"257727899","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"199325159","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":8054849,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_unit_id":"199325159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"9","insp_unit_license":"69AP8D","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDCSJR9BN333011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:59.000000Z","updated_at":"2025-03-17T23:07:59.000000Z"},{"id":8054850,"change_date":"2024-02-08 21:42:00","inspection_id":"80798212","insp_unit_id":"199325160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"73K5GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7223BB705767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:59.000000Z","updated_at":"2025-03-17T23:07:59.000000Z"}]},{"id":3894831,"change_date":"2023-09-05 21:39:00","inspection_id":"79575853","dot_number":"700452","report_state":"MO","report_number":"W140000033","insp_date":"2023-09-04 00:00:00","insp_start_time":"1753","insp_end_time":"1822","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EUREKAMO","county_code_state":"MO","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"48732","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2023-09-05 21:39:00","snet_input_date":"2023-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-05 21:39:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6262121,"change_date":"2023-09-05 21:39:00","inspection_id":"79575853","insp_unit_id":"196879641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"77AH4L","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1M1AA13Y7RW030356","insp_unit_decal":"Y","insp_unit_decal_number":"33045159","created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3457746,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","dot_number":"700452","report_state":"MO","report_number":"W096001613","insp_date":"2023-07-06 00:00:00","insp_start_time":"1112","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"C2W","location_desc":"C2 WEST","county_code_state":"MO","county_code":"071","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"BODEGA MEXICANA","shipping_paper_number":"MULTIPLE","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-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2082292","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2023-07-07 21:41:00","snet_input_date":"2023-07-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5330864,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932926","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195885244","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3963A1"},{"id":5330865,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932927","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"195885244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39347A"},{"id":5330866,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932928","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195885244","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39395A"},{"id":5330867,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932929","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195885244","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39395F"},{"id":5330868,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932930","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195885245","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3963A1"},{"id":5330869,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932931","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195885245","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39347E"},{"id":5330870,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_violation_id":"253932932","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195885245","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5559985,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_unit_id":"195885244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"17KS7C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVXAMBD77DX80377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"},{"id":5559986,"change_date":"2023-07-07 21:41:00","inspection_id":"79086851","insp_unit_id":"195885245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"73K1GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2485AM889501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":2852743,"change_date":"2023-04-20 21:42:00","inspection_id":"78404010","dot_number":"700452","report_state":"MO","report_number":"W108000400","insp_date":"2023-04-17 00:00:00","insp_start_time":"0722","insp_end_time":"0737","registration_date":null,"region":"CT","ci_status_code":"C","location":"B36","location_desc":"US 36 AND RT Z (MONROE CITY)","county_code_state":"MO","county_code":"173","insp_level_id":"3","service_center":"MW","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-04-20 21:42: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":"2069587","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-20 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:18.000000Z","updated_at":"2025-03-17T19:19:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4590491,"change_date":"2023-04-20 21:42:00","inspection_id":"78404010","insp_unit_id":"194499075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"36AN9U","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5D69X81N539580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:12.000000Z","updated_at":"2025-03-17T22:39:12.000000Z"},{"id":4590492,"change_date":"2023-04-20 21:42:00","inspection_id":"78404010","insp_unit_id":"194499076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"71J5ZE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS24848M281401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:12.000000Z","updated_at":"2025-03-17T22:39:12.000000Z"}]},{"id":2544164,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","dot_number":"700452","report_state":"MO","report_number":"0672001188","insp_date":"2023-03-08 00:00:00","insp_start_time":"1238","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"F70","location_desc":"IS 70 EB AT 148 MILE MARKER","county_code_state":"MO","county_code":"027","insp_level_id":"1","service_center":"MW","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-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2062566","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":null,"census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-09 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3912816,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_violation_id":"251573124","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193793764","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39345B2"},{"id":3912817,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_violation_id":"251573125","seq_no":"2","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"193793765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39347D"},{"id":3912818,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_violation_id":"251573126","seq_no":"3","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"193793765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39347D"},{"id":3912819,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_violation_id":"251573127","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193793765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3963A1"},{"id":3912820,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_violation_id":"251573128","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193793765","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4094971,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_unit_id":"193793764","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7","insp_unit_license":"84KS6B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDJSJR9DN154993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"},{"id":4094972,"change_date":"2023-03-09 21:42:00","inspection_id":"78052924","insp_unit_id":"193793765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"481L","insp_unit_license":"71J52E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS24848M281401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":1135685,"change_date":"2022-08-25 21:42:00","inspection_id":"76435988","dot_number":"700452","report_state":"MO","report_number":"SLC1002166","insp_date":"2022-08-24 00:00:00","insp_start_time":"0940","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":"C141","location_desc":"BAXTER RD @ CLAYTON RD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2028539","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":"M","census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:36.000000Z","updated_at":"2025-03-17T18:47:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1826548,"change_date":"2022-08-25 21:42:00","inspection_id":"76435988","insp_unit_id":"190543910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"81KS0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSDHSJR3DJ466340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:35.000000Z","updated_at":"2025-03-17T22:19:35.000000Z"},{"id":1826549,"change_date":"2022-08-25 21:42:00","inspection_id":"76435988","insp_unit_id":"190543911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"362L","insp_unit_license":"73K4GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7228BB705764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:35.000000Z","updated_at":"2025-03-17T22:19:35.000000Z"}]},{"id":749449,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","dot_number":"700452","report_state":"MO","report_number":"SLC7000550","insp_date":"2022-07-01 00:00:00","insp_start_time":"0700","insp_end_time":"0737","registration_date":null,"region":"CT","ci_status_code":"C","location":"C67","location_desc":"US 67 AT FOX MEADOWS","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"100765","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":"I","final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2019547","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":"M","census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-07-05 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1180001,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887247","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189602335","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"3939A"},{"id":1179996,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887242","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"189602334","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39355C1"},{"id":1179997,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887243","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189602335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39345B2"},{"id":1179998,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887244","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189602334","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39378"},{"id":1179999,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887245","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189602335","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39345B2"},{"id":1180000,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_violation_id":"246887246","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"189602335","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1205110,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_unit_id":"189602334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"81KS0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSDHSJR3DJ466340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"},{"id":1205111,"change_date":"2022-07-05 21:42:00","inspection_id":"75984771","insp_unit_id":"189602335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"362L","insp_unit_license":"73K4GH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA7228BB705764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"}]},{"id":472964,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","dot_number":"700452","report_state":"MO","report_number":"A4S6005780","insp_date":"2022-05-19 00:00:00","insp_start_time":"2115","insp_end_time":"2220","registration_date":null,"region":"CT","ci_status_code":"C","location":"A4N","location_desc":"HARRISONVILLE, NORTH","county_code_state":"MO","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SELF","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":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"14","oos_total":"3","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2013134","transaction_code":"C","transaction_date":"2022-06-07 00:00:00","upload_date":"2022-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00700452","upload_search_indicator":"M","census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"BODEGA MEXICANA WHOLESALE CO","insp_carrier_street":"6060 MANCHESTER","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:59.000000Z","updated_at":"2025-03-17T18:35:59.000000Z","inspection_violations":[{"id":748215,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287104","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3958"},{"id":748216,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287105","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3958"},{"id":748217,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287106","seq_no":"3","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3958"},{"id":748218,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287107","seq_no":"4","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3958K2"},{"id":748219,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287108","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39311"},{"id":748220,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287109","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39311"},{"id":748221,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287110","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39311"},{"id":748222,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287111","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3965B"},{"id":748223,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287112","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3939A"},{"id":748224,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287113","seq_no":"10","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189102506","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39375A3"},{"id":748225,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287114","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189102507","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3939A"},{"id":748226,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287115","seq_no":"12","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189102507","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39355E"},{"id":748227,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287116","seq_no":"13","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189102507","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"39345B2"},{"id":748228,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_violation_id":"246287117","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189102507","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:35.000000Z","updated_at":"2025-03-17T21:10:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":760492,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_unit_id":"189102506","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"36AN9U","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5D69X81N539580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"},{"id":760493,"change_date":"2022-06-07 21:38:00","inspection_id":"75657121","insp_unit_id":"189102507","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"558273","insp_unit_license":"41K0GP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25359M655602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/700452\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/700452\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/700452\/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\/700452\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}