| PASS |
WARNING |
person |
not_null |
person should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
CRITICAL |
record_id |
not_null |
record_id should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
CRITICAL |
__table__ |
row_count |
Table should have >= 23000000 rows |
1 |
1 |
0 |
100.00% |
|
| PASS |
WARNING |
person |
text_null |
person should not contain text representations of NULL |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
person |
allowed_values |
person should be in allowed set |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
reg_addr_koatuu |
null_distribution |
reg_addr_koatuu: 1261247 null (5.0%), 23774414 not null (95.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
CRITICAL |
record_id |
text_null |
record_id should not contain text representations of NULL |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
reg_addr_koatuu |
distinct_count |
reg_addr_koatuu: 28715 distinct values |
23774414 |
23774414 |
0 |
100.00% |
|
| INFO |
INFO |
oper_code |
null_distribution |
oper_code: 78 null (0.0%), 25035583 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
oper_code |
distinct_count |
oper_code: 188 distinct values |
25035583 |
25035583 |
0 |
100.00% |
|
| PASS |
INFO |
reg_addr_koatuu |
text_null |
reg_addr_koatuu should not contain text representations of NULL |
23774414 |
23774414 |
0 |
100.00% |
|
| INFO |
INFO |
oper_car_condition |
null_distribution |
oper_car_condition: 7107738 null (28.4%), 17927923 not null (71.6%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
oper_car_condition |
text_null |
oper_car_condition should not contain text representations of NULL |
17927923 |
17927923 |
0 |
100.00% |
|
| INFO |
INFO |
oper_name |
null_distribution |
oper_name: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
oper_car_condition |
allowed_values |
oper_car_condition should be in allowed set |
17927923 |
17927923 |
0 |
100.00% |
|
| INFO |
INFO |
oper_name |
distinct_count |
oper_name: 184 distinct values |
25034284 |
25034284 |
0 |
100.00% |
|
| INFO |
INFO |
short_oper_name |
null_distribution |
short_oper_name: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
short_oper_name |
distinct_count |
short_oper_name: 5 distinct values |
25034284 |
25034284 |
0 |
100.00% |
|
| PASS |
INFO |
short_oper_name |
text_null |
short_oper_name should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| INFO |
INFO |
oper_description |
null_distribution |
oper_description: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
oper_description |
text_null |
oper_description should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| INFO |
INFO |
oper_notes |
null_distribution |
oper_notes: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
owner_change |
null_distribution |
owner_change: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
oper_notes |
text_null |
oper_notes should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| INFO |
INFO |
is_import |
null_distribution |
is_import: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_aid |
null_distribution |
is_aid: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_credit_leasing |
null_distribution |
is_credit_leasing: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
modification_type |
null_distribution |
modification_type: 23669165 null (94.5%), 1366496 not null (5.5%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
modification_type |
allowed_values |
modification_type should be in allowed set |
1366496 |
1366496 |
0 |
100.00% |
|
| PASS |
INFO |
modification_type |
text_null |
modification_type should not contain text representations of NULL |
1366496 |
1366496 |
0 |
100.00% |
|
| PASS |
INFO |
oper_name |
text_null |
oper_name should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| FAIL |
INFO |
entity_type |
allowed_values |
entity_type should be in allowed set |
25034284 |
25034235 |
49 |
100.00% |
|
| INFO |
INFO |
is_wartime |
null_distribution |
is_wartime: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
document_basis |
null_distribution |
document_basis: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_digital |
null_distribution |
is_digital: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_stolen_related |
null_distribution |
is_stolen_related: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
entity_type |
null_distribution |
entity_type: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_insurer |
null_distribution |
is_insurer: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
document_basis |
text_null |
document_basis should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| INFO |
INFO |
is_social |
null_distribution |
is_social: 1377 null (0.0%), 25034284 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
d_reg |
not_null |
d_reg should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
entity_type |
text_null |
entity_type should not contain text representations of NULL |
25034284 |
25034284 |
0 |
100.00% |
|
| FAIL |
WARNING |
dep_code |
not_null |
dep_code should not be null or empty |
25035661 |
25035560 |
101 |
100.00% |
|
| INFO |
INFO |
d_reg |
distinct_count |
d_reg: 4781 distinct values |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
d_reg |
date_range |
d_reg should be between 2010-01-01 and today |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
dep_code |
distinct_count |
dep_code: 665 distinct values |
25035560 |
25035560 |
0 |
100.00% |
|
| INFO |
INFO |
dep |
null_distribution |
dep: 102 null (0.0%), 25035559 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
dep_code |
text_null |
dep_code should not contain text representations of NULL |
25035560 |
25035560 |
0 |
100.00% |
|
| PASS |
WARNING |
dep_code |
regex |
dep_code should match ^\d+$ |
25035560 |
25035560 |
0 |
100.00% |
|
| INFO |
INFO |
dep |
distinct_count |
dep: 498 distinct values |
25035559 |
25035559 |
0 |
100.00% |
|
| INFO |
INFO |
dep_region |
null_distribution |
dep_region: 102 null (0.0%), 25035559 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
dep_region |
distinct_count |
dep_region: 25 distinct values |
25035559 |
25035559 |
0 |
100.00% |
|
| PASS |
INFO |
dep |
text_null |
dep should not contain text representations of NULL |
25035559 |
25035559 |
0 |
100.00% |
|
| INFO |
INFO |
dep_city |
null_distribution |
dep_city: 5432458 null (21.7%), 19603203 not null (78.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
dep_region |
text_null |
dep_region should not contain text representations of NULL |
25035559 |
25035559 |
0 |
100.00% |
|
| INFO |
INFO |
dep_city |
distinct_count |
dep_city: 144 distinct values |
19603203 |
19603203 |
0 |
100.00% |
|
| INFO |
INFO |
dep_address |
null_distribution |
dep_address: 5432458 null (21.7%), 19603203 not null (78.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
dep_address_number |
null_distribution |
dep_address_number: 5576028 null (22.3%), 19459633 not null (77.7%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
dep_description |
null_distribution |
dep_description: 24287304 null (97.0%), 748357 not null (3.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
dep_city |
text_null |
dep_city should not contain text representations of NULL |
19603203 |
19603203 |
0 |
100.00% |
|
| PASS |
INFO |
dep_address |
text_null |
dep_address should not contain text representations of NULL |
19603203 |
19603203 |
0 |
100.00% |
|
| PASS |
INFO |
dep_address_number |
text_null |
dep_address_number should not contain text representations of NULL |
19459633 |
19459633 |
0 |
100.00% |
|
| PASS |
INFO |
dep_description |
text_null |
dep_description should not contain text representations of NULL |
748357 |
748357 |
0 |
100.00% |
|
| INFO |
INFO |
dep_hours_of_work |
null_distribution |
dep_hours_of_work: 5432965 null (21.7%), 19602696 not null (78.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
dep_phones |
null_distribution |
dep_phones: 6335941 null (25.3%), 18699720 not null (74.7%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
brand |
null_distribution |
brand: 2270 null (0.0%), 25033391 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
dep_hours_of_work |
text_null |
dep_hours_of_work should not contain text representations of NULL |
19602696 |
19602696 |
0 |
100.00% |
|
| FAIL |
WARNING |
brand |
text_null |
brand should not contain text representations of NULL |
25033391 |
25033369 |
22 |
100.00% |
|
| PASS |
INFO |
dep_phones |
text_null |
dep_phones should not contain text representations of NULL |
18699720 |
18699720 |
0 |
100.00% |
|
| INFO |
INFO |
brand |
distinct_count |
brand: 4217 distinct values |
25033391 |
25033391 |
0 |
100.00% |
|
| INFO |
INFO |
model |
null_distribution |
model: 8344 null (0.0%), 25027317 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
model |
distinct_count |
model: 36641 distinct values |
25027317 |
25027317 |
0 |
100.00% |
|
| PASS |
WARNING |
model |
text_null |
model should not contain text representations of NULL |
25027317 |
25027317 |
0 |
100.00% |
|
| INFO |
INFO |
generation |
array_length |
generation: avg array len=2.3, min=0, max=12 |
18415751 |
18415751 |
0 |
100.00% |
|
| FAIL |
INFO |
generation |
array_empty |
generation should not contain empty arrays |
18415751 |
17269456 |
1146295 |
93.78% |
|
| INFO |
INFO |
model_suffix |
null_distribution |
model_suffix: 19566194 null (78.2%), 5469467 not null (21.8%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
model_suffix |
distinct_count |
model_suffix: 9430 distinct values |
5469467 |
5469467 |
0 |
100.00% |
|
| FAIL |
INFO |
model_suffix |
text_null |
model_suffix should not contain text representations of NULL |
5469467 |
5469122 |
345 |
99.99% |
|
| INFO |
INFO |
make_year |
distinct_count |
make_year: 108 distinct values |
25035652 |
25035652 |
0 |
100.00% |
|
| PASS |
WARNING |
make_year |
range |
make_year should be in range [1900, 2027] |
25035652 |
25035652 |
0 |
100.00% |
|
| FAIL |
WARNING |
make_year |
not_null |
make_year should not be null or empty |
25035661 |
25035652 |
9 |
100.00% |
|
| INFO |
INFO |
model_year |
null_distribution |
model_year: 9248105 null (36.9%), 15787556 not null (63.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| FAIL |
INFO |
model_year |
range |
model_year should be in range [1900, 2027] |
15787556 |
15623836 |
163720 |
98.96% |
|
| INFO |
INFO |
model_year |
distinct_count |
model_year: 60 distinct values |
15787556 |
15787556 |
0 |
100.00% |
|
| INFO |
INFO |
vin_year_code |
null_distribution |
vin_year_code: 6694455 null (26.7%), 18341206 not null (73.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_year_code |
distinct_count |
vin_year_code: 35 distinct values |
18341206 |
18341206 |
0 |
100.00% |
|
| PASS |
INFO |
vin_year_code |
text_null |
vin_year_code should not contain text representations of NULL |
18341206 |
18341206 |
0 |
100.00% |
|
| PASS |
WARNING |
color |
not_null |
color should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
kind |
not_null |
kind should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
color |
distinct_count |
color: 13 distinct values |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
kind |
distinct_count |
kind: 14 distinct values |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
kind |
text_null |
kind should not contain text representations of NULL |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
WARNING |
color |
text_null |
color should not contain text representations of NULL |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
body |
null_distribution |
body: 5 null (0.0%), 25035656 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
body |
distinct_count |
body: 79 distinct values |
25035656 |
25035656 |
0 |
100.00% |
|
| PASS |
INFO |
body |
text_null |
body should not contain text representations of NULL |
25035656 |
25035656 |
0 |
100.00% |
|
| INFO |
INFO |
possible_body_types |
array_length |
possible_body_types: avg array len=1.7, min=1, max=6 |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
body_subtype |
null_distribution |
body_subtype: 23634835 null (94.4%), 1400826 not null (5.6%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
body_subtype |
text_null |
body_subtype should not contain text representations of NULL |
1400826 |
1400826 |
0 |
100.00% |
|
| PASS |
INFO |
possible_body_types |
array_empty |
possible_body_types should not contain empty arrays |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
body_subtype |
distinct_count |
body_subtype: 49 distinct values |
1400826 |
1400826 |
0 |
100.00% |
|
| INFO |
INFO |
body_modifiers |
null_distribution |
body_modifiers: 24223687 null (96.8%), 811974 not null (3.2%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
body_modifiers |
distinct_count |
body_modifiers: 16 distinct values |
811974 |
811974 |
0 |
100.00% |
|
| PASS |
INFO |
body_modifiers |
text_null |
body_modifiers should not contain text representations of NULL |
811974 |
811974 |
0 |
100.00% |
|
| INFO |
INFO |
vehicle_class |
null_distribution |
vehicle_class: 12528916 null (50.0%), 12506745 not null (50.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
vehicle_class |
text_null |
vehicle_class should not contain text representations of NULL |
12506745 |
12506745 |
0 |
100.00% |
|
| INFO |
INFO |
vehicle_class |
distinct_count |
vehicle_class: 19 distinct values |
12506745 |
12506745 |
0 |
100.00% |
|
| PASS |
INFO |
generation |
text_null_array |
generation array should not contain text representations of NULL |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
trailer_prefix |
distinct_count |
trailer_prefix: 2 distinct values |
1177739 |
1177739 |
0 |
100.00% |
|
| PASS |
INFO |
trailer_prefix |
text_null |
trailer_prefix should not contain text representations of NULL |
1177739 |
1177739 |
0 |
100.00% |
|
| INFO |
INFO |
trailer_prefix |
null_distribution |
trailer_prefix: 23857922 null (95.3%), 1177739 not null (4.7%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
purpose |
distinct_count |
purpose: 3 distinct values |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
fuel |
null_distribution |
fuel: 1187148 null (4.7%), 23848513 not null (95.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
possible_body_types |
text_null_array |
possible_body_types array should not contain text representations of NULL |
18415751 |
18415751 |
0 |
100.00% |
|
| PASS |
WARNING |
purpose |
not_null |
purpose should not be null or empty |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
fuel |
distinct_count |
fuel: 5 distinct values |
23848513 |
23848513 |
0 |
100.00% |
|
| INFO |
INFO |
secondary_fuel |
null_distribution |
secondary_fuel: 20106347 null (80.3%), 4929314 not null (19.7%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
secondary_fuel |
distinct_count |
secondary_fuel: 3 distinct values |
4929314 |
4929314 |
0 |
100.00% |
|
| PASS |
INFO |
secondary_fuel |
text_null |
secondary_fuel should not contain text representations of NULL |
4929314 |
4929314 |
0 |
100.00% |
|
| INFO |
INFO |
is_gbo |
null_distribution |
is_gbo: 1181582 null (4.7%), 23854079 not null (95.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
fuel |
text_null |
fuel should not contain text representations of NULL |
23848513 |
23848513 |
0 |
100.00% |
|
| PASS |
WARNING |
purpose |
text_null |
purpose should not contain text representations of NULL |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
is_hybrid |
null_distribution |
is_hybrid: 1181582 null (4.7%), 23854079 not null (95.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
is_gbo |
range |
is_gbo should be in range [0, 1] |
23854079 |
23854079 |
0 |
100.00% |
|
| INFO |
INFO |
fuel_notes |
distinct_count |
fuel_notes: 6 distinct values |
5459550 |
5459550 |
0 |
100.00% |
|
| PASS |
INFO |
is_hybrid |
range |
is_hybrid should be in range [0, 1] |
23854079 |
23854079 |
0 |
100.00% |
|
| INFO |
INFO |
fuel_notes |
null_distribution |
fuel_notes: 19576111 null (78.2%), 5459550 not null (21.8%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
fuel_notes |
text_null |
fuel_notes should not contain text representations of NULL |
5459550 |
5459550 |
0 |
100.00% |
|
| INFO |
INFO |
capacity |
null_distribution |
capacity: 1186061 null (4.7%), 23849600 not null (95.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| FAIL |
INFO |
possible_fuels |
array_empty |
possible_fuels should not contain empty arrays |
18415751 |
18412178 |
3573 |
99.98% |
|
| INFO |
INFO |
possible_fuels |
array_length |
possible_fuels: avg array len=2.0, min=0, max=6 |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
capacity |
distinct_count |
capacity: 6071 distinct values |
23849600 |
23849600 |
0 |
100.00% |
|
| FAIL |
INFO |
capacity |
range |
capacity should be in range [0, 20000] |
23849600 |
23849278 |
322 |
100.00% |
|
| INFO |
INFO |
possible_displacements |
array_length |
possible_displacements: avg array len=4.7, min=0, max=20 |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
own_weight |
null_distribution |
own_weight: 91456 null (0.4%), 24944205 not null (99.6%) |
25035661 |
25035661 |
0 |
100.00% |
|
| FAIL |
INFO |
possible_displacements |
array_empty |
possible_displacements should not contain empty arrays |
18415751 |
17951095 |
464656 |
97.48% |
|
| INFO |
INFO |
own_weight |
distinct_count |
own_weight: 14400 distinct values |
24944205 |
24944205 |
0 |
100.00% |
|
| INFO |
INFO |
total_weight |
null_distribution |
total_weight: 13377 null (0.1%), 25022284 not null (99.9%) |
25035661 |
25035661 |
0 |
100.00% |
|
| FAIL |
INFO |
own_weight |
range |
own_weight should be in range [40, 45000] |
24944205 |
24921692 |
22513 |
99.91% |
|
| INFO |
INFO |
total_weight |
distinct_count |
total_weight: 9658 distinct values |
25022284 |
25022284 |
0 |
100.00% |
|
| PASS |
INFO |
possible_displacements |
array_range |
possible_displacements array elements should be in range [0, 20000] |
86742007 |
86742007 |
0 |
100.00% |
|
| FAIL |
INFO |
total_weight |
range |
total_weight should be in range [60, 90000] |
25022284 |
25018952 |
3332 |
99.99% |
|
| INFO |
INFO |
payload |
null_distribution |
payload: 93628 null (0.4%), 24942033 not null (99.6%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
possible_fuels |
text_null_array |
possible_fuels array should not contain text representations of NULL |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
payload |
distinct_count |
payload: 25526 distinct values |
24942033 |
24942033 |
0 |
100.00% |
|
| FAIL |
INFO |
payload |
range |
payload should be in range [0, 35000] |
24942033 |
24916357 |
25676 |
99.90% |
|
| INFO |
INFO |
n_reg_new_cyrillic |
null_distribution |
n_reg_new_cyrillic: 748401 null (3.0%), 24287260 not null (97.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
n_reg_latin |
null_distribution |
n_reg_latin: 752563 null (3.0%), 24283098 not null (97.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
n_reg_new_cyrillic |
distinct_count |
n_reg_new_cyrillic: 16814791 distinct values |
24287260 |
24287260 |
0 |
100.00% |
|
| PASS |
INFO |
n_reg_new_cyrillic |
text_null |
n_reg_new_cyrillic should not contain text representations of NULL |
24287260 |
24287260 |
0 |
100.00% |
|
| INFO |
INFO |
has_old_cyrillic |
null_distribution |
has_old_cyrillic: 0 null (0.0%), 25035661 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
n_reg_latin |
text_null |
n_reg_latin should not contain text representations of NULL |
24283098 |
24283098 |
0 |
100.00% |
|
| INFO |
INFO |
has_old_cyrillic |
distinct_count |
has_old_cyrillic: 2 distinct values |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
n_reg_latin |
distinct_count |
n_reg_latin: 16724367 distinct values |
24283098 |
24283098 |
0 |
100.00% |
|
| FAIL |
INFO |
plate_type |
not_null |
plate_type should not be null or empty |
25035661 |
24385807 |
649854 |
97.40% |
|
| PASS |
INFO |
plate_type |
allowed_values |
plate_type should be in allowed set |
24385807 |
24385807 |
0 |
100.00% |
|
| INFO |
INFO |
region_code |
null_distribution |
region_code: 2337875 null (9.3%), 22697786 not null (90.7%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
plate_type |
distinct_count |
plate_type: 6 distinct values |
24385807 |
24385807 |
0 |
100.00% |
|
| PASS |
INFO |
plate_type |
text_null |
plate_type should not contain text representations of NULL |
24385807 |
24385807 |
0 |
100.00% |
|
| INFO |
INFO |
region_code |
distinct_count |
region_code: 167 distinct values |
22697786 |
22697786 |
0 |
100.00% |
|
| PASS |
INFO |
region_code |
text_null |
region_code should not contain text representations of NULL |
22697786 |
22697786 |
0 |
100.00% |
|
| PASS |
INFO |
validation_error |
text_null |
validation_error should not contain text representations of NULL |
2333718 |
2333718 |
0 |
100.00% |
|
| FAIL |
INFO |
is_valid_plate |
not_null |
is_valid_plate should not be null or empty |
25035661 |
24385807 |
649854 |
97.40% |
|
| INFO |
INFO |
validation_error |
null_distribution |
validation_error: 22701943 null (90.7%), 2333718 not null (9.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
validation_error |
distinct_count |
validation_error: 2 distinct values |
2333718 |
2333718 |
0 |
100.00% |
|
| INFO |
INFO |
raw_vin |
null_distribution |
raw_vin: 6480418 null (25.9%), 18555243 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
needs_moderation |
null_distribution |
needs_moderation: 0 null (0.0%), 25035661 not null (100.0%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
region_name |
null_distribution |
region_name: 2424172 null (9.7%), 22611489 not null (90.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
region_name |
distinct_count |
region_name: 29 distinct values |
22611489 |
22611489 |
0 |
100.00% |
|
| INFO |
INFO |
vin |
null_distribution |
vin: 6480419 null (25.9%), 18555242 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
raw_vin |
text_null |
raw_vin should not contain text representations of NULL |
18555243 |
18555243 |
0 |
100.00% |
|
| INFO |
INFO |
raw_vin |
distinct_count |
raw_vin: 9425925 distinct values |
18555243 |
18555243 |
0 |
100.00% |
|
| PASS |
INFO |
vin |
text_null |
vin should not contain text representations of NULL |
18555242 |
18555242 |
0 |
100.00% |
|
| INFO |
INFO |
is_valid_vin |
null_distribution |
is_valid_vin: 6480034 null (25.9%), 18555627 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin |
distinct_count |
vin: 9424917 distinct values |
18555242 |
18555242 |
0 |
100.00% |
|
| INFO |
INFO |
vin_validation_error |
null_distribution |
vin_validation_error: 24807801 null (99.1%), 227860 not null (0.9%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
vin_validation_error |
text_null |
vin_validation_error should not contain text representations of NULL |
227860 |
227860 |
0 |
100.00% |
|
| INFO |
INFO |
vin_validation_error |
distinct_count |
vin_validation_error: 4 distinct values |
227860 |
227860 |
0 |
100.00% |
|
| PASS |
INFO |
region_name |
text_null |
region_name should not contain text representations of NULL |
22611489 |
22611489 |
0 |
100.00% |
|
| INFO |
INFO |
vin_length |
null_distribution |
vin_length: 6480418 null (25.9%), 18555243 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_length |
distinct_count |
vin_length: 27 distinct values |
18555243 |
18555243 |
0 |
100.00% |
|
| INFO |
INFO |
vin_has_ioq |
null_distribution |
vin_has_ioq: 6480034 null (25.9%), 18555627 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_is_17 |
null_distribution |
vin_is_17: 6480034 null (25.9%), 18555627 not null (74.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi |
null_distribution |
vin_wmi: 6694455 null (26.7%), 18341206 not null (73.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi |
distinct_count |
vin_wmi: 9354 distinct values |
18341206 |
18341206 |
0 |
100.00% |
|
| PASS |
INFO |
vin_wmi |
text_null |
vin_wmi should not contain text representations of NULL |
18341206 |
18341206 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi_manufacturer |
null_distribution |
vin_wmi_manufacturer: 7244240 null (28.9%), 17791421 not null (71.1%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi_manufacturer |
distinct_count |
vin_wmi_manufacturer: 1697 distinct values |
17791421 |
17791421 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi_region |
null_distribution |
vin_wmi_region: 6708947 null (26.8%), 18326714 not null (73.2%) |
25035661 |
25035661 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi_known |
null_distribution |
vin_wmi_known: 6694071 null (26.7%), 18341590 not null (73.3%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
vin_wmi_region |
text_null |
vin_wmi_region should not contain text representations of NULL |
18326714 |
18326714 |
0 |
100.00% |
|
| INFO |
INFO |
possible_transmissions |
array_length |
possible_transmissions: avg array len=1.7, min=0, max=2 |
18415751 |
18415751 |
0 |
100.00% |
|
| INFO |
INFO |
vin_wmi_region |
distinct_count |
vin_wmi_region: 6 distinct values |
18326714 |
18326714 |
0 |
100.00% |
|
| PASS |
INFO |
vin_wmi_manufacturer |
text_null |
vin_wmi_manufacturer should not contain text representations of NULL |
17791421 |
17791421 |
0 |
100.00% |
|
| INFO |
INFO |
possible_drives |
array_length |
possible_drives: avg array len=1.4, min=0, max=3 |
18415751 |
18415751 |
0 |
100.00% |
|
| FAIL |
INFO |
possible_transmissions |
array_empty |
possible_transmissions should not contain empty arrays |
18415751 |
18240621 |
175130 |
99.05% |
|
| FAIL |
INFO |
possible_drives |
array_empty |
possible_drives should not contain empty arrays |
18415751 |
18316734 |
99017 |
99.46% |
|
| INFO |
INFO |
backfill_confidence |
null_distribution |
backfill_confidence: 18429844 null (73.6%), 6605817 not null (26.4%) |
25035661 |
25035661 |
0 |
100.00% |
|
| PASS |
INFO |
backfill_confidence |
allowed_values |
backfill_confidence should be in allowed set |
6605817 |
6605817 |
0 |
100.00% |
|
| PASS |
INFO |
backfill_confidence |
text_null |
backfill_confidence should not contain text representations of NULL |
6605817 |
6605817 |
0 |
100.00% |
|
| PASS |
INFO |
backfill_stage |
allowed_values |
backfill_stage should be in allowed set |
6605817 |
6605817 |
0 |
100.00% |
|
| PASS |
INFO |
backfill_stage |
text_null |
backfill_stage should not contain text representations of NULL |
6605817 |
6605817 |
0 |
100.00% |
|
| INFO |
INFO |
backfill_stage |
null_distribution |
backfill_stage: 18429844 null (73.6%), 6605817 not null (26.4%) |
25035661 |
25035661 |
0 |
100.00% |
|
| FAIL |
WARNING |
own_weight_lt_total_weight |
custom_sql |
own_weight має бути менший за total_weight |
24942033 |
24941119 |
914 |
100.00% |
|
| FAIL |
WARNING |
weight_ratio_too_high |
custom_sql |
total_weight / own_weight не має перевищувати 4 |
24921096 |
24233931 |
687165 |
97.24% |
|
| FAIL |
INFO |
make_year_vs_model_year |
custom_sql |
model_year (з VIN) не має відрізнятись від make_year більш ніж на 2 роки |
15787555 |
13164769 |
2622786 |
83.39% |
|
| PASS |
INFO |
possible_transmissions |
text_null_array |
possible_transmissions array should not contain text representations of NULL |
18415751 |
18415751 |
0 |
100.00% |
|
| FAIL |
INFO |
vin_null_before_2021 |
custom_sql |
VIN має бути NULL для реєстрацій до 2021-01-01 |
13085851 |
6480034 |
6605817 |
49.52% |
|
| PASS |
INFO |
possible_drives |
text_null_array |
possible_drives array should not contain text representations of NULL |
18415751 |
18415751 |
0 |
100.00% |
|
| PASS |
WARNING |
future_make_year |
custom_sql |
Автомобілі з майбутнього (make_year > поточний рік + 1) |
25035652 |
25035652 |
0 |
100.00% |
|
| PASS |
WARNING |
negative_weight |
custom_sql |
Від'ємна вага (own_weight або total_weight < 0) |
25024456 |
25024456 |
0 |
100.00% |
|