{"current_page":1,"data":[{"id":10774681,"change_date":"2026-02-18 21:38:00","inspection_id":"86800095","dot_number":"2462107","report_state":"NY","report_number":"D110601585","insp_date":"2026-01-12 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":"2026-02-17 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"NEW YORK NY","county_code_state":"NY","county_code":"061","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2768662","transaction_code":"C","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2026-01-15 21:40:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:44:25.000000Z","updated_at":"2026-03-01T10:30:12.000000Z","inspection_violations":[{"id":18701231,"change_date":"2026-02-18 21:38:00","inspection_id":"86800095","insp_violation_id":"271867327","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"211682083","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:25.000000Z","updated_at":"2026-03-01T10:39:31.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18701232,"change_date":"2026-02-18 21:38:00","inspection_id":"86800095","insp_violation_id":"271867328","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"211682083","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:25.000000Z","updated_at":"2026-03-01T10:39:31.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":18701230,"change_date":"2026-02-18 21:38:00","inspection_id":"86800095","insp_violation_id":"271867326","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211682083","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:25.000000Z","updated_at":"2026-03-01T10:39:31.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19050023,"change_date":"2026-02-18 21:38:00","inspection_id":"86800095","insp_unit_id":"211682083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"19345NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:06.000000Z","updated_at":"2026-03-01T10:02:47.000000Z"}]},{"id":10458107,"change_date":"2025-12-17 21:39:00","inspection_id":"86590954","dot_number":"2462107","report_state":"NJ","report_number":"SPRJI02070","insp_date":"2025-12-16 00:00:00","insp_start_time":"1124","insp_end_time":"1134","registration_date":null,"region":"ET","ci_status_code":"C","location":"0212","location_desc":"NJTP 16W","county_code_state":"NJ","county_code":"003","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2025-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1329477","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2025-12-17 21:39:00","snet_input_date":"2025-12-16 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:42.000000Z","updated_at":"2025-12-28T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17502217,"change_date":"2025-12-17 21:39:00","inspection_id":"86590954","insp_unit_id":"210662276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"19345NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:46.000000Z","updated_at":"2025-12-28T10:00:47.000000Z"}]},{"id":9113144,"change_date":"2025-07-10 21:39:00","inspection_id":"85177918","dot_number":"2462107","report_state":"NJ","report_number":"SPSJI00450","insp_date":"2025-07-09 00:00:00","insp_start_time":"1145","insp_end_time":"1224","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1300983","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:49.000000Z","updated_at":"2025-07-14T10:46:49.000000Z","inspection_violations":[{"id":14689069,"change_date":"2025-07-10 21:39:00","inspection_id":"85177918","insp_violation_id":"267324458","seq_no":"1","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"207801022","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:41.000000Z","updated_at":"2025-07-14T10:48:03.000000Z","normalized_code":"393201BFR"},{"id":14689070,"change_date":"2025-07-10 21:39:00","inspection_id":"85177918","insp_violation_id":"267324459","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"207801022","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1352E25005983","created_at":"2025-07-13T10:49:41.000000Z","updated_at":"2025-07-14T10:48:03.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":14960898,"change_date":"2025-07-10 21:39:00","inspection_id":"85177918","insp_unit_id":"207801022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:56.000000Z","updated_at":"2025-07-14T09:45:36.000000Z"}]},{"id":8089752,"change_date":"2025-03-12 21:39:00","inspection_id":"84098156","dot_number":"2462107","report_state":"CT","report_number":"3070006802","insp_date":"2025-03-12 00:00:00","insp_start_time":"0645","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CERA TILES","shipping_paper_number":"152218","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734563","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2025-03-12 21:39:00","snet_input_date":"2025-03-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-12 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:17.000000Z","updated_at":"2025-03-17T21:06:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13061472,"change_date":"2025-03-12 21:39:00","inspection_id":"84098156","insp_unit_id":"205746948","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"}]},{"id":7918605,"change_date":"2025-02-20 21:40:00","inspection_id":"83918384","dot_number":"2462107","report_state":"NJ","report_number":"PABTI00240","insp_date":"2025-02-19 00:00:00","insp_start_time":"1007","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"440 NORTH BOUND OUTTER BRIDGE","county_code_state":"NJ","county_code":"023","insp_level_id":"1","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2025-02-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1267088","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2025-02-20 21:40:00","snet_input_date":"2025-02-19 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:25.000000Z","updated_at":"2025-03-17T21:02:25.000000Z","inspection_violations":[{"id":12372473,"change_date":"2025-02-20 21:40:00","inspection_id":"83918384","insp_violation_id":"264612294","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205417969","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"39347E"},{"id":12372474,"change_date":"2025-02-20 21:40:00","inspection_id":"83918384","insp_violation_id":"264612295","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"205417969","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"3963A1BOS"},{"id":12372475,"change_date":"2025-02-20 21:40:00","inspection_id":"83918384","insp_violation_id":"264612296","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"205417969","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":12782144,"change_date":"2025-02-20 21:40:00","inspection_id":"83918384","insp_unit_id":"205417969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:13.000000Z","updated_at":"2025-03-17T23:56:13.000000Z"}]},{"id":7799081,"change_date":"2025-02-06 21:40:00","inspection_id":"83792919","dot_number":"2462107","report_state":"NY","report_number":"SPT3110438","insp_date":"2025-01-30 00:00:00","insp_start_time":"0945","insp_end_time":"1000","registration_date":null,"region":"ES","ci_status_code":"C","location":"80698R","location_desc":"SUFFERN NY","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1328965","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:58.000000Z","updated_at":"2025-03-17T20:59:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12586211,"change_date":"2025-02-06 21:40:00","inspection_id":"83792919","insp_unit_id":"205182530","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:03.000000Z","updated_at":"2025-03-17T23:54:03.000000Z"}]},{"id":6617245,"change_date":"2024-08-31 21:33:00","inspection_id":"82543545","dot_number":"2462107","report_state":"NY","report_number":"M606000066","insp_date":"2024-08-28 00:00:00","insp_start_time":"1400","insp_end_time":"1439","registration_date":null,"region":"ED","ci_status_code":"C","location":"80865M","location_desc":"WALLKILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"2481","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-31 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"802076","transaction_code":"A","transaction_date":"2024-08-31 00:00:00","upload_date":"2024-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2024-08-31 21:33:00","snet_input_date":"2024-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-31 21:33:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:06.000000Z","updated_at":"2025-03-17T20:34:06.000000Z","inspection_violations":[{"id":10289949,"change_date":"2024-08-31 21:33:00","inspection_id":"82543545","insp_violation_id":"261539013","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202696998","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39378A"}],"inspection_per_units":[{"id":10668629,"change_date":"2024-08-31 21:33:00","inspection_id":"82543545","insp_unit_id":"202696998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:28.000000Z","updated_at":"2025-03-17T23:33:28.000000Z"}]},{"id":6522396,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","dot_number":"2462107","report_state":"NY","report_number":"N118030244","insp_date":"2024-08-19 00:00:00","insp_start_time":"1712","insp_end_time":"1902","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BROOKLYN NY","county_code_state":"NY","county_code":"047","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-21 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"33000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"767148","transaction_code":"C","transaction_date":"2024-08-21 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2024-08-21 21:42:00","snet_input_date":"2024-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:42:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:19.000000Z","updated_at":"2025-11-26T10:30:29.000000Z","inspection_violations":[{"id":17103341,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186244","seq_no":"1","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648293","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"39345B2B"},{"id":17103342,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186245","seq_no":"2","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648301","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"39345B2B"},{"id":17103343,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186246","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648315","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"39347E"},{"id":17103344,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186247","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648329","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"39347E"},{"id":17103345,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186248","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648363","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"3965BL"},{"id":17103346,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186249","seq_no":"6","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648346","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"3939ALCL"},{"id":17103347,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186250","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4458648332","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"39353BB"},{"id":17103348,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_violation_id":"270186251","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"210198862","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4458648350","created_at":"2025-11-25T10:32:23.000000Z","updated_at":"2025-11-26T10:32:41.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":17119179,"change_date":"2025-11-22 21:48:00","inspection_id":"82442516","insp_unit_id":"210198862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"001","insp_unit_license":"48579MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT9H4S54356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:21.000000Z","updated_at":"2025-11-26T10:00:35.000000Z"}]},{"id":5631339,"change_date":"2024-04-30 21:41:00","inspection_id":"81482198","dot_number":"2462107","report_state":"NY","report_number":"SPWF061507","insp_date":"2024-04-29 00:00:00","insp_start_time":"1356","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"80333A","location_desc":"GOSHEN","county_code_state":"NY","county_code":"071","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2920590","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:18.000000Z","updated_at":"2025-03-17T20:14:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9070781,"change_date":"2024-04-30 21:41:00","inspection_id":"81482198","insp_unit_id":"200646535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"001","insp_unit_license":"48579MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT9H4S54356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"}]},{"id":5619910,"change_date":"2024-04-29 21:43:00","inspection_id":"81469743","dot_number":"2462107","report_state":"NY","report_number":"SPC0217431","insp_date":"2024-04-25 00:00:00","insp_start_time":"1117","insp_end_time":"1132","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CERA","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-04-29 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":"2920419","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9052551,"change_date":"2024-04-29 21:43:00","inspection_id":"81469743","insp_unit_id":"200622462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":5585145,"change_date":"2024-04-24 21:41:00","inspection_id":"81431742","dot_number":"2462107","report_state":"NY","report_number":"SPT0385970","insp_date":"2024-04-23 00:00:00","insp_start_time":"1231","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2919015","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8996268,"change_date":"2024-04-24 21:41:00","inspection_id":"81431742","insp_unit_id":"200548179","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":5423870,"change_date":"2024-04-03 21:41:00","inspection_id":"81255749","dot_number":"2462107","report_state":"NY","report_number":"SPT0550432","insp_date":"2024-04-01 00:00:00","insp_start_time":"1024","insp_end_time":"1039","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698B","location_desc":"SPRING VALLEY TANDEM NORTH LOT","county_code_state":"NY","county_code":"087","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2914663","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-04-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:15.000000Z","updated_at":"2025-03-17T20:10:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8736306,"change_date":"2024-04-03 21:41:00","inspection_id":"81255749","insp_unit_id":"200212644","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:16.000000Z","updated_at":"2025-03-17T23:14:16.000000Z"}]},{"id":5169003,"change_date":"2024-02-29 21:46:00","inspection_id":"80977395","dot_number":"2462107","report_state":"CT","report_number":"3082001053","insp_date":"2024-02-29 00:00:00","insp_start_time":"0724","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"144888","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-02-29 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"700946","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2024-02-29 21:46:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-29 21:46:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:58.000000Z","updated_at":"2025-03-17T20:04:58.000000Z","inspection_violations":[{"id":7965905,"change_date":"2024-02-29 21:46:00","inspection_id":"80977395","insp_violation_id":"258107063","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199667961","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:30.000000Z","updated_at":"2025-03-17T21:44:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8322158,"change_date":"2024-02-29 21:46:00","inspection_id":"80977395","insp_unit_id":"199667961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:25.000000Z","updated_at":"2025-03-17T23:10:25.000000Z"}]},{"id":5049543,"change_date":"2024-02-14 21:41:00","inspection_id":"80847501","dot_number":"2462107","report_state":"NJ","report_number":"SPRCI01500","insp_date":"2024-02-09 00:00:00","insp_start_time":"1156","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":"1217","location_desc":"PISCATAWAY SCALE","county_code_state":"NJ","county_code":"023","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1193504","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2024-02-14 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-02-14 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:45.000000Z","updated_at":"2025-03-17T20:02:45.000000Z","inspection_violations":[{"id":7782151,"change_date":"2024-02-14 21:41:00","inspection_id":"80847501","insp_violation_id":"257833476","seq_no":"1","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"199418924","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":8128021,"change_date":"2024-02-14 21:41:00","inspection_id":"80847501","insp_unit_id":"199418924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:38.000000Z","updated_at":"2025-03-17T23:08:38.000000Z"}]},{"id":4834729,"change_date":"2024-01-16 21:44:00","inspection_id":"80612573","dot_number":"2462107","report_state":"NJ","report_number":"SPEOI01005","insp_date":"2024-01-15 00:00:00","insp_start_time":"1036","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE CVI","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1189161","transaction_code":"A","transaction_date":"2024-01-15 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-15 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[{"id":7454876,"change_date":"2024-01-16 21:44:00","inspection_id":"80612573","insp_violation_id":"257343685","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198963917","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39617C"},{"id":7454877,"change_date":"2024-01-16 21:44:00","inspection_id":"80612573","insp_violation_id":"257343686","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198963917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7778557,"change_date":"2024-01-16 21:44:00","inspection_id":"80612573","insp_unit_id":"198963917","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:30.000000Z","updated_at":"2025-03-17T23:05:30.000000Z"}]},{"id":4732735,"change_date":"2023-12-29 21:40:00","inspection_id":"80501019","dot_number":"2462107","report_state":"NJ","report_number":"SPELI01469","insp_date":"2023-12-28 00:00:00","insp_start_time":"0858","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1185742","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-28 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:33.000000Z","updated_at":"2025-03-17T19:56:33.000000Z","inspection_violations":[{"id":7307736,"change_date":"2023-12-29 21:40:00","inspection_id":"80501019","insp_violation_id":"257116089","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198738031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"3939A"},{"id":7307737,"change_date":"2023-12-29 21:40:00","inspection_id":"80501019","insp_violation_id":"257116090","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198738031","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39617C"},{"id":7307738,"change_date":"2023-12-29 21:40:00","inspection_id":"80501019","insp_violation_id":"257116091","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198738031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7612810,"change_date":"2023-12-29 21:40:00","inspection_id":"80501019","insp_unit_id":"198738031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:03.000000Z","updated_at":"2025-03-17T23:04:03.000000Z"}]},{"id":4524625,"change_date":"2023-11-30 21:38:00","inspection_id":"80272931","dot_number":"2462107","report_state":"CT","report_number":"1241000002","insp_date":"2023-11-30 00:00:00","insp_start_time":"0910","insp_end_time":"1018","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CERTILE","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"693111","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:33.000000Z","updated_at":"2025-03-17T19:52:33.000000Z","inspection_violations":[{"id":7001770,"change_date":"2023-11-30 21:38:00","inspection_id":"80272931","insp_violation_id":"256633505","seq_no":"1","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"1","insp_unit_id":"198277067","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"393201B"}],"inspection_per_units":[{"id":7276868,"change_date":"2023-11-30 21:38:00","inspection_id":"80272931","insp_unit_id":"198277067","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4460209,"change_date":"2023-11-20 21:40:00","inspection_id":"80202110","dot_number":"2462107","report_state":"NY","report_number":"SPF0260106","insp_date":"2023-11-09 00:00:00","insp_start_time":"1225","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"80865B","location_desc":"WALLKILL (WB)","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2888683","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-11-20 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:22.000000Z","updated_at":"2025-03-17T19:51:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7172802,"change_date":"2023-11-20 21:40:00","inspection_id":"80202110","insp_unit_id":"198137787","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:14.000000Z","updated_at":"2025-03-17T23:00:14.000000Z"}]},{"id":4398620,"change_date":"2023-11-10 21:33:00","inspection_id":"80134320","dot_number":"2462107","report_state":"NY","report_number":"SPG0195255","insp_date":"2023-11-08 00:00:00","insp_start_time":"1255","insp_end_time":"1311","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-11-10 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2885901","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-11-10 21:33:00","snet_input_date":"2023-11-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-10 21:33:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:55.000000Z","updated_at":"2025-03-17T19:49:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7073800,"change_date":"2023-11-10 21:33:00","inspection_id":"80134320","insp_unit_id":"198001100","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:22.000000Z","updated_at":"2025-03-17T22:59:22.000000Z"}]},{"id":4380375,"change_date":"2023-11-08 21:40:00","inspection_id":"80114177","dot_number":"2462107","report_state":"NJ","report_number":"SPELI01435","insp_date":"2023-11-06 00:00:00","insp_start_time":"0856","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1178121","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-11-08 21:40:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-11-08 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:49.000000Z","updated_at":"2025-03-17T19:49:49.000000Z","inspection_violations":[{"id":6776920,"change_date":"2023-11-08 21:40:00","inspection_id":"80114177","insp_violation_id":"256282048","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197961813","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:36.000000Z","updated_at":"2025-03-17T21:38:36.000000Z","normalized_code":"39311"},{"id":6776921,"change_date":"2023-11-08 21:40:00","inspection_id":"80114177","insp_violation_id":"256282049","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197961813","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:36.000000Z","updated_at":"2025-03-17T21:38:36.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7044791,"change_date":"2023-11-08 21:40:00","inspection_id":"80114177","insp_unit_id":"197961813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:07.000000Z","updated_at":"2025-03-17T22:59:07.000000Z"}]},{"id":4320933,"change_date":"2023-10-31 21:39:00","inspection_id":"80048294","dot_number":"2462107","report_state":"NJ","report_number":"SPEKI01925","insp_date":"2023-10-30 00:00:00","insp_start_time":"0937","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE-CVI","county_code_state":"NJ","county_code":"025","insp_level_id":"3","service_center":"EA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1177212","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-10-31 21:39:00","snet_input_date":"2023-10-30 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-10-31 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:41.000000Z","updated_at":"2025-03-17T19:48:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6949333,"change_date":"2023-10-31 21:39:00","inspection_id":"80048294","insp_unit_id":"197830362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"}]},{"id":4252677,"change_date":"2023-10-23 21:41:00","inspection_id":"79972648","dot_number":"2462107","report_state":"NY","report_number":"M602300006","insp_date":"2023-10-20 00:00:00","insp_start_time":"1054","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":"80865M","location_desc":"WALLKILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"1340739","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"73761","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:04.000000Z","updated_at":"2025-03-17T19:47:04.000000Z","inspection_violations":[{"id":6584821,"change_date":"2023-10-23 21:41:00","inspection_id":"79972648","insp_violation_id":"255976189","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"197679372","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39395A4EEUS"},{"id":6584822,"change_date":"2023-10-23 21:41:00","inspection_id":"79972648","insp_violation_id":"255976190","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"197679372","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":6839104,"change_date":"2023-10-23 21:41:00","inspection_id":"79972648","insp_unit_id":"197679372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"}]},{"id":3348987,"change_date":"2023-06-23 21:40:00","inspection_id":"78964400","dot_number":"2462107","report_state":"NJ","report_number":"SPPXI03298","insp_date":"2023-06-22 00:00:00","insp_start_time":"1119","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"1217","location_desc":"PISCATAWAY SCALE FACILITY","county_code_state":"NJ","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"136879","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1161774","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-06-23 21:40:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:21.000000Z","updated_at":"2025-03-17T19:29:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5383689,"change_date":"2023-06-23 21:40:00","inspection_id":"78964400","insp_unit_id":"195638773","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"92129MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"}]},{"id":3301593,"change_date":"2023-06-16 21:40:00","inspection_id":"78911118","dot_number":"2462107","report_state":"NY","report_number":"SPWL081166","insp_date":"2023-06-15 00:00:00","insp_start_time":"1440","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW TRUCK SITE","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2836917","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-06-16 21:40:00","snet_input_date":"2023-06-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:29.000000Z","updated_at":"2025-03-17T19:28:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5308064,"change_date":"2023-06-16 21:40:00","inspection_id":"78911118","insp_unit_id":"195534862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"48579MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT9H4S54356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:52.000000Z","updated_at":"2025-03-17T22:44:52.000000Z"}]},{"id":3372203,"change_date":"2023-06-27 21:40:00","inspection_id":"78990340","dot_number":"2462107","report_state":"NY","report_number":"SPG0214544","insp_date":"2023-06-14 00:00:00","insp_start_time":"1255","insp_end_time":"1312","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2841646","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:46.000000Z","updated_at":"2025-03-17T19:29:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5420787,"change_date":"2023-06-27 21:40:00","inspection_id":"78990340","insp_unit_id":"195689086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"}]},{"id":3318861,"change_date":"2023-06-20 21:40:00","inspection_id":"78930627","dot_number":"2462107","report_state":"NY","report_number":"SPG0194695","insp_date":"2023-06-13 00:00:00","insp_start_time":"0103","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2837293","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-06-20 21:40:00","snet_input_date":"2023-06-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-20 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:35.000000Z","updated_at":"2025-03-17T19:28:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5335178,"change_date":"2023-06-20 21:40:00","inspection_id":"78930627","insp_unit_id":"195571944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:06.000000Z","updated_at":"2025-03-17T22:45:06.000000Z"}]},{"id":3077068,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","dot_number":"2462107","report_state":"NY","report_number":"0817014152","insp_date":"2023-05-17 00:00:00","insp_start_time":"1255","insp_end_time":"1351","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057M","location_desc":"BEDFORD REST AREA (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-05-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2826548","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2023-05-18 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-18 21:42:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:49.000000Z","updated_at":"2025-03-17T19:23:49.000000Z","inspection_violations":[{"id":4729336,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911479","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39347E"},{"id":4729337,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911480","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39353B"},{"id":4729338,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911481","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3963A1"},{"id":4729339,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911482","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3963A1"},{"id":4729340,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911483","seq_no":"5","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"393207C"},{"id":4729341,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_violation_id":"252911484","seq_no":"6","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"195000614","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"393207C"}],"inspection_per_units":[{"id":4949592,"change_date":"2023-05-18 21:42:00","inspection_id":"78657505","insp_unit_id":"195000614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:01.000000Z","updated_at":"2025-03-17T22:42:01.000000Z"}]},{"id":3018765,"change_date":"2023-05-11 21:41:00","inspection_id":"78591762","dot_number":"2462107","report_state":"NJ","report_number":"SPEPI00743","insp_date":"2023-05-08 00:00:00","insp_start_time":"1022","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE CVI","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1155930","transaction_code":"A","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-05-11 21:41:00","snet_input_date":"2023-05-08 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-05-11 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:40.000000Z","updated_at":"2025-03-17T19:22:40.000000Z","inspection_violations":[{"id":4636812,"change_date":"2023-05-11 21:41:00","inspection_id":"78591762","insp_violation_id":"252762442","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194869496","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4856355,"change_date":"2023-05-11 21:41:00","inspection_id":"78591762","insp_unit_id":"194869496","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:17.000000Z","updated_at":"2025-03-17T22:41:17.000000Z"}]},{"id":2641442,"change_date":"2023-03-23 21:42:00","inspection_id":"78163430","dot_number":"2462107","report_state":"NJ","report_number":"SPPXI03093","insp_date":"2023-03-22 00:00:00","insp_start_time":"1237","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"1217","location_desc":"PISCATAWAY SCALE FACILITY","county_code_state":"NJ","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1148933","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-03-23 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-03-23 21:42:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:29.000000Z","updated_at":"2025-03-17T19:15:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4252239,"change_date":"2023-03-23 21:42:00","inspection_id":"78163430","insp_unit_id":"194018921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"}]},{"id":2420029,"change_date":"2023-02-22 21:40:00","inspection_id":"77911980","dot_number":"2462107","report_state":"NJ","report_number":"SPRMI00092","insp_date":"2023-02-21 00:00:00","insp_start_time":"1120","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"2018","location_desc":"SUMMIT\/SH 24 AREA","county_code_state":"NJ","county_code":"039","insp_level_id":"2","service_center":"EA","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":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1144517","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:23.000000Z","updated_at":"2025-03-17T19:11:23.000000Z","inspection_violations":[{"id":3727605,"change_date":"2023-02-22 21:40:00","inspection_id":"77911980","insp_violation_id":"251262258","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193511412","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3894826,"change_date":"2023-02-22 21:40:00","inspection_id":"77911980","insp_unit_id":"193511412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:53.000000Z","updated_at":"2025-03-17T22:33:53.000000Z"}]},{"id":2353003,"change_date":"2023-02-12 21:31:00","inspection_id":"77835246","dot_number":"2462107","report_state":"NY","report_number":"0L88000424","insp_date":"2023-02-09 00:00:00","insp_start_time":"1116","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"SOB EXPWY @EXIT13","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-12 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2797572","transaction_code":"A","transaction_date":"2023-02-11 00:00:00","upload_date":"2023-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2023-02-12 21:31:00","snet_input_date":"2023-02-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-12 21:31:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:59.000000Z","updated_at":"2025-03-17T19:09:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3786939,"change_date":"2023-02-12 21:31:00","inspection_id":"77835246","insp_unit_id":"193355823","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"}]},{"id":2331408,"change_date":"2023-02-09 21:39:00","inspection_id":"77810220","dot_number":"2462107","report_state":"NY","report_number":"SPT0482023","insp_date":"2023-02-08 00:00:00","insp_start_time":"1230","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2797369","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2023-02-09 21:39:00","snet_input_date":"2023-02-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[{"id":3591344,"change_date":"2023-02-09 21:39:00","inspection_id":"77810220","insp_violation_id":"251033612","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193307091","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39395A"},{"id":3591345,"change_date":"2023-02-09 21:39:00","inspection_id":"77810220","insp_violation_id":"251033613","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193307091","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3751758,"change_date":"2023-02-09 21:39:00","inspection_id":"77810220","insp_unit_id":"193307091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:52.000000Z","updated_at":"2025-03-17T22:32:52.000000Z"}]},{"id":2138152,"change_date":"2023-01-13 21:39:00","inspection_id":"77589943","dot_number":"2462107","report_state":"NY","report_number":"SPG0205551","insp_date":"2023-01-11 00:00:00","insp_start_time":"1310","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2788406","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2023-01-13 21:39:00","snet_input_date":"2023-01-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-13 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[{"id":3308736,"change_date":"2023-01-13 21:39:00","inspection_id":"77589943","insp_violation_id":"250561634","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"38323A2"},{"id":3308737,"change_date":"2023-01-13 21:39:00","inspection_id":"77589943","insp_violation_id":"250561635","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192860786","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:39.000000Z","updated_at":"2025-03-17T21:22:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3440678,"change_date":"2023-01-13 21:39:00","inspection_id":"77589943","insp_unit_id":"192860786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:40.000000Z","updated_at":"2025-03-17T22:30:40.000000Z"}]},{"id":1703031,"change_date":"2022-11-09 21:40:00","inspection_id":"77091818","dot_number":"2462107","report_state":"NY","report_number":"SPT0376390","insp_date":"2022-11-08 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2767109","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:10.000000Z","updated_at":"2025-03-17T18:58:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2739854,"change_date":"2022-11-09 21:40:00","inspection_id":"77091818","insp_unit_id":"191872709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":845684,"change_date":"2022-07-20 21:41:00","inspection_id":"76096857","dot_number":"2462107","report_state":"CT","report_number":"3070003560","insp_date":"2022-07-18 00:00:00","insp_start_time":"0715","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0","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-07-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"649038","transaction_code":"C","transaction_date":"2022-07-18 00:00:00","upload_date":"2022-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2022-07-19 21:39:00","snet_input_date":"2022-07-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-19 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:39.000000Z","updated_at":"2025-03-17T18:42:39.000000Z","inspection_violations":[{"id":1333077,"change_date":"2022-07-20 21:41:00","inspection_id":"76096857","insp_violation_id":"247195318","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189865310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:16.000000Z","updated_at":"2025-03-17T21:13:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1361303,"change_date":"2022-07-20 21:41:00","inspection_id":"76096857","insp_unit_id":"189865310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:33.000000Z","updated_at":"2025-03-17T22:16:33.000000Z"}]},{"id":635454,"change_date":"2022-06-17 21:39:00","inspection_id":"75850305","dot_number":"2462107","report_state":"NY","report_number":"MC24002884","insp_date":"2022-06-16 00:00:00","insp_start_time":"0822","insp_end_time":"0859","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057M","location_desc":"BEDFORD REST AREA (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CERA TILE 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":"N","pen_cen_match":"I","final_status_date":"2022-06-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2717478","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2022-06-17 21:39:00","snet_input_date":"2022-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-17 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:50.000000Z","updated_at":"2025-03-17T18:38:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1021322,"change_date":"2022-06-17 21:39:00","inspection_id":"75850305","insp_unit_id":"189314657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:28.000000Z","updated_at":"2025-03-17T22:14:28.000000Z"}]},{"id":744268,"change_date":"2022-07-05 21:41:00","inspection_id":"75978639","dot_number":"2462107","report_state":"NY","report_number":"SPL0134386","insp_date":"2022-06-14 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2724017","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":"02462107","upload_search_indicator":"M","census_search_date":"2022-07-05 21:41:00","snet_input_date":"2022-07-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[{"id":1172775,"change_date":"2022-07-05 21:41:00","inspection_id":"75978639","insp_violation_id":"246873736","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"189588672","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39355D1"},{"id":1172776,"change_date":"2022-07-05 21:41:00","inspection_id":"75978639","insp_violation_id":"246873737","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189588672","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"},{"id":1172777,"change_date":"2022-07-05 21:41:00","inspection_id":"75978639","insp_violation_id":"246873738","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189588672","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1196213,"change_date":"2022-07-05 21:41:00","inspection_id":"75978639","insp_unit_id":"189588672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":448979,"change_date":"2022-06-22 21:40:00","inspection_id":"75628297","dot_number":"2462107","report_state":"PA","report_number":"P118213925","insp_date":"2022-05-19 00:00:00","insp_start_time":"1130","insp_end_time":"1250","registration_date":"2022-06-22 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"I-81 N AT REST AREA MM 155","county_code_state":"PA","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CERA TILE","shipping_paper_number":"124626","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2257382","transaction_code":"C","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:37.000000Z","updated_at":"2025-03-17T18:35:37.000000Z","inspection_violations":[{"id":710048,"change_date":"2022-06-22 21:40:00","inspection_id":"75628297","insp_violation_id":"246655885","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T9687513-3","created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":723853,"change_date":"2022-06-22 21:40:00","inspection_id":"75628297","insp_unit_id":"189410197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:39.000000Z","updated_at":"2025-03-17T22:12:39.000000Z"}]},{"id":468961,"change_date":"2022-06-24 21:38:00","inspection_id":"75652229","dot_number":"2462107","report_state":"NJ","report_number":"SPQJI01713","insp_date":"2022-05-11 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MARLBORO","county_code_state":"NJ","county_code":"025","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1093967","transaction_code":"C","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":null,"census_search_date":"2022-05-24 21:43:00","snet_input_date":"2022-05-11 00:00:00","source_office":"1NJS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:57.000000Z","updated_at":"2025-03-17T18:35:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":754504,"change_date":"2022-06-24 21:38:00","inspection_id":"75652229","insp_unit_id":"189443282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"95129ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S169JSG01742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:49.000000Z","updated_at":"2025-03-17T22:12:49.000000Z"}]},{"id":306994,"change_date":"2022-05-03 21:39:00","inspection_id":"75459352","dot_number":"2462107","report_state":"NY","report_number":"SPG0204886","insp_date":"2022-04-28 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CERA","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-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2702296","transaction_code":"A","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02462107","upload_search_indicator":"M","census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"CERA TILE INC","insp_carrier_street":"53 SMITH ROAD","insp_carrier_city":"MIDDLETOWN","insp_carrier_state":"NY","insp_carrier_zip_code":"10941","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:56.000000Z","updated_at":"2025-03-17T18:32:56.000000Z","inspection_violations":[{"id":477651,"change_date":"2022-05-03 21:39:00","inspection_id":"75459352","insp_violation_id":"245529667","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188469615","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":477652,"change_date":"2022-05-03 21:39:00","inspection_id":"75459352","insp_violation_id":"245529668","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188469615","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3939A"},{"id":477653,"change_date":"2022-05-03 21:39:00","inspection_id":"75459352","insp_violation_id":"245529669","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188469615","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":496617,"change_date":"2022-05-03 21:39:00","inspection_id":"75459352","insp_unit_id":"188469615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"78104MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV1H4S57172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2462107\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2462107\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2462107\/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\/2462107\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}