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

Third-party administrator, flag “Date of birth reformatted”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth reformattedClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58766TPARonald Burton———8308 Washington St, Denver, CO, 802430.82Date of birth reformattedDate of birth unreadablePlaceholder values cleared
TPA-58533TPAAdam Wheeler1950-10-17———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50448TPAArjun McCoy1954-10-07——2077 Spring St, Dallas, TX, 752470.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-61689TPAMargaret F Weaver1989-04-17UHC-13952-43——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59485TPABradley Rogers1987-12-20——8042 Pine Dr, Seattle, WA, 981690.82Date of birth reformattedState code upper-casedGender normalised
TPA-50064TPAJennifer Cole1962-10-12—63965727175396 Elm St, Charlotte, NC, 282310.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-54006TPAOlivia Ramos1998-07-18———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-56753TPAArjun Hart1977-06-09——4075 Lincoln Way, Miami, FL, 331870.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54261TPALinda Matthews2000-05-27——5828 Baseline Rd, Tampa, FL, 336930.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-55170TPAMelissa J Jordan1981-10-21——1628 Central Ave, Mesa, AZ, 852350.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-62119TPAMariana N Rios1939-03-01—47664929818891 Pine Dr, Tampa, FL, 336240.82Middle initial moved out of first nameDate of birth reformattedPlaceholder values cleared
TPA-51657TPAJesse Alvarez1939-04-07——8496 Harbor Blvd, Scottsdale, AZ, 852710.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-54555TPASteven Scott1953-04-17———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57402TPAElijah Tucker1958-10-28—98236459186906 Harbor Blvd, Plano, TX, 750550.82Date of birth reformattedPhone reformattedState name converted to code
TPA-62449TPAKevin Matthews1965-08-15———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-53643TPACamila Williams1956-07-24UHC-48033-98—9110 Mesa Dr Apt 3, Sacramento, CA, 958470.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-57779TPALauren Stevens1963-09-02———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-53760TPAYuki Gibson2005-09-19—30845094054005 Main St, Glendale, AZ, 853460.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52145TPAMargaret Gonzalez2005-07-08———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52920TPAJoe Stephens2008-02-05———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59903TPALori Wang1973-04-24———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-62518TPAMegan Maldonado1998-02-15———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-58074TPADenise Ward1959-07-06—96943747728358 Lake View Rd, Miami, FL, 331130.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59804TPABetty Black2008-06-15—83458405735994 Highland Ave, Charlotte, NC0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-51045TPAKeith Price1986-07-18—48957285989495 Palm Dr, Austin, TX, 787490.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-55764TPAChristopher Ward1976-10-01UHC-13167-68—886 Jefferson Ave, San Diego, CA, 921780.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-64059TPADaniel Wright1993-01-04——3838 Lincoln Way, Las Vegas, NV, 891670.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-61285TPAAdam Edwards1967-10-25—56628147585370 Central Ave, Chandler, AZ0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-52355TPASean Collins1995-06-27UHC-91688-56—3968 Elm St, Chandler, AZ, 852060.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-52495TPAVictoria Evans1994-03-26—21180741339661 Forest Ave, Houston, TX, 770680.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-62857TPABenjamin Thompson1990-07-25——6807 Canyon Rd, Denver, CO, 802180.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-60948TPAChristopher Contreras1951-12-19———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-56857TPACharles Matthews1952-05-12——8323 Market St, Los Angeles, CA, 900800.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-64203TPAKelly Gutierrez1990-10-16——6693 Maple Ave, Las Vegas, NV, 891230.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-60920TPADaniel Elliott1941-12-11——4953 Washington St, Eden Prairie, MN, 553700.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-57578TPAAmber Harvey1998-10-18UHC-45573-3672662566626154 Main St, Dallas, TX0.82Date of birth reformattedMember ID reformattedZIP missing
TPA-57430TPATerry Rychardson1984-07-04UHC-96410-44—6145 Park Pl, San Antonio, TX, 782860.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-60231TPAMichelle Mendez1967-12-20——1553 Hillcrest Rd, Sacramento, CA, 958200.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54732TPAJulie Stone1998-01-11—61650793211065 Meadow Ln, Phoenix, AZ, 850800.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57070TPAMichelle P Taylor2003-11-02——9367 Park Pl, Tucson, AZ, 857900.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-50819TPAEmma P Lopez1982-07-16UHC-06552-137443418913932 Harbor Blvd, Tampa, FL, 336520.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-62414TPADeborah Fox1982-06-04——3808 Highland Ave Apt 36, Houston, TX, 770590.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-55205TPAAaron Sandoval2006-04-13——8939 Valley View Dr, Jacksonville, FL, 322200.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-50154TPAGrace Burton1981-01-26——8064 Maple Ave, Columbus, OH, 432790.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-51855TPAMelissa Thompson1976-02-10———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-54435TPAAraon Cruz2008-01-18—59629607537271 Jefferson Ave, Phoenix, AZ, 850910.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52109TPALinda Padilla1947-02-20UHC-69153-86——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-55212TPAJuan Singh1968-07-02———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-62479TPAAustin Welch1963-04-23——278 Palm Dr, Gilbert, AZ, 852770.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-58994TPAJennifer Watkins1993-04-21———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
4,728 rows, page 70 of 95PreviousNext