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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-22725PRVCheryl Kelly1972-12-28UHC-30817-377453931076—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22991PRVAbigail Mertinez1967-03-08UHC-84886-9775125229002815 River Rd, Mesa, AZ, 852120.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21566PRVCarolyn Wallace1999-01-07—48471708682659 Grand Ave, Tampa, FL, 336680.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22912PRVCharlotte G Larson1991-02-27——7747 Pine Dr, Charlotte, NC, 282660.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28810PRVValentina Williams1982-09-21—92865125468185 Mesa Dr, Columbus, OH, 432870.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20107PRVCharles Willis1954-04-17—77832700212631 Lincoln Way, Austin, TX, 787450.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-27774PRVJeremy Fields1941-08-04—6063411589806 Jefferson Ave, San Antonio, TX, 782640.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-26159PRVEvelyn Rios1993-08-16—97387309675133 Grand Ave, Tucson, AZ, 857540.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20398PRVMaria Washington1968-08-24—6074832921—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28106PRVAlexis Bennett1968-06-04—96743338538577 Broadway, Sacramento, CA, 958820.92Phone reformattedAddress re-casedCity re-casedPlaceholder values cleared
PRV-24692PRVMason Austin1986-12-16UHC-03632-1660534771924635 Willow Ct, Dallas, TX, 752170.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-25272PRVJustin Johnson1991-03-02UHC-90635-3065479591973789 Valley View Dr, Eden Prairie, MN, 553040.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-24977PRVBilly Aguilar1961-04-02—68655452614931 Lincoln Way, Las Vegas, NV, 891230.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-20900PRVAustin Hughes2000-06-04—4454953335138 Meadow Ln, Eden Prairie, MN, 553080.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25723PRVLisa V Hudson1957-01-10UHC-49171-42719276323619 Broadway, Phoenix, AZ, 850680.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26963PRVShirley L Harrison1940-04-24—7475212037—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21959PRVArjun R Hunt2002-02-13—7077887410—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22972PRVDylan F Wheeler2000-01-26—7058103344—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23597PRVPeter Bradley1993-02-25UHC-24216-2045359434199274 Sunset Blvd, Tampa, FL, 336950.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26063PRVGloria Johnson1987-03-02—69652148683218 Hillcrest Rd, Orlando, FL, 328260.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26433PRVMatthew Marquez1963-03-11—31065031843974 Harbor Blvd, Sacramento, CA, 958240.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-22038PRVRobert Tucker2004-07-14UHC-10873-926222042561—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-23311PRVJordan Bowman1977-09-10—3897491542732 Bayshore Dr, Jacksonville, FL, 322910.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24579PRVPaul C Lewis1972-03-11—6837386045—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28957PRVPeter Burtn1996-12-18—78250196379727 Cedar Ln, Houston, TX, 770340.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22774PRVSharon Rodriguez1956-10-07—36952702213427 Cedar Ln, Scottsdale, AZ, 852020.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22419PRVPriya Clark1940-07-26—7576815457—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21092PRVMaria Munoz1974-05-22UHC-02382-28—7712 Cedar Ln, Tempe, AZ, 852570.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-26949PRVAaron Rojas1938-03-27—44937019997749 Mesa Dr, Gilbert, AZ, 852250.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-24536PRVDaniel Warren2007-05-06UHC-75069-059287959436—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22287PRVRaymond Banks2004-07-09—88234346832102 Central Ave, Denver, CO, 802360.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23850PRVKatherine Gomez2008-07-28—75536359232883 Hillcrest Rd, Jacksonville, FL, 322130.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24470PRVJoshua Gordon1958-12-25—48491161524104 Union St, Jacksonville, FL, 322860.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29142PRVCharlotte N Ferguson1982-06-01—52235059751240 Mesa Dr, Gilbert, AZ, 852400.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26338PRVAnna Y Greene1986-02-14UHC-19124-9398752173919359 Lake View Rd, Denver, CO, 802220.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-22025PRVArthur L Bennett1999-10-06UHC-95087-1420595291609341 Forest Ave, Dallas, TX, 752410.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-20083PRVJack Brooks1995-06-08UHC-96259-4087228827232490 Broadway, Mesa, AZ, 852750.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-24670PRVDaniel Henry1994-05-09UHC-35049-9964985816748016 Maple Ave, Eden Prairie, MN, 553630.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27989PRVRachel Flores2006-02-05UHC-97143-2786435665995831 Sunset Blvd, Plano, TX, 750800.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-22246PRVAshley Brooks1991-03-10—71877935981256 Canyon Rd, Phoenix, AZ, 850690.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-24115PRVDeborah R Burke1985-12-12—6935816501—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-23767PRVStephanie Castro1984-06-09—22537475286077 Market St, Tucson, AZ, 857900.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-26714PRVBrian Guzman1991-03-04—48579249185697 Camelback Rd, Glendale, AZ, 853400.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23871PRVMartha B Campbell1939-01-15UHC-30282-2047627310714725 Highland Ave, Plano, TX, 750750.92Member ID reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-28005PRVJeffrey X Fernandez1967-12-26UHC-50567-8827023943301440 Market St, Tucson, AZ, 857370.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-28802PRVMegan Young1952-02-28UHC-39931-303382809173—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28042PRVGloria W Ward1968-09-02—4968924413—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20576PRVHeather M Fisher1961-01-07UHC-92896-4752420703203767 Market St, Los Angeles, CA, 900430.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23710PRVEmma Nunez1955-05-11UHC-09511-6780365302062707 Bayshore Dr, Houston, TX, 770410.92Name re-casedPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-27306PRVHiroshi Brooks1990-08-15UHC-65032-334385737130741 Canyon Rd, Nashville, TN, 372320.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 164 of 192PreviousNext