Data Quality Report

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

PASS

Total Checks

Passed

Failed

Errors

96.0%

Pass Rate

Status	Severity	Field	Check	Description	Total	Passed	Failed	Rate
PASS	CRITICAL	__table__	row_count	Table should have >= 30000 rows	1	1	0	100.00%
PASS	CRITICAL	code	not_null	code should not be null or empty	48706	48706	0	100.00%
INFO	INFO	code	distinct_count	code: 48706 distinct values	48706	48706	0	100.00%
PASS	CRITICAL	code	text_null	code should not contain text representations of NULL	48706	48706	0	100.00%
FAIL	WARNING	name	not_null	name should not be null or empty	48706	48705	1	100.00%
PASS	CRITICAL	code	length_eq_10	code should have length 10	48706	48706	0	100.00%
PASS	CRITICAL	code	regex	code should match ^\d{10}$	48706	48706	0	100.00%
PASS	WARNING	level	not_null	level should not be null or empty	48706	48706	0	100.00%
PASS	WARNING	name	text_null	name should not contain text representations of NULL	48705	48705	0	100.00%
INFO	INFO	level	distinct_count	level: 4 distinct values	48706	48706	0	100.00%
INFO	INFO	name	distinct_count	name: 27317 distinct values	48705	48705	0	100.00%
PASS	WARNING	level	range	level should be in range [1, 5]	48706	48706	0	100.00%
INFO	INFO	region	null_distribution	region: 0 null (0.0%), 48706 not null (100.0%)	48706	48706	0	100.00%
INFO	INFO	region	distinct_count	region: 27 distinct values	48706	48706	0	100.00%
INFO	INFO	district	null_distribution	district: 27 null (0.1%), 48679 not null (99.9%)	48706	48706	0	100.00%
INFO	INFO	council	null_distribution	council: 771 null (1.6%), 47935 not null (98.4%)	48706	48706	0	100.00%
INFO	INFO	district	distinct_count	district: 738 distinct values	48679	48679	0	100.00%
PASS	INFO	region	text_null	region should not contain text representations of NULL	48706	48706	0	100.00%
INFO	INFO	full_address	null_distribution	full_address: 0 null (0.0%), 48706 not null (100.0%)	48706	48706	0	100.00%
INFO	INFO	council	distinct_count	council: 10216 distinct values	47935	47935	0	100.00%
PASS	INFO	council	text_null	council should not contain text representations of NULL	47935	47935	0	100.00%
PASS	INFO	district	text_null	district should not contain text representations of NULL	48679	48679	0	100.00%
INFO	INFO	parent_code	null_distribution	parent_code: 27 null (0.1%), 48679 not null (99.9%)	48706	48706	0	100.00%
INFO	INFO	parent_code	distinct_count	parent_code: 11686 distinct values	48679	48679	0	100.00%
PASS	INFO	parent_code	text_null	parent_code should not contain text representations of NULL	48679	48679	0	100.00%
INFO	INFO	full_address	distinct_count	full_address: 48650 distinct values	48706	48706	0	100.00%
PASS	INFO	parent_code	length_eq_10	parent_code should have length 10	48679	48679	0	100.00%
PASS	INFO	parent_code	regex	parent_code should match ^\d{10}$	48679	48679	0	100.00%
INFO	INFO	category	null_distribution	category: 12243 null (25.1%), 36463 not null (74.9%)	48706	48706	0	100.00%
PASS	WARNING	category	text_null	category should not contain text representations of NULL	36463	36463	0	100.00%
PASS	WARNING	category	allowed_values	category should be in allowed set	36463	36463	0	100.00%
INFO	INFO	category	distinct_count	category: 5 distinct values	36463	36463	0	100.00%
INFO	INFO	category_name	null_distribution	category_name: 12243 null (25.1%), 36463 not null (74.9%)	48706	48706	0	100.00%
PASS	INFO	category_name	text_null	category_name should not contain text representations of NULL	36463	36463	0	100.00%
INFO	INFO	settlement	null_distribution	settlement: 13632 null (28.0%), 35074 not null (72.0%)	48706	48706	0	100.00%
INFO	INFO	category_name	distinct_count	category_name: 5 distinct values	36463	36463	0	100.00%
PASS	INFO	settlement	text_null	settlement should not contain text representations of NULL	35074	35074	0	100.00%
PASS	INFO	full_address	text_null	full_address should not contain text representations of NULL	48706	48706	0	100.00%
INFO	INFO	lat	null_distribution	lat: 13328 null (27.4%), 35378 not null (72.6%)	48706	48706	0	100.00%
INFO	INFO	settlement	distinct_count	settlement: 16848 distinct values	35074	35074	0	100.00%
INFO	INFO	lat	distinct_count	lat: 21326 distinct values	35378	35378	0	100.00%
PASS	INFO	lat	range	lat should be in range [44.0, 53.0]	35378	35378	0	100.00%
INFO	INFO	lon	null_distribution	lon: 13328 null (27.4%), 35378 not null (72.6%)	48706	48706	0	100.00%
PASS	INFO	lon	range	lon should be in range [22.0, 41.0]	35378	35378	0	100.00%
INFO	INFO	lon	distinct_count	lon: 26023 distinct values	35378	35378	0	100.00%
PASS	CRITICAL	code	unique	Combination [code] should be unique	48706	48706	0	100.00%
PASS	WARNING	level_hierarchy_consistency	custom_sql	Рівень 1 не повинен мати parent_code	48706	48706	0	100.00%
PASS	WARNING	parent_code_exists	custom_sql	parent_code повинен існувати серед code (referential integrity)	48706	48706	0	100.00%

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