Character set distribution (CUSTOMERNAME,CONTACTLASTNAME,CONTACTFIRSTNAME)

CUSTOMERNAMECONTACTLASTNAMECONTACTFIRSTNAME
Arabic000
Armenian000
Bengali000
Cyrillic000
Devanagari000
Georgian000
Greek000
Gujarati000
Gurmukhi000
Han000
Hangul000
Hebrew000
Hiragana000
Kannada000
Katakana000
Latin, ASCII133133133
Latin, non-ASCII833
Malayalam000
Oriya000
Syriac000
Tamil000
Telugu000
Thaana000
Thai000

Date/time analyzer (ORDERDATE,SHIPPEDDATE,REQUIREDDATE)

ORDERDATESHIPPEDDATEREQUIREDDATE
Row count326326326
Null count0140
Highest date2005-05-312005-05-202005-06-11
Lowest date2003-01-062003-01-102003-01-13
Highest time00:00:00.00000:00:00.00000:00:00.000
Lowest time00:00:00.00000:00:00.00000:00:00.000

Number analyzer (CUSTOMERNUMBER,SALESREPEMPLOYEENUMBER,CREDITLIMIT)

CUSTOMERNUMBERSALESREPEMPLOYEENUMBERCREDITLIMIT
Row count133133133
Null count0263
Highest value4961,702227,600
Lowest value103-1-1
Sum40,083144,6958,588,498
Mean301.3761,352.2966,065.369
Geometric mean276.34
Standard deviation118.591282.69947,875.4
Variance14,063.88879,918.6232,292,053,941.816

Reference data matcher (COUNTRY)

COUNTRY in 'Country names'COUNTRY in Country code (2 letter)COUNTRY in Country code (3 letter)
Row count133133133
Null count100
True count8612894
False count46539
COUNTRY in 'Country names'COUNTRY in Country code (2 letter)COUNTRY in Country code (3 letter)Frequency
Most frequent11186
Combination 101035
Combination 20117
Combination 30003
Combination 4<null>001
Least frequent0011

Date gap analyzer (ORDERDATE,SHIPPEDDATE)

Total date gap count 77

Pattern finder (PHONE)

Match countSample
9999999999387025551838
9999-9999999190372-555188
(999) 999-999911(171) 555-1555
+999 999 9999 999911+81 06 6342 5555
+999 9999 99999999+612 9411 1555
99999999.9940.32.2555
99 9999 9999531 12 3555
(999) 999 99 99994(91) 555 94 44
9999-999 9999490-224 8555
(99) 9999 99993(93) 203 4555
+99 99 999 99 99993+49 69 66 90 2555
+99 9999999993+45 32928812
(9) 99999999.92(1) 42.34.2555
99-9-9999-9999261-7-3844-6555
9999 99999920711 555361
+99 99 99 99 99991 +49 89 61 08 9555
(99) 99999991(91) 5559444
+ 999 9 999 99991+ 972 9 959 8555
99-9-9999999164-9-3763555
a/a1n/a

Value distribution (STATE)

CA12
MA9
NY6
4
CT4
PA3
Victoria2
NSW2
BC2
Total count133
Distinct count21
Unique count11
Null count78

Value distribution (CITY)

Madrid6
NYC5
Brickhaven3
Auckland3
Paris3
Glendale3
Singapore3
2
Lisboa2
Nantes2
San Francisco2
Cambridge2
Frankfurt2
New Haven2
London2
Philadelphia2
27002
New Bedford2
Kobenhavn2
Boston2
Stuttgart2
Total count133
Distinct count100
Unique count79
Null count0

Weekday distribution (ORDERDATE,SHIPPEDDATE,REQUIREDDATE)

ORDERDATESHIPPEDDATEREQUIREDDATE
Sunday114734
Monday504744
Tuesday564743
Wednesday643754
Thursday594953
Friday693951
Saturday174647