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-60744TPAJacqueline Lewis1978-05-16——9882 Sage Ct, San Diego, CA, 921630.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56441TPASamuel Ross1998-03-03UHC-33174-59—3528 Meadow Ln, Houston, TX, 770020.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60493TPAKevin Fowler1963-10-01——5151 Valley View Dr, Chandler, AZ0.78Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more
TPA-58160TPAMason Fowler1940-01-28—4247934688606 Palm Dr, Glendale, AZ, 853100.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51936TPAJustin Crawford1982-10-08—49155384233216 Park Pl, Houston, TX, 770030.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54225TPAScott Howell2004-09-04——1885 Meadow Ln, Houston, TX, 770710.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51074TPAAnthony J Chen1999-12-01——8278 Desert Sky Blvd, Austin, TX, 787490.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55554TPAOlivia Sanchez1947-09-04UHC-66069-07—94 Cedar Ln # 421, Atlanta, GA, 303740.78Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-50300TPAShirley Woods1959-10-18—65926218739434 Washington St, Eden Prairie, MN, 553790.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57415TPAKevin Marshall1962-04-05—81773692296674 Sage Ct, Tampa, FL, 336940.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54033TPALori Ellis2005-08-15—88876339815821 Union St, Orlando, FL, 328790.78Phone reformattedState name converted to codeEmail lower-casedWhitespace trimmed+1 more
TPA-64343TPASandra Guzman1945-08-09——3250 Indian School Rd, Miami, FL, 331770.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55830TPAThomas Mendoza2007-04-23—86399368164060 Grand Ave, Eden Prairie, MN, 553930.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54287TPALucia Foster1944-01-24——9070 Maple Ave, Atlanta, GA, 303640.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58367TPAJoseph Webb2008-01-15——838 Washington St, Minneapolis, MN, 554770.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53048TPAKevin Jacobs1973-08-14—65656530259820 Harbor Blvd, Jacksonville, FL, 322020.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57665TPASean Pryce1952-05-18——469 Apache Blvd, Chandler, AZ, 852960.78Date of birth reformattedCity re-casedState name converted to codeEmail lower-cased+1 more
TPA-53700TPAJacqueline Adams1996-06-09——5404 Spring St, Houston, TX, 770670.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54674TPAEvelyn Coleman1982-11-13——5757 Main St, Tampa, FL, 336720.78Date of birth reformattedSSN last four extractedCity re-casedWhitespace trimmed+1 more
TPA-59023TPAGeorge Lopez1951-11-13UHC-53502-6559426267679472 Sunset Blvd, San Diego, CA, 921820.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50267TPACarolyn Dixon1973-10-21——1496 Camelback Rd, Austin, TX, 787840.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-54907TPAMark P Kennedy2004-06-24——8236 Main St, Jacksonville, FL, 322020.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58238TPAJudy Martin1991-05-09—75032735937674 Main St, Plano, TX, 750760.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52713TPAJudith Rivera1953-09-08——7771 Lake View Rd, Nashville, TN, 372390.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-51648TPACynthia M Morales1963-04-10—49420713461807 Canyon Rd, Eden Prairie, MN, 553980.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58061TPAShirley Morgan1997-05-16—81649552349045 Lake View Rd, Phoenix, AZ, 850790.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57472TPARalph Q Montgomery1992-12-15UHC-35654-55—4474 Sage Ct, Mesa, AZ, 852540.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-61157TPAAhmed Hoffman1979-12-22—39797569891307 Pine Dr, Dallas, TX, 752000.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59543TPADebra Holmes2003-01-12——6762 River Rd, Eden Prairie, MN, 553260.78Name re-casedDate of birth reformattedCity re-casedGender normalised+1 more
TPA-55539TPAKathy Brown1994-08-14UHC-43169-4774692280123092 Sage Ct, Orlando, FL, 328540.78Name re-casedPhone reformattedZIP+4 trimmedEmail lower-cased+1 more
TPA-54404TPAYuki Meyer1950-06-01——7772 Harbor Blvd, Seattle, WA, 981220.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62083TPARaymond Hunt1952-02-20——5972 Lake View Rd, Charlotte, NC, 282670.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51278TPARyan Bennett1983-12-04UHC-03938-6791074262961282 Ridge Rd, Seattle, WA, 981390.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55282TPAJulie Bowman2000-07-07——23 Desert Sky Blvd, Houston, TX, 770660.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59263TPAJuan Wells1963-12-02—7514299935943 Lincoln Way, Dallas, TX, 752350.78Phone reformattedSSN last four extractedCity re-casedWhitespace trimmed+1 more
TPA-51654TPAChristine Rios1979-12-13——6172 Cedar Ln, Denver, CO, 802530.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-54027TPADaniel Pena1978-06-28—25669909563626 Meadow Ln, Columbus, OH, 432910.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63085TPADylan Fernandez2006-08-09——467 Indian School Rd, Denver, CO, 802340.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52185TPADonna Ward1979-11-02UHC-41143-98——0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52209TPAGregory C Willis1942-12-18——7682 Main St, Mesa, AZ, 852950.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64356TPAGeorge N Coleman1939-05-05—28692101127711 Valley View Dr Apt 34, Sacramento, CA, 958960.80Name re-casedDate of birth reformattedUnit split from streetPlaceholder values cleared
TPA-51827TPAPhilip Nichols1988-04-04——5140 Park Pl, San Diego, CA, 921550.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57845TPAWalter Chavez1994-05-07——7980 Maple Ave, Austin, TX, 787610.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-53724TPAThomas Bryant2004-04-05UHC-39628-85—7941 Desert Sky Blvd, Tampa, FL, 336590.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56518TPABilly Little2002-08-12——5327 Canyon Rd, Columbus, OH, 432960.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60364TPASara Marshall———4451 Pine Dr, Fresno, CA, 937430.80Name re-casedDate of birth unreadableState code upper-casedPlaceholder values cleared
TPA-60226TPACynthia H Jenkins1950-04-28UHC-09930-9380266034861893 Ridge Rd, San Antonio, TX, 782750.80Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed
TPA-53931TPAJamas Garcia1975-05-23——1489 Baseline Rd, San Antonio, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53437TPAEmily Gibson1977-10-15—5169147893—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51904TPALuis Gordon1948-07-16—900790300746 Sage Ct, Minneapolis, MN, 554690.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
14,474 rows, page 160 of 290PreviousNext