Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

All sources, flag “Date of birth unreadable”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-20417PRVSarra Gomez——6536545230—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
PRV-28516PRVNatalie Walsh————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-110201ENRSantiago Q Olson—UHC-28731-6163472645699184 Camelback Rd, Austin, TX, 787360.82Name re-casedDate of birth unreadableWhitespace trimmed
CLM-430628CLMBarbara Stevens—UHC-77280-77——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-113562ENRWillie Mejia—UHC-65942-1323029386812372 Meadow Ln, Dallas, TX, 752590.82Date of birth unreadablePhone reformattedWhitespace trimmed
CLM-426996CLMHarold Matthews—UHC-47451-76—1371 Elm St, Nashville, TN, 372120.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-135086ENRDoris Little—UHC-78387-3497272156635197 Central Ave, Orlando, FL, 328140.82Name re-casedDate of birth unreadableWhitespace trimmed
ENR-135087ENRDoris Little—UHC-78387-3497272156635197 Central Ave, Orlando, FL, 328140.82Name re-casedDate of birth unreadableWhitespace trimmed
ENR-104391ENRDorothy W Rogers—UHC-06003-663407199887—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-119846ENRAmber Burns—UHC-27318-1292181022967470 Lincoln Way, Chandler, AZ, 852410.82Name re-casedDate of birth unreadablePhone reformatted
CLM-423357CLMBilly Fisher—UHC-80053-219354351554—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-114853ENRCheryl V Payne—UHC-07886-2269585066997084 Apache Blvd, Scottsdale, AZ, 852890.82Date of birth unreadablePhone reformattedMember ID reformatted
TPA-53287TPATeresa Hansen———5250 Jefferson Ave, Minneapolis, MN, 554620.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-420569CLMWillie Broosk—UHC-95252-31——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-405513CLMKathryn Y Lawson—UHC-96469-234396118559—0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-142526ENRHiroshi B Russell—UHC-16259-545902349183203 Oak St, Phoenix, AZ, 850300.82Name re-casedDate of birth unreadablePhone reformatted
CLM-416584CLMLarwence Morgan—UHC-20131-538245494912—0.82Name re-casedDate of birth unreadablePhone reformatted
CLM-422696CLMArthur Rios—UHC-05334-7743034023358018 Elm St, Glendale, AZ, 853350.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-60556TPAChuck Cook——89075721887669 Hillcrest Rd, Orlando, FL, 328120.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-409067CLMStephen U Scott——23129463323297 Forest Ave, Austin, TX, 787980.82Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-29475PRVPaul Nguyen——7706210767—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-411128CLMNicole Hughes—UHC-13273-39——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-64334TPAIsabella Gordon———752 Mountain View Dr, Los Angeles, CA, 900620.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-55658TPAKathryn Lawrence——40576601116151 Broadway, Columbus, OH, 432270.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-128778ENRLauren J Willis—UHC-41715-6882982382329796 Park Pl, Glendale, AZ, 853380.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-62628TPAMariana K Hanry————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-402250CLMCharlotte W Alvarez—UHC-27907-2824638060055621 Pine Dr, Sacramento, CA, 958270.82Date of birth unreadablePhone reformattedMember ID reformatted
CLM-409873CLMDiane Johnson—UHC-39148-39—2253 Broadway, Tucson, AZ, 857450.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-113429ENRBenjamin F Ferguson—UHC-84231-8984772934582793 Apache Blvd, Chandler, AZ, 852360.82Name re-casedDate of birth unreadablePhone reformatted
TPA-59284TPAArtthur Chavez——4288386557—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-410314CLMDonna O Hoffman—UHC-23819-12——0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-62440TPAJerry Willimason—UHC-31382-25—4925 Jefferson Ave, Chandler, AZ, 852330.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-403048CLMElizabeth Martin—UHC-63125-78—1405 Canyon Rd, Jacksonville, FL, 322680.82Date of birth unreadableCity re-casedPlaceholder values cleared
ENR-104958ENRScott G Schultz—UHC-40594-6843249355166925 Bayshore Dr, Tampa, FL, 336990.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-126650ENRSen G Munoz—UHC-30839-329802167970—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-400898CLMDennis K Kelley—UHC-12201-1755752340019006 Main St, San Diego, CA, 921120.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-431013CLMElizabeth Ross—UHC-90424-31——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-404359CLMRachel Payne————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-123159ENRBeverly Hicks—UHC-10140-65—3610 Bayshore Dr, Houston, TX, 770400.82Date of birth unreadableEmail lower-casedWhitespace trimmed
CLM-407066CLMBrenda Wells——3667773249—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
ENR-142652ENRJulie K Romero—UHC-01895-1821256373775688 Highland Ave, San Antonio, TX, 782290.82Date of birth unreadablePhone reformattedWhitespace trimmed
ENR-120807ENRChares Walker—UHC-36240-3643358989972543 Oak St, Orlando, FL, 328280.82Name re-casedDate of birth unreadableWhitespace trimmed
TPA-55248TPABarbara Marshall———4996 Central Ave, Jacksonville, FL, 322010.82Date of birth unreadableCity re-casedPlaceholder values cleared
TPA-54743TPABenjamin Turner——3579393116—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-414607CLMBobby V Myers———1221 Park Pl, Tucson, AZ, 857070.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-424366CLMBetty Scott—UHC-50628-3627466978393319 Washington St, Plano, TX, 750060.82Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-26382PRVRobert Walsh—UHC-24675-769523490553984 Forest Ave, Sacramento, CA, 958120.82Date of birth unreadableEmail lower-casedPlaceholder values cleared
CLM-420745CLMSusan Vazquez—UHC-65517-83——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
CLM-420746CLMSusan Vazquez—UHC-65517-83——0.82Name re-casedDate of birth unreadablePlaceholder values cleared
ENR-116730ENRHarold P Patterson—UHC-04603-363754075325226 Harbor Blvd, San Antonio, TX, 782600.82Date of birth unreadablePhone reformattedWhitespace trimmed
2,274 rows, page 44 of 46PreviousNext