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

Provider network, flag “Date of birth unreadable”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-20003PRVShirley Hernandez——46077387961513 Baseline Rd, Eden Prairie, MN, 553410.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23749PRVJennifer E Wattson——89071403899725 Harbor Blvd, Tucson, AZ, 857830.66Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+1 more
PRV-27317PRVBetty P Wang——37350192812663 Park Pl, Glendale, AZ, 853350.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23568PRVHarold U Rogers—UHC-54307-354666518737955 Lake View Rd, Eden Prairie, MN, 553010.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21164PRVAhmed Y Perez——96622424433435 Broadway, Sacramento, CA, 958110.66Name split from “Last, First”Date of birth unreadableCity re-casedWhitespace trimmed+1 more
PRV-24828PRVJonathan Weaver——86893331577790 Park Pl, Nashville, TN, 372210.66Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+1 more
PRV-25724PRVLisa Hudson—UHC-49171-42719276323619 Broadway, Phoenix, AZ, 850680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
PRV-20118PRVWilliam G Burton——39086480157872 Main St, Nashville, TN, 372240.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20145PRVLawrence Sanchez—UHC-61874-0722370782936912 Baseline Rd, Tucson, AZ, 857160.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22943PRVRonald A Scott—UHC-68475-54—9242 Grand Ave, Phoenix, AZ, 850100.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21323PRVKenneth Jordan————0.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-25696PRVTheresa A McDonald——7657923963—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-24047PRVGary P Coopeer——95726743227995 Sage Ct, Atlanta, GA, 303210.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27806PRVDnise Santos—UHC-49411-48—5029 Jefferson Ave, Columbus, OH, 432550.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24109PRVJonathan Peterson—UHC-80951-2486684926213469 Spring St, Plano, TX, 750190.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
PRV-23333PRVSantiago Miller——9432530574—0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-29271PRVKevin Washington—UHC-24205-7849677257397626 Ridge Rd, Plano, TX, 750460.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-29366PRVBrittany D Shaw——50761705626327 Ridge Rd, Denver, CO, 802990.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28991PRVJudith Morgan—UHC-85227-494493674179112 Meadow Ln # 869, Chandler, AZ, 852230.70Date of birth unreadableUnit split from streetPlaceholder values cleared
PRV-22312PRVDenise Q Lane——38636161408532 Sage Ct, Houston, TX, 770410.70Middle initial moved out of first nameDate of birth unreadablePlaceholder values cleared
PRV-25750PRVJeremy H Gomez—UHC-62554-77—5315 Mesa Dr, Minneapolis, MN, 554620.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
PRV-21757PRVJosse Ruiz——90066027471145 Mountain View Dr, Sacramento, CA, 958990.72Name split from “Last, First”Date of birth unreadable
PRV-28472PRVKeith Millre—UHC-21541-75——0.72Date of birth unreadableSSN last four extracted
PRV-21133PRVJudy Gomez—UHC-18172-2994025049718411 Canyon Rd, Orlando, FL, 328400.76Name re-casedDate of birth unreadablePhone reformattedEmail lower-cased+2 more
PRV-25674PRVPat I Howard—UHC-28807-9393086864007671 Sunset Blvd, Minneapolis, MN, 554990.78Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+1 more
PRV-27994PRVLawrence Fuller——9783604569—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-23181PRVJimmy Watkins—UHC-77031-08—3160 Union St, Austin, TX, 787160.78Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed+1 more
PRV-27001PRVVigrinia Maldonado——88463018124553 Main St, Sacramento, CA, 958890.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
PRV-28126PRVSharon Maldonado—UHC-48917-9347869936187013 Meadow Ln, Tucson, AZ, 857550.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-26710PRVArjun J Carter——88559560459536 Sunset Blvd, Tampa, FL, 336070.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-28633PRVDiego Harveey——6824100692—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-22005PRVLarry S Gibson—UHC-74898-559375549069—0.78Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+1 more
PRV-26578PRVHenry Burton——6458435996—0.78Name re-casedDate of birth reformattedDate of birth unreadableEmail lower-cased+1 more
PRV-21065PRVMei O Matthews—UHC-74503-34——0.78Name re-casedDate of birth unreadablePlan code upper-casedWhitespace trimmed+1 more
PRV-24246PRVDonna Welch—UHC-78754-725074405110—0.78Date of birth reformattedDate of birth unreadablePhone reformattedEmail lower-cased+1 more
PRV-23387PRVAlice Freeman—UHC-80293-638738938397—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
PRV-25191PRVElizabeth R Fisher——34068189838427 Main St, Jacksonville, FL, 322600.78Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed+1 more
PRV-25398PRVTerry A Medina——51843300479633 Sage Ct, Eden Prairie, MN, 553160.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
PRV-22169PRVRachel Watson—UHC-77213-1135128691841928 Camelback Rd, San Diego, CA, 921320.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
PRV-20899PRVAustin Hughes—UHC-81540-494454953335138 Meadow Ln, Eden Prairie, MN, 553080.80Date of birth unreadableMember ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-26769PRVBetty Gardner—UHC-30425-6728230985237139 Lake View Rd, Fresno, CA, 937630.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
PRV-22578PRVNathan W Bennett——9715566125—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-20712PRVAustin Z Palmer—UHC-12179-4295467476948866 Hillcrest Rd, Minneapolis, MN, 554980.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-22165PRVJoyce Thompson——78289465262819 Pine Dr, Fresno, CA, 937210.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-27760PRVMariana Hamilton——8583358665—0.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
PRV-28748PRVKevin Guzman——2788808571—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28935PRVDaniel Turner—UHC-52643-654509372554—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-28535PRVJocye Baker——6037111101—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24768PRVSandra O Campbell——57264508168853 Hillcrest Rd, Tampa, FL, 336780.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-21383PRVAngela Kennedy———890 Forest Ave, Dallas, TX, 752390.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
213 rows, page 4 of 5PreviousNext