{"current_page":1,"data":[{"id":8344995,"change_date":"2025-04-10 21:42:00","inspection_id":"84366886","dot_number":"2994863","report_state":"TX","report_number":"73O99DLEQA","insp_date":"2025-03-14 00:00:00","insp_start_time":"0853","insp_end_time":"0916","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9545956","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-04-14T10:28:36.000000Z","updated_at":"2025-04-14T10:28:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13538233,"change_date":"2025-04-10 21:42:00","inspection_id":"84366886","insp_unit_id":"206252357","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:19:55.000000Z","updated_at":"2025-04-14T10:05:51.000000Z"}]},{"id":8344884,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","dot_number":"2994863","report_state":"TX","report_number":"73M79DLEQ5","insp_date":"2025-03-12 00:00:00","insp_start_time":"0715","insp_end_time":"0752","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9545948","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-03-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-04-14T10:28:36.000000Z","updated_at":"2025-04-14T10:28:36.000000Z","inspection_violations":[{"id":13139700,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","insp_violation_id":"265551131","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"206252138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T11:00:15.000000Z","updated_at":"2025-04-13T10:53:18.000000Z","normalized_code":"39355D1"},{"id":13139701,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","insp_violation_id":"265551132","seq_no":"2","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"206252138","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T11:00:15.000000Z","updated_at":"2025-04-13T10:53:18.000000Z","normalized_code":"39395B"},{"id":13139702,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","insp_violation_id":"265551133","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206252138","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T11:00:15.000000Z","updated_at":"2025-04-13T10:53:18.000000Z","normalized_code":"39378"},{"id":13139703,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","insp_violation_id":"265551134","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206252138","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T11:00:15.000000Z","updated_at":"2025-04-13T10:53:18.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13538045,"change_date":"2025-04-10 21:42:00","inspection_id":"84366770","insp_unit_id":"206252138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:19:55.000000Z","updated_at":"2025-04-14T10:05:48.000000Z"}]},{"id":7785645,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","dot_number":"2994863","report_state":"TX","report_number":"V251600599","insp_date":"2025-01-30 00:00:00","insp_start_time":"1438","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SANTA FE PKWY","county_code_state":"TX","county_code":"291","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-02-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"7","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9489797","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2025-02-04 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:59:54.000000Z","updated_at":"2025-03-17T20:59:54.000000Z","inspection_violations":[{"id":12166440,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337620","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"38323A2"},{"id":12166441,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337621","seq_no":"2","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3928"},{"id":12166442,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337622","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205156453","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"39360C"},{"id":12166443,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337623","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205156453","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"39395A"},{"id":12166444,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337624","seq_no":"5","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"205156453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3963A1B"},{"id":12166445,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337625","seq_no":"6","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"205156453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3963A1B"},{"id":12166446,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_violation_id":"264337626","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"205156453","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12564801,"change_date":"2025-02-04 21:40:00","inspection_id":"83778905","insp_unit_id":"205156453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"TBV0582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:45.000000Z","updated_at":"2025-03-17T23:53:45.000000Z"}]},{"id":7630564,"change_date":"2025-01-17 21:40:00","inspection_id":"83615837","dot_number":"2994863","report_state":"TX","report_number":"72179DLENW","insp_date":"2025-01-14 00:00:00","insp_start_time":"0725","insp_end_time":"0807","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"9474907","transaction_code":"C","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:56:32.000000Z","updated_at":"2025-03-17T20:56:32.000000Z","inspection_violations":[{"id":11925315,"change_date":"2025-01-17 21:40:00","inspection_id":"83615837","insp_violation_id":"264066417","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"204901264","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"39375A3"},{"id":11925316,"change_date":"2025-01-17 21:40:00","inspection_id":"83615837","insp_violation_id":"264066418","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204901264","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":12312469,"change_date":"2025-01-17 21:40:00","inspection_id":"83615837","insp_unit_id":"204901264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"10","insp_unit_license":"SSB8858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y71W135648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":7566715,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","dot_number":"2994863","report_state":"TX","report_number":"71PE9DCOHN","insp_date":"2025-01-02 00:00:00","insp_start_time":"1442","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9467334","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[{"id":11828406,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818874","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"38323A2"},{"id":11828407,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818875","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39141A"},{"id":11828408,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818876","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39395A"},{"id":11828409,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818877","seq_no":"4","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3929"},{"id":11828410,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818878","seq_no":"5","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39355D1"},{"id":11828411,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818879","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939TS"},{"id":11828412,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818880","seq_no":"7","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939TS"},{"id":11828413,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818881","seq_no":"8","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939H"},{"id":11828414,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818882","seq_no":"9","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39330"},{"id":11828415,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_violation_id":"263818883","seq_no":"10","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"1","insp_unit_id":"204708588","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939BRKLAMP"}],"inspection_per_units":[{"id":12208750,"change_date":"2025-01-08 21:39:00","inspection_id":"83548860","insp_unit_id":"204708588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"09","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7440475,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","dot_number":"2994863","report_state":"TX","report_number":"70VE9DGTZI","insp_date":"2024-12-03 00:00:00","insp_start_time":"1444","insp_end_time":"1529","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8300  MYKAWA 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":"2024-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9451662","transaction_code":"C","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-12-17 21:39:00","snet_input_date":"2024-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-17 21:39:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:51:30.000000Z","updated_at":"2025-03-17T20:51:30.000000Z","inspection_violations":[{"id":11626054,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_violation_id":"263547773","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204457845","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39347E"},{"id":11626055,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_violation_id":"263547774","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204457845","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39347E"},{"id":11626056,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_violation_id":"263547775","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204457845","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39353B"},{"id":11626057,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_violation_id":"263547776","seq_no":"4","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204457845","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"3963A1B"},{"id":11626058,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_violation_id":"263547777","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204457845","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":12003332,"change_date":"2024-12-18 21:41:00","inspection_id":"83416270","insp_unit_id":"204457845","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:31.000000Z","updated_at":"2025-03-17T23:47:31.000000Z"}]},{"id":7320895,"change_date":"2024-12-02 21:40:00","inspection_id":"83290544","dot_number":"2994863","report_state":"TX","report_number":"70KG9DHZ07","insp_date":"2024-11-22 00:00:00","insp_start_time":"1610","insp_end_time":"1628","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700  GELLHORN","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":"2024-12-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9439454","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-12-02 21:40:00","snet_input_date":"2024-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-02 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:48:56.000000Z","updated_at":"2025-03-17T20:48:56.000000Z","inspection_violations":[{"id":11444073,"change_date":"2024-12-02 21:40:00","inspection_id":"83290544","insp_violation_id":"263177101","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":11809762,"change_date":"2024-12-02 21:40:00","inspection_id":"83290544","insp_unit_id":"204137745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"VCP3855","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08XXYW018887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:23.000000Z","updated_at":"2025-03-17T23:45:23.000000Z"}]},{"id":7231606,"change_date":"2026-03-26 21:40:00","inspection_id":"83196300","dot_number":"2994863","report_state":"TX","report_number":"V241684393","insp_date":"2024-11-07 00:00:00","insp_start_time":"1106","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"S POST OAK BLVD AT T","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEJANO SAND & CLAY","shipping_paper_number":"110344","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-11-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9431994","transaction_code":"C","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-11-19 21:41:00","snet_input_date":"2024-11-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-19 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:46:50.000000Z","updated_at":"2026-04-06T09:32:06.000000Z","inspection_violations":[{"id":19393108,"change_date":"2026-03-26 21:40:00","inspection_id":"83196300","insp_violation_id":"272670402","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"212363306","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:18.000000Z","updated_at":"2026-04-06T09:56:00.000000Z","normalized_code":"393209E"},{"id":19393109,"change_date":"2026-03-26 21:40:00","inspection_id":"83196300","insp_violation_id":"272670403","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212363306","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:18.000000Z","updated_at":"2026-04-06T09:56:00.000000Z","normalized_code":"3939"},{"id":19393110,"change_date":"2026-03-26 21:40:00","inspection_id":"83196300","insp_violation_id":"272670404","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212363306","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:18.000000Z","updated_at":"2026-04-06T09:56:00.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19675583,"change_date":"2026-03-26 21:40:00","inspection_id":"83196300","insp_unit_id":"212363306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"12","insp_unit_license":"VCP3855","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08XXYW018887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:50:58.000000Z","updated_at":"2026-04-06T09:12:00.000000Z"}]},{"id":7026574,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","dot_number":"2994863","report_state":"TX","report_number":"V241584319","insp_date":"2024-10-14 00:00:00","insp_start_time":"0825","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1128 S AT CR98","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG J'S TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-23 21:42: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":"9410028","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10966522,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_violation_id":"262516663","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"203550095","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"393209E"},{"id":10966523,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_violation_id":"262516664","seq_no":"2","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"203550095","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39328"},{"id":10966524,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_violation_id":"262516665","seq_no":"3","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"203550095","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39348A"},{"id":10966525,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_violation_id":"262516666","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203550095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"},{"id":10966526,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_violation_id":"262516667","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203550095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11332483,"change_date":"2024-10-23 21:42:00","inspection_id":"82979126","insp_unit_id":"203550095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"14","insp_unit_license":"VCN7166","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y23W012624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6797751,"change_date":"2024-09-23 21:41:00","inspection_id":"82736059","dot_number":"2994863","report_state":"TX","report_number":"V241493369","insp_date":"2024-09-19 00:00:00","insp_start_time":"1313","insp_end_time":"1333","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1833  CR59","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEJANO SAND AND CLAY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9384862","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:37:47.000000Z","updated_at":"2025-03-17T20:37:47.000000Z","inspection_violations":[{"id":10585513,"change_date":"2024-09-23 21:41:00","inspection_id":"82736059","insp_violation_id":"261985766","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10962138,"change_date":"2024-09-23 21:41:00","inspection_id":"82736059","insp_unit_id":"203086571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:33.000000Z","updated_at":"2025-03-17T23:36:33.000000Z"}]},{"id":6819381,"change_date":"2024-09-25 21:41:00","inspection_id":"82758956","dot_number":"2994863","report_state":"TX","report_number":"6YS69DBQ7F","insp_date":"2024-09-19 00:00:00","insp_start_time":"0650","insp_end_time":"0715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10800  BROADWAY ST","county_code_state":"TX","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"APCOM","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9386012","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10997002,"change_date":"2024-09-25 21:41:00","inspection_id":"82758956","insp_unit_id":"203130286","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"09","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6819910,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","dot_number":"2994863","report_state":"TX","report_number":"V241478187","insp_date":"2024-09-19 00:00:00","insp_start_time":"1130","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR 5200 NEAR 5740","county_code_state":"TX","county_code":"291","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PIT","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-09-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9386471","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-09-25 21:42:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10620974,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035568","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39347E"},{"id":10620975,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035569","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39348A"},{"id":10620976,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035570","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39348A"},{"id":10620977,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035571","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39348A"},{"id":10620978,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035572","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39348A"},{"id":10620979,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035573","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3963A1"},{"id":10620980,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_violation_id":"262035574","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203131424","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10997857,"change_date":"2024-09-25 21:42:00","inspection_id":"82759518","insp_unit_id":"203131424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"TBV0582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6770972,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","dot_number":"2994863","report_state":"TX","report_number":"6YI79DCGFD","insp_date":"2024-09-09 00:00:00","insp_start_time":"0710","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","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":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9381033","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[{"id":10544465,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","insp_violation_id":"261927101","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"203033101","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39395F"},{"id":10544466,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","insp_violation_id":"261927102","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203033101","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"39617C"},{"id":10544467,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","insp_violation_id":"261927103","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203033101","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3939A"},{"id":10544468,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","insp_violation_id":"261927104","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203033101","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:04.000000Z","updated_at":"2025-03-17T21:57:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10918612,"change_date":"2024-09-19 21:42:00","inspection_id":"82707177","insp_unit_id":"203033101","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"VCP3855","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA08XXYW018887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:06.000000Z","updated_at":"2025-03-17T23:36:06.000000Z"}]},{"id":5492260,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","dot_number":"2994863","report_state":"TX","report_number":"6U6E9DKY3U","insp_date":"2024-04-06 00:00:00","insp_start_time":"1456","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0519 IN GALVESTON CO. (704-","county_code_state":"TX","county_code":"167","insp_level_id":"1","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-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9245742","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:11:33.000000Z","updated_at":"2025-03-17T20:11:33.000000Z","inspection_violations":[{"id":8482941,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","insp_violation_id":"258887138","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200359004","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3922"},{"id":8482942,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","insp_violation_id":"258887139","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200359004","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3922"},{"id":8482943,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","insp_violation_id":"258887140","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200359004","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39355D1"},{"id":8482944,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","insp_violation_id":"258887141","seq_no":"5","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"200359004","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":8847114,"change_date":"2024-04-11 21:41:00","inspection_id":"81330744","insp_unit_id":"200359004","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"06","insp_unit_license":"VCN7166","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y23W012624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5190690,"change_date":"2024-03-01 21:40:00","inspection_id":"81001206","dot_number":"2994863","report_state":"TX","report_number":"6T4B9DJZGP","insp_date":"2024-02-28 00:00:00","insp_start_time":"1134","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0336 IN MONTGOMERY CO. (674","county_code_state":"TX","county_code":"339","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG J'S TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9212313","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"8338 OAKHAVEN RD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T20:05:22.000000Z","updated_at":"2025-03-17T20:05:22.000000Z","inspection_violations":[{"id":7999864,"change_date":"2024-03-01 21:40:00","inspection_id":"81001206","insp_violation_id":"258157732","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199713728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3939A"},{"id":7999865,"change_date":"2024-03-01 21:40:00","inspection_id":"81001206","insp_violation_id":"258157733","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"199713728","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"393209E"},{"id":7999866,"change_date":"2024-03-01 21:40:00","inspection_id":"81001206","insp_violation_id":"258157734","seq_no":"3","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"1","insp_unit_id":"199713728","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39375A4"}],"inspection_per_units":[{"id":8357814,"change_date":"2024-03-01 21:40:00","inspection_id":"81001206","insp_unit_id":"199713728","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":4325330,"change_date":"2023-10-31 21:40:00","inspection_id":"80053277","dot_number":"2994863","report_state":"TX","report_number":"6PKF9DBZTQ","insp_date":"2023-10-23 00:00:00","insp_start_time":"1518","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  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-10-31 21:40: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":"9113785","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:48:42.000000Z","updated_at":"2025-03-17T19:48:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6956242,"change_date":"2023-10-31 21:40:00","inspection_id":"80053277","insp_unit_id":"197840678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SSB8858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y71W135648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:24.000000Z","updated_at":"2025-03-17T22:58:24.000000Z"}]},{"id":4274701,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","dot_number":"2994863","report_state":"TX","report_number":"6PEF9DIADE","insp_date":"2023-10-17 00:00:00","insp_start_time":"1504","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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":"2023-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9108362","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[{"id":6612055,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019960","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"393207A"},{"id":6612056,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019961","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39395A"},{"id":6612057,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019962","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3939A"},{"id":6612058,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019963","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3965B"},{"id":6612059,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019964","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39347E"},{"id":6612060,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019965","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39353B"},{"id":6612061,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_violation_id":"256019966","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197726170","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6875067,"change_date":"2023-10-24 21:40:00","inspection_id":"79997294","insp_unit_id":"197726170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"10","insp_unit_license":"SSB8858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y71W135648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":3623747,"change_date":"2023-07-28 21:42:00","inspection_id":"79272977","dot_number":"2994863","report_state":"TX","report_number":"6MX99DCADZ","insp_date":"2023-07-20 00:00:00","insp_start_time":"0955","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  S.SAM HOUSTON","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9039368","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[{"id":5588015,"change_date":"2023-07-28 21:42:00","inspection_id":"79272977","insp_violation_id":"254353101","seq_no":"1","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"196260194","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":5826364,"change_date":"2023-07-28 21:42:00","inspection_id":"79272977","insp_unit_id":"196260194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"TBV0582","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3422777,"change_date":"2023-07-03 21:38:00","inspection_id":"79047297","dot_number":"2994863","report_state":"TX","report_number":"6MBE9DBQ1E","insp_date":"2023-06-28 00:00:00","insp_start_time":"1415","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4000  MANVEL RD","county_code_state":"TX","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEJANO TRUCKING","shipping_paper_number":"96404","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9018991","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-06-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:30:54.000000Z","updated_at":"2025-03-17T19:30:54.000000Z","inspection_violations":[{"id":5277110,"change_date":"2023-07-03 21:38:00","inspection_id":"79047297","insp_violation_id":"253843011","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195803734","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5502935,"change_date":"2023-07-03 21:38:00","inspection_id":"79047297","insp_unit_id":"195803734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"}]},{"id":3346382,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","dot_number":"2994863","report_state":"TX","report_number":"6M399DCGT0","insp_date":"2023-06-20 00:00:00","insp_start_time":"0930","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14400 S WAYSIDE","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-06-22 21:42: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":"9011487","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[{"id":5161266,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","insp_violation_id":"253656648","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195634248","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"39360D"},{"id":5161267,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","insp_violation_id":"253656649","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195634248","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3939A"},{"id":5161268,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","insp_violation_id":"253656650","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195634248","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3939A"},{"id":5161269,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","insp_violation_id":"253656651","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195634248","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5379856,"change_date":"2023-06-22 21:42:00","inspection_id":"78961559","insp_unit_id":"195634248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PCN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:25.000000Z","updated_at":"2025-03-17T22:45:25.000000Z"}]},{"id":2568928,"change_date":"2023-03-13 21:43:00","inspection_id":"78081492","dot_number":"2994863","report_state":"TX","report_number":"6J7A0ZGMIO","insp_date":"2023-03-08 00:00:00","insp_start_time":"1014","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0035 IN BRAZORIA CO. (482-5","county_code_state":"TX","county_code":"039","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":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8928754","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3951927,"change_date":"2023-03-13 21:43:00","inspection_id":"78081492","insp_violation_id":"251638292","seq_no":"1","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"193850131","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39347D"},{"id":3951928,"change_date":"2023-03-13 21:43:00","inspection_id":"78081492","insp_violation_id":"251638293","seq_no":"2","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"193850131","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39347D"},{"id":3951929,"change_date":"2023-03-13 21:43:00","inspection_id":"78081492","insp_violation_id":"251638294","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193850131","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":4134748,"change_date":"2023-03-13 21:43:00","inspection_id":"78081492","insp_unit_id":"193850131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:38.000000Z","updated_at":"2025-03-17T22:35:38.000000Z"}]},{"id":2460986,"change_date":"2023-02-27 21:42:00","inspection_id":"77958492","dot_number":"2994863","report_state":"TX","report_number":"6IT90XJDB6","insp_date":"2023-02-22 00:00:00","insp_start_time":"0852","insp_end_time":"0908","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0528 IN BRAZORIA CO. (688-6","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8914710","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:12:05.000000Z","updated_at":"2025-03-17T19:12:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3960829,"change_date":"2023-02-27 21:42:00","inspection_id":"77958492","insp_unit_id":"193605019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"14P001M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2461638,"change_date":"2023-02-27 21:42:00","inspection_id":"77959199","dot_number":"2994863","report_state":"TX","report_number":"6IT80XSKFE","insp_date":"2023-02-22 00:00:00","insp_start_time":"0814","insp_end_time":"0839","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0035 IN BRAZORIA CO. (482-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 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":"8914676","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3790281,"change_date":"2023-02-27 21:42:00","inspection_id":"77959199","insp_violation_id":"251367044","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193606433","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3961942,"change_date":"2023-02-27 21:42:00","inspection_id":"77959199","insp_unit_id":"193606433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"09","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2461937,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","dot_number":"2994863","report_state":"TX","report_number":"6IR80ZGMH4","insp_date":"2023-02-20 00:00:00","insp_start_time":"0810","insp_end_time":"0858","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0518 IN BRAZORIA CO. (680-6","county_code_state":"TX","county_code":"039","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":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8914147","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3791113,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","insp_violation_id":"251368248","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"193607116","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3929A2"},{"id":3791114,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","insp_violation_id":"251368249","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193607116","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3963A1"},{"id":3791115,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","insp_violation_id":"251368250","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193607116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3939A"},{"id":3791116,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","insp_violation_id":"251368251","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193607116","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":3962451,"change_date":"2023-02-27 21:42:00","inspection_id":"77959538","insp_unit_id":"193607116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"09","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2470824,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","dot_number":"2994863","report_state":"TX","report_number":"6IR89DAWV4","insp_date":"2023-02-20 00:00:00","insp_start_time":"0852","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  WHITAKER DR","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8916300","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-02-28 21:41:00","snet_input_date":"2023-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:12:08.000000Z","updated_at":"2025-03-17T19:12:08.000000Z","inspection_violations":[{"id":3803830,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393694","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39395A"},{"id":3803831,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393695","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39375C"},{"id":3803832,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393696","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39375C"},{"id":3803833,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393697","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"3939A"},{"id":3803834,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393698","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39375A3"},{"id":3803835,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_violation_id":"251393699","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193628816","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3976754,"change_date":"2023-02-28 21:41:00","inspection_id":"77969521","insp_unit_id":"193628816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"14P001M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:29.000000Z","updated_at":"2025-03-17T22:34:29.000000Z"}]},{"id":2381812,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","dot_number":"2994863","report_state":"TX","report_number":"6IL79DCQC8","insp_date":"2023-02-14 00:00:00","insp_start_time":"0750","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  MYKAWA","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DIRT YARD","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8906278","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2023-02-15 21:39:00","snet_input_date":"2023-02-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-15 21:39:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T19:10:41.000000Z","updated_at":"2025-03-17T19:10:41.000000Z","inspection_violations":[{"id":3668266,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162978","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39347E"},{"id":3668267,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162979","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39347E"},{"id":3668268,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162980","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39353B"},{"id":3668269,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162981","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"3922"},{"id":3668270,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162982","seq_no":"5","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39360D"},{"id":3668271,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_violation_id":"251162983","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193422933","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":3832925,"change_date":"2023-02-15 21:39:00","inspection_id":"77868345","insp_unit_id":"193422933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:27.000000Z","updated_at":"2025-03-17T22:33:27.000000Z"}]},{"id":1745875,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","dot_number":"2994863","report_state":"TX","report_number":"6FXC9DCK5D","insp_date":"2022-11-10 00:00:00","insp_start_time":"1256","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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":"2022-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8827792","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:58:55.000000Z","updated_at":"2025-03-17T18:58:55.000000Z","inspection_violations":[{"id":2734195,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615371","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347E"},{"id":2734196,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615372","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347E"},{"id":2734197,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615373","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347E"},{"id":2734198,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615374","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347E"},{"id":2734199,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615375","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347E"},{"id":2734200,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615376","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39353B"},{"id":2734201,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615377","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39345B2"},{"id":2734202,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615378","seq_no":"8","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39395A"},{"id":2734203,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615379","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3922"},{"id":2734204,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615380","seq_no":"11","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39375A1"},{"id":2734205,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_violation_id":"249615381","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191970016","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2809437,"change_date":"2022-11-15 21:40:00","inspection_id":"77141060","insp_unit_id":"191970016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"648317G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:13.000000Z","updated_at":"2025-03-17T22:26:13.000000Z"}]},{"id":1439426,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","dot_number":"2994863","report_state":"TX","report_number":"6EJF9DGTCV","insp_date":"2022-09-21 00:00:00","insp_start_time":"1509","insp_end_time":"1558","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8300  MYKAWA 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":"2022-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"8788209","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-09-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:53:07.000000Z","updated_at":"2025-03-17T18:53:07.000000Z","inspection_violations":[{"id":2266180,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","insp_violation_id":"248827143","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191265986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"3939A"},{"id":2266181,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","insp_violation_id":"248827144","seq_no":"3","part_no":"393","part_no_section":"50(b)","insp_viol_unit":"1","insp_unit_id":"191265986","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39350B"},{"id":2266182,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","insp_violation_id":"248827145","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191265986","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"3965B"},{"id":2266183,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","insp_violation_id":"248827146","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191265986","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2317293,"change_date":"2022-10-04 21:41:00","inspection_id":"76788287","insp_unit_id":"191265986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"520688G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"}]},{"id":1369517,"change_date":"2022-09-26 21:40:00","inspection_id":"76707325","dot_number":"2994863","report_state":"TX","report_number":"6EB79DCQ6Y","insp_date":"2022-09-13 00:00:00","insp_start_time":"0735","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14400  S WAYSIDE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-26 21:40: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":"8780877","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-09-26 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:51:58.000000Z","updated_at":"2025-03-17T18:51:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2205444,"change_date":"2022-09-26 21:40:00","inspection_id":"76707325","insp_unit_id":"191103648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"502417G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"}]},{"id":1222764,"change_date":"2022-09-09 21:39:00","inspection_id":"76536956","dot_number":"2994863","report_state":"TX","report_number":"6DZD9DAWPU","insp_date":"2022-09-01 00:00:00","insp_start_time":"1338","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1400  MOORE RD","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8763589","transaction_code":"C","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-09-06 21:43:00","snet_input_date":"2022-09-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-06 21:43:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:49:18.000000Z","updated_at":"2025-03-17T18:49:18.000000Z","inspection_violations":[{"id":1938112,"change_date":"2022-09-09 21:39:00","inspection_id":"76536956","insp_violation_id":"248321114","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190819020","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:55.000000Z","updated_at":"2025-03-17T21:15:55.000000Z","normalized_code":"39360D"},{"id":1938113,"change_date":"2022-09-09 21:39:00","inspection_id":"76536956","insp_violation_id":"248321115","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190819020","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:55.000000Z","updated_at":"2025-03-17T21:15:55.000000Z","normalized_code":"39345D"},{"id":1938114,"change_date":"2022-09-09 21:39:00","inspection_id":"76536956","insp_violation_id":"248321116","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190819020","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:55.000000Z","updated_at":"2025-03-17T21:15:55.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1967779,"change_date":"2022-09-09 21:39:00","inspection_id":"76536956","insp_unit_id":"190819020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:31.000000Z","updated_at":"2025-03-17T22:20:31.000000Z"}]},{"id":1200525,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","dot_number":"2994863","report_state":"TX","report_number":"6DYA9DCO4P","insp_date":"2022-08-31 00:00:00","insp_start_time":"1013","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  S SHAVER 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":"2022-09-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8761517","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-09-01 21:42:00","snet_input_date":"2022-08-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-01 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:48:56.000000Z","updated_at":"2025-03-17T18:48:56.000000Z","inspection_violations":[{"id":1905375,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185878","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"38323A2"},{"id":1905376,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185879","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39141A"},{"id":1905377,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185880","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190697163","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39378"},{"id":1905378,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185881","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190697163","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39375C"},{"id":1905379,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185882","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"190697163","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"39383G"},{"id":1905380,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_violation_id":"248185883","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190697163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:49.000000Z","updated_at":"2025-03-17T21:15:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1930770,"change_date":"2022-09-01 21:42:00","inspection_id":"76511212","insp_unit_id":"190697163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"460162G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y71W135648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:17.000000Z","updated_at":"2025-03-17T22:20:17.000000Z"}]},{"id":1207828,"change_date":"2022-09-02 21:39:00","inspection_id":"76519709","dot_number":"2994863","report_state":"TX","report_number":"6DQB9DBQ8J","insp_date":"2022-08-23 00:00:00","insp_start_time":"1058","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7100  BAILEY RD","county_code_state":"TX","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRAZORIA DRNG DST 4","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":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"8761723","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1942567,"change_date":"2022-09-02 21:39:00","inspection_id":"76519709","insp_unit_id":"190713962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"444143G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":925295,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","dot_number":"2994863","report_state":"TX","report_number":"6CV69DJV8S","insp_date":"2022-07-23 00:00:00","insp_start_time":"0617","insp_end_time":"0654","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED 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":"2022-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8727636","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-07-29 21:39:00","snet_input_date":"2022-07-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-29 21:39:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:44:02.000000Z","updated_at":"2025-03-17T18:44:02.000000Z","inspection_violations":[{"id":1460181,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408887","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"38323A2"},{"id":1460182,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408888","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39311"},{"id":1460183,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408889","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39021A"},{"id":1460184,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408890","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"},{"id":1460185,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408891","seq_no":"5","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39355C2"},{"id":1460186,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408892","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39395F"},{"id":1460187,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_violation_id":"247408893","seq_no":"7","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"190044650","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":1489909,"change_date":"2022-07-29 21:39:00","inspection_id":"76190418","insp_unit_id":"190044650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"RSK7806","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y23W012624","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:21.000000Z","updated_at":"2025-03-17T22:17:21.000000Z"}]},{"id":780280,"change_date":"2022-07-08 21:41:00","inspection_id":"76020592","dot_number":"2994863","report_state":"TX","report_number":"6C170XVRDD","insp_date":"2022-06-23 00:00:00","insp_start_time":"0654","insp_end_time":"0719","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG JS TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8707998","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-06-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[{"id":1233216,"change_date":"2022-07-08 21:41:00","inspection_id":"76020592","insp_violation_id":"246982417","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"189679797","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39375C"},{"id":1233217,"change_date":"2022-07-08 21:41:00","inspection_id":"76020592","insp_violation_id":"246982418","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189679797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1255598,"change_date":"2022-07-08 21:41:00","inspection_id":"76020592","insp_unit_id":"189679797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:54.000000Z","updated_at":"2025-03-17T22:15:54.000000Z"}]},{"id":663823,"change_date":"2022-06-21 21:42:00","inspection_id":"75883974","dot_number":"2994863","report_state":"TX","report_number":"6BRD0AMWO1","insp_date":"2022-06-13 00:00:00","insp_start_time":"1307","insp_end_time":"1329","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1462 IN FORT BEND CO. (662-","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FRANCO BUILDERS","shipping_paper_number":"146331","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"8690146","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1045111,"change_date":"2022-06-21 21:42:00","inspection_id":"75883974","insp_violation_id":"246631711","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189388204","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1067101,"change_date":"2022-06-21 21:42:00","inspection_id":"75883974","insp_unit_id":"189388204","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"09","insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":584686,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","dot_number":"2994863","report_state":"TX","report_number":"6B3F9DAWMI","insp_date":"2022-05-20 00:00:00","insp_start_time":"1513","insp_end_time":"1601","registration_date":"2022-06-15 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"1400  MOORE RD","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8671994","transaction_code":"C","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-06-10 21:41:00","snet_input_date":"2022-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-10 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:38:03.000000Z","updated_at":"2025-03-17T18:38:03.000000Z","inspection_violations":[{"id":914676,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489525","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39378"},{"id":914677,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489526","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3939A"},{"id":914678,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489527","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39345B2"},{"id":914679,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489528","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39345"},{"id":914680,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489529","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3939A"},{"id":914681,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489530","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3939A"},{"id":914682,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_violation_id":"246489531","seq_no":"9","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"189272454","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":939239,"change_date":"2022-06-15 21:41:00","inspection_id":"75789620","insp_unit_id":"189272454","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"129376G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:58.000000Z","updated_at":"2025-03-17T22:13:58.000000Z"}]},{"id":449995,"change_date":"2022-05-20 21:42:00","inspection_id":"75629452","dot_number":"2994863","report_state":"TX","report_number":"6B270XMNXP","insp_date":"2022-05-19 00:00:00","insp_start_time":"0704","insp_end_time":"0733","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN BRAZORIA CO. (486-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALVIN ISD","shipping_paper_number":"138595","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8661936","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-05-20 21:42:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-20 21:42:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:35:38.000000Z","updated_at":"2025-03-17T18:35:38.000000Z","inspection_violations":[{"id":712751,"change_date":"2022-05-20 21:42:00","inspection_id":"75629452","insp_violation_id":"245971618","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188829879","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39378"},{"id":712752,"change_date":"2022-05-20 21:42:00","inspection_id":"75629452","insp_violation_id":"245971619","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"188829879","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39383G"},{"id":712753,"change_date":"2022-05-20 21:42:00","inspection_id":"75629452","insp_violation_id":"245971620","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"188829879","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":725456,"change_date":"2022-05-20 21:42:00","inspection_id":"75629452","insp_unit_id":"188829879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"RDF1021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X04D813289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"}]},{"id":258130,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","dot_number":"2994863","report_state":"TX","report_number":"6A880XMNVK","insp_date":"2022-04-19 00:00:00","insp_start_time":"0822","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN BRAZORIA CO. (486-5","county_code_state":"TX","county_code":"039","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":"N","pen_cen_match":null,"final_status_date":"2022-04-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8633851","transaction_code":"A","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-04-26 21:41:00","snet_input_date":"2022-04-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-26 21:41:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:31:56.000000Z","updated_at":"2025-03-17T18:31:56.000000Z","inspection_violations":[{"id":396376,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384580","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"38323A2"},{"id":396377,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384581","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"3939A"},{"id":396378,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384582","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"3939A"},{"id":396379,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384583","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"3939A"},{"id":396380,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384584","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"39378"},{"id":396381,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384585","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"3939A"},{"id":396382,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384586","seq_no":"7","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"39360C"},{"id":396383,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_violation_id":"245384587","seq_no":"8","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"188351511","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":418025,"change_date":"2022-04-26 21:41:00","inspection_id":"75401300","insp_unit_id":"188351511","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"958092F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4VHJDCGF0XN867435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:46.000000Z","updated_at":"2025-03-17T22:10:46.000000Z"}]},{"id":138960,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","dot_number":"2994863","report_state":"TX","report_number":"69P99DGRR3","insp_date":"2022-03-31 00:00:00","insp_start_time":"1010","insp_end_time":"1045","registration_date":"2022-05-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","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":"2022-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8614680","transaction_code":"C","transaction_date":"2022-04-08 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02994863","upload_search_indicator":"M","census_search_date":"2022-04-08 21:39:00","snet_input_date":"2022-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-08 21:39:00","insp_carrier_name":"BIG J'S TRUCKING LLC","insp_carrier_street":"424 HILL RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77037-1713","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0944171","created_at":"2025-03-17T18:29:52.000000Z","updated_at":"2025-03-17T18:29:52.000000Z","inspection_violations":[{"id":206067,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_violation_id":"245844805","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188732253","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3963A1"},{"id":206068,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_violation_id":"245844806","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188732253","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3963A1"},{"id":206069,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_violation_id":"245844807","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188732253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3939A"},{"id":206070,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_violation_id":"245844808","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188732253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39311"},{"id":206071,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_violation_id":"245844809","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188732253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":225019,"change_date":"2022-05-17 21:43:00","inspection_id":"75258676","insp_unit_id":"188732253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"PGN8258","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y11W137147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:34.000000Z","updated_at":"2025-03-17T22:09:34.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2994863\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2994863\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2994863\/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\/2994863\/inspections","per_page":100,"prev_page_url":null,"to":39,"total":39}