{"current_page":1,"data":[{"id":9004264,"change_date":"2025-06-26 21:42:00","inspection_id":"85063164","dot_number":"3983669","report_state":"CA","report_number":"UE5M004522","insp_date":"2025-06-15 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15867413","transaction_code":"A","transaction_date":"2025-06-15 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-06-30T10:01:12.000000Z","updated_at":"2025-06-30T10:01:12.000000Z","inspection_violations":[{"id":14472834,"change_date":"2025-06-26 21:42:00","inspection_id":"85063164","insp_violation_id":"267077062","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207590291","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC10768","created_at":"2025-06-29T10:17:01.000000Z","updated_at":"2025-06-30T10:18:42.000000Z","normalized_code":"39021TB1MC"},{"id":14472835,"change_date":"2025-06-26 21:42:00","inspection_id":"85063164","insp_violation_id":"267077063","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207590291","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC10768","created_at":"2025-06-29T10:17:01.000000Z","updated_at":"2025-06-30T10:18:42.000000Z","normalized_code":"3939ALHLI"},{"id":14472836,"change_date":"2025-06-26 21:42:00","inspection_id":"85063164","insp_violation_id":"267077064","seq_no":"3","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"207590291","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:01.000000Z","updated_at":"2025-06-30T10:18:42.000000Z","normalized_code":"39330B"}],"inspection_per_units":[{"id":14766744,"change_date":"2025-06-26 21:42:00","inspection_id":"85063164","insp_unit_id":"207590291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"59060E4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JV0K4S71616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:27.000000Z","updated_at":"2025-07-01T09:48:44.000000Z"}]},{"id":8001500,"change_date":"2025-03-02 21:34:00","inspection_id":"84005284","dot_number":"3983669","report_state":"AZ","report_number":"XE55030502","insp_date":"2025-02-26 00:00:00","insp_start_time":"1424","insp_end_time":"1448","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSTGG","location_desc":"ST. GEORGE UT AZ","county_code_state":"AZ","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-02 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1418307","transaction_code":"A","transaction_date":"2025-03-02 00:00:00","upload_date":"2025-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2025-03-02 21:34:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-02 21:34:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:27.000000Z","updated_at":"2025-03-17T21:04:27.000000Z","inspection_violations":[{"id":12502363,"change_date":"2025-03-02 21:34:00","inspection_id":"84005284","insp_violation_id":"264781100","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"3953A1HOSPD"},{"id":12502364,"change_date":"2025-03-02 21:34:00","inspection_id":"84005284","insp_violation_id":"264781101","seq_no":"1","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"3958K2HOSP"},{"id":12502365,"change_date":"2025-03-02 21:34:00","inspection_id":"84005284","insp_violation_id":"264781102","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205578774","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12917649,"change_date":"2025-03-02 21:34:00","inspection_id":"84005284","insp_unit_id":"205578774","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"92379J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMFL5HG617123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:41.000000Z","updated_at":"2025-03-17T23:57:41.000000Z"}]},{"id":7959890,"change_date":"2025-02-25 21:41:00","inspection_id":"83961580","dot_number":"3983669","report_state":"CA","report_number":"NFFM000235","insp_date":"2025-02-22 00:00:00","insp_start_time":"0015","insp_end_time":"0100","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15716081","transaction_code":"A","transaction_date":"2025-02-22 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2025-02-25 21:41:00","snet_input_date":"2025-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:41:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12849537,"change_date":"2025-02-25 21:41:00","inspection_id":"83961580","insp_unit_id":"205497194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT","insp_unit_license":"92379J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMFL5HG617123","insp_unit_decal":"Y","insp_unit_decal_number":"34824136","created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7796547,"change_date":"2025-02-05 21:40:00","inspection_id":"83790260","dot_number":"3983669","report_state":"CA","report_number":"NBH6006382","insp_date":"2025-02-04 00:00:00","insp_start_time":"0604","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15693163","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2025-02-05 21:40:00","snet_input_date":"2025-02-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-05 21:40:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T20:59:57.000000Z","updated_at":"2025-03-17T20:59:57.000000Z","inspection_violations":[{"id":12184322,"change_date":"2025-02-05 21:40:00","inspection_id":"83790260","insp_violation_id":"264362037","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"205178129","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3922SLLSOA"},{"id":12184323,"change_date":"2025-02-05 21:40:00","inspection_id":"83790260","insp_violation_id":"264362038","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3958A1HOSP"},{"id":12184324,"change_date":"2025-02-05 21:40:00","inspection_id":"83790260","insp_violation_id":"264362039","seq_no":"3","part_no":"392","part_no_section":"7A-D","insp_viol_unit":"1","insp_unit_id":"205178129","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3927AD"}],"inspection_per_units":[{"id":12582290,"change_date":"2025-02-05 21:40:00","inspection_id":"83790260","insp_unit_id":"205178129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"92379J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRMFL5HG617123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:00.000000Z","updated_at":"2025-03-17T23:54:00.000000Z"}]},{"id":4297322,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","dot_number":"3983669","report_state":"CA","report_number":"UBU5001345","insp_date":"2023-10-26 00:00:00","insp_start_time":"0930","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"125","location_desc":"HUNTS SCALE","county_code_state":"CA","county_code":"023","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-10-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15112074","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-10-26 21:42:00","snet_input_date":"2023-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-26 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:47:54.000000Z","updated_at":"2025-03-17T19:47:54.000000Z","inspection_violations":[{"id":6648223,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","insp_violation_id":"256076325","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197774535","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KV19721","created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3922"},{"id":6648224,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","insp_violation_id":"256076326","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197774535","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39021TB"},{"id":6648225,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","insp_violation_id":"256076327","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197774535","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39345B2"},{"id":6648226,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","insp_violation_id":"256076328","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197774535","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6911407,"change_date":"2023-10-26 21:42:00","inspection_id":"80022269","insp_unit_id":"197774535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMMMML6GH129523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:58.000000Z","updated_at":"2025-03-17T22:57:58.000000Z"}]},{"id":3837299,"change_date":"2023-08-25 21:42:00","inspection_id":"79511714","dot_number":"3983669","report_state":"CA","report_number":"UBU5001203","insp_date":"2023-08-24 00:00:00","insp_start_time":"0920","insp_end_time":"0948","registration_date":null,"region":"PT","ci_status_code":"C","location":"125","location_desc":"HUNTS SCALE","county_code_state":"CA","county_code":"023","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":"2023-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15037321","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-08-25 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-25 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:38:34.000000Z","updated_at":"2025-03-17T19:38:34.000000Z","inspection_violations":[{"id":5927778,"change_date":"2023-08-25 21:42:00","inspection_id":"79511714","insp_violation_id":"254902946","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196743068","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CQ025573","created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6169707,"change_date":"2023-08-25 21:42:00","inspection_id":"79511714","insp_unit_id":"196743068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"}]},{"id":3625732,"change_date":"2023-07-28 21:42:00","inspection_id":"79275167","dot_number":"3983669","report_state":"CA","report_number":"UE1B000795","insp_date":"2023-07-26 00:00:00","insp_start_time":"0505","insp_end_time":"0523","registration_date":null,"region":"PT","ci_status_code":"C","location":"310","location_desc":"N\/B MARIN SCALES","county_code_state":"CA","county_code":"041","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14999084","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5591666,"change_date":"2023-07-28 21:42:00","inspection_id":"79275167","insp_violation_id":"254358607","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196264130","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW 752812","created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39021TA"},{"id":5591667,"change_date":"2023-07-28 21:42:00","inspection_id":"79275167","insp_violation_id":"254358608","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196264130","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5829498,"change_date":"2023-07-28 21:42:00","inspection_id":"79275167","insp_unit_id":"196264130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3561660,"change_date":"2023-07-20 21:42:00","inspection_id":"79203261","dot_number":"3983669","report_state":"CA","report_number":"UCUF003100","insp_date":"2023-07-17 00:00:00","insp_start_time":"0740","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","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-07-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"14990010","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-07-20 21:42:00","snet_input_date":"2023-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-20 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:33:30.000000Z","updated_at":"2025-03-17T19:33:30.000000Z","inspection_violations":[{"id":5492367,"change_date":"2023-07-20 21:42:00","inspection_id":"79203261","insp_violation_id":"254193600","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196118577","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LD 57698","created_at":"2025-03-17T21:32:29.000000Z","updated_at":"2025-03-17T21:32:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5727253,"change_date":"2023-07-20 21:42:00","inspection_id":"79203261","insp_unit_id":"196118577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI.2X.BXVN","insp_unit_license":"9F99190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDTXFDGH4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:12.000000Z","updated_at":"2025-03-17T22:48:12.000000Z"}]},{"id":3495365,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","dot_number":"3983669","report_state":"CA","report_number":"UDR4003919","insp_date":"2023-07-07 00:00:00","insp_start_time":"1250","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"UKIAH AREA - RIDGEWOOD SCALE","county_code_state":"CA","county_code":"045","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":"2023-07-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14977806","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-07-12 21:42:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5390155,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_violation_id":"254029112","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195969997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5390156,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_violation_id":"254029113","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195969997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LT47755","created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5390157,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_violation_id":"254029114","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195969997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5390158,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_violation_id":"254029115","seq_no":"4","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"195969997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39386B1"},{"id":5390159,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_violation_id":"254029116","seq_no":"5","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"195969997","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA430042","created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":5620437,"change_date":"2023-07-12 21:42:00","inspection_id":"79128998","insp_unit_id":"195969997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:23.000000Z","updated_at":"2025-03-17T22:47:23.000000Z"}]},{"id":3236348,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","dot_number":"3983669","report_state":"CA","report_number":"UD7S003469","insp_date":"2023-06-07 00:00:00","insp_start_time":"1240","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"RIDGEWOOD PLATFORM SCALE","county_code_state":"CA","county_code":"045","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":"2023-06-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14933812","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-06-07 21:43:00","snet_input_date":"2023-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-07 21:43:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:26:56.000000Z","updated_at":"2025-03-17T19:26:56.000000Z","inspection_violations":[{"id":4989635,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","insp_violation_id":"253376605","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195388354","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3922"},{"id":4989636,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","insp_violation_id":"253376606","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195388354","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3922"},{"id":4989637,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","insp_violation_id":"253376607","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"195388354","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW747025","created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39021TA"},{"id":4989638,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","insp_violation_id":"253376608","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195388354","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5205039,"change_date":"2023-06-07 21:43:00","inspection_id":"78837249","insp_unit_id":"195388354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:02.000000Z","updated_at":"2025-03-17T22:44:02.000000Z"}]},{"id":3187140,"change_date":"2023-05-31 21:43:00","inspection_id":"78781800","dot_number":"3983669","report_state":"CA","report_number":"UDR4003719","insp_date":"2023-05-23 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"155","location_desc":"HUNTS DAIRY","county_code_state":"CA","county_code":"023","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":"2023-05-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14923931","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-05-31 21:43:00","snet_input_date":"2023-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-31 21:43:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:26:05.000000Z","updated_at":"2025-03-17T19:26:05.000000Z","inspection_violations":[{"id":4910713,"change_date":"2023-05-31 21:43:00","inspection_id":"78781800","insp_violation_id":"253200372","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195246269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KM48199","created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3922"},{"id":4910714,"change_date":"2023-05-31 21:43:00","inspection_id":"78781800","insp_violation_id":"253200373","seq_no":"2","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"195246269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39386B1"},{"id":4910715,"change_date":"2023-05-31 21:43:00","inspection_id":"78781800","insp_violation_id":"253200374","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195246269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5126482,"change_date":"2023-05-31 21:43:00","inspection_id":"78781800","insp_unit_id":"195246269","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:24.000000Z","updated_at":"2025-03-17T22:43:24.000000Z"}]},{"id":2758954,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","dot_number":"3983669","report_state":"CA","report_number":"UDR4003525","insp_date":"2023-04-06 00:00:00","insp_start_time":"1325","insp_end_time":"1415","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"UKIAH AREA - RIDGEWOOD SCALE","county_code_state":"CA","county_code":"045","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":"2023-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"10","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14850566","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-04-07 21:38:00","snet_input_date":"2023-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:17:24.000000Z","updated_at":"2025-03-17T19:17:24.000000Z","inspection_violations":[{"id":4234655,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109400","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234656,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109401","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234657,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109402","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234658,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109403","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234659,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109404","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD74590","created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234660,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109405","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234661,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109406","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4234662,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109407","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39311"},{"id":4234663,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109408","seq_no":"9","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW609623","created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39375B"},{"id":4234664,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_violation_id":"252109409","seq_no":"10","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194284155","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":4440496,"change_date":"2023-04-07 21:38:00","inspection_id":"78297869","insp_unit_id":"194284155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:58.000000Z","updated_at":"2025-03-17T22:37:58.000000Z"}]},{"id":2880279,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","dot_number":"3983669","report_state":"CA","report_number":"UE0F003121","insp_date":"2023-04-05 00:00:00","insp_start_time":"1403","insp_end_time":"1428","registration_date":null,"region":"PT","ci_status_code":"C","location":"250","location_desc":"I80 W\/B E\/OF RALEY BLVD","county_code_state":"CA","county_code":"067","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14871266","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-04-24 21:42:00","snet_input_date":"2023-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-24 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:20:01.000000Z","updated_at":"2025-03-17T19:20:01.000000Z","inspection_violations":[{"id":4421196,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","insp_violation_id":"252411795","seq_no":"1","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"194559567","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"ELECTRONIC","created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"3929AA1"},{"id":4421197,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","insp_violation_id":"252411796","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194559567","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"3922"},{"id":4421198,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","insp_violation_id":"252411797","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194559567","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"39021TB"},{"id":4421199,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","insp_violation_id":"252411798","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194559567","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":4634462,"change_date":"2023-04-24 21:42:00","inspection_id":"78435033","insp_unit_id":"194559567","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X\/WHI","insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:33.000000Z","updated_at":"2025-03-17T22:39:33.000000Z"}]},{"id":2667161,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","dot_number":"3983669","report_state":"NV","report_number":"9398020996","insp_date":"2023-03-27 00:00:00","insp_start_time":"0745","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"GARSON CHECK SITE","county_code_state":"NV","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"6902755","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"732962","transaction_code":"C","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":"M","census_search_date":"2023-03-27 21:39:00","snet_input_date":"2023-03-27 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-03-27 21:39:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:51.000000Z","updated_at":"2025-03-17T19:15:51.000000Z","inspection_violations":[{"id":4099308,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906432","seq_no":"1","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"3929AA1"},{"id":4099309,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906433","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"3922"},{"id":4099310,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906434","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39360C"},{"id":4099311,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906435","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39395A"},{"id":4099312,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906436","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39021TB"},{"id":4099313,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906437","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39347E"},{"id":4099314,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906438","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39353B"},{"id":4099315,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906439","seq_no":"8","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"393207C"},{"id":4099316,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_violation_id":"251906440","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194101112","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4294725,"change_date":"2023-03-28 21:40:00","inspection_id":"78192657","insp_unit_id":"194101112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:49.000000Z","updated_at":"2025-03-17T22:36:49.000000Z"}]},{"id":2570805,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","dot_number":"3983669","report_state":"CA","report_number":"NBYF000574","insp_date":"2023-03-11 00:00:00","insp_start_time":"0825","insp_end_time":"0914","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"E\/B ANTELOPE PLATFORM SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DHL","shipping_paper_number":"6848852","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":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14816127","transaction_code":"A","transaction_date":"2023-03-11 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3956559,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","insp_violation_id":"251643744","seq_no":"1","part_no":"392","part_no_section":"5(a)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"10","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3925A3"},{"id":3956560,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","insp_violation_id":"251643745","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193853563","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39021TB"},{"id":3956561,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","insp_violation_id":"251643746","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193853563","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39395F"},{"id":3956562,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","insp_violation_id":"251643747","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":4137751,"change_date":"2023-03-13 21:43:00","inspection_id":"78083547","insp_unit_id":"193853563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT BOX","insp_unit_license":"D3252","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALACWDT0EDFV6494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"}]},{"id":2538306,"change_date":"2023-03-08 21:41:00","inspection_id":"78046157","dot_number":"3983669","report_state":"CA","report_number":"UFA3000462","insp_date":"2023-02-21 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"WB ANTELPOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"14812309","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"623399","created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[{"id":3904432,"change_date":"2023-03-08 21:41:00","inspection_id":"78046157","insp_violation_id":"251558467","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193780256","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4085783,"change_date":"2023-03-08 21:41:00","inspection_id":"78046157","insp_unit_id":"193780256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:18.000000Z","updated_at":"2025-03-17T22:35:18.000000Z"}]},{"id":2427022,"change_date":"2023-02-22 21:40:00","inspection_id":"77920016","dot_number":"3983669","report_state":"CA","report_number":"UDXK000249","insp_date":"2023-02-20 00:00:00","insp_start_time":"0947","insp_end_time":"1013","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS CVEF (I-80 W\/B)","county_code_state":"CA","county_code":"057","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"14790182","transaction_code":"A","transaction_date":"2023-02-20 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:25.000000Z","updated_at":"2025-03-17T19:11:25.000000Z","inspection_violations":[{"id":3739016,"change_date":"2023-02-22 21:40:00","inspection_id":"77920016","insp_violation_id":"251282632","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193529111","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:36.000000Z","updated_at":"2025-03-17T21:24:36.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3906496,"change_date":"2023-02-22 21:40:00","inspection_id":"77920016","insp_unit_id":"193529111","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI","insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:59.000000Z","updated_at":"2025-03-17T22:33:59.000000Z"}]},{"id":2375317,"change_date":"2023-02-14 21:42:00","inspection_id":"77860927","dot_number":"3983669","report_state":"CA","report_number":"UBU5000787","insp_date":"2023-02-13 00:00:00","insp_start_time":"1125","insp_end_time":"1152","registration_date":null,"region":"PT","ci_status_code":"C","location":"126","location_desc":"SB MIRANDA SCALE","county_code_state":"CA","county_code":"023","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14783591","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-02-14 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-14 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EL MUNANSO CONGO LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:22.000000Z","updated_at":"2025-03-17T19:10:22.000000Z","inspection_violations":[{"id":3658556,"change_date":"2023-02-14 21:42:00","inspection_id":"77860927","insp_violation_id":"251145791","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"193407345","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KV17437","created_at":"2025-03-17T21:24:14.000000Z","updated_at":"2025-03-17T21:24:14.000000Z","normalized_code":"39375B"},{"id":3658557,"change_date":"2023-02-14 21:42:00","inspection_id":"77860927","insp_violation_id":"251145792","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193407345","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:14.000000Z","updated_at":"2025-03-17T21:24:14.000000Z","normalized_code":"3939A"},{"id":3658558,"change_date":"2023-02-14 21:42:00","inspection_id":"77860927","insp_violation_id":"251145793","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193407345","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:14.000000Z","updated_at":"2025-03-17T21:24:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3822335,"change_date":"2023-02-14 21:42:00","inspection_id":"77860927","insp_unit_id":"193407345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"87555K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALEEW167L7301842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:22.000000Z","updated_at":"2025-03-17T22:33:22.000000Z"}]},{"id":2227879,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","dot_number":"3983669","report_state":"NV","report_number":"7471181461","insp_date":"2023-01-24 00:00:00","insp_start_time":"1800","insp_end_time":"1830","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"MM 2","county_code_state":"NV","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"729039","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":"M","census_search_date":"2023-01-25 21:43:00","snet_input_date":"2023-01-24 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-01-25 21:43:00","insp_carrier_name":"BOTANICA LA GITANA EMC LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:44.000000Z","updated_at":"2025-03-17T19:07:44.000000Z","inspection_violations":[{"id":3441557,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","insp_violation_id":"250780193","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193067050","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"},{"id":3441558,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","insp_violation_id":"250780194","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193067050","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"3922"},{"id":3441559,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","insp_violation_id":"250780195","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193067050","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39021TB"},{"id":3441560,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","insp_violation_id":"250780196","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:18.000000Z","updated_at":"2025-03-17T21:23:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3585933,"change_date":"2023-01-25 21:43:00","inspection_id":"77692881","insp_unit_id":"193067050","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:43.000000Z","updated_at":"2025-03-17T22:31:43.000000Z"}]},{"id":2209014,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","dot_number":"3983669","report_state":"CA","report_number":"UE4H000688","insp_date":"2023-01-21 00:00:00","insp_start_time":"0550","insp_end_time":"0719","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"E\/B ANTELOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DHL","shipping_paper_number":"6704223","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"14751130","transaction_code":"A","transaction_date":"2023-01-21 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-01-23 21:42:00","snet_input_date":"2023-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-23 21:42:00","insp_carrier_name":"BOTANICA LA GITANA EMC LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:21.000000Z","updated_at":"2025-03-17T19:07:21.000000Z","inspection_violations":[{"id":3412326,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_violation_id":"250729475","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193019949","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3922"},{"id":3412327,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_violation_id":"250729476","seq_no":"2","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"193019949","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3929AA1"},{"id":3412328,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_violation_id":"250729477","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"193019949","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"39021TA"},{"id":3412329,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_violation_id":"250729478","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193019949","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3922"},{"id":3412330,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_violation_id":"250729479","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193019949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3555511,"change_date":"2023-01-23 21:42:00","inspection_id":"77671209","insp_unit_id":"193019949","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"64206B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT2FDGG5715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":2079186,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","dot_number":"3983669","report_state":"CA","report_number":"UC13002729","insp_date":"2023-01-04 00:00:00","insp_start_time":"1510","insp_end_time":"1550","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14730149","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03983669","upload_search_indicator":null,"census_search_date":"2023-01-05 21:41:00","snet_input_date":"2023-01-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-05 21:41:00","insp_carrier_name":"BOTANICA LA GITANA EMC LLC","insp_carrier_street":"9309 INTERNATIONAL BLVD","insp_carrier_city":"OAKLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"94603","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:48.000000Z","updated_at":"2025-03-17T19:04:48.000000Z","inspection_violations":[{"id":3218635,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_violation_id":"250415606","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR58470","created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3922"},{"id":3218636,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_violation_id":"250415607","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3922"},{"id":3218637,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_violation_id":"250415608","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192726446","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR58471","created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3939A"},{"id":3218638,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_violation_id":"250415609","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192726446","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR58471","created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3922"},{"id":3218639,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_violation_id":"250415610","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192726446","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR58471","created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3345643,"change_date":"2023-01-05 21:41:00","inspection_id":"77522285","insp_unit_id":"192726446","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT","insp_unit_license":"01326L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVM1MH686100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:58.000000Z","updated_at":"2025-03-17T22:29:58.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3983669\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3983669\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3983669\/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\/3983669\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}