{"current_page":1,"data":[{"id":12661905,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","dot_number":"3174029","report_state":"CA","report_number":"NC7K011239","insp_date":"2026-08-06 00:00:00","insp_start_time":"0651","insp_end_time":"0736","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","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":"3930773","transaction_code":"A","transaction_date":"2026-08-07 00:00:00","upload_date":"2026-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-08-07 21:40:00","snet_input_date":"2026-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-07 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-11T09:42:00.000000Z","updated_at":"2026-08-18T09:30:31.000000Z","inspection_violations":[{"id":22044347,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_violation_id":"275989595","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"215034545","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-10T10:01:45.000000Z","updated_at":"2026-08-19T09:39:51.000000Z","normalized_code":"39347E"},{"id":22044348,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_violation_id":"275989596","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"215034545","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-10T10:01:45.000000Z","updated_at":"2026-08-19T09:39:51.000000Z","normalized_code":"39353BB"},{"id":22044349,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_violation_id":"275989597","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"215034545","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-10T10:01:45.000000Z","updated_at":"2026-08-19T09:39:51.000000Z","normalized_code":"39345DB"},{"id":22044346,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_violation_id":"275989594","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"215034545","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-10T10:01:45.000000Z","updated_at":"2026-08-19T09:39:51.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":21977682,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_unit_id":"215034545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5258\/GLD 3X","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-10T09:19:45.000000Z","updated_at":"2026-08-18T09:01:41.000000Z"},{"id":21977683,"change_date":"2026-08-07 21:40:00","inspection_id":"88634540","insp_unit_id":"215034546","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"PBT","insp_unit_company":"0316\/RFR 2X","insp_unit_license":"3119952","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XPBAP8X5ND759306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-10T09:19:45.000000Z","updated_at":"2026-08-18T09:01:41.000000Z"}]},{"id":12639157,"change_date":"2026-08-05 21:42:00","inspection_id":"88610679","dot_number":"3174029","report_state":"CA","report_number":"NEID004119","insp_date":"2026-08-03 00:00:00","insp_start_time":"2005","insp_end_time":"2030","registration_date":null,"region":"PD","ci_status_code":"C","location":"366","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-08-05 21:42: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":"3910425","transaction_code":"A","transaction_date":"2026-08-05 00:00:00","upload_date":"2026-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-08-05 21:42:00","snet_input_date":"2026-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-05 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-08-08T09:41:10.000000Z","updated_at":"2026-08-16T09:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21940231,"change_date":"2026-08-05 21:42:00","inspection_id":"88610679","insp_unit_id":"214991135","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"5504336","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS253XT2635025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-08T09:18:46.000000Z","updated_at":"2026-08-16T09:02:31.000000Z"},{"id":21940230,"change_date":"2026-08-05 21:42:00","inspection_id":"88610679","insp_unit_id":"214991134","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"Y","insp_unit_decal_number":"36518946","created_at":"2026-08-08T09:18:46.000000Z","updated_at":"2026-08-16T09:02:31.000000Z"}]},{"id":12052015,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","dot_number":"3174029","report_state":"CA","report_number":"UCV0001546","insp_date":"2026-05-29 00:00:00","insp_start_time":"0739","insp_end_time":"0808","registration_date":null,"region":"PS","ci_status_code":"C","location":"881","location_desc":"CA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"3428570","transaction_code":"A","transaction_date":"2026-05-29 00:00:00","upload_date":"2026-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-05-29 21:40:00","snet_input_date":"2026-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-29 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-06-02T09:39:58.000000Z","updated_at":"2026-06-09T09:31:12.000000Z","inspection_violations":[{"id":20971017,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","insp_violation_id":"274583244","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213820802","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:22.000000Z","updated_at":"2026-06-09T09:42:45.000000Z","normalized_code":"3922SLLEQP"},{"id":20971018,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","insp_violation_id":"274583245","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"213820803","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:22.000000Z","updated_at":"2026-06-09T09:42:45.000000Z","normalized_code":"3939ALCL"},{"id":20971019,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","insp_violation_id":"274583246","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"213820803","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-02T09:58:22.000000Z","updated_at":"2026-06-09T09:42:45.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":20946413,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","insp_unit_id":"213820803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"493578","insp_unit_license":"88797AK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532T2554231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:00.000000Z","updated_at":"2026-06-09T09:02:32.000000Z"},{"id":20946412,"change_date":"2026-05-29 21:40:00","inspection_id":"87993207","insp_unit_id":"213820802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F889225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-02T09:17:00.000000Z","updated_at":"2026-06-09T09:02:32.000000Z"}]},{"id":11703823,"change_date":"2026-04-20 21:39:00","inspection_id":"87630371","dot_number":"3174029","report_state":"CA","report_number":"UFHG000365","insp_date":"2026-04-18 00:00:00","insp_start_time":"2015","insp_end_time":"2105","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":"2026-04-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16254948","transaction_code":"A","transaction_date":"2026-04-18 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-04-20 21:39:00","snet_input_date":"2026-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-20 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-04-27T09:36:59.000000Z","updated_at":"2026-05-01T09:31:52.000000Z","inspection_violations":[{"id":20337083,"change_date":"2026-04-20 21:39:00","inspection_id":"87630371","insp_violation_id":"273734783","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213126985","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"3922SLLEQP"},{"id":20337084,"change_date":"2026-04-20 21:39:00","inspection_id":"87630371","insp_violation_id":"273734784","seq_no":"2","part_no":"393","part_no_section":"75A3-TALS","insp_viol_unit":"2","insp_unit_id":"213126986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"39375A3TALS"}],"inspection_per_units":[{"id":20367689,"change_date":"2026-04-20 21:39:00","inspection_id":"87630371","insp_unit_id":"213126985","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260\/GRY","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"Y","insp_unit_decal_number":"36184795","created_at":"2026-04-27T09:12:52.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"},{"id":20367690,"change_date":"2026-04-20 21:39:00","inspection_id":"87630371","insp_unit_id":"213126986","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5323556","insp_unit_license":"5204975","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0621RW531945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:52.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"}]},{"id":11667453,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","dot_number":"3174029","report_state":"CA","report_number":"NC7K010904","insp_date":"2026-04-14 00:00:00","insp_start_time":"0634","insp_end_time":"0714","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16249987","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:50.000000Z","updated_at":"2026-04-27T09:31:50.000000Z","inspection_violations":[{"id":20265862,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_violation_id":"273654151","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"213057688","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:28.000000Z","updated_at":"2026-04-27T09:45:28.000000Z","normalized_code":"3939ALCL"},{"id":20265859,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_violation_id":"273654148","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213057687","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:28.000000Z","updated_at":"2026-04-27T09:45:28.000000Z","normalized_code":"3939ALIL"},{"id":20265860,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_violation_id":"273654149","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213057687","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA733072","created_at":"2026-04-27T09:45:28.000000Z","updated_at":"2026-04-27T09:45:28.000000Z","normalized_code":"39375A3TAOL"},{"id":20265861,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_violation_id":"273654150","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"213057687","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA733073","created_at":"2026-04-27T09:45:28.000000Z","updated_at":"2026-04-27T09:45:28.000000Z","normalized_code":"39345B2BHTD"},{"id":20265863,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_violation_id":"273654152","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"213057688","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:28.000000Z","updated_at":"2026-04-27T09:45:28.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20295748,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_unit_id":"213057687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259\/RED 3X","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:01.000000Z","updated_at":"2026-04-27T09:05:01.000000Z"},{"id":20295749,"change_date":"2026-04-16 21:41:00","inspection_id":"87597847","insp_unit_id":"213057688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"3557\/RFR 2X","insp_unit_license":"5204976","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0623RW531946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:01.000000Z","updated_at":"2026-04-27T09:05:01.000000Z"}]},{"id":11402837,"change_date":"2026-03-17 21:40:00","inspection_id":"87317914","dot_number":"3174029","report_state":"CA","report_number":"UFHG000283","insp_date":"2026-03-15 00:00:00","insp_start_time":"2010","insp_end_time":"2115","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":"2026-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16211900","transaction_code":"A","transaction_date":"2026-03-15 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-03-17 21:40:00","snet_input_date":"2026-03-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-17 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-03-20T09:42:51.000000Z","updated_at":"2026-03-28T09:32:05.000000Z","inspection_violations":[{"id":19223806,"change_date":"2026-03-17 21:40:00","inspection_id":"87317914","insp_violation_id":"272463952","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"212191050","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ35420","created_at":"2026-03-20T10:04:05.000000Z","updated_at":"2026-03-28T09:48:59.000000Z","normalized_code":"39345B2BHTD"},{"id":19223807,"change_date":"2026-03-17 21:40:00","inspection_id":"87317914","insp_violation_id":"272463953","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"212191050","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35420","created_at":"2026-03-20T10:04:05.000000Z","updated_at":"2026-03-28T09:48:59.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":19529668,"change_date":"2026-03-17 21:40:00","inspection_id":"87317914","insp_unit_id":"212191050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:36.000000Z","updated_at":"2026-03-28T09:06:50.000000Z"},{"id":19529669,"change_date":"2026-03-17 21:40:00","inspection_id":"87317914","insp_unit_id":"212191051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"492587","insp_unit_license":"24218AL","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2539T2554209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:36.000000Z","updated_at":"2026-03-28T09:06:50.000000Z"}]},{"id":11348621,"change_date":"2026-03-11 21:39:00","inspection_id":"87266628","dot_number":"3174029","report_state":"CA","report_number":"NC7K010776","insp_date":"2026-03-10 00:00:00","insp_start_time":"0738","insp_end_time":"0805","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","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":"16204187","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19421533,"change_date":"2026-03-11 21:39:00","inspection_id":"87266628","insp_unit_id":"212092817","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5258\/TAN 3X","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:32.000000Z"},{"id":19421534,"change_date":"2026-03-11 21:39:00","inspection_id":"87266628","insp_unit_id":"212092818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"8509\/RFR 2X","insp_unit_license":"3118660","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4829KL017305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:32.000000Z"}]},{"id":11301441,"change_date":"2026-03-05 21:40:00","inspection_id":"87217190","dot_number":"3174029","report_state":"CA","report_number":"NBH6007684","insp_date":"2026-03-03 00:00:00","insp_start_time":"0825","insp_end_time":"0859","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"16194602","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-03-05 21:40:00","snet_input_date":"2026-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-05 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-03-08T09:44:16.000000Z","updated_at":"2026-03-16T09:31:09.000000Z","inspection_violations":[{"id":19010936,"change_date":"2026-03-05 21:40:00","inspection_id":"87217190","insp_violation_id":"272230368","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211994664","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:52.000000Z","updated_at":"2026-03-16T09:41:52.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":19331719,"change_date":"2026-03-05 21:40:00","inspection_id":"87217190","insp_unit_id":"211994664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5258","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:20.000000Z","updated_at":"2026-03-16T09:04:23.000000Z"},{"id":19331720,"change_date":"2026-03-05 21:40:00","inspection_id":"87217190","insp_unit_id":"211994665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5326254","insp_unit_license":"5504330","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2534T2635019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:20.000000Z","updated_at":"2026-03-16T09:04:23.000000Z"}]},{"id":11220352,"change_date":"2026-02-24 21:40:00","inspection_id":"87132049","dot_number":"3174029","report_state":"CA","report_number":"UDBH004019","insp_date":"2026-02-24 00:00:00","insp_start_time":"0544","insp_end_time":"0603","registration_date":null,"region":"PT","ci_status_code":"C","location":"360","location_desc":"LAKEVILLE RD N OF SR37","county_code_state":"CA","county_code":"097","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"16181158","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:38:10.000000Z","updated_at":"2026-03-07T10:31:15.000000Z","inspection_violations":[{"id":18817856,"change_date":"2026-02-24 21:40:00","inspection_id":"87132049","insp_violation_id":"271997108","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-27T10:54:05.000000Z","updated_at":"2026-03-07T10:40:57.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":19165851,"change_date":"2026-02-24 21:40:00","inspection_id":"87132049","insp_unit_id":"211804869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:27.000000Z","updated_at":"2026-03-07T10:04:12.000000Z"},{"id":19165852,"change_date":"2026-02-24 21:40:00","inspection_id":"87132049","insp_unit_id":"211804870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"2552064","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4824GL006798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:27.000000Z","updated_at":"2026-03-07T10:04:12.000000Z"}]},{"id":11230040,"change_date":"2026-02-25 21:49:00","inspection_id":"87142189","dot_number":"3174029","report_state":"CA","report_number":"UD6V001179","insp_date":"2026-02-23 00:00:00","insp_start_time":"1016","insp_end_time":"1034","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE CVEF","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":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"16184681","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2026-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:31.000000Z","updated_at":"2026-03-08T09:32:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19196222,"change_date":"2026-02-25 21:49:00","inspection_id":"87142189","insp_unit_id":"211839475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3 AXL RED","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:24.000000Z","updated_at":"2026-03-08T09:07:30.000000Z"},{"id":19196223,"change_date":"2026-02-25 21:49:00","inspection_id":"87142189","insp_unit_id":"211839476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"5504337","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2531T2635026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:24.000000Z","updated_at":"2026-03-08T09:07:30.000000Z"}]},{"id":11229749,"change_date":"2026-02-25 21:49:00","inspection_id":"87141890","dot_number":"3174029","report_state":"CA","report_number":"UC2Q002994","insp_date":"2026-02-22 00:00:00","insp_start_time":"0605","insp_end_time":"0625","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EASTBOUND","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":"2026-02-25 21:49: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":"16184234","transaction_code":"A","transaction_date":"2026-02-22 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2026-02-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2026-02-28T10:39:31.000000Z","updated_at":"2026-03-08T09:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19195787,"change_date":"2026-02-25 21:49:00","inspection_id":"87141890","insp_unit_id":"211838999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X GRY","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:24.000000Z","updated_at":"2026-03-08T09:07:27.000000Z"},{"id":19195788,"change_date":"2026-02-25 21:49:00","inspection_id":"87141890","insp_unit_id":"211839000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X VN WHT","insp_unit_license":"3119959","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2532L2734938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:24.000000Z","updated_at":"2026-03-08T09:07:27.000000Z"}]},{"id":11071202,"change_date":"2026-02-06 21:39:00","inspection_id":"86981831","dot_number":"3174029","report_state":"CA","report_number":"NA5N009128","insp_date":"2026-02-05 00:00:00","insp_start_time":"0652","insp_end_time":"0721","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, 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":"2026-02-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"16160276","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2026-02-06 21:39:00","snet_input_date":"2026-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-06 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-10T10:37:25.000000Z","updated_at":"2026-02-17T10:31:11.000000Z","inspection_violations":[{"id":18531003,"change_date":"2026-02-06 21:39:00","inspection_id":"86981831","insp_violation_id":"271652399","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"1","insp_unit_id":"211493394","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:51:05.000000Z","updated_at":"2026-02-17T10:39:53.000000Z","normalized_code":"3922SLLEWG2"},{"id":18531004,"change_date":"2026-02-06 21:39:00","inspection_id":"86981831","insp_violation_id":"271652400","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"211493395","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ79168","created_at":"2026-02-10T10:51:05.000000Z","updated_at":"2026-02-17T10:39:53.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":18877518,"change_date":"2026-02-06 21:39:00","inspection_id":"86981831","insp_unit_id":"211493394","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:36.000000Z","updated_at":"2026-02-17T10:04:31.000000Z"},{"id":18877519,"change_date":"2026-02-06 21:39:00","inspection_id":"86981831","insp_unit_id":"211493395","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X VAN","insp_unit_license":"5482646","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2536T2580721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:36.000000Z","updated_at":"2026-02-17T10:04:31.000000Z"}]},{"id":10500412,"change_date":"2025-12-22 21:39:00","inspection_id":"86635212","dot_number":"3174029","report_state":"CA","report_number":"NDKW008663","insp_date":"2025-12-16 00:00:00","insp_start_time":"2008","insp_end_time":"2038","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-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"16104408","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-12-22 21:39:00","snet_input_date":"2025-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-22 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-12-25T10:37:49.000000Z","updated_at":"2026-01-02T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17582402,"change_date":"2025-12-22 21:39:00","inspection_id":"86635212","insp_unit_id":"210761774","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"Y","insp_unit_decal_number":"35618468","created_at":"2025-12-25T10:08:46.000000Z","updated_at":"2026-01-02T10:01:18.000000Z"},{"id":17582403,"change_date":"2025-12-22 21:39:00","inspection_id":"86635212","insp_unit_id":"210761775","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"5504321","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2538T2635010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:46.000000Z","updated_at":"2026-01-02T10:01:18.000000Z"}]},{"id":10442110,"change_date":"2025-12-15 21:40:00","inspection_id":"86574260","dot_number":"3174029","report_state":"CA","report_number":"NDKW008612","insp_date":"2025-12-02 00:00:00","insp_start_time":"2014","insp_end_time":"2030","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":"TRADER JOES","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"16093945","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:48.000000Z","updated_at":"2025-12-26T10:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17469111,"change_date":"2025-12-15 21:40:00","inspection_id":"86574260","insp_unit_id":"210622429","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:40.000000Z","updated_at":"2025-12-26T10:01:31.000000Z"},{"id":17469112,"change_date":"2025-12-15 21:40:00","inspection_id":"86574260","insp_unit_id":"210622430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5326045","insp_unit_license":"5482631","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS253XT2580706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:40.000000Z","updated_at":"2025-12-26T10:01:31.000000Z"}]},{"id":10321791,"change_date":"2025-12-01 21:39:00","inspection_id":"86448519","dot_number":"3174029","report_state":"CA","report_number":"NDKW008567","insp_date":"2025-11-18 00:00:00","insp_start_time":"2020","insp_end_time":"2050","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-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16074958","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-12-04T10:30:42.000000Z","updated_at":"2025-12-05T10:31:34.000000Z","inspection_violations":[{"id":17266035,"change_date":"2025-12-01 21:39:00","inspection_id":"86448519","insp_violation_id":"270376898","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210338157","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"SC11938","created_at":"2025-12-04T10:31:09.000000Z","updated_at":"2025-12-05T10:32:14.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17237670,"change_date":"2025-12-01 21:39:00","inspection_id":"86448519","insp_unit_id":"210338158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5326058","insp_unit_license":"5482644","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2538T2580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:45.000000Z","updated_at":"2025-12-05T10:01:55.000000Z"},{"id":17237669,"change_date":"2025-12-01 21:39:00","inspection_id":"86448519","insp_unit_id":"210338157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260 \/ GRY","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:45.000000Z","updated_at":"2025-12-05T10:01:55.000000Z"}]},{"id":10323606,"change_date":"2025-12-01 21:39:00","inspection_id":"86450360","dot_number":"3174029","report_state":"CA","report_number":"UCK0003154","insp_date":"2025-11-18 00:00:00","insp_start_time":"2139","insp_end_time":"2148","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"16075514","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-12-04T10:30:45.000000Z","updated_at":"2025-12-05T10:31:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17240538,"change_date":"2025-12-01 21:39:00","inspection_id":"86450360","insp_unit_id":"210341159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:47.000000Z","updated_at":"2025-12-05T10:02:11.000000Z"},{"id":17240539,"change_date":"2025-12-01 21:39:00","inspection_id":"86450360","insp_unit_id":"210341160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5326058","insp_unit_license":"5482644","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2538T2580719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:47.000000Z","updated_at":"2025-12-05T10:02:11.000000Z"}]},{"id":10325799,"change_date":"2025-12-01 21:40:00","inspection_id":"86452615","dot_number":"3174029","report_state":"CA","report_number":"UFHG000075","insp_date":"2025-11-15 00:00:00","insp_start_time":"2015","insp_end_time":"2040","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-12-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79850","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":"16074474","transaction_code":"A","transaction_date":"2025-11-15 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-12-01 21:40:00","snet_input_date":"2025-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-12-04T10:30:48.000000Z","updated_at":"2025-12-05T10:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17243960,"change_date":"2025-12-01 21:40:00","inspection_id":"86452615","insp_unit_id":"210344757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5260","insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:50.000000Z","updated_at":"2025-12-05T10:02:29.000000Z"},{"id":17243961,"change_date":"2025-12-01 21:40:00","inspection_id":"86452615","insp_unit_id":"210344758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"491896","insp_unit_license":"88796AK","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2536T2554202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:50.000000Z","updated_at":"2025-12-05T10:02:29.000000Z"}]},{"id":9774185,"change_date":"2025-09-24 21:42:00","inspection_id":"85872187","dot_number":"3174029","report_state":"CA","report_number":"UCK0003060","insp_date":"2025-09-23 00:00:00","insp_start_time":"2008","insp_end_time":"2028","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15993812","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-09-26T10:01:20.000000Z","updated_at":"2025-09-28T10:00:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16192543,"change_date":"2025-09-24 21:42:00","inspection_id":"85872187","insp_unit_id":"209134142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"Y","insp_unit_decal_number":"35339601","created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:27.000000Z"},{"id":16192544,"change_date":"2025-09-24 21:42:00","inspection_id":"85872187","insp_unit_id":"209134143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"5482642","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2534T2580717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:27.000000Z"}]},{"id":9280923,"change_date":"2025-07-29 21:40:00","inspection_id":"85354231","dot_number":"3174029","report_state":"CA","report_number":"UF73003026","insp_date":"2025-07-27 00:00:00","insp_start_time":"1836","insp_end_time":"1900","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-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15918159","transaction_code":"A","transaction_date":"2025-07-27 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-07-29 21:40:00","snet_input_date":"2025-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-29 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-08-01T10:42:12.000000Z","updated_at":"2025-08-04T10:01:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15278706,"change_date":"2025-07-29 21:40:00","inspection_id":"85354231","insp_unit_id":"208144805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:51.000000Z","updated_at":"2025-08-02T09:46:19.000000Z"},{"id":15278707,"change_date":"2025-07-29 21:40:00","inspection_id":"85354231","insp_unit_id":"208144806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TM9008","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539N2659805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:51.000000Z","updated_at":"2025-08-02T09:46:19.000000Z"}]},{"id":9209683,"change_date":"2025-07-21 21:42:00","inspection_id":"85279308","dot_number":"3174029","report_state":"CA","report_number":"UEEE002952","insp_date":"2025-07-20 00:00:00","insp_start_time":"2015","insp_end_time":"2021","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-21 21:42: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":"15907303","transaction_code":"A","transaction_date":"2025-07-20 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-07-21 21:42:00","snet_input_date":"2025-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-21 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:36.000000Z","updated_at":"2025-07-25T10:45:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15140898,"change_date":"2025-07-21 21:42:00","inspection_id":"85279308","insp_unit_id":"207995677","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9H15724","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0NN271154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:40.000000Z","updated_at":"2025-07-25T09:46:30.000000Z"},{"id":15140899,"change_date":"2025-07-21 21:42:00","inspection_id":"85279308","insp_unit_id":"207995678","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5201360","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0620RW531936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:40.000000Z","updated_at":"2025-07-25T09:46:30.000000Z"}]},{"id":9241883,"change_date":"2025-07-24 21:41:00","inspection_id":"85313128","dot_number":"3174029","report_state":"CA","report_number":"UE2C005780","insp_date":"2025-07-19 00:00:00","insp_start_time":"1830","insp_end_time":"1900","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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-07-24 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":"15912910","transaction_code":"A","transaction_date":"2025-07-19 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:59.000000Z","updated_at":"2025-07-30T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15207638,"change_date":"2025-07-24 21:41:00","inspection_id":"85313128","insp_unit_id":"208067988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:35.000000Z","updated_at":"2025-07-28T09:46:26.000000Z"},{"id":15207639,"change_date":"2025-07-24 21:41:00","inspection_id":"85313128","insp_unit_id":"208067989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CCRR","insp_unit_company":"2X REF","insp_unit_license":"5451669","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4826SL047040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:35.000000Z","updated_at":"2025-07-28T09:46:26.000000Z"}]},{"id":8573567,"change_date":"2025-05-07 21:47:00","inspection_id":"84607693","dot_number":"3174029","report_state":"CA","report_number":"UDPO000534","insp_date":"2025-05-04 00:00:00","insp_start_time":"1837","insp_end_time":"1853","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-05-07 21:47: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":"15809338","transaction_code":"A","transaction_date":"2025-05-04 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-05-07 21:47:00","snet_input_date":"2025-05-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-07 21:47:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T11:03:32.000000Z","updated_at":"2025-05-11T10:22:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13992294,"change_date":"2025-05-07 21:47:00","inspection_id":"84607693","insp_unit_id":"206746831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:49:36.000000Z","updated_at":"2025-05-11T04:03:40.000000Z"},{"id":13992295,"change_date":"2025-05-07 21:47:00","inspection_id":"84607693","insp_unit_id":"206746832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5204988","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A062XRW531958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:49:36.000000Z","updated_at":"2025-05-11T04:03:40.000000Z"}]},{"id":8443734,"change_date":"2025-04-22 21:41:00","inspection_id":"84471090","dot_number":"3174029","report_state":"CA","report_number":"UCK0002766","insp_date":"2025-04-19 00:00:00","insp_start_time":"2021","insp_end_time":"2028","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-22 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":"15790185","transaction_code":"A","transaction_date":"2025-04-19 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-04-26T10:27:35.000000Z","updated_at":"2025-04-26T10:27:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13713463,"change_date":"2025-04-22 21:41:00","inspection_id":"84471090","insp_unit_id":"206442291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:16:12.000000Z","updated_at":"2025-04-26T10:09:56.000000Z"},{"id":13713464,"change_date":"2025-04-22 21:41:00","inspection_id":"84471090","insp_unit_id":"206442292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315462","insp_unit_license":"2452467","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0628FW704677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:16:12.000000Z","updated_at":"2025-04-26T10:09:56.000000Z"}]},{"id":8233284,"change_date":"2025-03-27 21:42:00","inspection_id":"84249186","dot_number":"3174029","report_state":"CA","report_number":"NFDT000748","insp_date":"2025-03-26 00:00:00","insp_start_time":"1020","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"2025-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15758177","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:55.000000Z","updated_at":"2025-03-31T10:32:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13318997,"change_date":"2025-03-27 21:42:00","inspection_id":"84249186","insp_unit_id":"206036691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X GOLD","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"Y","insp_unit_decal_number":"34767516","created_at":"2025-03-30T10:33:08.000000Z","updated_at":"2025-03-31T10:14:58.000000Z"},{"id":13318998,"change_date":"2025-03-27 21:42:00","inspection_id":"84249186","insp_unit_id":"206036692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X VAN","insp_unit_license":"2561074","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2538GU714803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:33:08.000000Z","updated_at":"2025-03-31T10:14:58.000000Z"}]},{"id":8865699,"change_date":"2025-06-10 21:41:00","inspection_id":"84916361","dot_number":"3174029","report_state":"CA","report_number":"UDK7003786","insp_date":"2025-03-16 00:00:00","insp_start_time":"1835","insp_end_time":"1850","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":"2025-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15856012","transaction_code":"A","transaction_date":"2025-03-16 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-06-10 21:41:00","snet_input_date":"2025-03-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-10 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:49.000000Z","updated_at":"2025-06-14T10:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14519082,"change_date":"2025-06-10 21:41:00","inspection_id":"84916361","insp_unit_id":"207319558","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P967422","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2535L2934602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:47.000000Z","updated_at":"2025-06-14T09:46:01.000000Z"},{"id":14519081,"change_date":"2025-06-10 21:41:00","inspection_id":"84916361","insp_unit_id":"207319557","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:47.000000Z","updated_at":"2025-06-14T09:46:01.000000Z"}]},{"id":7913403,"change_date":"2025-02-19 21:41:00","inspection_id":"83912923","dot_number":"3174029","report_state":"CA","report_number":"UFWH001006","insp_date":"2025-02-19 00:00:00","insp_start_time":"0930","insp_end_time":"1007","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"WB SR-140 JEO I-5","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARICH CONFECTIONARY CO","shipping_paper_number":"021925TJS 1","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-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15709065","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[{"id":12363906,"change_date":"2025-02-19 21:41:00","inspection_id":"83912923","insp_violation_id":"264601498","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK83699","created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"3922SLLED"},{"id":12363907,"change_date":"2025-02-19 21:41:00","inspection_id":"83912923","insp_violation_id":"264601499","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":12773781,"change_date":"2025-02-19 21:41:00","inspection_id":"83912923","insp_unit_id":"205408165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"},{"id":12773782,"change_date":"2025-02-19 21:41:00","inspection_id":"83912923","insp_unit_id":"205408166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5323712","insp_unit_license":"5152392","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3UTVS2532R8988410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7959260,"change_date":"2025-02-25 21:40:00","inspection_id":"83960928","dot_number":"3174029","report_state":"CA","report_number":"UD1D000848","insp_date":"2025-02-05 00:00:00","insp_start_time":"2010","insp_end_time":"2025","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15715603","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-02-25 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-25 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T21:03:19.000000Z","updated_at":"2025-03-17T21:03:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12848544,"change_date":"2025-02-25 21:40:00","inspection_id":"83960928","insp_unit_id":"205496131","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"},{"id":12848545,"change_date":"2025-02-25 21:40:00","inspection_id":"83960928","insp_unit_id":"205496132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2X REF","insp_unit_license":"2452467","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0628FW704677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:55.000000Z","updated_at":"2025-03-17T23:56:55.000000Z"}]},{"id":7538813,"change_date":"2025-01-02 21:39:00","inspection_id":"83519473","dot_number":"3174029","report_state":"CA","report_number":"UE2C005058","insp_date":"2024-12-28 00:00:00","insp_start_time":"1800","insp_end_time":"1830","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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-01-02 21:39: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":"15646785","transaction_code":"A","transaction_date":"2024-12-28 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:14.000000Z","updated_at":"2025-03-17T20:53:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12162922,"change_date":"2025-01-02 21:39:00","inspection_id":"83519473","insp_unit_id":"204632192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4VNC9EH9FN90827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"},{"id":12162923,"change_date":"2025-01-02 21:39:00","inspection_id":"83519473","insp_unit_id":"204632193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"2X REF","insp_unit_license":"2452446","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0620FW704656","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"}]},{"id":7118665,"change_date":"2024-11-04 21:41:00","inspection_id":"83076736","dot_number":"3174029","report_state":"CA","report_number":"NCNG008401","insp_date":"2024-10-30 00:00:00","insp_start_time":"2009","insp_end_time":"2035","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":"TRADERS JOE'S","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":"2024-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15581407","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:44:19.000000Z","updated_at":"2025-03-17T20:44:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11481594,"change_date":"2024-11-04 21:41:00","inspection_id":"83076736","insp_unit_id":"203731924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"Y","insp_unit_decal_number":"34474204","created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"},{"id":11481595,"change_date":"2024-11-04 21:41:00","inspection_id":"83076736","insp_unit_id":"203731925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315435","insp_unit_license":"3233319","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0625FW704653","insp_unit_decal":"Y","insp_unit_decal_number":"34474205","created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"}]},{"id":6991898,"change_date":"2024-10-18 21:42:00","inspection_id":"82942198","dot_number":"3174029","report_state":"CA","report_number":"UCOM000298","insp_date":"2024-10-15 00:00:00","insp_start_time":"0610","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15559616","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11277477,"change_date":"2024-10-18 21:42:00","inspection_id":"82942198","insp_unit_id":"203478965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X TAN","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"Y","insp_unit_decal_number":"34470472","created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"},{"id":11277478,"change_date":"2024-10-18 21:42:00","inspection_id":"82942198","insp_unit_id":"203478966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X","insp_unit_license":"2346336","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483EU932402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:46.000000Z","updated_at":"2025-03-17T23:39:46.000000Z"}]},{"id":6983386,"change_date":"2024-10-17 21:42:00","inspection_id":"82933140","dot_number":"3174029","report_state":"CA","report_number":"UFYK000100","insp_date":"2024-10-13 00:00:00","insp_start_time":"1921","insp_end_time":"1942","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580 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":"2024-10-17 21:42: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":"15559497","transaction_code":"A","transaction_date":"2024-10-13 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-10-17 21:42:00","snet_input_date":"2024-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-17 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:46.000000Z","updated_at":"2025-03-17T20:41:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11263571,"change_date":"2024-10-17 21:42:00","inspection_id":"82933140","insp_unit_id":"203461329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHI #5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4VNC9EH9FN90827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:34.000000Z","updated_at":"2025-03-17T23:39:34.000000Z"},{"id":11263572,"change_date":"2024-10-17 21:42:00","inspection_id":"82933140","insp_unit_id":"203461330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"2X WHI VAN","insp_unit_license":"2552069","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4824GL006803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:34.000000Z","updated_at":"2025-03-17T23:39:34.000000Z"}]},{"id":6935172,"change_date":"2024-10-10 21:42:00","inspection_id":"82881919","dot_number":"3174029","report_state":"CA","report_number":"NC7K009262","insp_date":"2024-10-09 00:00:00","insp_start_time":"1150","insp_end_time":"1225","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","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":"15551514","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10811246,"change_date":"2024-10-10 21:42:00","inspection_id":"82881919","insp_violation_id":"262297533","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"203362773","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":11185198,"change_date":"2024-10-10 21:42:00","inspection_id":"82881919","insp_unit_id":"203362773","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5258\/TAN 3X","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"},{"id":11185199,"change_date":"2024-10-10 21:42:00","inspection_id":"82881919","insp_unit_id":"203362774","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"10\/RFR 2X","insp_unit_license":"2346336","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483EU932402","insp_unit_decal":"Y","insp_unit_decal_number":"34469926","created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"}]},{"id":6935453,"change_date":"2024-10-10 21:42:00","inspection_id":"82882205","dot_number":"3174029","report_state":"CA","report_number":"NEYV001031","insp_date":"2024-10-09 00:00:00","insp_start_time":"0820","insp_end_time":"0855","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118351","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15551501","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10811551,"change_date":"2024-10-10 21:42:00","inspection_id":"82882205","insp_violation_id":"262297866","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203363244","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA389139","created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11185640,"change_date":"2024-10-10 21:42:00","inspection_id":"82882205","insp_unit_id":"203363244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X\/5258\/GOL","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"},{"id":11185641,"change_date":"2024-10-10 21:42:00","inspection_id":"82882205","insp_unit_id":"203363245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X\/10\/WHT","insp_unit_license":"2346336","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483EU932402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"}]},{"id":6906717,"change_date":"2024-10-07 21:41:00","inspection_id":"82851660","dot_number":"3174029","report_state":"CA","report_number":"UDK7003420","insp_date":"2024-10-05 00:00:00","insp_start_time":"2015","insp_end_time":"2030","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":"2024-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15547775","transaction_code":"A","transaction_date":"2024-10-05 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-10-07 21:41:00","snet_input_date":"2024-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:40:13.000000Z","updated_at":"2025-03-17T20:40:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11138932,"change_date":"2024-10-07 21:41:00","inspection_id":"82851660","insp_unit_id":"203305788","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"},{"id":11138933,"change_date":"2024-10-07 21:41:00","inspection_id":"82851660","insp_unit_id":"203305789","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5204993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0623RW531963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"}]},{"id":6840303,"change_date":"2024-09-27 21:40:00","inspection_id":"82781103","dot_number":"3174029","report_state":"CA","report_number":"UE2C004767","insp_date":"2024-09-26 00:00:00","insp_start_time":"1900","insp_end_time":"1930","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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":"2024-09-27 21:40: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":"15536486","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11031087,"change_date":"2024-09-27 21:40:00","inspection_id":"82781103","insp_unit_id":"203171267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"},{"id":11031088,"change_date":"2024-09-27 21:40:00","inspection_id":"82781103","insp_unit_id":"203171268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X REF","insp_unit_license":"2454142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2481FU410109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6541882,"change_date":"2024-08-22 21:43:00","inspection_id":"82463170","dot_number":"3174029","report_state":"CA","report_number":"NE28005077","insp_date":"2024-08-21 00:00:00","insp_start_time":"1842","insp_end_time":"1900","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":"TRADER JOES","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-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15492210","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-08-22 21:43:00","snet_input_date":"2024-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:32:45.000000Z","updated_at":"2025-03-17T20:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10545944,"change_date":"2024-08-22 21:43:00","inspection_id":"82463170","insp_unit_id":"202541564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"},{"id":10545945,"change_date":"2024-08-22 21:43:00","inspection_id":"82463170","insp_unit_id":"202541565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5323573","insp_unit_license":"5204992","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0621RW531962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"}]},{"id":6372977,"change_date":"2024-08-01 21:42:00","inspection_id":"82282843","dot_number":"3174029","report_state":"CA","report_number":"UE2C004616","insp_date":"2024-07-27 00:00:00","insp_start_time":"1830","insp_end_time":"1900","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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":"2024-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15468356","transaction_code":"A","transaction_date":"2024-07-27 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-08-01 21:42:00","snet_input_date":"2024-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-01 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:07.000000Z","updated_at":"2025-03-17T20:29:07.000000Z","inspection_violations":[{"id":9893782,"change_date":"2024-08-01 21:42:00","inspection_id":"82282843","insp_violation_id":"260976911","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202200304","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA518742","created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10269870,"change_date":"2024-08-01 21:42:00","inspection_id":"82282843","insp_unit_id":"202200303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"},{"id":10269871,"change_date":"2024-08-01 21:42:00","inspection_id":"82282843","insp_unit_id":"202200304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X REF","insp_unit_license":"P967428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2536L2934608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6339855,"change_date":"2024-07-29 21:42:00","inspection_id":"82247382","dot_number":"3174029","report_state":"CA","report_number":"UEAO004380","insp_date":"2024-07-26 00:00:00","insp_start_time":"2137","insp_end_time":"2150","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":"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":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15462787","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:19.000000Z","updated_at":"2025-03-17T20:28:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10216106,"change_date":"2024-07-29 21:42:00","inspection_id":"82247382","insp_unit_id":"202132149","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"},{"id":10216107,"change_date":"2024-07-29 21:42:00","inspection_id":"82247382","insp_unit_id":"202132150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X","insp_unit_license":"2339995","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483EU823504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"}]},{"id":6323777,"change_date":"2024-07-26 21:40:00","inspection_id":"82230224","dot_number":"3174029","report_state":"CA","report_number":"UE2C004608","insp_date":"2024-07-25 00:00:00","insp_start_time":"1800","insp_end_time":"1830","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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":"2024-07-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15460033","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-07-26 21:40:00","snet_input_date":"2024-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-26 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:13.000000Z","updated_at":"2025-03-17T20:28:13.000000Z","inspection_violations":[{"id":9818841,"change_date":"2024-07-26 21:40:00","inspection_id":"82230224","insp_violation_id":"260871645","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"202100268","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA518737","created_at":"2025-03-17T21:53:28.000000Z","updated_at":"2025-03-17T21:53:28.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":10189608,"change_date":"2024-07-26 21:40:00","inspection_id":"82230224","insp_unit_id":"202100268","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X TAN","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:31.000000Z","updated_at":"2025-03-17T23:28:31.000000Z"},{"id":10189609,"change_date":"2024-07-26 21:40:00","inspection_id":"82230224","insp_unit_id":"202100269","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X REF","insp_unit_license":"2339995","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483EU823504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:31.000000Z","updated_at":"2025-03-17T23:28:31.000000Z"}]},{"id":6181371,"change_date":"2024-07-09 21:44:00","inspection_id":"82077665","dot_number":"3174029","report_state":"CA","report_number":"UEAO004359","insp_date":"2024-07-05 00:00:00","insp_start_time":"1902","insp_end_time":"1914","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":"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":"2024-07-09 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15432342","transaction_code":"A","transaction_date":"2024-07-05 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-07-09 21:44:00","snet_input_date":"2024-07-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-09 21:44:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:20.000000Z","updated_at":"2025-03-17T20:25:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9957803,"change_date":"2024-07-09 21:44:00","inspection_id":"82077665","insp_unit_id":"201807686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XWHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:11.000000Z","updated_at":"2025-03-17T23:26:11.000000Z"},{"id":9957804,"change_date":"2024-07-09 21:44:00","inspection_id":"82077665","insp_unit_id":"201807687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X","insp_unit_license":"2452994","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2488FU410222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:11.000000Z","updated_at":"2025-03-17T23:26:11.000000Z"}]},{"id":6122563,"change_date":"2024-07-01 21:45:00","inspection_id":"82014342","dot_number":"3174029","report_state":"CA","report_number":"UCOB005963","insp_date":"2024-06-28 00:00:00","insp_start_time":"0826","insp_end_time":"0841","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","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":"2024-07-01 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15425736","transaction_code":"A","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-07-01 21:45:00","snet_input_date":"2024-06-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-01 21:45:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:10.000000Z","updated_at":"2025-03-17T20:24:10.000000Z","inspection_violations":[{"id":9506760,"change_date":"2024-07-01 21:45:00","inspection_id":"82014342","insp_violation_id":"260420839","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201686583","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9861943,"change_date":"2024-07-01 21:45:00","inspection_id":"82014342","insp_unit_id":"201686582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:11.000000Z","updated_at":"2025-03-17T23:25:11.000000Z"},{"id":9861944,"change_date":"2024-07-01 21:45:00","inspection_id":"82014342","insp_unit_id":"201686583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"2552060","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4827GL006794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:11.000000Z","updated_at":"2025-03-17T23:25:11.000000Z"}]},{"id":6030317,"change_date":"2024-06-19 21:38:00","inspection_id":"81915094","dot_number":"3174029","report_state":"CA","report_number":"UD89003050","insp_date":"2024-06-18 00:00:00","insp_start_time":"1835","insp_end_time":"1858","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-19 21:38: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":"15410512","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-06-19 21:38:00","snet_input_date":"2024-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-19 21:38:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9712662,"change_date":"2024-06-19 21:38:00","inspection_id":"81915094","insp_unit_id":"201492526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:39.000000Z","updated_at":"2025-03-17T23:23:39.000000Z"},{"id":9712663,"change_date":"2024-06-19 21:38:00","inspection_id":"81915094","insp_unit_id":"201492527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"48114B","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"527SR5322FL006407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:39.000000Z","updated_at":"2025-03-17T23:23:39.000000Z"}]},{"id":6029812,"change_date":"2024-06-19 21:38:00","inspection_id":"81914575","dot_number":"3174029","report_state":"CA","report_number":"NE28004814","insp_date":"2024-06-13 00:00:00","insp_start_time":"1840","insp_end_time":"1855","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":"WCD STOCKTON #71648","shipping_paper_number":"305458190113","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-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15411161","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-06-19 21:38:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-19 21:38:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9711930,"change_date":"2024-06-19 21:38:00","inspection_id":"81914575","insp_unit_id":"201491705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:38.000000Z","updated_at":"2025-03-17T23:23:38.000000Z"},{"id":9711931,"change_date":"2024-06-19 21:38:00","inspection_id":"81914575","insp_unit_id":"201491706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315410","insp_unit_license":"2452844","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0626FE702089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:38.000000Z","updated_at":"2025-03-17T23:23:38.000000Z"}]},{"id":5160199,"change_date":"2024-02-28 21:42:00","inspection_id":"80968192","dot_number":"3174029","report_state":"CA","report_number":"NCAT003857","insp_date":"2024-02-27 00:00:00","insp_start_time":"1845","insp_end_time":"1903","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":"WCD STOCKTON","shipping_paper_number":"0699077","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15260097","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8308364,"change_date":"2024-02-28 21:42:00","inspection_id":"80968192","insp_unit_id":"199652919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:17.000000Z","updated_at":"2025-03-17T23:10:17.000000Z"},{"id":8308365,"change_date":"2024-02-28 21:42:00","inspection_id":"80968192","insp_unit_id":"199652920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"5220957","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0620FW704690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:17.000000Z","updated_at":"2025-03-17T23:10:17.000000Z"}]},{"id":5065932,"change_date":"2024-02-15 21:43:00","inspection_id":"80865396","dot_number":"3174029","report_state":"CA","report_number":"NCNG007415","insp_date":"2024-02-14 00:00:00","insp_start_time":"1910","insp_end_time":"1930","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":"TRADER JOES","shipping_paper_number":"00128*150500000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15238176","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8154910,"change_date":"2024-02-15 21:43:00","inspection_id":"80865396","insp_unit_id":"199453763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"},{"id":8154911,"change_date":"2024-02-15 21:43:00","inspection_id":"80865396","insp_unit_id":"199453764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315466","insp_unit_license":"2452471","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XFW704681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"}]},{"id":4844045,"change_date":"2024-01-16 21:45:00","inspection_id":"80622617","dot_number":"3174029","report_state":"CA","report_number":"UD89002722","insp_date":"2024-01-15 00:00:00","insp_start_time":"1835","insp_end_time":"1855","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:45: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":"15200556","transaction_code":"A","transaction_date":"2024-01-15 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:58:48.000000Z","updated_at":"2025-03-17T19:58:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7793718,"change_date":"2024-01-16 21:45:00","inspection_id":"80622617","insp_unit_id":"198983798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"},{"id":7793719,"change_date":"2024-01-16 21:45:00","inspection_id":"80622617","insp_unit_id":"198983799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"7779ZB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2534FU423519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"}]},{"id":8579336,"change_date":"2025-05-08 21:41:00","inspection_id":"80571462","dot_number":"3174029","report_state":"CA","report_number":"NEID001851","insp_date":"2024-01-08 00:00:00","insp_start_time":"1839","insp_end_time":"1845","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-08 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":"15192798","transaction_code":"C","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2025-05-08 21:41:00","snet_input_date":"2024-01-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-09 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-05-11T10:21:14.000000Z","updated_at":"2025-05-12T10:03:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14002489,"change_date":"2025-05-08 21:41:00","inspection_id":"80571462","insp_unit_id":"206764743","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:57:45.000000Z","updated_at":"2025-05-12T09:50:09.000000Z"},{"id":14002490,"change_date":"2025-05-08 21:41:00","inspection_id":"80571462","insp_unit_id":"206764744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452855","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0621FE702100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:57:45.000000Z","updated_at":"2025-05-12T09:50:09.000000Z"}]},{"id":4758824,"change_date":"2024-01-03 21:44:00","inspection_id":"80529410","dot_number":"3174029","report_state":"CA","report_number":"NE28004238","insp_date":"2024-01-02 00:00:00","insp_start_time":"1833","insp_end_time":"1850","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":"TRADER JOES","shipping_paper_number":"287709167122","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15186649","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-01-03 21:44:00","snet_input_date":"2024-01-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7655740,"change_date":"2024-01-03 21:44:00","inspection_id":"80529410","insp_unit_id":"198801142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:26.000000Z","updated_at":"2025-03-17T23:04:26.000000Z"},{"id":7655741,"change_date":"2024-01-03 21:44:00","inspection_id":"80529410","insp_unit_id":"198801143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"120254","insp_unit_license":"481181B","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"527SR5324FL006411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:26.000000Z","updated_at":"2025-03-17T23:04:26.000000Z"}]},{"id":4777654,"change_date":"2024-01-05 21:46:00","inspection_id":"80550113","dot_number":"3174029","report_state":"CA","report_number":"NCAT003653","insp_date":"2023-12-28 00:00:00","insp_start_time":"1843","insp_end_time":"1856","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":"TRADER JOES","shipping_paper_number":"281613293*15*1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"15189187","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2024-01-05 21:46:00","snet_input_date":"2023-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:57:18.000000Z","updated_at":"2025-03-17T19:57:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7686335,"change_date":"2024-01-05 21:46:00","inspection_id":"80550113","insp_unit_id":"198845767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259\/RED","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:43.000000Z","updated_at":"2025-03-17T23:04:43.000000Z"},{"id":7686336,"change_date":"2024-01-05 21:46:00","inspection_id":"80550113","insp_unit_id":"198845768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452484","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0628FW704694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:43.000000Z","updated_at":"2025-03-17T23:04:43.000000Z"}]},{"id":4606199,"change_date":"2023-12-11 21:42:00","inspection_id":"80362659","dot_number":"3174029","report_state":"CA","report_number":"NEID001757","insp_date":"2023-12-07 00:00:00","insp_start_time":"1850","insp_end_time":"1859","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-11 21:42: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":"15161182","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-12-11 21:42:00","snet_input_date":"2023-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-11 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:54:10.000000Z","updated_at":"2025-03-17T19:54:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7408966,"change_date":"2023-12-11 21:42:00","inspection_id":"80362659","insp_unit_id":"198454772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:16.000000Z","updated_at":"2025-03-17T23:02:16.000000Z"},{"id":7408967,"change_date":"2023-12-11 21:42:00","inspection_id":"80362659","insp_unit_id":"198454773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452494","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0627FW704704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:16.000000Z","updated_at":"2025-03-17T23:02:16.000000Z"}]},{"id":4582926,"change_date":"2023-12-07 21:41:00","inspection_id":"80337104","dot_number":"3174029","report_state":"CA","report_number":"NCAT003545","insp_date":"2023-12-06 00:00:00","insp_start_time":"1840","insp_end_time":"1853","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":"TRADER JOES","shipping_paper_number":"5057789*14*0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"15157655","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-12-07 21:41:00","snet_input_date":"2023-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-07 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[{"id":7089135,"change_date":"2023-12-07 21:41:00","inspection_id":"80337104","insp_violation_id":"256778405","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198406601","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7371346,"change_date":"2023-12-07 21:41:00","inspection_id":"80337104","insp_unit_id":"198406601","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:57.000000Z","updated_at":"2025-03-17T23:01:57.000000Z"},{"id":7371347,"change_date":"2023-12-07 21:41:00","inspection_id":"80337104","insp_unit_id":"198406602","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452494","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0627FW704704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:57.000000Z","updated_at":"2025-03-17T23:01:57.000000Z"}]},{"id":4155638,"change_date":"2023-10-09 21:36:00","inspection_id":"79865670","dot_number":"3174029","report_state":"CA","report_number":"UCOB005083","insp_date":"2023-10-05 00:00:00","insp_start_time":"0919","insp_end_time":"0946","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"2023-10-09 21:36: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":"15089476","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:58.000000Z","updated_at":"2025-03-17T19:44:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6682088,"change_date":"2023-10-09 21:36:00","inspection_id":"79865670","insp_unit_id":"197462782","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"},{"id":6682089,"change_date":"2023-10-09 21:36:00","inspection_id":"79865670","insp_unit_id":"197462783","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"2923403","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2487J6380806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"}]},{"id":4051685,"change_date":"2023-09-25 21:41:00","inspection_id":"79750108","dot_number":"3174029","report_state":"CA","report_number":"UEEE001872","insp_date":"2023-09-23 00:00:00","insp_start_time":"2000","insp_end_time":"2006","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15073932","transaction_code":"A","transaction_date":"2023-09-23 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-09-25 21:41:00","snet_input_date":"2023-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:49.000000Z","updated_at":"2025-03-17T19:42:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6514952,"change_date":"2023-09-25 21:41:00","inspection_id":"79750108","insp_unit_id":"197228914","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:39.000000Z","updated_at":"2025-03-17T22:54:39.000000Z"}]},{"id":3968309,"change_date":"2023-09-13 21:41:00","inspection_id":"79657600","dot_number":"3174029","report_state":"CA","report_number":"UD89002451","insp_date":"2023-09-12 00:00:00","insp_start_time":"1830","insp_end_time":"1853","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-13 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":"15059625","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-09-13 21:41:00","snet_input_date":"2023-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-13 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:41:12.000000Z","updated_at":"2025-03-17T19:41:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6381059,"change_date":"2023-09-13 21:41:00","inspection_id":"79657600","insp_unit_id":"197042951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:36.000000Z","updated_at":"2025-03-17T22:53:36.000000Z"},{"id":6381060,"change_date":"2023-09-13 21:41:00","inspection_id":"79657600","insp_unit_id":"197042952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452851","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0623FE702096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:36.000000Z","updated_at":"2025-03-17T22:53:36.000000Z"}]},{"id":3907760,"change_date":"2023-09-05 21:41:00","inspection_id":"79590245","dot_number":"3174029","report_state":"CA","report_number":"UEX8003321","insp_date":"2023-09-01 00:00:00","insp_start_time":"2050","insp_end_time":"2110","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15050192","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-09-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:05.000000Z","updated_at":"2025-03-17T19:40:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6283291,"change_date":"2023-09-05 21:41:00","inspection_id":"79590245","insp_unit_id":"196907526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:47.000000Z","updated_at":"2025-03-17T22:52:47.000000Z"},{"id":6283292,"change_date":"2023-09-05 21:41:00","inspection_id":"79590245","insp_unit_id":"196907527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"2552051","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4826GL006785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:47.000000Z","updated_at":"2025-03-17T22:52:47.000000Z"}]},{"id":3892725,"change_date":"2023-09-01 21:40:00","inspection_id":"79573526","dot_number":"3174029","report_state":"CA","report_number":"UEX8003308","insp_date":"2023-08-26 00:00:00","insp_start_time":"1910","insp_end_time":"1930","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:40: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":"15047624","transaction_code":"A","transaction_date":"2023-08-26 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-09-01 21:40:00","snet_input_date":"2023-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-01 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:44.000000Z","updated_at":"2025-03-17T19:39:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6258534,"change_date":"2023-09-01 21:40:00","inspection_id":"79573526","insp_unit_id":"196874621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:34.000000Z","updated_at":"2025-03-17T22:52:34.000000Z"},{"id":6258535,"change_date":"2023-09-01 21:40:00","inspection_id":"79573526","insp_unit_id":"196874622","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"2452985","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2487FU410213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:34.000000Z","updated_at":"2025-03-17T22:52:34.000000Z"}]},{"id":3370901,"change_date":"2023-06-26 21:41:00","inspection_id":"78988922","dot_number":"3174029","report_state":"CA","report_number":"UEEE001686","insp_date":"2023-06-24 00:00:00","insp_start_time":"2010","insp_end_time":"2016","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14959000","transaction_code":"A","transaction_date":"2023-06-24 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-06-26 21:41:00","snet_input_date":"2023-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:46.000000Z","updated_at":"2025-03-17T19:29:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5418835,"change_date":"2023-06-26 21:41:00","inspection_id":"78988922","insp_unit_id":"195686239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:44.000000Z","updated_at":"2025-03-17T22:45:44.000000Z"},{"id":5418836,"change_date":"2023-06-26 21:41:00","inspection_id":"78988922","insp_unit_id":"195686240","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452467","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0628FW704677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:44.000000Z","updated_at":"2025-03-17T22:45:44.000000Z"}]},{"id":3061298,"change_date":"2023-05-16 21:43:00","inspection_id":"78639762","dot_number":"3174029","report_state":"CA","report_number":"UF73001391","insp_date":"2023-05-13 00:00:00","insp_start_time":"2012","insp_end_time":"2026","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14900652","transaction_code":"A","transaction_date":"2023-05-13 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-05-16 21:43:00","snet_input_date":"2023-05-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:23:44.000000Z","updated_at":"2025-03-17T19:23:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4925066,"change_date":"2023-05-16 21:43:00","inspection_id":"78639762","insp_unit_id":"194968460","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:50.000000Z","updated_at":"2025-03-17T22:41:50.000000Z"},{"id":4925067,"change_date":"2023-05-16 21:43:00","inspection_id":"78639762","insp_unit_id":"194968461","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452492","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0623FW704702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:50.000000Z","updated_at":"2025-03-17T22:41:50.000000Z"}]},{"id":3007092,"change_date":"2023-05-09 21:43:00","inspection_id":"78578615","dot_number":"3174029","report_state":"CA","report_number":"NEID001033","insp_date":"2023-05-02 00:00:00","insp_start_time":"1825","insp_end_time":"1852","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":"2023-05-09 21:43: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":"14892696","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4838537,"change_date":"2023-05-09 21:43:00","inspection_id":"78578615","insp_unit_id":"194844645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5259","insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"},{"id":4838538,"change_date":"2023-05-09 21:43:00","inspection_id":"78578615","insp_unit_id":"194844646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5","insp_unit_license":"2452437","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XFW704647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":2938773,"change_date":"2023-05-01 21:40:00","inspection_id":"78501315","dot_number":"3174029","report_state":"CA","report_number":"UEEE001568","insp_date":"2023-04-29 00:00:00","insp_start_time":"2020","insp_end_time":"2026","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-01 21:40: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":"14880167","transaction_code":"A","transaction_date":"2023-04-29 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-05-01 21:40:00","snet_input_date":"2023-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-01 21:40:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:57.000000Z","updated_at":"2025-03-17T19:20:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4728452,"change_date":"2023-05-01 21:40:00","inspection_id":"78501315","insp_unit_id":"194690756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G84133","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH8KN903961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:16.000000Z","updated_at":"2025-03-17T22:40:16.000000Z"},{"id":4728453,"change_date":"2023-05-01 21:40:00","inspection_id":"78501315","insp_unit_id":"194690757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452473","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0623FW704683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:16.000000Z","updated_at":"2025-03-17T22:40:16.000000Z"}]},{"id":2835203,"change_date":"2023-04-18 21:42:00","inspection_id":"78384059","dot_number":"3174029","report_state":"CA","report_number":"UEX8002883","insp_date":"2023-04-13 00:00:00","insp_start_time":"1845","insp_end_time":"1905","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14860510","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-04-18 21:42:00","snet_input_date":"2023-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4563569,"change_date":"2023-04-18 21:42:00","inspection_id":"78384059","insp_unit_id":"194460988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4563570,"change_date":"2023-04-18 21:42:00","inspection_id":"78384059","insp_unit_id":"194460989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"2923401","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2483J6380804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2660657,"change_date":"2023-03-24 21:41:00","inspection_id":"78185200","dot_number":"3174029","report_state":"CA","report_number":"UDBL001932","insp_date":"2023-03-22 00:00:00","insp_start_time":"0807","insp_end_time":"0826","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","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":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","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":"14832201","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:15:49.000000Z","updated_at":"2025-03-17T19:15:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4283617,"change_date":"2023-03-24 21:41:00","inspection_id":"78185200","insp_unit_id":"194063611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XGLD","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"},{"id":4283618,"change_date":"2023-03-24 21:41:00","inspection_id":"78185200","insp_unit_id":"194063612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2XWHTVAN","insp_unit_license":"2250004","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2538DU753452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2547857,"change_date":"2023-03-09 21:43:00","inspection_id":"78057061","dot_number":"3174029","report_state":"CA","report_number":"UBGJ004622","insp_date":"2023-03-06 00:00:00","insp_start_time":"1912","insp_end_time":"1940","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","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":"2023-03-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14813511","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-03-09 21:43:00","snet_input_date":"2023-03-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-09 21:43:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:41.000000Z","updated_at":"2025-03-17T19:13:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4101120,"change_date":"2023-03-09 21:43:00","inspection_id":"78057061","insp_unit_id":"193802314","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"#5258","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"},{"id":4101121,"change_date":"2023-03-09 21:43:00","inspection_id":"78057061","insp_unit_id":"193802315","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"2X\/VAN","insp_unit_license":"2552065","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4826GL006799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":2527711,"change_date":"2023-03-07 21:42:00","inspection_id":"78034257","dot_number":"3174029","report_state":"CA","report_number":"NDA2004684","insp_date":"2023-03-02 00:00:00","insp_start_time":"2000","insp_end_time":"2025","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":"2023-03-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"14810284","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-03-07 21:42:00","snet_input_date":"2023-03-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4068706,"change_date":"2023-03-07 21:42:00","inspection_id":"78034257","insp_unit_id":"193757131","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"Y","insp_unit_decal_number":"32137848","created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"},{"id":4068707,"change_date":"2023-03-07 21:42:00","inspection_id":"78034257","insp_unit_id":"193757132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"S5313059","insp_unit_license":"5122818","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2533DU753424","insp_unit_decal":"Y","insp_unit_decal_number":"32137849","created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":2248534,"change_date":"2023-01-27 21:41:00","inspection_id":"77716496","dot_number":"3174029","report_state":"CA","report_number":"UE2C003232","insp_date":"2023-01-25 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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":"2023-01-27 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":"14759287","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:07.000000Z","updated_at":"2025-03-17T19:08:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3619245,"change_date":"2023-01-27 21:41:00","inspection_id":"77716496","insp_unit_id":"193114314","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X GLD","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"},{"id":3619246,"change_date":"2023-01-27 21:41:00","inspection_id":"77716496","insp_unit_id":"193114315","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X REF","insp_unit_license":"2452977","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2488FU410205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":2307795,"change_date":"2023-02-06 21:42:00","inspection_id":"77783667","dot_number":"3174029","report_state":"CA","report_number":"N9FF000890","insp_date":"2022-12-09 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"265","location_desc":"STOCKTON","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"14772551","transaction_code":"A","transaction_date":"2022-12-09 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2022-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:09:14.000000Z","updated_at":"2025-03-17T19:09:14.000000Z","inspection_violations":[{"id":3557637,"change_date":"2023-02-06 21:42:00","inspection_id":"77783667","insp_violation_id":"250979736","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193256717","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":3715032,"change_date":"2023-02-06 21:42:00","inspection_id":"77783667","insp_unit_id":"193256717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5258","insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"Y","insp_unit_decal_number":"31814703","created_at":"2025-03-17T22:32:37.000000Z","updated_at":"2025-03-17T22:32:37.000000Z"}]},{"id":2307796,"change_date":"2023-02-06 21:42:00","inspection_id":"77783668","dot_number":"3174029","report_state":"CA","report_number":"N9FF000891","insp_date":"2022-12-09 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"265","location_desc":"STOCKTON","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"14771237","transaction_code":"A","transaction_date":"2022-12-09 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2022-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"ESMERALDA & BROS TRANSPORT INC","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"618165","created_at":"2025-03-17T19:09:14.000000Z","updated_at":"2025-03-17T19:09:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3715033,"change_date":"2023-02-06 21:42:00","inspection_id":"77783668","insp_unit_id":"193256718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"Y","insp_unit_decal_number":"31814704","created_at":"2025-03-17T22:32:37.000000Z","updated_at":"2025-03-17T22:32:37.000000Z"}]},{"id":1243627,"change_date":"2022-09-08 21:39:00","inspection_id":"76561013","dot_number":"3174029","report_state":"CA","report_number":"NE28002542","insp_date":"2022-09-07 00:00:00","insp_start_time":"2049","insp_end_time":"2111","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":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14585896","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:49:41.000000Z","updated_at":"2025-03-17T18:49:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2001454,"change_date":"2022-09-08 21:39:00","inspection_id":"76561013","insp_unit_id":"190798289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"},{"id":2001455,"change_date":"2022-09-08 21:39:00","inspection_id":"76561013","insp_unit_id":"190798290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315432","insp_unit_license":"2452437","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XFW704647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":1002198,"change_date":"2022-08-09 21:41:00","inspection_id":"76279927","dot_number":"3174029","report_state":"CA","report_number":"UE9B001319","insp_date":"2022-08-07 00:00:00","insp_start_time":"2003","insp_end_time":"2036","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14539146","transaction_code":"A","transaction_date":"2022-08-07 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:45:24.000000Z","updated_at":"2025-03-17T18:45:24.000000Z","inspection_violations":[{"id":1578906,"change_date":"2022-08-09 21:41:00","inspection_id":"76279927","insp_violation_id":"247617354","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190225301","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"39360D"},{"id":1578907,"change_date":"2022-08-09 21:41:00","inspection_id":"76279927","insp_violation_id":"247617355","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190225301","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":1612488,"change_date":"2022-08-09 21:41:00","inspection_id":"76279927","insp_unit_id":"190225301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"},{"id":1612489,"change_date":"2022-08-09 21:41:00","inspection_id":"76279927","insp_unit_id":"190225302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2X WHT","insp_unit_license":"2452455","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0621FW704665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"}]},{"id":869045,"change_date":"2022-07-21 21:40:00","inspection_id":"76124280","dot_number":"3174029","report_state":"CA","report_number":"UD89001652","insp_date":"2022-07-20 00:00:00","insp_start_time":"1835","insp_end_time":"1852","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-21 21:40: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":"14515608","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-07-21 21:40:00","snet_input_date":"2022-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-21 21:40:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1399120,"change_date":"2022-07-21 21:40:00","inspection_id":"76124280","insp_unit_id":"189907509","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"},{"id":1399121,"change_date":"2022-07-21 21:40:00","inspection_id":"76124280","insp_unit_id":"189907510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452839","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0627FE702084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"}]},{"id":519819,"change_date":"2022-05-31 21:42:00","inspection_id":"75712778","dot_number":"3174029","report_state":"CA","report_number":"UD89001527","insp_date":"2022-05-28 00:00:00","insp_start_time":"1835","insp_end_time":"1856","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:42: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":"14450289","transaction_code":"A","transaction_date":"2022-05-28 00:00:00","upload_date":"2022-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-05-31 21:42:00","snet_input_date":"2022-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-31 21:42:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:36:44.000000Z","updated_at":"2025-03-17T18:36:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":836590,"change_date":"2022-05-31 21:42:00","inspection_id":"75712778","insp_unit_id":"189004937","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"},{"id":836591,"change_date":"2022-05-31 21:42:00","inspection_id":"75712778","insp_unit_id":"189004938","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"48114B","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"527SR5322FL006407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":238904,"change_date":"2022-04-22 21:47:00","inspection_id":"75377844","dot_number":"3174029","report_state":"CA","report_number":"UBYV001366","insp_date":"2022-04-21 00:00:00","insp_start_time":"1830","insp_end_time":"1840","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:47: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":"14397106","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-04-22 21:47:00","snet_input_date":"2022-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-22 21:47:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:31:37.000000Z","updated_at":"2025-03-17T18:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":387355,"change_date":"2022-04-22 21:47:00","inspection_id":"75377844","insp_unit_id":"188305214","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9E39118","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH5BN298295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"},{"id":387356,"change_date":"2022-04-22 21:47:00","inspection_id":"75377844","insp_unit_id":"188305215","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"U67786","insp_unit_license":"2613630","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2530FU377011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"}]},{"id":219354,"change_date":"2022-04-20 21:45:00","inspection_id":"75354669","dot_number":"3174029","report_state":"CA","report_number":"UBYV001363","insp_date":"2022-04-19 00:00:00","insp_start_time":"1851","insp_end_time":"1905","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-20 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14393637","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-04-20 21:45:00","snet_input_date":"2022-04-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-20 21:45:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:31:17.000000Z","updated_at":"2025-03-17T18:31:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":355894,"change_date":"2022-04-20 21:45:00","inspection_id":"75354669","insp_unit_id":"188260450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"},{"id":355895,"change_date":"2022-04-20 21:45:00","inspection_id":"75354669","insp_unit_id":"188260451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452856","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0623FE702101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:19.000000Z","updated_at":"2025-03-17T22:10:19.000000Z"}]},{"id":189780,"change_date":"2022-04-15 21:38:00","inspection_id":"75319315","dot_number":"3174029","report_state":"CA","report_number":"NE28001967","insp_date":"2022-04-14 00:00:00","insp_start_time":"1832","insp_end_time":"1846","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":"2022-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14387761","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-04-15 21:38:00","snet_input_date":"2022-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-15 21:38:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:30:51.000000Z","updated_at":"2025-03-17T18:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":307332,"change_date":"2022-04-15 21:38:00","inspection_id":"75319315","insp_unit_id":"188186790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:02.000000Z","updated_at":"2025-03-17T22:10:02.000000Z"},{"id":307333,"change_date":"2022-04-15 21:38:00","inspection_id":"75319315","insp_unit_id":"188186791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315436","insp_unit_license":"2452441","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0621FW704651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:02.000000Z","updated_at":"2025-03-17T22:10:02.000000Z"}]},{"id":125092,"change_date":"2022-04-06 21:41:00","inspection_id":"75241917","dot_number":"3174029","report_state":"CA","report_number":"UC7X001025","insp_date":"2022-04-04 00:00:00","insp_start_time":"2013","insp_end_time":"2030","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":"2022-04-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14374268","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-04-06 21:41:00","snet_input_date":"2022-04-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-06 21:41:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:29:48.000000Z","updated_at":"2025-03-17T18:29:48.000000Z","inspection_violations":[{"id":185088,"change_date":"2022-04-06 21:41:00","inspection_id":"75241917","insp_violation_id":"245016325","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188031153","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":202518,"change_date":"2022-04-06 21:41:00","inspection_id":"75241917","insp_unit_id":"188031153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XWHT","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:26.000000Z","updated_at":"2025-03-17T22:09:26.000000Z"},{"id":202519,"change_date":"2022-04-06 21:41:00","inspection_id":"75241917","insp_unit_id":"188031154","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2X","insp_unit_license":"2452441","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0621FW704651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:26.000000Z","updated_at":"2025-03-17T22:09:26.000000Z"}]},{"id":66907,"change_date":"2022-03-29 21:42:00","inspection_id":"75170004","dot_number":"3174029","report_state":"CA","report_number":"NE28001883","insp_date":"2022-03-28 00:00:00","insp_start_time":"2020","insp_end_time":"2038","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":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14362479","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"533389","created_at":"2025-03-17T18:28:47.000000Z","updated_at":"2025-03-17T18:28:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":108870,"change_date":"2022-03-29 21:42:00","inspection_id":"75170004","insp_unit_id":"187884548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5257","insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:53.000000Z","updated_at":"2025-03-17T22:08:53.000000Z"},{"id":108871,"change_date":"2022-03-29 21:42:00","inspection_id":"75170004","insp_unit_id":"187884549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"S5315470","insp_unit_license":"2452475","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0627FW704685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:53.000000Z","updated_at":"2025-03-17T22:08:53.000000Z"}]},{"id":6698,"change_date":"2022-03-18 21:32:00","inspection_id":"75088423","dot_number":"3174029","report_state":"CA","report_number":"UF73000749","insp_date":"2022-03-17 00:00:00","insp_start_time":"1843","insp_end_time":"1853","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-18 21:32: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":"14348743","transaction_code":"A","transaction_date":"2022-03-17 00:00:00","upload_date":"2022-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03174029","upload_search_indicator":null,"census_search_date":"2022-03-18 21:32:00","snet_input_date":"2022-03-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-18 21:32:00","insp_carrier_name":"JOSE RUBEN VEGA ORTIZ","insp_carrier_street":"1126 S AVENA AVE","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"5333389","created_at":"2025-03-17T18:27:44.000000Z","updated_at":"2025-03-17T18:27:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10614,"change_date":"2022-03-18 21:32:00","inspection_id":"75088423","insp_unit_id":"187714459","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9F89225","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9FN908270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:20.000000Z","updated_at":"2025-03-17T22:08:20.000000Z"},{"id":10615,"change_date":"2022-03-18 21:32:00","inspection_id":"75088423","insp_unit_id":"187714460","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"9F89225","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0621FW704679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:20.000000Z","updated_at":"2025-03-17T22:08:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3174029\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3174029\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3174029\/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\/3174029\/inspections","per_page":100,"prev_page_url":null,"to":77,"total":77}