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-21117PRVLucia Adams1959-08-01UHC-55025-65—9384 Broadway, Fresno, CA, 937690.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-23296PRVAngela King1988-12-23UHC-91366-315689376706—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-23745PRVBilly X Herrera1962-09-18—85067695424332 Grand Ave, San Diego, CA, 921400.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-25053PRVLawrence Greene1987-01-10—29091955272538 Sage Ct, Austin, TX, 787360.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-24206PRVRebecca Lewis1967-03-26—8059327399—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-22176PRVPatrick C Carroll1986-01-15——9191 Meadow Ln, San Antonio, TX, 782800.94Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-27112PRVSarah Reed1945-11-23UHC-93227-2647733369205662 Oak St, Los Angeles, CA, 900520.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-28233PRVJanice L Hamilton1977-02-23—39667201566541 Cedar Ln, Las Vegas, NV, 891370.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-28742PRVAlan Olson1953-01-19UHC-34288-51—9036 Ridge Rd, San Antonio, TX, 782010.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-24083PRVSophia Hart1944-01-04UHC-60761-4569047056304177 Grand Ave, Las Vegas, NV, 891090.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-21992PRVZachary Palmer1947-02-28UHC-29115-60—5230 Apache Blvd, Dallas, TX, 752250.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-25002PRVGary Larson1962-04-20—5447586594892 Elm St, Columbus, OH, 432790.94Phone reformattedCity re-casedPlaceholder values cleared
PRV-27321PRVWillie Rivera1997-04-28UHC-34561-9067531147653895 Meadow Ln, Los Angeles, CA, 900670.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-27814PRVPaul Marshall1962-10-12—5663160388—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-25081PRVKayla Gibson1942-11-11UHC-77064-166126257015—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20134PRVSarah Patterson2000-04-06UHC-49912-646097536003—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20133PRVSarah Patterson2000-04-06UHC-49912-646097536003—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22960PRVTeresa Yang1939-07-03UHC-95957-355948036884—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-26278PRVMichelle Clark1987-06-28—71862752434196 Union St, Miami, FL, 331160.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28310PRVMichelle Harrison2000-04-28——2767 Indian School Rd, Jacksonville, FL, 322040.94Name re-casedState code upper-casedPlaceholder values cleared
PRV-21931PRVMaria Y Dean1956-04-23UHC-74698-76——0.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-24322PRVSandra Y Obrien1985-10-07UHC-52659-90—7731 Spring St, Atlanta, GA, 303200.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-20960PRVKevin U Price1963-08-28UHC-73391-84——0.94Member ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-23798PRVThomas Washington1951-03-13—5276232503—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22919PRVSophia Richardson1964-07-02—72032370012328 Church St, Plano, TX, 750040.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22834PRVWillie X Reed2000-02-02UHC-69931-099466321803—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-29515PRVCheryl Carr1981-12-11—6254293747—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-27696PRVJames N Bishop1953-11-23UHC-85304-868999219614—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-23182PRVTimothy Wang1971-12-13———0.94Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-26649PRVRalph A Mendoza1977-11-03UHC-00344-497793092735—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20059PRVLaura Wood2002-09-06—71960735332088 Union St, Seattle, WA, 981450.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-25490PRVKimberly A Morrison1943-11-19UHC-34877-544459186280—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25970PRVDiane Hughes2002-11-27UHC-73105-6256447131615255 River Rd, Seattle, WA, 981340.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-27089PRVWilliam R Diaz1966-03-12UHC-98786-0466521928175805 Meadow Ln, Orlando, FL, 328460.94Phone reformattedCity re-casedPlaceholder values cleared
PRV-28372PRVHannaah D Little1967-01-19—62846913901136 River Rd, Phoenix, AZ, 850240.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21234PRVRaymond H Hanson1990-05-20UHC-40217-49—3321 Grand Ave, Atlanta, GA, 303880.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-20367PRVEmma Vasquez1986-08-05UHC-95934-3291930754991098 Market St, Dallas, TX, 752490.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-21884PRVMary A Ward1961-12-07UHC-18681-668258766177—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-22907PRVTimothy Lucas1939-02-26UHC-65767-0879535802226117 Grand Ave, Las Vegas, NV, 891710.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-20950PRVChristina Jones1975-05-11UHC-72951-0151764727592696 Mesa Dr, Atlanta, GA, 303950.94Phone reformattedCity re-casedPlaceholder values cleared
PRV-20796PRVKatherine Hilll1979-09-20UHC-53855-277516947971983 Spring St, Fresno, CA, 937310.94Phone reformattedState code upper-casedPlaceholder values cleared
PRV-28654PRVDick O Harrison1953-09-09—77827979829432 Grand Ave, Fresno, CA, 937780.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21639PRVBrandon Snyder1968-12-04UHC-55662-935819701183—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29150PRVStephen Butler2000-08-09—62338792351461 Pine Dr, Atlanta, GA, 303540.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-27778PRVDiana Conntreras1973-04-08—52892025909178 Lake View Rd, Miami, FL, 331990.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-22124PRVWallace Ahmed1970-07-11———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-26867PRVSean S James1978-05-06—91127573147309 Mountain View Dr, Tucson, AZ, 857580.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-26866PRVSean S James1978-05-06—91127573147309 Mountain View Dr, Tucson, AZ, 857580.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-23653PRVShirley Coleman1954-03-14——6553 Lake View Rd, Austin, TX, 787550.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-21149PRVJudith Myers1946-09-27—53638323277974 Ocean Ave, Austin, TX, 787580.94Phone reformattedEmail lower-casedPlaceholder values cleared
9,596 rows, page 177 of 192PreviousNext