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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-29403PRVChristian G Meedina1970-02-20UHC-32287-1629923978274608 Pine Dr, Charlotte, NC, 282470.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25285PRVMike S Lynch1940-03-05UHC-82219-8483254944104883 Park Pl, Tempe, AZ, 852020.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-24816PRVLarry Z Richardson1968-09-23—9896256904397 Oak St, Orlando, FL, 328110.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23591PRVBeverly Padilla1988-12-19—6967591907404 Park Pl, Denver, CO, 802560.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-24559PRVNoah Bryant1949-03-15—67688152088174 Pine Dr, Jacksonville, FL, 322620.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-28608PRVJanet B Myers1976-03-26UHC-34234-7334363290391433 Jefferson Ave, Jacksonville, FL, 322060.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-28609PRVJanet B Myers1976-03-26UHC-34234-7334363290391433 Jefferson Ave, Jacksonville, FL, 322060.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-20418PRVSara W Gommez2002-04-12UHC-60271-3865365452305624 Elm St, Columbus, OH, 432980.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27947PRVMichelle P Baker1989-05-27——3246 Sage Ct, San Diego, CA, 921110.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-24980PRVSandra Hoffman1969-10-27UHC-22666-9878888983717038 Desert Sky Blvd, Mesa, AZ, 852530.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-24979PRVSandra Hoffman1969-10-27UHC-22666-9878888983717038 Desert Sky Blvd, Mesa, AZ, 852530.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-24433PRVNathan Burton1997-10-09—98567645773629 Union St, Atlanta, GA, 303080.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26494PRVPhilip Olson1949-06-10UHC-04127-2772798440013574 Lake View Rd, Chandler, AZ, 852100.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22319PRVJacqueline I Williamson1953-06-01——1442 Canyon Rd, Las Vegas, NV, 891620.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27598PRVHarold Porter1942-05-01—26986219522658 Grand Ave, Glendale, AZ, 853720.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22151PRVBradley Carr1998-11-03——2339 Jefferson Ave, Phoenix, AZ, 850290.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25836PRVBeverly Lynch1991-04-16——7879 Washington St, Sacramento, CA, 958670.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26099PRVBryan Ryan2005-03-05UHC-33706-7786842797619245 Highland Ave, Tempe, AZ, 852700.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20740PRVJames Delgado1977-12-02UHC-33344-7022083981877763 Broadway # 785, Tampa, FL, 336490.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-26798PRVIsabella Watson1977-02-03UHC-11528-2567957117216426 Washington St, Houston, TX, 770660.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
PRV-20271PRVKayla C Shaw1986-11-15UHC-04156-50—7030 Washington St, Plano, TX, 750490.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25537PRVJack Clark1967-02-09—64745223319312 Sage Ct, Jacksonville, FL, 322430.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20712PRVAustin Z Palmer—UHC-12179-4295467476948866 Hillcrest Rd, Minneapolis, MN, 554980.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-22656PRVAlan Henry1984-04-13UHC-13004-1661187103111586 Maple Ave, Jacksonville, FL, 322430.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-22971PRVBeverly Robinson1982-01-25——9497 Sage Ct, Scottsdale, AZ, 852240.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20459PRVHenry Jordan1964-09-22—6607726878—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25202PRVHeen Thomas1941-02-13—44051976343663 Sage Ct, Tempe, AZ, 852950.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-20206PRVAlbert Morales1949-06-03——4504 Lake View Rd, Gilbert, AZ, 852150.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23118PRVEthan J Lopez1993-10-04UHC-85031-6852832247932946 Central Ave, Austin, TX, 787500.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22286PRVAmy O Elliott1950-07-18UHC-43246-58—7041 Elm St, Phoenix, AZ, 850700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23382PRVJeffrey Wagner1981-04-19—76765707078796 River Rd, Nashville, TN, 372990.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22080PRVDonna Garza1997-09-22—33756633528852 Maple Ave, Columbus, OH, 432990.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-27879PRVMegan Sandoval2004-12-05UHC-35590-2789780765458968 Highland Ave, Atlanta, GA, 303270.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25599PRVCarlos Young1985-03-14UHC-22068-3775647109438579 Spring St, Tampa, FL, 336780.80Name split from “Last, First”Member ID reformattedCity re-casedPlaceholder values cleared
PRV-27985PRVBilly Rose1964-03-08UHC-55154-3685531231425030 Cedar Ln Apt 27, Phoenix, AZ, 850350.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-24890PRVBradley Ford1955-09-13——8827 Sage Ct, Chandler, AZ, 852960.80Street suffix standardisedAddress re-casedPlan code upper-casedPlaceholder values cleared
PRV-21348PRVMasun Bowman1979-01-19UHC-89875-5841438945021815 Sunset Blvd, Atlanta, GA, 303480.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28359PRVLinda Boyd1993-03-26UHC-33993-6292131916423073 Highland Ave, Jacksonville, FL, 322820.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20929PRVDiego S Nunez2001-11-26——6629 Canyon Rd, Scottsdale, AZ, 852140.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-23035PRVMelissa Pattarson1964-03-08—308573827564 Elm St, Sacramento, CA, 958450.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27601PRVAlice I Hunter2006-08-21—60056918132357 Indian School Rd, Plano, TX, 750620.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28663PRVAnna Harvey1968-10-09——3429 Forest Ave Apt 31, Chandler, AZ, 852740.80Name re-casedUnit split from streetState code upper-casedPlaceholder values cleared
PRV-22877PRVChristina Stone1992-04-11UHC-37469-453259577841100 Lake View Rd, Columbus, OH0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-26067PRVJerry Martin1939-03-08UHC-90262-1535156037258116 Ridge Rd, Nashville, TN, 372560.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27224PRVBilly Larson1991-03-08UHC-69765-55—2175 Mesa Dr, Austin, TX, 787800.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22089PRVKatherine Hernandez1940-11-01UHC-76710-6894791670053537 Broadway Apt 38, Glendale, AZ, 853490.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-20946PRVDavid F Garcia2008-01-09UHC-62582-3426356536856698 Mesa Dr, San Diego, CA, 921470.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29544PRVTimothy Q Bryant1980-04-17UHC-71520-1953160435154466 Ridge Rd, Phoenix, AZ, 850090.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-23665PRVRalh U Weaver1945-03-16UHC-96928-8984953461812322 Hillcrest Rd, Miami, FL, 331230.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22384PRVJoan Morris2007-12-21UHC-13242-9864627048057097 Pine Dr, San Diego, CA, 921400.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 128 of 192PreviousNext