{"current_page":1,"data":[{"id":12201803,"change_date":"2026-06-16 21:40:00","inspection_id":"88158598","dot_number":"476639","report_state":"MO","report_number":"3698003076","insp_date":"2026-06-16 00:00:00","insp_start_time":"1129","insp_end_time":"1153","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3555898","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:41.000000Z","updated_at":"2026-06-27T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528049,"change_date":null,"inspection_id":"88158598","insp_unit_id":"sms-backfill-793427382-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"AAJ961","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMN8TS546208","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11045753,"change_date":"2026-02-04 21:39:00","inspection_id":"86955328","dot_number":"476639","report_state":"MO","report_number":"3698002586","insp_date":"2026-02-04 00:00:00","insp_start_time":"1043","insp_end_time":"1113","registration_date":null,"region":"CS","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":"MILLIPOR SIGMA","shipping_paper_number":"6101516346","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-02-04 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":"2844851","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:36:59.000000Z","updated_at":"2026-02-15T10:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19451510,"change_date":null,"inspection_id":"86955328","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"89KR3B","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDZAPR3SN408611","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19457308,"change_date":null,"inspection_id":"86955328","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E7WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2489H3062701","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10015166,"change_date":"2025-10-23 21:39:00","inspection_id":"86126105","dot_number":"476639","report_state":"MO","report_number":"3214000657","insp_date":"2025-10-22 00:00:00","insp_start_time":"1249","insp_end_time":"1315","registration_date":null,"region":"CD","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":"MILLIPORE SIGMA","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":"2025-10-23 21:39: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":"2448390","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:49.000000Z","updated_at":"2025-10-27T10:00:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18669213,"change_date":null,"inspection_id":"86126105","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"72KS8F","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDZAPR5SN408612","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18831244,"change_date":null,"inspection_id":"86126105","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E9WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2482H3062703","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9815945,"change_date":"2025-09-30 21:39:00","inspection_id":"85916124","dot_number":"476639","report_state":"MO","report_number":"3214000640","insp_date":"2025-09-30 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CD","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":"SIGMAALDRICH MANUFACTURING LLC","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":"2025-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2347469","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-09-30 21:39:00","snet_input_date":"2025-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-30 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-03T10:01:49.000000Z","updated_at":"2025-10-04T10:00:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18666760,"change_date":null,"inspection_id":"85916124","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWQ1687","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HCDZAPR2NL663312","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18828555,"change_date":null,"inspection_id":"85916124","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E8WK","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2480H3062702","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9339181,"change_date":"2025-08-06 21:39:00","inspection_id":"85415467","dot_number":"476639","report_state":"MO","report_number":"3698002043","insp_date":"2025-08-05 00:00:00","insp_start_time":"0828","insp_end_time":"0857","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2090662","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-08-06 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-06 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:14.000000Z","updated_at":"2025-08-12T10:42:14.000000Z","inspection_violations":[{"id":18463549,"change_date":null,"inspection_id":"85415467","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":18661023,"change_date":null,"inspection_id":"85415467","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWQ1687","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HCDZAPR2NL663312","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18822396,"change_date":null,"inspection_id":"85415467","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"5090622","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2539GM652201","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8636842,"change_date":"2025-05-15 21:42:00","inspection_id":"84674156","dot_number":"476639","report_state":"MO","report_number":"3214000546","insp_date":"2025-05-14 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"CD","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":"MILLIPORE SIGMA","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":"2025-05-15 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":"1727870","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-05-15 21:42:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-15 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:03:32.000000Z","updated_at":"2025-05-19T10:03:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18729895,"change_date":null,"inspection_id":"84674156","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWQ1687","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HCDZAPR2NL663312","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18812971,"change_date":null,"inspection_id":"84674156","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E8WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2480H3062702","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8176938,"change_date":"2025-03-21 21:40:00","inspection_id":"84189944","dot_number":"476639","report_state":"MO","report_number":"3698001660","insp_date":"2025-03-21 00:00:00","insp_start_time":"1015","insp_end_time":"1034","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1499126","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:55.000000Z","updated_at":"2025-03-25T10:10:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18646019,"change_date":null,"inspection_id":"84189944","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PVY3618","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAMMMMN2FL508013","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8173285,"change_date":"2025-03-21 21:39:00","inspection_id":"84186058","dot_number":"476639","report_state":"MO","report_number":"3214000485","insp_date":"2025-03-20 00:00:00","insp_start_time":"1047","insp_end_time":"1115","registration_date":null,"region":"CD","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":"SIGMAALDRICH MANUFACTURING LLC","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":"2025-03-21 21:39: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":"1495207","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2025-03-21 21:39:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:26.000000Z","updated_at":"2025-03-25T10:09:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18723876,"change_date":null,"inspection_id":"84186058","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"72KS8F","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDZAPR5SN408612","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18806342,"change_date":null,"inspection_id":"84186058","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E9WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2482H3062703","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7827464,"change_date":"2025-02-10 21:39:00","inspection_id":"83822879","dot_number":"476639","report_state":"MO","report_number":"3698001548","insp_date":"2025-02-10 00:00:00","insp_start_time":"0716","insp_end_time":"0736","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","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":"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":"120000","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":"1345845","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":"00476639","upload_search_indicator":null,"census_search_date":"2025-02-10 21:39:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-10 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","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":18719201,"change_date":null,"inspection_id":"83822879","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"23KR0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDZAPR1SN408610","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18801156,"change_date":null,"inspection_id":"83822879","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"98E0WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2484H3062704","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7335274,"change_date":"2024-12-04 21:41:00","inspection_id":"83305665","dot_number":"476639","report_state":"MO","report_number":"3698001413","insp_date":"2024-12-04 00:00:00","insp_start_time":"0932","insp_end_time":"0951","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","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":"N","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":"33000","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":"1118590","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":"00476639","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:01.000000Z","updated_at":"2025-03-17T20:49:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18634719,"change_date":null,"inspection_id":"83305665","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"68AD9G","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HAMMAAN1FL518633","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7234055,"change_date":"2024-11-20 21:40:00","inspection_id":"83198820","dot_number":"476639","report_state":"MO","report_number":"3214000382","insp_date":"2024-11-19 00:00:00","insp_start_time":"1303","insp_end_time":"1325","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MILLIPORE SIGMA","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-11-20 21:40: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":"1070189","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:51.000000Z","updated_at":"2025-03-17T20:46:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18710963,"change_date":null,"inspection_id":"83198820","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"23KR0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDZAPR1SN408610","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18792123,"change_date":null,"inspection_id":"83198820","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"98E0WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2484H3062704","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7224952,"change_date":"2024-11-19 21:40:00","inspection_id":"83189213","dot_number":"476639","report_state":"MO","report_number":"1645002063","insp_date":"2024-11-15 00:00:00","insp_start_time":"0933","insp_end_time":"0955","registration_date":null,"region":"CS","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":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-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1066595","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[{"id":18428451,"change_date":null,"inspection_id":"83189213","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":18710830,"change_date":null,"inspection_id":"83189213","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWQ1687","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HCDZAPR2NL663312","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18791988,"change_date":null,"inspection_id":"83189213","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"97E8WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2480H3062702","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7045670,"change_date":"2024-10-25 21:40:00","inspection_id":"82999307","dot_number":"476639","report_state":"MO","report_number":"3698001349","insp_date":"2024-10-25 00:00:00","insp_start_time":"1000","insp_end_time":"1023","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"985498","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:00.000000Z","updated_at":"2025-03-17T20:43:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18630721,"change_date":null,"inspection_id":"82999307","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"68AD9G","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HAMMAAN1FL518633","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7021418,"change_date":"2024-10-23 21:41:00","inspection_id":"82973600","dot_number":"476639","report_state":"MO","report_number":"3214000351","insp_date":"2024-10-22 00:00:00","insp_start_time":"1238","insp_end_time":"1310","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"972074","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-10-23 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-23 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:36.000000Z","updated_at":"2025-03-17T20:42:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18708064,"change_date":null,"inspection_id":"82973600","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PVY3618","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAMMMMN2FL508013","insp_unit_decal":null,"insp_unit_decal_number":"34712377","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6755190,"change_date":"2024-09-18 21:42:00","inspection_id":"82690188","dot_number":"476639","report_state":"MO","report_number":"8039000888","insp_date":"2024-09-18 00:00:00","insp_start_time":"1143","insp_end_time":"1206","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":"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":"2024-09-18 21:42: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":"859654","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18626747,"change_date":null,"inspection_id":"82690188","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21KR3E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDJAPR6GN743800","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18784973,"change_date":null,"inspection_id":"82690188","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"97E9WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2482H3062703","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6450283,"change_date":"2024-08-13 21:41:00","inspection_id":"82365606","dot_number":"476639","report_state":"MO","report_number":"3214000303","insp_date":"2024-08-12 00:00:00","insp_start_time":"1304","insp_end_time":"1330","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MILLIPORE SIGMA","shipping_paper_number":"842835","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-08-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"738919","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-08-13 21:41:00","snet_input_date":"2024-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-13 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:42.000000Z","updated_at":"2025-03-17T20:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18622642,"change_date":null,"inspection_id":"82365606","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"29KG0A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HTMMAAN2FH518632","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6225807,"change_date":"2024-07-16 21:43:00","inspection_id":"82125399","dot_number":"476639","report_state":"MO","report_number":"3214000274","insp_date":"2024-07-16 00:00:00","insp_start_time":"0814","insp_end_time":"0835","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"3","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"657600","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-07-16 21:43:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-16 21:43:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:11.000000Z","updated_at":"2025-03-17T20:26:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18619598,"change_date":null,"inspection_id":"82125399","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21KR2E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDJAPR3GN743799","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5978712,"change_date":"2024-06-13 21:41:00","inspection_id":"81859335","dot_number":"476639","report_state":"MO","report_number":"5745000959","insp_date":"2024-06-12 00:00:00","insp_start_time":"1400","insp_end_time":"1420","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":"3","service_center":"MW","census_source_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2024-06-13 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":"565541","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-06-13 21:41:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-13 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18693794,"change_date":null,"inspection_id":"81859335","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21KR1E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSDJAPR8FH518190","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18773347,"change_date":null,"inspection_id":"81859335","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"98E0WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2484H3062704","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5816319,"change_date":"2024-05-22 21:40:00","inspection_id":"81683112","dot_number":"476639","report_state":"MO","report_number":"3698000900","insp_date":"2024-05-22 00:00:00","insp_start_time":"0912","insp_end_time":"0938","registration_date":null,"region":"CD","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":"NA","cargo_tank":null,"hazmat_placard_req":"N","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-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"506710","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18613744,"change_date":null,"inspection_id":"81683112","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":null,"insp_unit_license":"29KG0A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HTMMAAN2FH518632","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5013454,"change_date":"2024-02-09 21:40:00","inspection_id":"80808096","dot_number":"476639","report_state":"MO","report_number":"8039000417","insp_date":"2024-02-08 00:00:00","insp_start_time":"1458","insp_end_time":"1515","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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":"2024-02-09 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":"229685","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":"00476639","upload_search_indicator":null,"census_search_date":"2024-02-09 21:40:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-09 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","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":[],"inspection_per_units":[{"id":18679968,"change_date":null,"inspection_id":"80808096","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21KR2E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDJAPR3GN743799","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18758272,"change_date":null,"inspection_id":"80808096","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"97E7WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2489H3062701","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4820370,"change_date":"2024-01-12 21:42:00","inspection_id":"80596730","dot_number":"476639","report_state":"MO","report_number":"3698000423","insp_date":"2024-01-11 00:00:00","insp_start_time":"1044","insp_end_time":"1107","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-12 21:42: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":"171247","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2024-01-12 21:42:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-12 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:23.000000Z","updated_at":"2025-03-17T19:58:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18599354,"change_date":null,"inspection_id":"80596730","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"21KR3E","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HSDJAPR6GN743800","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18755057,"change_date":null,"inspection_id":"80596730","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97E9WK","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS2482H3062703","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":3999361,"change_date":"2023-09-19 21:39:00","inspection_id":"79691933","dot_number":"476639","report_state":"MO","report_number":"1645000017","insp_date":"2023-09-15 00:00:00","insp_start_time":"1255","insp_end_time":"1315","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUISMO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"55597","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-09-19 21:39:00","snet_input_date":"2023-09-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-19 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:41.000000Z","updated_at":"2025-03-17T19:41:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3999364,"change_date":"2023-09-19 21:39:00","inspection_id":"79691936","dot_number":"476639","report_state":"MO","report_number":"3698000060","insp_date":"2023-09-15 00:00:00","insp_start_time":"1324","insp_end_time":"1434","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUISMO","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":"S1141592","cargo_tank":null,"hazmat_placard_req":"N","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-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"8","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":"55600","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-09-19 21:39:00","snet_input_date":"2023-09-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-19 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:41.000000Z","updated_at":"2025-03-17T19:41:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3557107,"change_date":"2023-07-20 21:41:00","inspection_id":"79198173","dot_number":"476639","report_state":"MO","report_number":"00SG003956","insp_date":"2023-07-19 00:00:00","insp_start_time":"2040","insp_end_time":"2055","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2400 S 7TH","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","pen_cen_match":"I","final_status_date":"2023-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"2084785","transaction_code":"A","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:12.000000Z","updated_at":"2025-03-17T19:33:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3259866,"change_date":"2023-06-12 21:40:00","inspection_id":"78863783","dot_number":"476639","report_state":"MO","report_number":"00SG003832","insp_date":"2023-06-07 00:00:00","insp_start_time":"1415","insp_end_time":"1436","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"400 ARSENAL","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","pen_cen_match":"I","final_status_date":"2023-06-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"2078516","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-12 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:24.000000Z","updated_at":"2025-03-17T19:27:24.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3193814,"change_date":"2023-06-01 21:43:00","inspection_id":"78789392","dot_number":"476639","report_state":"MO","report_number":"00SB009397","insp_date":"2023-05-31 00:00:00","insp_start_time":"1235","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2600 S BROADWAY","county_code_state":"MO","county_code":"510","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":"2023-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2077104","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-06-01 21:43:00","snet_input_date":"2023-06-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3167295,"change_date":"2023-05-30 21:42:00","inspection_id":"78759359","dot_number":"476639","report_state":"MO","report_number":"00SX001256","insp_date":"2023-05-26 00:00:00","insp_start_time":"1416","insp_end_time":"1432","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"S 2ND ST\/SIDNEY ST","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2076357","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-30 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3053778,"change_date":"2023-05-16 21:42:00","inspection_id":"78631474","dot_number":"476639","report_state":"MO","report_number":"00SB009321","insp_date":"2023-05-15 00:00:00","insp_start_time":"1145","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"2600 SCOTT AVE","county_code_state":"MO","county_code":"510","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":"2023-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"2073835","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:25.000000Z","updated_at":"2025-03-17T19:23:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3001266,"change_date":"2023-05-09 21:42:00","inspection_id":"78572066","dot_number":"476639","report_state":"MO","report_number":"00SD008774","insp_date":"2023-05-03 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"7TH \/ SIDNEY","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","pen_cen_match":"I","final_status_date":"2023-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"2072651","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-05-09 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-05-09 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:35.000000Z","updated_at":"2025-03-17T19:22:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2635467,"change_date":"2023-03-22 21:42:00","inspection_id":"78156773","dot_number":"476639","report_state":"MO","report_number":"00SP006298","insp_date":"2023-03-21 00:00:00","insp_start_time":"0923","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"1200 CHOUTEAU AVE","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"I","final_status_date":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2064582","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2023-03-22 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:13.000000Z","updated_at":"2025-03-17T19:15:13.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2492539,"change_date":"2023-03-02 21:41:00","inspection_id":"77994396","dot_number":"476639","report_state":"MO","report_number":"00SB009060","insp_date":"2023-03-01 00:00:00","insp_start_time":"1450","insp_end_time":"1510","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"1000 CHOUTEAU","county_code_state":"MO","county_code":"510","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":"2023-03-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"2060953","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-03-02 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:32.000000Z","updated_at":"2025-03-17T19:12:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2337710,"change_date":"2023-02-09 21:40:00","inspection_id":"77817780","dot_number":"476639","report_state":"MO","report_number":"00SB009000","insp_date":"2023-02-08 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2400 S 2ND ST","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0007927267","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":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"2057763","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-09 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2215825,"change_date":"2023-01-24 21:42:00","inspection_id":"77679138","dot_number":"476639","report_state":"MO","report_number":"00SP006058","insp_date":"2023-01-23 00:00:00","insp_start_time":"1006","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"1000 CHOUTEAU AVE","county_code_state":"MO","county_code":"510","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":"2023-01-24 21:42: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":"2054926","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2023-01-24 21:42:00","snet_input_date":"2023-01-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:23.000000Z","updated_at":"2025-03-17T19:07:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2038452,"change_date":"2022-12-29 21:40:00","inspection_id":"77475833","dot_number":"476639","report_state":"MO","report_number":"00SP005959","insp_date":"2022-12-28 00:00:00","insp_start_time":"0823","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"1200 CHOUTEAU","county_code_state":"MO","county_code":"510","insp_level_id":"3","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-12-29 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":"2050635","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:04.000000Z","updated_at":"2025-03-17T19:04:04.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1986018,"change_date":"2022-12-20 21:41:00","inspection_id":"77416166","dot_number":"476639","report_state":"MO","report_number":"00SH006654","insp_date":"2022-12-19 00:00:00","insp_start_time":"1305","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":"C44","location_desc":"2000 S JEFFERSON","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2049747","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-20 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:18.000000Z","updated_at":"2025-03-17T19:03:18.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1604550,"change_date":"2022-10-26 21:39:00","inspection_id":"76979001","dot_number":"476639","report_state":"MO","report_number":"00SH006523","insp_date":"2022-10-25 00:00:00","insp_start_time":"1516","insp_end_time":"1531","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"3600 S BROADWAY","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"303030204","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-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2039494","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-26 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:17.000000Z","updated_at":"2025-03-17T18:56:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":739630,"change_date":"2022-07-01 21:38:00","inspection_id":"75973191","dot_number":"476639","report_state":"MO","report_number":"00SE003790","insp_date":"2022-06-28 00:00:00","insp_start_time":"1533","insp_end_time":"1553","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2100 MIAMI","county_code_state":"MO","county_code":"510","insp_level_id":"2","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":"Y","pen_cen_match":"I","final_status_date":"2022-07-01 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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2019195","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:35.000000Z","updated_at":"2025-03-17T18:40:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":112024,"change_date":"2022-04-05 21:40:00","inspection_id":"75224810","dot_number":"476639","report_state":"MO","report_number":"00SH005726","insp_date":"2022-04-04 00:00:00","insp_start_time":"1640","insp_end_time":"1701","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"200 PRESIDENT","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2004258","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00476639","upload_search_indicator":"M","census_search_date":"2022-04-05 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-04-05 21:40:00","insp_carrier_name":"SIGMA-ALDRICH MANUFACTURING LLC","insp_carrier_street":"3050 SPRUCE STREET","insp_carrier_city":"ST LOUIS","insp_carrier_state":"MO","insp_carrier_zip_code":"63103","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:29.000000Z","updated_at":"2025-03-17T18:29:29.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/476639\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/476639\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/476639\/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\/476639\/inspections","per_page":100,"prev_page_url":null,"to":38,"total":38}