{"current_page":1,"data":[{"id":11855891,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","dot_number":"1262609","report_state":"NY","report_number":"D103101630","insp_date":"2026-05-07 00:00:00","insp_start_time":"0803","insp_end_time":"0941","registration_date":"2026-05-21 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16590","viol_total":"15","oos_total":"6","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"6","hazmat_viol_total":"3","hazmat_oos_total":"2","snet_sequence_id":"3283780","transaction_code":"C","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:39:58.000000Z","updated_at":"2026-06-06T09:30:40.000000Z","inspection_violations":[{"id":20620881,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492855","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39395F"},{"id":20620882,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492856","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39021TB2DOT"},{"id":20620883,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492857","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39395A1"},{"id":20620880,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492854","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39021TB1MC"},{"id":20620888,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492847","seq_no":"9","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ75Q","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39343DB"},{"id":20620889,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492848","seq_no":"10","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20620893,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492852","seq_no":"14","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20620887,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492846","seq_no":"8","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ7GN","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"177834AHMC"},{"id":20620894,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492853","seq_no":"15","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39617CPI"},{"id":20620892,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492851","seq_no":"13","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20620885,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492859","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ717","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":20620890,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492849","seq_no":"11","part_no":"172","part_no_section":"600C1-HMER","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"172600C1HMER"},{"id":20620891,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492850","seq_no":"12","part_no":"393","part_no_section":"75A1-TAORETA","insp_viol_unit":"2","insp_unit_id":"213745828","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ6LG","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39375A1TAORETA"},{"id":20620884,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492858","seq_no":"5","part_no":"393","part_no_section":"40F-BNPB","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ7LQ","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"39340FBNPB"},{"id":20620886,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_violation_id":"274492860","seq_no":"7","part_no":"177","part_no_section":"817A-HMSP","insp_viol_unit":"1","insp_unit_id":"213745827","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457LLZ7BG","created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-06-06T09:42:55.000000Z","normalized_code":"177817AHMSP"}],"inspection_per_units":[{"id":20616923,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_unit_id":"213745828","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CG71513","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3EUDB1027P1023616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:20.000000Z","updated_at":"2026-06-06T09:02:02.000000Z"},{"id":20616922,"change_date":"2026-05-26 21:39:00","inspection_id":"87792112","insp_unit_id":"213745827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"72637MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FTEW1EP6KFB42255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:20.000000Z","updated_at":"2026-06-06T09:02:02.000000Z"}]},{"id":11708893,"change_date":"2026-04-21 21:38:00","inspection_id":"87635747","dot_number":"1262609","report_state":"PA","report_number":"E909611179","insp_date":"2026-04-21 00:00:00","insp_start_time":"1126","insp_end_time":"1211","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DEER CREEK TWP PA","county_code_state":"PA","county_code":"085","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"180000","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":"3190999","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"NY","created_at":"2026-04-27T09:37:47.000000Z","updated_at":"2026-05-02T09:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20375963,"change_date":"2026-04-21 21:38:00","inspection_id":"87635747","insp_unit_id":"213136783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"43389PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EX2RD666207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:06.000000Z","updated_at":"2026-05-02T09:03:10.000000Z"},{"id":20375964,"change_date":"2026-04-21 21:38:00","inspection_id":"87635747","insp_unit_id":"213136784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FOUNTAIN F","insp_unit_company":null,"insp_unit_license":"CH34267","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"13NE52304S35A4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:06.000000Z","updated_at":"2026-05-02T09:03:10.000000Z"}]},{"id":11676228,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","dot_number":"1262609","report_state":"NY","report_number":"SPT3081566","insp_date":"2026-04-10 00:00:00","insp_start_time":"0924","insp_end_time":"0958","registration_date":"2026-04-14 00:00:00","region":"ED","ci_status_code":"C","location":"40504M","location_desc":"MANCHESTER NY","county_code_state":"NY","county_code":"069","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MILTON CAT","shipping_paper_number":"2190115","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"187000","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":"3171253","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2026-04-17 21:40:00","snet_input_date":"2026-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-17 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:32:40.000000Z","updated_at":"2026-04-28T09:30:18.000000Z","inspection_violations":[{"id":20272411,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","insp_violation_id":"273660047","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213063578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:10.000000Z","updated_at":"2026-04-28T09:40:04.000000Z","normalized_code":"3939AHLLH"},{"id":20272409,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","insp_violation_id":"273660045","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"213063578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:10.000000Z","updated_at":"2026-04-28T09:40:04.000000Z","normalized_code":"3939ALTSIR"},{"id":20272410,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","insp_violation_id":"273660046","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"213063578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:46:10.000000Z","updated_at":"2026-04-28T09:40:04.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":20301517,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","insp_unit_id":"213063578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:06:14.000000Z","updated_at":"2026-04-28T09:02:27.000000Z"},{"id":20301518,"change_date":"2026-04-17 21:40:00","inspection_id":"87601300","insp_unit_id":"213063579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CH34267","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"13NE52304S35A4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:06:14.000000Z","updated_at":"2026-04-28T09:02:27.000000Z"}]},{"id":11402929,"change_date":"2026-03-18 21:37:00","inspection_id":"87317995","dot_number":"1262609","report_state":"NY","report_number":"SPT3150347","insp_date":"2026-03-11 00:00:00","insp_start_time":"0932","insp_end_time":"0959","registration_date":null,"region":"ED","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-18 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"3017884","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2026-03-18 21:37:00","snet_input_date":"2026-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-18 21:37:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-21T09:46:45.000000Z","updated_at":"2026-03-29T09:30:06.000000Z","inspection_violations":[{"id":19224511,"change_date":"2026-03-18 21:37:00","inspection_id":"87317995","insp_violation_id":"272464310","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"212191216","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:16.000000Z","updated_at":"2026-03-29T09:54:36.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19530054,"change_date":"2026-03-18 21:37:00","inspection_id":"87317995","insp_unit_id":"212191215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EX2RD666207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:14.000000Z","updated_at":"2026-03-29T09:11:47.000000Z"},{"id":19530055,"change_date":"2026-03-18 21:37:00","inspection_id":"87317995","insp_unit_id":"212191216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"43389PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:14.000000Z","updated_at":"2026-03-29T09:11:47.000000Z"}]},{"id":11102633,"change_date":"2026-02-18 21:38:00","inspection_id":"87014765","dot_number":"1262609","report_state":"NY","report_number":"D103001966","insp_date":"2026-02-06 00:00:00","insp_start_time":"1126","insp_end_time":"1144","registration_date":"2026-02-13 00:00:00","region":"ES","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"83868","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":"2872487","transaction_code":"C","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:31.000000Z","updated_at":"2026-03-01T10:30:14.000000Z","inspection_violations":[{"id":18703036,"change_date":"2026-02-18 21:38:00","inspection_id":"87014765","insp_violation_id":"271867253","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211682034","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:29.000000Z","updated_at":"2026-03-01T10:39:37.000000Z","normalized_code":"39378AWS"},{"id":18703037,"change_date":"2026-02-18 21:38:00","inspection_id":"87014765","insp_violation_id":"271867254","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"211682035","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:29.000000Z","updated_at":"2026-03-01T10:39:37.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19036436,"change_date":"2026-02-18 21:38:00","inspection_id":"87014765","insp_unit_id":"211682034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"34","insp_unit_license":"LBR7880","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XKHAJ8X1EM394677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:57.000000Z","updated_at":"2026-03-01T10:02:48.000000Z"},{"id":19036437,"change_date":"2026-02-18 21:38:00","inspection_id":"87014765","insp_unit_id":"211682035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGER BEAV","insp_unit_company":null,"insp_unit_license":"26-4560A","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"112H8V349ML084981","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:57.000000Z","updated_at":"2026-03-01T10:02:48.000000Z"}]},{"id":10105437,"change_date":"2025-11-03 21:39:00","inspection_id":"86221250","dot_number":"1262609","report_state":"VT","report_number":"50B0002478","insp_date":"2025-10-30 00:00:00","insp_start_time":"0950","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"1107SH","location_desc":"FAIR HAVEN SCALE HOUSE","county_code_state":"VT","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"221723","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-30 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-06T10:30:40.000000Z","updated_at":"2025-11-07T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16805456,"change_date":"2025-11-03 21:39:00","inspection_id":"86221250","insp_unit_id":"209801288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETER","insp_unit_company":null,"insp_unit_license":"43389PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EX2RD666207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:36.000000Z","updated_at":"2025-11-07T10:00:51.000000Z"},{"id":16805457,"change_date":"2025-11-03 21:39:00","inspection_id":"86221250","insp_unit_id":"209801289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":null,"insp_unit_license":"2374300","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"13N248203D1554699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:36.000000Z","updated_at":"2025-11-07T10:00:51.000000Z"}]},{"id":10013370,"change_date":"2025-11-18 21:38:00","inspection_id":"86124193","dot_number":"1262609","report_state":"NY","report_number":"SPT3101014","insp_date":"2025-10-16 00:00:00","insp_start_time":"0854","insp_end_time":"0916","registration_date":"2025-11-17 00:00:00","region":"ED","ci_status_code":"C","location":"20330R","location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"194000","viol_total":"2","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":"2445978","transaction_code":"C","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:46.000000Z","updated_at":"2025-11-23T10:30:11.000000Z","inspection_violations":[{"id":16995808,"change_date":"2025-11-18 21:38:00","inspection_id":"86124193","insp_violation_id":"270025670","seq_no":"1","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"210087380","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:40.000000Z","updated_at":"2025-11-23T10:30:14.000000Z","normalized_code":"39381H"},{"id":16995809,"change_date":"2025-11-18 21:38:00","inspection_id":"86124193","insp_violation_id":"270025671","seq_no":"2","part_no":"396","part_no_section":"3A1-ALATR","insp_viol_unit":"2","insp_unit_id":"210087381","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:40.000000Z","updated_at":"2025-11-23T10:30:14.000000Z","normalized_code":"3963A1ALATR"}],"inspection_per_units":[{"id":17035832,"change_date":"2025-11-18 21:38:00","inspection_id":"86124193","insp_unit_id":"210087380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON28","insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:49.000000Z","updated_at":"2025-11-23T10:00:14.000000Z"},{"id":17035833,"change_date":"2025-11-18 21:38:00","inspection_id":"86124193","insp_unit_id":"210087381","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"BP76576","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE55300K3575170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:49.000000Z","updated_at":"2025-11-23T10:00:14.000000Z"}]},{"id":9822392,"change_date":"2025-10-10 21:40:00","inspection_id":"85922798","dot_number":"1262609","report_state":"NY","report_number":"SPE3020910","insp_date":"2025-09-24 00:00:00","insp_start_time":"0900","insp_end_time":"0921","registration_date":"2025-10-09 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BROCKPORT NY","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-10-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"187000","viol_total":"2","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":"2348675","transaction_code":"C","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2025-10-01 21:39:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-01 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-04T10:01:34.000000Z","updated_at":"2025-10-14T10:00:38.000000Z","inspection_violations":[{"id":16347185,"change_date":"2025-10-10 21:40:00","inspection_id":"85922798","insp_violation_id":"269225444","seq_no":"1","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-13T10:18:01.000000Z","updated_at":"2025-10-14T10:16:03.000000Z","normalized_code":"3958A"},{"id":16347186,"change_date":"2025-10-10 21:40:00","inspection_id":"85922798","insp_violation_id":"269225445","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209403448","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-13T10:18:01.000000Z","updated_at":"2025-10-14T10:16:03.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16442402,"change_date":"2025-10-10 21:40:00","inspection_id":"85922798","insp_unit_id":"209403448","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:26.000000Z","updated_at":"2025-10-14T09:45:47.000000Z"},{"id":16442403,"change_date":"2025-10-10 21:40:00","inspection_id":"85922798","insp_unit_id":"209403449","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CH34267","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"13NE52304S35A4638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:26.000000Z","updated_at":"2025-10-14T09:45:47.000000Z"}]},{"id":8642623,"change_date":"2025-05-20 21:41:00","inspection_id":"84680318","dot_number":"1262609","report_state":"MA","report_number":"DD00002343","insp_date":"2025-05-14 00:00:00","insp_start_time":"1830","insp_end_time":"1844","registration_date":"2025-05-20 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MILTON CATERPILLAR","shipping_paper_number":"1704581","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"517660","transaction_code":"C","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"6627","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:04:14.000000Z","updated_at":"2025-05-24T10:04:52.000000Z","inspection_violations":[{"id":13839570,"change_date":"2025-05-20 21:41:00","inspection_id":"84680318","insp_violation_id":"266349941","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-05-23T10:34:13.000000Z","updated_at":"2025-05-24T10:23:31.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":14192665,"change_date":"2025-05-20 21:41:00","inspection_id":"84680318","insp_unit_id":"206965016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON40","insp_unit_license":"43389PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EX2RD666207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:02.000000Z","updated_at":"2025-05-24T09:50:08.000000Z"},{"id":14192666,"change_date":"2025-05-20 21:41:00","inspection_id":"84680318","insp_unit_id":"206965017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:02.000000Z","updated_at":"2025-05-24T09:50:08.000000Z"}]},{"id":8544570,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","dot_number":"1262609","report_state":"NY","report_number":"SPG3000175","insp_date":"2025-04-28 00:00:00","insp_start_time":"1233","insp_end_time":"1301","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"6","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":"1684076","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2025-05-05 21:39:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-05 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:02:56.000000Z","updated_at":"2025-05-09T10:20:45.000000Z","inspection_violations":[{"id":13536261,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999372","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"3922SLLIFTA"},{"id":13536262,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999373","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"3922SLLSR"},{"id":13536263,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999374","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"3939ALHLI"},{"id":13536264,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999375","seq_no":"4","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"39355D1B"},{"id":13536265,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999376","seq_no":"5","part_no":"393","part_no_section":"11A1-LTNRV","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"39311A1LTNRV"},{"id":13536266,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_violation_id":"265999377","seq_no":"6","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206636711","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:20:27.000000Z","updated_at":"2025-05-09T10:35:26.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13894526,"change_date":"2025-05-05 21:39:00","inspection_id":"84577402","insp_unit_id":"206636711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON25","insp_unit_license":"54497PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCLP0X6HD417050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:50:05.000000Z","updated_at":"2025-05-09T09:51:51.000000Z"}]},{"id":8164406,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","dot_number":"1262609","report_state":"NY","report_number":"D103400075","insp_date":"2025-03-14 00:00:00","insp_start_time":"0734","insp_end_time":"0836","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CANAJOHARIE NY","county_code_state":"NY","county_code":"057","insp_level_id":"1","service_center":"EA","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":"U","pen_cen_match":"I","final_status_date":"2025-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"185500","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1493076","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2025-03-20 21:41:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-20 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:45:59.000000Z","updated_at":"2025-03-24T10:24:14.000000Z","inspection_violations":[{"id":12786449,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_violation_id":"265146498","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"205896057","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-22T11:02:21.000000Z","updated_at":"2025-03-23T11:29:56.000000Z","normalized_code":"3939ALSLIWR"},{"id":12786450,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_violation_id":"265146499","seq_no":"2","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"205896056","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-22T11:02:21.000000Z","updated_at":"2025-03-23T11:29:56.000000Z","normalized_code":"3963A1F"},{"id":12786451,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_violation_id":"265146500","seq_no":"3","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"205896056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:02:21.000000Z","updated_at":"2025-03-23T11:29:56.000000Z","normalized_code":"39311A1CSLRR"},{"id":12786452,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_violation_id":"265146501","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205896057","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:02:21.000000Z","updated_at":"2025-03-23T11:29:56.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13192725,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_unit_id":"205896056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON33","insp_unit_license":"14993PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG30D354196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:10:37.000000Z","updated_at":"2025-03-24T09:55:33.000000Z"},{"id":13192726,"change_date":"2025-03-20 21:41:00","inspection_id":"84176720","insp_unit_id":"205896057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"T-26","insp_unit_license":"CE86415","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53306H3574361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:10:37.000000Z","updated_at":"2025-03-24T09:55:33.000000Z"}]},{"id":7425238,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","dot_number":"1262609","report_state":"NY","report_number":"SPT3100245","insp_date":"2024-12-10 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"ES","ci_status_code":"C","location":"20802R","location_desc":"HERKIMER NY","county_code_state":"NY","county_code":"043","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MILTON CAT","shipping_paper_number":"P001721897","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"183830","viol_total":"3","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":"1161157","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2024-12-16 21:39:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-16 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:07.000000Z","updated_at":"2025-03-17T20:51:07.000000Z","inspection_violations":[{"id":11603717,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","insp_violation_id":"263483521","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204401225","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:31.000000Z","updated_at":"2025-03-17T22:02:31.000000Z","normalized_code":"39378AWS"},{"id":11603718,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","insp_violation_id":"263483522","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"204401225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2T82JS7BKW","created_at":"2025-03-17T22:02:31.000000Z","updated_at":"2025-03-17T22:02:31.000000Z","normalized_code":"39311A1CSURR"},{"id":11603719,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","insp_violation_id":"263483523","seq_no":"3","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"204401225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2T82JS7B9Q","created_at":"2025-03-17T22:02:31.000000Z","updated_at":"2025-03-17T22:02:31.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":11979333,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","insp_unit_id":"204401225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"CON33","insp_unit_license":"14993PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG30D354196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:14.000000Z","updated_at":"2025-03-17T23:47:14.000000Z"},{"id":11979334,"change_date":"2024-12-16 21:39:00","inspection_id":"83400259","insp_unit_id":"204401226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:14.000000Z","updated_at":"2025-03-17T23:47:14.000000Z"}]},{"id":6815928,"change_date":"2024-09-25 21:41:00","inspection_id":"82755269","dot_number":"1262609","report_state":"NY","report_number":"SPK0196043","insp_date":"2024-09-19 00:00:00","insp_start_time":"1800","insp_end_time":"1920","registration_date":null,"region":"ET","ci_status_code":"C","location":"12001","location_desc":"LOUDONVILLE","county_code_state":"NY","county_code":"001","insp_level_id":"5","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"187220","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":"2952387","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":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10991231,"change_date":"2024-09-25 21:41:00","inspection_id":"82755269","insp_unit_id":"203122892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON28","insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"Y","insp_unit_decal_number":"34338196","created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"},{"id":10991232,"change_date":"2024-09-25 21:41:00","inspection_id":"82755269","insp_unit_id":"203122893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T31","insp_unit_license":"BP76577","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE52306K3575284","insp_unit_decal":"Y","insp_unit_decal_number":"34338197","created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"}]},{"id":6050982,"change_date":"2024-07-02 21:41:00","inspection_id":"81937383","dot_number":"1262609","report_state":"VT","report_number":"2161009048","insp_date":"2024-06-20 00:00:00","insp_start_time":"1021","insp_end_time":"1033","registration_date":"2024-07-01 00:00:00","region":"ET","ci_status_code":"C","location":"0118","location_desc":"SHOREHAM","county_code_state":"VT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-22 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"132300","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":"207256","transaction_code":"C","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-20 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-06-22 21:31:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:37.000000Z","updated_at":"2025-03-17T20:22:37.000000Z","inspection_violations":[{"id":9386685,"change_date":"2024-07-02 21:41:00","inspection_id":"81937383","insp_violation_id":"260432827","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:51:25.000000Z","updated_at":"2025-03-17T21:51:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9745896,"change_date":"2024-07-02 21:41:00","inspection_id":"81937383","insp_unit_id":"201697849","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETER","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:59.000000Z","updated_at":"2025-03-17T23:23:59.000000Z"},{"id":9745897,"change_date":"2024-07-02 21:41:00","inspection_id":"81937383","insp_unit_id":"201697850","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"2374300","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"13N248203D1554699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:59.000000Z","updated_at":"2025-03-17T23:23:59.000000Z"}]},{"id":5866539,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","dot_number":"1262609","report_state":"NY","report_number":"SPWC011066","insp_date":"2024-05-28 00:00:00","insp_start_time":"1329","insp_end_time":"1357","registration_date":null,"region":"ET","ci_status_code":"C","location":"90286","location_desc":"I-88 (FENTON)","county_code_state":"NY","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"KOMATSU AMERICA CORP","shipping_paper_number":"2258590","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"131830","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2926946","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:03.000000Z","updated_at":"2025-03-17T20:19:03.000000Z","inspection_violations":[{"id":9095687,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_violation_id":"259787631","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:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"},{"id":9095688,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_violation_id":"259787632","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201133692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"},{"id":9095689,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_violation_id":"259787633","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201133692","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"},{"id":9095690,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_violation_id":"259787634","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201133693","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9448490,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_unit_id":"201133692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:00.000000Z","updated_at":"2025-03-17T23:21:00.000000Z"},{"id":9448491,"change_date":"2024-05-29 21:41:00","inspection_id":"81737254","insp_unit_id":"201133693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:00.000000Z","updated_at":"2025-03-17T23:21:00.000000Z"}]},{"id":5432613,"change_date":"2024-04-04 21:42:00","inspection_id":"81265358","dot_number":"1262609","report_state":"VT","report_number":"4100004078","insp_date":"2024-04-02 00:00:00","insp_start_time":"1115","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"0405NB","location_desc":"COLCHESTER NB WS","county_code_state":"VT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"STL24-1868","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"204000","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":"204989","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:18.000000Z","updated_at":"2025-03-17T20:10:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8750675,"change_date":"2024-04-04 21:42:00","inspection_id":"81265358","insp_unit_id":"200232008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"},{"id":8750676,"change_date":"2024-04-04 21:42:00","inspection_id":"81265358","insp_unit_id":"200232009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"BP76577","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE52306K3575284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5303807,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","dot_number":"1262609","report_state":"NY","report_number":"SPB0372545","insp_date":"2024-03-08 00:00:00","insp_start_time":"0855","insp_end_time":"0948","registration_date":null,"region":"ET","ci_status_code":"C","location":"10756","location_desc":"SCHROON SALT BARN","county_code_state":"NY","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ADMAR","shipping_paper_number":"AL1014194","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"187220","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2912306","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:52.000000Z","updated_at":"2025-03-17T20:07:52.000000Z","inspection_violations":[{"id":8180558,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427009","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199951657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"39311"},{"id":8180559,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427010","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199951657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1HSP90S","created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"39311"},{"id":8180560,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427011","seq_no":"3","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"199951658","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"393104F3"},{"id":8180561,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427012","seq_no":"4","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"199951658","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"393130B"},{"id":8180562,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427013","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199951658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"},{"id":8180563,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_violation_id":"258427014","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199951658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8541457,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_unit_id":"199951657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"},{"id":8541458,"change_date":"2024-03-18 21:38:00","inspection_id":"81124785","insp_unit_id":"199951658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BP76577","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE52306K3575284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:25.000000Z","updated_at":"2025-03-17T23:12:25.000000Z"}]},{"id":5489751,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","dot_number":"1262609","report_state":"VT","report_number":"3700000179","insp_date":"2024-03-01 00:00:00","insp_start_time":"0943","insp_end_time":"1101","registration_date":null,"region":"ET","ci_status_code":"C","location":"0417NB","location_desc":"WILLISTON RA NB","county_code_state":"VT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"STL24-1150","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"184830","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"205164","transaction_code":"C","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-01 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[{"id":8478533,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","insp_violation_id":"261461989","seq_no":"1","part_no":"392","part_no_section":"2","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-17T21:47:02.000000Z","updated_at":"2025-03-17T21:47:02.000000Z","normalized_code":"3922"},{"id":8478534,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","insp_violation_id":"261461990","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202626967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:02.000000Z","updated_at":"2025-03-17T21:47:02.000000Z","normalized_code":"3939A"},{"id":8478535,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","insp_violation_id":"261461991","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202626968","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:02.000000Z","updated_at":"2025-03-17T21:47:02.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8842946,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","insp_unit_id":"202626967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"},{"id":8842947,"change_date":"2024-08-28 21:42:00","inspection_id":"81327953","insp_unit_id":"202626968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"T37","insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"}]},{"id":4370615,"change_date":"2023-11-07 21:40:00","inspection_id":"80103001","dot_number":"1262609","report_state":"NY","report_number":"SPT0541029","insp_date":"2023-11-06 00:00:00","insp_start_time":"1247","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854","location_desc":"VERONA","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"187220","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2884830","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:32.000000Z","updated_at":"2025-03-17T19:49:32.000000Z","inspection_violations":[{"id":6761952,"change_date":"2023-11-07 21:40:00","inspection_id":"80103001","insp_violation_id":"256256702","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3922"},{"id":6761953,"change_date":"2023-11-07 21:40:00","inspection_id":"80103001","insp_violation_id":"256256703","seq_no":"2","part_no":"395","part_no_section":"8(f)(11)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3958F11"}],"inspection_per_units":[{"id":7029219,"change_date":"2023-11-07 21:40:00","inspection_id":"80103001","insp_unit_id":"197940225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON28","insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"},{"id":7029220,"change_date":"2023-11-07 21:40:00","inspection_id":"80103001","insp_unit_id":"197940226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T31","insp_unit_license":"BP76577","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE52306K3575284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":4380919,"change_date":"2023-11-08 21:40:00","inspection_id":"80114777","dot_number":"1262609","report_state":"NY","report_number":"SPG0224912","insp_date":"2023-11-03 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"10917","location_desc":"WILTON FIRE DEPT ST RTE 50","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"2885127","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2023-11-08 21:40:00","snet_input_date":"2023-11-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-08 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:49.000000Z","updated_at":"2025-03-17T19:49:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7045439,"change_date":"2023-11-08 21:40:00","inspection_id":"80114777","insp_unit_id":"197962596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON26","insp_unit_license":"54499PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCLP0X8HD417051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:09.000000Z","updated_at":"2025-03-17T22:59:09.000000Z"}]},{"id":4054288,"change_date":"2023-09-26 21:42:00","inspection_id":"79752965","dot_number":"1262609","report_state":"NY","report_number":"SPG0214923","insp_date":"2023-09-14 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","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-09-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"183800","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":"2872919","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-26 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:50.000000Z","updated_at":"2025-03-17T19:42:50.000000Z","inspection_violations":[{"id":6276042,"change_date":"2023-09-26 21:42:00","inspection_id":"79752965","insp_violation_id":"255476352","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197233407","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:15.000000Z","updated_at":"2025-03-17T21:36:15.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6518799,"change_date":"2023-09-26 21:42:00","inspection_id":"79752965","insp_unit_id":"197233407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON33","insp_unit_license":"14993PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG30D354196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"},{"id":6518800,"change_date":"2023-09-26 21:42:00","inspection_id":"79752965","insp_unit_id":"197233408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"CE86415","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53306H3574361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"}]},{"id":3950711,"change_date":"2023-09-12 21:39:00","inspection_id":"79638032","dot_number":"1262609","report_state":"MA","report_number":"CW00002081","insp_date":"2023-09-11 00:00:00","insp_start_time":"1700","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":"141H","location_desc":"H-HATFIELD","county_code_state":"MA","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"186000","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":"473765","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":"2023-09-12 21:39:00","snet_input_date":"2023-09-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-12 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"6627","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:49.000000Z","updated_at":"2025-03-17T19:40:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6352711,"change_date":"2023-09-12 21:39:00","inspection_id":"79638032","insp_unit_id":"197004018","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETER","insp_unit_company":null,"insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"},{"id":6352712,"change_date":"2023-09-12 21:39:00","inspection_id":"79638032","insp_unit_id":"197004019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:22.000000Z","updated_at":"2025-03-17T22:53:22.000000Z"}]},{"id":3649078,"change_date":"2023-08-02 21:40:00","inspection_id":"79301159","dot_number":"1262609","report_state":"NY","report_number":"SPA0340301","insp_date":"2023-08-01 00:00:00","insp_start_time":"0854","insp_end_time":"0919","registration_date":null,"region":"ET","ci_status_code":"C","location":"50011","location_desc":"ALLEGANY REST AREA","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MILTON CAT","shipping_paper_number":"1240555","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"2854773","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2023-08-02 21:40:00","snet_input_date":"2023-08-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-02 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM I","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:56.000000Z","updated_at":"2025-03-17T19:34:56.000000Z","inspection_violations":[{"id":5627119,"change_date":"2023-08-02 21:40:00","inspection_id":"79301159","insp_violation_id":"254413410","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":5867171,"change_date":"2023-08-02 21:40:00","inspection_id":"79301159","insp_unit_id":"196314785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON33","insp_unit_license":"14993PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG30D354196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:20.000000Z","updated_at":"2025-03-17T22:49:20.000000Z"},{"id":5867172,"change_date":"2023-08-02 21:40:00","inspection_id":"79301159","insp_unit_id":"196314786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"CE86415","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53306H3574361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:20.000000Z","updated_at":"2025-03-17T22:49:20.000000Z"}]},{"id":3573820,"change_date":"2023-07-24 21:41:00","inspection_id":"79216953","dot_number":"1262609","report_state":"NY","report_number":"SPG0174138","insp_date":"2023-07-21 00:00:00","insp_start_time":"1310","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"2850377","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:34.000000Z","updated_at":"2025-03-17T19:33:34.000000Z","inspection_violations":[{"id":5510879,"change_date":"2023-07-24 21:41:00","inspection_id":"79216953","insp_violation_id":"254223891","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5746005,"change_date":"2023-07-24 21:41:00","inspection_id":"79216953","insp_unit_id":"196145193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON26","insp_unit_license":"54499PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCLP0X8HD417051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:21.000000Z","updated_at":"2025-03-17T22:48:21.000000Z"}]},{"id":3518850,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","dot_number":"1262609","report_state":"NY","report_number":"SPG0261036","insp_date":"2023-07-11 00:00:00","insp_start_time":"0950","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CONSTANTINE CONSTRUCTION YARD","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"68000","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":"2847875","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2023-07-17 21:40:00","snet_input_date":"2023-07-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-17 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:31.000000Z","updated_at":"2025-03-17T19:32:31.000000Z","inspection_violations":[{"id":5425947,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087290","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GZ0837","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5425948,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087291","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GZ08K0","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5425949,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087292","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8GZ092M","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5425950,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087293","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5425951,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087294","seq_no":"5","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39375G"},{"id":5425952,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087295","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3939A"},{"id":5425953,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_violation_id":"254087296","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196022517","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5657788,"change_date":"2023-07-17 21:40:00","inspection_id":"79155170","insp_unit_id":"196022517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON25","insp_unit_license":"54497PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCLP0X6HD417050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:39.000000Z","updated_at":"2025-03-17T22:47:39.000000Z"}]},{"id":3090628,"change_date":"2023-06-12 21:39:00","inspection_id":"78672816","dot_number":"1262609","report_state":"MA","report_number":"CW00001680","insp_date":"2023-05-17 00:00:00","insp_start_time":"1530","insp_end_time":"1540","registration_date":"2023-06-12 00:00:00","region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60320","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":"466206","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-17 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"6627","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4752397,"change_date":"2023-06-12 21:39:00","inspection_id":"78672816","insp_violation_id":"253424795","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4971473,"change_date":"2023-06-12 21:39:00","inspection_id":"78672816","insp_unit_id":"195430447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETER","insp_unit_company":null,"insp_unit_license":"71495PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X7KD606154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":2762644,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","dot_number":"1262609","report_state":"NY","report_number":"SPT0540430","insp_date":"2023-04-07 00:00:00","insp_start_time":"0552","insp_end_time":"0646","registration_date":null,"region":"ET","ci_status_code":"C","location":"20280","location_desc":"SCHUYLER","county_code_state":"NY","county_code":"043","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CATERPILLAR D3LGP","shipping_paper_number":"1161173","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:03:00","post_acc_ind":"N","gross_comb_veh_wt":"186000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2814764","transaction_code":"A","transaction_date":"2023-04-07 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":"2023-04-11 12:03:00","snet_input_date":"2023-04-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-11 12:03:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM I","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:39.000000Z","updated_at":"2025-03-17T19:17:39.000000Z","inspection_violations":[{"id":4239453,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","insp_violation_id":"252116964","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:47.000000Z","updated_at":"2025-03-17T21:26:47.000000Z","normalized_code":"3922"},{"id":4239454,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","insp_violation_id":"252116965","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194291847","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:47.000000Z","updated_at":"2025-03-17T21:26:47.000000Z","normalized_code":"3939A"},{"id":4239455,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","insp_violation_id":"252116966","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194291848","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:47.000000Z","updated_at":"2025-03-17T21:26:47.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4446154,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","insp_unit_id":"194291847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"},{"id":4446155,"change_date":"2023-04-11 12:03:00","inspection_id":"78302015","insp_unit_id":"194291848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"}]},{"id":2500029,"change_date":"2023-03-03 21:40:00","inspection_id":"78002859","dot_number":"1262609","report_state":"TN","report_number":"TBLW002284","insp_date":"2023-03-02 00:00:00","insp_start_time":"1218","insp_end_time":"1234","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 1 I-40 KNOXVILLE SCALES","county_code_state":"TN","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","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":"1632763","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-03 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-03-03 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:53.000000Z","updated_at":"2025-03-17T19:12:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4022865,"change_date":"2023-03-03 21:40:00","inspection_id":"78002859","insp_unit_id":"193694802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"},{"id":4022866,"change_date":"2023-03-03 21:40:00","inspection_id":"78002859","insp_unit_id":"193694803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"37","insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"}]},{"id":2322003,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","dot_number":"1262609","report_state":"NY","report_number":"SPT0376745","insp_date":"2023-02-07 00:00:00","insp_start_time":"1600","insp_end_time":"1639","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"187220","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":"2796569","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:35.000000Z","updated_at":"2025-03-17T19:09:35.000000Z","inspection_violations":[{"id":3575908,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","insp_violation_id":"251008426","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193286015","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"},{"id":3575909,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","insp_violation_id":"251008427","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193286016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"},{"id":3575910,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","insp_violation_id":"251008428","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193286015","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3GDL690","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3736921,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","insp_unit_id":"193286015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON28","insp_unit_license":"25152PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG40D119502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:46.000000Z","updated_at":"2025-03-17T22:32:46.000000Z"},{"id":3736922,"change_date":"2023-02-08 21:39:00","inspection_id":"77799569","insp_unit_id":"193286016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"T-31","insp_unit_license":"BP76577","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE52306K3575284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:46.000000Z","updated_at":"2025-03-17T22:32:46.000000Z"}]},{"id":2331735,"change_date":"2023-02-09 21:39:00","inspection_id":"77810585","dot_number":"1262609","report_state":"NY","report_number":"SPT0420936","insp_date":"2023-02-07 00:00:00","insp_start_time":"1605","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2796731","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[{"id":3592104,"change_date":"2023-02-09 21:39:00","inspection_id":"77810585","insp_violation_id":"251034553","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193307603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3752203,"change_date":"2023-02-09 21:39:00","inspection_id":"77810585","insp_unit_id":"193307602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:53.000000Z","updated_at":"2025-03-17T22:32:53.000000Z"},{"id":3752204,"change_date":"2023-02-09 21:39:00","inspection_id":"77810585","insp_unit_id":"193307603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:53.000000Z","updated_at":"2025-03-17T22:32:53.000000Z"}]},{"id":1985118,"change_date":"2022-12-20 21:41:00","inspection_id":"77415140","dot_number":"1262609","report_state":"IN","report_number":"9512004219","insp_date":"2022-12-16 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"5370E","location_desc":"#53 I-70 EB VIGO","county_code_state":"IN","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"RITCHIE BROTHERS AUCTIONS","shipping_paper_number":"ES9303","cargo_tank":null,"hazmat_placard_req":null,"snet_version_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":"I","final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"2166480","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-19 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:18.000000Z","updated_at":"2025-03-17T19:03:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3193598,"change_date":"2022-12-20 21:41:00","inspection_id":"77415140","insp_unit_id":"192513243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:52.000000Z","updated_at":"2025-03-17T22:28:52.000000Z"},{"id":3193599,"change_date":"2022-12-20 21:41:00","inspection_id":"77415140","insp_unit_id":"192513244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"37","insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:52.000000Z","updated_at":"2025-03-17T22:28:52.000000Z"}]},{"id":1631435,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","dot_number":"1262609","report_state":"NY","report_number":"SPG0260730","insp_date":"2022-10-28 00:00:00","insp_start_time":"0900","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"10501","location_desc":"PARADE GROUND VILLAGE","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21290","viol_total":"10","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2764474","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:41.000000Z","updated_at":"2025-03-17T18:56:41.000000Z","inspection_violations":[{"id":2560906,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326811","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39141A1"},{"id":2560907,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326812","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39021B"},{"id":2560908,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326813","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8G1NVC8","created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39617C"},{"id":2560909,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326814","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39378"},{"id":2560910,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326815","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39395A"},{"id":2560911,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326816","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39395F"},{"id":2560912,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326817","seq_no":"7","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"191710030","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39343D"},{"id":2560913,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326818","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191710030","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"39617C"},{"id":2560914,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326819","seq_no":"9","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"2","insp_unit_id":"191710030","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"177834A"},{"id":2560915,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_violation_id":"249326820","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191710029","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2624280,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_unit_id":"191710029","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"95874ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT8X3B69KEC94425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"},{"id":2624281,"change_date":"2022-10-31 21:40:00","inspection_id":"77009797","insp_unit_id":"191710030","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CD79549","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1J9BE2023PD498712","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1568920,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","dot_number":"1262609","report_state":"NY","report_number":"SPA0284766","insp_date":"2022-10-19 00:00:00","insp_start_time":"1400","insp_end_time":"1441","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONSTANTINE CONSTRUCTION AND FARM INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"170320","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2761346","transaction_code":"A","transaction_date":"2022-10-21 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:35.000000Z","updated_at":"2025-03-17T18:55:35.000000Z","inspection_violations":[{"id":2466963,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","insp_violation_id":"249169493","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3958A1"},{"id":2466964,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","insp_violation_id":"249169494","seq_no":"2","part_no":"395","part_no_section":"8(f)(11)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3958F11"},{"id":2466965,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","insp_violation_id":"249169495","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"191567448","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2524790,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","insp_unit_id":"191567447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"30","insp_unit_license":"71496PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2KD606157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"},{"id":2524791,"change_date":"2022-10-21 21:39:00","inspection_id":"76938099","insp_unit_id":"191567448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"3035723","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1E1U2Z387LR072057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]},{"id":1547549,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","dot_number":"1262609","report_state":"NY","report_number":"SPG0250818","insp_date":"2022-10-18 00:00:00","insp_start_time":"1129","insp_end_time":"1244","registration_date":null,"region":"ET","ci_status_code":"C","location":"10360","location_desc":"HALFMON","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"2760392","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-19 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:12.000000Z","updated_at":"2025-03-17T18:55:12.000000Z","inspection_violations":[{"id":2434912,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111389","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3939A"},{"id":2434913,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111390","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3922"},{"id":2434914,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111391","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39395A"},{"id":2434915,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111392","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3G0M84C","created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3922"},{"id":2434916,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111393","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39378"},{"id":2434917,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_violation_id":"249111394","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191513720","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2490223,"change_date":"2022-10-19 21:40:00","inspection_id":"76913261","insp_unit_id":"191513720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON26","insp_unit_license":"54499PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCLP0X8HD417051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:05.000000Z","updated_at":"2025-03-17T22:24:05.000000Z"}]},{"id":1541273,"change_date":"2023-04-20 21:42:00","inspection_id":"76906095","dot_number":"1262609","report_state":"IL","report_number":"4038550811","insp_date":"2022-10-14 00:00:00","insp_start_time":"0823","insp_end_time":"0835","registration_date":"2023-04-20 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","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":"2204948","transaction_code":"C","transaction_date":"2022-10-14 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-14 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM I","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:10.000000Z","updated_at":"2025-03-17T18:55:10.000000Z","inspection_violations":[{"id":2425865,"change_date":"2023-04-20 21:42:00","inspection_id":"76906095","insp_violation_id":"252342238","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2480131,"change_date":"2023-04-20 21:42:00","inspection_id":"76906095","insp_unit_id":"194497573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"},{"id":2480132,"change_date":"2023-04-20 21:42:00","inspection_id":"76906095","insp_unit_id":"194497574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:01.000000Z","updated_at":"2025-03-17T22:24:01.000000Z"}]},{"id":1256384,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","dot_number":"1262609","report_state":"NY","report_number":"SPA0333342","insp_date":"2022-09-08 00:00:00","insp_start_time":"0905","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"173000","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":"2747776","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-12 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:46.000000Z","updated_at":"2025-03-17T18:49:46.000000Z","inspection_violations":[{"id":1989051,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_violation_id":"248331345","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190828443","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"3922"},{"id":1989052,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_violation_id":"248331346","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190828444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"3939A"},{"id":1989053,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_violation_id":"248331347","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190828444","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"6FVBXKP","created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39375A3"},{"id":1989054,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_violation_id":"248331348","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190828444","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2021805,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_unit_id":"190828443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:53.000000Z","updated_at":"2025-03-17T22:20:53.000000Z"},{"id":2021806,"change_date":"2022-09-12 21:42:00","inspection_id":"76575603","insp_unit_id":"190828444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T32","insp_unit_license":"3125369","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1RNT48A3XAR023451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:53.000000Z","updated_at":"2025-03-17T22:20:53.000000Z"}]},{"id":1211690,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","dot_number":"1262609","report_state":"NY","report_number":"SPG0250777","insp_date":"2022-09-02 00:00:00","insp_start_time":"1509","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":"10355","location_desc":"GUILDERLAND","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"217000","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2745851","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-06 21:41:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:59.000000Z","updated_at":"2025-03-17T18:48:59.000000Z","inspection_violations":[{"id":1921014,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212590","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190722217","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"3922"},{"id":1921015,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212591","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190722218","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"39375A3"},{"id":1921016,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212592","seq_no":"3","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"190722218","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"393104F3"},{"id":1921017,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212593","seq_no":"4","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"190722218","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"393130"},{"id":1921018,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212594","seq_no":"5","part_no":"393","part_no_section":"106(d)","insp_viol_unit":"2","insp_unit_id":"190722218","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"393106D"},{"id":1921019,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212595","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190722217","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"3922"},{"id":1921020,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_violation_id":"248212596","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190722218","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:53.000000Z","updated_at":"2025-03-17T21:15:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1948783,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_unit_id":"190722217","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:23.000000Z","updated_at":"2025-03-17T22:20:23.000000Z"},{"id":1948784,"change_date":"2022-09-06 21:41:00","inspection_id":"76524156","insp_unit_id":"190722218","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"BL70754","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE54301H3574368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:23.000000Z","updated_at":"2025-03-17T22:20:23.000000Z"}]},{"id":1130216,"change_date":"2022-08-25 21:42:00","inspection_id":"76429517","dot_number":"1262609","report_state":"NY","report_number":"SPK0194587","insp_date":"2022-08-24 00:00:00","insp_start_time":"1300","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"80248","location_desc":"EAST FISHKILL (EB)","county_code_state":"NY","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","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":"2743315","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:34.000000Z","updated_at":"2025-03-17T18:47:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1817691,"change_date":"2022-08-25 21:42:00","inspection_id":"76429517","insp_unit_id":"190530227","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON13","insp_unit_license":"25151PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DBTX47N735557","insp_unit_decal":"Y","insp_unit_decal_number":"31688519","created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"}]},{"id":1130196,"change_date":"2022-08-25 21:42:00","inspection_id":"76429497","dot_number":"1262609","report_state":"NY","report_number":"SPK0194582","insp_date":"2022-08-23 00:00:00","insp_start_time":"0900","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"80868","location_desc":"FISHKILL DOT RESIDENCY","county_code_state":"NY","county_code":"027","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"211830","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":"2743205","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:34.000000Z","updated_at":"2025-03-17T18:47:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1817665,"change_date":"2022-08-25 21:42:00","inspection_id":"76429497","insp_unit_id":"190530200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"Y","insp_unit_decal_number":"31688517","created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"},{"id":1817666,"change_date":"2022-08-25 21:42:00","inspection_id":"76429497","insp_unit_id":"190530201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"Y","insp_unit_decal_number":"31688518","created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"}]},{"id":262618,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","dot_number":"1262609","report_state":"NY","report_number":"SPWC070852","insp_date":"2022-04-26 00:00:00","insp_start_time":"0839","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"90051","location_desc":"I-81 T\/BARKER","county_code_state":"NY","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONSTANTINE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"183830","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2699318","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01262609","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-27 21:39:00","insp_carrier_name":"CONSTANTINE CONSTRUCTION AND FARM INC","insp_carrier_street":"564 ALBANY SHAKER ROAD","insp_carrier_city":"LOUDONVILLE","insp_carrier_state":"NY","insp_carrier_zip_code":"12211","insp_colonia":null,"docket_number":"662740","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:12.000000Z","updated_at":"2025-03-17T18:32:12.000000Z","inspection_violations":[{"id":404312,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","insp_violation_id":"245397219","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3958F1"},{"id":404313,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","insp_violation_id":"245397220","seq_no":"2","part_no":"395","part_no_section":"8(f)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3958F4"},{"id":404314,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","insp_violation_id":"245397221","seq_no":"3","part_no":"395","part_no_section":"8(f)(7)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:59.000000Z","updated_at":"2025-03-17T21:08:59.000000Z","normalized_code":"3958F7"}],"inspection_per_units":[{"id":424919,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","insp_unit_id":"188360991","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CON32","insp_unit_license":"80081PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGG70D268499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"},{"id":424920,"change_date":"2022-04-27 21:39:00","inspection_id":"75406392","insp_unit_id":"188360992","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"31","insp_unit_license":"CC51762","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53302N35A0457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1262609\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1262609\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1262609\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1262609\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}