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

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

AllENRCLMTPAPRV
Junk onlyFlagDate of birth unreadableClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-123090ENRGloria M Dixon—UHC-62207-61—1423 Oak St, Mesa, AZ, 852310.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
ENR-108649ENRDouglas F Garza—UHC-82645-4827342761341168 Cedar Ln, Phoenix, AZ, 850690.68Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased
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
ENR-122239ENRWilliam Wallace—UHC-76716-5866236317827044 Union St, Tempe, AZ, 852700.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
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
ENR-138679ENRNatalie Weber—UHC-23318-2551544461433991 Hillcrest Rd, Fresno, CA, 937680.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
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
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
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)
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
ENR-109501ENRKathherine P Banks—UHC-70406-862036048422914 Willow Ct, Tucson, AZ, 857590.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-125237ENRRuth F Burns—UHC-98377-5967624639808130 Broadway, Austin, TX, 787450.68Name re-casedDate of birth unreadablePhone reformattedGender normalised
ENR-123435ENRStephanie B Hunt—UHC-45656-20—4313 Canyon Rd, Plano, TX, 750230.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-140663ENRKayla Talor—UHC-97205-6346764057914019 Grand Ave, Los Angeles, CA, 900980.68Name split from “Last, First”Date of birth unreadableEmail lower-casedWhitespace trimmed
ENR-110826ENRBilly Olson—UHC-87272-66—8096 River Rd, Mesa, AZ, 852590.68Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased
ENR-142882ENRBenjamin Olson—UHC-43567-80—3921 Lincoln Way, Jacksonville, FL, 322780.68Name re-casedDate of birth unreadablePhone missing area codeWhitespace trimmed
ENR-135788ENRDouglas Edwards—UHC-70622-6340899104901861 Bayshore Dr, Sacramento, CA, 958880.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
ENR-132895ENRAmber Lawson—UHC-33070-4332051548966226 Indian School Rd, Orlando, FL, 328720.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
ENR-105926ENRHenry Y Little—UHC-90229-5447777834286925 Hillcrest Rd, Plano, TX, 750170.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-122348ENRKen Henry—UHC-27427-7352455426234427 Forest Ave, Dallas, TX, 752080.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
ENR-131593ENRGregory X Price—UHC-11694-5867528182213676 Harbor Blvd, Tampa, FL, 336990.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
ENR-117518ENRWayne Torres—UHC-04022-43—5701 Willow Ct, Jacksonville, FL, 322360.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-142554ENRJessica Butler—UHC-65037-6184850216711637 Sage Ct, Plano, TX, 750500.70Date of birth unreadableGender normalisedWhitespace trimmed
ENR-108451ENRLinda R Russell—UHC-28519-5938439665849542 Camelback Rd, Miami, FL0.70Name re-casedDate of birth unreadableZIP missing
ENR-106898ENRJeff Oliver—UHC-68483-4859796213315314 Camelback Rd, Mesa, AZ, 852640.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
ENR-109973ENRLori Washington—UHC-14542-7883630528135031 Hillcrest Rd, Nashville, TN, 372690.70Date of birth unreadablePhone reformattedZIP+4 trimmed
ENR-113505ENRMelissa M Gilbert—UHC-21771-5531944823454068 Main St, San Diego, CA, 921610.70Date of birth unreadablePhone reformattedState name converted to code
ENR-133504ENRRachel Griffin—UHC-00904-3871282653863033 Camelback Rd, Tampa, FL, 336430.70Name re-casedDate of birth unreadableGender normalised
ENR-119538ENREvelyn Alvarado—UHC-71311-5123845761759250 Lincoln Way, Plano, TX, 750770.70Name split from “Last, First”Date of birth unreadableWhitespace trimmed
ENR-105309ENRAbbby J Andrews—UHC-48013-488794888751499 Lincoln Way, Minneapolis, MN0.70Date of birth unreadableZIP missingWhitespace trimmed
ENR-106148ENRPamela E Romero—UHC-33943-256897955953647 Lincoln Way, Chandler, AZ, 852520.70Name split from “Last, First”Date of birth unreadablePhone reformatted
ENR-137549ENRMarcus Black—UHC-60758-2550461574702200 Apache Blvd, Fresno, CA, 937430.70Date of birth unreadableStreet suffix standardisedAddress re-cased
ENR-122033ENRSarah Chapman—UHC-93677-085957811650263 Ridge Rd, Austin, TX, 787790.70Date of birth unreadablePhone reformattedState name converted to code
ENR-132447ENRGerald Burns—UHC-01240-2028298173487906 Palm Dr, Houston, TX, 770470.70Date of birth unreadablePhone reformattedGender normalised
ENR-140630ENRKimberly Y Wright—UHC-39402-3092962411684002 Market St, Nashville, TN, 372710.70Date of birth unreadablePhone reformattedState name converted to code
ENR-131754ENRDaniel G Coleman—UHC-12741-89—2517 Bayshore Dr, Eden Prairie, MN, 553200.70Date of birth unreadableSSN last four extractedPlaceholder values cleared
ENR-105157ENRVirginia F Howard—UHC-72367-0670430753519844 Sunset Blvd, Glendale, AZ, 853830.70Name re-casedDate of birth unreadableState name converted to code
ENR-100945ENRMatthew Y Johnston—UHC-88998-4847847797875468 Market St, Columbus, OH, 432680.70Date of birth unreadableStreet suffix standardisedAddress re-cased
ENR-138300ENRRachel B Morrison—UHC-19461-2674659326209587 Elm St, Columbus, OH, 432840.70Date of birth unreadablePhone reformattedSSN last four extracted
ENR-133120ENRRyan S Ruiz—UHC-53770-8467061447071962 Central Ave, Minneapolis, MN, 554690.70Date of birth unreadableStreet suffix standardisedAddress re-cased
ENR-116785ENREric K Bell—UHC-12364-05—5298 Highland Ave, Los Angeles, CA, 900270.72Date of birth unreadableGender normalised
991 rows, page 16 of 20PreviousNext