{"current_page":1,"data":[{"id":5092023,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","dot_number":"3273974","report_state":"TX","report_number":"6SRA9DBGM3","insp_date":"2024-02-15 00:00:00","insp_start_time":"1027","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"23000  WEST RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BOURGEOIS TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9200045","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T20:03:29.000000Z","updated_at":"2025-03-17T20:03:29.000000Z","inspection_violations":[{"id":7850632,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933226","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850633,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933227","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850634,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933228","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850635,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933229","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850636,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933230","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850637,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933231","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7850638,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933232","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3965B"},{"id":7850639,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933233","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3963A1"},{"id":7850640,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933234","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"39347E"},{"id":7850641,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_violation_id":"257933235","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199508202","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8197947,"change_date":"2024-02-20 21:42:00","inspection_id":"80894016","insp_unit_id":"199508202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:17.000000Z","updated_at":"2025-03-17T23:09:17.000000Z"}]},{"id":4454683,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","dot_number":"3273974","report_state":"TX","report_number":"6Q8A9DBHDM","insp_date":"2023-11-16 00:00:00","insp_start_time":"1018","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17000  BECKER RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF COAST","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"14","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9127894","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-11-17 21:41:00","snet_input_date":"2023-11-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-17 21:41:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:51:06.000000Z","updated_at":"2025-03-17T19:51:06.000000Z","inspection_violations":[{"id":6895326,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470242","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39395A"},{"id":6895327,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470243","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3939A"},{"id":6895328,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470244","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3939A"},{"id":6895329,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470245","seq_no":"4","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39324A"},{"id":6895330,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470246","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39378"},{"id":6895331,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470247","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3939A"},{"id":6895332,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470248","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3939A"},{"id":6895333,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470249","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3963A1"},{"id":6895334,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470250","seq_no":"9","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"393205A"},{"id":6895335,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470251","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3963A1"},{"id":6895336,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470252","seq_no":"11","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"393209E"},{"id":6895337,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470253","seq_no":"12","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39345B2"},{"id":6895338,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470254","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39347E"},{"id":6895339,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_violation_id":"256470255","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198127128","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":7163919,"change_date":"2023-11-17 21:41:00","inspection_id":"80196123","insp_unit_id":"198127128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:08.000000Z","updated_at":"2025-03-17T23:00:08.000000Z"}]},{"id":3946823,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","dot_number":"3273974","report_state":"TX","report_number":"6OB89DBHC0","insp_date":"2023-09-08 00:00:00","insp_start_time":"0858","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WM EXCAVATING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"11","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9072195","transaction_code":"C","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-09-11 21:40:00","snet_input_date":"2023-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-11 21:40:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:40:48.000000Z","updated_at":"2025-03-17T19:40:48.000000Z","inspection_violations":[{"id":6102253,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302731","seq_no":"1","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"39324A"},{"id":6102254,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302732","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102255,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302733","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102256,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302734","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102257,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302735","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102258,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302736","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102259,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302737","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"3939A"},{"id":6102260,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302738","seq_no":"8","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"393209D"},{"id":6102261,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302739","seq_no":"9","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"393209E"},{"id":6102262,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302740","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"39347E"},{"id":6102263,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_violation_id":"255302741","seq_no":"11","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"197084506","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:31.000000Z","updated_at":"2025-03-17T21:35:31.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":6346566,"change_date":"2023-09-15 21:40:00","inspection_id":"79633875","insp_unit_id":"197084506","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:19.000000Z","updated_at":"2025-03-17T22:53:19.000000Z"}]},{"id":3423538,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","dot_number":"3273974","report_state":"TX","report_number":"6MDC9DBH9T","insp_date":"2023-06-30 00:00:00","insp_start_time":"1245","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"24000  WEST RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WM EXCAVATING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9019512","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-06-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:30:54.000000Z","updated_at":"2025-03-17T19:30:54.000000Z","inspection_violations":[{"id":5279298,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845518","seq_no":"1","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39324A"},{"id":5279299,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845519","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"},{"id":5279300,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845520","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"},{"id":5279301,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845521","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"},{"id":5279302,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845522","seq_no":"5","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"393205A"},{"id":5279303,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845523","seq_no":"6","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"393209E"},{"id":5279304,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845524","seq_no":"7","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39347A"},{"id":5279305,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_violation_id":"253845525","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195805249","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":5504293,"change_date":"2023-07-03 21:38:00","inspection_id":"79048124","insp_unit_id":"195805249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"}]},{"id":3336276,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","dot_number":"3273974","report_state":"TX","report_number":"6LY99DBEUS","insp_date":"2023-06-15 00:00:00","insp_start_time":"0920","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WM","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"16","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9010293","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-06-21 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-21 21:43:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:28:57.000000Z","updated_at":"2025-03-17T19:28:57.000000Z","inspection_violations":[{"id":5144573,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628089","seq_no":"2","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"393203A"},{"id":5144574,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628090","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5144575,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628091","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5144576,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628092","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5144577,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628093","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5144578,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628094","seq_no":"7","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39378"},{"id":5144579,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628095","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5144580,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628096","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39375C"},{"id":5144581,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628097","seq_no":"10","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39375C"},{"id":5144582,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628098","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922"},{"id":5144583,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628099","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3963A1"},{"id":5144584,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628100","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3963A1"},{"id":5144585,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628101","seq_no":"14","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3965B"},{"id":5144586,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628102","seq_no":"15","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39347E"},{"id":5144587,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628103","seq_no":"16","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39347E"},{"id":5144588,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_violation_id":"253628104","seq_no":"17","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195610905","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5363917,"change_date":"2023-06-21 21:43:00","inspection_id":"78950194","insp_unit_id":"195610905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":2555572,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","dot_number":"3273974","report_state":"TX","report_number":"6J7C9DBH6W","insp_date":"2023-03-08 00:00:00","insp_start_time":"1253","insp_end_time":"1333","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TODDCO","shipping_paper_number":"34993","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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":"Y","pen_cen_match":null,"final_status_date":"2023-03-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"13","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8926411","transaction_code":"C","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-03-10 21:41:00","snet_input_date":"2023-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[{"id":3931384,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690313","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39617C"},{"id":3931385,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690314","seq_no":"2","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39324A"},{"id":3931386,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690315","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3939A"},{"id":3931387,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690316","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3939A"},{"id":3931388,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690317","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3939A"},{"id":3931389,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690318","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3939A"},{"id":3931390,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690319","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3965B"},{"id":3931391,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690320","seq_no":"8","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39347G"},{"id":3931392,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690321","seq_no":"9","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39347G"},{"id":3931393,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690322","seq_no":"10","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39347A"},{"id":3931394,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690323","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39347E"},{"id":3931395,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690324","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3963A1"},{"id":3931396,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_violation_id":"251690325","seq_no":"13","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"193897856","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":4113517,"change_date":"2023-03-15 21:42:00","inspection_id":"78065869","insp_unit_id":"193897856","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"93M022M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2145535,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","dot_number":"3273974","report_state":"TX","report_number":"6HND9DNAQ9","insp_date":"2023-01-11 00:00:00","insp_start_time":"1330","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"600  CANE ISLAND PKW","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-01-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8877191","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2023-01-13 21:41:00","snet_input_date":"2023-01-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-13 21:41:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[{"id":3319976,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581380","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39348A"},{"id":3319977,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581381","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3939A"},{"id":3319978,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581382","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3939A"},{"id":3319979,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581383","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39375A1"},{"id":3319980,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581384","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39383G"},{"id":3319981,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581385","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3939A"},{"id":3319982,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581386","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3965B"},{"id":3319983,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_violation_id":"250581387","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192878310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3452846,"change_date":"2023-01-13 21:41:00","inspection_id":"77598487","insp_unit_id":"192878310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"781424G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"}]},{"id":409584,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","dot_number":"3273974","report_state":"TX","report_number":"6AN80KDTOW","insp_date":"2022-05-04 00:00:00","insp_start_time":"0744","insp_end_time":"0850","registration_date":"2022-05-24 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-10 SERVICE ROAD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"14","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8656566","transaction_code":"C","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03273974","upload_search_indicator":"M","census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"BOURGEOIS TRUCKING LLC","insp_carrier_street":"19634 TULLY MEADOWS CT","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1027383","created_at":"2025-03-17T18:34:47.000000Z","updated_at":"2025-03-17T18:34:47.000000Z","inspection_violations":[{"id":640667,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049675","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640668,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049676","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640669,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049677","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640670,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049678","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640671,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049679","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39378"},{"id":640672,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049680","seq_no":"6","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"393209D"},{"id":640673,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049681","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39347E"},{"id":640674,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049682","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39347E"},{"id":640675,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049683","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39353B"},{"id":640676,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049684","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3963A1"},{"id":640677,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049685","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640678,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049686","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":640679,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049687","seq_no":"13","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39351"},{"id":640680,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_violation_id":"246049688","seq_no":"14","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"188893367","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":661372,"change_date":"2022-05-24 21:44:00","inspection_id":"75581657","insp_unit_id":"188893367","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"1M18315","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8RJ624093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3273974\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3273974\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3273974\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3273974\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}