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-61625TPAAbby Price1964-04-17—65423875962730 Desert Sky Blvd, Tempe, AZ, 852450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56046TPAMelissa Yang1968-05-01UHC-50658-1686943464136901 Hillcrest Rd, Plano, TX, 750360.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60308TPAChristian Kelley2008-11-28—95273362162826 Union St, Columbus, OH, 432450.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62753TPAAlexis U Bell1984-08-28—34245547426876 Hillcrest Rd, Tampa, FL, 336310.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53103TPARalph Daniels2001-07-07——3822 Sage Ct, Phoenix, AZ, 850820.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-59692TPAGerald Parker1953-07-26—54979612534446 Forest Ave, Dallas, TX, 752370.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61495TPARalph Jacobs1968-07-08UHC-62536-2197290658345925 Jefferson Ave, Los Angeles, CA, 900390.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53334TPANicole T Munoz1973-06-26—43041538507046 Ocean Ave, Los Angeles, CA, 900270.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54081TPAKenneth Stewart2003-04-08——333 Jefferson Ave, Atlanta, GA, 303890.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52749TPAFatima Perkins1992-04-14—6414426679107 Central Ave, Jacksonville, FL, 322100.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58395TPAMary Miller1940-11-17——9265 Sunset Blvd, Minneapolis, MN, 554760.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56710TPAKeith Scott1999-07-09——2392 River Rd, Fresno, CA, 937270.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62598TPAElijah Stone1948-02-20——1563 Forest Ave, Plano, TX, 750220.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56535TPAAmanda D Martinez1960-08-03——7043 Forest Ave, Glendale, AZ, 853210.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58435TPAJack Jenkins1952-08-07——7076 Church St, Atlanta, GA, 303290.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61103TPAMateo Alexander1973-03-12—55273417033499 Pine Dr, Tucson, AZ, 857630.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50524TPAJohnny Powell1942-04-22—86955577962053 Canyon Rd, Los Angeles, CA, 900490.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64229TPADanielle Herrera1963-01-22—83239541019155 Bayshore Dr, Phoenix, AZ, 850830.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57148TPABryan Gonzales1982-09-28—425736073081 Union St, Minneapolis, MN, 554490.76Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+2 more
TPA-52195TPARichard Washington1988-08-26——8525 Baseline Rd, Eden Prairie, MN, 553440.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62940TPALucia Ellis1972-09-15——1316 Sage Ct, Chandler, AZ, 852520.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54661TPACarl Long1982-10-17UHC-98459-4460943113034180 Maple Ave, Orlando, FL, 328600.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62288TPARuth Montgomery1968-10-18UHC-83646-29—125 Sunset Blvd, Atlanta, GA, 303830.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53139TPAChristina Garza1981-02-15——305 Church St, Tampa, FL, 336640.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-57201TPAValentina Peters1959-03-02UHC-88193-8494550410289631 Harbor Blvd, Las Vegas, NV, 891220.76Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-54934TPABetty Wood1950-04-12—55898067357551 Lincoln Way, Seattle, WA, 981760.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58010TPAWalter Guzman1980-07-20UHC-84623-41—9478 Washington St, Tucson, AZ, 857870.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53073TPABruce Espinoza1965-04-10——2762 Park Pl, Charlotte, NC, 282370.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-53072TPABruce Espinoza1965-04-10——2762 Park Pl, Charlotte, NC, 282370.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-53420TPAFrank Anderson1941-10-02——3969 Apache Blvd, Tucson, AZ, 857840.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63586TPABrandon Edwards1948-04-23——3531 Church St, Sacramento, CA, 958500.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-57242TPAEmma Patel1976-10-05——5189 River Rd, Charlotte, NC, 282840.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61110TPABrian Morgan1998-03-16——9619 Maple Ave, Los Angeles, CA, 900720.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59652TPAJeffrey Harrison1942-09-28—55929090246635 Canyon Rd, Las Vegas, NV, 891890.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-52494TPAJames Rivera1959-08-11—68968694351090 Spring St, Glendale, AZ, 853750.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53890TPAGabriel James1966-02-11——9853 Spring St, Miami, FL, 331120.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-54170TPAHelen Garza1945-10-14——1514 Highland Ave, Eden Prairie, MN, 553780.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61226TPALarry Mendoza1992-09-08—94344621902548 Willow Ct, Orlando, FL, 328090.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51661TPARobert Wells1957-10-10——3675 Mountain View Dr, San Antonio, TX, 782340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61784TPAPaul Coleman1939-09-22——8638 Main St, Miami, FL, 331700.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62386TPAKaren Clark1956-01-28UHC-04799-83—7273 Mesa Dr, Orlando, FL, 328140.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53898TPAMaria Walace1991-04-03UHC-55505-29—4494 Spring St, Minneapolis, MN, 554420.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53860TPANancy Simpson1956-04-01UHC-55422-7120595855065617 Jefferson Ave, Sacramento, CA, 958280.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60457TPAGloria Miller1950-12-10—770840154358 Forest Ave, Plano, TX, 750230.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54352TPATeresa Hayes1958-07-09UHC-65208-352643977486—0.76Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more
TPA-57760TPAAndrew Lawson1940-01-10—34074282308968 Willow Ct, Orlando, FL, 328950.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-54072TPAArjun Sullivan1967-11-02—70983089415726 Broadway, Jacksonville, FL, 322020.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-53356TPAJuan R Cestro2000-08-25——7584 Mountain View Dr, Charlotte, NC, 282190.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54318TPAOmar Foster1992-05-16—24071471005197 Highland Ave, Minneapolis, MN, 554840.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58882TPAJose Griffin1973-12-16——6349 Broadway, Eden Prairie, MN, 553700.76Name re-casedAddress re-casedCity re-casedGender normalised+2 more
14,474 rows, page 110 of 290PreviousNext