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-426081CLMMason Smith1961-02-15UHC-13514-3526625256693073 Jefferson Ave, Tempe, AZ, 852890.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-128292ENRHnery Chen—UHC-33237-1435955777037603 Sunset Blvd, Dallas, TX, 752970.46Name re-casedDate of birth missingPhone reformattedMember ID reformatted+5 more
ENR-127559ENRKathleen UJunk1981-08-17UHC-96127-4641370389903451 Sunset Blvd, Orlando, FL, 328600.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119121ENRNatalie Sims—UHC-65915-9961680017343877 Main St, Las Vegas, NV, 891620.46Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-424924CLMDoris T Ford1958-02-28UHC-97244-05—1242 Lake View Rd # 450, Scottsdale, AZ, 852240.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
ENR-136623ENRValentina Payne1974-01-26UHC-22618-4688465799594929 Church St, Jacksonville, FL, 322880.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-110806ENRJonathan Sanndoval1962-03-06UHC-01777-8581072130772173 Mesa Dr Apt 33, Nashville, TN, 372990.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-414448CLMEmily Wels1971-03-28—87982403102695 Mountain View Dr, San Diego, CA, 921550.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-105477ENRElijah M Delgado1982-04-20UHC-99236-8826450034784532 Canyon Rd, Sacramento, CA0.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-122462ENREvelyn P Colmean1987-02-14UHC-14941-9323596813181338 Ridge Rd, Gilbert, AZ, 852530.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-104456ENRAisha N Cole1975-04-01UHC-86878-5045934169894922 Cedar Ln, Minneapolis, MN0.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-125435ENRMary B Cook1976-10-13UHC-16807-5226437911107214 Palm Dr Apt 36, Nashville, TN, 372490.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-105318ENRBryan Li1943-02-22UHC-16862-6787933303945152 Central Ave, Glendale, AZ, 853860.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-105781ENRGerald Powell1948-10-22UHC-96423-732937337385730 Camelback Rd, San Antonio, TX0.46Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-25087PRV—Junk2005-01-27—88389637838651 Highland Ave, Nashville, TN, 372790.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-128863ENRWalter Q Porter1954-07-21UHC-68877-7547456789888571 Lincoln Way, Tempe, AZ, 852530.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-128862ENRWalter Q Porter1954-07-21UHC-68877-7547456789888571 Lincoln Way, Tempe, AZ, 852530.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-403067CLMAlexis Garza1972-01-15—65641501997046 Pine Dr, Eden Prairie, MN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-124231ENRSharon V Greene1982-12-09UHC-72907-7940248817056821 Grand Ave # 981, Miami, FL, 331320.46Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
ENR-112473ENRRuth U Larsun1960-08-11UHC-12479-7856592257451086 Forest Ave, Denver, CO, 802240.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-415239CLMAisha Owens2002-06-26UHC-84488-9623170753187806 Main St, Orlando, FL, 328680.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427674CLMGrace Wong2000-12-03UHC-13056-47—3571 Spring St, Sacramento, CA0.46Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-127157ENRSchmidt Sarah1965-01-28UHC-67055-1046082070298051 Willow Ct # 958, San Diego, CA, 921660.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-430178CLMEthan EJunk1961-03-01UHC-07381-6875838119828361 Indian School Rd, Nashville, TN, 372480.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-410288CLMAndrew McDonald—UHC-38489-9143743425557493 Sunset Blvd, Chandler, AZ, 852820.46Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-134370ENRBurce G Moore1964-11-19UHC-28109-7431566538921620 Willow Ct, Mesa, AZ, 852360.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
CLM-400369CLMGrace Burton1981-01-26UHC-52024-7528894499938064 Maple Ave, Columbus, OH0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-117844ENRGerald H Silva1976-09-23UHC-54444-8029355758733638 Valley View Dr, San Antonio, TX, 782840.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-405921CLMSteven Ortaga1941-03-27—28286261061456 Jefferson Ave, Tempe, AZ, 852390.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-407554CLMJack I Ray1943-10-02UHC-32122-3588634002984554 Meadow Ln, Phoenix, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-141739ENRLucia I Robertson1985-09-01UHC-90498-9859931454054263 Cedar Ln, Tempe, AZ, 852890.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416331CLMEllis Gerald1985-06-11—4103588512589 Mountain View Dr # 525, Tempe, AZ, 852520.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-24558PRVAisha Q Hendeerson1986-02-18UHC-27793-06—563 Spring St, San Antonio, TX, 782870.46Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-122826ENRKelly T Day1983-01-19UHC-30774-0197762297228106 Forest Ave, Gilbert, AZ, 852770.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
CLM-417154CLMRachelJunk1959-08-26UHC-31823-84—7580 Maple Ave, Eden Prairie, MN, 553540.46Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+5 more
ENR-102312ENRMariana Shaw1991-10-19UHC-03384-4655771066201773 Park Pl Apt 29, Nashville, TN0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-424978CLMDenise Anderson1987-05-16—29361298933970 Market St # 834, Las Vegas, NV, 891890.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-140594ENRSingh Katherine1989-10-16UHC-36821-7372463480229696 Mountain View Dr, Denver, CO, 802090.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-28677PRVAustin O Gordon1964-09-27UHC-50210-6238759105639313 Highland Ave # 505, Jacksonville, FL, 322400.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-123200ENRRachel F Maldonado—UHC-71621-2356048590589202 Main St, Austin, TX, 787200.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
CLM-402098CLMBrittany Taylor1982-05-25UHC-75127-0968581179456710 Valley View Dr, Mesa, AZ, 852990.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-420193CLMWei Miller1949-03-27UHC-77831-8769777705103062 Camelback Rd, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-139679ENRMariana K Mitchell1972-03-12UHC-47406-207717381941762 Sage Ct, Tempe, AZ0.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-108623ENRJustin G Cooper1991-11-18UHC-26825-5022886196777406 Spring St, Miami, FL, 331430.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-116972ENRGreg Washington1972-09-15UHC-30230-1444741423479052 Forest Ave, San Diego, CA, 921770.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-117257ENRDlan Hunter1970-12-16UHC-44105-8092092007624137 Sunset Blvd, Fresno, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-420533CLMMertha Q Salazar1982-06-10UHC-04503-8561340084128402 Pine Dr, Plano, TX, 750410.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-417786CLMWalter Chavez1994-05-07—34168095907980 Maple Ave, Austin, TX, 787610.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-135601ENRMarilyn R Sullivan1952-05-20UHC-59465-8027485195085246 Desert Sky Blvd, Miami, FL, 331430.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-426200CLMCheryl Padilla1978-04-06UHC-20056-0464466863729498 Forest Ave, Tempe, AZ, 852600.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
100,000 rows, page 47 of 2,000PreviousNext