Data Quality Report

Dataset: nessie.mvs.reestrtz | Branch: main | Period: All data | 2026-03-20T18:46:26.612958

PASS

Total Checks

Passed

Failed

Errors

84.2%

Pass Rate

Status	Severity	Field	Check	Description	Total	Passed	Failed	Rate
PASS	CRITICAL	__table__	row_count	Table should have >= 23000000 rows	1	1	0	100.00%
PASS	CRITICAL	record_id	not_null	record_id should not be null or empty	29474034	29474034	0	100.00%
PASS	WARNING	person	not_null	person should not be null or empty	29474034	29474034	0	100.00%
PASS	WARNING	person	text_null	person should not contain text representations of NULL	29474034	29474034	0	100.00%
PASS	WARNING	person	allowed_values	person should be in allowed set	29474034	29474034	0	100.00%
INFO	INFO	reg_addr_koatuu	null_distribution	reg_addr_koatuu: 611477 null (2.1%), 28862557 not null (97.9%)	29474034	29474034	0	100.00%
INFO	INFO	oper_code	null_distribution	oper_code: 78 null (0.0%), 29473956 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	reg_addr_koatuu	distinct_count	reg_addr_koatuu: 28700 distinct values	28862557	28862557	0	100.00%
INFO	INFO	oper_code	distinct_count	oper_code: 184 distinct values	29473956	29473956	0	100.00%
PASS	INFO	reg_addr_koatuu	text_null	reg_addr_koatuu should not contain text representations of NULL	28862557	28862557	0	100.00%
INFO	INFO	oper_name	null_distribution	oper_name: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	oper_car_condition	null_distribution	oper_car_condition: 9374391 null (31.8%), 20099643 not null (68.2%)	29474034	29474034	0	100.00%
INFO	INFO	oper_name	distinct_count	oper_name: 180 distinct values	29473515	29473515	0	100.00%
PASS	CRITICAL	record_id	text_null	record_id should not contain text representations of NULL	29474034	29474034	0	100.00%
PASS	INFO	oper_car_condition	text_null	oper_car_condition should not contain text representations of NULL	20099643	20099643	0	100.00%
PASS	INFO	oper_car_condition	allowed_values	oper_car_condition should be in allowed set	20099643	20099643	0	100.00%
INFO	INFO	short_oper_name	null_distribution	short_oper_name: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	short_oper_name	distinct_count	short_oper_name: 5 distinct values	29473515	29473515	0	100.00%
INFO	INFO	oper_description	null_distribution	oper_description: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	oper_notes	null_distribution	oper_notes: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	owner_change	null_distribution	owner_change: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
PASS	INFO	short_oper_name	text_null	short_oper_name should not contain text representations of NULL	29473515	29473515	0	100.00%
INFO	INFO	is_aid	null_distribution	is_aid: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	is_import	null_distribution	is_import: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	modification_type	null_distribution	modification_type: 27679638 null (93.9%), 1794396 not null (6.1%)	29474034	29474034	0	100.00%
INFO	INFO	is_credit_leasing	null_distribution	is_credit_leasing: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
PASS	INFO	modification_type	allowed_values	modification_type should be in allowed set	1794396	1794396	0	100.00%
PASS	INFO	modification_type	text_null	modification_type should not contain text representations of NULL	1794396	1794396	0	100.00%
PASS	INFO	oper_name	text_null	oper_name should not contain text representations of NULL	29473515	29473515	0	100.00%
INFO	INFO	document_basis	null_distribution	document_basis: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	entity_type	null_distribution	entity_type: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
PASS	INFO	entity_type	allowed_values	entity_type should be in allowed set	29473515	29473515	0	100.00%
PASS	INFO	document_basis	text_null	document_basis should not contain text representations of NULL	29473515	29473515	0	100.00%
PASS	INFO	entity_type	text_null	entity_type should not contain text representations of NULL	29473515	29473515	0	100.00%
INFO	INFO	is_stolen_related	null_distribution	is_stolen_related: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	is_digital	null_distribution	is_digital: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	is_wartime	null_distribution	is_wartime: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	is_insurer	null_distribution	is_insurer: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	is_social	null_distribution	is_social: 519 null (0.0%), 29473515 not null (100.0%)	29474034	29474034	0	100.00%
PASS	WARNING	d_reg	not_null	d_reg should not be null or empty	29474034	29474034	0	100.00%
INFO	INFO	d_reg	distinct_count	d_reg: 4597 distinct values	29474034	29474034	0	100.00%
PASS	INFO	oper_description	text_null	oper_description should not contain text representations of NULL	29473515	29473515	0	100.00%
PASS	WARNING	dep_code	not_null	dep_code should not be null or empty	29474034	29474034	0	100.00%
PASS	WARNING	d_reg	date_range	d_reg should be between 2010-01-01 and today	29474034	29474034	0	100.00%
PASS	WARNING	dep_code	text_null	dep_code should not contain text representations of NULL	29474034	29474034	0	100.00%
INFO	INFO	dep	null_distribution	dep: 18515686 null (62.8%), 10958348 not null (37.2%)	29474034	29474034	0	100.00%
PASS	WARNING	dep_code	regex	dep_code should match ^\d+$	29474034	29474034	0	100.00%
INFO	INFO	dep_code	distinct_count	dep_code: 664 distinct values	29474034	29474034	0	100.00%
INFO	INFO	dep	distinct_count	dep: 166 distinct values	10958348	10958348	0	100.00%
INFO	INFO	dep_region	null_distribution	dep_region: 18515686 null (62.8%), 10958348 not null (37.2%)	29474034	29474034	0	100.00%
PASS	INFO	dep	text_null	dep should not contain text representations of NULL	10958348	10958348	0	100.00%
INFO	INFO	dep_city	null_distribution	dep_city: 20370608 null (69.1%), 9103426 not null (30.9%)	29474034	29474034	0	100.00%
INFO	INFO	dep_region	distinct_count	dep_region: 25 distinct values	10958348	10958348	0	100.00%
PASS	INFO	dep_region	text_null	dep_region should not contain text representations of NULL	10958348	10958348	0	100.00%
PASS	INFO	oper_notes	text_null	oper_notes should not contain text representations of NULL	29473515	29473515	0	100.00%
INFO	INFO	dep_city	distinct_count	dep_city: 137 distinct values	9103426	9103426	0	100.00%
INFO	INFO	dep_address	null_distribution	dep_address: 20370608 null (69.1%), 9103426 not null (30.9%)	29474034	29474034	0	100.00%
INFO	INFO	dep_address_number	null_distribution	dep_address_number: 20443028 null (69.4%), 9031006 not null (30.6%)	29474034	29474034	0	100.00%
PASS	INFO	dep_city	text_null	dep_city should not contain text representations of NULL	9103426	9103426	0	100.00%
INFO	INFO	dep_description	null_distribution	dep_description: 29054528 null (98.6%), 419506 not null (1.4%)	29474034	29474034	0	100.00%
PASS	INFO	dep_description	text_null	dep_description should not contain text representations of NULL	419506	419506	0	100.00%
PASS	INFO	dep_address_number	text_null	dep_address_number should not contain text representations of NULL	9031006	9031006	0	100.00%
INFO	INFO	dep_hours_of_work	null_distribution	dep_hours_of_work: 20370608 null (69.1%), 9103426 not null (30.9%)	29474034	29474034	0	100.00%
PASS	INFO	dep_address	text_null	dep_address should not contain text representations of NULL	9103426	9103426	0	100.00%
INFO	INFO	dep_phones	null_distribution	dep_phones: 21041450 null (71.4%), 8432584 not null (28.6%)	29474034	29474034	0	100.00%
PASS	INFO	dep_phones	text_null	dep_phones should not contain text representations of NULL	8432584	8432584	0	100.00%
INFO	INFO	brand	null_distribution	brand: 2270 null (0.0%), 29471764 not null (100.0%)	29474034	29474034	0	100.00%
PASS	INFO	dep_hours_of_work	text_null	dep_hours_of_work should not contain text representations of NULL	9103426	9103426	0	100.00%
INFO	INFO	brand	distinct_count	brand: 4265 distinct values	29471764	29471764	0	100.00%
FAIL	WARNING	brand	text_null	brand should not contain text representations of NULL	29471764	29471763	1	100.00%
INFO	INFO	model	null_distribution	model: 8344 null (0.0%), 29465690 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	model	distinct_count	model: 34960 distinct values	29465690	29465690	0	100.00%
INFO	INFO	model_suffix	null_distribution	model_suffix: 22864194 null (77.6%), 6609840 not null (22.4%)	29474034	29474034	0	100.00%
PASS	WARNING	model	text_null	model should not contain text representations of NULL	29465690	29465690	0	100.00%
FAIL	INFO	generation	array_empty	generation should not contain empty arrays	21506163	20152878	1353285	93.71%
FAIL	INFO	model_suffix	text_null	model_suffix should not contain text representations of NULL	6609840	6609544	296	100.00%
INFO	INFO	model_suffix	distinct_count	model_suffix: 9457 distinct values	6609840	6609840	0	100.00%
PASS	WARNING	make_year	range	make_year should be in range [1900, 2027]	29474034	29474034	0	100.00%
INFO	INFO	make_year	distinct_count	make_year: 108 distinct values	29474034	29474034	0	100.00%
PASS	WARNING	make_year	not_null	make_year should not be null or empty	29474034	29474034	0	100.00%
INFO	INFO	model_year	distinct_count	model_year: 60 distinct values	17852145	17852145	0	100.00%
INFO	INFO	model_year	null_distribution	model_year: 11621889 null (39.4%), 17852145 not null (60.6%)	29474034	29474034	0	100.00%
FAIL	INFO	model_year	range	model_year should be in range [1980, 2027]	17852145	17688091	164054	99.08%
INFO	INFO	generation	array_length	generation: avg array len=2.4, min=0, max=12	21506163	21506163	0	100.00%
INFO	INFO	vin_year_code	distinct_count	vin_year_code: 35 distinct values	20744443	20744443	0	100.00%
INFO	INFO	vin_year_code	null_distribution	vin_year_code: 8729591 null (29.6%), 20744443 not null (70.4%)	29474034	29474034	0	100.00%
PASS	INFO	vin_year_code	text_null	vin_year_code should not contain text representations of NULL	20744443	20744443	0	100.00%
PASS	WARNING	color	not_null	color should not be null or empty	29474034	29474034	0	100.00%
INFO	INFO	color	distinct_count	color: 14 distinct values	29474034	29474034	0	100.00%
PASS	WARNING	kind	not_null	kind should not be null or empty	29474034	29474034	0	100.00%
PASS	WARNING	color	text_null	color should not contain text representations of NULL	29474034	29474034	0	100.00%
INFO	INFO	body	null_distribution	body: 12 null (0.0%), 29474022 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	kind	distinct_count	kind: 14 distinct values	29474034	29474034	0	100.00%
INFO	INFO	body	distinct_count	body: 75 distinct values	29474022	29474022	0	100.00%
PASS	WARNING	kind	text_null	kind should not contain text representations of NULL	29474034	29474034	0	100.00%
PASS	INFO	body	text_null	body should not contain text representations of NULL	29474022	29474022	0	100.00%
INFO	INFO	possible_body_types	array_length	possible_body_types: avg array len=1.7, min=1, max=6	21506163	21506163	0	100.00%
INFO	INFO	body_subtype	null_distribution	body_subtype: 27828278 null (94.4%), 1645756 not null (5.6%)	29474034	29474034	0	100.00%
PASS	INFO	possible_body_types	array_empty	possible_body_types should not contain empty arrays	21506163	21506163	0	100.00%
PASS	INFO	body_subtype	text_null	body_subtype should not contain text representations of NULL	1645756	1645756	0	100.00%
INFO	INFO	body_modifiers	null_distribution	body_modifiers: 28439064 null (96.5%), 1034970 not null (3.5%)	29474034	29474034	0	100.00%
INFO	INFO	body_subtype	distinct_count	body_subtype: 36 distinct values	1645756	1645756	0	100.00%
INFO	INFO	vehicle_class	null_distribution	vehicle_class: 12630661 null (42.9%), 16843373 not null (57.1%)	29474034	29474034	0	100.00%
PASS	INFO	body_modifiers	text_null	body_modifiers should not contain text representations of NULL	1034970	1034970	0	100.00%
INFO	INFO	body_modifiers	distinct_count	body_modifiers: 12 distinct values	1034970	1034970	0	100.00%
INFO	INFO	vehicle_class	distinct_count	vehicle_class: 18 distinct values	16843373	16843373	0	100.00%
PASS	INFO	vehicle_class	text_null	vehicle_class should not contain text representations of NULL	16843373	16843373	0	100.00%
INFO	INFO	trailer_prefix	null_distribution	trailer_prefix: 28045611 null (95.2%), 1428423 not null (4.8%)	29474034	29474034	0	100.00%
INFO	INFO	trailer_prefix	distinct_count	trailer_prefix: 2 distinct values	1428423	1428423	0	100.00%
PASS	INFO	trailer_prefix	text_null	trailer_prefix should not contain text representations of NULL	1428423	1428423	0	100.00%
PASS	WARNING	purpose	not_null	purpose should not be null or empty	29474034	29474034	0	100.00%
INFO	INFO	fuel	null_distribution	fuel: 1438664 null (4.9%), 28035370 not null (95.1%)	29474034	29474034	0	100.00%
INFO	INFO	purpose	distinct_count	purpose: 3 distinct values	29474034	29474034	0	100.00%
INFO	INFO	fuel	distinct_count	fuel: 4 distinct values	28035370	28035370	0	100.00%
PASS	WARNING	purpose	text_null	purpose should not contain text representations of NULL	29474034	29474034	0	100.00%
PASS	INFO	fuel	text_null	fuel should not contain text representations of NULL	28035370	28035370	0	100.00%
INFO	INFO	secondary_fuel	null_distribution	secondary_fuel: 23312772 null (79.1%), 6161262 not null (20.9%)	29474034	29474034	0	100.00%
PASS	INFO	generation	text_null_array	generation array should not contain text representations of NULL	21506163	21506163	0	100.00%
PASS	INFO	secondary_fuel	text_null	secondary_fuel should not contain text representations of NULL	6161262	6161262	0	100.00%
INFO	INFO	is_gbo	null_distribution	is_gbo: 1430776 null (4.9%), 28043258 not null (95.1%)	29474034	29474034	0	100.00%
INFO	INFO	secondary_fuel	distinct_count	secondary_fuel: 3 distinct values	6161262	6161262	0	100.00%
PASS	INFO	is_gbo	range	is_gbo should be in range [0, 1]	28043258	28043258	0	100.00%
PASS	INFO	is_hybrid	range	is_hybrid should be in range [0, 1]	28043258	28043258	0	100.00%
INFO	INFO	fuel_notes	null_distribution	fuel_notes: 22777605 null (77.3%), 6696429 not null (22.7%)	29474034	29474034	0	100.00%
INFO	INFO	is_hybrid	null_distribution	is_hybrid: 1430776 null (4.9%), 28043258 not null (95.1%)	29474034	29474034	0	100.00%
INFO	INFO	fuel_notes	distinct_count	fuel_notes: 4 distinct values	6696429	6696429	0	100.00%
PASS	INFO	fuel_notes	text_null	fuel_notes should not contain text representations of NULL	6696429	6696429	0	100.00%
INFO	INFO	capacity	null_distribution	capacity: 1436626 null (4.9%), 28037408 not null (95.1%)	29474034	29474034	0	100.00%
INFO	INFO	possible_fuels	array_length	possible_fuels: avg array len=2.0, min=1, max=6	21506163	21506163	0	100.00%
PASS	INFO	possible_fuels	array_empty	possible_fuels should not contain empty arrays	21506163	21506163	0	100.00%
INFO	INFO	capacity	distinct_count	capacity: 6034 distinct values	28037408	28037408	0	100.00%
FAIL	INFO	capacity	range	capacity should be in range [0, 20000]	28037408	28037035	373	100.00%
FAIL	INFO	possible_displacements	array_empty	possible_displacements should not contain empty arrays	21506163	21028281	477882	97.78%
INFO	INFO	own_weight	null_distribution	own_weight: 90402 null (0.3%), 29383632 not null (99.7%)	29474034	29474034	0	100.00%
INFO	INFO	possible_displacements	array_length	possible_displacements: avg array len=4.7, min=0, max=20	21506163	21506163	0	100.00%
PASS	INFO	possible_displacements	array_range	possible_displacements array elements should be in range [0, 20000]	101060756	101060756	0	100.00%
INFO	INFO	own_weight	distinct_count	own_weight: 14134 distinct values	29383632	29383632	0	100.00%
FAIL	INFO	own_weight	range	own_weight should be in range [40, 45000]	29383632	29355344	28288	99.90%
INFO	INFO	total_weight	null_distribution	total_weight: 13415 null (0.0%), 29460619 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	total_weight	distinct_count	total_weight: 9613 distinct values	29460619	29460619	0	100.00%
FAIL	INFO	total_weight	range	total_weight should be in range [60, 90000]	29460619	29456360	4259	99.99%
INFO	INFO	payload	null_distribution	payload: 92590 null (0.3%), 29381444 not null (99.7%)	29474034	29474034	0	100.00%
INFO	INFO	payload	distinct_count	payload: 24745 distinct values	29381444	29381444	0	100.00%
PASS	INFO	possible_body_types	text_null_array	possible_body_types array should not contain text representations of NULL	21506163	21506163	0	100.00%
FAIL	INFO	payload	range	payload should be in range [0, 35000]	29381444	29354338	27106	99.91%
INFO	INFO	n_reg_new_cyrillic	null_distribution	n_reg_new_cyrillic: 106240 null (0.4%), 29367794 not null (99.6%)	29474034	29474034	0	100.00%
INFO	INFO	n_reg_latin	null_distribution	n_reg_latin: 111075 null (0.4%), 29362959 not null (99.6%)	29474034	29474034	0	100.00%
PASS	INFO	n_reg_new_cyrillic	text_null	n_reg_new_cyrillic should not contain text representations of NULL	29367794	29367794	0	100.00%
PASS	INFO	n_reg_latin	text_null	n_reg_latin should not contain text representations of NULL	29362959	29362959	0	100.00%
INFO	INFO	n_reg_new_cyrillic	distinct_count	n_reg_new_cyrillic: 16652309 distinct values	29367794	29367794	0	100.00%
INFO	INFO	has_old_cyrillic	null_distribution	has_old_cyrillic: 0 null (0.0%), 29474034 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	has_old_cyrillic	distinct_count	has_old_cyrillic: 2 distinct values	29474034	29474034	0	100.00%
INFO	INFO	n_reg_latin	distinct_count	n_reg_latin: 16561896 distinct values	29362959	29362959	0	100.00%
PASS	INFO	plate_type	not_null	plate_type should not be null or empty	29474034	29474034	0	100.00%
PASS	INFO	plate_type	allowed_values	plate_type should be in allowed set	29474034	29474034	0	100.00%
INFO	INFO	region_code	null_distribution	region_code: 2152654 null (7.3%), 27321380 not null (92.7%)	29474034	29474034	0	100.00%
PASS	INFO	plate_type	text_null	plate_type should not contain text representations of NULL	29474034	29474034	0	100.00%
INFO	INFO	plate_type	distinct_count	plate_type: 6 distinct values	29474034	29474034	0	100.00%
PASS	INFO	is_valid_plate	not_null	is_valid_plate should not be null or empty	29474034	29474034	0	100.00%
INFO	INFO	region_code	distinct_count	region_code: 167 distinct values	27321380	27321380	0	100.00%
INFO	INFO	validation_error	null_distribution	validation_error: 27326209 null (92.7%), 2147825 not null (7.3%)	29474034	29474034	0	100.00%
PASS	INFO	region_code	text_null	region_code should not contain text representations of NULL	27321380	27321380	0	100.00%
PASS	INFO	validation_error	text_null	validation_error should not contain text representations of NULL	2147825	2147825	0	100.00%
INFO	INFO	validation_error	distinct_count	validation_error: 1 distinct values	2147825	2147825	0	100.00%
INFO	INFO	region_name	null_distribution	region_name: 2237436 null (7.6%), 27236598 not null (92.4%)	29474034	29474034	0	100.00%
INFO	INFO	needs_moderation	null_distribution	needs_moderation: 0 null (0.0%), 29474034 not null (100.0%)	29474034	29474034	0	100.00%
INFO	INFO	region_name	distinct_count	region_name: 29 distinct values	27236598	27236598	0	100.00%
PASS	INFO	possible_fuels	text_null_array	possible_fuels array should not contain text representations of NULL	21506163	21506163	0	100.00%
INFO	INFO	raw_vin	null_distribution	raw_vin: 8527565 null (28.9%), 20946469 not null (71.1%)	29474034	29474034	0	100.00%
INFO	INFO	vin	null_distribution	vin: 8527566 null (28.9%), 20946468 not null (71.1%)	29474034	29474034	0	100.00%
PASS	INFO	region_name	text_null	region_name should not contain text representations of NULL	27236598	27236598	0	100.00%
PASS	INFO	raw_vin	text_null	raw_vin should not contain text representations of NULL	20946469	20946469	0	100.00%
INFO	INFO	raw_vin	distinct_count	raw_vin: 9108307 distinct values	20946469	20946469	0	100.00%
INFO	INFO	is_valid_vin	null_distribution	is_valid_vin: 8527176 null (28.9%), 20946858 not null (71.1%)	29474034	29474034	0	100.00%
PASS	INFO	vin_validation_error	text_null	vin_validation_error should not contain text representations of NULL	220472	220472	0	100.00%
INFO	INFO	vin_validation_error	null_distribution	vin_validation_error: 29253562 null (99.3%), 220472 not null (0.7%)	29474034	29474034	0	100.00%
PASS	INFO	vin	text_null	vin should not contain text representations of NULL	20946468	20946468	0	100.00%
INFO	INFO	vin_validation_error	distinct_count	vin_validation_error: 4 distinct values	220472	220472	0	100.00%
INFO	INFO	vin	distinct_count	vin: 9107336 distinct values	20946468	20946468	0	100.00%
INFO	INFO	vin_length	distinct_count	vin_length: 27 distinct values	20946469	20946469	0	100.00%
INFO	INFO	vin_length	null_distribution	vin_length: 8527565 null (28.9%), 20946469 not null (71.1%)	29474034	29474034	0	100.00%
INFO	INFO	vin_is_17	null_distribution	vin_is_17: 8527176 null (28.9%), 20946858 not null (71.1%)	29474034	29474034	0	100.00%
INFO	INFO	vin_has_ioq	null_distribution	vin_has_ioq: 8527176 null (28.9%), 20946858 not null (71.1%)	29474034	29474034	0	100.00%
INFO	INFO	vin_wmi	null_distribution	vin_wmi: 8729591 null (29.6%), 20744443 not null (70.4%)	29474034	29474034	0	100.00%
INFO	INFO	vin_wmi	distinct_count	vin_wmi: 9314 distinct values	20744443	20744443	0	100.00%
INFO	INFO	vin_wmi_manufacturer	null_distribution	vin_wmi_manufacturer: 9352836 null (31.7%), 20121198 not null (68.3%)	29474034	29474034	0	100.00%
PASS	INFO	vin_wmi	text_null	vin_wmi should not contain text representations of NULL	20744443	20744443	0	100.00%
INFO	INFO	vin_wmi_manufacturer	distinct_count	vin_wmi_manufacturer: 1692 distinct values	20121198	20121198	0	100.00%
INFO	INFO	vin_wmi_region	null_distribution	vin_wmi_region: 8749176 null (29.7%), 20724858 not null (70.3%)	29474034	29474034	0	100.00%
INFO	INFO	vin_wmi_region	distinct_count	vin_wmi_region: 6 distinct values	20724858	20724858	0	100.00%
INFO	INFO	vin_wmi_known	null_distribution	vin_wmi_known: 8729202 null (29.6%), 20744832 not null (70.4%)	29474034	29474034	0	100.00%
PASS	INFO	vin_wmi_region	text_null	vin_wmi_region should not contain text representations of NULL	20724858	20724858	0	100.00%
INFO	INFO	possible_transmissions	array_length	possible_transmissions: avg array len=1.7, min=0, max=2	21506163	21506163	0	100.00%
PASS	INFO	vin_wmi_manufacturer	text_null	vin_wmi_manufacturer should not contain text representations of NULL	20121198	20121198	0	100.00%
INFO	INFO	possible_drives	array_length	possible_drives: avg array len=1.4, min=0, max=3	21506163	21506163	0	100.00%
FAIL	INFO	possible_transmissions	array_empty	possible_transmissions should not contain empty arrays	21506163	21288916	217247	98.99%
INFO	INFO	backfill_confidence	null_distribution	backfill_confidence: 20359566 null (69.1%), 9114468 not null (30.9%)	29474034	29474034	0	100.00%
FAIL	INFO	possible_drives	array_empty	possible_drives should not contain empty arrays	21506163	21384089	122074	99.43%
PASS	INFO	backfill_confidence	text_null	backfill_confidence should not contain text representations of NULL	9114468	9114468	0	100.00%
INFO	INFO	backfill_stage	null_distribution	backfill_stage: 20359566 null (69.1%), 9114468 not null (30.9%)	29474034	29474034	0	100.00%
PASS	INFO	backfill_stage	allowed_values	backfill_stage should be in allowed set	9114468	9114468	0	100.00%
PASS	INFO	backfill_confidence	allowed_values	backfill_confidence should be in allowed set	9114468	9114468	0	100.00%
PASS	INFO	backfill_stage	text_null	backfill_stage should not contain text representations of NULL	9114468	9114468	0	100.00%
FAIL	WARNING	own_weight_lt_total_weight	custom_sql	own_weight має бути менший за total_weight	29381444	29381333	111	100.00%
FAIL	WARNING	weight_ratio_too_high	custom_sql	total_weight / own_weight не має перевищувати 4	29355044	28536183	818861	97.21%
FAIL	INFO	vin_null_before_2021	custom_sql	VIN має бути NULL для реєстрацій до 2021-01-01	17641644	8527176	9114468	48.34%
FAIL	INFO	make_year_vs_model_year	custom_sql	model_year (з VIN) не має відрізнятись від make_year більш ніж на 2 роки	17852145	14839579	3012566	83.12%
PASS	WARNING	future_make_year	custom_sql	Автомобілі з майбутнього (make_year > поточний рік + 1)	29474034	29474034	0	100.00%
PASS	WARNING	negative_weight	custom_sql	Від'ємна вага (own_weight або total_weight < 0)	29462807	29462807	0	100.00%
PASS	INFO	possible_drives	text_null_array	possible_drives array should not contain text representations of NULL	21506163	21506163	0	100.00%
PASS	INFO	possible_transmissions	text_null_array	possible_transmissions array should not contain text representations of NULL	21506163	21506163	0	100.00%

Generated by AUTOMOTO DQ Platform | 2026-03-20T18:46:26.612958