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-24235PRVStephen Romero1987-01-15UHC-58897-9776449125667926 Camelback Rd, Eden Prairie, MN, 553160.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27818PRVDenise Smith1962-02-23—77224645643876 Baseline Rd, Tucson, AZ, 857050.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26427PRVBrenda W Edwards1966-12-10—86347944685077 Hillcrest Rd, Charlotte, NC, 282040.76Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
PRV-20390PRVSteven Y Lewis1941-11-08—96146925905512 Ridge Rd, Glendale, AZ, 853790.76Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
PRV-26720PRVBen Fuller1964-03-15UHC-11971-67—4702 Spring St, Nashville, TN, 372370.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-22769PRVMariana Johnson1997-03-21—44048210641867 Mountain View Dr, Dallas, TX, 752060.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22428PRVNicholas Williamson1986-07-06—26841335154949 Canyon Rd, Minneapolis, MN, 554720.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28505PRVJudy Patterson1998-03-07—24556738227921 Church St, Austin, TX, 787670.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27534PRVDouglas Edwards1962-05-28—66762983036463 Palm Dr, Denver, CO, 802460.76Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
PRV-22423PRVSandra Ryan1995-12-02—88964397033076 Spring St, Chandler, AZ, 852500.76Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
PRV-25496PRVHiroshi Powell1951-07-05UHC-87923-9642585249047769 Camelback Rd, Tucson, AZ, 857590.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26194PRVHenry Myers1953-05-04—21320714182969 Cedar Ln, Las Vegas, NV, 891000.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21356PRVAmy Fuller1982-08-24—74927607626125 Pine Dr, Tucson, AZ, 857460.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26027PRVAlan J Kelly1973-05-25—33253315718577 Baseline Rd, Jacksonville, FL, 322990.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28086PRVAlexis Salazar2003-10-05UHC-58806-0937975061434868 Lake View Rd, Las Vegas, NV, 891820.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27805PRVMichael Schmidt2004-10-28UHC-23738-8057995662397258 Harbor Blvd, Dallas, TX, 752680.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21596PRVKevin Payne1968-05-07UHC-53463-3382093627518737 Desert Sky Blvd, Seattle, WA, 981250.76Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-28017PRVFatima Freeman1986-09-04UHC-38123-2654382163986623 Church St, Glendale, AZ, 853780.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27349PRVArjun B Coleman1985-06-02—84974508219309 Willow Ct, Scottsdale, AZ, 852330.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20545PRVWayne Howell1965-10-08—38848111269750 Central Ave, Tempe, AZ, 852300.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22262PRVSofia Castro1999-02-28—87046680833667 Cedar Ln, Charlotte, NC, 282530.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
PRV-23442PRVGloria Holmes1985-08-04UHC-47269-708878901218606 Jefferson Ave, Seattle, WA, 981230.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21272PRVGregory Ward1981-01-22UHC-42600-614227143570886 Bayshore Dr, Miami, FL, 331590.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21273PRVGregory Ward1981-01-22UHC-42600-614227143570886 Bayshore Dr, Miami, FL, 331590.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21635PRVJack Ortiz1957-12-15UHC-23081-519454820627—0.76Name re-casedPhone reformattedMember ID reformattedGender normalised+2 more
PRV-26895PRVJeffrey S Gutyerrez2001-02-05—53045068038454 Forest Ave, Dallas, TX, 752880.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24632PRVCynthia J Mitchell1993-08-18UHC-39160-112164820816308 Broadway, Tampa, FL, 336020.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-24631PRVCynthia J Mitchell1993-08-18UHC-39160-112164820816308 Broadway, Tampa, FL, 336020.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-24001PRVJerry Vasquez1939-08-13—63895723986965 Camelback Rd, Tampa, FL, 336810.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23038PRVAhmed Burke1958-06-22UHC-38144-7238776477452720 Spring St, Minneapolis, MN, 554350.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21493PRVEmma O Reed1991-06-07UHC-91196-416332224385161 Desert Sky Blvd, Charlotte, NC, 282940.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-26216PRVDavid Ray2006-09-26—53797773468279 Mountain View Dr, Phoenix, AZ, 850140.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26896PRVJeffrey Gutierrez2001-02-05UHC-79792-5253045068038454 Forest Ave, Dallas, TX, 752880.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-26061PRVCatherine Contreras1972-02-12UHC-37529-4836057693148879 Grand Ave, Dallas, TX, 752910.76Name re-casedPhone reformattedEmail lower-casedGender normalised+2 more
PRV-28612PRVCheryl Sanchez2004-10-26UHC-38922-4633584078618988 Ocean Ave, San Antonio, TX0.76Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more
PRV-28397PRVJack Warren1966-02-10—84076979797172 Mountain View Dr, Los Angeles, CA, 900370.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23684PRVJack W Ryan1945-08-05—82768864186718 Church St, Scottsdale, AZ, 852510.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23019PRVNicole Munoz2006-06-19—44476106559023 Church St, Nashville, TN, 372480.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20175PRVDaniel Y Burton——75443226568924 Canyon Rd, Phoenix, AZ, 850210.76Name re-casedDate of birth missingPhone reformattedState code upper-cased+2 more
PRV-28008PRVRonald R Hicks1976-02-20—34634555688513 Union St, Tampa, FL, 336710.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25462PRVBarbara F James1988-06-23—65895042072480 Ocean Ave, Miami, FL, 331030.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27113PRVSarah Reed1945-11-23—47733369205662 Oak St, Los Angeles, CA, 900520.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22706PRVTerry E Rivera1993-04-10—23394556834242 Hillcrest Rd, Miami, FL, 331590.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25355PRVWilliam Ryan1991-12-16—25242749788692 Forest Ave, Nashville, TN, 372020.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24288PRVKevin Morris1938-05-10UHC-09232-8239238782872441 Forest Ave, Tucson, AZ, 857070.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27730PRVHeather Rios1960-07-24UHC-67463-2364729547796475 Desert Sky Blvd, Sacramento, CA, 958270.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21253PRVAlexis Edwards1976-03-25—2863973708561 Indian School Rd, San Antonio, TX, 782010.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26650PRVPamela Tran1947-06-05—74493482014889 Spring St # 189, Sacramento, CA, 958280.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
PRV-28735PRVKaren Hayes1944-09-06UHC-95889-2349734069126714 Union St, Eden Prairie, MN, 553860.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22164PRVPeter Elliott1976-10-08—40986082846020 River Rd Apt 8, Charlotte, NC, 282470.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
9,596 rows, page 95 of 192PreviousNext