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-58869TPAOlivia Turner1974-09-17——1202 Pine Dr, Tucson, AZ, 857460.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51011TPACarl Morales1979-12-15—60954665235098 Market St, Orlando, FL, 328000.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63187TPAAnn Garrett1938-12-18UHC-63615-3322180851995563 Lincoln Way, Houston, TX, 770730.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54388TPAChristina Howell1939-09-22UHC-20356-10—6124 Mesa Dr, Tempe, AZ, 852710.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52775TPANicole Roodriguez2008-05-07—98598422789401 Ocean Ave, Tempe, AZ, 852210.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63337TPAJanice Marshall1985-05-08UHC-01618-8058743089728752 Spring St, Mesa, AZ, 852760.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61272TPASarah Wung1948-03-17UHC-18126-07—8431 Desert Sky Blvd, Houston, TX, 770320.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54564TPAEmma Hawkins1947-08-08UHC-98014-78—1302 Ocean Ave, Nashville, TN, 372630.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53996TPAGabriel Munoz1938-08-21——1299 Indian School Rd, Glendale, AZ, 853700.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50866TPAAnna Shaw1956-08-26—50744158208585 Desert Sky Blvd, San Antonio, TX0.78Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-58145TPANicholas Garrett1987-02-16——8090 Lincoln Way, Tucson, AZ, 857760.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56794TPAGabriel N Davis1980-10-28——7481 Church St, Tampa, FL, 336840.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56405TPAMateo Perez2003-01-14——2630 Maple Ave, Tampa, FL, 336360.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-60144TPAOlivia Cooper1981-09-05——683 Bayshore Dr, Minneapolis, MN, 554920.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55180TPAArjun Herrera1983-12-20——6028 Maple Ave, Chandler, AZ, 852870.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58296TPABrittany Lucas1951-04-16——495 Washington St, San Antonio, TX, 782690.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50668TPAPatrick Henry1975-08-15UHC-39305-0261522681224132 Palm Dr, Glendale, AZ, 853500.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-64423TPAKayla Chavez1991-06-09—3655470683117 Harbor Blvd, Fresno, CA, 937600.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-59426TPAPeter Ferguson1948-03-25——1560 Central Ave, Houston, TX, 770660.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60084TPAStephanie Williamson1949-05-06UHC-63783-5697293414244702 Central Ave, Austin, TX, 787220.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55772TPAMichael Castillo1991-06-26—35362352289313 Sage Ct, Scottsdale, AZ, 852030.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52606TPAPamela Jones1975-12-10——2254 Spring St, Fresno, CA, 937920.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58081TPAJanet Morrison1993-11-28—28482478149399 Cedar Ln, San Antonio, TX, 782060.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55900TPACamila Snyder1951-11-11——8443 Valley View Dr, Austin, TX, 787620.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-54731TPAMarilyn Reyes1964-03-28——8962 Elm St, Houston, TX, 770550.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-52854TPACarlos Santiago1977-10-23—53727727022768 Ocean Ave, Eden Prairie, MN, 553730.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50579TPAAngela Myers2003-01-09——3652 Oak St, Jacksonville, FL, 322380.78Date of birth reformattedState name converted to codePlan code upper-casedWhitespace trimmed+1 more
TPA-64344TPAAna Murphhy1949-09-21——2678 Bayshore Dr, Tempe, AZ, 852650.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63919TPABrittanyJunk1968-01-08———0.78Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared+1 more
TPA-63918TPABrittanyJunk1968-01-08———0.78Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared+1 more
TPA-55692TPAElijah Meyer1957-01-17——1014 Mountain View Dr, Atlanta, GA, 303160.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-62608TPAMei Olson1956-09-21UHC-06921-3355477385396886 Pine Dr # 534, Sacramento, CA, 958630.78Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
TPA-50076TPAMason Williams1994-07-17——6790 Valley View Dr, Eden Prairie, MN, 553890.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59015TPARoger Howard1981-11-11—57184944678865 Bayshore Dr, Tampa, FL, 336300.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57466TPAAlexander H Gray1940-05-01——9441 Willow Ct, Minneapolis, MN, 554550.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50633TPAAisha Allen1938-10-20——6490 Baseline Rd, Minneapolis, MN, 554700.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57477TPAElijah Richardson1951-04-02UHC-63367-57—3875 Park Pl, Orlando, FL, 328640.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50947TPAHeather U Valdez1966-03-06UHC-93047-86—2610 Main St, Tucson, AZ, 857560.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59017TPASophia Le2000-04-12——3641 Forest Ave, Dallas, TX, 752210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53424TPAMark Z Webb1979-02-19—43559896377988 Cedar Ln, Gilbert, AZ, 852680.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-53263TPAShirley Walsh1970-02-11UHC-61247-35—4744 Lincoln Way, Sacramento, CA, 958520.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-56762TPAArjun Brooks—UHC-10874-587465254212—0.78Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more
TPA-50865TPAMrcus Bennett1950-06-07UHC-69159-18—7597 Valley View Dr, Los Angeles, CA, 900790.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62760TPASusan I Fields1959-01-25UHC-67312-24—8220 Grand Ave, Atlanta, GA0.78City re-casedState code upper-casedZIP missingWhitespace trimmed+1 more
TPA-55451TPAStevn Mason1965-11-06——6665 Pine Dr, Miami, FL, 331840.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57583TPASmith Andrew1962-10-28UHC-95354-6295629747255777 Harbor Blvd, Gilbert, AZ, 852130.78Member ID reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59607TPAVincent Littel1980-02-28—67941549101858 Market St, Phoenix, AZ, 850330.78Name re-casedPhone reformattedCity re-casedState name converted to code+1 more
TPA-61749TPATheresa Y Rios2007-07-20—70994126063083 Sage Ct, Houston, TX, 770630.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59022TPADavid Schultz1995-05-21—43934983599059 Lake View Rd, Atlanta, GA, 303430.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58609TPATerry Bannks1947-12-03—81393976031760 Highland Ave, Orlando, FL, 328300.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 135 of 290PreviousNext