{"current_page":1,"data":[{"id":8314222,"change_date":"2025-04-07 21:40:00","inspection_id":"84334595","dot_number":"3074698","report_state":"CA","report_number":"NE2W003392","insp_date":"2025-04-02 00:00:00","insp_start_time":"0705","insp_end_time":"0802","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE AREA","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"15769739","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":"522722","created_at":"2025-04-11T10:11:32.000000Z","updated_at":"2025-04-11T10:11:32.000000Z","inspection_violations":[{"id":13081629,"change_date":"2025-04-07 21:40:00","inspection_id":"84334595","insp_violation_id":"265485158","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206192741","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:30:10.000000Z","updated_at":"2025-04-11T10:36:44.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":13483021,"change_date":"2025-04-07 21:40:00","inspection_id":"84334595","insp_unit_id":"206192741","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"5652","insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:58:07.000000Z","updated_at":"2025-04-11T10:03:24.000000Z"}]},{"id":5127098,"change_date":"2024-02-23 21:42:00","inspection_id":"80932190","dot_number":"3074698","report_state":"CA","report_number":"NE2W002306","insp_date":"2024-02-14 00:00:00","insp_start_time":"1431","insp_end_time":"1505","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"15248943","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":"2024-02-23 21:42:00","snet_input_date":"2024-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-23 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":"522722","created_at":"2025-03-17T20:04:12.000000Z","updated_at":"2025-03-17T20:04:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8254534,"change_date":"2024-02-23 21:42:00","inspection_id":"80932190","insp_unit_id":"199582762","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"5660","insp_unit_license":"97194S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXU83F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:47.000000Z","updated_at":"2025-03-17T23:09:47.000000Z"}]},{"id":4888871,"change_date":"2024-01-23 21:45:00","inspection_id":"80671687","dot_number":"3074698","report_state":"CA","report_number":"UDLF003171","insp_date":"2024-01-23 00:00:00","insp_start_time":"1023","insp_end_time":"1040","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"15211356","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:37.000000Z","updated_at":"2025-03-17T19:59:37.000000Z","inspection_violations":[{"id":7533172,"change_date":"2024-01-23 21:45:00","inspection_id":"80671687","insp_violation_id":"257463914","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199079927","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"39345B2"},{"id":7533173,"change_date":"2024-01-23 21:45:00","inspection_id":"80671687","insp_violation_id":"257463915","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199079927","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7866329,"change_date":"2024-01-23 21:45:00","inspection_id":"80671687","insp_unit_id":"199079927","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"18236W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2CC19B0A2046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:19.000000Z","updated_at":"2025-03-17T23:06:19.000000Z"}]},{"id":4086389,"change_date":"2023-09-28 21:42:00","inspection_id":"79788919","dot_number":"3074698","report_state":"CA","report_number":"UEV6003042","insp_date":"2023-09-27 00:00:00","insp_start_time":"1010","insp_end_time":"1034","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"CACHE CREEK CASINO\/SR16","county_code_state":"CA","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-09-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"15078841","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-28 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:43:37.000000Z","updated_at":"2025-03-17T19:43:37.000000Z","inspection_violations":[{"id":6325899,"change_date":"2023-09-28 21:42:00","inspection_id":"79788919","insp_violation_id":"255560993","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197307543","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6570116,"change_date":"2023-09-28 21:42:00","inspection_id":"79788919","insp_unit_id":"197307543","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38279U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2CC19B0A2046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:09.000000Z","updated_at":"2025-03-17T22:55:09.000000Z"}]},{"id":3594362,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","dot_number":"3074698","report_state":"CA","report_number":"UDLF002921","insp_date":"2023-07-25 00:00:00","insp_start_time":"1023","insp_end_time":"1047","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"BROOKS","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50530","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14995704","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-25 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:54.000000Z","updated_at":"2025-03-17T19:33:54.000000Z","inspection_violations":[{"id":5541477,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_violation_id":"254277811","seq_no":"1","part_no":"393","part_no_section":"62(a)","insp_viol_unit":"1","insp_unit_id":"196194443","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"39362A"},{"id":5541478,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_violation_id":"254277812","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196194443","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"3939A"},{"id":5541479,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_violation_id":"254277813","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196194443","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"3963A1"},{"id":5541480,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_violation_id":"254277814","seq_no":"4","part_no":"390","part_no_section":"19(a)(2)","insp_viol_unit":"1","insp_unit_id":"196194443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"39019A2"},{"id":5541481,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_violation_id":"254277815","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196194443","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5779316,"change_date":"2023-07-25 21:42:00","inspection_id":"79239972","insp_unit_id":"196194443","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"SETR","insp_unit_company":"704","insp_unit_license":"97158S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"WKKA40PH8C3050015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:36.000000Z","updated_at":"2025-03-17T22:48:36.000000Z"}]},{"id":3594375,"change_date":"2023-07-25 21:42:00","inspection_id":"79239988","dot_number":"3074698","report_state":"CA","report_number":"UDLF002922","insp_date":"2023-07-25 00:00:00","insp_start_time":"1030","insp_end_time":"1108","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"BROOKS","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14995610","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-25 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:54.000000Z","updated_at":"2025-03-17T19:33:54.000000Z","inspection_violations":[{"id":5541490,"change_date":"2023-07-25 21:42:00","inspection_id":"79239988","insp_violation_id":"254277835","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"KL14002","created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"39141A1"},{"id":5541491,"change_date":"2023-07-25 21:42:00","inspection_id":"79239988","insp_violation_id":"254277836","seq_no":"2","part_no":"393","part_no_section":"62(a)","insp_viol_unit":"1","insp_unit_id":"196194465","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KL14002","created_at":"2025-03-17T21:32:43.000000Z","updated_at":"2025-03-17T21:32:43.000000Z","normalized_code":"39362A"}],"inspection_per_units":[{"id":5779332,"change_date":"2023-07-25 21:42:00","inspection_id":"79239988","insp_unit_id":"196194465","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:36.000000Z","updated_at":"2025-03-17T22:48:36.000000Z"}]},{"id":3266261,"change_date":"2023-06-12 21:41:00","inspection_id":"78870994","dot_number":"3074698","report_state":"CA","report_number":"NE2W001511","insp_date":"2023-05-17 00:00:00","insp_start_time":"1435","insp_end_time":"1533","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"14939240","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-12 21:41:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:27:42.000000Z","updated_at":"2025-03-17T19:27:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5252692,"change_date":"2023-06-12 21:41:00","inspection_id":"78870994","insp_unit_id":"195455997","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"5660","insp_unit_license":"97194S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXU83F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:24.000000Z","updated_at":"2025-03-17T22:44:24.000000Z"}]},{"id":2782614,"change_date":"2023-04-11 21:40:00","inspection_id":"78324617","dot_number":"3074698","report_state":"CA","report_number":"UDLF002749","insp_date":"2023-04-11 00:00:00","insp_start_time":"1000","insp_end_time":"1024","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14855453","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:02.000000Z","updated_at":"2025-03-17T19:18:02.000000Z","inspection_violations":[{"id":4270776,"change_date":"2023-04-11 21:40:00","inspection_id":"78324617","insp_violation_id":"252166414","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194336800","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"39360C"},{"id":4270777,"change_date":"2023-04-11 21:40:00","inspection_id":"78324617","insp_violation_id":"252166415","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194336800","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:57.000000Z","updated_at":"2025-03-17T21:26:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4478949,"change_date":"2023-04-11 21:40:00","inspection_id":"78324617","insp_unit_id":"194336800","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"Y","insp_unit_decal_number":"32458871","created_at":"2025-03-17T22:38:17.000000Z","updated_at":"2025-03-17T22:38:17.000000Z"}]},{"id":2691059,"change_date":"2023-03-29 21:42:00","inspection_id":"78220557","dot_number":"3074698","report_state":"CA","report_number":"NE2W001316","insp_date":"2023-03-09 00:00:00","insp_start_time":"0704","insp_end_time":"0801","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14837862","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4332389,"change_date":"2023-03-29 21:42:00","inspection_id":"78220557","insp_unit_id":"194132966","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38279U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2CC19B0A2046941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2691056,"change_date":"2023-03-29 21:42:00","inspection_id":"78220554","dot_number":"3074698","report_state":"CA","report_number":"NE2W001313","insp_date":"2023-03-08 00:00:00","insp_start_time":"0703","insp_end_time":"0759","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"14837419","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[{"id":4134349,"change_date":"2023-03-29 21:42:00","inspection_id":"78220554","insp_violation_id":"251943679","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194132963","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:20.000000Z","updated_at":"2025-03-17T21:26:20.000000Z","normalized_code":"3963A1"},{"id":4134350,"change_date":"2023-03-29 21:42:00","inspection_id":"78220554","insp_violation_id":"251943680","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194132963","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:20.000000Z","updated_at":"2025-03-17T21:26:20.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4332386,"change_date":"2023-03-29 21:42:00","inspection_id":"78220554","insp_unit_id":"194132963","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":null,"insp_unit_license":"0D57W48","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXV85F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2691057,"change_date":"2023-03-29 21:42:00","inspection_id":"78220555","dot_number":"3074698","report_state":"CA","report_number":"NE2W001314","insp_date":"2023-03-08 00:00:00","insp_start_time":"0802","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14837385","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4332387,"change_date":"2023-03-29 21:42:00","inspection_id":"78220555","insp_unit_id":"194132964","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2175403,"change_date":"2023-01-18 21:41:00","inspection_id":"77632847","dot_number":"3074698","report_state":"CA","report_number":"UF42004333","insp_date":"2023-01-17 00:00:00","insp_start_time":"1006","insp_end_time":"1036","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"14745497","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:41:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3362017,"change_date":"2023-01-18 21:41:00","inspection_id":"77632847","insp_violation_id":"250646987","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192942797","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3963A1"},{"id":3362018,"change_date":"2023-01-18 21:41:00","inspection_id":"77632847","insp_violation_id":"250646988","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192942797","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3501294,"change_date":"2023-01-18 21:41:00","inspection_id":"77632847","insp_unit_id":"192942797","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":null,"insp_unit_license":"0D57W48","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXV83F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2175458,"change_date":"2023-01-18 21:41:00","inspection_id":"77632905","dot_number":"3074698","report_state":"CA","report_number":"UF42004335","insp_date":"2023-01-17 00:00:00","insp_start_time":"1046","insp_end_time":"1116","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14745134","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:41:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3362057,"change_date":"2023-01-18 21:41:00","inspection_id":"77632905","insp_violation_id":"250647030","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192942881","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3963A1"},{"id":3362058,"change_date":"2023-01-18 21:41:00","inspection_id":"77632905","insp_violation_id":"250647031","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192942881","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3939A"},{"id":3362059,"change_date":"2023-01-18 21:41:00","inspection_id":"77632905","insp_violation_id":"250647032","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192942881","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3501369,"change_date":"2023-01-18 21:41:00","inspection_id":"77632905","insp_unit_id":"192942881","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":1556691,"change_date":"2022-10-19 21:42:00","inspection_id":"76923977","dot_number":"3074698","report_state":"CA","report_number":"UBZU002229","insp_date":"2022-10-18 00:00:00","insp_start_time":"0855","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14641151","transaction_code":"A","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-19 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:15.000000Z","updated_at":"2025-03-17T18:55:15.000000Z","inspection_violations":[{"id":2448275,"change_date":"2022-10-19 21:42:00","inspection_id":"76923977","insp_violation_id":"249137014","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KB18145","created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"},{"id":2448276,"change_date":"2022-10-19 21:42:00","inspection_id":"76923977","insp_violation_id":"249137015","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KB18145","created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2504958,"change_date":"2022-10-19 21:42:00","inspection_id":"76923977","insp_unit_id":"191538438","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXU83F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:09.000000Z","updated_at":"2025-03-17T22:24:09.000000Z"}]},{"id":1331173,"change_date":"2022-09-20 21:42:00","inspection_id":"76662813","dot_number":"3074698","report_state":"CA","report_number":"UDLF002304","insp_date":"2022-09-20 00:00:00","insp_start_time":"1005","insp_end_time":"1024","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14601803","transaction_code":"A","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:14.000000Z","updated_at":"2025-03-17T18:51:14.000000Z","inspection_violations":[{"id":2106649,"change_date":"2022-09-20 21:42:00","inspection_id":"76662813","insp_violation_id":"248545036","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191010917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"39311"},{"id":2106650,"change_date":"2022-09-20 21:42:00","inspection_id":"76662813","insp_violation_id":"248545037","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"191010917","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":2143137,"change_date":"2022-09-20 21:42:00","inspection_id":"76662813","insp_unit_id":"191010917","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38279U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2CC19B0A2046941","insp_unit_decal":"Y","insp_unit_decal_number":"31465451","created_at":"2025-03-17T22:21:40.000000Z","updated_at":"2025-03-17T22:21:40.000000Z"}]},{"id":1331175,"change_date":"2022-09-20 21:42:00","inspection_id":"76662815","dot_number":"3074698","report_state":"CA","report_number":"UDLF002306","insp_date":"2022-09-20 00:00:00","insp_start_time":"1036","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14602169","transaction_code":"A","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:14.000000Z","updated_at":"2025-03-17T18:51:14.000000Z","inspection_violations":[{"id":2106652,"change_date":"2022-09-20 21:42:00","inspection_id":"76662815","insp_violation_id":"248545039","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"191010919","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"39395F"},{"id":2106653,"change_date":"2022-09-20 21:42:00","inspection_id":"76662815","insp_violation_id":"248545040","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191010919","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2143139,"change_date":"2022-09-20 21:42:00","inspection_id":"76662815","insp_unit_id":"191010919","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":null,"insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"Y","insp_unit_decal_number":"03146542","created_at":"2025-03-17T22:21:40.000000Z","updated_at":"2025-03-17T22:21:40.000000Z"}]},{"id":622479,"change_date":"2022-06-15 21:41:00","inspection_id":"75834830","dot_number":"3074698","report_state":"CA","report_number":"UEV6001729","insp_date":"2022-06-14 00:00:00","insp_start_time":"0950","insp_end_time":"1040","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"14470319","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1001008,"change_date":"2022-06-15 21:41:00","inspection_id":"75834830","insp_unit_id":"189281920","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TMC","insp_unit_company":"5660","insp_unit_license":"EW47306","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXU83F1000022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:21.000000Z","updated_at":"2025-03-17T22:14:21.000000Z"}]},{"id":633179,"change_date":"2022-06-16 21:43:00","inspection_id":"75847703","dot_number":"3074698","report_state":"CA","report_number":"UEV6001731","insp_date":"2022-06-14 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14471449","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T18:38:50.000000Z","updated_at":"2025-03-17T18:38:50.000000Z","inspection_violations":[{"id":995736,"change_date":"2022-06-16 21:43:00","inspection_id":"75847703","insp_violation_id":"246537377","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189309876","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1018117,"change_date":"2022-06-16 21:43:00","inspection_id":"75847703","insp_unit_id":"189309876","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"5657","insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:27.000000Z","updated_at":"2025-03-17T22:14:27.000000Z"}]},{"id":495901,"change_date":"2022-05-26 21:43:00","inspection_id":"75684486","dot_number":"3074698","report_state":"CA","report_number":"NBHZ000913","insp_date":"2022-05-04 00:00:00","insp_start_time":"0842","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14445029","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T18:36:22.000000Z","updated_at":"2025-03-17T18:36:22.000000Z","inspection_violations":[{"id":788689,"change_date":"2022-05-26 21:43:00","inspection_id":"75684486","insp_violation_id":"246117588","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188946118","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":797447,"change_date":"2022-05-26 21:43:00","inspection_id":"75684486","insp_unit_id":"188946118","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"5657","insp_unit_license":"38483U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2TC19B9B2044719","insp_unit_decal":"Y","insp_unit_decal_number":"31108991","created_at":"2025-03-17T22:13:07.000000Z","updated_at":"2025-03-17T22:13:07.000000Z"}]},{"id":495827,"change_date":"2022-05-26 21:43:00","inspection_id":"75684402","dot_number":"3074698","report_state":"CA","report_number":"NBHZ000912","insp_date":"2022-05-03 00:00:00","insp_start_time":"0915","insp_end_time":"1020","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"SAN JOSE","county_code_state":"CA","county_code":"085","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"14446117","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T18:36:22.000000Z","updated_at":"2025-03-17T18:36:22.000000Z","inspection_violations":[{"id":788619,"change_date":"2022-05-26 21:43:00","inspection_id":"75684402","insp_violation_id":"246117499","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188945976","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":797327,"change_date":"2022-05-26 21:43:00","inspection_id":"75684402","insp_unit_id":"188945976","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TMC","insp_unit_company":"5660","insp_unit_license":"EW47306","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"NLTEJXU83F1000022","insp_unit_decal":"Y","insp_unit_decal_number":"31108990","created_at":"2025-03-17T22:13:07.000000Z","updated_at":"2025-03-17T22:13:07.000000Z"}]},{"id":15286,"change_date":"2022-03-21 21:32:00","inspection_id":"75101085","dot_number":"3074698","report_state":"CA","report_number":"UDLF001862","insp_date":"2022-03-19 00:00:00","insp_start_time":"0943","insp_end_time":"1011","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"CACHE CREEK CASINO","county_code_state":"CA","county_code":"113","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-21 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"14349819","transaction_code":"A","transaction_date":"2022-03-19 00:00:00","upload_date":"2022-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03074698","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-21 21:32:00","insp_carrier_name":"FERNANDO MANUEL MEDINA","insp_carrier_street":"2015 E HAMMOND AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93703","insp_colonia":null,"docket_number":"63198","insp_interstate":"Y","insp_carrier_state_id":"522722","created_at":"2025-03-17T18:27:47.000000Z","updated_at":"2025-03-17T18:27:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":24750,"change_date":"2022-03-21 21:32:00","inspection_id":"75101085","insp_unit_id":"187742355","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"5651","insp_unit_license":"38279U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"YE2CC19B0A2046941","insp_unit_decal":"Y","insp_unit_decal_number":"30774518","created_at":"2025-03-17T22:08:24.000000Z","updated_at":"2025-03-17T22:08:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3074698\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3074698\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3074698\/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\/3074698\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}