{"current_page":1,"data":[{"id":12181277,"change_date":"2026-06-13 21:35:00","inspection_id":"88136607","dot_number":"2809234","report_state":"CA","report_number":"N97H006414","insp_date":"2026-06-09 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536267","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158329,"change_date":"2026-06-13 21:35:00","inspection_id":"88136607","insp_unit_id":"214089283","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6526","insp_unit_license":"1470280","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC046479","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181388,"change_date":"2026-06-13 21:35:00","inspection_id":"88136724","dot_number":"2809234","report_state":"CA","report_number":"N97H006425","insp_date":"2026-06-09 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536278","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158520,"change_date":"2026-06-13 21:35:00","inspection_id":"88136724","insp_unit_id":"214089487","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6594","insp_unit_license":"1508729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU02GC049763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181278,"change_date":"2026-06-13 21:35:00","inspection_id":"88136608","dot_number":"2809234","report_state":"CA","report_number":"N97H006413","insp_date":"2026-06-09 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536266","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158330,"change_date":"2026-06-13 21:35:00","inspection_id":"88136608","insp_unit_id":"214089284","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6577","insp_unit_license":"1472199","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC047949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181377,"change_date":"2026-06-13 21:35:00","inspection_id":"88136713","dot_number":"2809234","report_state":"CA","report_number":"N97H006424","insp_date":"2026-06-09 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536277","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158504,"change_date":"2026-06-13 21:35:00","inspection_id":"88136713","insp_unit_id":"214089471","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6513","insp_unit_license":"1470274","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05FC046466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181378,"change_date":"2026-06-13 21:35:00","inspection_id":"88136714","dot_number":"2809234","report_state":"CA","report_number":"N97H006423","insp_date":"2026-06-09 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536276","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158505,"change_date":"2026-06-13 21:35:00","inspection_id":"88136714","insp_unit_id":"214089472","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6590","insp_unit_license":"1508726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00GC049759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181387,"change_date":"2026-06-13 21:35:00","inspection_id":"88136723","dot_number":"2809234","report_state":"CA","report_number":"N97H006426","insp_date":"2026-06-09 00:00:00","insp_start_time":"1300","insp_end_time":"1330","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536279","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158519,"change_date":"2026-06-13 21:35:00","inspection_id":"88136723","insp_unit_id":"214089486","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6594","insp_unit_license":"1470935","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC047938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181389,"change_date":"2026-06-13 21:35:00","inspection_id":"88136725","dot_number":"2809234","report_state":"CA","report_number":"N97H006420","insp_date":"2026-06-09 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536273","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158521,"change_date":"2026-06-13 21:35:00","inspection_id":"88136725","insp_unit_id":"214089488","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6606","insp_unit_license":"1510239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC046459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181390,"change_date":"2026-06-13 21:35:00","inspection_id":"88136726","dot_number":"2809234","report_state":"CA","report_number":"N97H006419","insp_date":"2026-06-09 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536272","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158522,"change_date":"2026-06-13 21:35:00","inspection_id":"88136726","insp_unit_id":"214089489","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6603","insp_unit_license":"1510236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06FC046461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181398,"change_date":"2026-06-13 21:35:00","inspection_id":"88136735","dot_number":"2809234","report_state":"CA","report_number":"N97H006422","insp_date":"2026-06-09 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536275","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[{"id":21200660,"change_date":"2026-06-13 21:35:00","inspection_id":"88136735","insp_violation_id":"274896367","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"214089501","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-16T10:06:55.000000Z","updated_at":"2026-06-24T09:40:40.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":21158532,"change_date":"2026-06-13 21:35:00","inspection_id":"88136735","insp_unit_id":"214089501","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6587","insp_unit_license":"1508723","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05GC049756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181399,"change_date":"2026-06-13 21:35:00","inspection_id":"88136736","dot_number":"2809234","report_state":"CA","report_number":"N97H006421","insp_date":"2026-06-09 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536274","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158533,"change_date":"2026-06-13 21:35:00","inspection_id":"88136736","insp_unit_id":"214089502","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6589","insp_unit_license":"1508725","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU09GC049758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181412,"change_date":"2026-06-13 21:35:00","inspection_id":"88136749","dot_number":"2809234","report_state":"CA","report_number":"N97H006428","insp_date":"2026-06-09 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536281","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158553,"change_date":"2026-06-13 21:35:00","inspection_id":"88136749","insp_unit_id":"214089522","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6531","insp_unit_license":"1470284","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU07FC046484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181413,"change_date":"2026-06-13 21:35:00","inspection_id":"88136750","dot_number":"2809234","report_state":"CA","report_number":"N97H006427","insp_date":"2026-06-09 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536280","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158554,"change_date":"2026-06-13 21:35:00","inspection_id":"88136750","insp_unit_id":"214089523","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6583","insp_unit_license":"1472203","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC047955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181423,"change_date":"2026-06-13 21:35:00","inspection_id":"88136760","dot_number":"2809234","report_state":"CA","report_number":"N97H006429","insp_date":"2026-06-09 00:00:00","insp_start_time":"1430","insp_end_time":"1500","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536282","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158569,"change_date":"2026-06-13 21:35:00","inspection_id":"88136760","insp_unit_id":"214089540","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6609","insp_unit_license":"1510240","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04GC049778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181457,"change_date":"2026-06-13 21:35:00","inspection_id":"88136795","dot_number":"2809234","report_state":"CA","report_number":"N97H006418","insp_date":"2026-06-09 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536271","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158626,"change_date":"2026-06-13 21:35:00","inspection_id":"88136795","insp_unit_id":"214089598","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6516","insp_unit_license":"1470245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00FC046469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":12181458,"change_date":"2026-06-13 21:35:00","inspection_id":"88136796","dot_number":"2809234","report_state":"CA","report_number":"N97H006417","insp_date":"2026-06-09 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536270","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158627,"change_date":"2026-06-13 21:35:00","inspection_id":"88136796","insp_unit_id":"214089599","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6547","insp_unit_license":"1470890","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU01FC046500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":12181459,"change_date":"2026-06-13 21:35:00","inspection_id":"88136797","dot_number":"2809234","report_state":"CA","report_number":"N97H006412","insp_date":"2026-06-09 00:00:00","insp_start_time":"0600","insp_end_time":"0630","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536265","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158628,"change_date":"2026-06-13 21:35:00","inspection_id":"88136797","insp_unit_id":"214089600","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6539","insp_unit_license":"1470885","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06FC046492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":12181401,"change_date":"2026-06-13 21:35:00","inspection_id":"88136738","dot_number":"2809234","report_state":"CA","report_number":"N97H006431","insp_date":"2026-06-09 00:00:00","insp_start_time":"1530","insp_end_time":"1600","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69025","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":"3536284","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158536,"change_date":"2026-06-13 21:35:00","inspection_id":"88136738","insp_unit_id":"214089505","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6564","insp_unit_license":"1470933","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU0XFC047936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181422,"change_date":"2026-06-13 21:35:00","inspection_id":"88136759","dot_number":"2809234","report_state":"CA","report_number":"N97H006430","insp_date":"2026-06-09 00:00:00","insp_start_time":"1500","insp_end_time":"1530","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536283","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158568,"change_date":"2026-06-13 21:35:00","inspection_id":"88136759","insp_unit_id":"214089539","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6503","insp_unit_license":"1470236","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06FC046461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":12181449,"change_date":"2026-06-13 21:35:00","inspection_id":"88136786","dot_number":"2809234","report_state":"CA","report_number":"N97H006415","insp_date":"2026-06-09 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536268","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158613,"change_date":"2026-06-13 21:35:00","inspection_id":"88136786","insp_unit_id":"214089584","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6596","insp_unit_license":"1508731","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06GC049765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":12181448,"change_date":"2026-06-13 21:35:00","inspection_id":"88136785","dot_number":"2809234","report_state":"CA","report_number":"N97H006416","insp_date":"2026-06-09 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PS","ci_status_code":"C","location":"335","location_desc":"CA","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"3536269","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-06-16T09:43:50.000000Z","updated_at":"2026-06-24T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158612,"change_date":"2026-06-13 21:35:00","inspection_id":"88136785","insp_unit_id":"214089583","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6506","insp_unit_license":"1470239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU0XFC047936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:37.000000Z"}]},{"id":11429433,"change_date":"2026-03-20 21:40:00","inspection_id":"87345643","dot_number":"2809234","report_state":"CA","report_number":"N97H006110","insp_date":"2026-03-11 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216789","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579906,"change_date":"2026-03-20 21:40:00","inspection_id":"87345643","insp_unit_id":"212245870","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6692","insp_unit_license":"1413694","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00JC052992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429434,"change_date":"2026-03-20 21:40:00","inspection_id":"87345644","dot_number":"2809234","report_state":"CA","report_number":"N97H006111","insp_date":"2026-03-11 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"16216790","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579907,"change_date":"2026-03-20 21:40:00","inspection_id":"87345644","insp_unit_id":"212245871","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6718","insp_unit_license":"1472218","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00FC048383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429435,"change_date":"2026-03-20 21:40:00","inspection_id":"87345645","dot_number":"2809234","report_state":"CA","report_number":"N97H006112","insp_date":"2026-03-11 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216791","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579908,"change_date":"2026-03-20 21:40:00","inspection_id":"87345645","insp_unit_id":"212245872","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6711","insp_unit_license":"1495961","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC048376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429426,"change_date":"2026-03-20 21:40:00","inspection_id":"87345636","dot_number":"2809234","report_state":"CA","report_number":"N97H006103","insp_date":"2026-03-11 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216782","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579899,"change_date":"2026-03-20 21:40:00","inspection_id":"87345636","insp_unit_id":"212245863","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6650","insp_unit_license":"1520073","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05HC051475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429427,"change_date":"2026-03-20 21:40:00","inspection_id":"87345637","dot_number":"2809234","report_state":"CA","report_number":"N97H006104","insp_date":"2026-03-11 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216783","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579900,"change_date":"2026-03-20 21:40:00","inspection_id":"87345637","insp_unit_id":"212245864","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6633","insp_unit_license":"1520058","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05HC051458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429428,"change_date":"2026-03-20 21:40:00","inspection_id":"87345638","dot_number":"2809234","report_state":"CA","report_number":"N97H006105","insp_date":"2026-03-11 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"16216784","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579901,"change_date":"2026-03-20 21:40:00","inspection_id":"87345638","insp_unit_id":"212245865","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6712","insp_unit_license":"1472213","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05FC048377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429429,"change_date":"2026-03-20 21:40:00","inspection_id":"87345639","dot_number":"2809234","report_state":"CA","report_number":"N97H006106","insp_date":"2026-03-11 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"16216785","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579902,"change_date":"2026-03-20 21:40:00","inspection_id":"87345639","insp_unit_id":"212245866","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6649","insp_unit_license":"1520072","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03HC051474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429430,"change_date":"2026-03-20 21:40:00","inspection_id":"87345640","dot_number":"2809234","report_state":"CA","report_number":"N97H006107","insp_date":"2026-03-11 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216786","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579903,"change_date":"2026-03-20 21:40:00","inspection_id":"87345640","insp_unit_id":"212245867","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6673","insp_unit_license":"1413677","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00JC052975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429431,"change_date":"2026-03-20 21:40:00","inspection_id":"87345641","dot_number":"2809234","report_state":"CA","report_number":"N97H006108","insp_date":"2026-03-11 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69355","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":"16216787","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579904,"change_date":"2026-03-20 21:40:00","inspection_id":"87345641","insp_unit_id":"212245868","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6626","insp_unit_license":"1510380","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04GC049795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429432,"change_date":"2026-03-20 21:40:00","inspection_id":"87345642","dot_number":"2809234","report_state":"CA","report_number":"N97H006109","insp_date":"2026-03-11 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69355","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":"16216788","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579905,"change_date":"2026-03-20 21:40:00","inspection_id":"87345642","insp_unit_id":"212245869","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6627","insp_unit_license":"1510381","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06GC049796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429416,"change_date":"2026-03-20 21:40:00","inspection_id":"87345626","dot_number":"2809234","report_state":"CA","report_number":"N97H006093","insp_date":"2026-03-10 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216772","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579889,"change_date":"2026-03-20 21:40:00","inspection_id":"87345626","insp_unit_id":"212245853","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6647","insp_unit_license":"1520071","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU0XHC051472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429417,"change_date":"2026-03-20 21:40:00","inspection_id":"87345627","dot_number":"2809234","report_state":"CA","report_number":"N97H006094","insp_date":"2026-03-10 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216773","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579890,"change_date":"2026-03-20 21:40:00","inspection_id":"87345627","insp_unit_id":"212245854","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6631","insp_unit_license":"1520056","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU01HC051456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429418,"change_date":"2026-03-20 21:40:00","inspection_id":"87345628","dot_number":"2809234","report_state":"CA","report_number":"N97H006095","insp_date":"2026-03-10 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69364","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":"16216774","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579891,"change_date":"2026-03-20 21:40:00","inspection_id":"87345628","insp_unit_id":"212245855","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6656","insp_unit_license":"1413659","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00HC051481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429419,"change_date":"2026-03-20 21:40:00","inspection_id":"87345629","dot_number":"2809234","report_state":"CA","report_number":"N97H006096","insp_date":"2026-03-10 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69364","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":"16216775","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579892,"change_date":"2026-03-20 21:40:00","inspection_id":"87345629","insp_unit_id":"212245856","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6616","insp_unit_license":"1510370","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00HC051481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429420,"change_date":"2026-03-20 21:40:00","inspection_id":"87345630","dot_number":"2809234","report_state":"CA","report_number":"N97H006097","insp_date":"2026-03-10 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216776","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579893,"change_date":"2026-03-20 21:40:00","inspection_id":"87345630","insp_unit_id":"212245857","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6697","insp_unit_license":"1413699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU0XJC052997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429421,"change_date":"2026-03-20 21:40:00","inspection_id":"87345631","dot_number":"2809234","report_state":"CA","report_number":"N97H006098","insp_date":"2026-03-10 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216777","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579894,"change_date":"2026-03-20 21:40:00","inspection_id":"87345631","insp_unit_id":"212245858","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6610","insp_unit_license":"1510241","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06GC049779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11349125,"change_date":"2026-03-11 21:39:00","inspection_id":"87267142","dot_number":"2809234","report_state":"CA","report_number":"UDXH001584","insp_date":"2026-03-10 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"16204133","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422286,"change_date":"2026-03-11 21:39:00","inspection_id":"87267142","insp_unit_id":"212093604","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6718","insp_unit_license":"1472218","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00FC048383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11349124,"change_date":"2026-03-11 21:39:00","inspection_id":"87267141","dot_number":"2809234","report_state":"CA","report_number":"UDXH001583","insp_date":"2026-03-10 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16204132","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422285,"change_date":"2026-03-11 21:39:00","inspection_id":"87267141","insp_unit_id":"212093603","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6650","insp_unit_license":"1520073","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05HC051475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11349164,"change_date":"2026-03-11 21:39:00","inspection_id":"87267183","dot_number":"2809234","report_state":"CA","report_number":"UDXH001585","insp_date":"2026-03-10 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16204134","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422342,"change_date":"2026-03-11 21:39:00","inspection_id":"87267183","insp_unit_id":"212093666","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6692","insp_unit_license":"1413694","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00JC052992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11349165,"change_date":"2026-03-11 21:39:00","inspection_id":"87267184","dot_number":"2809234","report_state":"CA","report_number":"UDXH001586","insp_date":"2026-03-10 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69355","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":"16204135","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422343,"change_date":"2026-03-11 21:39:00","inspection_id":"87267184","insp_unit_id":"212093667","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6626","insp_unit_license":"1510380","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04GC049795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11349166,"change_date":"2026-03-11 21:39:00","inspection_id":"87267185","dot_number":"2809234","report_state":"CA","report_number":"UDXH001587","insp_date":"2026-03-10 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16204136","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422344,"change_date":"2026-03-11 21:39:00","inspection_id":"87267185","insp_unit_id":"212093668","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6711","insp_unit_license":"1495961","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC048376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11349167,"change_date":"2026-03-11 21:39:00","inspection_id":"87267186","dot_number":"2809234","report_state":"CA","report_number":"UDXH001588","insp_date":"2026-03-10 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SF MUNI - FLYNN DIVISION YARD","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"69355","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":"16204137","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-14T09:38:24.000000Z","updated_at":"2026-03-22T09:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19422345,"change_date":"2026-03-11 21:39:00","inspection_id":"87267186","insp_unit_id":"212093669","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6627","insp_unit_license":"1510381","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06GC049796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:15:01.000000Z","updated_at":"2026-03-22T09:13:41.000000Z"}]},{"id":11429423,"change_date":"2026-03-20 21:40:00","inspection_id":"87345633","dot_number":"2809234","report_state":"CA","report_number":"N97H006100","insp_date":"2026-03-10 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69254","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":"16216779","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579896,"change_date":"2026-03-20 21:40:00","inspection_id":"87345633","insp_unit_id":"212245860","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6703","insp_unit_license":"1472205","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC047739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429424,"change_date":"2026-03-20 21:40:00","inspection_id":"87345634","dot_number":"2809234","report_state":"CA","report_number":"N97H006101","insp_date":"2026-03-10 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69254","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":"16216780","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579897,"change_date":"2026-03-20 21:40:00","inspection_id":"87345634","insp_unit_id":"212245861","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6704","insp_unit_license":"1472206","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04FC047740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429425,"change_date":"2026-03-20 21:40:00","inspection_id":"87345635","dot_number":"2809234","report_state":"CA","report_number":"N97H006102","insp_date":"2026-03-10 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216781","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579898,"change_date":"2026-03-20 21:40:00","inspection_id":"87345635","insp_unit_id":"212245862","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6693","insp_unit_license":"1413695","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU02JC052993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":11429422,"change_date":"2026-03-20 21:40:00","inspection_id":"87345632","dot_number":"2809234","report_state":"CA","report_number":"N97H006099","insp_date":"2026-03-10 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69354","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":"16216778","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2026-03-23T09:46:41.000000Z","updated_at":"2026-03-31T09:31:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19579895,"change_date":"2026-03-20 21:40:00","inspection_id":"87345632","insp_unit_id":"212245859","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6725","insp_unit_license":"1495966","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC048390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:07.000000Z","updated_at":"2026-03-31T09:12:18.000000Z"}]},{"id":10319452,"change_date":"2025-12-01 21:39:00","inspection_id":"86446144","dot_number":"2809234","report_state":"CA","report_number":"N97H005830","insp_date":"2025-11-19 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071030","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234108,"change_date":"2025-12-01 21:39:00","inspection_id":"86446144","insp_unit_id":"210334458","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8966","insp_unit_license":"1446484","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU0XJB054629","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319453,"change_date":"2025-12-01 21:39:00","inspection_id":"86446145","dot_number":"2809234","report_state":"CA","report_number":"N97H005831","insp_date":"2025-11-19 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071031","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234109,"change_date":"2025-12-01 21:39:00","inspection_id":"86446145","insp_unit_id":"210334459","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8773","insp_unit_license":"1465056","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR02HC051379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319466,"change_date":"2025-12-01 21:39:00","inspection_id":"86446158","dot_number":"2809234","report_state":"CA","report_number":"N97H005832","insp_date":"2025-11-19 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071032","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234123,"change_date":"2025-12-01 21:39:00","inspection_id":"86446158","insp_unit_id":"210334473","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8778","insp_unit_license":"1465061","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR06HC051384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319467,"change_date":"2025-12-01 21:39:00","inspection_id":"86446159","dot_number":"2809234","report_state":"CA","report_number":"N97H005833","insp_date":"2025-11-19 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071033","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234124,"change_date":"2025-12-01 21:39:00","inspection_id":"86446159","insp_unit_id":"210334474","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8953","insp_unit_license":"1446471","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU09JB054640","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319468,"change_date":"2025-12-01 21:39:00","inspection_id":"86446160","dot_number":"2809234","report_state":"CA","report_number":"N97H005834","insp_date":"2025-11-19 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071034","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234125,"change_date":"2025-12-01 21:39:00","inspection_id":"86446160","insp_unit_id":"210334475","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8935","insp_unit_license":"1446458","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU07JB054622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:37.000000Z"}]},{"id":10319469,"change_date":"2025-12-01 21:39:00","inspection_id":"86446161","dot_number":"2809234","report_state":"CA","report_number":"N97H005835","insp_date":"2025-11-19 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071035","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234126,"change_date":"2025-12-01 21:39:00","inspection_id":"86446161","insp_unit_id":"210334476","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8965","insp_unit_license":"1446483","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU05JB054652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:37.000000Z"}]},{"id":10319437,"change_date":"2025-12-01 21:39:00","inspection_id":"86446129","dot_number":"2809234","report_state":"CA","report_number":"N97H005822","insp_date":"2025-11-18 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071022","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234090,"change_date":"2025-12-01 21:39:00","inspection_id":"86446129","insp_unit_id":"210334438","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8930","insp_unit_license":"1445868","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU03JB054617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319438,"change_date":"2025-12-01 21:39:00","inspection_id":"86446130","dot_number":"2809234","report_state":"CA","report_number":"N97H005823","insp_date":"2025-11-18 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071023","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234091,"change_date":"2025-12-01 21:39:00","inspection_id":"86446130","insp_unit_id":"210334439","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8771","insp_unit_license":"1465054","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR09HC051377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319442,"change_date":"2025-12-01 21:39:00","inspection_id":"86446134","dot_number":"2809234","report_state":"CA","report_number":"N97H005824","insp_date":"2025-11-18 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071024","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234095,"change_date":"2025-12-01 21:39:00","inspection_id":"86446134","insp_unit_id":"210334445","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8959","insp_unit_license":"1446477","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU0XJB054646","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319443,"change_date":"2025-12-01 21:39:00","inspection_id":"86446135","dot_number":"2809234","report_state":"CA","report_number":"N97H005825","insp_date":"2025-11-18 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"16071025","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234096,"change_date":"2025-12-01 21:39:00","inspection_id":"86446135","insp_unit_id":"210334446","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8762","insp_unit_license":"1465045","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR08HC051368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319444,"change_date":"2025-12-01 21:39:00","inspection_id":"86446136","dot_number":"2809234","report_state":"CA","report_number":"N97H005826","insp_date":"2025-11-18 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"16071026","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234097,"change_date":"2025-12-01 21:39:00","inspection_id":"86446136","insp_unit_id":"210334447","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8777","insp_unit_license":"1465060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR04HC051383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319445,"change_date":"2025-12-01 21:39:00","inspection_id":"86446137","dot_number":"2809234","report_state":"CA","report_number":"N97H005827","insp_date":"2025-11-18 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"16071027","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234098,"change_date":"2025-12-01 21:39:00","inspection_id":"86446137","insp_unit_id":"210334448","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8764","insp_unit_license":"1465047","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR06HC051370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319450,"change_date":"2025-12-01 21:39:00","inspection_id":"86446142","dot_number":"2809234","report_state":"CA","report_number":"N97H005828","insp_date":"2025-11-18 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071028","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234106,"change_date":"2025-12-01 21:39:00","inspection_id":"86446142","insp_unit_id":"210334456","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8946","insp_unit_license":"1446464","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU01JB054633","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":10319451,"change_date":"2025-12-01 21:39:00","inspection_id":"86446143","dot_number":"2809234","report_state":"CA","report_number":"N97H005829","insp_date":"2025-11-18 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"16071029","transaction_code":"A","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-12-04T10:30:39.000000Z","updated_at":"2025-12-05T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17234107,"change_date":"2025-12-01 21:39:00","inspection_id":"86446143","insp_unit_id":"210334457","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8770","insp_unit_license":"1465053","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR07HC051376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:40.000000Z","updated_at":"2025-12-05T10:01:36.000000Z"}]},{"id":9794778,"change_date":"2025-09-26 21:40:00","inspection_id":"85893859","dot_number":"2809234","report_state":"CA","report_number":"N97H005640","insp_date":"2025-09-18 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995831","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:12.000000Z","updated_at":"2025-09-30T10:01:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232592,"change_date":"2025-09-26 21:40:00","inspection_id":"85893859","insp_unit_id":"209177628","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8738","insp_unit_license":"1421221","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR07DB043052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794635,"change_date":"2025-09-26 21:40:00","inspection_id":"85893714","dot_number":"2809234","report_state":"CA","report_number":"N97H005631","insp_date":"2025-09-17 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995822","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232374,"change_date":"2025-09-26 21:40:00","inspection_id":"85893714","insp_unit_id":"209177406","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8867","insp_unit_license":"1510252","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU09GC050218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794636,"change_date":"2025-09-26 21:40:00","inspection_id":"85893715","dot_number":"2809234","report_state":"CA","report_number":"N97H005632","insp_date":"2025-09-17 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995823","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108377,"change_date":"2025-09-26 21:40:00","inspection_id":"85893715","insp_violation_id":"268956925","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177407","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232375,"change_date":"2025-09-26 21:40:00","inspection_id":"85893715","insp_unit_id":"209177407","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8633","insp_unit_license":"1421085","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR08DB041701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794637,"change_date":"2025-09-26 21:40:00","inspection_id":"85893716","dot_number":"2809234","report_state":"CA","report_number":"N97H005633","insp_date":"2025-09-17 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995824","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232376,"change_date":"2025-09-26 21:40:00","inspection_id":"85893716","insp_unit_id":"209177408","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8626","insp_unit_license":"1421079","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR04DB041694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794702,"change_date":"2025-09-26 21:40:00","inspection_id":"85893782","dot_number":"2809234","report_state":"CA","report_number":"N97H005634","insp_date":"2025-09-17 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995825","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232474,"change_date":"2025-09-26 21:40:00","inspection_id":"85893782","insp_unit_id":"209177507","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8888","insp_unit_license":"1510061","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU06GC050239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794703,"change_date":"2025-09-26 21:40:00","inspection_id":"85893783","dot_number":"2809234","report_state":"CA","report_number":"N97H005635","insp_date":"2025-09-17 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995826","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232475,"change_date":"2025-09-26 21:40:00","inspection_id":"85893783","insp_unit_id":"209177508","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8872","insp_unit_license":"1510244","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU02GC050223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794704,"change_date":"2025-09-26 21:40:00","inspection_id":"85893784","dot_number":"2809234","report_state":"CA","report_number":"N97H005636","insp_date":"2025-09-17 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43720","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":"15995827","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108479,"change_date":"2025-09-26 21:40:00","inspection_id":"85893784","insp_violation_id":"268957043","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177509","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232476,"change_date":"2025-09-26 21:40:00","inspection_id":"85893784","insp_unit_id":"209177509","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8642","insp_unit_license":"1421094","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR09DB041710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794705,"change_date":"2025-09-26 21:40:00","inspection_id":"85893785","dot_number":"2809234","report_state":"CA","report_number":"N97H005637","insp_date":"2025-09-17 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995828","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108480,"change_date":"2025-09-26 21:40:00","inspection_id":"85893785","insp_violation_id":"268957044","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177510","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232477,"change_date":"2025-09-26 21:40:00","inspection_id":"85893785","insp_unit_id":"209177510","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8647","insp_unit_license":"1421098","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR08DB041715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794776,"change_date":"2025-09-26 21:40:00","inspection_id":"85893857","dot_number":"2809234","report_state":"CA","report_number":"N97H005638","insp_date":"2025-09-17 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995829","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:12.000000Z","updated_at":"2025-09-30T10:01:12.000000Z","inspection_violations":[{"id":16108578,"change_date":"2025-09-26 21:40:00","inspection_id":"85893857","insp_violation_id":"268957144","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177626","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232590,"change_date":"2025-09-26 21:40:00","inspection_id":"85893857","insp_unit_id":"209177626","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8643","insp_unit_license":"1421095","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR00DB041711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794777,"change_date":"2025-09-26 21:40:00","inspection_id":"85893858","dot_number":"2809234","report_state":"CA","report_number":"N97H005639","insp_date":"2025-09-17 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995830","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:12.000000Z","updated_at":"2025-09-30T10:01:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232591,"change_date":"2025-09-26 21:40:00","inspection_id":"85893858","insp_unit_id":"209177627","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8728","insp_unit_license":"1421211","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR04DB043042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:00.000000Z"}]},{"id":9794434,"change_date":"2025-09-26 21:40:00","inspection_id":"85893507","dot_number":"2809234","report_state":"CA","report_number":"N97H005620","insp_date":"2025-09-16 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995811","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232077,"change_date":"2025-09-26 21:40:00","inspection_id":"85893507","insp_unit_id":"209177093","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8632","insp_unit_license":"1421084","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FBH8FR03DB041700","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794435,"change_date":"2025-09-26 21:40:00","inspection_id":"85893508","dot_number":"2809234","report_state":"CA","report_number":"N97H005621","insp_date":"2025-09-16 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995812","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232078,"change_date":"2025-09-26 21:40:00","inspection_id":"85893508","insp_unit_id":"209177094","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8628","insp_unit_license":"1421081","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR08DB041696","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794503,"change_date":"2025-09-26 21:40:00","inspection_id":"85893577","dot_number":"2809234","report_state":"CA","report_number":"N97H005622","insp_date":"2025-09-16 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995813","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232180,"change_date":"2025-09-26 21:40:00","inspection_id":"85893577","insp_unit_id":"209177199","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8601","insp_unit_license":"1421054","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU03DB041743","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794504,"change_date":"2025-09-26 21:40:00","inspection_id":"85893578","dot_number":"2809234","report_state":"CA","report_number":"N97H005623","insp_date":"2025-09-16 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995814","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232181,"change_date":"2025-09-26 21:40:00","inspection_id":"85893578","insp_unit_id":"209177200","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8631","insp_unit_license":"1421083","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR03DB041699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794505,"change_date":"2025-09-26 21:40:00","inspection_id":"85893579","dot_number":"2809234","report_state":"CA","report_number":"N97H005624","insp_date":"2025-09-16 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43720","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":"15995815","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108211,"change_date":"2025-09-26 21:40:00","inspection_id":"85893579","insp_violation_id":"268956745","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177201","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232182,"change_date":"2025-09-26 21:40:00","inspection_id":"85893579","insp_unit_id":"209177201","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8605","insp_unit_license":"1421060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU00DB041747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794506,"change_date":"2025-09-26 21:40:00","inspection_id":"85893580","dot_number":"2809234","report_state":"CA","report_number":"N97H005625","insp_date":"2025-09-16 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995816","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108212,"change_date":"2025-09-26 21:40:00","inspection_id":"85893580","insp_violation_id":"268956746","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177202","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232183,"change_date":"2025-09-26 21:40:00","inspection_id":"85893580","insp_unit_id":"209177202","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8893","insp_unit_license":"1510173","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU0XGC050244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794568,"change_date":"2025-09-26 21:40:00","inspection_id":"85893645","dot_number":"2809234","report_state":"CA","report_number":"N97H005626","insp_date":"2025-09-16 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995817","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108288,"change_date":"2025-09-26 21:40:00","inspection_id":"85893645","insp_violation_id":"268956828","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177295","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232269,"change_date":"2025-09-26 21:40:00","inspection_id":"85893645","insp_unit_id":"209177295","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8611","insp_unit_license":"1421066","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU06DB041753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794569,"change_date":"2025-09-26 21:40:00","inspection_id":"85893646","dot_number":"2809234","report_state":"CA","report_number":"N97H005627","insp_date":"2025-09-16 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"42540","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":"15995818","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108289,"change_date":"2025-09-26 21:40:00","inspection_id":"85893646","insp_violation_id":"268956829","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177296","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232270,"change_date":"2025-09-26 21:40:00","inspection_id":"85893646","insp_unit_id":"209177296","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8746","insp_unit_license":"1421229","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FR06DB043060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794570,"change_date":"2025-09-26 21:40:00","inspection_id":"85893647","dot_number":"2809234","report_state":"CA","report_number":"N97H005628","insp_date":"2025-09-16 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44004","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":"15995819","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[{"id":16108290,"change_date":"2025-09-26 21:40:00","inspection_id":"85893647","insp_violation_id":"268956830","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209177297","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16232271,"change_date":"2025-09-26 21:40:00","inspection_id":"85893647","insp_unit_id":"209177297","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8865","insp_unit_license":"1510258","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU05GC050216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":9794571,"change_date":"2025-09-26 21:40:00","inspection_id":"85893648","dot_number":"2809234","report_state":"CA","report_number":"N97H005629","insp_date":"2025-09-16 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43720","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":"15995820","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-09-30T10:01:11.000000Z","updated_at":"2025-09-30T10:01:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16232272,"change_date":"2025-09-26 21:40:00","inspection_id":"85893648","insp_unit_id":"209177298","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"8836","insp_unit_license":"1495981","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8FU01GC048530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:45:59.000000Z"}]},{"id":8912684,"change_date":"2025-06-16 21:40:00","inspection_id":"84966327","dot_number":"2809234","report_state":"CA","report_number":"N97H005319","insp_date":"2025-06-04 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862642","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603171,"change_date":"2025-06-16 21:40:00","inspection_id":"84966327","insp_unit_id":"207412507","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6572","insp_unit_license":"1470939","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU09FC047944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912685,"change_date":"2025-06-16 21:40:00","inspection_id":"84966328","dot_number":"2809234","report_state":"CA","report_number":"N97H005320","insp_date":"2025-06-04 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862643","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603172,"change_date":"2025-06-16 21:40:00","inspection_id":"84966328","insp_unit_id":"207412508","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6547","insp_unit_license":"1470890","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU01FC046500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912692,"change_date":"2025-06-16 21:40:00","inspection_id":"84966335","dot_number":"2809234","report_state":"CA","report_number":"N97H005321","insp_date":"2025-06-04 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862644","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603179,"change_date":"2025-06-16 21:40:00","inspection_id":"84966335","insp_unit_id":"207412521","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6539","insp_unit_license":"1470885","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU06FC046492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912693,"change_date":"2025-06-16 21:40:00","inspection_id":"84966336","dot_number":"2809234","report_state":"CA","report_number":"N97H005322","insp_date":"2025-06-04 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862645","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603180,"change_date":"2025-06-16 21:40:00","inspection_id":"84966336","insp_unit_id":"207412522","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6602","insp_unit_license":"1510238","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU01GC049771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912694,"change_date":"2025-06-16 21:40:00","inspection_id":"84966337","dot_number":"2809234","report_state":"CA","report_number":"N97H005323","insp_date":"2025-06-04 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862646","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603181,"change_date":"2025-06-16 21:40:00","inspection_id":"84966337","insp_unit_id":"207412523","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6568","insp_unit_license":"1470937","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU01FC047940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912695,"change_date":"2025-06-16 21:40:00","inspection_id":"84966338","dot_number":"2809234","report_state":"CA","report_number":"N97H005324","insp_date":"2025-06-04 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862647","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603182,"change_date":"2025-06-16 21:40:00","inspection_id":"84966338","insp_unit_id":"207412524","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6569","insp_unit_license":"1496053","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC047941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912697,"change_date":"2025-06-16 21:40:00","inspection_id":"84966340","dot_number":"2809234","report_state":"CA","report_number":"N97H005325","insp_date":"2025-06-04 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862648","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603184,"change_date":"2025-06-16 21:40:00","inspection_id":"84966340","insp_unit_id":"207412533","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6506","insp_unit_license":"1470239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU0XFC047936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912698,"change_date":"2025-06-16 21:40:00","inspection_id":"84966341","dot_number":"2809234","report_state":"CA","report_number":"N97H005326","insp_date":"2025-06-04 00:00:00","insp_start_time":"1400","insp_end_time":"1500","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862649","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603185,"change_date":"2025-06-16 21:40:00","inspection_id":"84966341","insp_unit_id":"207412534","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6538","insp_unit_license":"1470884","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04FC046491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912699,"change_date":"2025-06-16 21:40:00","inspection_id":"84966342","dot_number":"2809234","report_state":"CA","report_number":"N97H005327","insp_date":"2025-06-04 00:00:00","insp_start_time":"1500","insp_end_time":"1600","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862650","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603186,"change_date":"2025-06-16 21:40:00","inspection_id":"84966342","insp_unit_id":"207412535","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6538","insp_unit_license":"1470884","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU04FC046491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912700,"change_date":"2025-06-16 21:40:00","inspection_id":"84966343","dot_number":"2809234","report_state":"CA","report_number":"N97H005328","insp_date":"2025-06-04 00:00:00","insp_start_time":"1600","insp_end_time":"1700","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862651","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603187,"change_date":"2025-06-16 21:40:00","inspection_id":"84966343","insp_unit_id":"207412536","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6529","insp_unit_license":"1470282","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU03FC046482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8819677,"change_date":"2025-06-04 21:41:00","inspection_id":"84867471","dot_number":"2809234","report_state":"CA","report_number":"UDXH001046","insp_date":"2025-06-03 00:00:00","insp_start_time":"0730","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"ISLAIS CREEK MUNI FACILITY","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15846567","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-07T10:01:10.000000Z","updated_at":"2025-06-09T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14437884,"change_date":"2025-06-04 21:41:00","inspection_id":"84867471","insp_unit_id":"207231343","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6509","insp_unit_license":"1470272","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC046462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:15.000000Z"}]},{"id":8819678,"change_date":"2025-06-04 21:41:00","inspection_id":"84867472","dot_number":"2809234","report_state":"CA","report_number":"UDXH001047","insp_date":"2025-06-03 00:00:00","insp_start_time":"0830","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"ISLAIS CREEK MUNI FACILITY","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15846568","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-07T10:01:10.000000Z","updated_at":"2025-06-09T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14437885,"change_date":"2025-06-04 21:41:00","inspection_id":"84867472","insp_unit_id":"207231344","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6532","insp_unit_license":"1470879","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU09FC046485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:15.000000Z"}]},{"id":8819679,"change_date":"2025-06-04 21:41:00","inspection_id":"84867473","dot_number":"2809234","report_state":"CA","report_number":"UDXH001048","insp_date":"2025-06-03 00:00:00","insp_start_time":"0930","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"ISLAIS CREEK MUNI FACILITY","county_code_state":"CA","county_code":"075","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15846570","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-07T10:01:10.000000Z","updated_at":"2025-06-09T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14437886,"change_date":"2025-06-04 21:41:00","inspection_id":"84867473","insp_unit_id":"207231345","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6515","insp_unit_license":"1470244","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU09FC046468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:20.000000Z","updated_at":"2025-06-08T09:46:15.000000Z"}]},{"id":8912653,"change_date":"2025-06-16 21:40:00","inspection_id":"84966296","dot_number":"2809234","report_state":"CA","report_number":"N97H005309","insp_date":"2025-06-03 00:00:00","insp_start_time":"0700","insp_end_time":"0800","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862623","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603139,"change_date":"2025-06-16 21:40:00","inspection_id":"84966296","insp_unit_id":"207412472","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6520","insp_unit_license":"1470275","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU02FC046473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912654,"change_date":"2025-06-16 21:40:00","inspection_id":"84966297","dot_number":"2809234","report_state":"CA","report_number":"N97H005310","insp_date":"2025-06-03 00:00:00","insp_start_time":"0800","insp_end_time":"0900","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862624","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603140,"change_date":"2025-06-16 21:40:00","inspection_id":"84966297","insp_unit_id":"207412473","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6509","insp_unit_license":"1470272","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08FC046462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912655,"change_date":"2025-06-16 21:40:00","inspection_id":"84966298","dot_number":"2809234","report_state":"CA","report_number":"N97H005311","insp_date":"2025-06-03 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862625","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603141,"change_date":"2025-06-16 21:40:00","inspection_id":"84966298","insp_unit_id":"207412474","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6515","insp_unit_license":"1470244","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU09FC046468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912656,"change_date":"2025-06-16 21:40:00","inspection_id":"84966299","dot_number":"2809234","report_state":"CA","report_number":"N97H005312","insp_date":"2025-06-03 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862626","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603142,"change_date":"2025-06-16 21:40:00","inspection_id":"84966299","insp_unit_id":"207412475","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6532","insp_unit_license":"1470879","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU90FC046485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912666,"change_date":"2025-06-16 21:40:00","inspection_id":"84966309","dot_number":"2809234","report_state":"CA","report_number":"N97H005313","insp_date":"2025-06-03 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862627","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603152,"change_date":"2025-06-16 21:40:00","inspection_id":"84966309","insp_unit_id":"207412488","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6597","insp_unit_license":"1508732","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU08GC049766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912667,"change_date":"2025-06-16 21:40:00","inspection_id":"84966310","dot_number":"2809234","report_state":"CA","report_number":"N97H005314","insp_date":"2025-06-03 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862628","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603153,"change_date":"2025-06-16 21:40:00","inspection_id":"84966310","insp_unit_id":"207412489","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6573","insp_unit_license":"1472195","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU00FC047945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]},{"id":8912668,"change_date":"2025-06-16 21:40:00","inspection_id":"84966311","dot_number":"2809234","report_state":"CA","report_number":"N97H005315","insp_date":"2025-06-03 00:00:00","insp_start_time":"1300","insp_end_time":"1400","registration_date":null,"region":"PD","ci_status_code":"C","location":"335","location_desc":"SAN FRANCISCO","county_code_state":"CA","county_code":"075","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69070","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":"15862636","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02809234","upload_search_indicator":null,"census_search_date":"2025-06-16 21:40:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-16 21:40:00","insp_carrier_name":"CITY AND COUNTY OF SAN FRANCISCO","insp_carrier_street":"1 S VAN NESS AVENUE 7TH FLOOR","insp_carrier_city":"SAN FRANCISCO","insp_carrier_state":"CA","insp_carrier_zip_code":"94103","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49819","created_at":"2025-06-19T10:00:26.000000Z","updated_at":"2025-06-20T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14603154,"change_date":"2025-06-16 21:40:00","inspection_id":"84966311","insp_unit_id":"207412490","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"NWFL","insp_unit_company":"6544","insp_unit_license":"1470888","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5FYH8YU05FC046497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:24.000000Z","updated_at":"2025-06-20T09:45:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=1","from":1,"last_page":4,"last_page_url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=4","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=3","label":"3","page":3,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=4","label":"4","page":4,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/2809234\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/2809234\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":346}