Data Quality Report

Dataset: s3.raw.mvs."administrative_codes"."katottg.parquet" | Period: All data | 2026-03-19T21:23:48.287956

FAIL

Total Checks

Passed

Failed

Errors

96.2%

Pass Rate

Critical Failures

unique on code: 581/31993 failed

Status	Severity	Field	Check	Description	Total	Passed	Failed	Rate
PASS	CRITICAL	code	length_eq_19	code should have length 19	31993	31993	0	100.00%
PASS	CRITICAL	code	not_null	code should not be null or empty	31993	31993	0	100.00%
INFO	INFO	code	distinct_count	code: 31412 distinct values	31993	31993	0	100.00%
PASS	CRITICAL	code	text_null	code should not contain text representations of NULL	31993	31993	0	100.00%
PASS	WARNING	name	not_null	name should not be null or empty	31993	31993	0	100.00%
PASS	CRITICAL	__table__	row_count	Table should have >= 30000 rows	1	1	0	100.00%
PASS	CRITICAL	code	regex	code should match ^UA\d{17}$	31993	31993	0	100.00%
PASS	WARNING	level	not_null	level should not be null or empty	31993	31993	0	100.00%
PASS	WARNING	name	text_null	name should not contain text representations of NULL	31993	31993	0	100.00%
INFO	INFO	name	distinct_count	name: 19576 distinct values	31993	31993	0	100.00%
PASS	WARNING	level	range	level should be in range [1, 5]	31993	31993	0	100.00%
INFO	INFO	level	distinct_count	level: 4 distinct values	31993	31993	0	100.00%
INFO	INFO	region	null_distribution	region: 0 null (0.0%), 31993 not null (100.0%)	31993	31993	0	100.00%
INFO	INFO	region	distinct_count	region: 27 distinct values	31993	31993	0	100.00%
PASS	INFO	region	text_null	region should not contain text representations of NULL	31993	31993	0	100.00%
INFO	INFO	district	null_distribution	district: 1609 null (5.0%), 30384 not null (95.0%)	31993	31993	0	100.00%
PASS	INFO	district	text_null	district should not contain text representations of NULL	30384	30384	0	100.00%
INFO	INFO	council	null_distribution	council: 1908 null (6.0%), 30085 not null (94.0%)	31993	31993	0	100.00%
INFO	INFO	district	distinct_count	district: 127 distinct values	30384	30384	0	100.00%
INFO	INFO	council	distinct_count	council: 1487 distinct values	30085	30085	0	100.00%
PASS	INFO	council	text_null	council should not contain text representations of NULL	30085	30085	0	100.00%
INFO	INFO	full_address	null_distribution	full_address: 0 null (0.0%), 31993 not null (100.0%)	31993	31993	0	100.00%
INFO	INFO	parent_code	null_distribution	parent_code: 1863 null (5.8%), 30130 not null (94.2%)	31993	31993	0	100.00%
INFO	INFO	full_address	distinct_count	full_address: 31481 distinct values	31993	31993	0	100.00%
PASS	INFO	parent_code	text_null	parent_code should not contain text representations of NULL	30130	30130	0	100.00%
INFO	INFO	parent_code	distinct_count	parent_code: 1680 distinct values	30130	30130	0	100.00%
PASS	INFO	parent_code	length_eq_19	parent_code should have length 19	30130	30130	0	100.00%
PASS	INFO	parent_code	regex	parent_code should match ^UA\d{17}$	30130	30130	0	100.00%
PASS	INFO	full_address	text_null	full_address should not contain text representations of NULL	31993	31993	0	100.00%
INFO	INFO	category	null_distribution	category: 6538 null (20.4%), 25455 not null (79.6%)	31993	31993	0	100.00%
PASS	WARNING	category	text_null	category should not contain text representations of NULL	25455	25455	0	100.00%
PASS	WARNING	category	allowed_values	category should be in allowed set	25455	25455	0	100.00%
INFO	INFO	category	distinct_count	category: 5 distinct values	25455	25455	0	100.00%
INFO	INFO	category_name	null_distribution	category_name: 6538 null (20.4%), 25455 not null (79.6%)	31993	31993	0	100.00%
PASS	INFO	category_name	text_null	category_name should not contain text representations of NULL	25455	25455	0	100.00%
INFO	INFO	category_name	distinct_count	category_name: 5 distinct values	25455	25455	0	100.00%
INFO	INFO	settlement	null_distribution	settlement: 1819 null (5.7%), 30174 not null (94.3%)	31993	31993	0	100.00%
PASS	INFO	settlement	text_null	settlement should not contain text representations of NULL	30174	30174	0	100.00%
INFO	INFO	settlement	distinct_count	settlement: 17820 distinct values	30174	30174	0	100.00%
INFO	INFO	koatuu	null_distribution	koatuu: 2452 null (7.7%), 29541 not null (92.3%)	31993	31993	0	100.00%
PASS	INFO	koatuu	text_null	koatuu should not contain text representations of NULL	29541	29541	0	100.00%
INFO	INFO	lat	null_distribution	lat: 0 null (0.0%), 31993 not null (100.0%)	31993	31993	0	100.00%
INFO	INFO	koatuu	distinct_count	koatuu: 29092 distinct values	29541	29541	0	100.00%
PASS	INFO	lat	range	lat should be in range [44.0, 53.0]	31993	31993	0	100.00%
INFO	INFO	lat	distinct_count	lat: 21366 distinct values	31993	31993	0	100.00%
INFO	INFO	lon	null_distribution	lon: 0 null (0.0%), 31993 not null (100.0%)	31993	31993	0	100.00%
PASS	INFO	lon	range	lon should be in range [22.0, 41.0]	31993	31993	0	100.00%
INFO	INFO	lon	distinct_count	lon: 26557 distinct values	31993	31993	0	100.00%
FAIL	CRITICAL	code	unique	Combination [code] should be unique	31993	31412	581	98.18%
PASS	WARNING	level_hierarchy_consistency	custom_sql	Рівень 1 не повинен мати parent_code	31993	31993	0	100.00%
PASS	WARNING	parent_code_exists	custom_sql	parent_code повинен існувати серед code (referential integrity)	31993	31993	0	100.00%

Generated by AUTOMOTO DQ Platform | 2026-03-19T21:23:48.287956