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-27758PRVBrittany Walsh1984-05-09UHC-72666-0296640138226263 Forest Ave, Denver, CO, 802200.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22443PRVShirley Butler1993-09-06UHC-47514-262996140395218 Canyon Rd, Phoenix, AZ, 850060.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-25896PRVSandra Lawis2005-01-08———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-26309PRVWalter X Barnes1942-03-12—9788172803—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21710PRVFatima Anrews1965-10-25UHC-06226-0346743756287295 Lincoln Way, Tucson, AZ, 857330.94Name re-casedPhone reformattedEmail lower-cased
PRV-21520PRVHiroshi Brown1975-12-15—53831519124342 Oak St, Tempe, AZ, 852960.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24059PRVBradley R Freeman1999-10-11—5472081684—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21719PRVRandy Hawkins1963-06-06UHC-99256-514508173685—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-24327PRVSofia Clark1987-06-19—3607268580—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22362PRVEdward X Cunningham1941-03-16——2332 Broadway, Dallas, TX, 752400.94Address re-casedEmail lower-casedPlaceholder values cleared
PRV-22527PRVSantiago Fowler1946-12-10UHC-38032-37—566 Broadway, Las Vegas, NV, 891970.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-22526PRVSantiago Fowler1946-12-10UHC-38032-37—566 Broadway, Las Vegas, NV, 891970.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-25051PRVOlivia K Bradley1950-11-05—5058067939293 Grand Ave, Sacramento, CA, 958730.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22724PRVWayne Arnold1964-08-20—7845295243—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27100PRVTerry Davis1976-05-26UHC-12131-1334031354797984 River Rd, Glendale, AZ, 853320.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-28872PRVAna G Kelly1984-10-08—65183176988504 Willow Ct, Charlotte, NC, 282120.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28766PRVBetty Q Sandoval1944-09-25UHC-13305-4743542363481080 Desert Sky Blvd, Dallas, TX, 752270.94Phone reformattedPlan code upper-casedPlaceholder values cleared
PRV-24360PRVRandy Meyer1984-07-26—7072619905—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27470PRVMason Edwards1998-08-27—7264066114—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24383PRVAmanda Parker1947-02-27UHC-47167-272938298489—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20146PRVBeverly M Soto1963-07-03UHC-65304-7321295541144080 Central Ave, Minneapolis, MN, 554010.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-21210PRVKathleen Ortiz2001-05-28UHC-82174-7296844057487729 Park Pl, Minneapolis, MN, 554790.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27841PRVRussell Tran1946-10-01—41793342798161 Valley View Dr, Mesa, AZ, 852880.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-20438PRVGabriel Bursn1972-07-27UHC-16198-5893679875759184 Spring St, Atlanta, GA, 303260.94Date of birth reformattedCity re-casedPlaceholder values cleared
PRV-21919PRVJanice Gutierrez1970-06-20—4998666057—0.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26074PRVJennifer Watkins1993-04-21UHC-27706-653146720042—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21527PRVAnna T Jordan2002-11-01—53149865919449 Maple Ave, Atlanta, GA, 303450.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22270PRVAmanda F Boyd1939-06-26—3964094126—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-26150PRVJordan F Rose1980-10-09—8165713463—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-27796PRVNtahan Wech2003-12-10UHC-78955-8172096962661747 Sunset Blvd, Fresno, CA, 937990.94City re-casedEmail lower-casedPlaceholder values cleared
PRV-24854PRVHiroshi Hudson1986-01-26—75467832966665 Washington St, Orlando, FL, 328420.94City re-casedWhitespace trimmedPlaceholder values cleared
PRV-20144PRVSantiago Peters1999-11-21UHC-16126-8590940436138248 Willow Ct, San Antonio, TX, 782100.94State code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-29325PRVPatrick Spencer1951-04-14———0.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-23009PRVAlbert Stephens1967-02-04UHC-44227-93—5794 Ridge Rd, Columbus, OH, 432130.94State code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-20751PRVArthur D Guzman1950-07-01——2337 Broadway, Eden Prairie, MN, 553700.94Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-29377PRVShirley Boyd1972-08-14—6134102978—0.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-28250PRVMei Clark1987-03-09UHC-15546-2076589629294102 Sunset Blvd, Glendale, AZ, 853290.94Phone reformattedMember ID reformattedPlaceholder values cleared
PRV-27253PRVValentina Kennedy1943-08-06UHC-03137-73—5500 Ocean Ave, Glendale, AZ, 853690.94Name re-casedDate of birth reformattedPlaceholder values cleared
PRV-23651PRVKatherine B Snyder1982-05-12—48944115439191 Broadway, Fresno, CA, 937540.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-27484PRVChristina U Lee1954-12-17—53992955091174 Oak St, Minneapolis, MN, 554190.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-27846PRVLori Allen1938-12-02UHC-74577-6096892912752361 Market St, Plano, TX, 750990.94Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23230PRVVyrginia Hudson1954-05-12UHC-60725-8686163886084992 Washington St, Dallas, TX, 752260.94Phone reformattedEmail lower-casedPlaceholder values cleared
PRV-23049PRVRonald Dominguuez1989-05-26UHC-96584-75——0.94Name re-casedEmail lower-casedPlaceholder values cleared
PRV-28504PRVBradley Kelley1979-09-06UHC-90063-136623691927—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-22977PRVRaymond Washinngton1993-04-26—3304926594—0.94Name re-casedPhone reformattedPlaceholder values cleared
PRV-24724PRVTyler Padilla1974-03-25UHC-67281-64—7057 Mesa Dr, Tempe, AZ, 852970.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-23464PRVValentina Ortiz1953-05-05—5086820139—0.94Name re-casedWhitespace trimmedPlaceholder values cleared
PRV-22737PRVValentina I Allen1986-02-20—7009958204461 Baseline Rd, San Diego, CA, 921480.94City re-casedWhitespace trimmedPlaceholder values cleared
PRV-24384PRVAmanda Parker1947-02-27UHC-47167-272938298489—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21680PRVJack Armstrong1965-07-16—25775599699598 Oak St, Atlanta, GA, 303560.94State code upper-casedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 174 of 192PreviousNext