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-53769TPACynthia Chen2008-03-08——7374 Lake View Rd, Charlotte, NC, 282000.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58368TPAJoe Webb2008-01-15UHC-44238-24—838 Washington St, Minneapolis, MN, 554770.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-57127TPAChristina Rodriguez1942-05-15——6388 Cedar Ln, Austin, TX, 787700.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-63959TPAGrace Williamson1997-09-17——9267 Mesa Dr, Miami, FL, 331310.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57241TPABruce Hart1941-09-14——1877 Ocean Ave, Charlotte, NC, 282910.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55415TPANatalie Reid1974-05-23——8152 Meadow Ln, Orlando, FL, 328220.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-59507TPABrian O Watkins1956-08-02——3908 Forest Ave, Chandler, AZ, 852000.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59771TPALucia Wood1946-04-20——2088 Indian School Rd, Los Angeles, CA, 900160.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60564TPADenise Jackson1949-03-07UHC-63308-42—3077 Valley View Dr, Tampa, FL0.78Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more
TPA-62196TPANathan Wong2001-08-11——7166 Sage Ct, Phoenix, AZ, 850840.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50399TPANicholas P Coleman1945-09-10—55455684205342 Elm St, Dallas, TX, 752720.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52032TPASofia V Lane1964-08-03UHC-15778-92—5091 Sage Ct, Scottsdale, AZ, 852830.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57774TPAFrank Santos1972-10-25——1611 Meadow Ln, Glendale, AZ, 853450.78Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+1 more
TPA-55352TPAJoshua Jensen2002-08-16——5857 Cedar Ln, Dallas, TX, 752520.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57285TPAStephen Meyyer1994-05-10——3258 Ridge Rd, San Diego, CA, 921000.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55126TPAAndrea A Espinoza1995-10-20——4990 Church St, Eden Prairie, MN, 553120.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55014TPABilly H Alexander1946-04-05—48148170401182 Central Ave, Tampa, FL, 336940.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59965TPAHannah White1953-06-08UHC-97230-82—4277 Palm Dr, Eden Prairie, MN, 553680.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60688TPAWalter Carter1998-01-14—38047595406131 Lincoln Way, Phoenix, AZ, 850760.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53795TPADebra S Chavez1977-11-01——1967 Highland Ave, Sacramento, CA, 958310.78Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+1 more
TPA-64384TPADenise C Sullivan1965-08-05—83779444927428 Lincoln Way Apt 36, Chandler, AZ, 852720.78Name re-casedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-51095TPADiana Bennett1964-09-14——7866 Sunset Blvd, Minneapolis, MN, 554870.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53397TPAPeter Ortiz1975-01-03—94350594285318 Park Pl, Minneapolis, MN, 554650.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55125TPAKayla Baker1956-09-19—39865775913320 Elm St, San Antonio, TX, 782750.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-60395TPAKathryn Butler1961-10-11——1625 Forest Ave, Mesa, AZ, 852430.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53710TPAChristine B Porter1989-09-25UHC-92458-92—426 Valley View Dr, Austin, TX, 787520.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51135TPAAmy Murray1952-03-15——5657 Central Ave, San Diego, CA, 921440.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-58197TPABecky Jordan1941-10-12—8646408446277 Forest Ave, Chandler, AZ, 852780.78Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+1 more
TPA-52799TPAMegan Santiago1948-05-15UHC-27734-0984632270784521 Ridge Rd, Glendale, AZ, 853840.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-51883TPAAna R Banks1968-01-12UHC-34703-5255475361595264 Elm St, Minneapolis, MN, 554740.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57214TPAJaanice Ramos1999-11-02—47089850837210 Ocean Ave, Atlanta, GA, 303810.78Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-55122TPAKimberly Webb2001-10-11——1437 Grand Ave, Nashville, TN, 372920.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-62572TPACamila Ortiz1975-03-25——2942 Lake View Rd, Columbus, OH, 432240.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-64298TPAMarcus Roberts1956-02-28—66639246908092 Oak St, Charlotte, NC, 282330.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-61228TPAEriic Wang1975-11-25—56756304139887 Mountain View Dr, Austin, TX, 787970.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50613TPANathan Medina1982-10-28—51991478957987 Ridge Rd, Glendale, AZ, 853620.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61694TPAMichael Schmidt2004-10-28——7258 Harbor Blvd, Dallas, TX, 752680.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61788TPABrandon Grant1939-03-23—40028172905840 Lincoln Way, Chandler, AZ, 852950.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57569TPATyler Singh2002-04-12——7305 Valley View Dr, Las Vegas, NV, 891240.78Name re-casedCity re-casedEmail lower-casedGender normalised+1 more
TPA-50786TPAJames Thomas1994-11-16UHC-33106-1322667844508806 Desert Sky Blvd, Atlanta, GA, 303240.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-62374TPABruce Price1966-11-23——1066 Sunset Blvd, Sacramento, CA, 958440.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52328TPADiana Hill1999-04-05——3644 Sunset Blvd, Atlanta, GA, 303640.78Name split from “Last, First”State code upper-casedEmail lower-casedWhitespace trimmed+1 more
TPA-59460TPAAnna Greene1986-02-14—98752173919359 Lake View Rd, Denver, CO, 802220.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51044TPASandra Smith1967-08-12——2812 Maple Ave, Denver, CO, 802800.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55450TPASteven Mason1965-11-06——6665 Pine Dr Apt 33, Miami, FL, 331840.78Unit split from streetCity re-casedPlan code upper-casedWhitespace trimmed+1 more
TPA-53926TPAArjun Rios1960-01-03——5434 Union St, Chandler, AZ, 852900.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57653TPAKeith G Ford1947-04-21——6215 Central Ave, Orlando, FL, 328110.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52259TPACharlotte D Pierce1952-11-13—62949848626045 Meadow Ln, San Antonio, TX, 782650.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54130TPAAshley P Scott1998-04-22———0.78Name re-casedDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more
TPA-58828TPATerry Cooper1960-07-24——6679 Sunset Blvd, Fresno, CA, 937520.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 132 of 290PreviousNext