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
CLM-409406CLMOlivia Campbell——6424320170—0.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-51511TPASharon Boyd———4822 Camelback Rd, Minneapolis, MN, 554710.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-134621ENRJack A Sullivan—UHC-56237-02——0.68Name re-casedDate of birth unreadablePhone missing area codePlaceholder values cleared
ENR-112962ENRAnn Ferguson—UHC-90827-1245974377972004 Pine Dr, Scottsdale, AZ, 852080.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-422974CLMMelissa Owens—UHC-20322-63—7251 Sunset Blvd, San Antonio, TX, 782220.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407058CLMBenjamin Yang—UHC-59355-41—8627 Washington St, Phoenix, AZ, 850840.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-426371CLMHeather Pena——91555613406554 Baseline Rd, Tucson, AZ, 857080.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413284CLMJon I Pierce—UHC-45594-56—4558 Ocean Ave, Chandler, AZ, 852370.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54756TPAAlbert Santos——66597909402953 Union St, Chandler, AZ, 852210.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder 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
CLM-410193CLMChristina Burton—UHC-38322-16——0.68Date of birth unreadableMember ID reformattedGender normalisedPlaceholder values cleared
TPA-57538TPARussell Matthews——9684397875—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-420104CLMAshley Park—UHC-77999-99——0.68Name re-casedDate of birth unreadablePhone missing area codePlaceholder values cleared
ENR-122239ENRWilliam Wallace—UHC-76716-5866236317827044 Union St, Tempe, AZ, 852700.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-403713CLMDiana Meeyer—UHC-82280-7590751980265374 Sunset Blvd, Tucson, AZ0.68Date of birth unreadablePhone reformattedZIP missingPlaceholder values cleared
CLM-428224CLMKaren Fisehr—UHC-80767-69—3938 Camelback Rd, Austin, TX, 787300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-142013ENRHannah Patterson—UHC-40407-99——0.68Date of birth unreadablePhone missing area codeEmail lower-casedWhitespace trimmed
ENR-142987ENRFrances Ruiz—UHC-64484-5343246876305275 Oak St, Phoenix, AZ, 850270.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-404644CLMSean C Torres———1225 Park Pl, Las Vegas, NV, 891210.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-409943CLMGerald Carpenter—UHC-74053-6359490285406030 Meadow Ln, Tucson, AZ, 857720.68Date of birth unreadableSSN last four extractedCity re-casedPlaceholder values cleared
TPA-57218TPACastro Priya——84832562711086 Oak St, Seattle, WA, 981560.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-423661CLMAndrew U Nunez—UHC-64434-62—9834 Elm St # 965, Austin, TX, 787930.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
ENR-138679ENRNatalie Weber—UHC-23318-2551544461433991 Hillcrest Rd, Fresno, CA, 937680.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
TPA-53269TPAJoseph C King——70383629469130 Broadway, Jacksonville, FL, 322900.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-59850TPASara Matthews————0.68Name re-casedDate of birth unreadableSSN last four extractedPlaceholder values cleared
CLM-432151CLMTimothy Nunez—UHC-87616-0671092596993333 Church St, Los Angeles, CA, 900150.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-55700TPAJanice Hunt——85690034045192 Lincoln Way, Charlotte, NC, 282680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
ENR-140727ENRElizaeth Ross—UHC-90424-31——0.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
ENR-101280ENRJames N Evans—UHC-88818-5668677463907651 Palm Dr, Nashville, TN, 372360.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-110824ENRMadison W Lopez—UHC-62337-0148131029843579 Willow Ct, Miami, FL, 331040.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-104079ENRYuki Morrison—UHC-46933-33581379910179 Cedar Ln, Tampa, FL, 336820.68Date of birth unreadableZIP+4 trimmedEmail lower-casedPlaceholder values cleared
PRV-23333PRVSantiago Miller——9432530574—0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-122468ENREugene Vega—UHC-77351-2776839688758100 Mesa Dr, Tampa, FL, 336270.68Date of birth unreadablePhone reformattedZIP+4 trimmedWhitespace trimmed
ENR-130678ENRAmber Willis—UHC-07211-0680494323139561 Mountain View Dr, Sacramento, CA, 958480.68Date of birth reformattedDate of birth unreadableGender normalisedWhitespace trimmed
ENR-102729ENRKevin G Nelson—UHC-08394-2382341310247386 Market St, Dallas, TX, 752690.68Middle initial moved out of first nameDate of birth unreadableCity re-casedPlan code upper-cased
TPA-50389TPAMarcus Wallace———7455 Palm Dr, Plano, TX, 750300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
ENR-142821ENREdwrd O Wright—UHC-92029-257768038757758 Lincoln Way, Phoenix, AZ, 850240.68Date of birth unreadablePhone reformattedState name converted to codeWhitespace trimmed
ENR-129051ENRJulia EJunk—UHC-52748-0632653323724899 Elm St, Tampa, FL, 336400.68Date of birth unreadablePhone reformattedWhitespace trimmedNo usable name (quarantined)
CLM-411337CLMMargaret Roberts————0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-139148ENRLisa K Stevens—UHC-13790-1364763788288250 Highland Ave, Chandler, AZ, 852050.68Date of birth unreadableCity re-casedGender normalisedWhitespace trimmed
ENR-106735ENRMargaret U Ward—UHC-09444-6969278133909749 Oak St, Nashville, TN, 372060.68Date of birth unreadablePhone reformattedState name converted to codeWhitespace trimmed
TPA-56904TPAGeorge F Salazar———1928 Palm Dr, San Antonio, TX, 782720.68Name re-casedDate of birth unreadableGender normalisedPlaceholder values cleared
ENR-109501ENRKathherine P Banks—UHC-70406-862036048422914 Willow Ct, Tucson, AZ, 857590.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-426848CLMHannah Martin—UHC-93034-52—483 Central Ave, Plano, TX, 750190.68Date of birth unreadableCity re-casedGender normalisedPlaceholder values cleared
ENR-125237ENRRuth F Burns—UHC-98377-5967624639808130 Broadway, Austin, TX, 787450.68Name re-casedDate of birth unreadablePhone reformattedGender normalised
TPA-59354TPARandy L Lawrence———9077 Oak St, Las Vegas, NV, 891310.68Name re-casedDate of birth unreadableZIP+4 trimmedPlaceholder values cleared
CLM-428176CLMGreg Rosse—UHC-54198-54——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-428175CLMGreg Rosse—UHC-54198-54——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-29271PRVKevin Washington—UHC-24205-7849677257397626 Ridge Rd, Plano, TX, 750460.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
2,274 rows, page 34 of 46PreviousNext