{"current_page":1,"data":[{"id":12303204,"change_date":"2026-06-27 21:42:00","inspection_id":"88260377","dot_number":"2705049","report_state":"CA","report_number":"N9PI010809","insp_date":"2026-06-25 00:00:00","insp_start_time":"1212","insp_end_time":"1236","registration_date":null,"region":"PD","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"3637303","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-27 21:42:00","snet_input_date":"2026-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-06-30T09:40:23.000000Z","updated_at":"2026-07-08T09:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21369398,"change_date":"2026-06-27 21:42:00","inspection_id":"88260377","insp_unit_id":"214328129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"36207867","created_at":"2026-06-30T09:16:45.000000Z","updated_at":"2026-07-08T09:03:00.000000Z"}]},{"id":12232123,"change_date":"2026-06-19 21:38:00","inspection_id":"88189639","dot_number":"2705049","report_state":"CA","report_number":"ND7N011012","insp_date":"2026-06-18 00:00:00","insp_start_time":"1615","insp_end_time":"1634","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"3579711","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-22T09:41:22.000000Z","updated_at":"2026-06-30T09:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21243013,"change_date":"2026-06-19 21:38:00","inspection_id":"88189639","insp_unit_id":"214189435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"36207871","created_at":"2026-06-22T09:18:36.000000Z","updated_at":"2026-06-30T09:01:26.000000Z"}]},{"id":12210751,"change_date":"2026-06-17 21:40:00","inspection_id":"88167964","dot_number":"2705049","report_state":"CA","report_number":"ND7N011004","insp_date":"2026-06-16 00:00:00","insp_start_time":"1744","insp_end_time":"1804","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"3562157","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-17 21:40:00","snet_input_date":"2026-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-17 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-20T09:43:42.000000Z","updated_at":"2026-06-28T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21207675,"change_date":"2026-06-17 21:40:00","inspection_id":"88167964","insp_unit_id":"214149404","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"108 WHT","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"36207867","created_at":"2026-06-20T09:22:00.000000Z","updated_at":"2026-06-28T09:02:01.000000Z"}]},{"id":12210797,"change_date":"2026-06-17 21:40:00","inspection_id":"88168012","dot_number":"2705049","report_state":"CA","report_number":"UD54001024","insp_date":"2026-06-16 00:00:00","insp_start_time":"1639","insp_end_time":"1702","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"3562164","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-17 21:40:00","snet_input_date":"2026-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-17 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-06-20T09:43:43.000000Z","updated_at":"2026-06-28T09:30:45.000000Z","inspection_violations":[{"id":21251354,"change_date":"2026-06-17 21:40:00","inspection_id":"88168012","insp_violation_id":"274963837","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214149486","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"D9965601","created_at":"2026-06-19T10:05:31.000000Z","updated_at":"2026-06-28T09:41:00.000000Z","normalized_code":"39375A3TAOL"},{"id":21251355,"change_date":"2026-06-17 21:40:00","inspection_id":"88168012","insp_violation_id":"274963838","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214149486","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SU11506","created_at":"2026-06-19T10:05:31.000000Z","updated_at":"2026-06-28T09:41:00.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21207755,"change_date":"2026-06-17 21:40:00","inspection_id":"88168012","insp_unit_id":"214149486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"108\/WHT","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:00.000000Z","updated_at":"2026-06-28T09:02:01.000000Z"}]},{"id":12120135,"change_date":"2026-06-07 21:34:00","inspection_id":"88065569","dot_number":"2705049","report_state":"CA","report_number":"NC43010777","insp_date":"2026-06-04 00:00:00","insp_start_time":"1624","insp_end_time":"1651","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3486624","transaction_code":"A","transaction_date":"2026-06-07 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-06-10T09:39:59.000000Z","updated_at":"2026-06-18T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21057216,"change_date":"2026-06-07 21:34:00","inspection_id":"88065569","insp_unit_id":"213956488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"36206808","created_at":"2026-06-10T09:14:49.000000Z","updated_at":"2026-06-18T09:01:34.000000Z"}]},{"id":12075555,"change_date":"2026-06-02 21:41:00","inspection_id":"88017993","dot_number":"2705049","report_state":"CA","report_number":"NAHY009048","insp_date":"2026-06-01 00:00:00","insp_start_time":"1216","insp_end_time":"1245","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3448417","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-06-06T09:40:24.000000Z","updated_at":"2026-06-13T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20985000,"change_date":"2026-06-02 21:41:00","inspection_id":"88017993","insp_unit_id":"213867964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"8\/WHITE","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"Y","insp_unit_decal_number":"36209116","created_at":"2026-06-06T09:17:16.000000Z","updated_at":"2026-06-13T09:02:11.000000Z"}]},{"id":11930362,"change_date":"2026-05-15 21:44:00","inspection_id":"87864979","dot_number":"2705049","report_state":"CA","report_number":"NFSD000923","insp_date":"2026-05-12 00:00:00","insp_start_time":"1900","insp_end_time":"1920","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"3337130","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-05-18T09:40:36.000000Z","updated_at":"2026-05-26T09:31:48.000000Z","inspection_violations":[{"id":20751842,"change_date":"2026-05-15 21:44:00","inspection_id":"87864979","insp_violation_id":"274293216","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"213582688","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:11.000000Z","updated_at":"2026-05-26T09:45:08.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":20747286,"change_date":"2026-05-15 21:44:00","inspection_id":"87864979","insp_unit_id":"213582688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/105","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:52.000000Z","updated_at":"2026-05-26T09:04:11.000000Z"}]},{"id":11836919,"change_date":"2026-05-08 21:38:00","inspection_id":"87772305","dot_number":"2705049","report_state":"CA","report_number":"UD54000982","insp_date":"2026-05-05 00:00:00","insp_start_time":"1505","insp_end_time":"1522","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"3270750","transaction_code":"C","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-05-09T09:40:13.000000Z","updated_at":"2026-05-19T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20585795,"change_date":"2026-05-08 21:38:00","inspection_id":"87772305","insp_unit_id":"213444175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:18.000000Z","updated_at":"2026-05-19T09:02:06.000000Z"}]},{"id":11855583,"change_date":"2026-05-08 21:38:00","inspection_id":"87791791","dot_number":"2705049","report_state":"CA","report_number":"NC43010657","insp_date":"2026-05-05 00:00:00","insp_start_time":"1617","insp_end_time":"1652","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"3283423","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-05-11T09:39:58.000000Z","updated_at":"2026-05-19T09:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20616442,"change_date":"2026-05-08 21:38:00","inspection_id":"87791791","insp_unit_id":"213444147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:19.000000Z","updated_at":"2026-05-19T09:02:37.000000Z"}]},{"id":11714225,"change_date":"2026-04-21 21:39:00","inspection_id":"87641386","dot_number":"2705049","report_state":"CA","report_number":"NF8B002964","insp_date":"2026-04-20 00:00:00","insp_start_time":"1724","insp_end_time":"1815","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"16257296","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-04-27T09:38:31.000000Z","updated_at":"2026-05-02T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20384899,"change_date":"2026-04-21 21:39:00","inspection_id":"87641386","insp_unit_id":"213147910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/106","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"Y","insp_unit_decal_number":"36209399","created_at":"2026-04-27T09:15:12.000000Z","updated_at":"2026-05-02T09:04:14.000000Z"}]},{"id":11635652,"change_date":"2026-04-13 21:38:00","inspection_id":"87564472","dot_number":"2705049","report_state":"CA","report_number":"NC43010538","insp_date":"2026-04-09 00:00:00","insp_start_time":"1822","insp_end_time":"1854","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLLA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"16243584","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-04-24T09:31:34.000000Z","updated_at":"2026-04-24T09:31:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20238609,"change_date":"2026-04-13 21:38:00","inspection_id":"87564472","insp_unit_id":"212993804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"36206589","created_at":"2026-04-24T09:04:20.000000Z","updated_at":"2026-04-24T09:04:20.000000Z"}]},{"id":11469142,"change_date":"2026-03-24 21:40:00","inspection_id":"87387618","dot_number":"2705049","report_state":"CA","report_number":"NFSD000640","insp_date":"2026-03-23 00:00:00","insp_start_time":"1645","insp_end_time":"1721","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14050","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":"16221253","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-03-27T09:45:30.000000Z","updated_at":"2026-04-04T09:31:50.000000Z","inspection_violations":[{"id":19357071,"change_date":"2026-03-24 21:40:00","inspection_id":"87387618","insp_violation_id":"272618236","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"212317583","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:32.000000Z","updated_at":"2026-04-03T09:56:01.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19644176,"change_date":"2026-03-24 21:40:00","inspection_id":"87387618","insp_unit_id":"212317583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/107","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:08.000000Z","updated_at":"2026-04-04T09:05:41.000000Z"}]},{"id":11402111,"change_date":"2026-03-17 21:40:00","inspection_id":"87317167","dot_number":"2705049","report_state":"CA","report_number":"NF8B002808","insp_date":"2026-03-16 00:00:00","insp_start_time":"1728","insp_end_time":"1820","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","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":"12300","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":"16211964","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-03-17 21:40:00","snet_input_date":"2026-03-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-17 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-03-20T09:42:49.000000Z","updated_at":"2026-03-28T09:31:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19528510,"change_date":"2026-03-17 21:40:00","inspection_id":"87317167","insp_unit_id":"212189824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/113","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"35894089","created_at":"2026-03-20T09:19:34.000000Z","updated_at":"2026-03-28T09:06:40.000000Z"}]},{"id":11402166,"change_date":"2026-03-17 21:40:00","inspection_id":"87317226","dot_number":"2705049","report_state":"CA","report_number":"NF8B002812","insp_date":"2026-03-16 00:00:00","insp_start_time":"2043","insp_end_time":"2126","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","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":"15000","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":"16212092","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-03-17 21:40:00","snet_input_date":"2026-03-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-17 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-03-20T09:42:50.000000Z","updated_at":"2026-03-28T09:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19528590,"change_date":"2026-03-17 21:40:00","inspection_id":"87317226","insp_unit_id":"212189916","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/105","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"35894093","created_at":"2026-03-20T09:19:35.000000Z","updated_at":"2026-03-28T09:06:41.000000Z"}]},{"id":11390173,"change_date":"2026-03-16 21:39:00","inspection_id":"87304701","dot_number":"2705049","report_state":"CA","report_number":"ND7N010614","insp_date":"2026-03-12 00:00:00","insp_start_time":"1435","insp_end_time":"1459","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16210115","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-03-16 21:39:00","snet_input_date":"2026-03-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-16 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-03-19T09:37:57.000000Z","updated_at":"2026-03-27T09:31:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19505592,"change_date":"2026-03-16 21:39:00","inspection_id":"87304701","insp_unit_id":"212165170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X WHT","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"Y","insp_unit_decal_number":"35893724","created_at":"2026-03-19T09:12:47.000000Z","updated_at":"2026-03-27T09:06:06.000000Z"}]},{"id":11279072,"change_date":"2026-03-03 21:36:00","inspection_id":"87193676","dot_number":"2705049","report_state":"CA","report_number":"NC20008673","insp_date":"2026-03-02 00:00:00","insp_start_time":"1500","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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":"2026-03-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"16190936","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-03-03 21:36:00","snet_input_date":"2026-03-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-03 21:36:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-03-06T10:39:45.000000Z","updated_at":"2026-03-14T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19289743,"change_date":"2026-03-03 21:36:00","inspection_id":"87193676","insp_unit_id":"211947936","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:09.000000Z","updated_at":"2026-03-14T09:03:42.000000Z"}]},{"id":11131835,"change_date":"2026-02-13 21:39:00","inspection_id":"87045339","dot_number":"2705049","report_state":"CA","report_number":"NC43010339","insp_date":"2026-02-12 00:00:00","insp_start_time":"1547","insp_end_time":"1608","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"16170954","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-02-16T10:38:49.000000Z","updated_at":"2026-02-24T10:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18989178,"change_date":"2026-02-13 21:39:00","inspection_id":"87045339","insp_unit_id":"211623546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"35892710","created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:39.000000Z"}]},{"id":10918402,"change_date":"2026-02-03 21:39:00","inspection_id":"86950587","dot_number":"2705049","report_state":"CA","report_number":"NF8B002624","insp_date":"2026-02-02 00:00:00","insp_start_time":"1851","insp_end_time":"1927","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16154471","transaction_code":"A","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-02-03 21:39:00","snet_input_date":"2026-02-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-03 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-02-06T10:35:21.000000Z","updated_at":"2026-02-14T10:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18362073,"change_date":"2026-02-03 21:39:00","inspection_id":"86950587","insp_unit_id":"211426417","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/114","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"35895033","created_at":"2026-02-06T10:09:26.000000Z","updated_at":"2026-02-14T10:05:57.000000Z"}]},{"id":10886386,"change_date":"2026-01-29 21:39:00","inspection_id":"86917062","dot_number":"2705049","report_state":"CA","report_number":"ND7N010422","insp_date":"2026-01-28 00:00:00","insp_start_time":"1653","insp_end_time":"1713","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"16150696","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-02-01T10:36:00.000000Z","updated_at":"2026-02-10T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18300020,"change_date":"2026-01-29 21:39:00","inspection_id":"86917062","insp_unit_id":"211351006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"111  WHT","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"Y","insp_unit_decal_number":"35893558","created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:14.000000Z"}]},{"id":10863506,"change_date":"2026-01-26 21:37:00","inspection_id":"86893185","dot_number":"2705049","report_state":"CA","report_number":"NCNK009832","insp_date":"2026-01-22 00:00:00","insp_start_time":"1511","insp_end_time":"1526","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2026-01-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"16143379","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-01-26 21:37:00","snet_input_date":"2026-01-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-26 21:37:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-01-29T10:36:09.000000Z","updated_at":"2026-02-06T10:30:34.000000Z","inspection_violations":[{"id":18175707,"change_date":"2026-01-26 21:37:00","inspection_id":"86893185","insp_violation_id":"271436362","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"211298155","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-29T10:41:28.000000Z","updated_at":"2026-02-06T10:36:31.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":18254759,"change_date":"2026-01-26 21:37:00","inspection_id":"86893185","insp_unit_id":"211298155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/01","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:41.000000Z","updated_at":"2026-02-06T10:02:56.000000Z"}]},{"id":10819399,"change_date":"2026-01-20 21:41:00","inspection_id":"86846852","dot_number":"2705049","report_state":"CA","report_number":"NFDX001651","insp_date":"2026-01-15 00:00:00","insp_start_time":"1457","insp_end_time":"1513","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"16136185","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2026-01-20 21:41:00","snet_input_date":"2026-01-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-20 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2026-01-23T10:36:33.000000Z","updated_at":"2026-01-31T10:31:22.000000Z","inspection_violations":[{"id":18087519,"change_date":"2026-01-20 21:41:00","inspection_id":"86846852","insp_violation_id":"271326200","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211197687","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK92802","created_at":"2026-01-23T10:43:06.000000Z","updated_at":"2026-01-31T10:39:15.000000Z","normalized_code":"39360C"},{"id":18087520,"change_date":"2026-01-20 21:41:00","inspection_id":"86846852","insp_violation_id":"271326201","seq_no":"2","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"211197687","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-23T10:43:06.000000Z","updated_at":"2026-01-31T10:39:15.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":18169367,"change_date":"2026-01-20 21:41:00","inspection_id":"86846852","insp_unit_id":"211197687","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:29.000000Z","updated_at":"2026-01-31T10:04:06.000000Z"}]},{"id":10474312,"change_date":"2025-12-18 21:41:00","inspection_id":"86607909","dot_number":"2705049","report_state":"CA","report_number":"NFDX001567","insp_date":"2025-12-17 00:00:00","insp_start_time":"1555","insp_end_time":"1616","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"16102157","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-12-18 21:41:00","snet_input_date":"2025-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-18 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-12-21T10:31:59.000000Z","updated_at":"2025-12-29T10:31:24.000000Z","inspection_violations":[{"id":17575458,"change_date":"2025-12-18 21:41:00","inspection_id":"86607909","insp_violation_id":"270785938","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210702230","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:42.000000Z","updated_at":"2025-12-29T10:32:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17533305,"change_date":"2025-12-18 21:41:00","inspection_id":"86607909","insp_unit_id":"210702230","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/2X","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:52.000000Z","updated_at":"2025-12-29T10:01:40.000000Z"}]},{"id":10367222,"change_date":"2025-12-05 21:43:00","inspection_id":"86495871","dot_number":"2705049","report_state":"CA","report_number":"NFDX001521","insp_date":"2025-12-04 00:00:00","insp_start_time":"1937","insp_end_time":"2003","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"11050","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":"16084556","transaction_code":"A","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-12-08T10:32:09.000000Z","updated_at":"2025-12-09T10:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17328179,"change_date":"2025-12-05 21:43:00","inspection_id":"86495871","insp_unit_id":"210452502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/2X","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:13.000000Z","updated_at":"2025-12-09T10:01:57.000000Z"}]},{"id":10321470,"change_date":"2025-12-01 21:39:00","inspection_id":"86448196","dot_number":"2705049","report_state":"CA","report_number":"ND7N010187","insp_date":"2025-11-24 00:00:00","insp_start_time":"1504","insp_end_time":"1530","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"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":"14500","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":"16071396","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:42.000000Z","updated_at":"2025-12-05T10:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17237167,"change_date":"2025-12-01 21:39:00","inspection_id":"86448196","insp_unit_id":"210337642","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:44.000000Z","updated_at":"2025-12-05T10:01:53.000000Z"}]},{"id":10322820,"change_date":"2025-12-01 21:39:00","inspection_id":"86449563","dot_number":"2705049","report_state":"CA","report_number":"NFDX001480","insp_date":"2025-11-20 00:00:00","insp_start_time":"1548","insp_end_time":"1613","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16071237","transaction_code":"A","transaction_date":"2025-11-20 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-12-04T10:30:44.000000Z","updated_at":"2025-12-05T10:31:40.000000Z","inspection_violations":[{"id":17267164,"change_date":"2025-12-01 21:39:00","inspection_id":"86449563","insp_violation_id":"270378069","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"210339806","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA251533","created_at":"2025-12-04T10:31:11.000000Z","updated_at":"2025-12-05T10:32:21.000000Z","normalized_code":"39341BNPB"},{"id":17267165,"change_date":"2025-12-01 21:39:00","inspection_id":"86449563","insp_violation_id":"270378070","seq_no":"2","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK92266","created_at":"2025-12-04T10:31:11.000000Z","updated_at":"2025-12-05T10:32:21.000000Z","normalized_code":"39111B5LNCDLNVL"}],"inspection_per_units":[{"id":17239244,"change_date":"2025-12-01 21:39:00","inspection_id":"86449563","insp_unit_id":"210339806","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/8","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:46.000000Z","updated_at":"2025-12-05T10:02:03.000000Z"}]},{"id":10254538,"change_date":"2025-11-20 21:41:00","inspection_id":"86377895","dot_number":"2705049","report_state":"CA","report_number":"UDY3000122","insp_date":"2025-11-18 00:00:00","insp_start_time":"1325","insp_end_time":"1357","registration_date":null,"region":"PT","ci_status_code":"C","location":"450","location_desc":"AVE 12","county_code_state":"CA","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16064306","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-11-20 21:41:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-20 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-23T10:32:15.000000Z","updated_at":"2025-11-24T10:31:28.000000Z","inspection_violations":[{"id":17059050,"change_date":"2025-11-20 21:41:00","inspection_id":"86377895","insp_violation_id":"270110485","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210160667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-23T10:33:12.000000Z","updated_at":"2025-11-24T10:32:21.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":17094381,"change_date":"2025-11-20 21:41:00","inspection_id":"86377895","insp_unit_id":"210160667","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/113","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"35625288","created_at":"2025-11-23T10:02:08.000000Z","updated_at":"2025-11-24T10:01:46.000000Z"}]},{"id":10130783,"change_date":"2025-11-05 21:41:00","inspection_id":"86247879","dot_number":"2705049","report_state":"CA","report_number":"ND7N010117","insp_date":"2025-11-04 00:00:00","insp_start_time":"1930","insp_end_time":"1955","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"16046623","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-11-05 21:41:00","snet_input_date":"2025-11-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-05 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-08T10:32:03.000000Z","updated_at":"2025-11-09T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16860957,"change_date":"2025-11-05 21:41:00","inspection_id":"86247879","insp_unit_id":"209868569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"9168861","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"35621408","created_at":"2025-11-08T10:02:15.000000Z","updated_at":"2025-11-09T10:01:39.000000Z"}]},{"id":9839872,"change_date":"2025-10-02 21:42:00","inspection_id":"85941341","dot_number":"2705049","report_state":"CA","report_number":"N9PI009639","insp_date":"2025-10-01 00:00:00","insp_start_time":"1901","insp_end_time":"1927","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"16002057","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-10-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-10-05T10:01:58.000000Z","updated_at":"2025-10-05T10:01:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16317245,"change_date":"2025-10-02 21:42:00","inspection_id":"85941341","insp_unit_id":"209269016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT VAN TRK","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"35624678","created_at":"2025-10-05T09:47:01.000000Z","updated_at":"2025-10-05T09:47:01.000000Z"}]},{"id":9723086,"change_date":"2025-09-18 21:43:00","inspection_id":"85818962","dot_number":"2705049","report_state":"CA","report_number":"NC20008177","insp_date":"2025-09-17 00:00:00","insp_start_time":"1450","insp_end_time":"1505","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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-09-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15985062","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-09-18 21:43:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-18 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-09-23T10:02:31.000000Z","updated_at":"2025-09-23T10:02:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16100581,"change_date":"2025-09-18 21:43:00","inspection_id":"85818962","insp_unit_id":"209035748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"23408F3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W168N7K00466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:46:00.000000Z","updated_at":"2025-09-22T09:46:51.000000Z"}]},{"id":9688155,"change_date":"2025-09-15 21:41:00","inspection_id":"85782351","dot_number":"2705049","report_state":"CA","report_number":"NAHY008178","insp_date":"2025-09-11 00:00:00","insp_start_time":"1851","insp_end_time":"1924","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15980674","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:41.000000Z","updated_at":"2025-09-18T10:00:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16035406,"change_date":"2025-09-15 21:41:00","inspection_id":"85782351","insp_unit_id":"208965597","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"Y","insp_unit_decal_number":"35349786","created_at":"2025-09-18T09:45:34.000000Z","updated_at":"2025-09-18T09:45:34.000000Z"}]},{"id":9635801,"change_date":"2025-09-09 21:41:00","inspection_id":"85727075","dot_number":"2705049","report_state":"CA","report_number":"N9PI009523","insp_date":"2025-09-08 00:00:00","insp_start_time":"1652","insp_end_time":"1715","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15972849","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-09-11T10:47:15.000000Z","updated_at":"2025-09-13T10:47:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15919384,"change_date":"2025-09-09 21:41:00","inspection_id":"85727075","insp_unit_id":"208836031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"35349575","created_at":"2025-09-12T10:47:50.000000Z","updated_at":"2025-09-13T10:00:06.000000Z"}]},{"id":9475678,"change_date":"2025-08-21 21:41:00","inspection_id":"85559163","dot_number":"2705049","report_state":"CA","report_number":"NF8B001873","insp_date":"2025-08-20 00:00:00","insp_start_time":"1654","insp_end_time":"1914","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"2105 WARDROBE AVE","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15947114","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-08-25T10:43:03.000000Z","updated_at":"2025-08-25T10:43:03.000000Z","inspection_violations":[{"id":15442040,"change_date":"2025-08-21 21:41:00","inspection_id":"85559163","insp_violation_id":"268178357","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208522005","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA251055","created_at":"2025-08-24T10:49:00.000000Z","updated_at":"2025-08-25T10:45:17.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15629179,"change_date":"2025-08-21 21:41:00","inspection_id":"85559163","insp_unit_id":"208522005","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/113","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"35349974","created_at":"2025-08-24T09:46:46.000000Z","updated_at":"2025-08-25T09:46:24.000000Z"}]},{"id":9426792,"change_date":"2025-08-15 21:39:00","inspection_id":"85507644","dot_number":"2705049","report_state":"CA","report_number":"NAHY008111","insp_date":"2025-08-14 00:00:00","insp_start_time":"1605","insp_end_time":"1625","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15939444","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-08-20T10:44:42.000000Z","updated_at":"2025-08-20T10:44:42.000000Z","inspection_violations":[{"id":15339879,"change_date":"2025-08-15 21:39:00","inspection_id":"85507644","insp_violation_id":"268063283","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208426034","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":15540005,"change_date":"2025-08-15 21:39:00","inspection_id":"85507644","insp_unit_id":"208426034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"Y","insp_unit_decal_number":"35349742","created_at":"2025-08-18T09:46:34.000000Z","updated_at":"2025-08-19T09:46:06.000000Z"}]},{"id":9416889,"change_date":"2025-08-14 21:41:00","inspection_id":"85497182","dot_number":"2705049","report_state":"CA","report_number":"N9PI009435","insp_date":"2025-08-13 00:00:00","insp_start_time":"1546","insp_end_time":"1613","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15937841","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-08-14 21:41:00","snet_input_date":"2025-08-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-14 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-08-17T10:01:25.000000Z","updated_at":"2025-08-20T10:44:20.000000Z","inspection_violations":[{"id":15319220,"change_date":"2025-08-14 21:41:00","inspection_id":"85497182","insp_violation_id":"268039771","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"208406896","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:30.000000Z","updated_at":"2025-08-18T10:44:33.000000Z","normalized_code":"3939ALCL"},{"id":15319221,"change_date":"2025-08-14 21:41:00","inspection_id":"85497182","insp_violation_id":"268039772","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208406896","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:30.000000Z","updated_at":"2025-08-18T10:44:33.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":15522327,"change_date":"2025-08-14 21:41:00","inspection_id":"85497182","insp_unit_id":"208406896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:30.000000Z","updated_at":"2025-08-18T09:46:17.000000Z"}]},{"id":9290103,"change_date":"2025-07-30 21:41:00","inspection_id":"85364200","dot_number":"2705049","report_state":"CA","report_number":"NAHY008080","insp_date":"2025-07-29 00:00:00","insp_start_time":"1841","insp_end_time":"1912","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15919427","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-07-30 21:41:00","snet_input_date":"2025-07-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-30 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-08-04T10:01:17.000000Z","updated_at":"2025-08-04T10:01:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15295634,"change_date":"2025-07-30 21:41:00","inspection_id":"85364200","insp_unit_id":"208163216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"Y","insp_unit_decal_number":"35349719","created_at":"2025-08-02T09:46:29.000000Z","updated_at":"2025-08-03T09:46:09.000000Z"}]},{"id":9241505,"change_date":"2025-07-24 21:41:00","inspection_id":"85312745","dot_number":"2705049","report_state":"CA","report_number":"N9PI009367","insp_date":"2025-07-23 00:00:00","insp_start_time":"2001","insp_end_time":"2024","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"14000","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":"15912382","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-07-24 21:41:00","snet_input_date":"2025-07-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-07-27T10:41:59.000000Z","updated_at":"2025-07-30T10:01:06.000000Z","inspection_violations":[{"id":14963568,"change_date":"2025-07-24 21:41:00","inspection_id":"85312745","insp_violation_id":"267639557","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208067390","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:25.000000Z","updated_at":"2025-07-28T10:49:21.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":15207073,"change_date":"2025-07-24 21:41:00","inspection_id":"85312745","insp_unit_id":"208067390","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT VAN","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"35349494","created_at":"2025-07-27T09:46:35.000000Z","updated_at":"2025-07-28T09:46:24.000000Z"}]},{"id":9227764,"change_date":"2025-07-23 21:42:00","inspection_id":"85298478","dot_number":"2705049","report_state":"CA","report_number":"N9PI009360","insp_date":"2025-07-22 00:00:00","insp_start_time":"1926","insp_end_time":"1949","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15910162","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-07-27T10:41:39.000000Z","updated_at":"2025-07-27T10:41:39.000000Z","inspection_violations":[{"id":14935758,"change_date":"2025-07-23 21:42:00","inspection_id":"85298478","insp_violation_id":"267607932","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208040916","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA2520849","created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"3922SLLSOA"},{"id":14935759,"change_date":"2025-07-23 21:42:00","inspection_id":"85298478","insp_violation_id":"267607933","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208040916","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA2520849","created_at":"2025-07-26T10:43:41.000000Z","updated_at":"2025-07-27T10:43:42.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15182420,"change_date":"2025-07-23 21:42:00","inspection_id":"85298478","insp_unit_id":"208040916","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:32.000000Z","updated_at":"2025-07-27T09:46:17.000000Z"}]},{"id":9144393,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","dot_number":"2705049","report_state":"CA","report_number":"NCNK009055","insp_date":"2025-07-10 00:00:00","insp_start_time":"1211","insp_end_time":"1240","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15898354","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-07-18T10:45:49.000000Z","updated_at":"2025-07-18T10:45:49.000000Z","inspection_violations":[{"id":14752352,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_violation_id":"267397994","seq_no":"5","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"207862159","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:19.000000Z","updated_at":"2025-07-18T10:47:43.000000Z","normalized_code":"3965BHWSL"},{"id":14752353,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_violation_id":"267397995","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"207862159","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:19.000000Z","updated_at":"2025-07-18T10:47:43.000000Z","normalized_code":"3922SLLSOA"},{"id":14752354,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_violation_id":"267397996","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207862159","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:19.000000Z","updated_at":"2025-07-18T10:47:43.000000Z","normalized_code":"3922SLLSR"},{"id":14752355,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_violation_id":"267397997","seq_no":"3","part_no":"393","part_no_section":"95A3","insp_viol_unit":"1","insp_unit_id":"207862159","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:19.000000Z","updated_at":"2025-07-18T10:47:43.000000Z","normalized_code":"39395A3"},{"id":14752356,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_violation_id":"267397998","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207862159","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:19.000000Z","updated_at":"2025-07-18T10:47:43.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":15016691,"change_date":"2025-07-14 21:41:00","inspection_id":"85210905","insp_unit_id":"207862159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/1","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:34.000000Z","updated_at":"2025-07-18T09:46:09.000000Z"}]},{"id":8913193,"change_date":"2025-06-16 21:40:00","inspection_id":"84966844","dot_number":"2705049","report_state":"CA","report_number":"NCNK008935","insp_date":"2025-06-13 00:00:00","insp_start_time":"1644","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"15862561","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-06-19T10:00:27.000000Z","updated_at":"2025-06-20T10:00:39.000000Z","inspection_violations":[{"id":14293366,"change_date":"2025-06-16 21:40:00","inspection_id":"84966844","insp_violation_id":"266874140","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207413335","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK91219","created_at":"2025-06-19T10:15:40.000000Z","updated_at":"2025-06-20T10:16:12.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14603908,"change_date":"2025-06-16 21:40:00","inspection_id":"84966844","insp_unit_id":"207413335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/01","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:25.000000Z","updated_at":"2025-06-20T09:45:52.000000Z"}]},{"id":8829543,"change_date":"2025-06-05 21:41:00","inspection_id":"84878025","dot_number":"2705049","report_state":"CA","report_number":"NC43009481","insp_date":"2025-06-04 00:00:00","insp_start_time":"1606","insp_end_time":"1639","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"15849867","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-06-09T10:01:08.000000Z","updated_at":"2025-06-09T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14455866,"change_date":"2025-06-05 21:41:00","inspection_id":"84878025","insp_unit_id":"207250798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"35069641","created_at":"2025-06-08T09:46:29.000000Z","updated_at":"2025-06-09T09:46:04.000000Z"}]},{"id":8808705,"change_date":"2025-06-03 21:41:00","inspection_id":"84855879","dot_number":"2705049","report_state":"CA","report_number":"NF8B001571","insp_date":"2025-06-02 00:00:00","insp_start_time":"2031","insp_end_time":"2059","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"2105 WARDROBE AVE","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15846092","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-06-03 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-03 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-06-06T10:01:09.000000Z","updated_at":"2025-06-07T10:00:50.000000Z","inspection_violations":[{"id":14092902,"change_date":"2025-06-03 21:41:00","inspection_id":"84855879","insp_violation_id":"266644929","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"207209789","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA250830","created_at":"2025-06-06T10:16:51.000000Z","updated_at":"2025-06-07T10:18:01.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":14417923,"change_date":"2025-06-03 21:41:00","inspection_id":"84855879","insp_unit_id":"207209789","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/114","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:52.000000Z","updated_at":"2025-06-07T09:46:05.000000Z"}]},{"id":8537084,"change_date":"2025-05-02 21:41:00","inspection_id":"84569365","dot_number":"2705049","report_state":"CA","report_number":"UC13004886","insp_date":"2025-04-29 00:00:00","insp_start_time":"0825","insp_end_time":"0855","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15804349","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-05-05T10:16:17.000000Z","updated_at":"2025-05-06T10:07:02.000000Z","inspection_violations":[{"id":13522172,"change_date":"2025-05-02 21:41:00","inspection_id":"84569365","insp_violation_id":"265984500","seq_no":"1","part_no":"392","part_no_section":"2SLIMPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK90865","created_at":"2025-05-04T10:56:51.000000Z","updated_at":"2025-05-06T10:37:33.000000Z","normalized_code":"3922SLIMPT"}],"inspection_per_units":[{"id":13881490,"change_date":"2025-05-02 21:41:00","inspection_id":"84569365","insp_unit_id":"206622979","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X BOX","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:08:36.000000Z","updated_at":"2025-05-07T10:09:09.000000Z"}]},{"id":8443723,"change_date":"2025-04-22 21:41:00","inspection_id":"84471079","dot_number":"2705049","report_state":"CA","report_number":"NF8B001450","insp_date":"2025-04-17 00:00:00","insp_start_time":"1604","insp_end_time":"1642","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"2105 WARDROBE AVE","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"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":"14500","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":"15789477","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-04-26T10:27:35.000000Z","updated_at":"2025-04-26T10:27:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13713442,"change_date":"2025-04-22 21:41:00","inspection_id":"84471079","insp_unit_id":"206442270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/102","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"Y","insp_unit_decal_number":"35070994","created_at":"2025-04-25T10:16:12.000000Z","updated_at":"2025-04-26T10:09:55.000000Z"}]},{"id":8300002,"change_date":"2025-04-04 21:41:00","inspection_id":"84319482","dot_number":"2705049","report_state":"CA","report_number":"ND7N009351","insp_date":"2025-04-03 00:00:00","insp_start_time":"1936","insp_end_time":"1955","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"15768116","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:24.000000Z","updated_at":"2025-04-08T10:10:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13457486,"change_date":"2025-04-04 21:41:00","inspection_id":"84319482","insp_unit_id":"206165299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"35070132","created_at":"2025-04-07T10:14:26.000000Z","updated_at":"2025-04-08T10:03:49.000000Z"}]},{"id":8159212,"change_date":"2025-03-19 21:41:00","inspection_id":"84171264","dot_number":"2705049","report_state":"CA","report_number":"NC43009278","insp_date":"2025-03-18 00:00:00","insp_start_time":"1618","insp_end_time":"1641","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15744463","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-22T10:37:09.000000Z","updated_at":"2025-03-23T10:53:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13181566,"change_date":"2025-03-19 21:41:00","inspection_id":"84171264","insp_unit_id":"205886776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"34780469","created_at":"2025-03-22T10:09:24.000000Z","updated_at":"2025-03-23T10:07:20.000000Z"}]},{"id":8161485,"change_date":"2025-03-19 21:41:00","inspection_id":"84173584","dot_number":"2705049","report_state":"CA","report_number":"UEX2003899","insp_date":"2025-03-18 00:00:00","insp_start_time":"1840","insp_end_time":"1858","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15744482","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-22T10:39:07.000000Z","updated_at":"2025-03-23T10:55:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13185103,"change_date":"2025-03-19 21:41:00","inspection_id":"84173584","insp_unit_id":"205890512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"108\/WHT","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"34779902","created_at":"2025-03-22T10:11:35.000000Z","updated_at":"2025-03-23T10:10:56.000000Z"}]},{"id":8039041,"change_date":"2025-03-05 21:40:00","inspection_id":"84044765","dot_number":"2705049","report_state":"CA","report_number":"UEX2003866","insp_date":"2025-03-04 00:00:00","insp_start_time":"1830","insp_end_time":"1851","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15727883","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12978498,"change_date":"2025-03-05 21:40:00","inspection_id":"84044765","insp_unit_id":"205649870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"34779894","created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":8026334,"change_date":"2025-03-04 21:39:00","inspection_id":"84031413","dot_number":"2705049","report_state":"CA","report_number":"N9PI008897","insp_date":"2025-03-03 00:00:00","insp_start_time":"1949","insp_end_time":"2013","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15725345","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:04:56.000000Z","updated_at":"2025-03-17T21:04:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12957913,"change_date":"2025-03-04 21:39:00","inspection_id":"84031413","insp_unit_id":"205626058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"Y","insp_unit_decal_number":"34782483","created_at":"2025-03-17T23:58:08.000000Z","updated_at":"2025-03-17T23:58:08.000000Z"}]},{"id":7985691,"change_date":"2025-02-27 21:42:00","inspection_id":"83988662","dot_number":"2705049","report_state":"CA","report_number":"NC43009193","insp_date":"2025-02-25 00:00:00","insp_start_time":"1714","insp_end_time":"1750","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15720715","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12891809,"change_date":"2025-02-27 21:42:00","inspection_id":"83988662","insp_unit_id":"205548460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"34780406","created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"}]},{"id":7923008,"change_date":"2025-02-20 21:41:00","inspection_id":"83922977","dot_number":"2705049","report_state":"CA","report_number":"NCNK008495","insp_date":"2025-02-19 00:00:00","insp_start_time":"1559","insp_end_time":"1606","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"9500","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":"15710628","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-02-20 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-20 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:02:48.000000Z","updated_at":"2025-03-17T21:02:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12789650,"change_date":"2025-02-20 21:41:00","inspection_id":"83922977","insp_unit_id":"205427483","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/1","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"34780724","created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"}]},{"id":7867228,"change_date":"2025-02-13 21:41:00","inspection_id":"83864454","dot_number":"2705049","report_state":"CA","report_number":"N9PI008846","insp_date":"2025-02-12 00:00:00","insp_start_time":"1508","insp_end_time":"1529","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15703112","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-02-13 21:41:00","snet_input_date":"2025-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-13 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:01:33.000000Z","updated_at":"2025-03-17T21:01:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12697731,"change_date":"2025-02-13 21:41:00","inspection_id":"83864454","insp_unit_id":"205319427","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT VAN TRK","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"34782442","created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"}]},{"id":7854962,"change_date":"2025-02-12 21:39:00","inspection_id":"83851712","dot_number":"2705049","report_state":"CA","report_number":"N9PI008841","insp_date":"2025-02-11 00:00:00","insp_start_time":"1619","insp_end_time":"1644","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15701013","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-02-12 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-12 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:01:13.000000Z","updated_at":"2025-03-17T21:01:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12677639,"change_date":"2025-02-12 21:39:00","inspection_id":"83851712","insp_unit_id":"205295337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"Y","insp_unit_decal_number":"34782440","created_at":"2025-03-17T23:55:02.000000Z","updated_at":"2025-03-17T23:55:02.000000Z"}]},{"id":7855142,"change_date":"2025-02-12 21:39:00","inspection_id":"83851894","dot_number":"2705049","report_state":"CA","report_number":"NC43009148","insp_date":"2025-02-11 00:00:00","insp_start_time":"1544","insp_end_time":"1610","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"15701016","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-02-12 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-12 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T21:01:13.000000Z","updated_at":"2025-03-17T21:01:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12677915,"change_date":"2025-02-12 21:39:00","inspection_id":"83851894","insp_unit_id":"205295627","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"34780370","created_at":"2025-03-17T23:55:02.000000Z","updated_at":"2025-03-17T23:55:02.000000Z"}]},{"id":7750882,"change_date":"2025-01-30 21:41:00","inspection_id":"83742129","dot_number":"2705049","report_state":"CA","report_number":"N9PI008796","insp_date":"2025-01-29 00:00:00","insp_start_time":"1509","insp_end_time":"1523","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS","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":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15685633","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:59:09.000000Z","updated_at":"2025-03-17T20:59:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12508190,"change_date":"2025-01-30 21:41:00","inspection_id":"83742129","insp_unit_id":"205088303","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT BX","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"34782412","created_at":"2025-03-17T23:53:04.000000Z","updated_at":"2025-03-17T23:53:04.000000Z"}]},{"id":7729851,"change_date":"2025-01-28 21:39:00","inspection_id":"83719962","dot_number":"2705049","report_state":"CA","report_number":"N9PI008774","insp_date":"2025-01-27 00:00:00","insp_start_time":"1433","insp_end_time":"1456","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15681321","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12473943,"change_date":"2025-01-28 21:39:00","inspection_id":"83719962","insp_unit_id":"205047560","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"Y","insp_unit_decal_number":"34782394","created_at":"2025-03-17T23:52:37.000000Z","updated_at":"2025-03-17T23:52:37.000000Z"}]},{"id":7705799,"change_date":"2025-01-24 21:40:00","inspection_id":"83694780","dot_number":"2705049","report_state":"CA","report_number":"NCNK008404","insp_date":"2025-01-23 00:00:00","insp_start_time":"1446","insp_end_time":"1457","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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":"2025-01-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"15676816","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:58:17.000000Z","updated_at":"2025-03-17T20:58:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12434635,"change_date":"2025-01-24 21:40:00","inspection_id":"83694780","insp_unit_id":"205000465","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/01","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"34780650","created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"}]},{"id":7610965,"change_date":"2025-01-13 21:46:00","inspection_id":"83595359","dot_number":"2705049","report_state":"CA","report_number":"UELQ000093","insp_date":"2025-01-09 00:00:00","insp_start_time":"1927","insp_end_time":"1941","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"2025-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15658061","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:08.000000Z","updated_at":"2025-03-17T20:56:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12280801,"change_date":"2025-01-13 21:46:00","inspection_id":"83595359","insp_unit_id":"204791109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2AXLEBX\/WHI","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7453283,"change_date":"2024-12-18 21:41:00","inspection_id":"83429678","dot_number":"2705049","report_state":"CA","report_number":"NC43008970","insp_date":"2024-12-17 00:00:00","insp_start_time":"1734","insp_end_time":"1907","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15635213","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12024266,"change_date":"2024-12-18 21:41:00","inspection_id":"83429678","insp_unit_id":"204464580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"34487060","created_at":"2025-03-17T23:47:43.000000Z","updated_at":"2025-03-17T23:47:43.000000Z"}]},{"id":7442109,"change_date":"2024-12-17 21:40:00","inspection_id":"83417960","dot_number":"2705049","report_state":"CA","report_number":"ND7N008963","insp_date":"2024-12-16 00:00:00","insp_start_time":"1706","insp_end_time":"1724","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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-12-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"15631766","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-17 21:40:00","snet_input_date":"2024-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-17 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:30.000000Z","updated_at":"2025-03-17T20:51:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12005917,"change_date":"2024-12-17 21:40:00","inspection_id":"83417960","insp_unit_id":"204440177","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"}]},{"id":7416338,"change_date":"2024-12-13 21:41:00","inspection_id":"83390830","dot_number":"2705049","report_state":"CA","report_number":"NCNK008228","insp_date":"2024-12-12 00:00:00","insp_start_time":"1714","insp_end_time":"1734","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15628837","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:50:48.000000Z","updated_at":"2025-03-17T20:50:48.000000Z","inspection_violations":[{"id":11589722,"change_date":"2024-12-13 21:41:00","inspection_id":"83390830","insp_violation_id":"263466759","seq_no":"1","part_no":"393","part_no_section":"47D2-BLTHE","insp_viol_unit":"1","insp_unit_id":"204384682","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39347D2BLTHE"}],"inspection_per_units":[{"id":11964451,"change_date":"2024-12-13 21:41:00","inspection_id":"83390830","insp_unit_id":"204384682","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/9168861","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"}]},{"id":7416015,"change_date":"2024-12-13 21:41:00","inspection_id":"83390498","dot_number":"2705049","report_state":"CA","report_number":"NFDX000091","insp_date":"2024-12-11 00:00:00","insp_start_time":"1712","insp_end_time":"1744","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15628046","transaction_code":"A","transaction_date":"2024-12-11 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-12-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:50:48.000000Z","updated_at":"2025-03-17T20:50:48.000000Z","inspection_violations":[{"id":11589337,"change_date":"2024-12-13 21:41:00","inspection_id":"83390498","insp_violation_id":"263466347","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204384146","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA249548","created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11963942,"change_date":"2024-12-13 21:41:00","inspection_id":"83390498","insp_unit_id":"204384146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/106","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"Y","insp_unit_decal_number":"34486828","created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"}]},{"id":7374824,"change_date":"2024-12-09 21:42:00","inspection_id":"83347311","dot_number":"2705049","report_state":"CA","report_number":"UCRG000250","insp_date":"2024-12-06 00:00:00","insp_start_time":"1400","insp_end_time":"1412","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15620641","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-09 21:42:00","snet_input_date":"2024-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-09 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:49:50.000000Z","updated_at":"2025-03-17T20:49:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11896975,"change_date":"2024-12-09 21:42:00","inspection_id":"83347311","insp_unit_id":"204284188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHI","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"34483799","created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"}]},{"id":7385095,"change_date":"2024-12-10 21:42:00","inspection_id":"83358069","dot_number":"2705049","report_state":"CA","report_number":"NEAY001744","insp_date":"2024-12-06 00:00:00","insp_start_time":"1121","insp_end_time":"1142","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15624248","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-10 21:42:00","snet_input_date":"2024-12-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-10 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:50:17.000000Z","updated_at":"2025-03-17T20:50:17.000000Z","inspection_violations":[{"id":11538081,"change_date":"2024-12-10 21:42:00","inspection_id":"83358069","insp_violation_id":"263377889","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204309171","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA249162","created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11913310,"change_date":"2024-12-10 21:42:00","inspection_id":"83358069","insp_unit_id":"204309171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:32.000000Z","updated_at":"2025-03-17T23:46:32.000000Z"}]},{"id":7374005,"change_date":"2024-12-09 21:42:00","inspection_id":"83346474","dot_number":"2705049","report_state":"CA","report_number":"ND7N008913","insp_date":"2024-12-05 00:00:00","insp_start_time":"1708","insp_end_time":"1719","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"15622519","transaction_code":"A","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-12-09 21:42:00","snet_input_date":"2024-12-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-09 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:50.000000Z","updated_at":"2025-03-17T20:49:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11895623,"change_date":"2024-12-09 21:42:00","inspection_id":"83346474","insp_unit_id":"204282741","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"34485513","created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"}]},{"id":7177952,"change_date":"2024-11-12 21:42:00","inspection_id":"83139497","dot_number":"2705049","report_state":"CA","report_number":"NCNK008113","insp_date":"2024-11-07 00:00:00","insp_start_time":"1924","insp_end_time":"1941","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15589442","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:45:37.000000Z","updated_at":"2025-03-17T20:45:37.000000Z","inspection_violations":[{"id":11216737,"change_date":"2024-11-12 21:42:00","inspection_id":"83139497","insp_violation_id":"262858724","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"203848858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA249209","created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"3939AHLLH"},{"id":11216738,"change_date":"2024-11-12 21:42:00","inspection_id":"83139497","insp_violation_id":"262858725","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"203848858","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":11578097,"change_date":"2024-11-12 21:42:00","inspection_id":"83139497","insp_unit_id":"203848858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:58.000000Z","updated_at":"2025-03-17T23:42:58.000000Z"}]},{"id":7127946,"change_date":"2024-11-05 21:39:00","inspection_id":"83086486","dot_number":"2705049","report_state":"CA","report_number":"NF8B000821","insp_date":"2024-11-04 00:00:00","insp_start_time":"1546","insp_end_time":"1608","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"15582816","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-11-05 21:39:00","snet_input_date":"2024-11-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-05 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:44:39.000000Z","updated_at":"2025-03-17T20:44:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11496513,"change_date":"2024-11-05 21:39:00","inspection_id":"83086486","insp_unit_id":"203749677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/101","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"34486620","created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"}]},{"id":7005927,"change_date":"2024-10-21 21:42:00","inspection_id":"82957126","dot_number":"2705049","report_state":"CA","report_number":"NC43008743","insp_date":"2024-10-17 00:00:00","insp_start_time":"1848","insp_end_time":"1909","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15562559","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-10-21 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-21 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:42:15.000000Z","updated_at":"2025-03-17T20:42:15.000000Z","inspection_violations":[{"id":10931945,"change_date":"2024-10-21 21:42:00","inspection_id":"82957126","insp_violation_id":"262466094","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203507916","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922SLLSR"},{"id":10931946,"change_date":"2024-10-21 21:42:00","inspection_id":"82957126","insp_violation_id":"262466095","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203507916","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11300356,"change_date":"2024-10-21 21:42:00","inspection_id":"82957126","insp_unit_id":"203507916","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:01.000000Z","updated_at":"2025-03-17T23:40:01.000000Z"}]},{"id":6942799,"change_date":"2024-10-11 21:40:00","inspection_id":"82889997","dot_number":"2705049","report_state":"CA","report_number":"NC43008722","insp_date":"2024-10-10 00:00:00","insp_start_time":"1837","insp_end_time":"1858","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15552717","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-10-11 21:40:00","snet_input_date":"2024-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-11 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:40:58.000000Z","updated_at":"2025-03-17T20:40:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11197620,"change_date":"2024-10-11 21:40:00","inspection_id":"82889997","insp_unit_id":"203377831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"34484397","created_at":"2025-03-17T23:38:56.000000Z","updated_at":"2025-03-17T23:38:56.000000Z"}]},{"id":6926141,"change_date":"2024-10-09 21:42:00","inspection_id":"82872244","dot_number":"2705049","report_state":"CA","report_number":"ND7N008694","insp_date":"2024-10-08 00:00:00","insp_start_time":"1715","insp_end_time":"1725","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15550632","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11170297,"change_date":"2024-10-09 21:42:00","inspection_id":"82872244","insp_unit_id":"203344499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"Y","insp_unit_decal_number":"34485342","created_at":"2025-03-17T23:38:41.000000Z","updated_at":"2025-03-17T23:38:41.000000Z"}]},{"id":6875538,"change_date":"2024-10-02 21:41:00","inspection_id":"82818435","dot_number":"2705049","report_state":"CA","report_number":"NC43008668","insp_date":"2024-10-01 00:00:00","insp_start_time":"1652","insp_end_time":"1702","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15542310","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-10-02 21:41:00","snet_input_date":"2024-10-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-02 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:39:27.000000Z","updated_at":"2025-03-17T20:39:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11088362,"change_date":"2024-10-02 21:41:00","inspection_id":"82818435","insp_unit_id":"203241657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:49.000000Z","updated_at":"2025-03-17T23:37:49.000000Z"}]},{"id":6840846,"change_date":"2024-09-27 21:41:00","inspection_id":"82781666","dot_number":"2705049","report_state":"CA","report_number":"NC43008647","insp_date":"2024-09-26 00:00:00","insp_start_time":"1658","insp_end_time":"1721","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15537598","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":"02705049","upload_search_indicator":null,"census_search_date":"2024-09-27 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-27 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11031945,"change_date":"2024-09-27 21:41:00","inspection_id":"82781666","insp_unit_id":"203172172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHTR","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"34165899","created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6751431,"change_date":"2024-09-17 21:46:00","inspection_id":"82686150","dot_number":"2705049","report_state":"CA","report_number":"N9PI008286","insp_date":"2024-09-16 00:00:00","insp_start_time":"1828","insp_end_time":"1846","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15525163","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-09-17 21:46:00","snet_input_date":"2024-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-17 21:46:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:36:56.000000Z","updated_at":"2025-03-17T20:36:56.000000Z","inspection_violations":[{"id":10513184,"change_date":"2024-09-17 21:46:00","inspection_id":"82686150","insp_violation_id":"261881194","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202992831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK88424","created_at":"2025-03-17T21:56:54.000000Z","updated_at":"2025-03-17T21:56:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10886809,"change_date":"2024-09-17 21:46:00","inspection_id":"82686150","insp_unit_id":"202992831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT VAN TRK","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"Y","insp_unit_decal_number":"34168276","created_at":"2025-03-17T23:35:46.000000Z","updated_at":"2025-03-17T23:35:46.000000Z"}]},{"id":6714711,"change_date":"2024-09-12 21:42:00","inspection_id":"82647231","dot_number":"2705049","report_state":"CA","report_number":"NC43008561","insp_date":"2024-09-10 00:00:00","insp_start_time":"1649","insp_end_time":"1710","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15520039","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:36:07.000000Z","updated_at":"2025-03-17T20:36:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10827291,"change_date":"2024-09-12 21:42:00","inspection_id":"82647231","insp_unit_id":"202899346","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"Y","insp_unit_decal_number":"34165825","created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"}]},{"id":6714712,"change_date":"2024-09-12 21:42:00","inspection_id":"82647232","dot_number":"2705049","report_state":"CA","report_number":"NC43008562","insp_date":"2024-09-10 00:00:00","insp_start_time":"1710","insp_end_time":"1720","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15520040","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:36:07.000000Z","updated_at":"2025-03-17T20:36:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10827292,"change_date":"2024-09-12 21:42:00","inspection_id":"82647232","insp_unit_id":"202899347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"34165826","created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"}]},{"id":6660953,"change_date":"2024-09-05 21:43:00","inspection_id":"82590081","dot_number":"2705049","report_state":"CA","report_number":"ND7N008514","insp_date":"2024-09-04 00:00:00","insp_start_time":"1530","insp_end_time":"1540","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15511192","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10739374,"change_date":"2024-09-05 21:43:00","inspection_id":"82590081","insp_unit_id":"202787830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"36094N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R81J801809","insp_unit_decal":"Y","insp_unit_decal_number":"34167085","created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":6603205,"change_date":"2024-08-29 21:43:00","inspection_id":"82528707","dot_number":"2705049","report_state":"CA","report_number":"NAHY006916","insp_date":"2024-08-28 00:00:00","insp_start_time":"1956","insp_end_time":"2024","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15502633","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:34:02.000000Z","updated_at":"2025-03-17T20:34:02.000000Z","inspection_violations":[{"id":10269165,"change_date":"2024-08-29 21:43:00","inspection_id":"82528707","insp_violation_id":"261510389","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202668858","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:43.000000Z","updated_at":"2025-03-17T21:55:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10646156,"change_date":"2024-08-29 21:43:00","inspection_id":"82528707","insp_unit_id":"202668858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:16.000000Z","updated_at":"2025-03-17T23:33:16.000000Z"}]},{"id":6541688,"change_date":"2024-08-22 21:43:00","inspection_id":"82462973","dot_number":"2705049","report_state":"CA","report_number":"N9PI008156","insp_date":"2024-08-21 00:00:00","insp_start_time":"1849","insp_end_time":"1906","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"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":"15000","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":"15494009","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":"02705049","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":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:32:45.000000Z","updated_at":"2025-03-17T20:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10545669,"change_date":"2024-08-22 21:43:00","inspection_id":"82462973","insp_unit_id":"202541282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"Y","insp_unit_decal_number":"34168179","created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"}]},{"id":6542883,"change_date":"2024-08-22 21:43:00","inspection_id":"82464216","dot_number":"2705049","report_state":"CA","report_number":"UFEV002912","insp_date":"2024-08-21 00:00:00","insp_start_time":"1815","insp_end_time":"1835","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"15493200","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":"02705049","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":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:45.000000Z","updated_at":"2025-03-17T20:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10547517,"change_date":"2024-08-22 21:43:00","inspection_id":"82464216","insp_unit_id":"202543257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"104","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"34165350","created_at":"2025-03-17T23:32:14.000000Z","updated_at":"2025-03-17T23:32:14.000000Z"}]},{"id":6529518,"change_date":"2024-08-21 21:43:00","inspection_id":"82450014","dot_number":"2705049","report_state":"CA","report_number":"NAHY006865","insp_date":"2024-08-20 00:00:00","insp_start_time":"1559","insp_end_time":"1620","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15490221","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-08-21 21:43:00","snet_input_date":"2024-08-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-21 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:32:21.000000Z","updated_at":"2025-03-17T20:32:21.000000Z","inspection_violations":[{"id":10144164,"change_date":"2024-08-21 21:43:00","inspection_id":"82450014","insp_violation_id":"261331500","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202517182","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK88664","created_at":"2025-03-17T21:55:06.000000Z","updated_at":"2025-03-17T21:55:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10526067,"change_date":"2024-08-21 21:43:00","inspection_id":"82450014","insp_unit_id":"202517182","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHITE","insp_unit_license":"97341W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJG31K381907540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:02.000000Z","updated_at":"2025-03-17T23:32:02.000000Z"}]},{"id":6507878,"change_date":"2024-08-19 21:43:00","inspection_id":"82427027","dot_number":"2705049","report_state":"CA","report_number":"UEX2003504","insp_date":"2024-08-16 00:00:00","insp_start_time":"1830","insp_end_time":"1848","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"15488675","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10107962,"change_date":"2024-08-19 21:43:00","inspection_id":"82427027","insp_violation_id":"261279834","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202473029","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"D7004071","created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10490750,"change_date":"2024-08-19 21:43:00","inspection_id":"82427027","insp_unit_id":"202473029","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:41.000000Z","updated_at":"2025-03-17T23:31:41.000000Z"}]},{"id":6493364,"change_date":"2024-08-16 21:40:00","inspection_id":"82411617","dot_number":"2705049","report_state":"CA","report_number":"NF8B000379","insp_date":"2024-08-15 00:00:00","insp_start_time":"1630","insp_end_time":"1659","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-08-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"9900","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":"15486385","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-08-16 21:40:00","snet_input_date":"2024-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-16 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:31:36.000000Z","updated_at":"2025-03-17T20:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10467007,"change_date":"2024-08-16 21:40:00","inspection_id":"82411617","insp_unit_id":"202444619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/105","insp_unit_license":"8Z79574","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDSE3FLXCDA71051","insp_unit_decal":"Y","insp_unit_decal_number":"34168822","created_at":"2025-03-17T23:31:26.000000Z","updated_at":"2025-03-17T23:31:26.000000Z"}]},{"id":6361600,"change_date":"2024-07-31 21:43:00","inspection_id":"82270662","dot_number":"2705049","report_state":"CA","report_number":"NF8B000294","insp_date":"2024-07-30 00:00:00","insp_start_time":"1734","insp_end_time":"1750","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BRIGHT IDEAS CONSTRUCTION","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-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14050","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":"15466280","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:29:03.000000Z","updated_at":"2025-03-17T20:29:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10251781,"change_date":"2024-07-31 21:43:00","inspection_id":"82270662","insp_unit_id":"202177531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/107","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"34168750","created_at":"2025-03-17T23:29:12.000000Z","updated_at":"2025-03-17T23:29:12.000000Z"}]},{"id":6256047,"change_date":"2024-07-18 21:41:00","inspection_id":"82157749","dot_number":"2705049","report_state":"CA","report_number":"NAHY006751","insp_date":"2024-07-16 00:00:00","insp_start_time":"1708","insp_end_time":"1738","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15446809","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10079708,"change_date":"2024-07-18 21:41:00","inspection_id":"82157749","insp_unit_id":"201961010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"39904G1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R5XJ000666","insp_unit_decal":"Y","insp_unit_decal_number":"34168395","created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"}]},{"id":6233168,"change_date":"2024-07-16 21:44:00","inspection_id":"82133292","dot_number":"2705049","report_state":"CA","report_number":"N9PI008008","insp_date":"2024-07-11 00:00:00","insp_start_time":"1824","insp_end_time":"1843","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15441582","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-07-16 21:44:00","snet_input_date":"2024-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-16 21:44:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:26:14.000000Z","updated_at":"2025-03-17T20:26:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10043026,"change_date":"2024-07-16 21:44:00","inspection_id":"82133292","insp_unit_id":"201915423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:03.000000Z","updated_at":"2025-03-17T23:27:03.000000Z"}]},{"id":6234230,"change_date":"2024-07-16 21:44:00","inspection_id":"82134396","dot_number":"2705049","report_state":"CA","report_number":"NBH0008014","insp_date":"2024-07-09 00:00:00","insp_start_time":"0838","insp_end_time":"0851","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"15441494","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-07-16 21:44:00","snet_input_date":"2024-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-16 21:44:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:26:14.000000Z","updated_at":"2025-03-17T20:26:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10044650,"change_date":"2024-07-16 21:44:00","inspection_id":"82134396","insp_unit_id":"201917171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"34165416","created_at":"2025-03-17T23:27:03.000000Z","updated_at":"2025-03-17T23:27:03.000000Z"}]},{"id":6145180,"change_date":"2024-07-03 21:40:00","inspection_id":"82038763","dot_number":"2705049","report_state":"CA","report_number":"NAHY006728","insp_date":"2024-07-02 00:00:00","insp_start_time":"1822","insp_end_time":"1855","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15429078","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:35.000000Z","updated_at":"2025-03-17T20:24:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9898741,"change_date":"2024-07-03 21:40:00","inspection_id":"82038763","insp_unit_id":"201732710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHITE","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"34168381","created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":6049717,"change_date":"2024-06-21 21:40:00","inspection_id":"81936021","dot_number":"2705049","report_state":"CA","report_number":"UC5R002756","insp_date":"2024-06-20 00:00:00","insp_start_time":"1825","insp_end_time":"1845","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"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":"2024-06-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15414632","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-06-21 21:40:00","snet_input_date":"2024-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-21 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:22:37.000000Z","updated_at":"2025-03-17T20:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9743714,"change_date":"2024-06-21 21:40:00","inspection_id":"81936021","insp_unit_id":"201534543","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHI","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:56.000000Z","updated_at":"2025-03-17T23:23:56.000000Z"}]},{"id":5999116,"change_date":"2024-06-14 21:41:00","inspection_id":"81881429","dot_number":"2705049","report_state":"CA","report_number":"ND7N008075","insp_date":"2024-06-13 00:00:00","insp_start_time":"1837","insp_end_time":"1846","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15404553","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9662258,"change_date":"2024-06-14 21:41:00","inspection_id":"81881429","insp_unit_id":"201409437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"6Y93184","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R62J803547","insp_unit_decal":"Y","insp_unit_decal_number":"33820767","created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":5999119,"change_date":"2024-06-14 21:41:00","inspection_id":"81881432","dot_number":"2705049","report_state":"CA","report_number":"ND7N008078","insp_date":"2024-06-13 00:00:00","insp_start_time":"2055","insp_end_time":"2109","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15404585","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9662261,"change_date":"2024-06-14 21:41:00","inspection_id":"81881432","insp_unit_id":"201409441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"39236A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXE4FS3BDA04857","insp_unit_decal":"Y","insp_unit_decal_number":"33820770","created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":5999215,"change_date":"2024-06-14 21:41:00","inspection_id":"81881529","dot_number":"2705049","report_state":"CA","report_number":"NC43008286","insp_date":"2024-06-13 00:00:00","insp_start_time":"1810","insp_end_time":"1825","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15404935","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9662394,"change_date":"2024-06-14 21:41:00","inspection_id":"81881529","insp_unit_id":"201409581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"6Z28537","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLC4B1R92J803526","insp_unit_decal":"Y","insp_unit_decal_number":"33819316","created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":5912546,"change_date":"2024-06-04 21:43:00","inspection_id":"81787448","dot_number":"2705049","report_state":"CA","report_number":"N9PI007807","insp_date":"2024-06-03 00:00:00","insp_start_time":"1654","insp_end_time":"1713","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15390192","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-06-04 21:43:00","snet_input_date":"2024-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-04 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:19:51.000000Z","updated_at":"2025-03-17T20:19:51.000000Z","inspection_violations":[{"id":9168286,"change_date":"2024-06-04 21:43:00","inspection_id":"81787448","insp_violation_id":"259903949","seq_no":"1","part_no":"393","part_no_section":"24(c)","insp_viol_unit":"1","insp_unit_id":"201233686","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:19.000000Z","updated_at":"2025-03-17T21:50:19.000000Z","normalized_code":"39324C"}],"inspection_per_units":[{"id":9523292,"change_date":"2024-06-04 21:43:00","inspection_id":"81787448","insp_unit_id":"201233686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:46.000000Z","updated_at":"2025-03-17T23:21:46.000000Z"}]},{"id":5879987,"change_date":"2024-05-30 21:43:00","inspection_id":"81751784","dot_number":"2705049","report_state":"CA","report_number":"NC43008230","insp_date":"2024-05-29 00:00:00","insp_start_time":"1729","insp_end_time":"1740","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15383353","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-05-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-30 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:19:08.000000Z","updated_at":"2025-03-17T20:19:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9470368,"change_date":"2024-05-30 21:43:00","inspection_id":"81751784","insp_unit_id":"201163015","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"6D86813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1RX1J800063","insp_unit_decal":"Y","insp_unit_decal_number":"33819278","created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5880557,"change_date":"2024-05-30 21:43:00","inspection_id":"81752368","dot_number":"2705049","report_state":"CA","report_number":"NDS4005378","insp_date":"2024-05-29 00:00:00","insp_start_time":"1735","insp_end_time":"1746","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15383108","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-05-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-30 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:19:25.000000Z","updated_at":"2025-03-17T20:19:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9471219,"change_date":"2024-05-30 21:43:00","inspection_id":"81752368","insp_unit_id":"201163937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"55422V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CA7C1908766","insp_unit_decal":"Y","insp_unit_decal_number":"33821378","created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5870388,"change_date":"2024-05-29 21:41:00","inspection_id":"81741459","dot_number":"2705049","report_state":"CA","report_number":"NC20006896","insp_date":"2024-05-28 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11050","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":"15381971","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:19:05.000000Z","updated_at":"2025-03-17T20:19:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9454854,"change_date":"2024-05-29 21:41:00","inspection_id":"81741459","insp_unit_id":"201142534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X\/WHT","insp_unit_license":"8Y11314","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R61J803882","insp_unit_decal":"Y","insp_unit_decal_number":"33819928","created_at":"2025-03-17T23:21:03.000000Z","updated_at":"2025-03-17T23:21:03.000000Z"}]},{"id":5721860,"change_date":"2024-05-10 21:39:00","inspection_id":"81580557","dot_number":"2705049","report_state":"CA","report_number":"N9PI007672","insp_date":"2024-05-09 00:00:00","insp_start_time":"1613","insp_end_time":"1628","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"15357675","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-05-10 21:39:00","snet_input_date":"2024-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:16:15.000000Z","updated_at":"2025-03-17T20:16:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9215978,"change_date":"2024-05-10 21:39:00","inspection_id":"81580557","insp_unit_id":"200839082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT VAN TRK","insp_unit_license":"39051A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG4F1166772","insp_unit_decal":"Y","insp_unit_decal_number":"33822192","created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"}]},{"id":5691816,"change_date":"2024-05-07 21:43:00","inspection_id":"81548022","dot_number":"2705049","report_state":"CA","report_number":"NDS4005293","insp_date":"2024-05-06 00:00:00","insp_start_time":"1740","insp_end_time":"1757","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15351162","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-05-07 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-07 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:15:30.000000Z","updated_at":"2025-03-17T20:15:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9167807,"change_date":"2024-05-07 21:43:00","inspection_id":"81548022","insp_unit_id":"200775588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT\/2X","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"33821288","created_at":"2025-03-17T23:18:18.000000Z","updated_at":"2025-03-17T23:18:18.000000Z"}]},{"id":5602238,"change_date":"2024-04-25 21:43:00","inspection_id":"81450367","dot_number":"2705049","report_state":"CA","report_number":"NDS4005251","insp_date":"2024-04-24 00:00:00","insp_start_time":"1234","insp_end_time":"1244","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"9600","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":"15335251","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9023934,"change_date":"2024-04-25 21:43:00","inspection_id":"81450367","insp_unit_id":"200586732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT","insp_unit_license":"7R05026","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBHG31U141202741","insp_unit_decal":"Y","insp_unit_decal_number":"33821252","created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":5589519,"change_date":"2024-04-24 21:42:00","inspection_id":"81436545","dot_number":"2705049","report_state":"CA","report_number":"ND7N007883","insp_date":"2024-04-23 00:00:00","insp_start_time":"1742","insp_end_time":"1751","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15331634","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:30.000000Z","updated_at":"2025-03-17T20:13:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9003464,"change_date":"2024-04-24 21:42:00","inspection_id":"81436545","insp_unit_id":"200560049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"36094N2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KLB4B1R81J801809","insp_unit_decal":"Y","insp_unit_decal_number":"33820556","created_at":"2025-03-17T23:16:46.000000Z","updated_at":"2025-03-17T23:16:46.000000Z"}]},{"id":5450653,"change_date":"2024-04-05 21:40:00","inspection_id":"81284835","dot_number":"2705049","report_state":"CA","report_number":"UFEV002750","insp_date":"2024-04-04 00:00:00","insp_start_time":"1845","insp_end_time":"1904","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15307796","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"399837","created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8779496,"change_date":"2024-04-05 21:40:00","inspection_id":"81284835","insp_unit_id":"200268675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"413945","insp_unit_license":"3453623","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"JALC4W165P7014516","insp_unit_decal":"Y","insp_unit_decal_number":"33822825","created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":5343448,"change_date":"2024-03-21 21:41:00","inspection_id":"81168054","dot_number":"2705049","report_state":"CA","report_number":"ND7N007750","insp_date":"2024-03-19 00:00:00","insp_start_time":"1846","insp_end_time":"1856","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"15288598","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02705049","upload_search_indicator":null,"census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"BRIGHT IDEAS CONSTRUCTION","insp_carrier_street":"5649 E PROVINCE","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:38.000000Z","updated_at":"2025-03-17T20:08:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8605383,"change_date":"2024-03-21 21:41:00","inspection_id":"81168054","insp_unit_id":"200034761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"9168861 WT","insp_unit_license":"59142R2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GD374CG0F1900064","insp_unit_decal":"Y","insp_unit_decal_number":"33535487","created_at":"2025-03-17T23:13:04.000000Z","updated_at":"2025-03-17T23:13:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/2705049\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/2705049\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":175}