{"current_page":1,"data":[{"id":12719366,"change_date":"2026-08-13 21:43:00","inspection_id":"88694896","dot_number":"1940100","report_state":"TX","report_number":"7HZD9DCTOU","insp_date":"2026-08-11 00:00:00","insp_start_time":"1345","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1100 W BARBOURS CUT","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":"2026-08-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10068574","transaction_code":"A","transaction_date":"2026-08-13 00:00:00","upload_date":"2026-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-08-13 21:43:00","snet_input_date":"2026-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-13 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-08-16T09:41:09.000000Z","updated_at":"2026-08-23T09:33:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22073570,"change_date":"2026-08-13 21:43:00","inspection_id":"88694896","insp_unit_id":"215146396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1761","insp_unit_license":"1N75449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD431761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-16T09:20:32.000000Z","updated_at":"2026-08-23T09:06:06.000000Z"},{"id":22073571,"change_date":"2026-08-13 21:43:00","inspection_id":"88694896","insp_unit_id":"215146397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"602","insp_unit_license":"138C486","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA6424GS010602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-16T09:20:32.000000Z","updated_at":"2026-08-23T09:06:06.000000Z"}]},{"id":12526083,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","dot_number":"1940100","report_state":"TX","report_number":"V262498160","insp_date":"2026-07-20 00:00:00","insp_start_time":"1245","insp_end_time":"1321","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"READY ICE","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":"2026-07-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10040173","transaction_code":"A","transaction_date":"2026-07-22 00:00:00","upload_date":"2026-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-07-22 21:44:00","snet_input_date":"2026-07-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-22 21:44:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-07-25T09:41:53.000000Z","updated_at":"2026-08-02T09:32:02.000000Z","inspection_violations":[{"id":21805646,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_violation_id":"275679610","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"214774035","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-25T10:03:04.000000Z","updated_at":"2026-08-02T09:45:09.000000Z","normalized_code":"39345B2PC"},{"id":21805647,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_violation_id":"275679611","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214774035","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:03:04.000000Z","updated_at":"2026-08-02T09:45:09.000000Z","normalized_code":"39347E"},{"id":21805648,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_violation_id":"275679612","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"214774036","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:03:04.000000Z","updated_at":"2026-08-02T09:45:09.000000Z","normalized_code":"39347E"},{"id":21805649,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_violation_id":"275679613","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"214774035","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:03:04.000000Z","updated_at":"2026-08-02T09:45:09.000000Z","normalized_code":"39353B"},{"id":21805650,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_violation_id":"275679614","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"214774035","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-25T10:03:04.000000Z","updated_at":"2026-08-02T09:45:09.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":21752704,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_unit_id":"214774035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"402","insp_unit_license":"1M19164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFRAMRXWC051402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-25T09:21:04.000000Z","updated_at":"2026-08-03T09:04:10.000000Z"},{"id":21752705,"change_date":"2026-07-22 21:44:00","inspection_id":"88491798","insp_unit_id":"214774036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"394","insp_unit_license":"259C892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA7228FE701394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-25T09:21:04.000000Z","updated_at":"2026-08-03T09:04:10.000000Z"}]},{"id":12328175,"change_date":"2026-06-30 21:41:00","inspection_id":"88286463","dot_number":"1940100","report_state":"TX","report_number":"7GOE9DAP3U","insp_date":"2026-06-25 00:00:00","insp_start_time":"1415","insp_end_time":"1456","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5300  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","shipping_paper_number":"1566070858","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":"2026-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10011883","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-06-30 21:41:00","snet_input_date":"2026-06-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-30 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-07-03T09:41:33.000000Z","updated_at":"2026-07-11T09:31:24.000000Z","inspection_violations":[{"id":21456252,"change_date":"2026-06-30 21:41:00","inspection_id":"88286463","insp_violation_id":"275231537","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"214379509","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:03:03.000000Z","updated_at":"2026-07-11T09:42:22.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":21410588,"change_date":"2026-06-30 21:41:00","inspection_id":"88286463","insp_unit_id":"214379509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"18","insp_unit_license":"TYW9160","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X6HM440290","insp_unit_decal":"Y","insp_unit_decal_number":"36287926","created_at":"2026-07-05T09:18:15.000000Z","updated_at":"2026-07-11T09:02:50.000000Z"}]},{"id":12404267,"change_date":"2026-07-09 21:42:00","inspection_id":"88362051","dot_number":"1940100","report_state":"TX","report_number":"7GNG9DGTMO","insp_date":"2026-06-24 00:00:00","insp_start_time":"1634","insp_end_time":"1704","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","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":"2026-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10016545","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-07-13T09:39:32.000000Z","updated_at":"2026-07-20T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21548619,"change_date":"2026-07-09 21:42:00","inspection_id":"88362051","insp_unit_id":"214524719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"LCP5187","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X9KM611330","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:56.000000Z","updated_at":"2026-07-20T09:03:24.000000Z"}]},{"id":12227206,"change_date":"2026-06-18 21:42:00","inspection_id":"88185280","dot_number":"1940100","report_state":"TX","report_number":"7FOA9DDC20","insp_date":"2026-05-20 00:00:00","insp_start_time":"1021","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3300  BAYPORT BLVD","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":"2026-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9998035","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-06-21T09:43:46.000000Z","updated_at":"2026-06-29T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21234538,"change_date":"2026-06-18 21:42:00","inspection_id":"88185280","insp_unit_id":"214181425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"696172","insp_unit_license":"230C734","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA6428FB701159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:39.000000Z","updated_at":"2026-06-29T09:02:44.000000Z"},{"id":21234537,"change_date":"2026-06-18 21:42:00","inspection_id":"88185280","insp_unit_id":"214181424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1761","insp_unit_license":"1N75449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD431761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:39.000000Z","updated_at":"2026-06-29T09:02:44.000000Z"}]},{"id":11761380,"change_date":"2026-04-27 21:39:00","inspection_id":"87691790","dot_number":"1940100","report_state":"TX","report_number":"V262319281","insp_date":"2026-04-24 00:00:00","insp_start_time":"1053","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COASTAL ICE","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":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56768","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9933794","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-04-30T09:39:40.000000Z","updated_at":"2026-05-08T09:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20462591,"change_date":"2026-04-27 21:39:00","inspection_id":"87691790","insp_unit_id":"213251121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"61","insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:46.000000Z","updated_at":"2026-05-08T09:04:06.000000Z"}]},{"id":11712115,"change_date":"2026-04-21 21:39:00","inspection_id":"87639189","dot_number":"1940100","report_state":"TX","report_number":"7EO99DGPFT","insp_date":"2026-04-14 00:00:00","insp_start_time":"0913","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FREEWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9925822","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-04-27T09:38:12.000000Z","updated_at":"2026-05-02T09:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20381400,"change_date":"2026-04-21 21:39:00","inspection_id":"87639189","insp_unit_id":"213144005","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"17","insp_unit_license":"TFR0970","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X5HM371320","insp_unit_decal":"Y","insp_unit_decal_number":"36286036","created_at":"2026-04-27T09:14:44.000000Z","updated_at":"2026-05-02T09:03:51.000000Z"}]},{"id":11711946,"change_date":"2026-04-21 21:39:00","inspection_id":"87639001","dot_number":"1940100","report_state":"TX","report_number":"7ENH9DGXKS","insp_date":"2026-04-13 00:00:00","insp_start_time":"1708","insp_end_time":"1719","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4400  RED BLUFF N\/B","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ROXANNE WATER -6600 LESSA","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":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9925813","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-04-27T09:38:12.000000Z","updated_at":"2026-05-02T09:31:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20381117,"change_date":"2026-04-21 21:39:00","inspection_id":"87639001","insp_unit_id":"213143663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"TYW9092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X8HM440291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:44.000000Z","updated_at":"2026-05-02T09:03:48.000000Z"}]},{"id":11632275,"change_date":"2026-04-13 21:38:00","inspection_id":"87561001","dot_number":"1940100","report_state":"TX","report_number":"7EH79DBADE","insp_date":"2026-04-07 00:00:00","insp_start_time":"0722","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14550  JOHN F. KENNE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","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":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9913637","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-04-24T09:31:03.000000Z","updated_at":"2026-04-24T09:31:03.000000Z","inspection_violations":[{"id":20189616,"change_date":"2026-04-13 21:38:00","inspection_id":"87561001","insp_violation_id":"273564941","seq_no":"1","part_no":"392","part_no_section":"82A1","insp_viol_unit":"1","insp_unit_id":"212987460","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:43:11.000000Z","updated_at":"2026-04-24T09:43:11.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":20232727,"change_date":"2026-04-13 21:38:00","inspection_id":"87561001","insp_unit_id":"212987460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"18","insp_unit_license":"TYW9160","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X6HM440290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:39.000000Z","updated_at":"2026-04-24T09:03:39.000000Z"}]},{"id":11644031,"change_date":"2026-04-14 21:39:00","inspection_id":"87573348","dot_number":"1940100","report_state":"TX","report_number":"7EE99DBSB5","insp_date":"2026-04-04 00:00:00","insp_start_time":"0938","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  NORTH FRWY SER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":"3123777487","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":"2026-04-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9917060","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-04-14 21:39:00","snet_input_date":"2026-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-14 21:39:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-04-25T09:31:05.000000Z","updated_at":"2026-04-25T09:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20254353,"change_date":"2026-04-14 21:39:00","inspection_id":"87573348","insp_unit_id":"213011074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"TYW9092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X8HM440291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:51.000000Z","updated_at":"2026-04-25T09:03:51.000000Z"}]},{"id":11503176,"change_date":"2026-03-27 21:40:00","inspection_id":"87423363","dot_number":"1940100","report_state":"TX","report_number":"7E2B9DJMHZ","insp_date":"2026-03-23 00:00:00","insp_start_time":"1156","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16800  BARKER SPRING","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9897837","transaction_code":"A","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-03-30T09:51:47.000000Z","updated_at":"2026-04-07T09:32:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19706426,"change_date":"2026-03-27 21:40:00","inspection_id":"87423363","insp_unit_id":"212389934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"18","insp_unit_license":"TYW9160","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X6HM440290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:29.000000Z","updated_at":"2026-04-07T09:09:22.000000Z"}]},{"id":11399613,"change_date":"2026-03-17 21:39:00","inspection_id":"87314586","dot_number":"1940100","report_state":"TX","report_number":"7DQB9DJW8A","insp_date":"2026-03-11 00:00:00","insp_start_time":"1139","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"REDDY ICE","shipping_paper_number":"3123738370","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":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9886694","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-03-20T09:42:40.000000Z","updated_at":"2026-03-28T09:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19523126,"change_date":"2026-03-17 21:39:00","inspection_id":"87314586","insp_unit_id":"212184902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"Y","insp_unit_decal_number":"35975322","created_at":"2026-03-20T09:19:30.000000Z","updated_at":"2026-03-28T09:05:52.000000Z"}]},{"id":10780950,"change_date":"2026-01-15 21:41:00","inspection_id":"86806647","dot_number":"1940100","report_state":"TX","report_number":"7C099DCAEL","insp_date":"2026-01-08 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9800  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9818866","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2026-01-18T10:45:09.000000Z","updated_at":"2026-01-26T10:31:05.000000Z","inspection_violations":[{"id":18013328,"change_date":"2026-01-15 21:41:00","inspection_id":"86806647","insp_violation_id":"271234545","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"211115385","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:40.000000Z","updated_at":"2026-01-26T10:31:43.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":18099658,"change_date":"2026-01-15 21:41:00","inspection_id":"86806647","insp_unit_id":"211115385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TCC3050","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:40.000000Z","updated_at":"2026-01-26T10:01:15.000000Z"}]},{"id":10179733,"change_date":"2025-11-12 21:41:00","inspection_id":"86299532","dot_number":"1940100","report_state":"TX","report_number":"7A799DGX3H","insp_date":"2025-11-04 00:00:00","insp_start_time":"0918","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9753758","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-11-15T10:30:49.000000Z","updated_at":"2025-11-16T10:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16954495,"change_date":"2025-11-12 21:41:00","inspection_id":"86299532","insp_unit_id":"209982972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"17","insp_unit_license":"TFR0970","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X5HM371320","insp_unit_decal":"Y","insp_unit_decal_number":"35654698","created_at":"2025-11-15T10:00:41.000000Z","updated_at":"2025-11-16T10:01:28.000000Z"}]},{"id":9927681,"change_date":"2025-10-13 21:37:00","inspection_id":"86033510","dot_number":"1940100","report_state":"TX","report_number":"799A9DBT9Y","insp_date":"2025-10-01 00:00:00","insp_start_time":"0948","insp_end_time":"1029","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  GREENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"26-500222","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-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9723066","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-10-16T10:00:42.000000Z","updated_at":"2025-10-17T10:00:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16477153,"change_date":"2025-10-13 21:37:00","inspection_id":"86033510","insp_unit_id":"209441272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"Y","insp_unit_decal_number":"35653041","created_at":"2025-10-16T09:46:00.000000Z","updated_at":"2025-10-17T09:46:05.000000Z"}]},{"id":9963161,"change_date":"2025-10-16 21:40:00","inspection_id":"86071359","dot_number":"1940100","report_state":"TX","report_number":"783D9DCB92","insp_date":"2025-08-20 00:00:00","insp_start_time":"1324","insp_end_time":"1349","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5500  CORTLANDT ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9728090","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-10-19T10:01:48.000000Z","updated_at":"2025-10-20T10:01:18.000000Z","inspection_violations":[{"id":16453865,"change_date":"2025-10-16 21:40:00","inspection_id":"86071359","insp_violation_id":"269347745","seq_no":"1","part_no":"393","part_no_section":"104A","insp_viol_unit":"1","insp_unit_id":"209512016","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:50.000000Z","updated_at":"2025-10-20T10:16:59.000000Z","normalized_code":"393104A"}],"inspection_per_units":[{"id":16541797,"change_date":"2025-10-16 21:40:00","inspection_id":"86071359","insp_unit_id":"209512016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:01.000000Z","updated_at":"2025-10-20T09:46:32.000000Z"}]},{"id":9156784,"change_date":"2025-07-15 21:41:00","inspection_id":"85223644","dot_number":"1940100","report_state":"TX","report_number":"V251931417","insp_date":"2025-07-10 00:00:00","insp_start_time":"1512","insp_end_time":"1534","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENTERGY TRANSFER","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-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9637946","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-07-15 21:41:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-15 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-07-18T10:46:07.000000Z","updated_at":"2025-07-19T10:42:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15039639,"change_date":"2025-07-15 21:41:00","inspection_id":"85223644","insp_unit_id":"207886360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5764","insp_unit_license":"1L38214","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHD79XXCD155764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:46:01.000000Z"},{"id":15039640,"change_date":"2025-07-15 21:41:00","inspection_id":"85223644","insp_unit_id":"207886361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"216","insp_unit_license":"124B212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2480XU980216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:46:01.000000Z"}]},{"id":9156379,"change_date":"2025-07-15 21:40:00","inspection_id":"85223295","dot_number":"1940100","report_state":"TX","report_number":"76WC9DCN0M","insp_date":"2025-07-08 00:00:00","insp_start_time":"1218","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","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-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9637502","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-07-18T10:46:06.000000Z","updated_at":"2025-07-19T10:42:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15038714,"change_date":"2025-07-15 21:40:00","inspection_id":"85223295","insp_unit_id":"207885691","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TYW9092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X8HM440291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:45:58.000000Z"}]},{"id":9156417,"change_date":"2025-07-15 21:40:00","inspection_id":"85223335","dot_number":"1940100","report_state":"TX","report_number":"76W99DGADL","insp_date":"2025-07-08 00:00:00","insp_start_time":"0904","insp_end_time":"0936","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","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-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9637476","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-07-18T10:46:06.000000Z","updated_at":"2025-07-19T10:42:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15038769,"change_date":"2025-07-15 21:40:00","inspection_id":"85223335","insp_unit_id":"207885750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"V-443","insp_unit_license":"MXK8534","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM700443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:45:58.000000Z"}]},{"id":8691059,"change_date":"2025-05-20 21:41:00","inspection_id":"84731368","dot_number":"1940100","report_state":"TX","report_number":"V251853793","insp_date":"2025-05-19 00:00:00","insp_start_time":"1443","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PETRO RESERVE","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9584875","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-05-23T10:04:25.000000Z","updated_at":"2025-05-24T10:06:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14200396,"change_date":"2025-05-20 21:41:00","inspection_id":"84731368","insp_unit_id":"206971221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"14","insp_unit_license":"MXK8533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X7LM700444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:17.000000Z","updated_at":"2025-05-24T09:51:35.000000Z"}]},{"id":8771073,"change_date":"2025-05-29 21:42:00","inspection_id":"84816057","dot_number":"1940100","report_state":"TX","report_number":"756D9DBT2O","insp_date":"2025-05-07 00:00:00","insp_start_time":"1253","insp_end_time":"1332","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-05-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9593054","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-05-29 21:42:00","snet_input_date":"2025-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-29 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-06-01T10:01:25.000000Z","updated_at":"2025-06-04T10:00:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14349117,"change_date":"2025-05-29 21:42:00","inspection_id":"84816057","insp_unit_id":"207135170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"TYW9092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X8HM440291","insp_unit_decal":"Y","insp_unit_decal_number":"35128635","created_at":"2025-06-01T09:46:47.000000Z","updated_at":"2025-06-02T09:46:04.000000Z"}]},{"id":8321026,"change_date":"2025-04-08 21:40:00","inspection_id":"84341617","dot_number":"1940100","report_state":"TX","report_number":"74879DJNLE","insp_date":"2025-04-03 00:00:00","insp_start_time":"0732","insp_end_time":"0811","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FREEWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9543591","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-04-11T10:12:23.000000Z","updated_at":"2025-04-12T10:22:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13495397,"change_date":"2025-04-08 21:40:00","inspection_id":"84341617","insp_unit_id":"206206083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"TCC3050","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"Y","insp_unit_decal_number":"35128557","created_at":"2025-04-11T10:05:48.000000Z","updated_at":"2025-04-12T10:01:12.000000Z"}]},{"id":8157799,"change_date":"2025-03-19 21:41:00","inspection_id":"84169812","dot_number":"1940100","report_state":"TX","report_number":"V251800477","insp_date":"2025-03-17 00:00:00","insp_start_time":"1458","insp_end_time":"1521","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"S AND D","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-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9526786","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-22T10:35:58.000000Z","updated_at":"2025-03-23T10:51:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13179191,"change_date":"2025-03-19 21:41:00","inspection_id":"84169812","insp_unit_id":"205884173","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"TCC3050","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:08:16.000000Z","updated_at":"2025-03-23T10:05:04.000000Z"}]},{"id":7912590,"change_date":"2025-02-19 21:41:00","inspection_id":"83912089","dot_number":"1940100","report_state":"TX","report_number":"V251786472","insp_date":"2025-02-13 00:00:00","insp_start_time":"1505","insp_end_time":"1603","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-10 MM 791","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","shipping_paper_number":"VARIOUS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9502772","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T21:02:23.000000Z","updated_at":"2025-03-17T21:02:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12772512,"change_date":"2025-02-19 21:41:00","inspection_id":"83912089","insp_unit_id":"205406677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7629688,"change_date":"2025-01-17 21:40:00","inspection_id":"83614916","dot_number":"1940100","report_state":"TX","report_number":"721A9DCPR7","insp_date":"2025-01-14 00:00:00","insp_start_time":"1005","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-01-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9474916","transaction_code":"C","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:56:32.000000Z","updated_at":"2025-03-17T20:56:32.000000Z","inspection_violations":[{"id":11923216,"change_date":"2025-01-17 21:40:00","inspection_id":"83614916","insp_violation_id":"264066419","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204901265","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"39347E"},{"id":11923217,"change_date":"2025-01-17 21:40:00","inspection_id":"83614916","insp_violation_id":"264066420","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204901265","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":12311007,"change_date":"2025-01-17 21:40:00","inspection_id":"83614916","insp_unit_id":"204901265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":7230602,"change_date":"2024-11-19 21:40:00","inspection_id":"83195242","dot_number":"1940100","report_state":"TX","report_number":"70A89DJNDA","insp_date":"2024-11-12 00:00:00","insp_start_time":"0854","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FREEWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58748","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9431179","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:46:50.000000Z","updated_at":"2025-03-17T20:46:50.000000Z","inspection_violations":[{"id":11301930,"change_date":"2024-11-19 21:40:00","inspection_id":"83195242","insp_violation_id":"262979022","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203955139","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39347E"},{"id":11301931,"change_date":"2024-11-19 21:40:00","inspection_id":"83195242","insp_violation_id":"262979023","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203955139","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":11662821,"change_date":"2024-11-19 21:40:00","inspection_id":"83195242","insp_unit_id":"203955139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:52.000000Z","updated_at":"2025-03-17T23:43:52.000000Z"}]},{"id":6990892,"change_date":"2024-10-18 21:42:00","inspection_id":"82941154","dot_number":"1940100","report_state":"TX","report_number":"6ZIA9DGXCF","insp_date":"2024-10-15 00:00:00","insp_start_time":"1055","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE & WATER LLC","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-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9405432","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":10906855,"change_date":"2024-10-18 21:42:00","inspection_id":"82941154","insp_violation_id":"262431028","seq_no":"1","part_no":"393","part_no_section":"203B","insp_viol_unit":"1","insp_unit_id":"203476960","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":11275835,"change_date":"2024-10-18 21:42:00","inspection_id":"82941154","insp_unit_id":"203476960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BT17","insp_unit_license":"TFR0970","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X5HM371320","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"}]},{"id":6819450,"change_date":"2024-09-25 21:41:00","inspection_id":"82759032","dot_number":"1940100","report_state":"TX","report_number":"6YS79DCPM0","insp_date":"2024-09-19 00:00:00","insp_start_time":"0730","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9386034","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10619574,"change_date":"2024-09-25 21:41:00","inspection_id":"82759032","insp_violation_id":"262033430","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203130414","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39347E"},{"id":10619575,"change_date":"2024-09-25 21:41:00","inspection_id":"82759032","insp_violation_id":"262033431","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203130414","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10997111,"change_date":"2024-09-25 21:41:00","inspection_id":"82759032","insp_unit_id":"203130414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PMJ6243","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9XXXD491315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6819344,"change_date":"2024-09-25 21:41:00","inspection_id":"82758918","dot_number":"1940100","report_state":"TX","report_number":"6YQA9DAX0Y","insp_date":"2024-09-17 00:00:00","insp_start_time":"1030","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":"3122795911","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9385867","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10619216,"change_date":"2024-09-25 21:41:00","inspection_id":"82758918","insp_violation_id":"262033026","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10996947,"change_date":"2024-09-25 21:41:00","inspection_id":"82758918","insp_unit_id":"203130229","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1761","insp_unit_license":"1N62821","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD431761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"},{"id":10996948,"change_date":"2024-09-25 21:41:00","inspection_id":"82758918","insp_unit_id":"203130230","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"3330622","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS23655U469002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6782020,"change_date":"2024-09-20 21:43:00","inspection_id":"82719278","dot_number":"1940100","report_state":"TX","report_number":"6YLE9DGX8X","insp_date":"2024-09-12 00:00:00","insp_start_time":"1432","insp_end_time":"1453","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7800  FAIRMONT PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE & WATER LLC","shipping_paper_number":"25-404063","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9382504","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[{"id":10561905,"change_date":"2024-09-20 21:43:00","inspection_id":"82719278","insp_violation_id":"261954373","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203056464","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"3963A1"},{"id":10561906,"change_date":"2024-09-20 21:43:00","inspection_id":"82719278","insp_violation_id":"261954374","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203056464","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10936578,"change_date":"2024-09-20 21:43:00","inspection_id":"82719278","insp_unit_id":"203056464","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"17","insp_unit_license":"TFR0970","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ9X5HM371320","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6782490,"change_date":"2024-09-20 21:43:00","inspection_id":"82719777","dot_number":"1940100","report_state":"TX","report_number":"6YK89DGX8C","insp_date":"2024-09-11 00:00:00","insp_start_time":"0846","insp_end_time":"0901","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7800  FAIRMONT PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9382473","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[{"id":10563356,"change_date":"2024-09-20 21:43:00","inspection_id":"82719777","insp_violation_id":"261956149","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203057361","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10937341,"change_date":"2024-09-20 21:43:00","inspection_id":"82719777","insp_unit_id":"203057361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"TCC3050","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6647020,"change_date":"2024-09-04 21:42:00","inspection_id":"82575320","dot_number":"1940100","report_state":"TX","report_number":"6Y799DRB2Z","insp_date":"2024-08-29 00:00:00","insp_start_time":"0900","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"31900  RILEY RD","county_code_state":"TX","county_code":"473","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9368889","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-09-04 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-04 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:34:50.000000Z","updated_at":"2025-03-17T20:34:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10716784,"change_date":"2024-09-04 21:42:00","inspection_id":"82575320","insp_unit_id":"202758266","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1761","insp_unit_license":"1N62821","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD431761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:59.000000Z","updated_at":"2025-03-17T23:33:59.000000Z"},{"id":10716785,"change_date":"2024-09-04 21:42:00","inspection_id":"82575320","insp_unit_id":"202758267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"9002","insp_unit_license":"3330622","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS23655U469002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:59.000000Z","updated_at":"2025-03-17T23:33:59.000000Z"}]},{"id":6506772,"change_date":"2024-08-19 21:43:00","inspection_id":"82425886","dot_number":"1940100","report_state":"TX","report_number":"V241515803","insp_date":"2024-08-14 00:00:00","insp_start_time":"1243","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"TX288 NB ANGLETON SCALE","county_code_state":"TX","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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-08-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9354457","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10106413,"change_date":"2024-08-19 21:43:00","inspection_id":"82425886","insp_violation_id":"261278116","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202471129","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10488954,"change_date":"2024-08-19 21:43:00","inspection_id":"82425886","insp_unit_id":"202471129","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1763","insp_unit_license":"1N56742","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X1HD431763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"},{"id":10488955,"change_date":"2024-08-19 21:43:00","inspection_id":"82425886","insp_unit_id":"202471130","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTBC","insp_unit_company":"5686","insp_unit_license":"3330618","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS248644315686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"}]},{"id":6119939,"change_date":"2024-07-01 21:44:00","inspection_id":"82011598","dot_number":"1940100","report_state":"TX","report_number":"6WHE9DBIMS","insp_date":"2024-06-28 00:00:00","insp_start_time":"1414","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0099 IN HARRIS CO. (698-750","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9314279","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:23:50.000000Z","updated_at":"2025-03-17T20:23:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9857614,"change_date":"2024-07-01 21:44:00","inspection_id":"82011598","insp_unit_id":"201681610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"LCP5187","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X9KM611330","insp_unit_decal":"Y","insp_unit_decal_number":"33927796","created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":6095933,"change_date":"2024-06-27 21:41:00","inspection_id":"81985887","dot_number":"1940100","report_state":"TX","report_number":"6WD89DCPJ3","insp_date":"2024-06-24 00:00:00","insp_start_time":"0810","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9310960","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-06-27 21:41:00","snet_input_date":"2024-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:23:25.000000Z","updated_at":"2025-03-17T20:23:25.000000Z","inspection_violations":[{"id":9461979,"change_date":"2024-06-27 21:41:00","inspection_id":"81985887","insp_violation_id":"260358460","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201631305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3939A"},{"id":9461980,"change_date":"2024-06-27 21:41:00","inspection_id":"81985887","insp_violation_id":"260358461","seq_no":"2","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"201631305","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39324A"}],"inspection_per_units":[{"id":9818596,"change_date":"2024-06-27 21:41:00","inspection_id":"81985887","insp_unit_id":"201631305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:42.000000Z","updated_at":"2025-03-17T23:24:42.000000Z"}]},{"id":5931502,"change_date":"2024-08-29 21:43:00","inspection_id":"81808155","dot_number":"1940100","report_state":"TX","report_number":"6VL69DTG1G","insp_date":"2024-05-27 00:00:00","insp_start_time":"0822","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN GALVESTON CO. (502-","county_code_state":"TX","county_code":"167","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":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9293096","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-05-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9198832,"change_date":"2024-08-29 21:43:00","inspection_id":"81808155","insp_violation_id":"261505019","seq_no":"1","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"202665176","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":9553815,"change_date":"2024-08-29 21:43:00","inspection_id":"81808155","insp_unit_id":"202665176","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"TCC3050","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5757932,"change_date":"2024-05-15 21:44:00","inspection_id":"81619786","dot_number":"1940100","report_state":"TX","report_number":"6V389DJVD6","insp_date":"2024-05-09 00:00:00","insp_start_time":"0840","insp_end_time":"0914","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9273563","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[{"id":8912799,"change_date":"2024-05-15 21:44:00","inspection_id":"81619786","insp_violation_id":"259526840","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200911946","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":9274103,"change_date":"2024-05-15 21:44:00","inspection_id":"81619786","insp_unit_id":"200911946","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5513988,"change_date":"2024-04-22 21:41:00","inspection_id":"81354286","dot_number":"1940100","report_state":"TX","report_number":"V241390572","insp_date":"2024-04-11 00:00:00","insp_start_time":"1220","insp_end_time":"1308","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH 10 WESTBOUND WINNIE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COASTAL ICE INC","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-04-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9249320","transaction_code":"C","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-04-15 21:42:00","snet_input_date":"2024-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-15 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:11:58.000000Z","updated_at":"2025-03-17T20:11:58.000000Z","inspection_violations":[{"id":8519753,"change_date":"2024-04-22 21:41:00","inspection_id":"81354286","insp_violation_id":"259065006","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200513262","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39378"},{"id":8519754,"change_date":"2024-04-22 21:41:00","inspection_id":"81354286","insp_violation_id":"259065007","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200513262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3939A"},{"id":8519755,"change_date":"2024-04-22 21:41:00","inspection_id":"81354286","insp_violation_id":"259065008","seq_no":"3","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"200513262","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":8882152,"change_date":"2024-04-22 21:41:00","inspection_id":"81354286","insp_unit_id":"200513262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PMJ6243","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9XXXD491315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:38.000000Z","updated_at":"2025-03-17T23:15:38.000000Z"}]},{"id":5319952,"change_date":"2024-03-19 21:45:00","inspection_id":"81142615","dot_number":"1940100","report_state":"TX","report_number":"6TI89DGTL7","insp_date":"2024-03-13 00:00:00","insp_start_time":"0852","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9226575","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:07:57.000000Z","updated_at":"2025-03-17T20:07:57.000000Z","inspection_violations":[{"id":8208468,"change_date":"2024-03-19 21:45:00","inspection_id":"81142615","insp_violation_id":"258468380","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199986394","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39347E"},{"id":8208469,"change_date":"2024-03-19 21:45:00","inspection_id":"81142615","insp_violation_id":"258468381","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199986394","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"39353B"},{"id":8208470,"change_date":"2024-03-19 21:45:00","inspection_id":"81142615","insp_violation_id":"258468382","seq_no":"3","part_no":"393","part_no_section":"104(c)","insp_viol_unit":"1","insp_unit_id":"199986394","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"393104C"}],"inspection_per_units":[{"id":8567866,"change_date":"2024-03-19 21:45:00","inspection_id":"81142615","insp_unit_id":"199986394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":5115830,"change_date":"2024-02-22 21:43:00","inspection_id":"80919898","dot_number":"1940100","report_state":"TX","report_number":"V241296906","insp_date":"2024-02-20 00:00:00","insp_start_time":"1141","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH 10 WESTBOUND WINNIE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DROP OFF","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-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9204426","transaction_code":"A","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8236361,"change_date":"2024-02-22 21:43:00","inspection_id":"80919898","insp_unit_id":"199558190","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"LCP5187","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X9KM611330","insp_unit_decal":"Y","insp_unit_decal_number":"33596013","created_at":"2025-03-17T23:09:39.000000Z","updated_at":"2025-03-17T23:09:39.000000Z"}]},{"id":5092121,"change_date":"2024-02-20 21:42:00","inspection_id":"80894117","dot_number":"1940100","report_state":"TX","report_number":"6SP99DJV33","insp_date":"2024-02-13 00:00:00","insp_start_time":"0935","insp_end_time":"1007","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9199798","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:03:29.000000Z","updated_at":"2025-03-17T20:03:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8198116,"change_date":"2024-02-20 21:42:00","inspection_id":"80894117","insp_unit_id":"199508393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:18.000000Z","updated_at":"2025-03-17T23:09:18.000000Z"}]},{"id":4922100,"change_date":"2024-01-29 21:40:00","inspection_id":"80707995","dot_number":"1940100","report_state":"TX","report_number":"6S6A9DCRP2","insp_date":"2024-01-25 00:00:00","insp_start_time":"1011","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9182324","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2024-01-29 21:40:00","snet_input_date":"2024-01-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-29 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T20:00:25.000000Z","updated_at":"2025-03-17T20:00:25.000000Z","inspection_violations":[{"id":7581781,"change_date":"2024-01-29 21:40:00","inspection_id":"80707995","insp_violation_id":"257541351","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199153006","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"39345B2"},{"id":7581782,"change_date":"2024-01-29 21:40:00","inspection_id":"80707995","insp_violation_id":"257541352","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199153006","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:37.000000Z","updated_at":"2025-03-17T21:42:37.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":7920988,"change_date":"2024-01-29 21:40:00","inspection_id":"80707995","insp_unit_id":"199153006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:49.000000Z","updated_at":"2025-03-17T23:06:49.000000Z"}]},{"id":4728171,"change_date":"2024-12-10 21:41:00","inspection_id":"80496108","dot_number":"1940100","report_state":"TX","report_number":"6R499DAP7V","insp_date":"2023-12-18 00:00:00","insp_start_time":"0959","insp_end_time":"1016","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"REDDY ICE","shipping_paper_number":"3122294198","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-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9159751","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7605670,"change_date":"2024-12-10 21:41:00","inspection_id":"80496108","insp_unit_id":"204300013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"14","insp_unit_license":"MXK8533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X7LM700444","insp_unit_decal":"Y","insp_unit_decal_number":"33314230","created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"}]},{"id":4634953,"change_date":"2024-12-09 21:41:00","inspection_id":"80394320","dot_number":"1940100","report_state":"TX","report_number":"6QZA9DBEZ2","insp_date":"2023-12-13 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1806 S BATTLEGROUND","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COSTAL ICE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9149401","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7454798,"change_date":"2024-12-09 21:41:00","inspection_id":"80394320","insp_unit_id":"204272709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8","insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"Y","insp_unit_decal_number":"33312052","created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4274659,"change_date":"2023-10-24 21:40:00","inspection_id":"79997247","dot_number":"1940100","report_state":"TX","report_number":"6PG79DJMMD","insp_date":"2023-10-19 00:00:00","insp_start_time":"0720","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12400  NORTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9108492","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6875009,"change_date":"2023-10-24 21:40:00","inspection_id":"79997247","insp_unit_id":"197726101","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"Y","insp_unit_decal_number":"33312372","created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":4148213,"change_date":"2023-10-06 21:41:00","inspection_id":"79857529","dot_number":"1940100","report_state":"TX","report_number":"6P089DBA0L","insp_date":"2023-10-03 00:00:00","insp_start_time":"0820","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3210  FM 1960 ROAD R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9094063","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:44:56.000000Z","updated_at":"2025-03-17T19:44:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6670047,"change_date":"2023-10-06 21:41:00","inspection_id":"79857529","insp_unit_id":"197446531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"13","insp_unit_license":"MXK8534","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM700443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"}]},{"id":3883160,"change_date":"2023-09-01 21:40:00","inspection_id":"79562868","dot_number":"1940100","report_state":"TX","report_number":"6NNC9DBFUR","insp_date":"2023-08-15 00:00:00","insp_start_time":"1235","insp_end_time":"1258","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16100  2ND ST","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-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9065052","transaction_code":"C","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-08-31 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-31 21:43:00","insp_carrier_name":"COASTAL ICE AND WATER LLC","insp_carrier_street":"14432 JOHN F KENNEDY BLVD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77032","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:39:41.000000Z","updated_at":"2025-03-17T19:39:41.000000Z","inspection_violations":[{"id":6001505,"change_date":"2023-09-01 21:40:00","inspection_id":"79562868","insp_violation_id":"255055508","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6243271,"change_date":"2023-09-01 21:40:00","inspection_id":"79562868","insp_unit_id":"196872409","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:27.000000Z","updated_at":"2025-03-17T22:52:27.000000Z"}]},{"id":3569138,"change_date":"2023-07-21 21:41:00","inspection_id":"79211746","dot_number":"1940100","report_state":"TX","report_number":"6MWC9DKYN1","insp_date":"2023-07-19 00:00:00","insp_start_time":"1250","insp_end_time":"1313","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1764 IN GALVESTON CO. (698-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9033914","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-07-21 21:41:00","snet_input_date":"2023-07-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:33:32.000000Z","updated_at":"2025-03-17T19:33:32.000000Z","inspection_violations":[{"id":5503200,"change_date":"2023-07-21 21:41:00","inspection_id":"79211746","insp_violation_id":"254212602","seq_no":"1","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"196135664","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39347B"}],"inspection_per_units":[{"id":5738864,"change_date":"2023-07-21 21:41:00","inspection_id":"79211746","insp_unit_id":"196135664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8","insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"}]},{"id":3346046,"change_date":"2023-06-22 21:42:00","inspection_id":"78961199","dot_number":"1940100","report_state":"TX","report_number":"6M379DJVCR","insp_date":"2023-06-20 00:00:00","insp_start_time":"0715","insp_end_time":"0749","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9011448","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5379265,"change_date":"2023-06-22 21:42:00","inspection_id":"78961199","insp_unit_id":"195633459","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"Y","insp_unit_decal_number":"32615064","created_at":"2025-03-17T22:45:25.000000Z","updated_at":"2025-03-17T22:45:25.000000Z"}]},{"id":3336763,"change_date":"2023-06-21 21:43:00","inspection_id":"78950748","dot_number":"1940100","report_state":"TX","report_number":"6M069DBZLO","insp_date":"2023-06-17 00:00:00","insp_start_time":"0628","insp_end_time":"0644","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-06-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9010522","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-06-21 21:43:00","snet_input_date":"2023-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-21 21:43:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:28:57.000000Z","updated_at":"2025-03-17T19:28:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5364733,"change_date":"2023-06-21 21:43:00","inspection_id":"78950748","insp_unit_id":"195611999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":3286057,"change_date":"2023-06-14 21:42:00","inspection_id":"78893609","dot_number":"1940100","report_state":"TX","report_number":"6LS79DBTNK","insp_date":"2023-06-09 00:00:00","insp_start_time":"0736","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":"23184096705","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58770","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9004905","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-06-14 21:42:00","snet_input_date":"2023-06-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-14 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:28:08.000000Z","updated_at":"2025-03-17T19:28:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5283564,"change_date":"2023-06-14 21:42:00","inspection_id":"78893609","insp_unit_id":"195501134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"LCP5187","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X9KM611330","insp_unit_decal":"Y","insp_unit_decal_number":"32615016","created_at":"2025-03-17T22:44:38.000000Z","updated_at":"2025-03-17T22:44:38.000000Z"}]},{"id":2678823,"change_date":"2023-03-28 21:41:00","inspection_id":"78205613","dot_number":"1940100","report_state":"TX","report_number":"6JO79DBZHX","insp_date":"2023-03-25 00:00:00","insp_start_time":"0731","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE & WATER","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-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8939770","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-03-28 21:41:00","snet_input_date":"2023-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-28 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:15:55.000000Z","updated_at":"2025-03-17T19:15:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4313392,"change_date":"2023-03-28 21:41:00","inspection_id":"78205613","insp_unit_id":"194105447","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:58.000000Z","updated_at":"2025-03-17T22:36:58.000000Z"}]},{"id":2597496,"change_date":"2023-03-16 21:43:00","inspection_id":"78113998","dot_number":"1940100","report_state":"TX","report_number":"6JCF9DCN3A","insp_date":"2023-03-13 00:00:00","insp_start_time":"1547","insp_end_time":"1607","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  NORTH SERVICE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-03-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8930994","transaction_code":"A","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:14:31.000000Z","updated_at":"2025-03-17T19:14:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4181010,"change_date":"2023-03-16 21:43:00","inspection_id":"78113998","insp_unit_id":"193920588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"}]},{"id":2160663,"change_date":"2023-01-17 21:42:00","inspection_id":"77616330","dot_number":"1940100","report_state":"TX","report_number":"6HOA9DJVW5","insp_date":"2023-01-12 00:00:00","insp_start_time":"0957","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7000  DAYCO 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":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8879339","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:06:34.000000Z","updated_at":"2025-03-17T19:06:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3477441,"change_date":"2023-01-17 21:42:00","inspection_id":"77616330","insp_unit_id":"192912016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"}]},{"id":1949829,"change_date":"2022-12-14 21:40:00","inspection_id":"77374878","dot_number":"1940100","report_state":"TX","report_number":"6GM99DCRAO","insp_date":"2022-12-05 00:00:00","insp_start_time":"0909","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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":"2022-12-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8850896","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-12-14 21:40:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-14 21:40:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:02:34.000000Z","updated_at":"2025-03-17T19:02:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3137468,"change_date":"2022-12-14 21:40:00","inspection_id":"77374878","insp_unit_id":"192433058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"13","insp_unit_license":"MXK8534","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM700443","insp_unit_decal":"Y","insp_unit_decal_number":"31925720","created_at":"2025-03-17T22:28:29.000000Z","updated_at":"2025-03-17T22:28:29.000000Z"}]},{"id":1863100,"change_date":"2022-12-02 21:41:00","inspection_id":"77275483","dot_number":"1940100","report_state":"TX","report_number":"6G279DBTAU","insp_date":"2022-11-15 00:00:00","insp_start_time":"0717","insp_end_time":"0731","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","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-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8840742","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":"01940100","upload_search_indicator":"M","census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2998387,"change_date":"2022-12-02 21:41:00","inspection_id":"77275483","insp_unit_id":"192239809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"LCP5187","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X9KM611330","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":1690293,"change_date":"2022-11-07 21:41:00","inspection_id":"77077430","dot_number":"1940100","report_state":"TX","report_number":"6FO69DCCE4","insp_date":"2022-11-01 00:00:00","insp_start_time":"0656","insp_end_time":"0715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15216  LEE 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-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8819953","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-11-07 21:41:00","snet_input_date":"2022-11-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-07 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:57:46.000000Z","updated_at":"2025-03-17T18:57:46.000000Z","inspection_violations":[{"id":2650740,"change_date":"2022-11-07 21:41:00","inspection_id":"77077430","insp_violation_id":"249478295","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"191846203","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":2719601,"change_date":"2022-11-07 21:41:00","inspection_id":"77077430","insp_unit_id":"191846203","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8","insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:37.000000Z","updated_at":"2025-03-17T22:25:37.000000Z"}]},{"id":1649675,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","dot_number":"1940100","report_state":"TX","report_number":"6FL99DCNTZ","insp_date":"2022-10-29 00:00:00","insp_start_time":"0908","insp_end_time":"0929","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4500  NORTH SER E RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":"312159100","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-11-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"8816333","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-11-01 21:41:00","snet_input_date":"2022-10-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-01 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2589529,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","insp_violation_id":"249377372","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191755106","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"3939A"},{"id":2589530,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","insp_violation_id":"249377373","seq_no":"2","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"191755106","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"39328"},{"id":2589531,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","insp_violation_id":"249377374","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191755106","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"39617C"},{"id":2589532,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","insp_violation_id":"249377375","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191755106","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:12.000000Z","updated_at":"2025-03-17T21:19:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2654614,"change_date":"2022-11-01 21:41:00","inspection_id":"77030882","insp_unit_id":"191755106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1641729,"change_date":"2022-10-31 21:42:00","inspection_id":"77021692","dot_number":"1940100","report_state":"TX","report_number":"6FKC0XSK8X","insp_date":"2022-10-28 00:00:00","insp_start_time":"1245","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"SH 288 NB ANGLETON","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"XX","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-10-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8815500","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-10-31 21:42:00","snet_input_date":"2022-10-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-31 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:57:01.000000Z","updated_at":"2025-03-17T18:57:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2641472,"change_date":"2022-10-31 21:42:00","inspection_id":"77021692","insp_unit_id":"191735639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:07.000000Z","updated_at":"2025-03-17T22:25:07.000000Z"}]},{"id":1307867,"change_date":"2022-09-23 21:38:00","inspection_id":"76635849","dot_number":"1940100","report_state":"TX","report_number":"6EDG9DCK26","insp_date":"2022-09-15 00:00:00","insp_start_time":"1640","insp_end_time":"1710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":"UNK","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-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8774845","transaction_code":"C","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[{"id":2071396,"change_date":"2022-09-23 21:38:00","inspection_id":"76635849","insp_violation_id":"248619969","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191074393","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"}],"inspection_per_units":[{"id":2105434,"change_date":"2022-09-23 21:38:00","inspection_id":"76635849","insp_unit_id":"191074393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"MHL0753","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X5LM664589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":1338807,"change_date":"2022-09-21 21:39:00","inspection_id":"76671707","dot_number":"1940100","report_state":"TX","report_number":"6DXF9DBZ5K","insp_date":"2022-08-30 00:00:00","insp_start_time":"1546","insp_end_time":"1602","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","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-09-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8777960","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-09-21 21:39:00","snet_input_date":"2022-08-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-21 21:39:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:51:17.000000Z","updated_at":"2025-03-17T18:51:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2155778,"change_date":"2022-09-21 21:39:00","inspection_id":"76671707","insp_unit_id":"191029552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"PMJ6243","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9XXXD491315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:46.000000Z","updated_at":"2025-03-17T22:21:46.000000Z"}]},{"id":1207831,"change_date":"2022-09-02 21:39:00","inspection_id":"76519712","dot_number":"1940100","report_state":"TX","report_number":"6DRA9DGPBL","insp_date":"2022-08-24 00:00:00","insp_start_time":"1020","insp_end_time":"1048","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4200 N SHEPHERD DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE & WATER","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-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8761736","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1942570,"change_date":"2022-09-02 21:39:00","inspection_id":"76519712","insp_unit_id":"190713965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"14","insp_unit_license":"MXK8533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X7LM700444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":1416211,"change_date":"2022-09-30 21:40:00","inspection_id":"76761632","dot_number":"1940100","report_state":"TX","report_number":"6DRH9DJN67","insp_date":"2022-08-24 00:00:00","insp_start_time":"1751","insp_end_time":"1814","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4900  NAVIGATION BLV","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-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8786100","transaction_code":"A","transaction_date":"2022-09-30 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-09-30 21:40:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-30 21:40:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:52:44.000000Z","updated_at":"2025-03-17T18:52:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2279856,"change_date":"2022-09-30 21:40:00","inspection_id":"76761632","insp_unit_id":"191211333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8","insp_unit_license":"JDT5479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPGLU9X04D836704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:35.000000Z","updated_at":"2025-03-17T22:22:35.000000Z"}]},{"id":1207826,"change_date":"2022-09-02 21:39:00","inspection_id":"76519707","dot_number":"1940100","report_state":"TX","report_number":"6DK99DBT4Z","insp_date":"2022-08-17 00:00:00","insp_start_time":"0923","insp_end_time":"0944","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8761629","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1915755,"change_date":"2022-09-02 21:39:00","inspection_id":"76519707","insp_violation_id":"248204023","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"190713948","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39330"},{"id":1915756,"change_date":"2022-09-02 21:39:00","inspection_id":"76519707","insp_violation_id":"248204024","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190713948","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1942563,"change_date":"2022-09-02 21:39:00","inspection_id":"76519707","insp_unit_id":"190713948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L38214","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHD79XXCD155764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1942564,"change_date":"2022-09-02 21:39:00","inspection_id":"76519707","insp_unit_id":"190713949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"124B212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2480XU980216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":1103406,"change_date":"2022-08-22 21:43:00","inspection_id":"76398386","dot_number":"1940100","report_state":"TX","report_number":"6DID0ZGM3X","insp_date":"2022-08-15 00:00:00","insp_start_time":"1318","insp_end_time":"1352","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"SH 288 NB ANGLETON","county_code_state":"TX","county_code":"039","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":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8748765","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:47:12.000000Z","updated_at":"2025-03-17T18:47:12.000000Z","inspection_violations":[{"id":1738683,"change_date":"2022-08-22 21:43:00","inspection_id":"76398386","insp_violation_id":"247901355","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"190468881","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:04.000000Z","updated_at":"2025-03-17T21:15:04.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":1775091,"change_date":"2022-08-22 21:43:00","inspection_id":"76398386","insp_unit_id":"190468881","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"}]},{"id":831197,"change_date":"2022-08-24 21:40:00","inspection_id":"76080055","dot_number":"1940100","report_state":"TX","report_number":"6CJ99DKYEX","insp_date":"2022-07-11 00:00:00","insp_start_time":"0954","insp_end_time":"1020","registration_date":"2022-08-24 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"3015  AVE R E\/B","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8714515","transaction_code":"C","transaction_date":"2022-07-15 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-07-15 21:40:00","snet_input_date":"2022-07-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:42:18.000000Z","updated_at":"2025-03-17T18:42:18.000000Z","inspection_violations":[{"id":1311256,"change_date":"2022-08-24 21:40:00","inspection_id":"76080055","insp_violation_id":"247974244","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190525170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"3922"},{"id":1311257,"change_date":"2022-08-24 21:40:00","inspection_id":"76080055","insp_violation_id":"247974245","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190525170","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1337370,"change_date":"2022-08-24 21:40:00","inspection_id":"76080055","insp_unit_id":"190525170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"12","insp_unit_license":"MHR4096","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X2LM664601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:24.000000Z","updated_at":"2025-03-17T22:16:24.000000Z"}]},{"id":702803,"change_date":"2022-06-27 21:41:00","inspection_id":"75929984","dot_number":"1940100","report_state":"TX","report_number":"6C199DCC65","insp_date":"2022-06-23 00:00:00","insp_start_time":"0958","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8696277","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-06-27 21:41:00","snet_input_date":"2022-06-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[{"id":1104951,"change_date":"2022-06-27 21:41:00","inspection_id":"75929984","insp_violation_id":"246746402","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189486094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39345D"},{"id":1104952,"change_date":"2022-06-27 21:41:00","inspection_id":"75929984","insp_violation_id":"246746403","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189486094","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"3963A1"},{"id":1104953,"change_date":"2022-06-27 21:41:00","inspection_id":"75929984","insp_violation_id":"246746404","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"189486094","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":1129842,"change_date":"2022-06-27 21:41:00","inspection_id":"75929984","insp_unit_id":"189486094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"15","insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:08.000000Z","updated_at":"2025-03-17T22:15:08.000000Z"}]},{"id":740989,"change_date":"2022-07-01 21:38:00","inspection_id":"75974813","dot_number":"1940100","report_state":"TX","report_number":"6C0B9DBALB","insp_date":"2022-06-22 00:00:00","insp_start_time":"1152","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14499  BEAUMONT HWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE INC","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":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8700862","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:40:51.000000Z","updated_at":"2025-03-17T18:40:51.000000Z","inspection_violations":[{"id":1167677,"change_date":"2022-07-01 21:38:00","inspection_id":"75974813","insp_violation_id":"246864578","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"189580510","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":1190808,"change_date":"2022-07-01 21:38:00","inspection_id":"75974813","insp_unit_id":"189580510","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"KZF3444","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVACWDC96HW67974","insp_unit_decal":"Y","insp_unit_decal_number":"31246549","created_at":"2025-03-17T22:15:30.000000Z","updated_at":"2025-03-17T22:15:30.000000Z"}]},{"id":752495,"change_date":"2022-07-05 21:42:00","inspection_id":"75988353","dot_number":"1940100","report_state":"TX","report_number":"6AZ59DJWQ1","insp_date":"2022-05-16 00:00:00","insp_start_time":"0531","insp_end_time":"0548","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4700  NORTH FWY","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":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8701550","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-05-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:40:54.000000Z","updated_at":"2025-03-17T18:40:54.000000Z","inspection_violations":[{"id":1185963,"change_date":"2022-07-05 21:42:00","inspection_id":"75988353","insp_violation_id":"246897006","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1210349,"change_date":"2022-07-05 21:42:00","inspection_id":"75988353","insp_unit_id":"189610063","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1L33570","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAMR3WC061918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"},{"id":1210350,"change_date":"2022-07-05 21:42:00","inspection_id":"75988353","insp_unit_id":"189610064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"P5078319","insp_unit_license":"7409JX","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532W37L028319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"}]},{"id":351789,"change_date":"2022-05-09 21:42:00","inspection_id":"75512687","dot_number":"1940100","report_state":"TX","report_number":"6AOE9DCNFF","insp_date":"2022-05-05 00:00:00","insp_start_time":"1412","insp_end_time":"1439","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COASTAL ICE","shipping_paper_number":"3121311033","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-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8649267","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-05-09 21:42:00","snet_input_date":"2022-05-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-09 21:42:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:33:40.000000Z","updated_at":"2025-03-17T18:33:40.000000Z","inspection_violations":[{"id":553343,"change_date":"2022-05-09 21:42:00","inspection_id":"75512687","insp_violation_id":"245683549","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188589654","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:38.000000Z","updated_at":"2025-03-17T21:09:38.000000Z","normalized_code":"39617C"},{"id":553344,"change_date":"2022-05-09 21:42:00","inspection_id":"75512687","insp_violation_id":"245683550","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188589654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:38.000000Z","updated_at":"2025-03-17T21:09:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":569103,"change_date":"2022-05-09 21:42:00","inspection_id":"75512687","insp_unit_id":"188589654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"LNZ7680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0KM615394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:41.000000Z","updated_at":"2025-03-17T22:11:41.000000Z"}]},{"id":85244,"change_date":"2022-03-31 21:41:00","inspection_id":"75192422","dot_number":"1940100","report_state":"TX","report_number":"69HD0XLILJ","insp_date":"2022-03-23 00:00:00","insp_start_time":"1317","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"SH 288 NB ANGLETON","county_code_state":"TX","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COASTAL ICE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8606873","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01940100","upload_search_indicator":"M","census_search_date":"2022-03-31 21:41:00","snet_input_date":"2022-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"COASTAL ICE & WATER LLC","insp_carrier_street":"6004 N SHEPHERD DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77091","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0200587","created_at":"2025-03-17T18:29:07.000000Z","updated_at":"2025-03-17T18:29:07.000000Z","inspection_violations":[{"id":126486,"change_date":"2022-03-31 21:41:00","inspection_id":"75192422","insp_violation_id":"244902212","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"187931214","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":138346,"change_date":"2022-03-31 21:41:00","inspection_id":"75192422","insp_unit_id":"187931214","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BT-15","insp_unit_license":"PXD5212","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X0GM318732","insp_unit_decal":"Y","insp_unit_decal_number":"30879236","created_at":"2025-03-17T22:09:04.000000Z","updated_at":"2025-03-17T22:09:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1940100\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1940100\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1940100\/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\/1940100\/inspections","per_page":100,"prev_page_url":null,"to":71,"total":71}