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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-107311ENRGabriel P Salazar1943-02-04UHC-97571-1723781443434562 Union St, Gilbert, AZ0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109977ENRChristina I Perez1944-11-01—94530536264757 Ridge Rd Apt 5, Glendale, AZ, 853310.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-131509ENROmar D Ferguson1950-11-04UHC-22742-2460271456747551 Harbor Blvd, Los Angeles, CA, 900220.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-134155ENRAdam R Vasquez1973-04-07UHC-36719-4794172967375966 Cedar Ln, Charlotte, NC, 282880.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115846ENRDeborah Z Little1946-06-28—39589587732259 Jefferson Ave # 907, Charlotte, NC, 282250.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113971ENREvelyn V Coleman—UHC-59991-6275539331085757 Main St, Tampa, FL, 336720.50Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-134290ENRJeremy K Martin1940-04-16—30540133112692 Canyon Rd, Los Angeles, CA, 900230.50Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-136959ENRSamuel Warren2003-06-02UHC-67401-51—4561 Pine Dr, Mesa, AZ, 852460.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-140496ENROmar A Price1998-12-10UHC-59884-8433684215172765 Spring St, Scottsdale, AZ0.50Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
ENR-126930ENRKelly Burns1941-07-07UHC-13674-7725830465925638 Park Pl Apt 13, Chandler, AZ, 852860.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-127573ENRDaivd Powell2004-04-27UHC-50609-6292597410021225 Canyon Rd, Austin, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-122200ENRCarol Hall2004-04-28UHC-68238-77—6376 Desert Sky Blvd, Phoenix, AZ, 850180.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114594ENRCarl S Chhen1997-08-15UHC-16221-28—8246 Canyon Rd, Charlotte, NC, 282690.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121120ENRSean Allen—UHC-74463-6869728926739243 Union St, Seattle, WA, 981830.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-139678ENRRichard McDonald1966-04-08UHC-41907-9136040422541822 Central Ave, Orlando, FL, 328630.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-108415ENRTyler Dean2004-08-17UHC-36417-9656687124794144 Canyon Rd, Seattle, WA, 981770.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-138790ENRChristopher Wilson1946-12-07UHC-54608-6267959560015634 Washington St Apt 15, Tucson, AZ, 857760.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-125460ENRNoah Roberts1953-07-09UHC-09396-3868583620985412 Main St, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-136440ENRMark Lopez—UHC-01657-312959574362810 Mesa Dr, Sacramento, CA, 958120.50Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-117422ENRTony G Aguilar1989-11-06UHC-75197-95—7798 Mountain View Dr, Tempe, AZ, 852880.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-112009ENRJose Espinoza—UHC-99113-0275142000568225 Market St # 129, Seattle, WA, 981290.50Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-114313ENRWJunk1984-06-12UHC-76015-4657445027591221 Harbor Blvd, Chandler, AZ, 852700.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-104811ENRVictoria A Bennett1956-05-07UHC-20682-6522546849319161 Maple Ave # 210, Tempe, AZ, 852650.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-115150ENRDooris Cox1987-05-05UHC-68670-2561650299019747 Hillcrest Rd, Seattle, WA, 981000.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-102951ENRCharles Z Olson1970-04-02UHC-73785-8320627514765690 Meadow Ln # 607, Phoenix, AZ, 850270.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-101917ENRFatima Stevens1979-04-05UHC-61847-88—715 Spring St, Scottsdale, AZ0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-130782ENRJerry Q Moore1963-04-12UHC-01331-3282146626495838 Lincoln Way, Columbus, OH0.50Name re-casedCity re-casedState name converted to codeZIP missing+3 more
ENR-100631ENRKenneth Y Edwards2002-12-07UHC-87921-7191081517526068 Forest Ave, Sacramento, CA, 958070.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-133308ENRMegan Ortiz1961-08-20UHC-20744-1840958603859249 Desert Sky Blvd, Los Angeles, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112827ENRMegan Reed2005-11-11UHC-55099-8624281316238402 Mesa Dr, Sacramento, CA, 958120.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127068ENRZachary Pena1950-06-06UHC-45681-3437991116966126 Mountain View Dr, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-140074ENRPhilip Z Stephens1940-02-17UHC-52177-385218261425145 Cedar Ln, Dallas, TX, 752710.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128725ENRKimberly M James2002-07-23UHC-59619-3326897890081599 Hillcrest Rd, Seattle, WA, 981610.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-125162ENRJudy V Hoffman1949-11-07UHC-63831-1582397707759408 Valley View Dr, Phoenix, AZ, 850160.50Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+3 more
ENR-112879ENRAshley Lopez1944-08-15UHC-75234-8369340616501743 Sage Ct Apt 5, Denver, CO, 802720.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-125075ENRGerald Little1996-11-14UHC-94042-5169159416523476 Ocean Ave, Columbus, OH, 432970.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118573ENRPriyya Moore1977-07-03UHC-65655-6348628872448579 Hillcrest Rd, Glendale, AZ, 853640.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-113302ENRDebra M Bradley1971-01-11UHC-29050-7375452612871134 Maple Ave, Scottsdale, AZ, 852540.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-121042ENRDiane A Hunter1964-01-01UHC-50127-4989837748268372 Lake View Rd Apt 30, Plano, TX, 750120.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120879ENRDebra Young1945-02-12UHC-20229-0556426813558723 Park Pl, Houston, TX, 770500.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120530ENRBarbara C Fisher1938-06-16UHC-18628-8657288192694226 Church St, Orlando, FL, 328220.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-122540ENRAshlye Fields1986-05-25UHC-74750-4575224248986344 Forest Ave, Jacksonville, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127444ENREthan M Taylor1997-03-22UHC-84782-4978846470564991 Lincoln Way, Austin, TX, 787860.50Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-140285ENRHiroshi Y Sims1972-10-22UHC-85479-928352798010393 Lincoln Way, Fresno, CA, 937660.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
ENR-133892ENRKathryn Waren1959-03-12UHC-71018-9431671364606289 Jefferson Ave, Los Angeles, CA, 900130.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120659ENRKayla Kim1993-05-19UHC-11035-6230947464339631 Church St # 591, Los Angeles, CA, 900920.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130458ENRVJunk1999-05-04UHC-41301-4176635427432788 Sage Ct, Plano, TX, 750350.50Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-136968ENRMaason H George1999-06-17UHC-70059-3963183697638193 Meadow Ln, Gilbert, AZ, 852360.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108696ENRCynthia Q Owens1961-04-27UHC-95956-5771824249789409 Main St, Phoenix, AZ, 850510.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120858ENRTeresa Fox1961-05-17UHC-55652-5770834514643267 Camelback Rd, Minneapolis, MN, 554370.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
43,101 rows, page 48 of 863PreviousNext