Type, overview and findings per column. Errors: values a rule proves invalid. Issues: ambiguities and deviations to inspect. Missing values are counted apart. Remarks are under Observations.
34 of 34 columns
Column
Type family
Type
Overview
Missing
Errors
Issues
Details
1customer_id
Identifier
ID
99,992 distinct values across at least 9 recurring formats.Unique after row deduplication
–
-Not applicable
Issue8 repetitions beyond the first
What it is
Occurrences of an identifier beyond the first one: the values present minus the distinct values.
Counted in
occurrences
Count
8
Out of
100,000 present values
Share
<0.01% (8 of 100,000 present values)
Accuracy
Exact: every value the Scan read was counted
Limit
Counts repetitions beyond the first, not the duplicated occurrences nor the number of identifiers that repeat.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
CLI-00000696CLI-00006855CLI-00024687…
Values 3 / 99,992
3 values of 99,992 distinct values; A sample of the values; the list is not exhaustive.
CLI-00000696(2, 0.0%)
CLI-00006855(2, 0.0%)
CLI-00024687(2, 0.0%)
Issues
8 repetitions beyond the first
2title
Categorical
Enum
2 categories; the most frequent holds 50.0% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
distinct values in minority patternsNone detected
values of a minority lengthNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
Ms.Mr.
Values 2 / 2
Ms.(50,025, 50.0%)
Mr.(49,975, 50.0%)
3first_name
Text
Very short string
Very short text, with a median length of 5 characters and 136 distinct values.
0.01%7
-Not applicable
Issue8 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
8
Accuracy
Exact: every value the Scan read was counted
Examples
Miamia
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
Issue6 values with repeated whitespace
What it is
Values with whitespace repeated inside the text.
Counted in
occurrences
Count
6
Out of
99,993 text values
Share
<0.01% (6 of 99,993 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
LiamOliviaEmma…
Values 3 / 136
3 values of 136 distinct values; A sample of the values; the list is not exhaustive.
Liam(2,164, 2.2%)
Olivia(2,121, 2.1%)
Emma(2,105, 2.1%)
Issues
8 spelling-variant groups
6 values with repeated whitespace
Spelling variants 8 groups
Mia×1,787mia×1
William×1,695william×1
Harper×1,669harper×1
Eleanor×1,471eleanor×1
Ezra×1,378ezra×1
Chloe×1,361chloe×1
Mila×1,281mila×1
Ethan×1,086ethan×1
Measures
Shortest value, in characters3
Longest value, in characters10
Mean length, in characters5.57
4last_name
Text
Short string
Short text, with a median length of 6 characters and 220 distinct values.
–
-Not applicable
Issue12 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
12
Accuracy
Exact: every value the Scan read was counted
Examples
Smithsmith
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
Issue5 values with repeated whitespace
What it is
Values with whitespace repeated inside the text.
Counted in
occurrences
Count
5
Out of
99,996 text values
Share
<0.01% (5 of 99,996 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
SmithBrownWilson…
Values 3 / 220
3 values of 220 distinct values; A sample of the values; the list is not exhaustive.
Smith(4,922, 4.9%)
Brown(4,163, 4.2%)
Wilson(4,081, 4.1%)
Issues
12 spelling-variant groups
5 values with repeated whitespace
Spelling variants 12 groups
Smith×4,922smith×1
Taylor×3,797taylor×1
White×3,098white×1
Clark×3,033clark×1
Walker×2,751walker×1
Roberts×1,316roberts×1
Turner×1,184turner×1
Phillips×1,162phillips×1
Morgan×865morgan×1
Lee×820lee×1
Tremblay×229tremblay×1
Sm ith×1Sm ith×1
Measures
Shortest value, in characters2
Longest value, in characters10
Mean length, in characters5.81
5birth_date
Temporal
Date
Dates range from 1940-01-01 to 2008-09-14, in 4 recognized formats (ambiguous dates left out of the range).
0.01%6
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 99,994 eligible values was tested
Issue9,848 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
9,848
Out of
99,994 occurrences
Share
9.85% (9,848 of 99,994 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
09-07-194907-01-1972
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
1945-04-021963-04-151979-05-09…
Values 3 / 42,666
3 values of 42,666 distinct values; A sample of the values; the list is not exhaustive.
1945-04-02(12, 0.0%)
1963-04-15(12, 0.0%)
1979-05-09(12, 0.0%)
Issues
9,848 ambiguous dates
Measures
YYYY-MM-DD72,710
DD-MM-YYYY11,071
MM-DD-YYYY5,490
YYYY/MM/DD7
6gender
Categorical
Enum
2 categories; the most frequent holds 50.0% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values of a minority lengthNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
FM
Values 2 / 2
F(50,025, 50.0%)
M(49,975, 50.0%)
7preferred_language
Categorical
Constant
One value on all 100,000 present positions.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values of a minority lengthNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
en
Values 1 / 1
en(100,000, 100.0%)
8street_number
Numeric
Integer
Whole numbers ranging from 1 to 9,999, with a median of 5,006.
–
Errors: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 100,000 eligible values was tested
Issues: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 100,000 eligible values was tested
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
58423637403…
Values 3 / 9,999
3 values of 9,999 distinct values; A sample of the values; the list is not exhaustive.
5842(25, 0.0%)
3637(24, 0.0%)
403(24, 0.0%)
Measures
Mean4,999.2256
9street_type
Categorical
Enum
15 categories; the most frequent holds 22.2% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
StreetAvenueBoulevard…
Values 3 / 15
3 values of 15 distinct values; A sample of the values; the list is not exhaustive.
Street(22,198, 22.2%)
Avenue(14,319, 14.3%)
Boulevard(11,169, 11.2%)
10street_name
Text
Short string
Short text, with a median length of 7 characters and 123 distinct values.
–
-Not applicable
Issue8 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
8
Accuracy
Exact: every value the Scan read was counted
Examples
Cedarcedar
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
Issue2 values with surrounding whitespace
What it is
Values with whitespace before or after the text.
Counted in
occurrences
Count
2
Out of
100,000 text values
Share
<0.01% (2 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
Issue8 values with repeated whitespace
What it is
Values with whitespace repeated inside the text.
Counted in
occurrences
Count
8
Out of
100,000 text values
Share
<0.01% (8 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
MapleCedarPine…
Values 3 / 123
3 values of 123 distinct values; A sample of the values; the list is not exhaustive.
Maple(4,016, 4.0%)
Cedar(3,954, 4.0%)
Pine(3,836, 3.8%)
Issues
8 spelling-variant groups
2 values with surrounding whitespace
8 values with repeated whitespace
Spelling variants 8 groups
Cedar×3,954cedar×2
Pine×3,836pine×1
Parkside×2,787parkside×1
Garden×2,436garden×1
Harbour×2,399harbour×2
Market×1,236market×1
Clearwater×941clearwater×1
Redwood×730redwood×1
Measures
Shortest value, in characters2
Longest value, in characters299
Mean length, in characters7.26
11street_direction
Categorical
Enum
4 categories; the most frequent holds 29.1% of present values.
75.07%75,070
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 24,930 eligible values was tested
ambiguous numbersNone detectedevery one of the 24,930 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
WestNorthSouth…
Values 3 / 4
3 values of 4 distinct values; A sample of the values; the list is not exhaustive.
West(7,245, 29.1%)
North(6,664, 26.7%)
South(5,802, 23.3%)
12unit_number
Numeric
Integer
Whole numbers ranging from 1 to 999, with a median of 499.
65.0%65,003
Errors: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 34,997 eligible values was tested
Issues: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 34,997 eligible values was tested
ambiguous datesNone detectedevery one of the 34,997 eligible values was tested
ambiguous numbersNone detectedevery one of the 34,997 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
36119680…
Values 3 / 999
3 values of 999 distinct values; A sample of the values; the list is not exhaustive.
361(54, 0.2%)
196(53, 0.2%)
80(53, 0.2%)
Measures
Mean500.4192
13city
Text
Short string
Short text, with a median length of 8 characters and 139 distinct values.
–
-Not applicable
Issue7 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
7
Accuracy
Exact: every value the Scan read was counted
Examples
QuébecQuebec
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
MontréalQuébecLaval…
Values 3 / 139
3 values of 139 distinct values; A sample of the values; the list is not exhaustive.
Montréal(11,183, 11.2%)
Québec(7,353, 7.4%)
Laval(4,692, 4.7%)
Issues
7 spelling-variant groups
Spelling variants 7 groups
Québec×7,353Quebec×2
Brossard×2,070brossard×1
Brampton×1,650brampton×1
Hamilton×1,453hamilton×1
Saint-Hyacinthe×1,337saint-hyacinthe×1
Baie-Comeau×574baie-comeau×1
Surrey×517surrey×1
Measures
Shortest value, in characters4
Longest value, in characters25
Mean length, in characters9.07
14province_code
Categorical
Enum
18 categories; the most frequent holds 75.2% of present values.
–
-Not applicable
Issue5 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
5
Accuracy
Exact: every value the Scan read was counted
Examples
QCqc
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
QCONAB…
Values 3 / 18
3 values of 18 distinct values; A sample of the values; the list is not exhaustive.
QC(75,173, 75.2%)
ON(14,330, 14.3%)
AB(2,604, 2.6%)
Issues
5 spelling-variant groups
Spelling variants 5 groups
QC×75,173qc×17
ON×14,330on×3
AB×2,604ab×1
BC×2,541bc×1
NT×86nt×1
15province_name
Categorical
Enum
16 categories; the most frequent holds 75.2% of present values.
–
-Not applicable
Issue3 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
3
Accuracy
Exact: every value the Scan read was counted
Examples
Quebecquebec
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
QuebecOntarioAlberta…
Values 3 / 16
3 values of 16 distinct values; A sample of the values; the list is not exhaustive.
Quebec(75,184, 75.2%)
Ontario(14,331, 14.3%)
Alberta(2,605, 2.6%)
Issues
3 spelling-variant groups
Spelling variants 3 groups
Quebec×75,184quebec×10
Ontario×14,331ontario×1
British Columbia×2,541british columbia×1
16postal_code
Geographic
Postal code
Postal-code-shaped values in 2 recognized formats.
–
Error16 invalid values
What it is
Values that do not have the shape or the syntax of the type of the column.
Counted in
occurrences
Count
16
Out of
100,000 eligible values
Share
0.02% (16 of 100,000 eligible values)
Accuracy
Exact: every value the Scan read was counted
Limit
Checks the syntax of the type only. A value of valid syntax can still be wrong.
Issue32 spelling-variant groups
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
32
Accuracy
Exact: every value the Scan read was counted
Examples
H0A 3M2H0A 3M2
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
Issue21 values of a minority length
What it is
Values whose length differs from the one that nearly all the values share.
Counted in
occurrences
Count
21
Out of
100,000 text values
Share
0.02% (21 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
A minority length may be legitimate.
Issue54 values with repeated whitespace
What it is
Values with whitespace repeated inside the text.
Counted in
occurrences
Count
54
Out of
100,000 text values
Share
0.05% (54 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
H0A 7S5H0A 8T3H0A 3H9…
Values 3 / 57,510
3 values of 57,510 distinct values; A sample of the values; the list is not exhaustive.
H0A 7S5(15, 0.0%)
H0A 8T3(15, 0.0%)
H0A 3H9(14, 0.0%)
Errors
16 invalid values
Issues
32 spelling-variant groups
21 values of a minority length
54 values with repeated whitespace
Spelling variants 32 groups
H0A 3M2×10H0A 3M2×1
H0A 3G8×6H0A 3G8×1
H0A 3Z4×6H0A 3Z4×1
H0A 8Y3×6H0A 8Y3×1
H0C 9M0×6H0C 9M0×1
H0E 9G1×6H0E 9G1×1
H0A 1V1×5H0A 1V1×1
H0B 0N8×5H0B 0N8×1
H0B 3S4×5H0B 3S4×1
H0A 1X4×4H0A 1X4×1
H0C 4V8×4H0C 4V8×1
H0E 2N4×4H0E 2N4×1
H0P 2L0×4H0P 2L0×1
H0B 5W1×3H0B 5W1×1
H0G 1Z5×3H0G 1Z5×1
H0H 8G3×2H0H 8G3×1
H0K 5X2×2H0K 5X2×1
H0L 8C2×2H0L 8C2×1
H0X 7B5×2H0X 7B5×1
H1J 7P4×2H1J 7P4×1
+12 more groups; the Transformations section lists them.
Measures
Share recognized by the detector99.98
A9A 9A999,979
A9A9A95
H75,185
K14,329
T2,603
V2,542
E1,749
17country_code
Categorical
Enum
2 categories; the most frequent holds more than 99.9% of present values.
–
-Not applicable
Issue1 spelling-variant group
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
1
Accuracy
Exact: every value the Scan read was counted
Examples
CAca
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
CAca
Values 2 / 2
CA(99,978, 100.0%)
ca(22, 0.0%)
Issues
1 spelling-variant group
Spelling variants 1 group
CA×99,978ca×22
18email
Contact
Email
Email-shaped values.
9.29%9,295
Error12 invalid values
What it is
Values that do not have the shape or the syntax of the type of the column.
3 values of 90,698 distinct values; A sample of the values; the list is not exhaustive.
ameliascott@yahoo.example(2, 0.0%)
anderson.ellie.2@yahoo.example(2, 0.0%)
henry.taylor.4@hotmail.example(2, 0.0%)
Errors
12 invalid values
Measures
Share recognized by the detector99.99
example90,693
19phone
Contact
Phone
Phone-shaped values in 2 recognized formats.
–
Errors: None detected
The check ran on every eligible value and found nothing.
invalid valuesNone detectedevery one of the 100,000 eligible values was tested
Issue42 values with repeated whitespace
What it is
Values with whitespace repeated inside the text.
Counted in
occurrences
Count
42
Out of
100,000 text values
Share
0.04% (42 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
+1-200-555-0176+1-200-555-0177+1-200-555-0170…
Values 3 / 1,217
3 values of 1,217 distinct values; A sample of the values; the list is not exhaustive.
+1-200-555-0176(813, 0.8%)
+1-200-555-0177(806, 0.8%)
+1-200-555-0170(802, 0.8%)
Issues
42 values with repeated whitespace
Measures
Share recognized by the detector100
+1-999-999-999999,958
+1 999-999-999942
nanp100,000
20contract_id
Identifier
ID
99,983 distinct values across at least 3 recurring formats.
0.01%9
-Not applicable
Issue36 values of a minority length
What it is
Values whose length differs from the one that nearly all the values share.
Counted in
occurrences
Count
36
Out of
99,991 text values
Share
0.04% (36 of 99,991 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
A minority length may be legitimate.
Issue8 repetitions beyond the first
What it is
Occurrences of an identifier beyond the first one: the values present minus the distinct values.
Counted in
occurrences
Count
8
Out of
99,991 present values
Share
<0.01% (8 of 99,991 present values)
Accuracy
Exact: every value the Scan read was counted
Limit
Counts repetitions beyond the first, not the duplicated occurrences nor the number of identifiers that repeat.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
CTR-1000000696CTR-1000006855CTR-1000024687…
Values 3 / 99,983
3 values of 99,983 distinct values; A sample of the values; the list is not exhaustive.
CTR-1000000696(2, 0.0%)
CTR-1000006855(2, 0.0%)
CTR-1000024687(2, 0.0%)
Issues
36 values of a minority length
8 repetitions beyond the first
21contract_type
Categorical
Enum
9 categories; the most frequent holds 40.8% of present values.
–
-Not applicable
Issue1 spelling-variant group
What it is
Groups of values that differ only by case, accents or spacing.
Counted in
groups
Count
1
Accuracy
Exact: every value the Scan read was counted
Examples
autoAUTO
Limit
Variants are groups of spellings of one text; they do not prove that the spellings mean the same thing.
Issue2 values with surrounding whitespace
What it is
Values with whitespace before or after the text.
Counted in
occurrences
Count
2
Out of
99,998 text values
Share
<0.01% (2 of 99,998 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
Whitespace is often invisible and says nothing about what the value means.
autohometravel…
Values 3 / 9
3 values of 9 distinct values; A sample of the values; the list is not exhaustive.
auto(40,793, 40.8%)
home(30,114, 30.1%)
travel(16,898, 16.9%)
Issues
1 spelling-variant group
2 values with surrounding whitespace
Spelling variants 1 group
auto×40,791AUTO×3auto ×2
22start_date
Temporal
Date
Dates range from 2016-09-18 to 2027-08-15, in 5 recognized formats (ambiguous dates left out of the range).
–
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 100,000 eligible values was tested
Issue9,862 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
9,862
Out of
100,000 occurrences
Share
9.86% (9,862 of 100,000 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
03-05-201806-09-2018
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
2026-05-122026-09-102026-09-14…
Values 3 / 9,315
3 values of 9,315 distinct values; A sample of the values; the list is not exhaustive.
2026-05-12(54, 0.1%)
2026-09-10(54, 0.1%)
2026-09-14(53, 0.1%)
Issues
9,862 ambiguous dates
Measures
YYYY-MM-DD72,717
DD-MM-YYYY11,014
MM-DD-YYYY5,525
YYYY/MM/DD6
DD/MM/YYYY1
23end_date
Temporal
Date
Dates range from 2016-10-24 to 9999-12-31, in 5 recognized formats (ambiguous dates left out of the range).
13.75%13,750
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 86,250 eligible values was tested
Issue8,457 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
8,457
Out of
86,250 occurrences
Share
9.81% (8,457 of 86,250 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
09-05-202607-05-2027
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
2026-10-172026-10-162026-11-02…
Values 3 / 6,248
3 values of 6,248 distinct values; A sample of the values; the list is not exhaustive.
2026-10-17(149, 0.2%)
2026-10-16(146, 0.2%)
2026-11-02(146, 0.2%)
Issues
8,457 ambiguous dates
Measures
YYYY-MM-DD62,909
DD-MM-YYYY9,406
MM-DD-YYYY4,733
YYYY/MM/DD5
MM/DD/YYYY1
24contract_status
Categorical
Enum
7 categories; the most frequent holds 64.1% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
activeexpiredsuspended…
Values 3 / 7
3 values of 7 distinct values; A sample of the values; the list is not exhaustive.
active(64,054, 64.1%)
expired(26,847, 26.8%)
suspended(4,973, 5.0%)
25annual_premium
Numeric
Number
Numbers ranging from -10,152 to 10,916.49, with a median of 1,439.98.
–
Error14 values outside the type of the column
What it is
Values that are not numbers in a column whose type is a number: a word, a symbol or a currency code.
Counted in
occurrences
Count
14
Out of
99,997 present values
Share
0.01% (14 of 99,997 present values)
Accuracy
Exact: every value the Scan read was counted
Limit
Says which values are not numbers, not what they should have been.
Issues: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 99,997 eligible values was tested
ambiguous datesNone detectedevery one of the 99,997 eligible values was tested
ambiguous numbersNone detectedevery one of the 99,997 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
205.881829.04235.13…
Values 3 / 86,913
3 values of 86,913 distinct values; A sample of the values; the list is not exhaustive.
205.88(6, 0.0%)
1829.04(5, 0.0%)
235.13(5, 0.0%)
Errors
14 values outside the type of the column
Measures
Mean1,704.0263
26payment_frequency
Categorical
Enum
6 categories; the most frequent holds 65.1% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
monthlyannualquarterly…
Values 3 / 6
3 values of 6 distinct values; A sample of the values; the list is not exhaustive.
monthly(65,096, 65.1%)
annual(21,971, 22.0%)
quarterly(8,900, 8.9%)
27payment_method
Categorical
Enum
9 categories; the most frequent holds 63.7% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
distinct values in minority patternsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
direct_debitcredit_cardbank_transfer…
Values 3 / 9
3 values of 9 distinct values; A sample of the values; the list is not exhaustive.
direct_debit(63,688, 63.7%)
credit_card(29,258, 29.3%)
bank_transfer(5,269, 5.3%)
28agency_code
Categorical
Enum
30 categories; the most frequent holds 27.1% of present values.
–
-Not applicable
Issue16 values of a minority length
What it is
Values whose length differs from the one that nearly all the values share.
Counted in
occurrences
Count
16
Out of
100,000 text values
Share
0.02% (16 of 100,000 text values)
Accuracy
Exact: every value the Scan read was counted
Limit
A minority length may be legitimate.
AG-PR-001AG-PR-002AG-PR-003…
Values 3 / 30
3 values of 30 distinct values; A sample of the values; the list is not exhaustive.
AG-PR-001(27,096, 27.1%)
AG-PR-002(16,829, 16.8%)
AG-PR-003(9,094, 9.1%)
Issues
16 values of a minority length
29creation_date
Temporal
Date
Dates range from 2016-08-20 to 2026-09-15, in 5 recognized formats (ambiguous dates left out of the range).
–
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 100,000 eligible values was tested
Issue9,900 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
9,900
Out of
100,000 occurrences
Share
9.9% (9,900 of 100,000 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
05-12-202006-03-2024
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
2026-07-242026-03-272026-07-29…
Values 3 / 9,355
3 values of 9,355 distinct values; A sample of the values; the list is not exhaustive.
2026-07-24(53, 0.1%)
2026-03-27(51, 0.1%)
2026-07-29(51, 0.1%)
Issues
9,900 ambiguous dates
Measures
YYYY-MM-DD72,716
DD-MM-YYYY11,059
MM-DD-YYYY5,448
YYYY/MM/DD7
MM/DD/YYYY1
30modification_date
Temporal
Date
Dates range from 2016-08-30 to 2026-09-16, in 5 recognized formats (ambiguous dates left out of the range).
–
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 100,000 eligible values was tested
Issue9,902 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
9,902
Out of
100,000 occurrences
Share
9.9% (9,902 of 100,000 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
05-08-202503-05-2026
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
2026-09-162026-09-142026-09-15…
Values 3 / 7,759
3 values of 7,759 distinct values; A sample of the values; the list is not exhaustive.
2026-09-16(264, 0.3%)
2026-09-14(253, 0.3%)
2026-09-15(250, 0.2%)
Issues
9,902 ambiguous dates
Measures
YYYY-MM-DD72,718
DD-MM-YYYY10,977
MM-DD-YYYY5,485
YYYY/MM/DD5
DD/MM/YYYY1
31claim_date
Temporal
Date
Dates range from 2016-10-09 to 2026-09-16, in 3 recognized formats (ambiguous dates left out of the range).
85.92%85,915
Errors: None detected
The check ran on every eligible value and found nothing.
invalid datesNone detectedevery one of the 14,085 eligible values was tested
Issue1,439 ambiguous dates
What it is
Dates that two configured day and month orders both read as valid.
Counted in
occurrences
Count
1,439
Out of
14,085 occurrences
Share
10.22% (1,439 of 14,085 occurrences)
Accuracy
Exact: every value the Scan read was counted
Examples
09-11-202608-04-2026
Limit
An ambiguous date is not wrong. Tabalyst does not guess the order.
Checks that did not look everywhere
distinct values in minority patternsPartially assessedthe patterns were inferred on a sample
2026-09-152026-09-142026-09-16…
Values 3 / 4,874
3 values of 4,874 distinct values; A sample of the values; the list is not exhaustive.
2026-09-15(35, 0.2%)
2026-09-14(29, 0.2%)
2026-09-16(28, 0.2%)
Issues
1,439 ambiguous dates
Measures
YYYY-MM-DD10,187
DD-MM-YYYY1,556
MM-DD-YYYY784
32claim_amount
Numeric
Number
Numbers ranging from -12,868.67 to 446,411.23, with a median of 4,212.52.
87.19%87,187
Errors: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 12,813 eligible values was tested
Issues: None detected
The check ran on every eligible value and found nothing.
values outside the type of the columnNone detectedevery one of the 12,813 eligible values was tested
ambiguous datesNone detectedevery one of the 12,813 eligible values was tested
ambiguous numbersNone detectedevery one of the 12,813 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
0.002090.7010392.53…
Values 3 / 12,733
3 values of 12,733 distinct values; A sample of the values; the list is not exhaustive.
0.00(5, 0.0%)
2090.70(3, 0.0%)
10392.53(2, 0.0%)
Measures
Mean8,530.3248
33claim_status
Categorical
Enum
4 categories; the most frequent holds 74.4% of present values.
85.92%85,915
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 14,085 eligible values was tested
ambiguous numbersNone detectedevery one of the 14,085 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
closedin_progressrejected…
Values 3 / 4
3 values of 4 distinct values; A sample of the values; the list is not exhaustive.
closed(10,477, 74.4%)
in_progress(1,729, 12.3%)
rejected(1,041, 7.4%)
34branch
Categorical
Enum
3 categories; the most frequent holds 72.7% of present values.
–
-Not applicable
Issues: None detected
The check ran on every eligible value and found nothing.
ambiguous datesNone detectedevery one of the 100,000 eligible values was tested
ambiguous numbersNone detectedevery one of the 100,000 eligible values was tested
spelling-variant groupsNone detected
values outside the closest typeNone detected
values with surrounding whitespaceNone detected
values with repeated whitespaceNone detected
mainquebecontario
Values 3 / 3
main(72,727, 72.7%)
quebec(18,182, 18.2%)
ontario(9,091, 9.1%)
03 / Findings
Observations(42)
What the scan found, by rule, from its facts and never from a guess. A candidate anomaly is worth a look, a remark may be perfectly valid. Counts are exact unless marked.
Confirmed issues
0Defects of the source
Candidate anomalies
20Worth a look
Remarks
22May be valid
Limits
7What the scan could not establish
42 of 42 findings
Status
Finding
Column
Count
Out of
Accuracy
Detail
Candidate anomaly
Duplicate rows beyond their first occurrenceduplicate_rows
dataset
8
100,000records
exact
Records 1109, 7800, 25601, 47930, 54883…
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
first_name
8
–
exact
Miamia8 groups
Spelling variants first_name
Mia×1,787mia×1
William×1,695william×1
Harper×1,669harper×1
Eleanor×1,471eleanor×1
Ezra×1,378ezra×1
Chloe×1,361chloe×1
Mila×1,281mila×1
Ethan×1,086ethan×1
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
last_name
12
–
exact
Smithsmith12 groups
Spelling variants last_name
Smith×4,922smith×1
Taylor×3,797taylor×1
White×3,098white×1
Clark×3,033clark×1
Walker×2,751walker×1
Roberts×1,316roberts×1
Turner×1,184turner×1
Phillips×1,162phillips×1
Morgan×865morgan×1
Lee×820lee×1
Tremblay×229tremblay×1
Sm ith×1Sm ith×1
Candidate anomaly
Date values matching more than one day-month orderambiguous_dates
birth_date
9,848
99,994values
exact
DD-MM-YYYYMM-DD-YYYY9,846, +1 more
Ambiguous dates birth_date
No order was chosen: these values stay ambiguous.
Formats that fit the same values
DD-MM-YYYY or MM-DD-YYYY(9,846)
DD/MM/YYYY or MM/DD/YYYY(2)
Other values, by day-month order
Day first (DD/MM)(11,071)
Month first (MM/DD)(5,490)
Formats read without doubt
YYYY-MM-DD(72,710)
DD-MM-YYYY(11,071)
MM-DD-YYYY(5,490)
YYYY/MM/DD(7)
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
street_name
8
–
exact
Cedarcedar8 groups
Spelling variants street_name
Cedar×3,954cedar×2
Pine×3,836pine×1
Parkside×2,787parkside×1
Garden×2,436garden×1
Harbour×2,399harbour×2
Market×1,236market×1
Clearwater×941clearwater×1
Redwood×730redwood×1
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
city
7
–
exact
QuébecQuebec7 groups
Spelling variants city
Québec×7,353Quebec×2
Brossard×2,070brossard×1
Brampton×1,650brampton×1
Hamilton×1,453hamilton×1
Saint-Hyacinthe×1,337saint-hyacinthe×1
Baie-Comeau×574baie-comeau×1
Surrey×517surrey×1
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
province_code
5
–
exact
QCqc5 groups
Spelling variants province_code
QC×75,173qc×17
ON×14,330on×3
AB×2,604ab×1
BC×2,541bc×1
NT×86nt×1
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
province_name
3
–
exact
Quebecquebec3 groups
Spelling variants province_name
Quebec×75,184quebec×10
Ontario×14,331ontario×1
British Columbia×2,541british columbia×1
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
postal_code
32
–
exact
H0A 3M2H0A 3M232 groups
Spelling variants postal_code
H0A 3M2×10H0A 3M2×1
H0A 3G8×6H0A 3G8×1
H0A 3Z4×6H0A 3Z4×1
H0A 8Y3×6H0A 8Y3×1
H0C 9M0×6H0C 9M0×1
H0E 9G1×6H0E 9G1×1
H0A 1V1×5H0A 1V1×1
H0B 0N8×5H0B 0N8×1
H0B 3S4×5H0B 3S4×1
H0A 1X4×4H0A 1X4×1
H0C 4V8×4H0C 4V8×1
H0E 2N4×4H0E 2N4×1
H0P 2L0×4H0P 2L0×1
H0B 5W1×3H0B 5W1×1
H0G 1Z5×3H0G 1Z5×1
H0H 8G3×2H0H 8G3×1
H0K 5X2×2H0K 5X2×1
H0L 8C2×2H0L 8C2×1
H0X 7B5×2H0X 7B5×1
H1J 7P4×2H1J 7P4×1
+12 more groups; the Transformations section lists them.
Candidate anomaly
Rare lengths among otherwise uniform valuesminority_length
postal_code
21
100,000text values
exact
6 characters
Minority lengths postal_code
Examples are texts of these cases chosen by the scan; there may be others.
Lengths count the characters of the text after normalization.
Dominant length
7 characters(99,979)
Lengths that few texts have
6 charactersT0E 2RH0M8G4H0A6M8(21, 0.02%)
Candidate anomaly
Values written in several ways that normalization compares as equalvariant_groups
country_code
1
–
exact
CAca1 group
Spelling variants country_code
CA×99,978ca×22
Candidate anomaly
Rare lengths among otherwise uniform valuesminority_length
contract_id
36
99,991text values
exact
13 characters15 characters
Minority lengths contract_id
Examples are texts of these cases chosen by the scan; there may be others.
Lengths count the characters of the text after normalization.
Cells changed by collapsing repeated internal whitespacecollapsed_whitespace
street_name
8
100,000text values
exact
Nor··thgate (whitespace repeated inside the text)Hea··ther (whitespace repeated inside the text)+1 more
Repeated whitespace street_name
Examples are texts of these cases chosen by the scan; there may be others.
Marks show the whitespace: · a space, → a tab, ↵ a line break.
Whitespace repeated inside the text: 8 cells
Nor··thgate (whitespace repeated inside the text)(1)
Hea··ther (whitespace repeated inside the text)(1)
Stoneb··ridge (whitespace repeated inside the text)(1)
Remark
Missing valuesmissing_values
street_direction
75,070
100,000values
exact
–
Remark
Missing valuesmissing_values
unit_number
65,003
100,000values
exact
–
Remark
Missing valuesmissing_values
province_code
3
100,000values
exact
–
Remark
Cells changed by collapsing repeated internal whitespacecollapsed_whitespace
postal_code
54
100,000text values
exact
H1J··7P4 (whitespace repeated inside the text)K0G··8R2 (whitespace repeated inside the text)+1 more
Repeated whitespace postal_code
Examples are texts of these cases chosen by the scan; there may be others.
Marks show the whitespace: · a space, → a tab, ↵ a line break.
Whitespace repeated inside the text: 54 cells
H1J··7P4 (whitespace repeated inside the text)(1)
K0G··8R2 (whitespace repeated inside the text)(1)
H0A··1V1 (whitespace repeated inside the text)(1)
Remark
Missing valuesmissing_values
email
9,295
100,000values
exact
–
Remark
Cells changed by collapsing repeated internal whitespacecollapsed_whitespace
phone
42
100,000text values
exact
+1··200-555-0171 (whitespace repeated inside the text)+1··201-555-0170 (whitespace repeated inside the text)+1 more
Repeated whitespace phone
Examples are texts of these cases chosen by the scan; there may be others.
Marks show the whitespace: · a space, → a tab, ↵ a line break.
Whitespace repeated inside the text: 42 cells
+1··200-555-0171 (whitespace repeated inside the text)(1)
+1··201-555-0170 (whitespace repeated inside the text)(1)
+1··200-555-0167 (whitespace repeated inside the text)(1)
Remark
Missing valuesmissing_values
contract_id
9
100,000values
exact
–
Remark
Missing valuesmissing_values
contract_type
2
100,000values
exact
–
Remark
Cells changed by trimming surrounding whitespacetrimmed_cells
contract_type
2
99,998text values
exact
auto· (1 trailing whitespace character)
Surrounding whitespace contract_type
The scan kept every distinct text of these cases.
Marks show the whitespace: · a space, → a tab, ↵ a line break.
Whitespace after the text: 2 cells
auto· (1 trailing whitespace character)(2)
Remark
Missing valuesmissing_values
end_date
13,750
100,000values
exact
–
Remark
Missing valuesmissing_values
annual_premium
3
100,000values
exact
–
Remark
Missing valuesmissing_values
claim_date
85,915
100,000values
exact
–
Remark
Missing valuesmissing_values
claim_amount
87,187
100,000values
exact
–
Remark
Missing valuesmissing_values
claim_status
85,915
100,000values
exact
–
Accuracy: exact counted on every value of the file; at least a scan limit stopped the count; sample counted on a sample of the distinct values. Remarks such as missing values are not quality issues.
04 / Structure
Columns(34)
Inferred type and classification per column. Issues: confirmed issues and candidate anomalies found by the scan; remarks such as missing values are under Observations.
Distinct values are exact unless marked: ≥ at least (a scan limit stopped the count), ≈ estimated from a sample with its error.
06 / Cleaning
Transformations(34)
Occurrences changed by each normalization stage, and the spellings it groups. Raw preview values remain unchanged.
34 of 34 columns
Column
Unicode composed
Trimmed
Whitespace collapsed
Case folded
Accents removed
Distinct
Compared distinct
Variant groups
1customer_id
–
–
–
100.0%100,000
–
99,992
99,992
0
2title
–
–
–
100.0%100,000
–
2
2
0
3first_name
–
–
0.01%6
99.98%99,983
–
136
128
8
4last_name
–
–
0.01%5
99.98%99,982
0.83%832
220
209
12
5birth_date
–
–
–
–
–
42,666
42,666
0
6gender
–
–
–
100.0%100,000
–
2
2
0
7preferred_language
–
–
–
–
–
1
1
0
8street_number
–
–
–
–
–
9,999
9,999
0
9street_type
–
–
–
100.0%100,000
–
15
15
0
10street_name
–
–
0.01%8
99.98%99,985
–
123
115
8
11street_direction
–
–
–
24.93%24,930
–
4
4
0
12unit_number
–
–
–
–
–
999
999
0
13city
–
–
–
99.99%99,994
28.32%28,318
139
132
7
14province_code
–
–
–
99.97%99,974
–
18
13
5
15province_name
–
–
–
99.99%99,988
–
16
13
3
16postal_code
–
–
0.05%54
100.0%100,000
–
57,510
57,510
32
17country_code
–
–
–
99.98%99,978
–
2
1
1
18email
–
–
–
–
–
90,698
90,698
0
19phone
–
–
0.04%42
–
–
1,217
1,217
0
20contract_id
–
–
–
99.99%99,991
–
99,983
99,983
0
21contract_type
–
–
–
0.01%9
–
9
8
1
22start_date
–
–
–
–
–
9,315
9,315
0
23end_date
–
–
–
–
–
6,248
6,248
0
24contract_status
–
–
–
0.01%5
–
7
7
0
25annual_premium
–
–
–
–
–
86,913
86,913
0
26payment_frequency
–
–
–
–
–
6
6
0
27payment_method
–
–
–
0.01%8
–
9
9
0
28agency_code
–
–
–
100.0%100,000
–
30
30
0
29creation_date
–
–
–
–
–
9,355
9,355
0
30modification_date
–
–
–
–
–
7,759
7,759
0
31claim_date
–
–
–
–
–
4,874
4,874
0
32claim_amount
–
–
–
–
–
12,733
12,733
0
33claim_status
–
–
–
–
–
4
4
0
34branch
–
–
–
–
–
3
3
0
Variant groups(77)
Raw spellings that every normalization stage compares as equal: an analytical equivalence, not proof of identity. Whitespace is shown as written.
77 of 77 groups
Column
Comparison key
Occurrences
Spellings
Variants
3first_name
mia
1,788
2
Mia1,787mia1
3first_name
william
1,696
2
William1,695william1
3first_name
harper
1,670
2
Harper1,669harper1
3first_name
eleanor
1,472
2
Eleanor1,471eleanor1
3first_name
ezra
1,379
2
Ezra1,378ezra1
3first_name
chloe
1,362
2
Chloe1,361chloe1
3first_name
mila
1,282
2
Mila1,281mila1
3first_name
ethan
1,087
2
Ethan1,086ethan1
4last_name
smith
4,923
2
Smith4,922smith1
4last_name
taylor
3,798
2
Taylor3,797taylor1
4last_name
white
3,099
2
White3,098white1
4last_name
clark
3,034
2
Clark3,033clark1
4last_name
walker
2,752
2
Walker2,751walker1
4last_name
roberts
1,317
2
Roberts1,316roberts1
4last_name
turner
1,185
2
Turner1,184turner1
4last_name
phillips
1,163
2
Phillips1,162phillips1
4last_name
morgan
866
2
Morgan865morgan1
4last_name
lee
821
2
Lee820lee1
4last_name
tremblay
230
2
Tremblay229tremblay1
4last_name
sm ith
2
2
Sm ith1Sm ith1
10street_name
cedar
3,956
2
Cedar3,954cedar2
10street_name
pine
3,837
2
Pine3,836pine1
10street_name
parkside
2,788
2
Parkside2,787parkside1
10street_name
garden
2,437
2
Garden2,436garden1
10street_name
harbour
2,401
2
Harbour2,399harbour2
10street_name
market
1,237
2
Market1,236market1
10street_name
clearwater
942
2
Clearwater941clearwater1
10street_name
redwood
731
2
Redwood730redwood1
13city
quebec
7,355
2
Québec7,353Quebec2
13city
brossard
2,071
2
Brossard2,070brossard1
13city
brampton
1,651
2
Brampton1,650brampton1
13city
hamilton
1,454
2
Hamilton1,453hamilton1
13city
saint-hyacinthe
1,338
2
Saint-Hyacinthe1,337saint-hyacinthe1
13city
baie-comeau
575
2
Baie-Comeau574baie-comeau1
13city
surrey
518
2
Surrey517surrey1
14province_code
qc
75,190
2
QC75,173qc17
14province_code
on
14,333
2
ON14,330on3
14province_code
ab
2,605
2
AB2,604ab1
14province_code
bc
2,542
2
BC2,541bc1
14province_code
nt
87
2
NT86nt1
15province_name
quebec
75,194
2
Quebec75,184quebec10
15province_name
ontario
14,332
2
Ontario14,331ontario1
15province_name
british columbia
2,542
2
British Columbia2,541british columbia1
16postal_code
h0a 3m2
11
2
H0A 3M210H0A 3M21
16postal_code
h0a 3g8
7
2
H0A 3G86H0A 3G81
16postal_code
h0a 3z4
7
2
H0A 3Z46H0A 3Z41
16postal_code
h0a 8y3
7
2
H0A 8Y36H0A 8Y31
16postal_code
h0c 9m0
7
2
H0C 9M06H0C 9M01
16postal_code
h0e 9g1
7
2
H0E 9G16H0E 9G11
16postal_code
h0a 1v1
6
2
H0A 1V15H0A 1V11
16postal_code
h0b 0n8
6
2
H0B 0N85H0B 0N81
16postal_code
h0b 3s4
6
2
H0B 3S45H0B 3S41
16postal_code
h0a 1x4
5
2
H0A 1X44H0A 1X41
16postal_code
h0c 4v8
5
2
H0C 4V84H0C 4V81
16postal_code
h0e 2n4
5
2
H0E 2N44H0E 2N41
16postal_code
h0p 2l0
5
2
H0P 2L04H0P 2L01
16postal_code
h0b 5w1
4
2
H0B 5W13H0B 5W11
16postal_code
h0g 1z5
4
2
H0G 1Z53H0G 1Z51
16postal_code
h0h 8g3
3
2
H0H 8G32H0H 8G31
16postal_code
h0k 5x2
3
2
H0K 5X22H0K 5X21
16postal_code
h0l 8c2
3
2
H0L 8C22H0L 8C21
16postal_code
h0x 7b5
3
2
H0X 7B52H0X 7B51
16postal_code
h1j 7p4
3
2
H1J 7P42H1J 7P41
16postal_code
k0a 7e0
3
2
K0A 7E02K0A 7E01
16postal_code
h0b 7s8
2
2
H0B 7S81H0B 7S81
16postal_code
h0g 5a0
2
2
H0G 5A01H0G 5A01
16postal_code
h0h 8p6
2
2
H0H 8P61H0H 8P61
16postal_code
h0j 4s4
2
2
H0J 4S41H0J 4S41
16postal_code
h0m 9k5
2
2
H0M 9K51H0M 9K51
16postal_code
h0p 9b2
2
2
H0P 9B21H0P 9B21
16postal_code
h0x 8a8
2
2
H0X 8A81H0X 8A81
16postal_code
h1p 1y2
2
2
H1P 1Y21H1P 1Y21
16postal_code
k0c 2s6
2
2
K0C 2S61K0C 2S61
16postal_code
k0g 8r2
2
2
K0G 8R21K0G 8R21
16postal_code
k0h 3p6
2
2
K0H 3P61K0H 3P61
17country_code
ca
100,000
2
CA99,978ca22
21contract_type
auto
40,796
3
auto40,791AUTO3auto 2
07 / Numeric
Numeric analysis(4)
Range and distribution statistics for accepted numeric values.
4 of 4 columns
Column
Range
Minimum
Maximum
Mean
Median
Distinct
Examples
8street_number
9,998
1
9,999
4,999.2256
5,006
9,999
58423637403++
Values 100 / 9,999
5842(25)
3637(24)
403(24)
9203(20)
5161(15)
7516(13)
4173(12)
227(11)
5104(11)
7446(11)
1657(9)
4585(9)
4693(9)
6794(9)
8761(9)
8879(9)
3801(8)
8108(8)
3365(5)
7129(5)
12unit_number
998
1
999
500.4192
499
999
36119680++
Values 100 / 999
361(54)
196(53)
80(53)
329(46)
714(45)
166(40)
338(40)
454(40)
966(40)
582(39)
390(36)
54(36)
599(36)
749(35)
285(33)
400(31)
710(30)
538(29)
346(28)
589(27)
25annual_premium
21,068.49
-10,152
10,916.49
1,704.0263
1,439.98
86,913
205.881829.04235.13++
Values 100 / 86,913
205.88(6)
1829.04(5)
235.13(5)
1133.32(1)
1334.50(1)
1485.59(1)
1673.89(1)
1870.47(1)
2040.35(1)
2099.21(1)
2108.18(1)
2751.64(1)
2761.70(1)
280.72(1)
2928.30(1)
3051.75(1)
462.16(1)
503.17(1)
5755.15(1)
644.74(1)
32claim_amount
459,279.9
-12,868.67
446,411.23
8,530.3248
4,212.52
12,733
0.002090.7010392.53++
Values 100 / 12,733
0.00(5)
2090.70(3)
10392.53(2)
14650.15(1)
1600.49(1)
2067.32(1)
21458.78(1)
22657.14(1)
23789.14(1)
2733.29(1)
2833.21(1)
2941.69(1)
40026.22(1)
401.01(1)
413.18(1)
5141.58(1)
5509.23(1)
6389.95(1)
9491.09(1)
958.77(1)
08 / Dates
Date analysis(6)
Strict date parsing keeps ambiguous, invalid and non-date values separate. Ambiguous values are never resolved from the other values of the column.
6 of 6 date columns
Column
Status
Breakdown
Valid
Ambiguous
Invalid
Other
Distinct
Formats
5birth_date
mixed
90.15%90,146
9.85%9,848
–
–
42,666
4 variants
4 variants
Unambiguous values: DMY 11,071 · MDY 5,490. Evidence is shown, never applied.
YYYY-MM-DD72,710 (72.71%)
DD-MM-YYYY11,071 (11.07%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY9,846 (9.85%)
MM-DD-YYYY5,490 (5.49%)
YYYY/MM/DD7 (0.01%)
Ambiguous: DD/MM/YYYY or MM/DD/YYYY2 (0.0%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
22start_date
mixed
90.14%90,138
9.86%9,862
–
–
9,315
5 variants
5 variants
Unambiguous values: DMY 11,015 · MDY 5,525. Evidence is shown, never applied.
YYYY-MM-DD72,717 (72.72%)
DD-MM-YYYY11,014 (11.01%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY9,861 (9.86%)
MM-DD-YYYY5,525 (5.53%)
YYYY/MM/DD6 (0.01%)
Ambiguous: DD/MM/YYYY or MM/DD/YYYY1 (0.0%)
DD/MM/YYYY1 (0.0%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
23end_date
mixed
90.19%77,793
9.81%8,457
–
–
6,248
5 variants
5 variants
Unambiguous values: DMY 9,406 · MDY 4,734. Evidence is shown, never applied.
YYYY-MM-DD62,909 (72.94%)
DD-MM-YYYY9,406 (10.91%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY8,455 (9.8%)
MM-DD-YYYY4,733 (5.49%)
YYYY/MM/DD5 (0.01%)
Ambiguous: DD/MM/YYYY or MM/DD/YYYY2 (0.0%)
MM/DD/YYYY1 (0.0%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
29creation_date
mixed
90.1%90,100
9.9%9,900
–
–
9,355
5 variants
5 variants
Unambiguous values: DMY 11,059 · MDY 5,449. Evidence is shown, never applied.
YYYY-MM-DD72,716 (72.72%)
DD-MM-YYYY11,059 (11.06%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY9,899 (9.9%)
MM-DD-YYYY5,448 (5.45%)
YYYY/MM/DD7 (0.01%)
Ambiguous: DD/MM/YYYY or MM/DD/YYYY1 (0.0%)
MM/DD/YYYY1 (0.0%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
30modification_date
mixed
90.1%90,098
9.9%9,902
–
–
7,759
5 variants
5 variants
Unambiguous values: DMY 10,978 · MDY 5,485. Evidence is shown, never applied.
YYYY-MM-DD72,718 (72.72%)
DD-MM-YYYY10,977 (10.98%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY9,902 (9.9%)
MM-DD-YYYY5,485 (5.49%)
YYYY/MM/DD5 (0.01%)
DD/MM/YYYY1 (0.0%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
31claim_date
mixed
89.78%12,646
10.22%1,439
–
–
4,874
3 variants
3 variants
Unambiguous values: DMY 1,556 · MDY 784. Evidence is shown, never applied.
YYYY-MM-DD10,187 (72.33%)
DD-MM-YYYY1,556 (11.05%)
Ambiguous: DD-MM-YYYY or MM-DD-YYYY1,439 (10.22%)
MM-DD-YYYY784 (5.57%)
Invalid date0 (0.0%)
Not a date0 (0.0%)
Distribution over time exact
Valid dates counted by the second pass per calendar period, as written: the offset of a datetime is not converted, and ambiguous dates are counted apart and never placed, unless the unambiguous dates of the column prove one order and the second pass reads them with it.
start_date · 90,138 dates by month, 2016-09 to 2027-08 · 9,862 ambiguous not placed
Period
Dates
2016-09
259
2016-10
533
2016-11
540
2016-12
591
2017-01
510
2017-02
495
2017-03
522
2017-04
537
2017-05
539
2017-06
546
2017-07
550
2017-08
609
2017-09
545
2017-10
525
2017-11
524
2017-12
547
2018-01
582
2018-02
529
2018-03
560
2018-04
568
2018-05
535
2018-06
561
2018-07
589
2018-08
540
2018-09
569
2018-10
559
2018-11
547
2018-12
556
2019-01
557
2019-02
480
2019-03
550
2019-04
552
2019-05
559
2019-06
543
2019-07
564
2019-08
585
2019-09
601
2019-10
562
2019-11
552
2019-12
596
2020-01
564
2020-02
513
2020-03
605
2020-04
556
2020-05
592
2020-06
613
2020-07
585
2020-08
557
2020-09
582
2020-10
602
2020-11
566
2020-12
582
2021-01
569
2021-02
519
2021-03
580
2021-04
589
2021-05
608
2021-06
585
2021-07
603
2021-08
634
2021-09
591
2021-10
584
2021-11
589
2021-12
608
2022-01
622
2022-02
523
2022-03
557
2022-04
599
2022-05
604
2022-06
596
2022-07
684
2022-08
641
2022-09
621
2022-10
594
2022-11
605
2022-12
623
2023-01
639
2023-02
580
2023-03
622
2023-04
668
2023-05
669
2023-06
641
2023-07
664
2023-08
601
2023-09
835
2023-10
1,067
2023-11
1,019
2023-12
1,159
2024-01
1,042
2024-02
1,023
2024-03
1,069
2024-04
1,038
2024-05
1,125
2024-06
1,027
2024-07
1,156
2024-08
1,129
2024-09
1,072
2024-10
1,109
2024-11
1,169
2024-12
1,145
2025-01
1,106
2025-02
994
2025-03
1,087
2025-04
1,116
2025-05
1,205
2025-06
1,115
2025-07
1,178
2025-08
1,189
2025-09
1,178
2025-10
1,209
2025-11
1,166
2025-12
1,162
2026-01
1,257
2026-02
1,085
2026-03
1,295
2026-04
1,240
2026-05
1,373
2026-06
1,242
2026-07
1,423
2026-08
1,492
2026-09
730
2026-10
1
2026-12
2
2027-03
2
2027-04
2
2027-05
3
2027-06
1
2027-07
1
2027-08
3
creation_date · 90,100 dates by month, 2016-08 to 2026-09 · 9,900 ambiguous not placed
Period
Dates
2016-08
76
2016-09
432
2016-10
570
2016-11
547
2016-12
517
2017-01
521
2017-02
497
2017-03
575
2017-04
515
2017-05
535
2017-06
527
2017-07
564
2017-08
592
2017-09
523
2017-10
531
2017-11
533
2017-12
563
2018-01
573
2018-02
509
2018-03
582
2018-04
550
2018-05
543
2018-06
577
2018-07
558
2018-08
578
2018-09
548
2018-10
554
2018-11
583
2018-12
513
2019-01
543
2019-02
470
2019-03
532
2019-04
574
2019-05
562
2019-06
548
2019-07
580
2019-08
591
2019-09
567
2019-10
557
2019-11
579
2019-12
586
2020-01
526
2020-02
532
2020-03
626
2020-04
552
2020-05
640
2020-06
550
2020-07
578
2020-08
575
2020-09
577
2020-10
609
2020-11
578
2020-12
561
2021-01
583
2021-02
511
2021-03
611
2021-04
576
2021-05
596
2021-06
549
2021-07
613
2021-08
647
2021-09
582
2021-10
595
2021-11
591
2021-12
604
2022-01
636
2022-02
505
2022-03
645
2022-04
543
2022-05
627
2022-06
631
2022-07
665
2022-08
632
2022-09
584
2022-10
636
2022-11
614
2022-12
641
2023-01
628
2023-02
567
2023-03
609
2023-04
647
2023-05
676
2023-06
662
2023-07
627
2023-08
664
2023-09
1,003
2023-10
1,049
2023-11
1,098
2023-12
1,131
2024-01
1,071
2024-02
953
2024-03
1,057
2024-04
1,083
2024-05
1,120
2024-06
1,044
2024-07
1,154
2024-08
1,126
2024-09
1,043
2024-10
1,179
2024-11
1,135
2024-12
1,153
2025-01
1,092
2025-02
987
2025-03
1,098
2025-04
1,182
2025-05
1,164
2025-06
1,116
2025-07
1,193
2025-08
1,205
2025-09
1,180
2025-10
1,182
2025-11
1,171
2025-12
1,235
2026-01
1,206
2026-02
1,126
2026-03
1,244
2026-04
1,307
2026-05
1,340
2026-06
1,292
2026-07
1,461
2026-08
1,315
2026-09
229
modification_date · 90,098 dates by month, 2016-08 to 2026-09 · 9,902 ambiguous not placed
Period
Dates
2016-08
1
2016-09
2
2016-10
4
2016-11
10
2016-12
13
2017-01
15
2017-02
16
2017-03
19
2017-04
26
2017-05
23
2017-06
34
2017-07
32
2017-08
53
2017-09
40
2017-10
60
2017-11
37
2017-12
60
2018-01
59
2018-02
68
2018-03
70
2018-04
84
2018-05
100
2018-06
84
2018-07
80
2018-08
101
2018-09
125
2018-10
126
2018-11
119
2018-12
144
2019-01
121
2019-02
135
2019-03
144
2019-04
148
2019-05
137
2019-06
166
2019-07
181
2019-08
185
2019-09
152
2019-10
191
2019-11
179
2019-12
223
2020-01
207
2020-02
192
2020-03
231
2020-04
188
2020-05
220
2020-06
219
2020-07
231
2020-08
230
2020-09
282
2020-10
288
2020-11
262
2020-12
268
2021-01
308
2021-02
269
2021-03
284
2021-04
287
2021-05
316
2021-06
312
2021-07
331
2021-08
363
2021-09
338
2021-10
396
2021-11
358
2021-12
394
2022-01
415
2022-02
375
2022-03
460
2022-04
383
2022-05
424
2022-06
488
2022-07
489
2022-08
478
2022-09
470
2022-10
501
2022-11
529
2022-12
535
2023-01
560
2023-02
488
2023-03
557
2023-04
608
2023-05
620
2023-06
576
2023-07
643
2023-08
682
2023-09
654
2023-10
699
2023-11
736
2023-12
768
2024-01
819
2024-02
819
2024-03
844
2024-04
921
2024-05
996
2024-06
953
2024-07
1,133
2024-08
1,157
2024-09
1,099
2024-10
1,156
2024-11
1,203
2024-12
1,345
2025-01
1,369
2025-02
1,320
2025-03
1,547
2025-04
1,541
2025-05
1,666
2025-06
1,631
2025-07
1,857
2025-08
1,863
2025-09
1,942
2025-10
2,095
2025-11
2,144
2025-12
2,321
2026-01
2,570
2026-02
2,416
2026-03
2,973
2026-04
3,064
2026-05
3,493
2026-06
3,833
2026-07
4,706
2026-08
6,072
2026-09
3,751
claim_date · 12,646 dates by month, 2016-10 to 2026-09 · 1,439 ambiguous not placed
Period
Dates
2016-10
2
2016-11
4
2016-12
1
2017-01
5
2017-02
3
2017-03
4
2017-04
7
2017-05
6
2017-06
5
2017-07
7
2017-08
10
2017-09
18
2017-10
14
2017-11
10
2017-12
21
2018-01
16
2018-02
21
2018-03
19
2018-04
25
2018-05
14
2018-06
22
2018-07
19
2018-08
27
2018-09
16
2018-10
24
2018-11
19
2018-12
27
2019-01
26
2019-02
27
2019-03
27
2019-04
22
2019-05
32
2019-06
30
2019-07
42
2019-08
29
2019-09
38
2019-10
37
2019-11
26
2019-12
27
2020-01
46
2020-02
33
2020-03
50
2020-04
37
2020-05
54
2020-06
47
2020-07
56
2020-08
42
2020-09
45
2020-10
52
2020-11
42
2020-12
64
2021-01
51
2021-02
54
2021-03
58
2021-04
60
2021-05
62
2021-06
64
2021-07
77
2021-08
75
2021-09
60
2021-10
63
2021-11
77
2021-12
66
2022-01
83
2022-02
56
2022-03
83
2022-04
75
2022-05
82
2022-06
73
2022-07
75
2022-08
92
2022-09
86
2022-10
92
2022-11
113
2022-12
79
2023-01
104
2023-02
83
2023-03
90
2023-04
109
2023-05
108
2023-06
97
2023-07
97
2023-08
103
2023-09
124
2023-10
126
2023-11
129
2023-12
150
2024-01
159
2024-02
151
2024-03
147
2024-04
173
2024-05
187
2024-06
185
2024-07
168
2024-08
179
2024-09
194
2024-10
178
2024-11
207
2024-12
173
2025-01
220
2025-02
171
2025-03
221
2025-04
197
2025-05
213
2025-06
232
2025-07
243
2025-08
239
2025-09
278
2025-10
239
2025-11
267
2025-12
285
2026-01
294
2026-02
264
2026-03
292
2026-04
334
2026-05
390
2026-06
393
2026-07
461
2026-08
551
2026-09
388
ValidAmbiguousInvalid
09 / Text
String analysis(24)
Length classes, fixed widths and representative values.
Structural patterns inferred from the distinct values the scan sampled, grouped by family (the values of one structure); the column page shows each family with its nodes and tables. 9 a digit, A a capital, a a lowercase letter, @ any letter, X a capital or a digit, x a lowercase letter or a digit, # a letter or a digit, other characters as written. Shares count distinct values, never occurrences in the file, and are not validated against the whole file.
Columns with patterns
15of 34 columns
Without patterns
19Numbers, dates, masked or too few distinct values
Grammar
v2Version of the pattern rules
114 of 114 patterns
Column
Family
Pattern
Role
Distinct values
Share
Basis
Validated on every value
Length
Examples
1customer_id
UDf2
'ONT000'9999
principal
100
42.19%100
sampleof sampled distinct values
9.09%9,090
10
ONT0007694ONT0002225ONT0007991
Examples 3
ONT0007694
ONT0002225
ONT0007991
1customer_id
UP-Df1
'CLI-000'99999
secondary
86
36.29%86
sampleof sampled distinct values
72.7%72,701
12
CLI-00064850CLI-00008317CLI-00033746
Examples 3
CLI-00064850
CLI-00008317
CLI-00033746
1customer_id
UP-Df1
'CLI-00'99999
secondary
14
5.91%14
sampleof sampled distinct values
0.01%14
11
not kept
1customer_id
UP-DP-Df3
'QC-000'9-9999
secondary
14
5.91%14
sampleof sampled distinct values
18.17%18,172
12
QC-0001-8146QC-0000-4550QC-0001-0983
Examples 3
QC-0001-8146
QC-0000-4550
QC-0001-0983
1customer_id
UP-Df1
'CLI--000'99999
secondary
12
5.06%12
sampleof sampled distinct values
0.01%12
13
not kept
1customer_id
UP-DP-Df3
'QC--000'9-9999
secondary
5
2.11%5
sampleof sampled distinct values
0.01%5
13
not kept
1customer_id
UP-DP-Df3
'QC-000'9-999
secondary
4
1.69%4
sampleof sampled distinct values
–
11
not kept
1customer_id
UDf2
AAA999999
secondary
1
0.42%1
sampleof sampled distinct values
–
9
not kept
1customer_id
UP-DP-Df3
AA-999-9999
secondary
1
0.42%1
sampleof sampled distinct values
–
11
not kept
2title
ULP.f1
'M'a.
principal
2
100.0%2
exactof every distinct value
100.0%100,000
3
Ms.Mr.
Examples 2
Ms.
Mr.
3first_name
ULf1
Aaaaa
principal
29
21.32%29
sampleof sampled distinct values
22.69%22,691
5
JacobEllieMatex
Examples 3
Jacob
Ellie
Matex
3first_name
ULf1
Aaaaaa
secondary
27
19.85%27
sampleof sampled distinct values
24.97%24,972
6
SamuelAmeliaEvelyn
Examples 3
Samuel
Amelia
Evelyn
3first_name
ULf1
Aaaa
secondary
22
16.18%22
sampleof sampled distinct values
23.77%23,773
4
LucaNovaLuvi
Examples 3
Luca
Nova
Luvi
3first_name
ULf1
Aa{7}
secondary
11
8.09%11
sampleof sampled distinct values
8.57%8,573
8
TheodoreBenjaminScarlett
Examples 3
Theodore
Benjamin
Scarlett
3first_name
ULf1
Aaaaaaa
secondary
11
8.09%11
sampleof sampled distinct values
8.1%8,104
7
MatthewJacksonAbigail
Examples 3
Matthew
Jackson
Abigail
3first_name
ULf1
Aa{8}
secondary
4
2.94%4
sampleof sampled distinct values
6.33%6,334
9
CharlotteSebastian
Examples 2
Charlotte
Sebastian
3first_name
ULf1
Aaa
secondary
4
2.94%4
sampleof sampled distinct values
5.52%5,518
3
ZoeAvaLeo
Examples 3
Zoe
Ava
Leo
3first_name
Lf2
aaaa
secondary
4
2.94%4
sampleof sampled distinct values
–
4
ezramilaaleb
Examples 3
ezra
mila
aleb
3first_name
ULf1
AAaaaaa
secondary
3
2.21%3
sampleof sampled distinct values
–
7
JJulianOOliverAAmelia
Examples 3
JJulian
OOliver
AAmelia
3first_name
Lf2
aaaaa
secondary
2
1.47%2
sampleof sampled distinct values
–
5
not kept
3first_name
Lf2
a{7}
secondary
2
1.47%2
sampleof sampled distinct values
–
7
william
Examples 1
william
3first_name
ULP Lf3
Aaaa' 'a
secondary
2
1.47%2
sampleof sampled distinct values
–
7
Davi d
Examples 1
Davi d
3first_name
LULf4
aAaaaa
secondary
2
1.47%2
sampleof sampled distinct values
–
6
oSphia
Examples 1
oSphia
3first_name
ULf1
Aa{9}
secondary
1
0.74%1
sampleof sampled distinct values
–
10
not kept
3first_name
Lf2
aaa
secondary
1
0.74%1
sampleof sampled distinct values
–
3
mia
Examples 1
mia
3first_name
Lf2
aaaaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
6
harper
Examples 1
harper
3first_name
ULP Lf3
Aa aaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
7
Ha rper
Examples 1
Ha rper
3first_name
ULP Lf3
Aa aaaaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
9
Vi ctoria
Examples 1
Vi ctoria
3first_name
ULP Lf3
Aaa aaa
secondary
1
0.74%1
sampleof sampled distinct values
–
7
not kept
3first_name
ULP Lf3
Aaaa' 'aaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
10
Isab ella
Examples 1
Isab ella
3first_name
ULP Lf3
Aaaa' 'aaaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
11
Alex ander
Examples 1
Alex ander
3first_name
ULP Lf3
Aaaaa' 'a
secondary
1
0.74%1
sampleof sampled distinct values
–
8
not kept
3first_name
ULP Lf3
Aaaaaa' 'a
secondary
1
0.74%1
sampleof sampled distinct values
–
9
Abigai l
Examples 1
Abigai l
3first_name
LULf4
aAa
secondary
1
0.74%1
sampleof sampled distinct values
–
3
iMa
Examples 1
iMa
3first_name
LULf4
aAaaa
secondary
1
0.74%1
sampleof sampled distinct values
–
5
mEily
Examples 1
mEily
3first_name
LULf4
aAa{7}
secondary
1
0.74%1
sampleof sampled distinct values
–
9
not kept
4last_name
ULf1
Aaaaaa
principal
43
19.46%43
sampleof sampled distinct values
25.5%25,494
6
BaileyRenaudWlaker
Examples 3
Bailey
Renaud
Wlaker
4last_name
ULf1
Aaaaa
secondary
32
14.48%32
sampleof sampled distinct values
32.12%32,120
5
AhmdeWlsonSingh
Examples 3
Ahmde
Wlson
Singh
4last_name
ULf1
Aa{7}
secondary
28
12.67%28
sampleof sampled distinct values
15.75%15,751
8
LachanceGxuthierBergeron
Examples 3
Lachance
Gxuthier
Bergeron
4last_name
ULf1
Aaaa
secondary
19
8.6%19
sampleof sampled distinct values
10.29%10,293
4
KingKhanSato
Examples 3
King
Khan
Sato
4last_name
ULf1
Aaaaaaa
secondary
19
8.6%19
sampleof sampled distinct values
8.05%8,045
7
MichaudOuelletThompon
Examples 3
Michaud
Ouellet
Thompon
4last_name
ULf1
Aaa
secondary
8
3.62%8
sampleof sampled distinct values
2.84%2,844
3
AliLiiRoy
Examples 3
Ali
Lii
Roy
4last_name
ULf1
Aa{8}
secondary
6
2.71%6
sampleof sampled distinct values
1.59%1,588
9
RodriguezAndersonnFernandes
Examples 3
Rodriguez
Andersonn
Fernandes
4last_name
LULf2
aAaaa
secondary
5
2.26%5
sampleof sampled distinct values
0.01%6
5
rBown
Examples 1
rBown
4last_name
LULf2
aAaaaaaa
secondary
5
2.26%5
sampleof sampled distinct values
0.01%8
8
aCmpbell
Examples 1
aCmpbell
4last_name
Lf3
aaaaaa
secondary
5
2.26%5
sampleof sampled distinct values
0.01%5
6
turnertaylorwalker
Examples 3
turner
taylor
walker
4last_name
ULf1
Aa
secondary
4
1.81%4
sampleof sampled distinct values
1.39%1,392
2
WuLe
Examples 2
Wu
Le
4last_name
LULf2
aAaaaa
secondary
4
1.81%4
sampleof sampled distinct values
–
6
aTylorgNuyen
Examples 2
aTylor
gNuyen
4last_name
Lf3
aaaaa
secondary
4
1.81%4
sampleof sampled distinct values
–
5
clarkartel
Examples 2
clark
artel
4last_name
ULf1
Aa{9}
secondary
3
1.36%3
sampleof sampled distinct values
0.67%672
10
RichardqonDesjardins
Examples 2
Richardqon
Desjardins
4last_name
LULf2
aAaa
secondary
3
1.36%3
sampleof sampled distinct values
–
4
not kept
4last_name
Lf3
a{7}
secondary
2
0.9%2
sampleof sampled distinct values
–
7
hompson
Examples 1
hompson
4last_name
Lf3
a{8}
secondary
2
0.9%2
sampleof sampled distinct values
–
8
not kept
4last_name
ULP Lf4
Aa' 'aaa
secondary
2
0.9%2
sampleof sampled distinct values
–
7
Sm ithEv ans
Examples 2
Sm ith
Ev ans
4last_name
Xf5
@@@@
secondary
2
0.9%2
sampleof sampled distinct values
0.3%304
4
not kept
4last_name
Xf5
@{8}
secondary
2
0.9%2
sampleof sampled distinct values
0.31%310
8
not kept
4last_name
UP'ULf7
A''''Aaaaa
secondary
2
0.9%2
sampleof sampled distinct values
0.4%398
7
D'SouzaO'Brien
Examples 2
D'Souza
O'Brien
4last_name
LUf8
aA
secondary
2
0.9%2
sampleof sampled distinct values
–
2
oH
Examples 1
oH
4last_name
ULf1
AAaaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
6
not kept
4last_name
ULf1
AAaaaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
7
not kept
4last_name
LULf2
aAaaaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
7
oBucher
Examples 1
oBucher
4last_name
LULf2
aAa{7}
secondary
1
0.45%1
sampleof sampled distinct values
–
9
oRdriguez
Examples 1
oRdriguez
4last_name
Lf3
aaa
secondary
1
0.45%1
sampleof sampled distinct values
–
3
lee
Examples 1
lee
4last_name
ULP Lf4
Aa aaa
secondary
1
0.45%1
sampleof sampled distinct values
–
6
Sm ith
Examples 1
Sm ith
4last_name
ULP Lf4
Aaa' 'aaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
9
Rob erts
Examples 1
Rob erts
4last_name
ULP Lf4
Aaaa' 'aaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
10
not kept
4last_name
ULP Lf4
Aaaaaa a
secondary
1
0.45%1
sampleof sampled distinct values
–
8
not kept
4last_name
ULP Lf4
Aaaaaaa a
secondary
1
0.45%1
sampleof sampled distinct values
–
9
not kept
4last_name
Xf5
@@@@@
secondary
1
0.45%1
sampleof sampled distinct values
0.17%165
5
not kept
4last_name
Xf5
@@@@@@
secondary
1
0.45%1
sampleof sampled distinct values
0.05%53
6
not kept
4last_name
UP Lf6
A aaa
secondary
1
0.45%1
sampleof sampled distinct values
–
5
not kept
4last_name
UP Lf6
A aaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
6
not kept
4last_name
UP Lf6
A' 'aaaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
8
T aylor
Examples 1
T aylor
4last_name
UP'ULf7
A''''Aaaaaa
secondary
1
0.45%1
sampleof sampled distinct values
0.41%411
8
not kept
4last_name
P'ULf9
''''Aaaaa
secondary
1
0.45%1
sampleof sampled distinct values
–
6
not kept
4last_name
ULP ULf10
Aa Aaaa
secondary
1
0.45%1
sampleof sampled distinct values
0.06%55
7
De Luca
Examples 1
De Luca
4last_name
ULP-ULf11
Aa-Aaaaaa
secondary
1
0.45%1
sampleof sampled distinct values
0.05%49
9
not kept
5birth_date
DP-DP-Df1
9999-99-99
principal
67
67.0%67
sampleof sampled distinct values
72.71%72,710
10
1976-06-271993-10-061966-04-20
Examples 3
1976-06-27
1993-10-06
1966-04-20
5birth_date
DP-DP-Df1
99-99-9999
secondary
33
33.0%33
sampleof sampled distinct values
27.28%27,275
10
27-07-195026-02-198929-02-2000
Examples 3
27-07-1950
26-02-1989
29-02-2000
16postal_code
UDUP DUDf1
A9A 9A9
principal
100
57.14%100
sampleof sampled distinct values
99.92%99,925
7
A0A 6M2H0Y 3S5H0M 7Y2
Examples 3
A0A 6M2
H0Y 3S5
H0M 7Y2
16postal_code
UDUP DUDf1
A9A' '9A9
secondary
54
30.86%54
sampleof sampled distinct values
0.05%54
8
not kept
16postal_code
UDUP DUf2
A9A 9A
secondary
7
4.0%7
sampleof sampled distinct values
0.01%7
6
not kept
16postal_code
UDUDUDf3
A'0'A9A9
secondary
5
2.86%5
sampleof sampled distinct values
0.01%5
6
not kept
16postal_code
DUP DUDf4
'0'A 9A9
secondary
3
1.71%3
sampleof sampled distinct values
–
6
not kept
16postal_code
UDP DUDf5
A'0' 9A9
secondary
3
1.71%3
sampleof sampled distinct values
–
6
not kept
16postal_code
UDUP UDf6
A9A A9
secondary
2
1.14%2
sampleof sampled distinct values
–
6
not kept
16postal_code
UDUP Df7
A9A 99
secondary
1
0.57%1
sampleof sampled distinct values
–
6
not kept
19phone
P+DP-DP-DP-Df1
'+1-2'99'-555-01'99
principal
100
73.53%100
sampleof sampled distinct values
99.96%99,958
15
+1-205-555-0104+1-206-555-0120+1-203-555-0121
Examples 3
+1-205-555-0104
+1-206-555-0120
+1-203-555-0121
19phone
P+DP DP-DP-Df2
'+1 20'9'-555-01'99
secondary
36
26.47%36
sampleof sampled distinct values
0.04%42
16
+1 200-555-0171+1 201-555-0170+1 200-555-0167
Examples 3
+1 200-555-0171
+1 201-555-0170
+1 200-555-0167
20contract_id
UP-Df1
'CTR-'9{10}
principal
100
73.53%100
sampleof sampled distinct values
99.96%99,955
14
CTR-1000051543CTR-3000010844CTR-1000032588
Examples 3
CTR-1000051543
CTR-3000010844
CTR-1000032588
20contract_id
UP-Df1
'CTR-'9{9}
secondary
22
16.18%22
sampleof sampled distinct values
0.02%22
13
not kept
20contract_id
UP-Df1
'CTR--'9{10}
secondary
14
10.29%14
sampleof sampled distinct values
0.01%14
15
not kept
22start_date
DP-DP-Df1
99-99'-20'99
principal
60
60.0%60
sampleof sampled distinct values
27.27%27,275
10
14-01-202111-18-201708-08-2020
Examples 3
14-01-2021
11-18-2017
08-08-2020
22start_date
DP-DP-Df1
'20'99-99-99
secondary
40
40.0%40
sampleof sampled distinct values
72.72%72,717
10
2017-08-212023-10-182023-07-12
Examples 3
2017-08-21
2023-10-18
2023-07-12
23end_date
DP-DP-Df1
99-99'-20'99
principal
61
61.0%61
sampleof sampled distinct values
27.05%23,333
10
03-11-202212-06-202006-05-2023
Examples 3
03-11-2022
12-06-2020
06-05-2023
23end_date
DP-DP-Df1
'20'99-99-99
secondary
39
39.0%39
sampleof sampled distinct values
72.94%62,909
10
2023-10-182027-02-152023-07-12
Examples 3
2023-10-18
2027-02-15
2023-07-12
27payment_method
LP_Lf1
aaaaaa_aaaaa
principal
1
11.11%1
exactof every distinct value
63.69%63,688
12
direct_debit
Examples 1
direct_debit
27payment_method
LP_Lf1
aaaaaa_aaaa
secondary
1
11.11%1
exactof every distinct value
29.26%29,258
11
credit_card
Examples 1
credit_card
27payment_method
LP_Lf1
aaaa_a{8}
secondary
1
11.11%1
exactof every distinct value
5.27%5,269
13
bank_transfer
Examples 1
bank_transfer
27payment_method
Lf2
aaaaa
secondary
1
11.11%1
exactof every distinct value
–
5
check
Examples 1
check
27payment_method
Lf2
aaaaaa
secondary
1
11.11%1
exactof every distinct value
1.76%1,760
6
cheque
Examples 1
cheque
27payment_method
LP_LP_Uf3
aaaaaa_aaaa_A
secondary
1
11.11%1
exactof every distinct value
–
13
credit_card_X
Examples 1
credit_card_X
27payment_method
LP_LP_Uf3
aaaaaa_aaaaa_A
secondary
1
11.11%1
exactof every distinct value
0.01%5
14
direct_debit_X
Examples 1
direct_debit_X
27payment_method
LP Lf4
aaaaaa aaaaa
secondary
1
11.11%1
exactof every distinct value
0.02%16
12
direct debit
Examples 1
direct debit
27payment_method
LP_Uf5
aaaaaa_A
secondary
1
11.11%1
exactof every distinct value
–
8
cheque_X
Examples 1
cheque_X
28agency_code
UP-UP-Df1
'AG-'AA'-00'9
principal
20
66.67%20
exactof every distinct value
99.98%99,984
9
AG-PR-002AG-PR-003AG-PR-004
Examples 3
AG-PR-002
AG-PR-003
AG-PR-004
28agency_code
UP-UP-Df1
'AG--'AA'-00'9
secondary
10
33.33%10
exactof every distinct value
0.02%16
10
AG--PR-004AG--PR-002AG--PR-001
Examples 3
AG--PR-004
AG--PR-002
AG--PR-001
29creation_date
DP-DP-Df1
99-99'-20'99
principal
60
60.0%60
sampleof sampled distinct values
27.27%27,275
10
14-01-202108-08-202013-02-2022
Examples 3
14-01-2021
08-08-2020
13-02-2022
29creation_date
DP-DP-Df1
'20'99-99-99
secondary
40
40.0%40
sampleof sampled distinct values
72.72%72,716
10
2017-08-212023-10-182023-07-12
Examples 3
2017-08-21
2023-10-18
2023-07-12
30modification_date
DP-DP-Df1
99-99'-20'99
principal
59
59.0%59
sampleof sampled distinct values
27.27%27,275
10
14-01-202108-08-202013-02-2022
Examples 3
14-01-2021
08-08-2020
13-02-2022
30modification_date
DP-DP-Df1
'20'99-99-99
secondary
40
40.0%40
sampleof sampled distinct values
72.72%72,718
10
2017-08-212023-10-182023-07-12
Examples 3
2017-08-21
2023-10-18
2023-07-12
30modification_date
DP/DP/Df2
9999/99/99
secondary
1
1.0%1
sampleof sampled distinct values
0.01%5
10
2026/09/11
Examples 1
2026/09/11
31claim_date
DP-DP-Df1
'20'99-99-99
principal
55
55.0%55
sampleof sampled distinct values
72.33%10,187
10
2023-10-182023-07-122025-08-18
Examples 3
2023-10-18
2023-07-12
2025-08-18
31claim_date
DP-DP-Df1
99-99'-20'99
secondary
45
45.0%45
sampleof sampled distinct values
27.67%3,898
10
23-12-202003-06-202524-02-2024
Examples 3
23-12-2020
03-06-2025
24-02-2024
A share is the part of the distinct values a pattern takes: exact when the scan held every distinct value, sample when it held a sample of them. A value counts for one pattern: the one of its family that has its lengths. Quoted text is a constant the pattern folds. Validated on every value is the second pass: how many occurrences of the whole file the pattern reads, exactly; a value no pattern reads is an observation of structure, not an error.
12 / Relationships
Relationships(8)
How one column goes with another, counted on every row by the second pass. The counts and the percentages of each category come first; a score only summarizes them. An association is not a cause, and a candidate rule is learned from the data and validated by nobody.
title to gender(1 feature)
By prefix of 2 charactersexact 100,000 of 100,000 rows are classified. The dominant prefix of 2 characters of each title holds 100.0% of them; the most frequent prefix of 2 characters overall holds 50.0%.
Classified rows
100,000of 100,000
Purity
100.0%Dominant class of each category; the other way round 100.0%
Association
1.00Cramér's V, bias-corrected: strong
Exceptions
0Rows outside the dominant class, in 0 cells
title
F
M
Rows
Coverage
Purity
Ms.
50,025100.0% dominant class
0
50,025
100.0%
100.0%
Mr.
0
49,975100.0% dominant class
49,975
100.0%
100.0%
All
50,025
49,975
100,000
Candidate rules(2)
candidate When title is Ms., gender reads F in 50,025 of 50,025 rows (100.0%).Learned from the data, not validated.0
candidate When title is Mr., gender reads M in 49,975 of 49,975 rows (100.0%).Learned from the data, not validated.0
The same pair the other way round: gender to title
gender to title(1 feature)
By prefix of 2 charactersexact 100,000 of 100,000 rows are classified. The dominant prefix of 2 characters of each gender holds 100.0% of them; the most frequent prefix of 2 characters overall holds 50.0%.
Classified rows
100,000of 100,000
Purity
100.0%Dominant class of each category; the other way round 100.0%
Association
1.00Cramér's V, bias-corrected: strong
Exceptions
0Rows outside the dominant class, in 0 cells
gender
Ms
Mr
Rows
Coverage
Purity
F
50,025100.0% dominant class
0
50,025
100.0%
100.0%
M
0
49,975100.0% dominant class
49,975
100.0%
100.0%
All
50,025
49,975
100,000
Candidate rules(2)
candidate When gender is F, title reads Ms in 50,025 of 50,025 rows (100.0%).Learned from the data, not validated.0
candidate When gender is M, title reads Mr in 49,975 of 49,975 rows (100.0%).Learned from the data, not validated.0
branch to customer_id(1 feature)
By prefix of 2 charactersexact 100,000 of 100,000 rows are classified. The dominant prefix of 2 characters of each branch holds 100.0% of them; the most frequent prefix of 2 characters overall holds 72.7%.
Classified rows
100,000of 100,000
Purity
100.0%Dominant class of each category; the other way round 100.0%
Association
1.00Cramér's V, bias-corrected: strong
Exceptions
0Rows outside the dominant class, in 0 cells
branch
CL
QC
ON
Rows
Coverage
Purity
main
72,727100.0% dominant class
0
0
72,727
100.0%
100.0%
quebec
0
18,182100.0% dominant class
0
18,182
100.0%
100.0%
ontario
0
0
9,091100.0% dominant class
9,091
100.0%
100.0%
All
72,727
18,182
9,091
100,000
Candidate rules(3)
candidate When branch is main, customer_id reads CL in 72,727 of 72,727 rows (100.0%).Learned from the data, not validated.0
candidate When branch is quebec, customer_id reads QC in 18,182 of 18,182 rows (100.0%).Learned from the data, not validated.0
candidate When branch is ontario, customer_id reads ON in 9,091 of 9,091 rows (100.0%).Learned from the data, not validated.0
province_code to province_name(1 feature)
By lengthexact 99,997 of 100,000 rows are classified. The dominant length of each province_code holds 100.0% of them; the most frequent length overall holds 75.2%.
Classified rows
99,997of 100,000; 3 have no province_code
Purity
100.0%Dominant class of each category; the other way round 97.2%
Association
1.00Unstable: low counts
Exceptions
3Rows outside the dominant class, in 1 cells
The expected counts are below 5 in 48% of the cells: this score is not reliable and says little.
province_code
5
6
7
8
11
12
13
16
20
21
25
Rows
Coverage
Purity
QC
0
75,173100.0% dominant class
0
0
0
0
0
0
0
0
0
75,173
100.0%
100.0%
ON
0
30.0%
14,327100.0% dominant class
0
0
0
0
0
0
0
0
14,330
100.0%
100.0%
AB
0
0
2,604100.0% dominant class
0
0
0
0
0
0
0
0
2,604
100.0%
100.0%
BC
0
0
0
0
0
0
0
2,541100.0% dominant class
0
0
0
2,541
100.0%
100.0%
NB
0
0
0
0
0
0
1,750100.0% dominant class
0
0
0
0
1,750
100.0%
100.0%
SK
0
0
0
0
0
909100.0% dominant class
0
0
0
0
0
909
100.0%
100.0%
MB
0
0
0
879100.0% dominant class
0
0
0
0
0
0
0
879
100.0%
100.0%
NS
0
0
0
0
874100.0% dominant class
0
0
0
0
0
0
874
100.0%
100.0%
NL
0
0
0
0
0
0
0
0
0
0
361100.0% dominant class
361
100.0%
100.0%
PE
0
0
0
0
0
0
0
0
188100.0% dominant class
0
0
188
100.0%
100.0%
NU
0
0
184100.0% dominant class
0
0
0
0
0
0
0
0
184
100.0%
100.0%
YT
95100.0% dominant class
0
0
0
0
0
0
0
0
0
0
95
100.0%
100.0%
NT
0
0
0
0
0
0
0
0
0
86100.0% dominant class
0
86
100.0%
100.0%
qc
0
17100.0% dominant class
0
0
0
0
0
0
0
0
0
17
100.0%
100.0%
on
0
0
3100.0% dominant class
0
0
0
0
0
0
0
0
3
100.0%
100.0%
ab
0
0
1100.0% dominant class
0
0
0
0
0
0
0
0
1
100.0%
100.0%
bc
0
0
0
0
0
0
0
1100.0% dominant class
0
0
0
1
100.0%
100.0%
nt
0
0
0
0
0
0
0
0
0
1100.0% dominant class
0
1
100.0%
100.0%
All
95
75,193
17,119
879
874
909
1,750
2,542
188
87
361
99,997
Exceptions(3 rows)
province_code
Class
Rows
First rows
ON
6
3
QuebecQuebecQuebecRecords 41034, 59460, 84385
Candidate rules(13)
candidate When province_code is QC, province_name reads 6 in 75,173 of 75,173 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is ON, province_name reads 7 in 14,327 of 14,330 rows (100.0%).Learned from the data, not validated.3
candidate When province_code is AB, province_name reads 7 in 2,604 of 2,604 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is BC, province_name reads 16 in 2,541 of 2,541 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NB, province_name reads 13 in 1,750 of 1,750 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is SK, province_name reads 12 in 909 of 909 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is MB, province_name reads 8 in 879 of 879 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NS, province_name reads 11 in 874 of 874 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NL, province_name reads 25 in 361 of 361 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is PE, province_name reads 20 in 188 of 188 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NU, province_name reads 7 in 184 of 184 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is YT, province_name reads 5 in 95 of 95 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NT, province_name reads 21 in 86 of 86 rows (100.0%).Learned from the data, not validated.0
The same pair the other way round: province_name to province_code
province_name to province_code(1 feature)
By prefix of 2 charactersexact 99,997 of 100,000 rows are classified. The dominant prefix of 2 characters of each province_name holds 100.0% of them; the most frequent prefix of 2 characters overall holds 75.2%.
Classified rows
99,997of 100,000; 3 have no value in province_code
Purity
100.0%Dominant class of each category; the other way round 99.9%
Association
0.99Unstable: low counts
Exceptions
25Rows outside the dominant class, in 5 cells
The expected counts are below 5 in 46% of the cells: this score is not reliable and says little.
province_name
QC
ON
AB
BC
NB
SK
MB
NS
NL
PE
NU
other
Rows
Coverage
Purity
Quebec
75,163100.0% dominant class
30.0%
0
0
0
0
0
0
0
0
0
170.0%
75,183
100.0%
100.0%
Ontario
0
14,326100.0% dominant class
0
0
0
0
0
0
0
0
0
30.0%
14,329
100.0%
100.0%
Alberta
0
0
2,604100.0% dominant class
0
0
0
0
0
0
0
0
10.0%
2,605
100.0%
100.0%
British Columbia
0
0
0
2,540100.0% dominant class
0
0
0
0
0
0
0
10.0%
2,541
100.0%
100.0%
New Brunswick
0
0
0
0
1,750100.0% dominant class
0
0
0
0
0
0
0
1,750
100.0%
100.0%
Saskatchewan
0
0
0
0
0
909100.0% dominant class
0
0
0
0
0
0
909
100.0%
100.0%
Manitoba
0
0
0
0
0
0
879100.0% dominant class
0
0
0
0
0
879
100.0%
100.0%
Nova Scotia
0
0
0
0
0
0
0
874100.0% dominant class
0
0
0
0
874
100.0%
100.0%
Newfoundland and Labrador
0
0
0
0
0
0
0
0
361100.0% dominant class
0
0
0
361
100.0%
100.0%
Prince Edward Island
0
0
0
0
0
0
0
0
0
188100.0% dominant class
0
0
188
100.0%
100.0%
Nunavut
0
0
0
0
0
0
0
0
0
0
184100.0% dominant class
0
184
100.0%
100.0%
Yukon
0
0
0
0
0
0
0
0
0
0
0
95100.0% dominant class
95
100.0%
100.0%
Northwest Territories
0
0
0
0
0
0
0
0
0
0
0
87100.0% dominant class
87
100.0%
100.0%
quebec
10100.0% dominant class
0
0
0
0
0
0
0
0
0
0
0
10
100.0%
100.0%
british columbia
0
0
0
1100.0% dominant class
0
0
0
0
0
0
0
0
1
100.0%
100.0%
ontario
0
1100.0% dominant class
0
0
0
0
0
0
0
0
0
0
1
100.0%
100.0%
All
75,173
14,330
2,604
2,541
1,750
909
879
874
361
188
184
204
99,997
Exceptions(25 rows)
province_name
Class
Rows
First rows
Quebec
other
17
qcqcqcRecords 335, 1436, 15848
Quebec
ON
3
ONONONRecords 41034, 59460, 84385
Ontario
other
3
onononRecords 21795, 75950, 81759
Alberta
other
1
abRecords 16556
British Columbia
other
1
bcRecords 6691
Candidate rules(11)
candidate When province_name is Quebec, province_code reads QC in 75,163 of 75,183 rows (100.0%).Learned from the data, not validated.20
candidate When province_name is Ontario, province_code reads ON in 14,326 of 14,329 rows (100.0%).Learned from the data, not validated.3
candidate When province_name is Alberta, province_code reads AB in 2,604 of 2,605 rows (100.0%).Learned from the data, not validated.1
candidate When province_name is British Columbia, province_code reads BC in 2,540 of 2,541 rows (100.0%).Learned from the data, not validated.1
candidate When province_name is New Brunswick, province_code reads NB in 1,750 of 1,750 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Saskatchewan, province_code reads SK in 909 of 909 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Manitoba, province_code reads MB in 879 of 879 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Nova Scotia, province_code reads NS in 874 of 874 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Newfoundland and Labrador, province_code reads NL in 361 of 361 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Prince Edward Island, province_code reads PE in 188 of 188 rows (100.0%).Learned from the data, not validated.0
candidate When province_name is Nunavut, province_code reads NU in 184 of 184 rows (100.0%).Learned from the data, not validated.0
agency_code to customer_id(1 feature)
By prefix of 2 charactersexact 100,000 of 100,000 rows are classified. The dominant prefix of 2 characters of each agency_code holds 100.0% of them; the most frequent prefix of 2 characters overall holds 72.7%.
Classified rows
100,000of 100,000
Purity
100.0%Dominant class of each category; the other way round 36.5%
Association
1.00Cramér's V, bias-corrected: strong
Exceptions
0Rows outside the dominant class, in 0 cells
agency_code
CL
QC
ON
Rows
Coverage
Purity
AG-PR-001
27,096100.0% dominant class
0
0
27,096
100.0%
100.0%
AG-PR-002
16,829100.0% dominant class
0
0
16,829
100.0%
100.0%
AG-PR-003
9,094100.0% dominant class
0
0
9,094
100.0%
100.0%
AG-PR-004
8,100100.0% dominant class
0
0
8,100
100.0%
100.0%
AG-QC-001
0
6,334100.0% dominant class
0
6,334
100.0%
100.0%
AG-QC-002
0
4,000100.0% dominant class
0
4,000
100.0%
100.0%
AG-PR-005
3,899100.0% dominant class
0
0
3,899
100.0%
100.0%
AG-ON-001
0
0
3,088100.0% dominant class
3,088
100.0%
100.0%
AG-PR-006
2,792100.0% dominant class
0
0
2,792
100.0%
100.0%
AG-QC-003
0
2,561100.0% dominant class
0
2,561
100.0%
100.0%
AG-PR-008
2,515100.0% dominant class
0
0
2,515
100.0%
100.0%
AG-PR-007
2,394100.0% dominant class
0
0
2,394
100.0%
100.0%
AG-QC-004
0
2,152100.0% dominant class
0
2,152
100.0%
100.0%
AG-ON-002
0
0
1,812100.0% dominant class
1,812
100.0%
100.0%
AG-QC-005
0
1,786100.0% dominant class
0
1,786
100.0%
100.0%
AG-ON-003
0
0
1,452100.0% dominant class
1,452
100.0%
100.0%
AG-QC-006
0
1,343100.0% dominant class
0
1,343
100.0%
100.0%
AG-ON-004
0
0
1,137100.0% dominant class
1,137
100.0%
100.0%
AG-ON-005
0
0
989100.0% dominant class
989
100.0%
100.0%
AG-ON-006
0
0
611100.0% dominant class
611
100.0%
100.0%
AG--PR-002
3100.0% dominant class
0
0
3
100.0%
100.0%
AG--QC-001
0
3100.0% dominant class
0
3
100.0%
100.0%
AG--ON-003
0
0
2100.0% dominant class
2
100.0%
100.0%
AG--PR-004
2100.0% dominant class
0
0
2
100.0%
100.0%
AG--PR-001
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--PR-003
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--PR-007
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--QC-002
0
1100.0% dominant class
0
1
100.0%
100.0%
AG--QC-004
0
1100.0% dominant class
0
1
100.0%
100.0%
AG--QC-006
0
1100.0% dominant class
0
1
100.0%
100.0%
All
72,727
18,182
9,091
100,000
Candidate rules(20)
candidate When agency_code is AG-PR-001, customer_id reads CL in 27,096 of 27,096 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-002, customer_id reads CL in 16,829 of 16,829 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-003, customer_id reads CL in 9,094 of 9,094 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-004, customer_id reads CL in 8,100 of 8,100 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-001, customer_id reads QC in 6,334 of 6,334 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-002, customer_id reads QC in 4,000 of 4,000 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-005, customer_id reads CL in 3,899 of 3,899 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-001, customer_id reads ON in 3,088 of 3,088 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-006, customer_id reads CL in 2,792 of 2,792 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-003, customer_id reads QC in 2,561 of 2,561 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-008, customer_id reads CL in 2,515 of 2,515 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-007, customer_id reads CL in 2,394 of 2,394 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-004, customer_id reads QC in 2,152 of 2,152 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-002, customer_id reads ON in 1,812 of 1,812 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-005, customer_id reads QC in 1,786 of 1,786 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-003, customer_id reads ON in 1,452 of 1,452 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-006, customer_id reads QC in 1,343 of 1,343 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-004, customer_id reads ON in 1,137 of 1,137 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-005, customer_id reads ON in 989 of 989 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-006, customer_id reads ON in 611 of 611 rows (100.0%).Learned from the data, not validated.0
agency_code to branch(1 feature)
By lengthexact 100,000 of 100,000 rows are classified. The dominant length of each agency_code holds 100.0% of them; the most frequent length overall holds 72.7%.
Classified rows
100,000of 100,000
Purity
100.0%Dominant class of each category; the other way round 36.5%
Association
1.00Cramér's V, bias-corrected: strong
Exceptions
0Rows outside the dominant class, in 0 cells
agency_code
4
6
7
Rows
Coverage
Purity
AG-PR-001
27,096100.0% dominant class
0
0
27,096
100.0%
100.0%
AG-PR-002
16,829100.0% dominant class
0
0
16,829
100.0%
100.0%
AG-PR-003
9,094100.0% dominant class
0
0
9,094
100.0%
100.0%
AG-PR-004
8,100100.0% dominant class
0
0
8,100
100.0%
100.0%
AG-QC-001
0
6,334100.0% dominant class
0
6,334
100.0%
100.0%
AG-QC-002
0
4,000100.0% dominant class
0
4,000
100.0%
100.0%
AG-PR-005
3,899100.0% dominant class
0
0
3,899
100.0%
100.0%
AG-ON-001
0
0
3,088100.0% dominant class
3,088
100.0%
100.0%
AG-PR-006
2,792100.0% dominant class
0
0
2,792
100.0%
100.0%
AG-QC-003
0
2,561100.0% dominant class
0
2,561
100.0%
100.0%
AG-PR-008
2,515100.0% dominant class
0
0
2,515
100.0%
100.0%
AG-PR-007
2,394100.0% dominant class
0
0
2,394
100.0%
100.0%
AG-QC-004
0
2,152100.0% dominant class
0
2,152
100.0%
100.0%
AG-ON-002
0
0
1,812100.0% dominant class
1,812
100.0%
100.0%
AG-QC-005
0
1,786100.0% dominant class
0
1,786
100.0%
100.0%
AG-ON-003
0
0
1,452100.0% dominant class
1,452
100.0%
100.0%
AG-QC-006
0
1,343100.0% dominant class
0
1,343
100.0%
100.0%
AG-ON-004
0
0
1,137100.0% dominant class
1,137
100.0%
100.0%
AG-ON-005
0
0
989100.0% dominant class
989
100.0%
100.0%
AG-ON-006
0
0
611100.0% dominant class
611
100.0%
100.0%
AG--PR-002
3100.0% dominant class
0
0
3
100.0%
100.0%
AG--QC-001
0
3100.0% dominant class
0
3
100.0%
100.0%
AG--ON-003
0
0
2100.0% dominant class
2
100.0%
100.0%
AG--PR-004
2100.0% dominant class
0
0
2
100.0%
100.0%
AG--PR-001
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--PR-003
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--PR-007
1100.0% dominant class
0
0
1
100.0%
100.0%
AG--QC-002
0
1100.0% dominant class
0
1
100.0%
100.0%
AG--QC-004
0
1100.0% dominant class
0
1
100.0%
100.0%
AG--QC-006
0
1100.0% dominant class
0
1
100.0%
100.0%
All
72,727
18,182
9,091
100,000
Candidate rules(20)
candidate When agency_code is AG-PR-001, branch reads 4 in 27,096 of 27,096 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-002, branch reads 4 in 16,829 of 16,829 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-003, branch reads 4 in 9,094 of 9,094 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-004, branch reads 4 in 8,100 of 8,100 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-001, branch reads 6 in 6,334 of 6,334 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-002, branch reads 6 in 4,000 of 4,000 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-005, branch reads 4 in 3,899 of 3,899 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-001, branch reads 7 in 3,088 of 3,088 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-006, branch reads 4 in 2,792 of 2,792 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-003, branch reads 6 in 2,561 of 2,561 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-008, branch reads 4 in 2,515 of 2,515 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-PR-007, branch reads 4 in 2,394 of 2,394 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-004, branch reads 6 in 2,152 of 2,152 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-002, branch reads 7 in 1,812 of 1,812 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-005, branch reads 6 in 1,786 of 1,786 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-003, branch reads 7 in 1,452 of 1,452 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-QC-006, branch reads 6 in 1,343 of 1,343 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-004, branch reads 7 in 1,137 of 1,137 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-005, branch reads 7 in 989 of 989 rows (100.0%).Learned from the data, not validated.0
candidate When agency_code is AG-ON-006, branch reads 7 in 611 of 611 rows (100.0%).Learned from the data, not validated.0
province_code to postal_code(1 feature)
By prefix of 2 charactersexact 99,997 of 100,000 rows are classified. The dominant prefix of 2 characters of each province_code holds 85.3% of them; the most frequent prefix of 2 characters overall holds 60.5%.
Classified rows
99,997of 100,000; 3 have no province_code
Purity
85.3%Dominant class of each category; the other way round 97.7%
Association
0.93Unstable: low counts
Exceptions
14,686Rows outside the dominant class, in 4 cells
The expected counts are below 5 in 27% of the cells: this score is not reliable and says little.
province_code
H0
H1
K0
T0
V0
A0
S0
other
Rows
Coverage
Purity
QC
60,49280.5% dominant class
14,67819.5%
0
0
0
0
0
30.0%
75,173
100.0%
80.5%
ON
30.0%
0
14,327100.0% dominant class
0
0
0
0
0
14,330
100.0%
100.0%
AB
0
0
0
2,604100.0% dominant class
0
0
0
0
2,604
100.0%
100.0%
BC
0
0
0
0
2,541100.0% dominant class
0
0
0
2,541
100.0%
100.0%
NB
0
0
0
0
0
0
0
1,750100.0% dominant class
1,750
100.0%
100.0%
SK
0
0
0
0
0
0
909100.0% dominant class
0
909
100.0%
100.0%
MB
0
0
0
0
0
0
0
879100.0% dominant class
879
100.0%
100.0%
NS
0
0
0
0
0
0
0
874100.0% dominant class
874
100.0%
100.0%
NL
0
0
0
0
0
361100.0% dominant class
0
0
361
100.0%
100.0%
PE
0
0
0
0
0
0
0
188100.0% dominant class
188
100.0%
100.0%
NU
0
0
0
0
0
0
0
184100.0% dominant class
184
100.0%
100.0%
YT
0
0
0
0
0
0
0
95100.0% dominant class
95
100.0%
100.0%
NT
0
0
0
0
0
0
0
86100.0% dominant class
86
100.0%
100.0%
qc
1588.2% dominant class
211.8%
0
0
0
0
0
0
17
100.0%
88.2%
on
0
0
3100.0% dominant class
0
0
0
0
0
3
100.0%
100.0%
ab
0
0
0
1100.0% dominant class
0
0
0
0
1
100.0%
100.0%
bc
0
0
0
0
1100.0% dominant class
0
0
0
1
100.0%
100.0%
nt
0
0
0
0
0
0
0
1100.0% dominant class
1
100.0%
100.0%
All
60,510
14,680
14,330
2,605
2,542
361
909
4,060
99,997
Exceptions(14,686 rows)
province_code
Class
Rows
First rows
QC
H1
14,678
H1N 9R6H1P 7K5H1B 7G8Records 5, 21, 26
QC
other
3
0Z 3L60G 7K90E 0E7Records 24617, 31653, 63471
ON
H0
3
H0A 7Y1H0A 7T4H0A 7Y2Records 41034, 59460, 84385
qc
H1
2
H1M 0B2H1R 5B1Records 28142, 63900
Candidate rules(5)
candidate When province_code is ON, postal_code reads K0 in 14,327 of 14,330 rows (100.0%).Learned from the data, not validated.3
candidate When province_code is AB, postal_code reads T0 in 2,604 of 2,604 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is BC, postal_code reads V0 in 2,541 of 2,541 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is SK, postal_code reads S0 in 909 of 909 rows (100.0%).Learned from the data, not validated.0
candidate When province_code is NL, postal_code reads A0 in 361 of 361 rows (100.0%).Learned from the data, not validated.0
779 tables of a category against a feature were explored on the sampled rows of the interior (900 rows): 20 listed, 61 only one category has rows, 93 only one class has rows. A relation not found in a sample may still exist in the file.
6 pairs of numeric columns were explored on the sampled rows of the interior (900 rows): 0 listed.
Counts are exact: every row of the file is placed in one category and one class, or counted as left out. The dominant class of a category is the one that holds most of it; a tie goes to the first class listed. Purity is the share of the classified rows that sit in the dominant class of their category. The score is Cramér's V corrected for the number of rows and classes; when the expected counts are low it is marked unstable and given no strength. An empty other row or column is not printed. Correlations show a linear association between two columns, over the rows where both have a number.
13 / Insights
Insights(11)
What the second pass found in the values, with the accuracy of each figure: exact counts every value of the file, estimated comes with certain bounds. The same cards appear on the page of each column they concern.
Values left out
Values left out by patterns and detectorsfirst_name
exact
99,993 values read.
Values read
99,993
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
Aaaaaa
24,972
27
Hudson
2
Aaaa
23,773
22
Emma
1
Aaaaa
22,691
29
Elias
6
Aa{7}
8,573
11
Benjamin
3
Aaaaaaa
8,104
11
William
42
Aa{8}
6,334
4
Elizabeth
11
Aaa
5,518
4
Ava
4
AAaaaaa
3
3
OOliver
14,498
Aa{9}
1
1
Elizaabeth
80,588
aaaa
4
4
acob
24,511
aaaaa
2
2
ethan
72,963
a{7}
2
2
william
31,215
aaa
1
1
mia
35,625
aaaaaa
1
1
harper
21,204
Aaaa' 'a
2
2
Davi d
11,575
Values left out by patterns and detectorslast_name
exact
99,996 values read.
Values read
99,996
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
Aaaaa
32,120
32
Clark
1
Aaaaaa
25,494
43
Nelson
2
Aa{7}
15,751
28
Anderson
19
Aaaa
10,293
19
Ward
10
Aaaaaaa
8,045
19
Johnson
11
Aaa
2,844
8
Cox
69
Aa{8}
1,588
6
Pelletier
8
Aa
1,392
4
Wu
110
Aa{9}
672
3
Richardson
39
AAaaaa
1
1
PPatel
37,143
AAaaaaa
1
1
WWright
75,530
aAaaa
6
5
hAmed
1,766
aAaaaaaa
8
5
nAderson
10,720
aAaaaa
4
4
oHward
17,292
aAaa
3
3
aHll
8,220
Values left out by patterns and detectorsphone
exact
100,000 values read.
Values read
100,000
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
'+1-2'99'-555-01'99
99,958
1,181
+1-200-555-0133
1
'+1 20'9'-555-01'99
42
36
+1 200-555-0135
5,491
Values left out by patterns and detectorsstart_date
exact
100,000 values read.
Values read
100,000
Left out: no pattern reads them
8 occurrences8 distinct values
Most frequent values left out (1) exact
Value
Occurrences
First record
11/07/2024
1
87,425
2017/12/23
1
53,226
2019/03/30
1
14,696
2020/04/15
1
11,283
2020/12/06
1
55,526
2025/10/29
1
70,635
2026/07/09
1
43,904
29/03/2025
1
82,374
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
'20'99-99-99
72,717
3,661
2020-01-01
1
99-99'-20'99
27,275
5,646
13-11-2018
442
Values left out by patterns and detectorsend_date
exact
86,250 values read.
Values read
86,250
Left out: no pattern reads them
8 occurrences8 distinct values
Most frequent values left out (1) exact
Value
Occurrences
First record
04/08/2027
1
93,088
07/25/2027
1
77,822
10/03/2027
1
83,860
2023/12/10
1
16,698
2026/09/13
1
14,780
2026/10/21
1
14,957
2027/03/30
1
20,469
2027/05/10
1
30,659
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
99-99'-20'99
23,333
3,250
21-11-2026
21,689
'20'99-99-99
62,909
2,990
2027-02-12
1
Values left out by patterns and detectorscreation_date
exact
100,000 values read.
Values read
100,000
Left out: no pattern reads them
9 occurrences9 distinct values
Most frequent values left out (1) exact
Value
Occurrences
First record
03/05/2019
1
76,213
06/20/2023
1
79,701
2017/07/11
1
26,585
2019/03/14
1
8,973
2020/05/16
1
63,239
2020/05/19
1
40,466
2022/07/09
1
63,454
2023/10/12
1
329
2025/08/25
1
67,818
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
'20'99-99-99
72,716
3,678
2019-12-31
1
99-99'-20'99
27,275
5,668
22-12-2017
1,162
Values left out by patterns and detectorsmodification_date
exact
100,000 values read.
Values read
100,000
Left out: no pattern reads them
2 occurrences2 distinct values
Most frequent values left out (1) exact
Value
Occurrences
First record
03/03/2023
1
85,522
30/12/2025
1
89,153
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
'20'99-99-99
72,718
3,371
2022-02-02
1
99-99'-20'99
27,275
4,381
20-03-2026
1,492
9999/99/99
5
5
2024/10/18
12,037
Values left out by patterns and detectorsclaim_date
exact
14,085 values read.
Values read
14,085
Each pattern over every occurrence exact
Pattern
Occurrences
Distinct values
Example
First record
'20'99-99-99
10,187
2,634
2025-05-12
3
99-99'-20'99
3,898
2,240
07-25-2018
72,730
Repeated values
Repeated valuescustomer_id
exact
8 values found more than once.
Values read
100,000
Distinct values
99,992
Values found more than once
8
Extra occurrences
8
Most repeated values exact
Value
Occurrences
First record
CLI-00000696
2
696
CLI-00006855
2
6,855
CLI-00024687
2
24,687
CLI-00047806
2
47,806
CLI-00054365
2
54,365
CLI-00069732
2
69,732
QC-0000-1479
2
83,297
QC-0000-7867
2
89,685
Repeated valuespostal_code
exact
22,241 values found more than once.
Values read
100,000
Distinct values
57,542
Values found more than once
22,241
Extra occurrences
42,458
Most repeated values exact
Value
Occurrences
First record
H0A 7S5
15
4,646
H0A 8T3
15
4,094
H0A 3H9
14
3,095
H0A 1T0
13
5,328
H0A 2V8
13
4,878
H0A 7L2
13
4,571
H0A 7W6
13
8,844
H0A 8A3
13
1,970
H0A 8R1
13
13,007
H0A 0G2
12
12,310
H0A 1N1
12
4,399
H0A 1V8
12
3,950
H0A 3C4
12
3,157
H0A 3R8
12
2,777
H0A 4Z6
12
34,912
The list is bounded; the counts of the values it holds are exact.
Numbers by category
Numbers by categorycontract_type and annual_premium
exactestimated
99,981 of 100,000 rows.
Rows
100,000
Rows with a category and a number
99,981
Rows without a category
2
Rows without a number
17
Share of the variance the categories explain
33.1%33.0% once corrected for the number of categories
contract_type and annual_premium by category estimated
Category
Rows
Numbers
Minimum
Median
Mean
Maximum
auto
40,793
40,790
-3,849.71
1,508.6384
1,561.9825
4,679.75
home
30,114
30,106
-3,349.45
1,875.0888
1,874.3755
3,499.99
travel
16,898
16,895
-726.93
466.1267
482.4766
1,199.46
life
12,182
12,179
-10,152
2,969.4855
3,453.7182
10,916.49
AUTO
3
3
2,020.79
2,278.4091
2,279.9933
2,670.14
travel_X
3
3
148.64
592.9299
661.2967
1,162.53
auto_X
2
2
2,032.69
2,083.9821
2,100.24
2,167.79
autos
2
2
526.97
776.4249
749.235
971.5
home_X
1
1
931.62
931.62
931.62
931.62
An association between two columns, not a cause. Counts are exact; the minimum, maximum, mean and spread are computed in float64; medians are estimates between certain bounds.
14 / Second pass
Second pass(48)
Exact analyses added by reading the source again. Automatic: the planner chose what is useful and cheap. The second pass computed analyses.
Computed
48Analyses with a result
Not computed
00 skipped, 0 failed
Already answered
125By the scan, no reading needed
Not selected
161Left out by the planner
48 of 48 analyses
Column
Analysis
Status
Result
Accuracy
first_name
Exact frequencies
complete
136 values counted, the most frequent 2,164 times
exact
last_name
Exact frequencies
complete
220 values counted, the most frequent 4,922 times
exact
street_name
Exact frequencies
complete
123 values counted, the most frequent 4,016 times
exact
unit_number
Exact frequencies
complete
999 values counted, the most frequent 54 times
exact
city
Exact frequencies
complete
139 values counted, the most frequent 11,183 times
exact
street_number
Histogram and exact quantiles
complete
9,999 distinct integers counted one by one; median 5,006
exact
unit_number
Histogram and exact quantiles
complete
999 distinct integers counted one by one; median 499
exact
annual_premium
Histogram and exact quantiles
complete
100 bins, counts exact; median estimated at 1,440.2245 (between 1,435.6695 and 1,646.3544)
exact
claim_amount
Histogram and exact quantiles
complete
100 bins, counts exact; median estimated at 4,662.2509 (between 909.727 and 5,502.526)
exact
customer_id
Pattern validation
complete
100,000 of 100,000 values read by 9 patterns, 0 by none
exact
title
Pattern validation
complete
100,000 of 100,000 values read by 1 pattern, 0 by none
exact
first_name
Pattern validation
complete
99,993 of 99,993 values read by 26 patterns, 0 by none
exact
last_name
Pattern validation
complete
99,996 of 99,996 values read by 41 patterns, 0 by none
exact
birth_date
Pattern validation
complete
99,985 of 99,994 values read by 2 patterns, 9 by none
exact
postal_code
Pattern validation
complete
100,000 of 100,000 values read by 8 patterns, 0 by none
exact
phone
Pattern validation
complete
100,000 of 100,000 values read by 2 patterns, 0 by none
exact
contract_id
Pattern validation
complete
99,991 of 99,991 values read by 3 patterns, 0 by none
exact
start_date
Pattern validation
complete
99,992 of 100,000 values read by 2 patterns, 8 by none
exact
end_date
Pattern validation
complete
86,242 of 86,250 values read by 2 patterns, 8 by none
exact
payment_method
Pattern validation
complete
100,000 of 100,000 values read by 9 patterns, 0 by none
exact
agency_code
Pattern validation
complete
100,000 of 100,000 values read by 2 patterns, 0 by none
exact
creation_date
Pattern validation
complete
99,991 of 100,000 values read by 2 patterns, 9 by none
exact
modification_date
Pattern validation
complete
100,000 of 100,000 values read by 3 patterns, 2 by none
exact
claim_date
Pattern validation
complete
14,085 of 14,085 values read by 2 patterns, 0 by none
exact
start_date
Distribution over time
complete
90,138 dates by month, 2016-09 to 2027-08; 9,862 ambiguous not placed
exact
creation_date
Distribution over time
complete
90,100 dates by month, 2016-08 to 2026-09; 9,900 ambiguous not placed
exact
modification_date
Distribution over time
complete
90,098 dates by month, 2016-08 to 2026-09; 9,902 ambiguous not placed
exact
claim_date
Distribution over time
complete
12,646 dates by month, 2016-10 to 2026-09; 1,439 ambiguous not placed
exact
first_name
Values left out by patterns and detectors
complete
at least 0 values left out; 26 patterns profiled
exact
last_name
Values left out by patterns and detectors
complete
at least 0 values left out; 41 patterns profiled
exact
phone
Values left out by patterns and detectors
complete
at least 0 values left out; 2 patterns profiled
exact
start_date
Values left out by patterns and detectors
complete
at least 8 values left out (1 table); 2 patterns profiled
exact
end_date
Values left out by patterns and detectors
complete
at least 8 values left out (1 table); 2 patterns profiled
exact
creation_date
Values left out by patterns and detectors
complete
at least 9 values left out (1 table); 2 patterns profiled
exact
modification_date
Values left out by patterns and detectors
complete
at least 2 values left out (1 table); 3 patterns profiled
exact
claim_date
Values left out by patterns and detectors
complete
at least 0 values left out; 2 patterns profiled
exact
customer_id
Repeated values
complete
8 values found more than once, 8 extra occurrences
exact
postal_code
Repeated values
complete
22,241 values found more than once, 42,458 extra occurrences; list bounded
exact
title and gender (prefix)
Category against a feature of a column
complete
100,000 of 100,000 rows by prefix; Cramér's V 1.00; purity 100.0%; 2 candidate rules
exact
gender and title (prefix)
Category against a feature of a column
complete
100,000 of 100,000 rows by prefix; Cramér's V 1.00; purity 100.0%; 2 candidate rules
exact
branch and customer_id (prefix)
Category against a feature of a column
complete
100,000 of 100,000 rows by prefix; Cramér's V 1.00; purity 100.0%; 3 candidate rules
exact
province_name and province_code (prefix)
Category against a feature of a column
complete
99,997 of 100,000 rows by prefix; Cramér's V 1.00 (low counts); purity 100.0%; 11 candidate rules
exact
province_code and province_name (length)
Category against a feature of a column
complete
99,997 of 100,000 rows by length; Cramér's V 1.00 (low counts); purity 100.0%; 13 candidate rules
exact
agency_code and customer_id (prefix)
Category against a feature of a column
complete
100,000 of 100,000 rows by prefix; Cramér's V 1.00; purity 100.0%; 20 candidate rules
exact
agency_code and branch (length)
Category against a feature of a column
complete
100,000 of 100,000 rows by length; Cramér's V 1.00; purity 100.0%; 20 candidate rules
exact
province_code and postal_code (prefix)
Category against a feature of a column
complete
99,997 of 100,000 rows by prefix; Cramér's V 0.93 (low counts); purity 85.3%; 5 candidate rules
exact
contract_type and annual_premium
Numbers of a column by category
complete
99,981 of 100,000 rows described by 9 categories; the categories explain 33.1% of the variance (33.0% once corrected)
exact
$
Extra copies of the rows without an ID
complete
column_20: 0 extra copies among 9 rows without a value
exact
Not selected, by reason: 88 too little expected benefit for an automatic choice; 19 its CPU class is above the automatic limit; 14 too many distinct values for a table of frequencies; 14 a pattern would describe its values poorly, so the scan did not look for one; 10 the field misses no value and has too many distinct values to follow by position; 6 enough tables were already chosen automatically; 6 another feature of the same two columns says more; 2 its memory does not fit in the budget with the analyses already selected; 1 too few distinct values to infer patterns; 1 fewer than half of the values carry a currency marker, a percent sign or a unit.
The source was read again and checked against the digest of the scan, so no result mixes two versions of the data, 5.83 s. This run computed 48 analyses and reused 0 stored ones.
15 / Limits
Limits and diagnostics
What the scan could not measure completely, and the technical events it recorded. Counters and statistics continue past a limit.
Limited measures(7)
7 of 7 measures
Field
Measure
Reason
Limit
At least
last_name
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
birth_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
start_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
end_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
creation_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
modification_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
claim_date
Inferred patternsderived.patterns
max_depthscan.pattern_inference.max_depth
3
–
16 / Raw values
Data sample(30)
Rows of the scan's row sample, with original row numbers and raw values: the first records, records drawn at random from the interior and the last records. The sampled rows are not uniform over the whole file.
30 of the 1,000 rows the scan sampled (10 at the start, 10 sampled, 10 at the end) out of 100,000 records. The sampled rows come from the interior, records 51 to 99,950, where each record had the same chance by a seeded hash.
30 of 30 sample rows
Row
Part
customer_idtext
titletext
first_nametext
last_nametext
birth_datedate
gendertext
preferred_languagetext
street_numberinteger
street_typetext
street_nametext
street_directiontext
unit_numberinteger
citytext
province_codetext
province_nametext
postal_codetext
country_codetext
emailtext
phonetext
contract_idtext
contract_typetext
start_datedate
end_datedate
contract_statustext
annual_premiumnumber
payment_frequencytext
payment_methodtext
agency_codetext
creation_datedate
modification_datedate
claim_datedate
claim_amountnumber
claim_statustext
branchtext
1
Start
CLI-00000001
Ms.
Emma
Clark
1977-08-19
F
en
5612
Trail
Westwood
empty
empty
Québec
QC
Quebec
H0B 8Z6
CA
emma.clark@outlook.example
+1-200-555-0133
CTR-1000000001
home
2020-01-01
2027-02-12
active
1072.61
annual
bank_transfer
AG-PR-002
2019-12-31
2022-02-02
empty
empty
empty
main
2
Start
CLI-00000002
Mr.
Hudson
Nelson
1984-11-13
M
en
6985
Street
Pine
West
empty
Gatineau
QC
Quebec
H0E 4Y4
CA
hudson.nelson@gmail.example
+1-200-555-0185
CTR-1000000002
home
2021-12-07
2027-02-22
active
2141.16
quarterly
direct_debit
AG-PR-003
2021-11-25
2024-06-12
empty
empty
empty
main
3
Start
CLI-00000003
Mr.
Benjamin
Young
1941-03-17
M
en
4180
Drive
Silverwood
East
empty
Granby
QC
Quebec
H0V 9M7
CA
empty
+1-200-555-0140
CTR-1000000003
auto
2024-09-16
2027-03-11
active
292.15
monthly
direct_debit
AG-PR-002
2024-08-25
2026-07-23
2025-05-12
3044.92
closed
main
4
Start
CLI-00000004
Ms.
Ava
Singh
1962-03-02
F
en
7976
Boulevard
Maple
empty
empty
Saskatoon
SK
Saskatchewan
S0A 4M7
CA
ava8465@gmail.example
+1-207-555-0195
CTR-1000000004
travel
2024-09-04
2024-11-28
expired
590.50
monthly
direct_debit
AG-PR-002
2024-08-06
2026-06-25
empty
empty
empty
main
5
Start
CLI-00000005
Ms.
Aria
Smith
1987-04-08
F
en
6252
Street
Cedar
empty
empty
Alma
QC
Quebec
H1N 9R6
CA
asmith@icloud.example
+1-200-555-0126
CTR-1000000005
home
2022-02-24
2027-08-30
active
1108.61
monthly
credit_card
AG-PR-004
2022-01-30
2026-03-13
empty
empty
empty
main
6
Start
CLI-00000006
Mr.
Elias
Green
1948-08-22
M
en
7292
Place
Birch
North
empty
Terrebonne
QC
Quebec
H0M 8P9
CA
eli933@yahoo.example
+1-200-555-0148
CTR-1000000006
travel
2024-12-02
2025-02-19
expired
1192.77
monthly
direct_debit
AG-PR-001
2024-11-12
2025-04-23
empty
empty
empty
main
7
Start
CLI-00000007
Ms.
Penelope
Young
1980-07-01
F
en
7479
Court
Oak
empty
empty
Dollard-des-Ormeaux
QC
Quebec
H0Z 2J2
CA
penelopeyoung@hotmail.example
+1-200-555-0133
CTR-1000000007
home
2025-01-07
2026-11-21
active
2926.19
monthly
direct_debit
AG-PR-003
2024-12-29
2025-01-24
empty
empty
empty
main
8
Start
CLI-00000008
Ms.
Emily
Pelletier
1997-03-26
F
en
6530
Lane
Lakeview
empty
empty
Montréal
QC
Quebec
H0A 1X9
CA
emily.pelletier@gmail.example
+1-200-555-0105
CTR-1000000008
travel
2024-01-06
2024-02-26
expired
297.68
monthly
credit_card
AG-PR-001
2023-12-20
2025-03-30
empty
empty
empty
main
9
Start
CLI-00000009
Ms.
Gianna
Smith
1992-01-13
F
en
8491
Boulevard
Mountainview
empty
388
Longueuil
QC
Quebec
H0G 4K7
CA
gianna.smith@icloud.example
+1-200-555-0103
CTR-1000000009
auto
2021-09-29
2026-12-10
active
1912.29
monthly
direct_debit
AG-PR-001
2021-09-15
2026-06-09
2025-01-23
8026.55
closed
main
10
Start
CLI-00000010
Ms.
Gianna
Ward
1968-10-21
F
en
3086
Avenue
Highland
empty
empty
Lévis
QC
Quebec
H0J 0R3
CA
gia5002@bell.example
+1-200-555-0144
CTR-1000000010
auto
2023-06-20
2027-09-09
active
2585.27
quarterly
direct_debit
AG-PR-002
2023-05-21
2026-06-20
empty
empty
empty
main
3378
Sampled
CLI-00003378
Ms.
Luna
Green
1967-01-12
F
en
5907
Boulevard
Sunset
empty
empty
Saguenay
QC
Quebec
H0K 3R9
CA
empty
+1-200-555-0178
CTR-1000003378
home
2025-08-17
2026-09-02
expired
2459.26
annual
credit_card
AG-PR-002
2025-07-18
2026-08-24
empty
empty
empty
main
6473
Sampled
CLI-00006473
Ms.
Charlotte
Taylor
1998-07-23
F
en
5722
Terrace
Clearwater
empty
empty
Mississauga
ON
Ontario
K0C 4L7
CA
taylor.charlotte@gmail.example
+1-201-555-0180
CTR-1000006473
auto
2022-08-11
empty
active
3061.06
monthly
direct_debit
AG-PR-005
2022-07-17
2026-09-05
2026-07-27
empty
open
main
7809
Sampled
CLI-00007809
Ms.
Elizabeth
Lopez
2006-09-30
F
en
8979
Way
Highland
South
327
Shawinigan
QC
Quebec
H0Y 1S9
CA
elizabeth64@outlook.example
+1-200-555-0199
CTR-1000007809
auto
2026-09-10
empty
active
3081.24
monthly
direct_debit
AG-PR-001
2026-08-13
2026-09-08
empty
empty
empty
main
16792
Sampled
CLI-00016792
Ms.
Emily
Thompson
1966-08-24
F
en
4373
Street
Station
empty
344
Gatineau
QC
Quebec
H0E 3W6
CA
ethompson.4@outlook.example
+1-200-555-0198
CTR-1000016792
life
2022-05-13
2027-08-12
suspended
4890.48
monthly
credit_card
AG-PR-003
2022-05-08
2026-08-30
empty
empty
empty
main
35383
Sampled
CLI-00035383
Ms.
Ava
Li
2006-08-05
F
en
5635
Road
Hillcrest
North
empty
Mirabel
QC
Quebec
H1K 3Z5
CA
aval.2@yahoo.example
+1-200-555-0174
CTR-1000035383
auto
2024-08-05
2026-09-04
expired
2209.18
monthly
direct_debit
AG-PR-001
2024-08-05
2026-07-31
2026-07-28
2538.18
closed
main
54302
Sampled
CLI-00054302
Ms.
Madison
Lopez
1972-08-29
F
en
9
Drive
Brookside
empty
empty
Sherbrooke
QC
Quebec
H0H 9W4
CA
lopez8279@yahoo.example
+1-200-555-0108
CTR-1000054302
home
2025-09-26
2026-09-08
expired
3100.12
monthly
direct_debit
AG-PR-004
2025-09-26
2025-11-11
empty
empty
empty
main
61892
Sampled
CLI-00061892
Ms.
Riley
Campbell
1942-07-28
F
en
8388
Street
Silverwood
empty
empty
Joliette
QC
Quebec
H1J 4C9
CA
riley.campbell@icloud.example
+1-200-555-0131
CTR-1000061892
home
2019-07-17
2027-08-30
active
710.82
monthly
direct_debit
AG-PR-001
2019-07-16
2026-07-09
empty
empty
empty
main
62516
Sampled
CLI-00062516
Mr.
William
Ward
1957-03-30
M
en
9766
Crescent
Highland
East
empty
Longueuil
QC
Quebec
H0G 0E9
CA
empty
+1-200-555-0167
CTR-1000062516
home
2025-05-14
2027-01-29
active
2771.50
monthly
direct_debit
AG-PR-002
2025-04-29
2025-07-17
empty
empty
empty
main
66809
Sampled
CLI-00066809
Ms.
Sophia
Smith
1952-09-19
F
en
2194
Circle
Maple
empty
empty
Edmonton
AB
Alberta
T0B 2K9
CA
empty
+1-203-555-0137
CTR-1000066809
travel
2026-02-11
2026-03-12
expired
1143.64
monthly
credit_card
AG-PR-008
2026-02-11
2026-07-26
empty
empty
empty
main
91990
Sampled
QC-0001-0172
Mr.
Liam
Collins
09-08-1974
M
en
4568
Drive
Oak
empty
512
Granby
QC
Quebec
H0V 7E9
CA
lcollins.5@outlook.example
+1-200-555-0114
CTR-3000010172
auto
30-07-2020
17-10-2026
active
992.46
quarterly
direct_debit
AG-QC-005
15-07-2020
20-02-2023
empty
empty
empty
quebec
99991
End
QC-0001-8173
Mr.
Mason
Evans
16-03-1960
M
en
4652
Avenue
Hillcrest
empty
599
Drummondville
QC
Quebec
H0S 6C1
CA
mason_evans@outlook.example
+1-200-555-0183
CTR-3000018173
home
30-09-2017
07-05-2027
active
3410.59
annual
direct_debit
AG-QC-005
27-09-2017
26-01-2023
empty
empty
empty
quebec
99992
End
QC-0001-8174
Ms.
Olivia
Morris
29-03-1940
F
en
5035
Way
Cedar
empty
empty
Sainte-Julie
QC
Quebec
H1X 3V9
CA
oliviam.2@hotmail.example
+1-200-555-0195
CTR-3000018174
life
30-07-2019
10-11-2024
expired
7050.34
monthly
credit_card
AG-QC-001
08-07-2019
07-01-2022
empty
empty
empty
quebec
99993
End
QC-0001-8175
Ms.
Aria
Smith
26-05-1961
F
en
1631
Street
Birch
empty
empty
Salaberry-de-Valleyfield
QC
Quebec
H1G 4T9
CA
aria.smith.8@gmail.example
+1-200-555-0126
CTR-3000018175
auto
28-01-2025
22-12-2026
active
2109.46
monthly
credit_card
AG-QC-002
31-12-2024
05-08-2026
empty
empty
empty
quebec
99994
End
QC-0001-8176
Mr.
Daniel
King
30-06-1965
M
en
9150
Avenue
Willow
North
empty
Laval
QC
Quebec
H0C 0G9
CA
daniel.king.2@icloud.example
+1-200-555-0131
CTR-3000018176
travel
24-05-2025
12-08-2025
expired
234.26
monthly
direct_debit
AG-QC-003
16-05-2025
23-06-2025
empty
empty
empty
quebec
99995
End
QC-0001-8177
Ms.
Willow
Thompson
21-07-1965
F
en
1150
Street
Birch
empty
empty
Longueuil
QC
Quebec
H0G 1G4
CA
willow.thompson@gmail.example
+1-200-555-0132
CTR-3000018177
home
09-05-2018
09-06-2027
active
3445.06
quarterly
credit_card
AG-QC-004
06-05-2018
24-10-2020
06-04-2019
15049.99
closed
quebec
99996
End
QC-0001-8178
Ms.
Avery
Anderson
23-11-1970
F
en
9256
Avenue
Cedar
North
936
Gatineau
QC
Quebec
H0E 3M5
CA
averyanderson@gmail.example
+1-200-555-0169
CTR-3000018178
life
05-08-2023
26-05-2027
active
7059.96
monthly
direct_debit
AG-QC-001
19-07-2023
22-04-2024
empty
empty
empty
quebec
99997
End
QC-0001-8179
Ms.
Sophia
Collins
12-10-1992
F
en
9476
Place
Southridge
East
empty
Rouyn-Noranda
QC
Quebec
H1E 4S6
CA
scollins.9@gmail.example
+1-200-555-0191
CTR-3000018179
auto
08-05-2020
empty
active
1902.48
monthly
credit_card
AG-QC-004
25-04-2020
03-06-2021
empty
empty
empty
quebec
99998
End
QC-0001-8180
Mr.
Lucas
White
08-12-1994
M
en
6596
Lane
Sunset
empty
994
Montréal
QC
Quebec
H0A 1H3
CA
lucas38@outlook.example
+1-200-555-0131
CTR-3000018180
life
19-09-2019
06-03-2024
expired
1039.38
annual
direct_debit
AG-QC-001
03-09-2019
27-06-2022
empty
empty
empty
quebec
99999
End
QC-0001-8181
Ms.
Nova
Singh
05-03-2001
F
en
499
Street
Greenfield
empty
empty
Gatineau
QC
Quebec
H0E 2W7
CA
nova-singh@yahoo.example
+1-200-555-0115
CTR-3000018181
life
05-05-2022
01-05-2027
active
1364.34
monthly
direct_debit
AG-QC-003
23-04-2022
09-09-2023
empty
empty
empty
quebec
100000
End
QC-0001-8182
Mr.
Lucas
Smith
26-12-1970
M
en
9316
Drive
Rosewood
empty
416
Saguenay
QC
Quebec
H0K 7P1
CA
lucas72.2@yahoo.example
+1-200-555-0152
CTR-3000018182
life
15-09-2017
18-05-2027
active
852.38
monthly
direct_debit
AG-QC-006
02-09-2017
24-01-2025
empty
empty
empty
quebec
Empty cellMixed-type column
17 / Method
Analysis settings
Rules used for this analysis, so the result can be reproduced.
Unicode composition (NFC): enabled; trim: enabled; collapse internal whitespace: enabled; comparison also with case folding: enabled, accents removed: enabled. Raw preview values are preserved.
Duplicate comparison
Exact raw values across every column; up to 2,000,000 distinct records compared
Type inference
At least 95.0% agreement across present values; numbers with dot or comma decimals, configured dates and true/false. Leading-zero identifiers remain text.
Date detection
Orders: YMD, MDY, DMY; separators: "-""/""." ; month names: en, fr; ambiguous order: unresolved, column evidence shown but never applied
Column types
The technical type, a detector matching at least 95.0% of present values, the length of the texts, the name of the column and, when the second pass counted them, the exact distinct values
Adaptive detection
Every detector on the first 10,000 distinct values of each column; detectors that recognized none of them, or at most 0.1% of them and none of the last 5,000, then skip the others, except about 1 value in 100. Number and date detection always test every value
Enumerations
At most 49 distinct values among at least 500 present values
Sensitive values
Shown in examples and the data sample
String lengths
Very short through 5; short through 20; medium through 50; long through 255; otherwise very long. Up to 10 examples per length are retained when the maximum is 50 or less.
Value representation
Complete through 50 distinct values; otherwise a reproducible sample of up to 100 distinct values, the ones with the smallest hash priorities
Row numbering
Data records start at 1, excluding the header. Quoted multiline values count as one record.
Row sample
The scan kept the first 50 records, up to 900 records drawn from the interior by a seeded hash, and the last 50; this report shows 10 at the start, 10 sampled and 10 at the end; raw values preserved
Patterns
Inferred from the sampled distinct values: up to 128 per column, values up to 64 characters, at least 2 distinct values per pattern
Observations
Rules version 2; at most 1,000 findings and 1,000 limits listed
Identifier uniqueness
Rule version 1, 2 columns. Exact duplicate rows read from the Scan's comparison of whole records. Copies of the rows without an ID counted by the second pass. The qualification reads no data and does not run Dedup.