Amalio Jauregui Inspection Reports

SELECT INSPECTION_ID,DOT_NUMBER,REPORT_STATE,REPORT_NUMBER,INSP_DATE,INSP_START_TIME,INSP_END_TIME,REGISTRATION_DATE,REGION,CI_STATUS_CODE,LOCATION,LOCATION_DESC,COUNTY_CODE_STATE,COUNTY_CODE,INSP_LEVEL_ID,SERVICE_CENTER,CENSUS_SOURCE_ID,INSP_FACILITY,SHIPPER_NAME,SHIPPING_PAPER_NUMBER,CARGO_TANK,SNET_VERSION_NUMBER,SNET_SEARCH_DATE,ALCOHOL_CONTROL_SUB,DRUG_INTRDCTN_SEARCH,DRUG_INTRDCTN_ARRESTS,SIZE_WEIGHT_ENF,TRAFFIC_ENF,LOCAL_ENF_JURISDICTION,PEN_CEN_MATCH,FINAL_STATUS_DATE,POST_ACC_IND,GROSS_COMB_VEH_WT, VIOL_TOTAL,OOS_TOTAL,DRIVER_VIOL_TOTAL,DRIVER_OOS_TOTAL,VEHICLE_VIOL_TOTAL,VEHICLE_OOS_TOTAL,SNET_SEQUENCE_ID,TRANSACTION_CODE,TRANSACTION_DATE,UPLOAD_DATE,UPLOAD_FIRST_BYTE,UPLOAD_DOT_NUMBER,UPLOAD_SEARCH_INDICATOR,CENSUS_SEARCH_DATE,MCMIS_ADD_DATE,CHANGE_DATE,SNET_INPUT_DATE,SOURCE_OFFICE FROM carrier_inspections WHERE DOT_NUMBER=3031570 ORDER BY INSPECTION_ID DESC LIMIT 0, 10