{"current_page":1,"data":[{"id":7866080,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","dot_number":"2846862","report_state":"TX","report_number":"72PC9DGV25","insp_date":"2025-02-07 00:00:00","insp_start_time":"1205","insp_end_time":"1307","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN CHAMBERS CO. (472-4","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"10","oos_total":"4","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9497416","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12292334,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509963","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"38323A2"},{"id":12292335,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509964","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205317221","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39395F"},{"id":12292336,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509965","seq_no":"3","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"205317221","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39395B"},{"id":12292337,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509966","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"205317222","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39375A3"},{"id":12292338,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509967","seq_no":"5","part_no":"393","part_no_section":"23PT","insp_viol_unit":"1","insp_unit_id":"205317221","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39323PT"},{"id":12292339,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509968","seq_no":"6","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"205317221","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"393203C"},{"id":12292340,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509969","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205317221","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"3922RG"},{"id":12292341,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509970","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205317222","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"3922RG"},{"id":12292342,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509971","seq_no":"9","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39141A"},{"id":12292343,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_violation_id":"264509972","seq_no":"10","part_no":"392","part_no_section":"16","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:06:00.000000Z","updated_at":"2025-03-17T22:06:00.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":12695949,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_unit_id":"205317221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L42253","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK57LV91581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"},{"id":12695950,"change_date":"2025-02-13 21:40:00","inspection_id":"83863268","insp_unit_id":"205317222","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"124B580","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C9GT105958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"}]},{"id":6934500,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","dot_number":"2846862","report_state":"TX","report_number":"V241597708","insp_date":"2024-10-03 00:00:00","insp_start_time":"1448","insp_end_time":"1539","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB IH45 SB","county_code_state":"TX","county_code":"161","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MFC","shipping_paper_number":"798066965","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"6","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9398754","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10809558,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295250","seq_no":"1","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3929AA1"},{"id":10809559,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295251","seq_no":"2","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"203361451","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"393203E"},{"id":10809560,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295252","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","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:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3958A1"},{"id":10809561,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295253","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203361451","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3922"},{"id":10809562,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295254","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203361452","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3922"},{"id":10809563,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_violation_id":"262295255","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11184064,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_unit_id":"203361451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"1L42253","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK57LV91581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"},{"id":11184065,"change_date":"2024-10-10 21:42:00","inspection_id":"82881223","insp_unit_id":"203361452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"2","insp_unit_license":"124B580","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C9GT105958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"}]},{"id":6391523,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","dot_number":"2846862","report_state":"TX","report_number":"6XFD9DMO2O","insp_date":"2024-08-01 00:00:00","insp_start_time":"1336","insp_end_time":"1437","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0067 IN ELLIS CO. (424-434)","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"22","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"21","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9339685","transaction_code":"C","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2024-08-05 21:43:00","snet_input_date":"2024-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T20:29:30.000000Z","updated_at":"2025-03-17T20:29:30.000000Z","inspection_violations":[{"id":9920706,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047102","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3922"},{"id":9920707,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047103","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3922"},{"id":9920708,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047104","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202265708","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3922"},{"id":9920709,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047105","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39617C"},{"id":9920710,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047106","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202265708","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39617C"},{"id":9920711,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047107","seq_no":"7","part_no":"395","part_no_section":"8(a)(1)","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:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3958A1"},{"id":9920712,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047108","seq_no":"8","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"393203C"},{"id":9920713,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047109","seq_no":"9","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"393203E"},{"id":9920714,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047110","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39378"},{"id":9920715,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047111","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920716,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047112","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920717,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047113","seq_no":"13","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39319"},{"id":9920718,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047114","seq_no":"14","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"202265708","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39319"},{"id":9920719,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047115","seq_no":"15","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39345D"},{"id":9920720,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047116","seq_no":"16","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920721,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047117","seq_no":"17","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39355C1"},{"id":9920722,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047118","seq_no":"18","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39355D2"},{"id":9920723,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047119","seq_no":"19","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202265708","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39375A3"},{"id":9920724,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047120","seq_no":"20","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920725,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047121","seq_no":"21","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920726,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047122","seq_no":"22","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202265707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"},{"id":9920727,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_violation_id":"261047123","seq_no":"23","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202265708","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10300469,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_unit_id":"202265707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"818","insp_unit_license":"1L42253","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK57LV91581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"},{"id":10300470,"change_date":"2024-08-06 21:44:00","inspection_id":"82302828","insp_unit_id":"202265708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"811782","insp_unit_license":"124B580","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C9GT105958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"}]},{"id":4850536,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","dot_number":"2846862","report_state":"TX","report_number":"6RTE9DJMP6","insp_date":"2024-01-12 00:00:00","insp_start_time":"1422","insp_end_time":"1443","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700  MCCARTY","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9175048","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[{"id":7478295,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381741","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"38323A2"},{"id":7478296,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381742","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"39141A"},{"id":7478297,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381743","seq_no":"3","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"39216A"},{"id":7478298,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381744","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198999238","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3922"},{"id":7478299,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381745","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198999237","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3922"},{"id":7478300,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381746","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198999237","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"3922"},{"id":7478301,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381747","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198999237","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"39617C"},{"id":7478302,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_violation_id":"257381748","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198999237","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:03.000000Z","updated_at":"2025-03-17T21:42:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7804438,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_unit_id":"198999237","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M75516","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG42LJ47905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"},{"id":7804439,"change_date":"2024-01-17 21:44:00","inspection_id":"80629723","insp_unit_id":"198999238","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"124B580","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C9GT105958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"}]},{"id":2864924,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","dot_number":"2846862","report_state":"TX","report_number":"6KB79DNN3C","insp_date":"2023-04-17 00:00:00","insp_start_time":"0758","insp_end_time":"0844","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8960145","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2023-04-21 21:41:00","snet_input_date":"2023-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-21 21:41:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:19:39.000000Z","updated_at":"2025-03-17T19:19:39.000000Z","inspection_violations":[{"id":4397559,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376776","seq_no":"1","part_no":"393","part_no_section":"207(e)","insp_viol_unit":"1","insp_unit_id":"194526221","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"393207E"},{"id":4397560,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376777","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194526221","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"3922"},{"id":4397561,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376778","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194526221","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"39617C"},{"id":4397562,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376779","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194526222","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"3922"},{"id":4397563,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376780","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194526222","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"3922"},{"id":4397564,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376781","seq_no":"8","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"194526222","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"39375A1"},{"id":4397565,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376782","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194526222","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"39375C"},{"id":4397566,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_violation_id":"252376783","seq_no":"10","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194526222","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":4609735,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_unit_id":"194526221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"712","insp_unit_license":"67P071M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X5TS719995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:20.000000Z","updated_at":"2025-03-17T22:39:20.000000Z"},{"id":4609736,"change_date":"2023-04-21 21:41:00","inspection_id":"78417757","insp_unit_id":"194526222","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"122C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C4HT079027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:20.000000Z","updated_at":"2025-03-17T22:39:20.000000Z"}]},{"id":2822869,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","dot_number":"2846862","report_state":"TX","report_number":"6K7A9DDY24","insp_date":"2023-04-13 00:00:00","insp_start_time":"1020","insp_end_time":"1119","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A101","location_desc":"IH 45 NORTHBOUND","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2023-04-17 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":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8955820","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2023-04-17 21:41:00","snet_input_date":"2023-04-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:18:52.000000Z","updated_at":"2025-03-17T19:18:52.000000Z","inspection_violations":[{"id":4332615,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_violation_id":"252274383","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194434273","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39378"},{"id":4332616,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_violation_id":"252274384","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194434274","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"},{"id":4332617,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_violation_id":"252274385","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194434274","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39617C"},{"id":4332618,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_violation_id":"252274386","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194434274","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4543797,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_unit_id":"194434273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"67P071M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X1SJ647439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:49.000000Z","updated_at":"2025-03-17T22:38:49.000000Z"},{"id":4543798,"change_date":"2023-04-17 21:41:00","inspection_id":"78370243","insp_unit_id":"194434274","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"137C868","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204G328208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:49.000000Z","updated_at":"2025-03-17T22:38:49.000000Z"}]},{"id":2517546,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","dot_number":"2846862","report_state":"TX","report_number":"6J1D0NDZ1A","insp_date":"2023-03-02 00:00:00","insp_start_time":"1340","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0256 IN ANDERSON CO. (654-6","county_code_state":"TX","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"US PL HAWKINS FACTORY","shipping_paper_number":"80482297","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8921817","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:12:58.000000Z","updated_at":"2025-03-17T19:12:58.000000Z","inspection_violations":[{"id":3873049,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_violation_id":"251552838","seq_no":"5","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:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"3958"},{"id":3873046,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_violation_id":"251552835","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193775429","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39395A"},{"id":3873047,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_violation_id":"251552836","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193775429","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39617C"},{"id":3873048,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_violation_id":"251552837","seq_no":"4","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"193775429","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"393203A"},{"id":3873050,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_violation_id":"251552839","seq_no":"6","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"2","insp_unit_id":"193775430","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:11.000000Z","updated_at":"2025-03-17T21:25:11.000000Z","normalized_code":"39375A4"}],"inspection_per_units":[{"id":4052417,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_unit_id":"193775429","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"613","insp_unit_license":"1M75516","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG42LJ47905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"},{"id":4052418,"change_date":"2023-03-08 21:41:00","inspection_id":"78022802","insp_unit_id":"193775430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"122C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5V8VA53248M806809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"}]},{"id":2006659,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","dot_number":"2846862","report_state":"TX","report_number":"6H1F0DPYQD","insp_date":"2022-12-20 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN NAVARRO CO. (213-24","county_code_state":"TX","county_code":"349","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"US PL","shipping_paper_number":"80300649","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8859341","transaction_code":"C","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-22 21:40:00","insp_carrier_name":"CAMILO ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[{"id":3114939,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323153","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192637861","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39617C"},{"id":3114940,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323154","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192637862","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39617C"},{"id":3114941,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323155","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192637861","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3922"},{"id":3114942,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323156","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192637862","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3922"},{"id":3114943,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323157","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192637861","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3922"},{"id":3114944,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323158","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192637861","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39395A"},{"id":3114945,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323159","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192637862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3939A"},{"id":3114946,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_violation_id":"250323160","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192637862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3228334,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_unit_id":"192637861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"613","insp_unit_license":"1M75516","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG42LJ47905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:06.000000Z","updated_at":"2025-03-17T22:29:06.000000Z"},{"id":3228335,"change_date":"2022-12-29 21:40:00","inspection_id":"77439763","insp_unit_id":"192637862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"686042","insp_unit_license":"137C868","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06204G328208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:06.000000Z","updated_at":"2025-03-17T22:29:06.000000Z"}]},{"id":1746554,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","dot_number":"2846862","report_state":"TX","report_number":"6FX80AHGUY","insp_date":"2022-11-10 00:00:00","insp_start_time":"0730","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0075 IN MONTGOMERY CO. (448","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PALMER HOLLAND","shipping_paper_number":"260228","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8827546","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:58:55.000000Z","updated_at":"2025-03-17T18:58:55.000000Z","inspection_violations":[{"id":2736479,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618143","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191971339","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3922"},{"id":2736480,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618144","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191971338","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3922"},{"id":2736481,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618145","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191971338","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39617C"},{"id":2736482,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618146","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191971339","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39617C"},{"id":2736483,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618147","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191971338","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3922"},{"id":2736484,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_violation_id":"249618148","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191971339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2810560,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_unit_id":"191971338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X1SJ647439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:14.000000Z","updated_at":"2025-03-17T22:26:14.000000Z"},{"id":2810561,"change_date":"2022-11-15 21:40:00","inspection_id":"77141818","insp_unit_id":"191971339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"9199","insp_unit_license":"101C279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C27T388140","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:14.000000Z","updated_at":"2025-03-17T22:26:14.000000Z"}]},{"id":1862594,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","dot_number":"2846862","report_state":"TX","report_number":"6FPL9DJN9W","insp_date":"2022-11-02 00:00:00","insp_start_time":"1800","insp_end_time":"1840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700 W MONT HOUSTON R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SQ PUS PRODUCTS","shipping_paper_number":"740616749","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8840718","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-11-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2901717,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896721","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"192238630","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39021A"},{"id":2901718,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896722","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192238630","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39617C"},{"id":2901719,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896723","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192238630","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39617C"},{"id":2901720,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896724","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"38323A2"},{"id":2901721,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896725","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192238630","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"3922"},{"id":2901722,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896726","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192238630","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"3922"},{"id":2901723,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_violation_id":"249896727","seq_no":"7","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":2997543,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_unit_id":"192238630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"81","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHD49X0CD125171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"},{"id":2997544,"change_date":"2022-12-02 21:41:00","inspection_id":"77274924","insp_unit_id":"192238631","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"Y57201","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A5327XS250839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"}]},{"id":1307246,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","dot_number":"2846862","report_state":"TX","report_number":"6EA90XTWA6","insp_date":"2022-09-12 00:00:00","insp_start_time":"0915","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A101","location_desc":"IH 45 NORTHBOUND","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONAGRA BRANDS, INC.","shipping_paper_number":"192840","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8774283","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[{"id":2069103,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479947","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190954348","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3922"},{"id":2069104,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479948","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","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:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3958A1"},{"id":2069105,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479949","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190954349","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3939A"},{"id":2069106,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479950","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190954349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3939A"},{"id":2069107,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479951","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190954349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3939A"},{"id":2069108,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_violation_id":"248479952","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190954349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2104352,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_unit_id":"190954348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"110","insp_unit_license":"93286B6","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADR9X1SJ647439","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:25.000000Z","updated_at":"2025-03-17T22:21:25.000000Z"},{"id":2104353,"change_date":"2022-09-16 21:41:00","inspection_id":"76635159","insp_unit_id":"190954349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"122C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5V8VA53248M806809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:25.000000Z","updated_at":"2025-03-17T22:21:25.000000Z"}]},{"id":1049436,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","dot_number":"2846862","report_state":"TX","report_number":"6DIH9DJN5R","insp_date":"2022-08-15 00:00:00","insp_start_time":"1751","insp_end_time":"1845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8100 W TIDWELL RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"Y","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"11","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8745356","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:46:11.000000Z","updated_at":"2025-03-17T18:46:11.000000Z","inspection_violations":[{"id":1654187,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752058","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"38323A2"},{"id":1654188,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752059","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190339813","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39617C"},{"id":1654189,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752060","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190339814","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39617C"},{"id":1654190,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752061","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39141A"},{"id":1654191,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752062","seq_no":"5","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39216B"},{"id":1654192,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752063","seq_no":"6","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"190339813","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39355D2"},{"id":1654193,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752064","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190339813","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3939A"},{"id":1654194,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752065","seq_no":"8","part_no":"393","part_no_section":"13(d)(3)","insp_viol_unit":"1","insp_unit_id":"190339813","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39313D3"},{"id":1654195,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752066","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190339813","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3939A"},{"id":1654196,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752067","seq_no":"10","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"190339814","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"39375A1"},{"id":1654197,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_violation_id":"247752068","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190339814","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:44.000000Z","updated_at":"2025-03-17T21:14:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1688811,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_unit_id":"190339813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"613","insp_unit_license":"1M75516","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG42LJ47905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"},{"id":1688812,"change_date":"2022-08-16 21:39:00","inspection_id":"76334938","insp_unit_id":"190339814","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"137C830","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C82T039198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":1010751,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","dot_number":"2846862","report_state":"TX","report_number":"6D3E0XTKEX","insp_date":"2022-07-31 00:00:00","insp_start_time":"1400","insp_end_time":"1412","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN WALKER CO. (101-133","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"US HAWKINS FACTORY","shipping_paper_number":"T840168601","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8738591","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-08-10 21:40:00","snet_input_date":"2022-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-10 21:40:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:45:26.000000Z","updated_at":"2025-03-17T18:45:26.000000Z","inspection_violations":[{"id":1592024,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_violation_id":"247641372","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","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:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3958A1"},{"id":1592025,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_violation_id":"247641373","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190246086","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3939A"},{"id":1592026,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_violation_id":"247641374","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190246087","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3922"},{"id":1592027,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_violation_id":"247641375","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":1626199,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_unit_id":"190246086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"719","insp_unit_license":"1M19153","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLBG2CSBV6122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"},{"id":1626200,"change_date":"2022-08-10 21:40:00","inspection_id":"76290024","insp_unit_id":"190246087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"122C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5V8VA53248M806809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"}]},{"id":663383,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","dot_number":"2846862","report_state":"TX","report_number":"6BN90XDM2Q","insp_date":"2022-06-09 00:00:00","insp_start_time":"0830","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A199","location_desc":"SL-0012 IN DALLAS CO. (588-632","county_code_state":"TX","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8689597","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1044033,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630236","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"2","insp_unit_id":"189387270","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39375B"},{"id":1044034,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630237","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189387270","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3963A1"},{"id":1044035,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630238","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189387269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3963A1"},{"id":1044036,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630239","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189387269","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3965B"},{"id":1044037,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630240","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189387270","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3922"},{"id":1044038,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630241","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"189387269","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39345"},{"id":1044039,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630242","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189387270","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39347E"},{"id":1044040,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_violation_id":"246630243","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"189387270","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":1066337,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_unit_id":"189387269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"107","insp_unit_license":"IMI9153","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLBG2CSBV6122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1066338,"change_date":"2022-06-21 21:42:00","inspection_id":"75883474","insp_unit_id":"189387270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"I22C276","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5V8VA53248M806809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":270953,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","dot_number":"2846862","report_state":"TX","report_number":"6AAE0VJI7R","insp_date":"2022-04-21 00:00:00","insp_start_time":"1301","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0075 IN LEON CO. (362-388)","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"REFRESCO BEVERAGES US","shipping_paper_number":"52545065","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"12","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8637192","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02846862","upload_search_indicator":"M","census_search_date":"2022-04-27 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-27 21:40:00","insp_carrier_name":"CAMILO ANDRES ALVAREZ","insp_carrier_street":"9738 PHIL HALSTEAD DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77086-2879","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0917179","created_at":"2025-03-17T18:32:14.000000Z","updated_at":"2025-03-17T18:32:14.000000Z","inspection_violations":[{"id":421131,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428909","seq_no":"1","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39522G"},{"id":421132,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428910","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3958E1"},{"id":421133,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428911","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3963A1"},{"id":421134,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428912","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3939A"},{"id":421135,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428913","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39378"},{"id":421136,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428914","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188383832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3963A1"},{"id":421137,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428915","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"39617C"},{"id":421138,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428916","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":421139,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428917","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188383832","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":421140,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428918","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188383832","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"},{"id":421141,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428919","seq_no":"11","part_no":"392","part_no_section":"9b(a)","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3929BA"},{"id":421142,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_violation_id":"245428920","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188383831","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:04.000000Z","updated_at":"2025-03-17T21:09:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":439159,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_unit_id":"188383831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"107","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLBG2CSBV6122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:53.000000Z","updated_at":"2025-03-17T22:10:53.000000Z"},{"id":439160,"change_date":"2022-04-27 21:40:00","inspection_id":"75416384","insp_unit_id":"188383832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"285","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C4HT079027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:53.000000Z","updated_at":"2025-03-17T22:10:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2846862\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2846862\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2846862\/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\/2846862\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}