DataSentry Data Quality Report

report_schema_version: 1.0 · datasentry_version: 0.1.0 · scan_run_id: scan_3426008c0380 · generated_at: 2026-08-09T12:29:19.607681+00:00 · reproducible: True · llm_used: False

Executive Summary

Overall	94.6
Issues	15
Detector runs	39
Rows / Columns	200 / 7

Quality Score

Overall: 94.6 (score_version 1)

completeness 99.7

validity 96.2

uniqueness 85.5

consistency: n/a

integrity: n/a

timeliness: n/a

dimension = 100 * (1 - sum(weight_issue * severity_norm * affected_ratio) / (n * 1.6)); severity_norm = SEVERITY_WEIGHTS (ADR-003); field criticality = NORMAL default (contract V1); coverage adjust = 1.0 (V1); weights renormalized across scored dimensions

Per-issue deductions (hover the score bar):

completeness / iss_13cb4b2748a9: 0.0045
integrity / iss_460b2a6dcdfc: 0.0035
uniqueness / iss_0ecf36788e2f: 0.4655
uniqueness / iss_38d1503a72bd: 0.0123
uniqueness / iss_4acdab0fa68a: 0.0588
uniqueness / iss_5b135524e462: 0.1470
uniqueness / iss_7e6a695150bd: 0.4778
validity / iss_1b511e197afe: 0.0062
validity / iss_2473ce3e8eb2: 0.0420
validity / iss_2db8aad2eb53: 0.0149
validity / iss_415a97f489bc: 0.0137
validity / iss_929393fa2a85: 0.2000
validity / iss_943fa10b1c0d: 0.0045
validity / iss_cdebe323eecc: 0.1950
validity / iss_e2e5ca64a707: 0.0125

Issue Breakdown

Severity	Priority	Title	Columns	Detectors	Affected
low	81.5	String format issue in email	email	leading_or_trailing_whitespace, repeated_whitespace, invalid_email	11 (0.0550)
medium	76.5	Numeric outlier in total	total	iqr_outlier, percentile_outlier, modified_zscore, tail_probability	5 (0.0250)
medium	73.5	Duplicate values in status	status	uniqueness_violation	195 (0.9750)
medium	73.5	Duplicate values in quantity	quantity	uniqueness_violation	190 (0.9500)
medium	73.5	Duplicate values in total	total	uniqueness_violation	60 (0.3000)
medium	73.5	Duplicate values in event_date	event_date	uniqueness_violation	24 (0.1200)
high	72.4	Datetime anomaly in event_date	event_date	invalid_date, impossible_date	4 (0.0200)
medium	69.0	Numeric outlier in quantity	quantity	modified_zscore	21 (0.1050)
low	69.0	String format issue in customer	customer	leading_or_trailing_whitespace, repeated_whitespace	5 (0.0250)
low	66.5	Categorical anomaly in customer	customer	category_explosion	200 (1.0000)
low	66.5	Categorical anomaly in email	email	category_explosion	195 (0.9750)
medium	66.0	Duplicate values in email	email	uniqueness_violation	5 (0.0250)
low	60.0	Missing values in event_date	event_date	suspicious_missing_token	4 (0.0200)
medium	59.5	Numeric outlier in order_id	order_id	percentile_outlier	2 (0.0100)
low	55.0	Distribution anomaly in order_id	order_id	model_outlier	4 (0.0200)

Critical Findings

[high] Datetime anomaly in event_date — priority 72.4, 4 rows affected
[medium] Numeric outlier in total — priority 76.5, 5 rows affected
[medium] Duplicate values in status — priority 73.5, 195 rows affected
[medium] Duplicate values in quantity — priority 73.5, 190 rows affected
[medium] Duplicate values in total — priority 73.5, 60 rows affected

Dataset Overview

dataset_id	orders
status	completed
rows	200
schema_hash	`64ff9e1cc2c6058dd12b3cf6c83e40af95bd3bb304cb809774cbde6f0dda0151`

Columns:

order_id (BIGINT)
customer (VARCHAR)
email (VARCHAR)
status (VARCHAR)
quantity (BIGINT)
total (DOUBLE)
event_date (VARCHAR)

Methodology

Deterministic SQL pushdown detectors (15 in MVP) run per column; candidates are fused per issue cluster (confidence = 1 - prod(1 - c_i)); each issue receives a priority score (0-100, 12.8 formula); the quality score aggregates per dimension (27.1 formula, ADR-013). No LLM calls in MVP: scores are fully reproducible.

Reproducibility Metadata

datasentry_version: 0.1.0
detector_versions: {'excessive_null_rate': '1.0.0', 'suspicious_missing_token': '1.0.0', 'sudden_missingness': '1.0.0', 'group_missingness': '1.0.0', 'conditional_missingness': '1.0.0', 'correlated_missingness': '1.0.0', 'uniqueness_violation': '1.0.0', 'fuzzy_duplicate': '1.0.0', 'suspicious_placeholder': '1.0.0', 'rare_category': '1.0.0', 'category_explosion': '1.0.0', 'inconsistent_case': '1.0.0', 'leading_or_trailing_whitespace': '1.0.0', 'repeated_whitespace': '1.0.0', 'hidden_control_character': '1.0.0', 'unusual_length': '1.0.0', 'invalid_email': '1.0.0', 'invalid_phone': '1.0.0', 'invalid_url': '1.0.0', 'invalid_ip': '1.0.0', 'iqr_outlier': '1.0.0', 'percentile_outlier': '1.0.0', 'modified_zscore': '1.0.0', 'tail_probability': '1.0.0', 'histogram_rarity': '1.0.0', 'suspicious_formula_injection': '1.0.0', 'cross_field_rule': '1.0.0', 'invalid_date': '1.0.0', 'impossible_date': '1.0.0', 'future_date': '1.0.0', 'stale_date': '1.0.0', 'mixed_date_format': '1.0.0', 'duplicate_timestamp': '1.0.0', 'spelling_variant': '1.0.0', 'fullwidth_character': '1.0.0', 'mojibake_character': '1.0.0', 'invalid_numeric': '1.0.0', 'foreign_key_violation': '1.0.0', 'model_outlier': '1.0.0'}
seed: 42
scanned_at: 2026-08-09T12:29:19.607684Z