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-63505TPAHarod Howell1939-01-19——300 Washington St, Nashville, TN, 372190.80Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed
TPA-59979TPAFrank Banks1981-05-15—5343609093—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64413TPABenjamin Olson1977-02-25———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62671TPARebecca Estrada1998-01-03UHC-94735-59—9541 Jefferson Ave, Atlanta, GA, 303100.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50096TPADeborah T Murray2003-04-24———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57630TPACarl T Weber1999-04-18——2535 Market St, Charlotte, NC, 282210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54718TPAAshley Hayes1970-03-20UHC-08753-09—2850 Valley View Dr, Chandler, AZ, 852300.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59729TPAPatricia E Sanchez1942-07-20——8616 Bayshore Dr, Chandler, AZ, 852400.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63253TPAMartha Marquez2002-07-06——6570 Mesa Dr, Phoenix, AZ, 850530.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61386TPAAmy Ruuiz2005-04-11—2073820208347 Indian School Rd, Gilbert, AZ, 852690.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-60997TPAJoe Ramos1969-08-23——6532 Mountain View Dr, San Antonio, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54544TPALisa Daniels1948-04-20——420 Lincoln Way, Dallas, TX, 752160.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53018TPASteev Meer1999-09-17———0.80Name re-casedDate of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-50859TPAMaria James2001-11-10——9109 Broadway, Orlando, FL, 328410.80Two-digit birth yearCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56492TPAPriya Y Schultz1969-11-28UHC-36322-4941447235194149 Ocean Ave, Miami, FL, 331950.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60325TPAAmber U Willis1990-08-08——9561 Mountain View Dr, Sacramento, CA, 958480.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59385TPABenjamin Dean1953-07-17—60395616522589 Church St, Dallas, TX, 752780.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58862TPAAshley Park1984-03-25——5422 Meadow Ln, Miami, FL, 331290.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58455TPAEthan Morris2002-06-13——1385 Mountain View Dr, Mesa, AZ, 852690.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54815TPAKeith Palmer1984-02-21—68069275237266 Meadow Ln, Columbus, OH, 432110.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-50667TPADeborah Wright1997-11-24——7683 Market St, Orlando, FL, 328130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64195TPADiane Gordon1974-08-21—24234524349110 Camelback Rd, Dallas, TX, 752110.80ZIP+4 trimmedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-59010TPAChristina Armstrong1977-06-05—6675606643—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-63748TPAAhmed O Coleman1975-03-03—51260659714581 Forest Ave, Columbus, OH, 432550.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-51576TPANicole Wood2002-05-07UHC-81471-19—3460 Sage Ct, San Antonio, TX, 782860.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-61078TPAMadison Black1995-03-09——5866 Sunset Blvd, Tucson, AZ, 857470.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
TPA-50544TPAKaren Martinez1972-11-01—4828590805—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-50398TPADylan Green1988-01-20——8017 Ridge Rd, Tempe, AZ, 852410.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57838TPAHeather Pierce1966-05-21——3017 Ocean Ave, Minneapolis, MN, 554550.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55200TPAHenry Yang1987-12-03——4104 Highland Ave, Dallas, TX, 752980.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50710TPAJerry Walsh1994-09-24——6984 Union St, Tampa, FL, 336210.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58599TPABradley Santos2004-03-03—36240431388363 Sage Ct, Phoenix, AZ, 850790.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-64114TPAMark Johnson1938-08-27——3509 Main St, Fresno, CA, 937750.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63404TPAArthur Burns1985-09-27——4680 Desert Sky Blvd, Miami, FL, 331650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60415TPAArjun Jones1953-02-05—8045062354—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60791TPABeverly Ramirez1979-04-12—7684237278683 River Rd, Atlanta, GA, 303030.80ZIP+4 trimmedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63300TPAPriya H Estrada1980-01-15UHC-63095-70—9798 Sage Ct, Columbus, OH, 432450.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63692TPAJack Morris1944-06-09——9062 Forest Ave, Seattle, WA, 981820.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50880TPAAlexander Carlson1940-06-07——5227 Ridge Rd Apt 19, Fresno, CA, 937420.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-61781TPARalph Jacobs1999-04-07——1278 River Rd, Phoenix, AZ, 850900.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53800TPAWillie Webb2006-09-24—35368972472644 Grand Ave, Tempe, AZ, 852110.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-53651TPASusn Estrada1995-10-02——4654 Bayshore Dr, Gilbert, AZ, 852630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50068TPAMaria Dvis2007-03-12UHC-35556-52—5103 Willow Ct, Tempe, AZ, 852470.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51003TPANatalie Luuna1943-03-22—94089380259853 River Rd, Glendale, AZ, 853230.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-58742TPARichard Elliott1965-03-28——5139 Ridge Rd, Dallas, TX, 752230.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60614TPANicole Gonzalez1959-04-24——1921 Union St, Las Vegas, NV, 891060.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57328TPAAndrea Lawson1979-08-19——9607 Central Ave, Tempe, AZ, 852200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57622TPAJerry Adams1969-04-08——5849 Maple Ave, Scottsdale, AZ, 852890.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56483TPASophia Perez1948-12-19——2043 Forest Ave, Sacramento, CA, 958330.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57770TPAFatima Daniels2007-06-08——500 Desert Sky Blvd, Plano, TX, 750140.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 175 of 290PreviousNext