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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-59558TPAJean Ramirez2005-03-05———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54171TPARussell Dean1981-07-23—7348393066—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62052TPAAustin R Medina1954-03-06—80270983724470 Main St # 614, Fresno, CA, 937800.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
TPA-62636TPAAna Carr1981-08-17—58983739193689 Pine Dr, Los Angeles, CA, 900740.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52135TPAZachary S Simpson1941-12-20——4120 Lake View Rd, Mesa, AZ, 852430.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61605TPAOlivia Johnson1971-01-09——8638 Washington St, Seattle, WA, 981810.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54463TPASandra Tucker1962-06-06——4843 Grand Ave, San Diego, CA, 921760.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61674TPAHiroshi Greene1997-09-26—71629666007106 Market St, Sacramento, CA, 958960.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53976TPAJanice T Henry1944-10-20—9245473305160 Camelback Rd, Jacksonville, FL, 322950.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-61778TPARoger Banks1974-05-26—54580520544937 Sage Ct, Scottsdale, AZ0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-61779TPARoger Banks1974-05-26—54580520544937 Sage Ct, Scottsdale, AZ0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54966TPAAmber Young1990-08-06——5945 River Rd, Nashville, TN, 372180.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50937TPAZachary Rios1954-01-02—33450413915006 Baseline Rd, Gilbert, AZ, 852250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54577TPAPatrick Sanchez1955-04-09UHC-04893-31—8588 Church St, Dallas, TX0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52912TPABreenda T Porter2003-10-03——9264 Oak St, Tempe, AZ, 852210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52772TPAJeffrey Hrerera1989-08-07UHC-15185-8723344204556053 Elm St, Charlotte, NC, 282760.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59998TPAMariana Padilla1949-05-16——8125 Valley View Dr, Los Angeles, CA, 900700.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60631TPAAisha Cruz1972-02-22UHC-68226-6561882703555583 Bayshore Dr, Austin, TX, 787670.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59330TPASteven Price1939-01-16——2043 Grand Ave, Houston, TX, 770620.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-61597TPAAdam Carlson1990-04-20UHC-39092-8070796944432767 Lake View Rd, Denver, CO, 802810.80Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased
TPA-58046TPAIsabella Harper1952-12-28———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52804TPAAlexander Yang1993-07-25UHC-49539-93—527 Lincoln Way, Dallas, TX, 752970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60150TPAArthur Jimenez2001-02-01——4586 Lake View Rd, Eden Prairie, MN, 553420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53614TPAJacqueline Moore1995-03-14UHC-13379-8977056621269435 Broadway, Houston, TX, 770870.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57221TPABrandon Stevens1976-11-18——4843 Palm Dr, Eden Prairie, MN, 553450.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64159TPAVirginia Luna1952-02-07——5487 Palm Dr, Chandler, AZ, 852000.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53138TPAStephanie Roberts1945-10-01———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-63834TPARayymond Chapman1975-12-27—2023467133—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63286TPAJason Smith1972-06-13——6480 River Rd, Glendale, AZ, 853150.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58662TPARyan Smith1942-09-01——5462 Indian School Rd, Gilbert, AZ, 852990.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53425TPABenjamin Webb1967-03-24——9584 Hillcrest Rd, San Diego, CA, 921730.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60771TPARalph Ruiz1950-05-14—81796059795738 Valley View Dr Apt 28, Mesa, AZ, 852980.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-52694TPASara Burton1938-03-28——2589 Canyon Rd, Atlanta, GA, 303280.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-58185TPARussell Powell1939-10-22—65467224578283 Willow Ct, Fresno, CA, 937600.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-51969TPAPaul Simmons1953-06-17—56545986403135 Baseline Rd, Phoenix, AZ, 850170.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58510TPAJudith Garza1949-03-27——7413 Sunset Blvd, Las Vegas, NV, 891180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63319TPACarolyn Li1943-09-13——2737 Lake View Rd, Minneapolis, MN, 554790.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58392TPACarol Gibson1941-01-10——6007 Oak St, Tempe, AZ, 852350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60287TPABrandon Hall1997-08-11——1192 Union St, Chandler, AZ, 852800.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52415TPAAnn Simpson1975-01-13——63 Indian School Rd, Tempe, AZ, 852970.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63192TPARalph Fowler1998-08-16——3163 Oak St, Miami, FL, 331660.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-52591TPASara King1996-12-15——4661 Central Ave, Tucson, AZ, 857060.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-62095TPAPaul Hudson————0.80Date of birth unreadableEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60393TPASteve Hunt1959-08-22——2211 Willow Ct, Charlotte, NC, 282080.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-50502TPARebecca Gaarza1976-06-04——5159 Mountain View Dr, Gilbert, AZ, 852720.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52947TPADouglas Schultz1954-10-05———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50447TPAAmanda Estrada1941-04-18—88426192812694 Jefferson Ave, Plano, TX, 750730.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50416TPAOlivia Wels1950-06-10——9276 Hillcrest Rd, Sacramento, CA, 958680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54031TPAAisha C Boyd1976-06-01——418 Palm Dr, Miami, FL, 331650.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50312TPAElizabeth Bailey1991-07-17UHC-28857-39—2559 Main St, Dallas, TX, 752020.80Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
14,474 rows, page 165 of 290PreviousNext