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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-59681TPAMary Baker1973-06-23———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51364TPATimothy Arnold1943-09-15———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55968TPAMary Cox1990-08-03—71736684308887 Lincoln Way, Denver, CO, 802770.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60960TPASofai Lucas1969-04-12—6606442234—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61506TPARussell R Mendoza1989-07-06——2400 Hillcrest Rd, Tempe, AZ, 852150.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56990TPASandra Russell1995-02-25—61582136236195 Main St, Tempe, AZ, 852750.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59576TPANancy Graham1959-03-19—70946051284350 Apache Blvd, Seattle, WA, 981970.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-50223TPAIsabella Harrisun1986-09-12—9333412719—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56342TPAHenry Sullivan1951-01-08——1538 Harbor Blvd, Los Angeles, CA, 900760.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63793TPAGary Montgomery1958-03-17—25323028131820 Washington St, Orlando, FL, 328560.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61998TPALauren Hoffman1940-07-25——1201 Meadow Ln, Jacksonville, FL, 322030.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60709TPAEmma Wright1978-08-21—83721166744449 Jefferson Ave, Chandler, AZ, 852280.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58539TPAEthan Dean1958-02-12——8968 Elm St, Mesa, AZ, 852690.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-55714TPALaura Hill1985-12-11——3213 Sunset Blvd, Sacramento, CA, 958970.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-57163TPAKathleen Johnston1964-01-05———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59157TPADennis Hannsen1940-05-06—65844967289125 Jefferson Ave, Phoenix, AZ, 850580.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59964TPALori Hamilton1961-09-04—8493519558—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59386TPAElijah Clark1966-03-23UHC-01209-61—3071 Oak St, Chandler, AZ, 852950.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-56891TPATeresa Vazquez2003-03-18——6244 Union St, Plano, TX, 750870.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-56111TPACarol Crawford1980-09-14UHC-16231-67——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63563TPAJanice Salazar1959-08-16——5992 Palm Dr, Tempe, AZ, 852220.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56164TPALuis Walker1980-06-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53357TPAMariana Marquez1973-05-24—2802286308—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55430TPAAlice Porter1989-06-20UHC-37723-15—1574 River Rd, Jacksonville, FL, 322010.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63622TPASam Ray1967-10-28—64261390101864 Indian School Rd, Gilbert, AZ, 852440.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63150TPAHeather Ramirez1984-02-13———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57832TPADoris Cole1979-03-15UHC-59466-15—4228 Canyon Rd, Charlotte, NC, 282090.92Name re-casedDate of birth reformattedMember ID reformattedPlaceholder values cleared
TPA-63318TPAJohn Vazquez1956-03-21—5213268166—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64395TPAJeremy Gardner2007-05-17——7756 Mountain View Dr, Atlanta, GA, 303070.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-57692TPAAhmed Hudosn1963-04-04UHC-89402-89——0.92Date of birth reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-62396TPAChristian King1952-07-18—30876732675526 Sunset Blvd, Tempe, AZ, 852150.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61608TPACamila Chen1977-01-12—4166840302130 Harbor Blvd, Glendale, AZ, 853270.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52370TPARebecca Z Austin1983-03-26——2519 Spring St, Atlanta, GA, 303540.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51522TPATyler Jackson1948-07-16—92973635627548 Baseline Rd, Atlanta, GA, 303260.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56329TPAMariana I Parker2008-11-14——9046 Church St, Gilbert, AZ, 852240.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-58180TPASam Anderson1971-12-10—4333355037—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53635TPAElizabeth Ramirez2001-01-11UHC-37122-33—2787 Indian School Rd, Austin, TX, 787410.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-64008TPAAnn J Espinoza1943-08-06—4807905379—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64460TPAPatricia Yang1991-10-21——3279 Cedar Ln, Tucson, AZ, 857920.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56886TPASusan Z Martin2006-12-27UHC-48771-56—5676 Central Ave, Seattle, WA, 981030.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60363TPALauren Reynolds1957-04-11—41847851297932 Willow Ct, Columbus, OH, 432970.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54348TPAOmar Wong1952-11-11—2372375706—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54405TPAJerry Flores1995-09-19———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60418TPADavid Long1966-04-07UHC-02750-47——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52316TPAAna White1980-04-08——7235 Lake View Rd, Nashville, TN, 372900.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52315TPAAna White1980-04-08——7235 Lake View Rd, Nashville, TN, 372900.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56330TPAJuan Castro1981-08-02—5608809025—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55369TPARobert Weaver1962-01-16——9421 Desert Sky Blvd, Miami, FL, 331620.92Date of birth reformattedCity re-casedState code upper-casedPlaceholder values cleared
TPA-55452TPABrittany Maldonado1971-09-18UHC-59228-39—147 Lake View Rd, Miami, FL, 331330.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-58821TPADenise Spencer1953-02-02—6476441833—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 239 of 290PreviousNext