{"current_page":1,"data":[{"id":10149971,"change_date":"2025-11-07 21:40:00","inspection_id":"86268105","dot_number":"2664967","report_state":"CA","report_number":"UEIG000745","insp_date":"2025-11-06 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"160","location_desc":"SR-162 AT EUREKA ST","county_code_state":"CA","county_code":"021","insp_level_id":"1","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"110700","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16050166","transaction_code":"A","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-11-10T10:31:46.000000Z","updated_at":"2025-11-11T10:31:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16897763,"change_date":"2025-11-07 21:40:00","inspection_id":"86268105","insp_unit_id":"209912807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHI","insp_unit_license":"9E85928","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBAP8X4DD212168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:18.000000Z","updated_at":"2025-11-11T10:01:26.000000Z"},{"id":16897764,"change_date":"2025-11-07 21:40:00","inspection_id":"86268105","insp_unit_id":"209912808","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLMO","insp_unit_company":null,"insp_unit_license":"UY9045","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"V51400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:18.000000Z","updated_at":"2025-11-11T10:01:26.000000Z"},{"id":16897765,"change_date":"2025-11-07 21:40:00","inspection_id":"86268105","insp_unit_id":"209912809","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRLMO","insp_unit_company":null,"insp_unit_license":"1UJ2956","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"V51389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:18.000000Z","updated_at":"2025-11-11T10:01:26.000000Z"}]},{"id":9537375,"change_date":"2025-08-28 21:41:00","inspection_id":"85624195","dot_number":"2664967","report_state":"CA","report_number":"UEY5001967","insp_date":"2025-08-27 00:00:00","insp_start_time":"1502","insp_end_time":"1524","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"SB SR-99 AT EAGER RD","county_code_state":"CA","county_code":"101","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":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15956535","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-09-06T10:42:19.000000Z","updated_at":"2025-09-06T10:42:19.000000Z","inspection_violations":[{"id":18468317,"change_date":null,"inspection_id":"85624195","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"110C-C","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393110CC"}],"inspection_per_units":[{"id":15741487,"change_date":"2025-08-28 21:41:00","inspection_id":"85624195","insp_unit_id":"208643337","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9F88313","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X0KD618144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:41.000000Z","updated_at":"2025-09-09T09:46:41.000000Z"},{"id":15741488,"change_date":"2025-08-28 21:41:00","inspection_id":"85624195","insp_unit_id":"208643338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLMO","insp_unit_company":null,"insp_unit_license":"XB4232","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"J22676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:41.000000Z","updated_at":"2025-09-09T09:46:41.000000Z"},{"id":15741489,"change_date":"2025-08-28 21:41:00","inspection_id":"85624195","insp_unit_id":"208643339","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TUFB","insp_unit_company":null,"insp_unit_license":"XP7494","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1T9A3112XE1030524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:41.000000Z","updated_at":"2025-09-09T09:46:41.000000Z"}]},{"id":6416096,"change_date":"2024-08-07 21:41:00","inspection_id":"82329111","dot_number":"2664967","report_state":"CA","report_number":"UDP0005308","insp_date":"2024-08-07 00:00:00","insp_start_time":"0900","insp_end_time":"0927","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"STOCKTON AREA","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15474953","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2024-08-07 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-03-17T20:29:55.000000Z","updated_at":"2025-03-17T20:29:55.000000Z","inspection_violations":[{"id":9962957,"change_date":"2024-08-07 21:41:00","inspection_id":"82329111","insp_violation_id":"261075841","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"202287635","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10340655,"change_date":"2024-08-07 21:41:00","inspection_id":"82329111","insp_unit_id":"202287633","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"ZP04809","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCA48X3RD685179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"},{"id":10340656,"change_date":"2024-08-07 21:41:00","inspection_id":"82329111","insp_unit_id":"202287634","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"XB4232","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"J22676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"},{"id":10340657,"change_date":"2024-08-07 21:41:00","inspection_id":"82329111","insp_unit_id":"202287635","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TUFB","insp_unit_company":null,"insp_unit_license":"XP7494","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1T9A3112XE1030524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"}]},{"id":6301554,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","dot_number":"2664967","report_state":"CA","report_number":"UDP0005270","insp_date":"2024-07-24 00:00:00","insp_start_time":"1125","insp_end_time":"1203","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"STOCKTON AREA","county_code_state":"CA","county_code":"077","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-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15456345","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-03-17T20:27:48.000000Z","updated_at":"2025-03-17T20:27:48.000000Z","inspection_violations":[{"id":9786056,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_violation_id":"260825193","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"202053979","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"37611D1"},{"id":9786057,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_violation_id":"260825194","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202053980","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RD66004","created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3922"},{"id":9786058,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_violation_id":"260825195","seq_no":"3","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"202053980","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3929A1"},{"id":9786059,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_violation_id":"260825196","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"202053981","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RD66004","created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3922"},{"id":9786060,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_violation_id":"260825197","seq_no":"5","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"3","insp_unit_id":"202053981","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":10153660,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_unit_id":"202053979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YP18402","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCAP7X5ND775317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"},{"id":10153661,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_unit_id":"202053980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4BY9190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"6L92657009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"},{"id":10153662,"change_date":"2024-07-24 21:42:00","inspection_id":"82206508","insp_unit_id":"202053981","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4BY9191","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"6L92658003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"}]},{"id":5001019,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","dot_number":"2664967","report_state":"CA","report_number":"UDR4004569","insp_date":"2024-02-06 00:00:00","insp_start_time":"1520","insp_end_time":"1550","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"UKIAH AREA -","county_code_state":"CA","county_code":"045","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":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15227833","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-03-17T20:01:59.000000Z","updated_at":"2025-03-17T20:01:59.000000Z","inspection_violations":[{"id":7703796,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720649","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"199318689","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39021TA"},{"id":7703797,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720650","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199318689","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39311"},{"id":7703798,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720651","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199318689","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LU10459","created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39395F"},{"id":7703799,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720652","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199318689","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW636846","created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39395A"},{"id":7703800,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720653","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3922"},{"id":7703801,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_violation_id":"257720654","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199318689","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":8049307,"change_date":"2024-02-07 21:41:00","inspection_id":"80794457","insp_unit_id":"199318689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"CU12T95","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD39SEYRF167430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"}]},{"id":1535539,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","dot_number":"2664967","report_state":"CA","report_number":"UD7S002977","insp_date":"2022-10-17 00:00:00","insp_start_time":"1035","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"151","location_desc":"SR-53 AT LAKESHORE DR","county_code_state":"CA","county_code":"033","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-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"14637553","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2022-10-17 21:42:00","snet_input_date":"2022-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-17 21:42:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-03-17T18:54:52.000000Z","updated_at":"2025-03-17T18:54:52.000000Z","inspection_violations":[{"id":2419095,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084651","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"191487303","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39351"},{"id":2419096,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084652","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191487304","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39347E"},{"id":2419097,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084653","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191487304","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39347E"},{"id":2419098,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084654","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"191487305","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW745510","created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3963A1"},{"id":2419099,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084655","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191487304","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3963A1"},{"id":2419100,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_violation_id":"249084656","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191487303","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2471379,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_unit_id":"191487303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9F58687","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X4HD421633","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"},{"id":2471380,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_unit_id":"191487304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLO","insp_unit_company":null,"insp_unit_license":"1VD8355","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"212999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"},{"id":2471381,"change_date":"2022-10-17 21:42:00","inspection_id":"76899561","insp_unit_id":"191487305","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"TRLO","insp_unit_company":null,"insp_unit_license":"1VD8356","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"213000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"}]},{"id":1279821,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","dot_number":"2664967","report_state":"CA","report_number":"UD7S002900","insp_date":"2022-09-12 00:00:00","insp_start_time":"1310","insp_end_time":"1355","registration_date":null,"region":"PT","ci_status_code":"C","location":"151","location_desc":"SR-29 AT HOFACKER LN","county_code_state":"CA","county_code":"033","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"114700","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14591146","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02664967","upload_search_indicator":null,"census_search_date":"2022-09-13 21:42:00","snet_input_date":"2022-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-13 21:42:00","insp_carrier_name":"BELLA VISTA FARMING COMPANY LLC","insp_carrier_street":"4150 SODA BAY ROAD","insp_carrier_city":"KELSEYVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95451","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"252341","created_at":"2025-03-17T18:50:10.000000Z","updated_at":"2025-03-17T18:50:10.000000Z","inspection_violations":[{"id":2025501,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_violation_id":"248396372","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"190884379","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39311"},{"id":2025502,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_violation_id":"248396373","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"190884377","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39343"},{"id":2025503,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_violation_id":"248396374","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"3","insp_unit_id":"190884379","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39375C"},{"id":2025504,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_violation_id":"248396375","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190884377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2059812,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_unit_id":"190884377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9F34077","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBAP8X2GD341014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:07.000000Z","updated_at":"2025-03-17T22:21:07.000000Z"},{"id":2059813,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_unit_id":"190884378","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLMO","insp_unit_company":null,"insp_unit_license":"XB4232","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"J22676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:07.000000Z","updated_at":"2025-03-17T22:21:07.000000Z"},{"id":2059814,"change_date":"2022-09-13 21:42:00","inspection_id":"76602705","insp_unit_id":"190884379","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"TUFB","insp_unit_company":null,"insp_unit_license":"XP7494","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1T9A3112XE1030524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:07.000000Z","updated_at":"2025-03-17T22:21:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2664967\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2664967\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2664967\/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\/2664967\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}