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-20609PRVMike Boyd1992-07-23UHC-19257-7839754317575328 Ridge Rd, San Antonio, TX, 782310.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21468PRVPatricia Grant1962-11-13UHC-86096-7431774523902725 Hillcrest Rd, Mesa, AZ0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22251PRVPatricia Schultz1940-11-24UHC-79313-9041450670738206 Union St, Denver, CO, 802960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-29495PRVJudy Chen1980-06-18—73523803717401 Desert Sky Blvd, Fresno, CA, 937900.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-26223PRVScott Hansen1943-04-11——212 Meadow Ln, Minneapolis, MN, 554010.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-28020PRVCamila Phillips1977-11-17UHC-26863-5738737905873465 Hillcrest Rd # 705, Atlanta, GA, 303050.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28611PRVHarold Green———5450 Spring St, Seattle, WA0.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
PRV-24002PRVLogan T Pihllips1962-04-09UHC-41116-08—2237 Market St # 861, Seattle, WA0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22390PRVSarah Marshall1941-06-20——4580 River Rd, Tucson, AZ, 857080.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-21289PRVHenry Y Little1979-03-06—47777834286925 Hillcrest Rd, Plano, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22354PRVWayne I Chavez1995-08-11UHC-99718-582886107037586 Ocean Ave, Fresno, CA, 937250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21320PRVCastro John1993-10-13UHC-60495-9562740799063188 Spring St Apt 20, Orlando, FL, 328400.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28540PRVJesse Bell1983-01-06—32820750036700 Spring St, Orlando, FL, 328590.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-29546PRVHiroshi Butler—UHC-41564-7334871747484742 Oak St, Denver, CO0.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
PRV-21568PRVJoshua Hill1990-06-01UHC-62851-11—1228 Central Ave, Seattle, WA, 981250.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21965PRVNunez Jacqueline1947-06-14UHC-70312-0645927463672269 Sage Ct, Glendale, AZ, 853420.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28667PRVAustin I Parker1952-07-03UHC-47167-0732680669713166 Spring St, Miami, FL, 331230.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21966PRVJessica Johnson1979-10-05UHC-65449-185357954278222 Harbor Blvd, Las Vegas, NV0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27863PRVPaul Coleman—UHC-62015-2874181465808638 Main St Apt 16, Miami, FL, 331700.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-29238PRVMichelle Gonzales1973-12-03UHC-28818-2861993423406915 Church St # 661, Sacramento, CA, 958870.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-29285PRVLogan W Clark1996-08-06UHC-45189-8834156870633642 Meadow Ln, Las Vegas, NV0.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
PRV-29284PRVLogan W Clark1996-08-06UHC-45189-8834156870633642 Meadow Ln, Las Vegas, NV0.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
PRV-28728PRVAlexis Singh2007-12-05—89959326296744 Desert Sky Blvd, Las Vegas, NV, 891520.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22113PRVChristine Marshall1978-11-02—53078156233165 Elm St, Houston, TX, 770950.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26959PRVLarry Cox1983-06-01—95537066584973 Grand Ave # 668, Tampa, FL0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27092PRVRalph Espinoza1938-09-14UHC-65631-51—2235 Highland Ave Apt 26, Tempe, AZ, 852110.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22920PRVBilly F Mendez1978-12-26——3385 Desert Sky Blvd, Chandler, AZ0.50Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+3 more
PRV-22288PRVRaymond Banks2004-07-09UHC-53680-51—2102 Central Ave, Denver, CO, 802360.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-27341PRVAlan Mendez1999-04-23—27051002809237 Lincoln Way, Las Vegas, NV, 891350.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26160PRVEvelyn Rios—UHC-61519-1497387309675133 Grand Ave # 470, Tucson, AZ, 857540.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24985PRVJohn Contreras1945-12-13—45680266163814 Union St, Tucson, AZ, 857180.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-25094PRVHanah Lucas1986-12-09UHC-54951-7071456553619358 Mountain View Dr, Plano, TX, 750670.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-28866PRVMaria Reed1944-03-19—87773276137228 Ridge Rd, Jacksonville, FL, 322570.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20857PRVAllice Wallace1939-07-04UHC-88572-65—1501 Main St, Orlando, FL, 328750.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21498PRVSophia M Anderson1944-05-23UHC-17148-9870691637602387 Sage Ct, Houston, TX0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
PRV-23633PRVKathleen Lane2001-01-26—49497250277643 Highland Ave Apt 13, Miami, FL, 331930.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-27410PRVGloria Watkins1974-11-18UHC-01940-8057136831337662 Church St, San Antonio, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29359PRVKyle J Bishop1940-01-05UHC-06507-6682377040501367 Grand Ave, Chandler, AZ, 852800.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24370PRVLawrence Carter———1881 Jefferson Ave, Scottsdale, AZ, 852060.50Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
PRV-20462PRVNatalie J Simpson1940-11-11UHC-12051-8349470905294332 Maple Ave, Jacksonville, FL0.50Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more
PRV-24199PRVJuan Castro1981-08-02——3666 Market St, Fresno, CA, 937130.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-28708PRVBradley Romero1955-02-12—33081484982559 Lake View Rd Apt 4, Jacksonville, FL, 322820.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
PRV-24526PRVZachary Jacobs1964-10-07UHC-67727-9940463924785070 Jefferson Ave, Las Vegas, NV, 891570.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-29520PRVMelissa Allen1954-02-25—83765211309662 Main St Apt 12, Chandler, AZ, 852840.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25351PRVLinda Lucas1951-03-06—4002711136592 Jefferson Ave, Tucson, AZ, 857610.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-23099PRVGregory Q Hudson1954-02-04—53563688208058 Main St, Nashville, TN, 372620.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29452PRVKelly Valdez2000-08-09——3063 Indian School Rd, Fresno, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-24955PRVLewis Ahmed1986-11-18—79147798221864 Baseline Rd, Miami, FL, 331550.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
PRV-24159PRVGerald Nguyen1995-06-26UHC-55379-89—7182 Canyon Rd, Chandler, AZ, 852040.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25621PRVEthan Mitchell1954-08-17UHC-64818-21—4533 Valley View Dr # 649, Atlanta, GA0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 12 of 192PreviousNext