{"current_page":1,"data":[{"id":12220614,"change_date":"2026-06-18 21:41:00","inspection_id":"88178346","dot_number":"2677422","report_state":"CA","report_number":"UEBM000427","insp_date":"2026-06-17 00:00:00","insp_start_time":"0943","insp_end_time":"1001","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","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":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"150300","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":"3569664","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545-3816","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:34.000000Z","updated_at":"2026-06-29T09:30:36.000000Z","inspection_violations":[{"id":21270555,"change_date":"2026-06-18 21:41:00","inspection_id":"88178346","insp_violation_id":"274989270","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214168881","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:48.000000Z","updated_at":"2026-06-29T09:42:17.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21223874,"change_date":"2026-06-18 21:41:00","inspection_id":"88178346","insp_unit_id":"214168881","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:23.000000Z","updated_at":"2026-06-29T09:01:30.000000Z"},{"id":21223875,"change_date":"2026-06-18 21:41:00","inspection_id":"88178346","insp_unit_id":"214168882","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":"FLAT BED","insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:23.000000Z","updated_at":"2026-06-29T09:01:30.000000Z"}]},{"id":11492782,"change_date":"2026-03-26 21:40:00","inspection_id":"87412551","dot_number":"2677422","report_state":"CA","report_number":"UFA3003347","insp_date":"2026-03-25 00:00:00","insp_start_time":"1300","insp_end_time":"1345","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":"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":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"150300","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":"16224911","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2026-03-29T09:54:23.000000Z","updated_at":"2026-04-06T09:34:22.000000Z","inspection_violations":[{"id":19404914,"change_date":"2026-03-26 21:40:00","inspection_id":"87412551","insp_violation_id":"272674001","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212366769","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RT 97133","created_at":"2026-03-29T10:23:45.000000Z","updated_at":"2026-04-06T09:55:56.000000Z","normalized_code":"3922SLLSR"},{"id":19404915,"change_date":"2026-03-26 21:40:00","inspection_id":"87412551","insp_violation_id":"272674002","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"212366769","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:45.000000Z","updated_at":"2026-04-06T09:55:56.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":19687528,"change_date":"2026-03-26 21:40:00","inspection_id":"87412551","insp_unit_id":"212366769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:16.000000Z"},{"id":19687529,"change_date":"2026-03-26 21:40:00","inspection_id":"87412551","insp_unit_id":"212366770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"4NE2236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH930VH9E1C20804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:16.000000Z"}]},{"id":10510723,"change_date":"2025-12-23 21:39:00","inspection_id":"86645904","dot_number":"2677422","report_state":"CA","report_number":"UED8001913","insp_date":"2025-12-23 00:00:00","insp_start_time":"1154","insp_end_time":"1218","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"SB I-680 WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"2025-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"150300","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":"16107505","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-12-23 21:39:00","snet_input_date":"2025-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-12-26T10:38:41.000000Z","updated_at":"2026-01-03T10:31:04.000000Z","inspection_violations":[{"id":17645991,"change_date":"2025-12-23 21:39:00","inspection_id":"86645904","insp_violation_id":"270882183","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210788246","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN34617","created_at":"2025-12-26T10:44:44.000000Z","updated_at":"2026-01-03T10:31:58.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17601741,"change_date":"2025-12-23 21:39:00","inspection_id":"86645904","insp_unit_id":"210788246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"34","insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:35.000000Z","updated_at":"2026-01-03T10:01:12.000000Z"},{"id":17601742,"change_date":"2025-12-23 21:39:00","inspection_id":"86645904","insp_unit_id":"210788247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":"2X BLK","insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:35.000000Z","updated_at":"2026-01-03T10:01:12.000000Z"}]},{"id":10425056,"change_date":"2025-12-12 21:41:00","inspection_id":"86556422","dot_number":"2677422","report_state":"CA","report_number":"NE8I004922","insp_date":"2025-12-10 00:00:00","insp_start_time":"1339","insp_end_time":"1410","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"DUBLIN AREA","county_code_state":"CA","county_code":"001","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139500","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":"16092951","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-12-15T10:32:16.000000Z","updated_at":"2025-12-23T10:31:15.000000Z","inspection_violations":[{"id":17479701,"change_date":"2025-12-12 21:41:00","inspection_id":"86556422","insp_violation_id":"270662689","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"210586952","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-15T10:34:00.000000Z","updated_at":"2025-12-23T10:32:13.000000Z","normalized_code":"39345B2BHTD"},{"id":17479702,"change_date":"2025-12-12 21:41:00","inspection_id":"86556422","insp_violation_id":"270662690","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210586952","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-12-15T10:34:00.000000Z","updated_at":"2025-12-23T10:32:13.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":17437077,"change_date":"2025-12-12 21:41:00","inspection_id":"86556422","insp_unit_id":"210586951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X\/RED","insp_unit_license":"9F16722","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD79X8ED239994","insp_unit_decal":"Y","insp_unit_decal_number":"35615836","created_at":"2025-12-15T10:02:49.000000Z","updated_at":"2025-12-23T10:01:25.000000Z"},{"id":17437078,"change_date":"2025-12-12 21:41:00","inspection_id":"86556422","insp_unit_id":"210586952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":"2X\/FLATBED","insp_unit_license":"4NE2236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH930VH9E1C20804","insp_unit_decal":"Y","insp_unit_decal_number":"35615840","created_at":"2025-12-15T10:02:49.000000Z","updated_at":"2025-12-23T10:01:25.000000Z"}]},{"id":9228211,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","dot_number":"2677422","report_state":"CA","report_number":"NE28006039","insp_date":"2025-07-17 00:00:00","insp_start_time":"1615","insp_end_time":"1710","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":"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-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"150300","viol_total":"5","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15911378","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-07-27T10:41:39.000000Z","updated_at":"2025-07-27T10:41:39.000000Z","inspection_violations":[{"id":14936132,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_violation_id":"267608325","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"208041578","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:44.000000Z","normalized_code":"3963A1BALAC"},{"id":14936133,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_violation_id":"267608326","seq_no":"2","part_no":"393","part_no_section":"47F-B","insp_viol_unit":"2","insp_unit_id":"208041579","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:44.000000Z","normalized_code":"39347FB"},{"id":14936134,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_violation_id":"267608327","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208041578","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:44.000000Z","normalized_code":"3963A1BOS"},{"id":14936135,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_violation_id":"267608328","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208041579","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:44.000000Z","normalized_code":"39375A3TAOL"},{"id":14936136,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_violation_id":"267608329","seq_no":"5","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-26T10:43:42.000000Z","updated_at":"2025-07-27T10:43:44.000000Z","normalized_code":"393130CCHVE"}],"inspection_per_units":[{"id":15183055,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_unit_id":"208041578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"34","insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"Y","insp_unit_decal_number":"35338754","created_at":"2025-07-26T09:46:33.000000Z","updated_at":"2025-07-27T09:46:19.000000Z"},{"id":15183056,"change_date":"2025-07-23 21:42:00","inspection_id":"85298931","insp_unit_id":"208041579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":"BLK 2X","insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"Y","insp_unit_decal_number":"35338755","created_at":"2025-07-26T09:46:33.000000Z","updated_at":"2025-07-27T09:46:19.000000Z"}]},{"id":9058457,"change_date":"2025-07-03 21:34:00","inspection_id":"85120085","dot_number":"2677422","report_state":"CA","report_number":"NC9Y006522","insp_date":"2025-07-02 00:00:00","insp_start_time":"1344","insp_end_time":"1402","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-03 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15885574","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-07-03 21:34:00","snet_input_date":"2025-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-03 21:34:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:36.000000Z","updated_at":"2025-07-07T10:07:36.000000Z","inspection_violations":[{"id":14578993,"change_date":"2025-07-03 21:34:00","inspection_id":"85120085","insp_violation_id":"267196969","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"207694017","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:57.000000Z","updated_at":"2025-07-07T10:15:45.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14862990,"change_date":"2025-07-03 21:34:00","inspection_id":"85120085","insp_unit_id":"207694017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/22","insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:19.000000Z","updated_at":"2025-07-07T09:45:29.000000Z"}]},{"id":8323328,"change_date":"2025-04-08 21:40:00","inspection_id":"84343988","dot_number":"2677422","report_state":"CA","report_number":"NE7S004505","insp_date":"2025-04-01 00:00:00","insp_start_time":"1350","insp_end_time":"1405","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15770592","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-04-11T10:12:31.000000Z","updated_at":"2025-04-12T10:23:17.000000Z","inspection_violations":[{"id":13099565,"change_date":"2025-04-08 21:40:00","inspection_id":"84343988","insp_violation_id":"265505883","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206210278","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:42:57.000000Z","updated_at":"2025-04-11T10:53:04.000000Z","normalized_code":"39395A4EEUS"},{"id":13099566,"change_date":"2025-04-08 21:40:00","inspection_id":"84343988","insp_violation_id":"265505884","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206210278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ00764","created_at":"2025-04-11T10:42:57.000000Z","updated_at":"2025-04-11T10:53:04.000000Z","normalized_code":"3922SLLSR"},{"id":13099567,"change_date":"2025-04-08 21:40:00","inspection_id":"84343988","insp_violation_id":"265505885","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"206210278","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RJ00764","created_at":"2025-04-11T10:42:57.000000Z","updated_at":"2025-04-11T10:53:04.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":13499193,"change_date":"2025-04-08 21:40:00","inspection_id":"84343988","insp_unit_id":"206210278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"WHITE\/2AX","insp_unit_license":"22706N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JV6J4S69285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:08:04.000000Z","updated_at":"2025-04-12T10:04:47.000000Z"}]},{"id":7948032,"change_date":"2025-02-24 21:40:00","inspection_id":"83949215","dot_number":"2677422","report_state":"CA","report_number":"NEAH004754","insp_date":"2025-02-20 00:00:00","insp_start_time":"1220","insp_end_time":"1252","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15713755","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12830445,"change_date":"2025-02-24 21:40:00","inspection_id":"83949215","insp_unit_id":"205474837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"22\/RED","insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"Y","insp_unit_decal_number":"34824090","created_at":"2025-03-17T23:56:45.000000Z","updated_at":"2025-03-17T23:56:45.000000Z"}]},{"id":7924346,"change_date":"2025-02-20 21:41:00","inspection_id":"83924348","dot_number":"2677422","report_state":"CA","report_number":"UE03003830","insp_date":"2025-02-19 00:00:00","insp_start_time":"1123","insp_end_time":"1153","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","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-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15710278","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-02-20 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-20 21:41:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:48.000000Z","updated_at":"2025-03-17T21:02:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12791784,"change_date":"2025-02-20 21:41:00","inspection_id":"83924348","insp_unit_id":"205429749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:19.000000Z","updated_at":"2025-03-17T23:56:19.000000Z"},{"id":12791785,"change_date":"2025-02-20 21:41:00","inspection_id":"83924348","insp_unit_id":"205429750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":null,"insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:19.000000Z","updated_at":"2025-03-17T23:56:19.000000Z"}]},{"id":7807070,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","dot_number":"2677422","report_state":"CA","report_number":"UCUF004101","insp_date":"2025-02-04 00:00:00","insp_start_time":"1425","insp_end_time":"1510","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15695406","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2025-02-06 21:41:00","snet_input_date":"2025-02-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-06 21:41:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T21:00:19.000000Z","updated_at":"2025-03-17T21:00:19.000000Z","inspection_violations":[{"id":12201646,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","insp_violation_id":"264386759","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"2","insp_unit_id":"205199819","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3922SLLEWA2"},{"id":12201647,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","insp_violation_id":"264386760","seq_no":"2","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"205199819","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 517608","created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39375A1TEPBM"},{"id":12201648,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","insp_violation_id":"264386761","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"205199819","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":12599366,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","insp_unit_id":"205199818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED.3X.TT","insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:10.000000Z","updated_at":"2025-03-17T23:54:10.000000Z"},{"id":12599367,"change_date":"2025-02-06 21:41:00","inspection_id":"83801382","insp_unit_id":"205199819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":"2X.ST","insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:10.000000Z","updated_at":"2025-03-17T23:54:10.000000Z"}]},{"id":7454901,"change_date":"2024-12-18 21:42:00","inspection_id":"83431341","dot_number":"2677422","report_state":"CA","report_number":"UEAO004771","insp_date":"2024-12-17 00:00:00","insp_start_time":"1226","insp_end_time":"1242","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","county_code_state":"CA","county_code":"001","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":"2024-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15635002","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2024-12-18 21:42:00","snet_input_date":"2024-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-18 21:42:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[{"id":11650718,"change_date":"2024-12-18 21:42:00","inspection_id":"83431341","insp_violation_id":"263560735","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204467266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12026783,"change_date":"2024-12-18 21:42:00","inspection_id":"83431341","insp_unit_id":"204467265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3XRED","insp_unit_license":"9F42090","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8GJ111908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"},{"id":12026784,"change_date":"2024-12-18 21:42:00","inspection_id":"83431341","insp_unit_id":"204467266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAND","insp_unit_company":"2XFB","insp_unit_license":"4NU1737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH440UH0G1A22835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":6566565,"change_date":"2024-08-26 21:43:00","inspection_id":"82489493","dot_number":"2677422","report_state":"CA","report_number":"NF9T000269","insp_date":"2024-08-23 00:00:00","insp_start_time":"0938","insp_end_time":"1012","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA","county_code_state":"CA","county_code":"095","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":"2024-08-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15496595","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2024-08-26 21:43:00","snet_input_date":"2024-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-26 21:43:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:10.000000Z","updated_at":"2025-03-17T20:33:10.000000Z","inspection_violations":[{"id":10205410,"change_date":"2024-08-26 21:43:00","inspection_id":"82489493","insp_violation_id":"261417539","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202592079","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ36655","created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3922"},{"id":10205411,"change_date":"2024-08-26 21:43:00","inspection_id":"82489493","insp_violation_id":"261417540","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202592079","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10586463,"change_date":"2024-08-26 21:43:00","inspection_id":"82489493","insp_unit_id":"202592079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"22\/3XRED","insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"}]},{"id":6178805,"change_date":"2024-07-09 21:44:00","inspection_id":"82075012","dot_number":"2677422","report_state":"CA","report_number":"NARW002476","insp_date":"2024-07-03 00:00:00","insp_start_time":"1144","insp_end_time":"1209","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2024-07-09 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15431977","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2024-07-09 21:44:00","snet_input_date":"2024-07-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-09 21:44:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9595800,"change_date":"2024-07-09 21:44:00","inspection_id":"82075012","insp_violation_id":"260550569","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201803423","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:25.000000Z","updated_at":"2025-03-17T21:52:25.000000Z","normalized_code":"3922"},{"id":9595801,"change_date":"2024-07-09 21:44:00","inspection_id":"82075012","insp_violation_id":"260550570","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201803423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:25.000000Z","updated_at":"2025-03-17T21:52:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9953869,"change_date":"2024-07-09 21:44:00","inspection_id":"82075012","insp_unit_id":"201803423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"WHT\/2X","insp_unit_license":"22706N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JV6J4S69285","insp_unit_decal":"Y","insp_unit_decal_number":"34152724","created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":5838676,"change_date":"2024-05-24 21:39:00","inspection_id":"81707261","dot_number":"2677422","report_state":"CA","report_number":"UBZ9001175","insp_date":"2024-05-24 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"ST VINCENT SCALE","county_code_state":"CA","county_code":"041","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":"2024-05-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"15378465","transaction_code":"A","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2024-05-24 21:39:00","snet_input_date":"2024-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-24 21:39:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:19.000000Z","updated_at":"2025-03-17T20:18:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9403214,"change_date":"2024-05-24 21:39:00","inspection_id":"81707261","insp_unit_id":"201077164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"38833B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYBS9CHBN7627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:35.000000Z","updated_at":"2025-03-17T23:20:35.000000Z"}]},{"id":3217103,"change_date":"2023-06-05 21:43:00","inspection_id":"78815642","dot_number":"2677422","report_state":"CA","report_number":"UDI1001317","insp_date":"2023-06-02 00:00:00","insp_start_time":"1435","insp_end_time":"1455","registration_date":null,"region":"PT","ci_status_code":"C","location":"211","location_desc":"ANTELOPE PLATFORM SCALE WB","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-06-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14929747","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2023-06-05 21:43:00","snet_input_date":"2023-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-05 21:43:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4957325,"change_date":"2023-06-05 21:43:00","inspection_id":"78815642","insp_violation_id":"253306144","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:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5173987,"change_date":"2023-06-05 21:43:00","inspection_id":"78815642","insp_unit_id":"195334111","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:46.000000Z","updated_at":"2025-03-17T22:43:46.000000Z"}]},{"id":2261326,"change_date":"2023-01-30 21:44:00","inspection_id":"77730886","dot_number":"2677422","report_state":"CA","report_number":"NE02002562","insp_date":"2023-01-24 00:00:00","insp_start_time":"1722","insp_end_time":"1749","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"14760478","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3640010,"change_date":"2023-01-30 21:44:00","inspection_id":"77730886","insp_unit_id":"193142248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/3X","insp_unit_license":"9F57321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X3HJ171970","insp_unit_decal":"Y","insp_unit_decal_number":"32147359","created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"},{"id":3640011,"change_date":"2023-01-30 21:44:00","inspection_id":"77730886","insp_unit_id":"193142249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FLATBED2X","insp_unit_license":"4RB9595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2459J5179201","insp_unit_decal":"Y","insp_unit_decal_number":"32147360","created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"}]},{"id":1933013,"change_date":"2022-12-12 21:44:00","inspection_id":"77355528","dot_number":"2677422","report_state":"CA","report_number":"NCCL004282","insp_date":"2022-12-06 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2022-12-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14703825","transaction_code":"A","transaction_date":"2022-12-06 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2022-12-12 21:44:00","snet_input_date":"2022-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-12 21:44:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T19:02:14.000000Z","updated_at":"2025-03-17T19:02:14.000000Z","inspection_violations":[{"id":3006255,"change_date":"2022-12-12 21:44:00","inspection_id":"77355528","insp_violation_id":"250069447","seq_no":"1","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3110812,"change_date":"2022-12-12 21:44:00","inspection_id":"77355528","insp_unit_id":"192396214","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"22RED3X","insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"Y","insp_unit_decal_number":"31826288","created_at":"2025-03-17T22:28:19.000000Z","updated_at":"2025-03-17T22:28:19.000000Z"}]},{"id":1863612,"change_date":"2022-12-02 21:41:00","inspection_id":"77276041","dot_number":"2677422","report_state":"CA","report_number":"NE8I001679","insp_date":"2022-11-28 00:00:00","insp_start_time":"1802","insp_end_time":"1852","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","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":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"14693302","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-11-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"292333","created_at":"2025-03-17T19:01:05.000000Z","updated_at":"2025-03-17T19:01:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2999185,"change_date":"2022-12-02 21:41:00","inspection_id":"77276041","insp_unit_id":"192240813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2308334","insp_unit_license":"9F16722","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD79X8ED239994","insp_unit_decal":"Y","insp_unit_decal_number":"31826441","created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"},{"id":2999186,"change_date":"2022-12-02 21:41:00","inspection_id":"77276041","insp_unit_id":"192240814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":"BLK FLATBED","insp_unit_license":"4NE2236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1LH930VH9E1C20804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"}]},{"id":439485,"change_date":"2022-05-19 21:42:00","inspection_id":"75616966","dot_number":"2677422","report_state":"CA","report_number":"UE74000969","insp_date":"2022-05-18 00:00:00","insp_start_time":"1025","insp_end_time":"1049","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":"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":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14435527","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02677422","upload_search_indicator":null,"census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"BIG JOE CALIFORNIA NORTH INC","insp_carrier_street":"25932 EDEN LANDING RD","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94545","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:12.000000Z","updated_at":"2025-03-17T18:35:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":708628,"change_date":"2022-05-19 21:42:00","inspection_id":"75616966","insp_unit_id":"188805718","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"32668F2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X0KM238920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:33.000000Z","updated_at":"2025-03-17T22:12:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2677422\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2677422\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2677422\/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\/2677422\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}