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-62201TPAAlbert Hoffman1967-12-23——3682 Pine Dr, San Diego, CA, 921530.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57046TPASerah Singh1940-12-15—4785488691220 Broadway Apt 20, Jacksonville, FL, 322140.80Name re-casedUnit split from streetAddress re-casedPlaceholder values cleared
TPA-59162TPANoah Hall1967-05-02——8762 Desert Sky Blvd, Tampa, FL, 336440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63067TPALuis Nichols1975-08-02——7229 Union St, Seattle, WA, 981980.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50752TPASamantha N Hughes2003-06-15—60999897923646 Meadow Ln, Gilbert, AZ, 852930.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54958TPAWillam Z Coleman2004-12-19——2790 Forest Ave, Mesa, AZ, 852000.80Date of birth reformattedState name converted to codePlan code upper-casedPlaceholder values cleared
TPA-58394TPAAmber Fernandez1970-08-14——3495 Hillcrest Rd, San Diego, CA, 921290.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62334TPADiego Ray1979-07-24——203 Union St, Phoenix, AZ, 850110.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58931TPAChristopher Ortega2006-06-19UHC-06039-7362533501699815 Bayshore Dr, Charlotte, NC, 282680.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-59436TPARonald Guerrero1953-09-22UHC-63884-9681499493208347 Market St, Scottsdale, AZ, 852620.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63652TPAChristopher Yang1961-08-27——6043 Church St, Chandler, AZ0.80City re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64391TPAJoan Silva1968-06-25———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-51008TPATerry B Kelley1963-01-07——8993 Camelback Rd, Tempe, AZ, 852230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64282TPARoy James1967-08-14—2083171681—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62887TPASusan Hanson1982-10-01——4755 Maple Ave, Minneapolis, MN, 554880.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63220TPAAlice Mendez1992-04-02——3762 Jefferson Ave, Orlando, FL, 328510.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51243TPAJerrry Murray1986-02-06UHC-55351-47—7532 Cedar Ln, Nashville, TN, 372770.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63324TPAMichael George1955-06-24UHC-92579-34—3589 Baseline Rd, Miami, FL, 331730.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-55344TPACarl Cole1962-09-09—33199630467658 Oak St, Austin, TX, 787760.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53068TPADonna Padilla1951-10-28——6322 Bayshore Dr Apt 9, Sacramento, CA, 958750.80Date of birth reformattedUnit split from streetCity re-casedPlaceholder values cleared
TPA-51552TPAPhilip K George1952-09-16UHC-01483-4476448156352537 Sage Ct, Jacksonville, FL, 322230.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
TPA-51053TPAPeter Roberts1988-04-11UHC-41456-864076290973—0.80Name re-casedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-60245TPARichard Hansen1959-10-08—3505892402—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57239TPAAisha X Gibson1941-12-19—87736347953743 Church St, Atlanta, GA, 303590.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-51641TPAMariana G Bradley1961-08-08—71593177683194 Sunset Blvd, Seattle, WA0.80Date of birth reformattedPhone reformattedZIP missingPlaceholder values cleared
TPA-52338TPAAmy Washngton1963-07-27UHC-41659-76—8281 Mountain View Dr, Fresno, CA, 937100.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59430TPAJulie Vasquez1944-08-01——4713 Jefferson Ave, Tampa, FL, 336130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58288TPAKathryn Mills2008-02-24——2641 Ocean Ave, Miami, FL, 331110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58383TPAAisha Morrison2006-04-13——3540 Maple Ave, Houston, TX0.80City re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59222TPAStephanie Harper1964-06-15———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-56802TPAWilliam Wright1999-12-01——5224 Apache Blvd, Fresno, CA, 937320.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55513TPAArjun Lucas2003-05-25——5737 Market St, Tempe, AZ, 852880.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56253TPAMasonJunk1938-11-23—95121859923902 Apache Blvd, Miami, FL, 331460.80Phone reformattedCity re-casedPlaceholder values clearedNo usable name (quarantined)
TPA-64364TPAMariana Henderson1986-11-02——8672 Highland Ave, Orlando, FL, 328840.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58182TPAMei Cunningham1985-07-19——6528 Meadow Ln, Charlotte, NC, 282150.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56678TPALisa D Shaw1989-08-06UHC-91238-3374525887933486 Elm St, San Diego, CA0.80Phone reformattedCity re-casedZIP missingPlaceholder values cleared
TPA-57797TPADanielle Ferguson1945-04-19——3567 Elm St, San Antonio, TX, 782090.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52289TPAThomas Boyd1984-09-28——7546 Sunset Blvd, Sacramento, CA, 958830.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50227TPACatherine S Gomez1944-12-26——790 Meadow Ln, Sacramento, CA, 958050.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58176TPACamila Howell1993-08-02UHC-03133-672122468677882 Harbor Blvd, Phoenix, AZ, 850360.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60116TPASantiago Allen1975-09-04——2932 Ocean Ave, Nashville, TN, 372130.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55214TPASean Campblel1961-07-27———0.80Date of birth reformattedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-52744TPANancy Mendoza1988-03-18UHC-66651-92—7989 River Rd, Gilbert, AZ, 852980.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54563TPACatherine Bennett1945-01-20——9312 Indian School Rd, Orlando, FL, 328540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53824TPAJerry Scott2004-10-26—30529593678838 Baseline Rd, Nashville, TN, 372490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61460TPARuth Z Ross1970-04-21—53925676513071 Canyon Rd, Phoenix, AZ, 850960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51579TPATony Wells1940-09-03—88278429296559 Mesa Dr, Gilbert, AZ, 852720.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57894TPARyan Wright1953-03-20———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62499TPAPrice Brenda1950-07-23——553 Forest Ave, Atlanta, GA, 303970.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62500TPAPrice Brenda1950-07-23——553 Forest Ave, Atlanta, GA, 303970.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 173 of 290PreviousNext