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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-409540CLMMari Park1979-04-01UHC-74024-31—1510 Grand Ave, Phoenix, AZ, 850340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106215ENRHarold B Ortega1974-01-26UHC-31718-0150557593039698 Ridge Rd, San Diego, CA, 921180.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28477PRVHenry Harrison—UHC-33101-6835184852807019 Washington St, Chandler, AZ0.50Name re-casedDate of birth unreadableMember ID reformattedZIP missing+3 more
ENR-137090ENRCheryl Yang2003-02-03UHC-63563-1674729064483370 Bayshore Dr # 978, Jacksonville, FL, 322350.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21673PRVJacob M Obrien1949-07-03UHC-92455-5167943317229669 Mountain View Dr Apt 37, Jacksonville, FL, 322810.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
CLM-430464CLMEmily T Gonzalez1986-09-26UHC-10003-8960788714374296 Willow Ct, San Antonio, TX, 782600.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117855ENRLaura Mason1979-10-02UHC-27169-905362474745259 Central Ave, Los Angeles, CA, 900440.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-110079ENRPatricia G Aguilar1953-02-23UHC-00064-3292245344675789 River Rd, Nashville, TN, 372020.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-52774TPANancy Hoffman1945-06-23UHC-67490-98—4284 Grand Ave, Phoenix, AZ, 850620.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-121673ENRSantiago White1956-03-09UHC-90732-5430154932849371 Canyon Rd Apt 16, Orlando, FL0.50Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-403719CLMJessica Rios1949-07-04UHC-96873-05—552 Spring St, Charlotte, NC, 282380.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403720CLMJessica Rios1949-07-04UHC-96873-05—552 Spring St, Charlotte, NC, 282380.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51225TPASantiago Nunez1954-08-27——8018 Union St, Chandler, AZ, 852360.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54232TPAYuki Lynch1963-06-01——5354 Central Ave, Denver, CO0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-21843PRVAlexis Wheeler1957-05-26—36397242976355 Highland Ave, Orlando, FL, 328900.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-102346ENRJordan Armstrong1990-06-22UHC-21547-0472249671675162 Bayshore Dr, San Antonio, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23642PRVBruce Garrett1989-08-06UHC-03054-9588428217202966 Harbor Blvd, Glendale, AZ, 853240.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-126447ENRKimberly G Reynolds1995-06-10UHC-53253-1180790700955724 Elm St, Austin, TX, 787410.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-20052PRVAnthony R Maldonado1958-06-17UHC-57454-9888162984597136 Sage Ct # 287, Dallas, TX, 752460.50Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-23456PRVChristian Fuller1993-07-18UHC-09907-7368091339701377 Desert Sky Blvd Apt 14, Eden Prairie, MN, 553050.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28284PRVSophia Morgan1989-01-15—3636774936504 River Rd, Houston, TX, 770480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142370ENRJacqueline O Sullivan1951-10-08UHC-00042-81—211 Ocean Ave, Glendale, AZ, 853720.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-57318TPAMargaret Cole1973-09-02——6556 Lake View Rd, Las Vegas, NV0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-422581CLMHelen Sanders1964-07-24—58234223815250 Oak St, San Antonio, TX, 782930.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122693ENRSean Nguyen2004-05-04UHC-10988-1083299016896219 Cedar Ln, Atlanta, GA, 303820.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120232ENRCarolyn Fisher1959-11-11UHC-40205-9930171464991539 Apache Blvd, Tucson, AZ0.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101266ENRJustin Ortiz1956-12-05UHC-24168-0754667478248585 Maple Ave, Columbus, OH, 432630.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-110578ENRRachel O Romero1978-10-03UHC-05946-5360384439453385 Hillcrest Rd # 858, Jacksonville, FL0.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-51052TPAJuith Lopez1978-05-25—94557438922945 Grand Ave, Eden Prairie, MN, 553890.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-133151ENRLarry Li2001-07-08UHC-08701-85—3403 Willow Ct # 558, Miami, FL, 331610.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-427528CLMAisha Martin1972-02-24UHC-24039-328456994850449 Indian School Rd, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113407ENRAlice C Lane1961-02-10UHC-89889-4142226463361232 Mesa Dr # 773, Nashville, TN, 372880.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410655CLMTerry Brooks1939-10-25UHC-76049-7467862574566223 Cedar Ln # 372, Gilbert, AZ, 852900.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-128889ENRJanet W Aguilar1959-11-13UHC-58854-6235565633314575 Church St, Tucson, AZ, 857140.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-111298ENRCarol M Espinoza1980-12-21UHC-76825-6444560535086265 Palm Dr, Tempe, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114714ENRDylan Vasquez2005-08-04UHC-72211-2164778012286703 Oak St, Atlanta, GA, 303600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431101CLMKimbrly Baker1956-01-26——8898 Lake View Rd, San Diego, CA, 921190.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60753TPANoah Cooper1993-07-02——1754 Sage Ct, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111949ENRJacob W Fowler1940-06-26UHC-65588-2744271175832147 Valley View Dr, Miami, FL, 331400.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403858CLMMei Rogers1954-02-16UHC-86487-5251497943714173 Pine Dr, San Antonio, TX, 782730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52943TPAJudith Daniels1940-03-13UHC-61314-90—862 Sunset Blvd, Phoenix, AZ0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-139419ENRPatricia E Foster1974-04-19UHC-51732-0470838028432238 Spring St, Los Angeles, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110959ENRMelissa U Parker—UHC-58335-2542321372685230 Cedar Ln # 756, Sacramento, CA, 958330.50Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-63450TPARalph Garcia1945-04-22——2592 Forest Ave # 444, Miami, FL, 331150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-427288CLMMarcus Jensen1968-07-11UHC-67757-3049886498852794 Pine Dr # 182, San Antonio, TX, 782420.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-55722TPAMary Powell2007-09-09——2667 Indian School Rd, Atlanta, GA, 303360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55723TPAMary Powell2007-09-09——2667 Indian School Rd, Atlanta, GA, 303360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105852ENRJerry P Wheeler1977-06-17——4541 Meadow Ln, Atlanta, GA, 303440.50Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415095CLMNathan Burton1997-10-09UHC-04380-9998567645773629 Union St # 220, Atlanta, GA, 303080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-64017TPAHeather Carpenter1995-04-21——7891 Forest Ave, San Diego, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 97 of 2,000PreviousNext