{"current_page":1,"data":[{"id":12260696,"change_date":"2026-06-23 21:39:00","inspection_id":"88219530","dot_number":"2047670","report_state":"TX","report_number":"7GEB9DGXQX","insp_date":"2026-06-15 00:00:00","insp_start_time":"1139","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GREENDSHADOWS LANDFILL","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":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10003069","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-06-26T09:40:58.000000Z","updated_at":"2026-07-04T09:31:04.000000Z","inspection_violations":[{"id":21340848,"change_date":"2026-06-23 21:39:00","inspection_id":"88219530","insp_violation_id":"275081788","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"214245439","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-26T10:01:38.000000Z","updated_at":"2026-07-04T09:43:49.000000Z","normalized_code":"393134"},{"id":21340849,"change_date":"2026-06-23 21:39:00","inspection_id":"88219530","insp_violation_id":"275081789","seq_no":"2","part_no":"393","part_no_section":"86A1","insp_viol_unit":"1","insp_unit_id":"214245439","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:38.000000Z","updated_at":"2026-07-04T09:43:49.000000Z","normalized_code":"39386A1"}],"inspection_per_units":[{"id":21290848,"change_date":"2026-06-23 21:39:00","inspection_id":"88219530","insp_unit_id":"214245439","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"006","insp_unit_license":"WXX3665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZL40X4RJ320141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:26.000000Z","updated_at":"2026-07-05T09:04:44.000000Z"}]},{"id":12260671,"change_date":"2026-06-23 21:39:00","inspection_id":"88219504","dot_number":"2047670","report_state":"TX","report_number":"7GBC9DBF92","insp_date":"2026-06-12 00:00:00","insp_start_time":"1213","insp_end_time":"1232","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6300  S LAKE HOUSTON","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"10003055","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-06-26T09:40:58.000000Z","updated_at":"2026-07-04T09:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21290809,"change_date":"2026-06-23 21:39:00","inspection_id":"88219504","insp_unit_id":"214245397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":"05","insp_unit_license":"XKF0773","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:26.000000Z","updated_at":"2026-07-05T09:04:44.000000Z"}]},{"id":11851622,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","dot_number":"2047670","report_state":"TX","report_number":"7F499DCAL7","insp_date":"2026-04-30 00:00:00","insp_start_time":"0935","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  HERSHE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9946221","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-04-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-05-10T09:39:37.000000Z","updated_at":"2026-05-18T09:31:12.000000Z","inspection_violations":[{"id":20611321,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_violation_id":"274114654","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213436296","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:59.000000Z","updated_at":"2026-05-18T09:42:49.000000Z","normalized_code":"39360C"},{"id":20611322,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_violation_id":"274114655","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"213436296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:59.000000Z","updated_at":"2026-05-18T09:42:49.000000Z","normalized_code":"3939H"},{"id":20611323,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_violation_id":"274114656","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"213436296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:59.000000Z","updated_at":"2026-05-18T09:42:49.000000Z","normalized_code":"3965B"},{"id":20611324,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_violation_id":"274114657","seq_no":"5","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"213436296","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:59.000000Z","updated_at":"2026-05-18T09:42:49.000000Z","normalized_code":"3922WC"},{"id":20611325,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_violation_id":"274114658","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213436296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:59.000000Z","updated_at":"2026-05-18T09:42:49.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20609707,"change_date":"2026-05-07 21:40:00","inspection_id":"87787767","insp_unit_id":"213436296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"XKF0773","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:57.000000Z","updated_at":"2026-05-18T09:03:47.000000Z"}]},{"id":11760217,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","dot_number":"2047670","report_state":"TX","report_number":"7EW89DGTHC","insp_date":"2026-04-22 00:00:00","insp_start_time":"0841","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9931931","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-04-30T09:39:38.000000Z","updated_at":"2026-05-08T09:31:06.000000Z","inspection_violations":[{"id":20455317,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_violation_id":"273881416","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213248713","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T09:59:51.000000Z","updated_at":"2026-05-08T09:42:26.000000Z","normalized_code":"39617C"},{"id":20455318,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_violation_id":"273881417","seq_no":"2","part_no":"392","part_no_section":"9A2","insp_viol_unit":"1","insp_unit_id":"213248713","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-01T09:59:51.000000Z","updated_at":"2026-05-08T09:42:26.000000Z","normalized_code":"3929A2"},{"id":20455319,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_violation_id":"273881418","seq_no":"3","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"213248713","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-01T09:59:51.000000Z","updated_at":"2026-05-08T09:42:26.000000Z","normalized_code":"39351"},{"id":20455320,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_violation_id":"273881419","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213248713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T09:59:51.000000Z","updated_at":"2026-05-08T09:42:26.000000Z","normalized_code":"39311"},{"id":20455321,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_violation_id":"273881420","seq_no":"5","part_no":"393","part_no_section":"45DCUV","insp_viol_unit":"1","insp_unit_id":"213248713","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T09:59:51.000000Z","updated_at":"2026-05-08T09:42:26.000000Z","normalized_code":"39345DCUV"}],"inspection_per_units":[{"id":20460538,"change_date":"2026-04-27 21:39:00","inspection_id":"87690574","insp_unit_id":"213248713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"XKF0773","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:40.000000Z","updated_at":"2026-05-08T09:03:51.000000Z"}]},{"id":11842564,"change_date":"2026-05-06 21:41:00","inspection_id":"87778220","dot_number":"2047670","report_state":"TX","report_number":"7EV79DCO2C","insp_date":"2026-04-21 00:00:00","insp_start_time":"0730","insp_end_time":"0803","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5700  FM 1960 RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9944444","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-05-06 21:41:00","snet_input_date":"2026-04-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-05-09T09:40:21.000000Z","updated_at":"2026-05-16T13:24:41.000000Z","inspection_violations":[{"id":20595832,"change_date":"2026-05-06 21:41:00","inspection_id":"87778220","insp_violation_id":"274094054","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213418804","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:24.000000Z","updated_at":"2026-05-16T12:57:12.000000Z","normalized_code":"39360C"},{"id":20595833,"change_date":"2026-05-06 21:41:00","inspection_id":"87778220","insp_violation_id":"274094055","seq_no":"2","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"213418804","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-09T10:01:24.000000Z","updated_at":"2026-05-16T12:57:12.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":20595016,"change_date":"2026-05-06 21:41:00","inspection_id":"87778220","insp_unit_id":"213418804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"XKF0772","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:35.000000Z","updated_at":"2026-05-16T12:32:21.000000Z"}]},{"id":11466986,"change_date":"2026-03-24 21:40:00","inspection_id":"87385383","dot_number":"2047670","report_state":"TX","report_number":"V262258238","insp_date":"2026-03-19 00:00:00","insp_start_time":"1432","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13000 SOUTH POST OAK","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE SYSTEMS LLC","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":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9893264","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-03-27T09:45:28.000000Z","updated_at":"2026-04-04T09:31:30.000000Z","inspection_violations":[{"id":19353106,"change_date":"2026-03-24 21:40:00","inspection_id":"87385383","insp_violation_id":"272613477","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"212313588","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-27T10:10:23.000000Z","updated_at":"2026-04-03T09:55:26.000000Z","normalized_code":"393134"},{"id":19353107,"change_date":"2026-03-24 21:40:00","inspection_id":"87385383","insp_violation_id":"272613478","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"212313588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:23.000000Z","updated_at":"2026-04-03T09:55:26.000000Z","normalized_code":"3939H"},{"id":19353108,"change_date":"2026-03-24 21:40:00","inspection_id":"87385383","insp_violation_id":"272613479","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212313588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:23.000000Z","updated_at":"2026-04-03T09:55:26.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19640646,"change_date":"2026-03-24 21:40:00","inspection_id":"87385383","insp_unit_id":"212313588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:05.000000Z","updated_at":"2026-04-04T09:05:12.000000Z"}]},{"id":11277192,"change_date":"2026-03-03 21:36:00","inspection_id":"87191727","dot_number":"2047670","report_state":"TX","report_number":"7DE79DCTEH","insp_date":"2026-02-27 00:00:00","insp_start_time":"0702","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700 W MAIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9870597","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-03-03 21:36:00","snet_input_date":"2026-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-03 21:36:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-03-06T10:39:43.000000Z","updated_at":"2026-03-14T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19286495,"change_date":"2026-03-03 21:36:00","inspection_id":"87191727","insp_unit_id":"211943961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"006","insp_unit_license":"WXX3665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZL40X4RJ320141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:07.000000Z","updated_at":"2026-03-14T09:03:25.000000Z"}]},{"id":10571255,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","dot_number":"2047670","report_state":"TX","report_number":"7BR99DBE7E","insp_date":"2025-12-30 00:00:00","insp_start_time":"0915","insp_end_time":"1010","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":"BAYOU CITY WASTE SYSTEM LLC","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":"2026-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9805810","transaction_code":"C","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2025-12-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-01-08T10:34:21.000000Z","updated_at":"2026-01-17T10:30:35.000000Z","inspection_violations":[{"id":17773048,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035825","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"3922RG"},{"id":17773049,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035826","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"39311"},{"id":17773050,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035827","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"3939"},{"id":17773051,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035828","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"39311"},{"id":17773052,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035829","seq_no":"5","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"39360C"},{"id":17773053,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_violation_id":"271035830","seq_no":"6","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210931225","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:36.000000Z","updated_at":"2026-01-17T10:31:10.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":17725608,"change_date":"2026-01-06 21:39:00","inspection_id":"86709167","insp_unit_id":"210931225","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:50.000000Z"}]},{"id":10627097,"change_date":"2026-01-12 21:39:00","inspection_id":"86767824","dot_number":"2047670","report_state":"TX","report_number":"7BG89DCC45","insp_date":"2025-12-19 00:00:00","insp_start_time":"0842","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0008 IN HARRIS CO. (690-758","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9813275","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2026-01-12 21:39:00","snet_input_date":"2025-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-12 21:39:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2026-01-15T10:37:05.000000Z","updated_at":"2026-01-23T10:30:44.000000Z","inspection_violations":[{"id":17870918,"change_date":"2026-01-12 21:39:00","inspection_id":"86767824","insp_violation_id":"271146001","seq_no":"1","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"211034035","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:43:02.000000Z","updated_at":"2026-01-23T10:31:22.000000Z","normalized_code":"3939TS"},{"id":17870919,"change_date":"2026-01-12 21:39:00","inspection_id":"86767824","insp_violation_id":"271146002","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211034035","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:43:02.000000Z","updated_at":"2026-01-23T10:31:22.000000Z","normalized_code":"3922RG"},{"id":17870920,"change_date":"2026-01-12 21:39:00","inspection_id":"86767824","insp_violation_id":"271146003","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211034035","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:43:02.000000Z","updated_at":"2026-01-23T10:31:22.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17821309,"change_date":"2026-01-12 21:39:00","inspection_id":"86767824","insp_unit_id":"211034035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:09:24.000000Z","updated_at":"2026-01-24T10:01:06.000000Z"}]},{"id":10333996,"change_date":"2025-12-02 21:39:00","inspection_id":"86461186","dot_number":"2047670","report_state":"TX","report_number":"7ASF9DAP1X","insp_date":"2025-11-25 00:00:00","insp_start_time":"1502","insp_end_time":"1527","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10700 S RED BLUFF RD","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2025-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9773072","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-12-02 21:39:00","snet_input_date":"2025-11-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-02 21:39:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-12-05T10:32:34.000000Z","updated_at":"2025-12-06T10:30:55.000000Z","inspection_violations":[{"id":17286917,"change_date":"2025-12-02 21:39:00","inspection_id":"86461186","insp_violation_id":"270407425","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210366910","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:24.000000Z","updated_at":"2025-12-06T10:31:28.000000Z","normalized_code":"39347E"},{"id":17286918,"change_date":"2025-12-02 21:39:00","inspection_id":"86461186","insp_violation_id":"270407426","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"210366910","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:24.000000Z","updated_at":"2025-12-06T10:31:28.000000Z","normalized_code":"39353B"},{"id":17286919,"change_date":"2025-12-02 21:39:00","inspection_id":"86461186","insp_violation_id":"270407427","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210366910","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:24.000000Z","updated_at":"2025-12-06T10:31:28.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":17259417,"change_date":"2025-12-02 21:39:00","inspection_id":"86461186","insp_unit_id":"210366910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:55.000000Z","updated_at":"2025-12-06T10:00:57.000000Z"}]},{"id":10119454,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","dot_number":"2047670","report_state":"TX","report_number":"V252080903","insp_date":"2025-10-30 00:00:00","insp_start_time":"1041","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 1093","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE SYSTEMS LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9747112","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-11-04 21:40:00","snet_input_date":"2025-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-11-07T10:31:46.000000Z","updated_at":"2025-11-08T10:31:21.000000Z","inspection_violations":[{"id":16777154,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","insp_violation_id":"269726044","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"209836707","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-11-07T10:31:45.000000Z","updated_at":"2025-11-08T10:31:57.000000Z","normalized_code":"393134"},{"id":16777155,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","insp_violation_id":"269726045","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209836707","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:45.000000Z","updated_at":"2025-11-08T10:31:57.000000Z","normalized_code":"39360C"},{"id":16777156,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","insp_violation_id":"269726046","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209836707","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:45.000000Z","updated_at":"2025-11-08T10:31:57.000000Z","normalized_code":"39378"},{"id":16777157,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","insp_violation_id":"269726047","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209836707","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:45.000000Z","updated_at":"2025-11-08T10:31:57.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16838014,"change_date":"2025-11-04 21:40:00","inspection_id":"86235934","insp_unit_id":"209836707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:39.000000Z","updated_at":"2025-11-08T10:01:43.000000Z"}]},{"id":9635410,"change_date":"2025-09-09 21:41:00","inspection_id":"85726669","dot_number":"2047670","report_state":"TX","report_number":"V252012981","insp_date":"2025-09-05 00:00:00","insp_start_time":"1108","insp_end_time":"1137","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9690946","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-09-11T10:47:14.000000Z","updated_at":"2025-09-13T10:47:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15918718,"change_date":"2025-09-09 21:41:00","inspection_id":"85726669","insp_unit_id":"208835259","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:50.000000Z","updated_at":"2025-09-13T10:00:04.000000Z"}]},{"id":9570413,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","dot_number":"2047670","report_state":"TX","report_number":"V252003476","insp_date":"2025-08-28 00:00:00","insp_start_time":"0944","insp_end_time":"1029","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"2025-09-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9683454","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-09-02 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-09-06T10:43:07.000000Z","updated_at":"2025-09-06T10:43:07.000000Z","inspection_violations":[{"id":15633014,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","insp_violation_id":"268408733","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208705379","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:36.000000Z","updated_at":"2025-09-06T10:47:36.000000Z","normalized_code":"39347E"},{"id":15633015,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","insp_violation_id":"268408734","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208705379","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:36.000000Z","updated_at":"2025-09-06T10:47:36.000000Z","normalized_code":"39353B"},{"id":15633016,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","insp_violation_id":"268408735","seq_no":"3","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"208705379","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-09-06T10:47:36.000000Z","updated_at":"2025-09-06T10:47:36.000000Z","normalized_code":"3965BHWSLIW"},{"id":15633017,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","insp_violation_id":"268408736","seq_no":"4","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"208705379","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:36.000000Z","updated_at":"2025-09-06T10:47:36.000000Z","normalized_code":"3965BHWSLIW"}],"inspection_per_units":[{"id":15797785,"change_date":"2025-09-02 21:40:00","inspection_id":"85659094","insp_unit_id":"208705379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:19.000000Z","updated_at":"2025-09-09T09:47:19.000000Z"}]},{"id":9451332,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","dot_number":"2047670","report_state":"TX","report_number":"77Y79DBE3K","insp_date":"2025-08-15 00:00:00","insp_start_time":"0850","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14901  HOLLISTER ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE","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":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9669848","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-08-23T10:46:31.000000Z","updated_at":"2025-08-23T10:46:31.000000Z","inspection_violations":[{"id":15391954,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121024","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"3965B"},{"id":15391955,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121025","seq_no":"9","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"39355D1"},{"id":15391956,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121026","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"39617C"},{"id":15391957,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121027","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"3939"},{"id":15391958,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121028","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"3922RG"},{"id":15391959,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121029","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"3939"},{"id":15391960,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121030","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"39378"},{"id":15391961,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121031","seq_no":"6","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"39360C"},{"id":15391962,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_violation_id":"268121032","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"208473943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:45:05.000000Z","updated_at":"2025-08-23T10:48:27.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":15584808,"change_date":"2025-08-19 21:40:00","inspection_id":"85533575","insp_unit_id":"208473943","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:11.000000Z"}]},{"id":9251056,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","dot_number":"2047670","report_state":"TX","report_number":"77BC9DCK6Z","insp_date":"2025-07-23 00:00:00","insp_start_time":"1244","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7400  CARVER RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9647808","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-07-30T10:01:23.000000Z","updated_at":"2025-07-30T10:01:23.000000Z","inspection_violations":[{"id":14982808,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661026","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"39378"},{"id":14982809,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661027","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"3939H"},{"id":14982810,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661028","seq_no":"3","part_no":"393","part_no_section":"104F3","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"393104F3"},{"id":14982811,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661029","seq_no":"4","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"393134"},{"id":14982812,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661030","seq_no":"5","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"393201D"},{"id":14982813,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661031","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"39617C"},{"id":14982814,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_violation_id":"267661032","seq_no":"7","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208086313","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-28T10:49:50.000000Z","updated_at":"2025-07-29T10:43:45.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":15224801,"change_date":"2025-07-25 21:40:00","inspection_id":"85322858","insp_unit_id":"208086313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:36.000000Z","updated_at":"2025-07-29T09:46:04.000000Z"}]},{"id":8980555,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","dot_number":"2047670","report_state":"TX","report_number":"76CC9DJM6E","insp_date":"2025-06-18 00:00:00","insp_start_time":"1234","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2025-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9615144","transaction_code":"C","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-06-24 21:41:00","snet_input_date":"2025-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-24 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-06-28T10:01:06.000000Z","updated_at":"2025-06-30T10:00:29.000000Z","inspection_violations":[{"id":14436680,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040211","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"3922RG"},{"id":14436681,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040212","seq_no":"2","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"39375A"},{"id":14436682,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040213","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"39345B2UV"},{"id":14436683,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040214","seq_no":"4","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"39345B2UV"},{"id":14436684,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040215","seq_no":"5","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"39345B2UV"},{"id":14436685,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040216","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"39345"},{"id":14436686,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_violation_id":"267040217","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207550347","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:58.000000Z","updated_at":"2025-06-29T10:15:52.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14725554,"change_date":"2025-06-25 21:40:00","inspection_id":"85032174","insp_unit_id":"207550347","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:13.000000Z","updated_at":"2025-06-29T09:45:44.000000Z"}]},{"id":8662041,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","dot_number":"2047670","report_state":"TX","report_number":"75CD9DCA24","insp_date":"2025-05-13 00:00:00","insp_start_time":"1325","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700  W TIDWELL","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"55001","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9579763","transaction_code":"C","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-05-16 21:43:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-05-19T10:04:31.000000Z","updated_at":"2025-06-04T10:01:09.000000Z","inspection_violations":[{"id":14034844,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582248","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"393134"},{"id":14034845,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582249","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"39311"},{"id":14034846,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582250","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"3939"},{"id":14034847,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582251","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"39375C"},{"id":14034848,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582252","seq_no":"5","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"393203C"},{"id":14034849,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_violation_id":"266582253","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207155555","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:15.000000Z","updated_at":"2025-06-03T10:17:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14365817,"change_date":"2025-05-30 21:41:00","inspection_id":"84700723","insp_unit_id":"207155555","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:23.000000Z","updated_at":"2025-06-03T09:45:54.000000Z"}]},{"id":9964129,"change_date":"2025-10-16 21:40:00","inspection_id":"86072375","dot_number":"2047670","report_state":"TX","report_number":"74Z99DCB4F","insp_date":"2025-04-30 00:00:00","insp_start_time":"0921","insp_end_time":"0937","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8100  STEDMAN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9727925","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-04-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-10-19T10:01:49.000000Z","updated_at":"2025-10-20T10:01:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16543339,"change_date":"2025-10-16 21:40:00","inspection_id":"86072375","insp_unit_id":"209513883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:47:02.000000Z","updated_at":"2025-10-20T09:46:41.000000Z"}]},{"id":8298699,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","dot_number":"2047670","report_state":"TX","report_number":"V251821526","insp_date":"2025-03-20 00:00:00","insp_start_time":"1012","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"2D001","location_desc":"TX288 NB ANGLETON SCALE","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAYOU CITY WASTE SYSTEMS LLC","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":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9541644","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-03-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-04-07T10:22:20.000000Z","updated_at":"2025-04-08T10:09:54.000000Z","inspection_violations":[{"id":13050236,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450170","seq_no":"1","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"206163039","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"39355C1"},{"id":13050237,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450171","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206163039","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"3939"},{"id":13050238,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450172","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206163039","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"3939TS"},{"id":13050239,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450173","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206163039","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"39617C"},{"id":13050240,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450174","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206163039","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"3922RG"},{"id":13050241,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_violation_id":"265450175","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:53:15.000000Z","updated_at":"2025-04-07T11:01:37.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":13455459,"change_date":"2025-04-04 21:41:00","inspection_id":"84318147","insp_unit_id":"206163039","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:13:05.000000Z","updated_at":"2025-04-08T10:01:35.000000Z"}]},{"id":7641999,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","dot_number":"2047670","report_state":"TX","report_number":"72099DGPHS","insp_date":"2025-01-13 00:00:00","insp_start_time":"0939","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","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":"Y","pen_cen_match":null,"final_status_date":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9475358","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:56:59.000000Z","updated_at":"2025-03-17T20:56:59.000000Z","inspection_violations":[{"id":11941794,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043273","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"39360C"},{"id":11941795,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043274","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"39378"},{"id":11941796,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043275","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"3939"},{"id":11941797,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043276","seq_no":"4","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"393134"},{"id":11941798,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043277","seq_no":"5","part_no":"393","part_no_section":"104F3","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"393104F3"},{"id":11941799,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043278","seq_no":"6","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"393203C"},{"id":11941800,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_violation_id":"264043279","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204878063","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:12.000000Z","updated_at":"2025-03-17T22:04:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12330997,"change_date":"2025-01-16 21:41:00","inspection_id":"83627826","insp_unit_id":"204878063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:06.000000Z","updated_at":"2025-03-17T23:51:06.000000Z"}]},{"id":7584745,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","dot_number":"2047670","report_state":"TX","report_number":"71PC9DGPHC","insp_date":"2025-01-02 00:00:00","insp_start_time":"1249","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11100  HEMPSTEAD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9469591","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2025-01-09 21:40:00","snet_input_date":"2025-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[{"id":11856379,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_violation_id":"263843533","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204731497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"3922RG"},{"id":11856380,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_violation_id":"263843534","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204731497","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"39360C"},{"id":11856381,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_violation_id":"263843535","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204731497","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"39378"},{"id":11856382,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_violation_id":"263843536","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204731497","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"39375C"},{"id":11856383,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_violation_id":"263843537","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204731497","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12238058,"change_date":"2025-01-09 21:40:00","inspection_id":"83567741","insp_unit_id":"204731497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"}]},{"id":6177591,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","dot_number":"2047670","report_state":"TX","report_number":"6WKF9DCEQZ","insp_date":"2024-07-01 00:00:00","insp_start_time":"1540","insp_end_time":"1610","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500  PECH RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9320876","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9592708,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545952","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39395A"},{"id":9592709,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545953","seq_no":"2","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3929A2"},{"id":9592710,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545954","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39360C"},{"id":9592711,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545955","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39355D1"},{"id":9592712,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545956","seq_no":"5","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"393203C"},{"id":9592713,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545957","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3939A"},{"id":9592714,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545958","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3939A"},{"id":9592715,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_violation_id":"260545959","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201800803","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9951870,"change_date":"2024-07-09 21:43:00","inspection_id":"82073712","insp_unit_id":"201800803","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":6119577,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","dot_number":"2047670","report_state":"TX","report_number":"6W7D9DBA99","insp_date":"2024-06-18 00:00:00","insp_start_time":"1316","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE SYSTEMS LLC","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-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9313188","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:23:49.000000Z","updated_at":"2025-03-17T20:23:49.000000Z","inspection_violations":[{"id":9500287,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","insp_violation_id":"260412664","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"201680964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39021A"},{"id":9500288,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","insp_violation_id":"260412665","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201680964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"3965B"},{"id":9500289,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","insp_violation_id":"260412666","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201680964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"3939A"},{"id":9500290,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","insp_violation_id":"260412667","seq_no":"4","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"201680964","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39375A4"}],"inspection_per_units":[{"id":9857045,"change_date":"2024-07-01 21:44:00","inspection_id":"82011208","insp_unit_id":"201680964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":5757613,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","dot_number":"2047670","report_state":"TX","report_number":"6V199DAZKW","insp_date":"2024-05-07 00:00:00","insp_start_time":"0925","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9273513","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[{"id":8911855,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525267","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8911856,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525268","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39375A3"},{"id":8911857,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525269","seq_no":"3","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"393104B"},{"id":8911858,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525270","seq_no":"4","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"393134"},{"id":8911859,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525271","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39345"},{"id":8911860,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525272","seq_no":"6","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3929"},{"id":8911861,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_violation_id":"259525273","seq_no":"7","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"200911138","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":9273590,"change_date":"2024-05-15 21:44:00","inspection_id":"81619440","insp_unit_id":"200911138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5461404,"change_date":"2024-04-08 21:44:00","inspection_id":"81296678","dot_number":"2047670","report_state":"TX","report_number":"6U3B9DNOJJ","insp_date":"2024-04-03 00:00:00","insp_start_time":"1102","insp_end_time":"1123","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GREEN SHADOW LANDFILL","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":"Y","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9241289","transaction_code":"A","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[{"id":8431742,"change_date":"2024-04-08 21:44:00","inspection_id":"81296678","insp_violation_id":"258808678","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200292279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39348A"},{"id":8431743,"change_date":"2024-04-08 21:44:00","inspection_id":"81296678","insp_violation_id":"258808679","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200292279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8797226,"change_date":"2024-04-08 21:44:00","inspection_id":"81296678","insp_unit_id":"200292279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"}]},{"id":5260633,"change_date":"2024-03-11 21:44:00","inspection_id":"81077800","dot_number":"2047670","report_state":"TX","report_number":"6TBE9DBFYR","insp_date":"2024-03-06 00:00:00","insp_start_time":"1405","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15300  BEAUMONT HWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9219408","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[{"id":8112514,"change_date":"2024-03-11 21:44:00","inspection_id":"81077800","insp_violation_id":"258321739","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"199857755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":8471242,"change_date":"2024-03-11 21:44:00","inspection_id":"81077800","insp_unit_id":"199857755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":"05","insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"}]},{"id":5155669,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","dot_number":"2047670","report_state":"TX","report_number":"6T279DCNKF","insp_date":"2024-02-26 00:00:00","insp_start_time":"0703","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  NORTH SERVICE","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9209622","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7952873,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091533","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39021A"},{"id":7952874,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091534","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3929"},{"id":7952875,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091535","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7952876,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091536","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7952877,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091537","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39375A"},{"id":7952878,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091538","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39347E"},{"id":7952879,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091539","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39353B"},{"id":7952880,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_violation_id":"258091540","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199645350","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8301521,"change_date":"2024-02-28 21:42:00","inspection_id":"80963477","insp_unit_id":"199645350","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"}]},{"id":4989839,"change_date":"2024-02-06 21:42:00","inspection_id":"80782229","dot_number":"2047670","report_state":"TX","report_number":"6SAD9DKY09","insp_date":"2024-01-29 00:00:00","insp_start_time":"1319","insp_end_time":"1344","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9189201","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-01-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7685088,"change_date":"2024-02-06 21:42:00","inspection_id":"80782229","insp_violation_id":"257693781","seq_no":"1","part_no":"393","part_no_section":"104(c)","insp_viol_unit":"1","insp_unit_id":"199295568","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"393104C"}],"inspection_per_units":[{"id":8031103,"change_date":"2024-02-06 21:42:00","inspection_id":"80782229","insp_unit_id":"199295568","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4840163,"change_date":"2024-01-16 21:45:00","inspection_id":"80618488","dot_number":"2047670","report_state":"TX","report_number":"6RRF9DJVZY","insp_date":"2024-01-10 00:00:00","insp_start_time":"1540","insp_end_time":"1609","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9172924","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:58:47.000000Z","updated_at":"2025-03-17T19:58:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7787479,"change_date":"2024-01-16 21:45:00","inspection_id":"80618488","insp_unit_id":"198975892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:36.000000Z","updated_at":"2025-03-17T23:05:36.000000Z"}]},{"id":4933921,"change_date":"2024-01-30 21:42:00","inspection_id":"80720900","dot_number":"2047670","report_state":"TX","report_number":"6RKA9DFX7Y","insp_date":"2024-01-03 00:00:00","insp_start_time":"1021","insp_end_time":"1038","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4300  ALLEN GENOA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9183286","transaction_code":"A","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2024-01-30 21:42:00","snet_input_date":"2024-01-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-30 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T20:00:29.000000Z","updated_at":"2025-03-17T20:00:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7940004,"change_date":"2024-01-30 21:42:00","inspection_id":"80720900","insp_unit_id":"199177275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:59.000000Z","updated_at":"2025-03-17T23:06:59.000000Z"}]},{"id":4728041,"change_date":"2024-12-04 21:41:00","inspection_id":"80495959","dot_number":"2047670","report_state":"TX","report_number":"6R4G9DGXQ8","insp_date":"2023-12-18 00:00:00","insp_start_time":"1603","insp_end_time":"1614","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE","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":"Y","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9159793","transaction_code":"C","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7605449,"change_date":"2024-12-04 21:41:00","inspection_id":"80495959","insp_unit_id":"204183778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"}]},{"id":4656246,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","dot_number":"2047670","report_state":"TX","report_number":"6R0H9DCRNL","insp_date":"2023-12-14 00:00:00","insp_start_time":"1732","insp_end_time":"1756","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11000  WESTHEIMER RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9151301","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-12-18 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:55:00.000000Z","updated_at":"2025-03-17T19:55:00.000000Z","inspection_violations":[{"id":7198685,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365508","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939H"},{"id":7198686,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365509","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939"},{"id":7198687,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365510","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939"},{"id":7198688,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365511","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3922RG"},{"id":7198689,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365512","seq_no":"5","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39355D1"},{"id":7198690,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365513","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939"},{"id":7198691,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365514","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939"},{"id":7198692,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_violation_id":"263365515","seq_no":"8","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"204300527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"999"}],"inspection_per_units":[{"id":7489158,"change_date":"2024-12-10 21:41:00","inspection_id":"80417638","insp_unit_id":"204300527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"}]},{"id":4634455,"change_date":"2024-12-10 21:41:00","inspection_id":"80393759","dot_number":"2047670","report_state":"TX","report_number":"6QU89DCPAG","insp_date":"2023-12-08 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MCCARTY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9146882","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7163415,"change_date":"2024-12-10 21:41:00","inspection_id":"80393759","insp_violation_id":"263366001","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204300672","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"3922RG"},{"id":7163416,"change_date":"2024-12-10 21:41:00","inspection_id":"80393759","insp_violation_id":"263366002","seq_no":"2","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"204300672","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":7454032,"change_date":"2024-12-10 21:41:00","inspection_id":"80393759","insp_unit_id":"204300672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":4334962,"change_date":"2023-11-01 21:44:00","inspection_id":"80063885","dot_number":"2047670","report_state":"TX","report_number":"6PLH9DGTB8","insp_date":"2023-10-24 00:00:00","insp_start_time":"1730","insp_end_time":"1803","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10100  BEAUMONT HWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CLEANUP CREW","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":"Y","pen_cen_match":null,"final_status_date":"2023-11-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9114750","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-11-01 21:44:00","snet_input_date":"2023-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-01 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[{"id":6705038,"change_date":"2023-11-01 21:44:00","inspection_id":"80063885","insp_violation_id":"256170571","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197863118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6705039,"change_date":"2023-11-01 21:44:00","inspection_id":"80063885","insp_violation_id":"256170572","seq_no":"2","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197863118","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":6971690,"change_date":"2023-11-01 21:44:00","inspection_id":"80063885","insp_unit_id":"197863118","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"}]},{"id":4220174,"change_date":"2023-10-17 21:42:00","inspection_id":"79936873","dot_number":"2047670","report_state":"TX","report_number":"6P8D9DGTA2","insp_date":"2023-10-11 00:00:00","insp_start_time":"1331","insp_end_time":"1356","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  GAZIN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TRASH DADDY","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":"Y","pen_cen_match":null,"final_status_date":"2023-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9102772","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-10-17 21:42:00","snet_input_date":"2023-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-17 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:46:34.000000Z","updated_at":"2025-03-17T19:46:34.000000Z","inspection_violations":[{"id":6534369,"change_date":"2023-10-17 21:42:00","inspection_id":"79936873","insp_violation_id":"255893958","seq_no":"1","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"197607201","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":6786963,"change_date":"2023-10-17 21:42:00","inspection_id":"79936873","insp_unit_id":"197607201","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:53.000000Z","updated_at":"2025-03-17T22:56:53.000000Z"}]},{"id":4335211,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","dot_number":"2047670","report_state":"TX","report_number":"6ONH9DCDEP","insp_date":"2023-09-20 00:00:00","insp_start_time":"1721","insp_end_time":"1740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9114666","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-11-01 21:44:00","snet_input_date":"2023-09-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-01 21:44:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:48:46.000000Z","updated_at":"2025-03-17T19:48:46.000000Z","inspection_violations":[{"id":6705780,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","insp_violation_id":"256171853","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197863652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6705781,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","insp_violation_id":"256171854","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197863652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"},{"id":6705782,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","insp_violation_id":"256171855","seq_no":"3","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"197863652","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"39375A4"},{"id":6705783,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","insp_violation_id":"256171856","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197863652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6972086,"change_date":"2023-11-01 21:44:00","inspection_id":"80064157","insp_unit_id":"197863652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:32.000000Z","updated_at":"2025-03-17T22:58:32.000000Z"}]},{"id":3994562,"change_date":"2023-09-18 21:38:00","inspection_id":"79686835","dot_number":"2047670","report_state":"TX","report_number":"6OFH9DGXJ2","insp_date":"2023-09-12 00:00:00","insp_start_time":"1721","insp_end_time":"1735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4200  RED BLUFF N\/B","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEADIT - 10700 RED BLUFF","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":"Y","pen_cen_match":null,"final_status_date":"2023-09-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9077014","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-09-18 21:38:00","snet_input_date":"2023-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-18 21:38:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6423447,"change_date":"2023-09-18 21:38:00","inspection_id":"79686835","insp_unit_id":"197104862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:55.000000Z","updated_at":"2025-03-17T22:53:55.000000Z"}]},{"id":3985656,"change_date":"2023-09-15 21:40:00","inspection_id":"79676876","dot_number":"2047670","report_state":"TX","report_number":"6O8E9DJNPF","insp_date":"2023-09-05 00:00:00","insp_start_time":"1353","insp_end_time":"1422","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9400 W MONTGOMERY RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9075823","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[{"id":6164617,"change_date":"2023-09-15 21:40:00","inspection_id":"79676876","insp_violation_id":"255302594","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"197084465","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"393134"},{"id":6164618,"change_date":"2023-09-15 21:40:00","inspection_id":"79676876","insp_violation_id":"255302595","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"197084465","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"39355D1"},{"id":6164619,"change_date":"2023-09-15 21:40:00","inspection_id":"79676876","insp_violation_id":"255302596","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197084465","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6408771,"change_date":"2023-09-15 21:40:00","inspection_id":"79676876","insp_unit_id":"197084465","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3891087,"change_date":"2023-09-01 21:40:00","inspection_id":"79571785","dot_number":"2047670","report_state":"TX","report_number":"6NX89DJX67","insp_date":"2023-08-25 00:00:00","insp_start_time":"0837","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  FM 1960","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9065899","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-09-01 21:40:00","snet_input_date":"2023-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-01 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:39:44.000000Z","updated_at":"2025-03-17T19:39:44.000000Z","inspection_violations":[{"id":6014113,"change_date":"2023-09-01 21:40:00","inspection_id":"79571785","insp_violation_id":"255053529","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196871507","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39617C"},{"id":6014114,"change_date":"2023-09-01 21:40:00","inspection_id":"79571785","insp_violation_id":"255053530","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196871507","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:06.000000Z","updated_at":"2025-03-17T21:35:06.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":6256012,"change_date":"2023-09-01 21:40:00","inspection_id":"79571785","insp_unit_id":"196871507","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:34.000000Z","updated_at":"2025-03-17T22:52:34.000000Z"}]},{"id":3780371,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","dot_number":"2047670","report_state":"TX","report_number":"6NO79DJVIY","insp_date":"2023-08-16 00:00:00","insp_start_time":"0734","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9055499","transaction_code":"A","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[{"id":5832616,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","insp_violation_id":"254751478","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196616601","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3939A"},{"id":5832617,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","insp_violation_id":"254751479","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196616601","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3939A"},{"id":5832618,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","insp_violation_id":"254751480","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196616601","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39311"},{"id":5832619,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","insp_violation_id":"254751481","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196616601","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6078420,"change_date":"2023-08-18 21:42:00","inspection_id":"79448004","insp_unit_id":"196616601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"}]},{"id":3602243,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","dot_number":"2047670","report_state":"TX","report_number":"6MYG9DCE32","insp_date":"2023-07-21 00:00:00","insp_start_time":"1622","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9037131","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-07-26 21:41:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-26 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:34:11.000000Z","updated_at":"2025-03-17T19:34:11.000000Z","inspection_violations":[{"id":5554144,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298193","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"393205C"},{"id":5554145,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298194","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39311"},{"id":5554146,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298195","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"3939A"},{"id":5554147,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298196","seq_no":"4","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39375A4"},{"id":5554148,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298197","seq_no":"5","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39375A4"},{"id":5554149,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_violation_id":"254298198","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196212330","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:44.000000Z","updated_at":"2025-03-17T21:32:44.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5792159,"change_date":"2023-07-26 21:41:00","inspection_id":"79248861","insp_unit_id":"196212330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:44.000000Z","updated_at":"2025-03-17T22:48:44.000000Z"}]},{"id":2888152,"change_date":"2023-04-26 21:42:00","inspection_id":"78444209","dot_number":"2047670","report_state":"TX","report_number":"6KBB9DBAU2","insp_date":"2023-04-17 00:00:00","insp_start_time":"1105","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3900  EAST RICHEY RO","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE SYSTEMS LLC","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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8962322","transaction_code":"C","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4431951,"change_date":"2023-04-26 21:42:00","inspection_id":"78444209","insp_violation_id":"252465819","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194608642","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39378"},{"id":4431952,"change_date":"2023-04-26 21:42:00","inspection_id":"78444209","insp_violation_id":"252465820","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194608642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4647077,"change_date":"2023-04-26 21:42:00","inspection_id":"78444209","insp_unit_id":"194608642","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2730457,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","dot_number":"2047670","report_state":"TX","report_number":"6JSA9DCCRB","insp_date":"2023-03-29 00:00:00","insp_start_time":"0937","insp_end_time":"1016","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1264 N FRY RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8945722","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-04-04 21:42:00","snet_input_date":"2023-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:16:59.000000Z","updated_at":"2025-03-17T19:16:59.000000Z","inspection_violations":[{"id":4194982,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_violation_id":"252044654","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194222162","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"39375C"},{"id":4194983,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_violation_id":"252044655","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"194222162","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"393205C"},{"id":4194984,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_violation_id":"252044656","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"194222162","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:37.000000Z","updated_at":"2025-03-17T21:26:37.000000Z","normalized_code":"39330"},{"id":4194985,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_violation_id":"252044657","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194222162","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:37.000000Z","updated_at":"2025-03-17T21:26:37.000000Z","normalized_code":"39378"},{"id":4194986,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_violation_id":"252044658","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194222162","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:37.000000Z","updated_at":"2025-03-17T21:26:37.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4395440,"change_date":"2023-04-04 21:42:00","inspection_id":"78265831","insp_unit_id":"194222162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"}]},{"id":2627593,"change_date":"2023-03-21 21:42:00","inspection_id":"78147967","dot_number":"2047670","report_state":"TX","report_number":"6JH69DBVK7","insp_date":"2023-03-18 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN MONTGOMERY CO. (152","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYOU CITY WASTE","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":"Y","pen_cen_match":null,"final_status_date":"2023-03-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8934303","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-03-21 21:42:00","snet_input_date":"2023-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-21 21:42:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:15:10.000000Z","updated_at":"2025-03-17T19:15:10.000000Z","inspection_violations":[{"id":4039865,"change_date":"2023-03-21 21:42:00","inspection_id":"78147967","insp_violation_id":"251788589","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193988640","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39617C"},{"id":4039866,"change_date":"2023-03-21 21:42:00","inspection_id":"78147967","insp_violation_id":"251788590","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193988640","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:54.000000Z","updated_at":"2025-03-17T21:25:54.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":4230044,"change_date":"2023-03-21 21:42:00","inspection_id":"78147967","insp_unit_id":"193988640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"NTB1371","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X7KJ245555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:21.000000Z","updated_at":"2025-03-17T22:36:21.000000Z"}]},{"id":2637396,"change_date":"2023-03-22 21:43:00","inspection_id":"78158946","dot_number":"2047670","report_state":"TX","report_number":"6JCG9DCCPQ","insp_date":"2023-03-13 00:00:00","insp_start_time":"1644","insp_end_time":"1712","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1743  SEAMIST DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"8934808","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-03-22 21:43:00","snet_input_date":"2023-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-22 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:15:13.000000Z","updated_at":"2025-03-17T19:15:13.000000Z","inspection_violations":[{"id":4053934,"change_date":"2023-03-22 21:43:00","inspection_id":"78158946","insp_violation_id":"251811564","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194010866","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4245894,"change_date":"2023-03-22 21:43:00","inspection_id":"78158946","insp_unit_id":"194010866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"LYL5140","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0KJ245557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:28.000000Z","updated_at":"2025-03-17T22:36:28.000000Z"}]},{"id":2360880,"change_date":"2023-02-13 21:43:00","inspection_id":"77844265","dot_number":"2047670","report_state":"TX","report_number":"6IGH9DCK93","insp_date":"2023-02-09 00:00:00","insp_start_time":"1752","insp_end_time":"1809","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"600  FRANKLIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8902319","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2023-02-13 21:43:00","snet_input_date":"2023-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T19:10:17.000000Z","updated_at":"2025-03-17T19:10:17.000000Z","inspection_violations":[{"id":3637155,"change_date":"2023-02-13 21:43:00","inspection_id":"77844265","insp_violation_id":"251110478","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"193376040","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3929"},{"id":3637156,"change_date":"2023-02-13 21:43:00","inspection_id":"77844265","insp_violation_id":"251110479","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193376040","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":3799867,"change_date":"2023-02-13 21:43:00","inspection_id":"77844265","insp_unit_id":"193376040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"NKG5582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3BKDL40X2LF385487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:12.000000Z","updated_at":"2025-03-17T22:33:12.000000Z"}]},{"id":1461281,"change_date":"2022-10-06 21:40:00","inspection_id":"76813879","dot_number":"2047670","report_state":"TX","report_number":"6ESC0XUP3Q","insp_date":"2022-09-30 00:00:00","insp_start_time":"1145","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"8792574","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T18:53:44.000000Z","updated_at":"2025-03-17T18:53:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2352554,"change_date":"2022-10-06 21:40:00","inspection_id":"76813879","insp_unit_id":"191317271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"NTB1369","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X0JJ197430","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:07.000000Z","updated_at":"2025-03-17T22:23:07.000000Z"}]},{"id":1267332,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","dot_number":"2047670","report_state":"TX","report_number":"6E4C9DAXFB","insp_date":"2022-09-06 00:00:00","insp_start_time":"1235","insp_end_time":"1315","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":"FIERRO GROUP","shipping_paper_number":"237192","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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":"2022-09-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"10","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8769523","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2022-09-12 21:43:00","snet_input_date":"2022-09-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T18:50:06.000000Z","updated_at":"2025-03-17T18:50:06.000000Z","inspection_violations":[{"id":2007120,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364714","seq_no":"1","part_no":"393","part_no_section":"26","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39326"},{"id":2007121,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364715","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3965B"},{"id":2007122,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364716","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3939A"},{"id":2007123,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364717","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3939A"},{"id":2007124,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364718","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39375C"},{"id":2007125,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364719","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39311"},{"id":2007126,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364720","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3939A"},{"id":2007127,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364721","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3922"},{"id":2007128,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364722","seq_no":"10","part_no":"393","part_no_section":"93(b)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39393B"},{"id":2007129,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_violation_id":"248364723","seq_no":"11","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"1","insp_unit_id":"190854871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39387A"}],"inspection_per_units":[{"id":2039561,"change_date":"2022-09-12 21:43:00","inspection_id":"76588438","insp_unit_id":"190854871","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:00.000000Z","updated_at":"2025-03-17T22:21:00.000000Z"}]},{"id":643379,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","dot_number":"2047670","report_state":"TX","report_number":"6BNB9DBGJF","insp_date":"2022-06-09 00:00:00","insp_start_time":"1045","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","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":"Y","pen_cen_match":null,"final_status_date":"2022-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8686094","transaction_code":"C","transaction_date":"2022-06-20 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02047670","upload_search_indicator":"M","census_search_date":"2022-06-17 21:41:00","snet_input_date":"2022-06-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-17 21:41:00","insp_carrier_name":"BAYOU CITY WASTE SYSTEMS LLC","insp_carrier_street":"10234 LUCORE ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0196976","created_at":"2025-03-17T18:39:08.000000Z","updated_at":"2025-03-17T18:39:08.000000Z","inspection_violations":[{"id":1013707,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_violation_id":"246592041","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189353038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"3939A"},{"id":1013708,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_violation_id":"246592042","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189353038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"3939A"},{"id":1013709,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_violation_id":"246592043","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189353038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"3939A"},{"id":1013710,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_violation_id":"246592044","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189353038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"3939A"},{"id":1013711,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_violation_id":"246592045","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189353038","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:44.000000Z","updated_at":"2025-03-17T21:11:44.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1034298,"change_date":"2022-06-20 21:36:00","inspection_id":"75859750","insp_unit_id":"189353038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"LYG5752","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKZLP0X5KJ245554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:33.000000Z","updated_at":"2025-03-17T22:14:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2047670\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2047670\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2047670\/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\/2047670\/inspections","per_page":100,"prev_page_url":null,"to":49,"total":49}