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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-138790ENRChristopher Wilson1946-12-07UHC-54608-6267959560015634 Washington St Apt 15, Tucson, AZ, 857760.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-125460ENRNoah Roberts1953-07-09UHC-09396-3868583620985412 Main St, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407096CLMJoe Young2002-03-24UHC-30717-32—4851 Mountain View Dr, Mesa, AZ, 852600.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-136440ENRMark Lopez—UHC-01657-312959574362810 Mesa Dr, Sacramento, CA, 958120.50Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-54249TPABetty D Fields2004-09-15—84471624076147 Lincoln Way, Columbus, OH, 432280.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28837PRVJudy Munoz1939-12-27—22783197371477 Lincoln Way, Fresno, CA, 937670.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-117422ENRTony G Aguilar1989-11-06UHC-75197-95—7798 Mountain View Dr, Tempe, AZ, 852880.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-112009ENRJose Espinoza—UHC-99113-0275142000568225 Market St # 129, Seattle, WA, 981290.50Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-114313ENRWJunk1984-06-12UHC-76015-4657445027591221 Harbor Blvd, Chandler, AZ, 852700.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-400970CLMGary J Sullivan1965-11-03UHC-11966-4377096324324564 Baseline Rd, Atlanta, GA, 303340.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-104811ENRVictoria A Bennett1956-05-07UHC-20682-6522546849319161 Maple Ave # 210, Tempe, AZ, 852650.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-50039TPAGregory Morales1977-02-09——7891 Valley View Dr, Plano, TX, 750680.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60909TPARandy Miller1997-11-14——5877 Sunset Blvd, Dallas, TX, 752860.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-115150ENRDooris Cox1987-05-05UHC-68670-2561650299019747 Hillcrest Rd, Seattle, WA, 981000.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21956PRVSofia Greene1976-05-20UHC-16642-19—6125 Apache Blvd, Denver, CO, 802390.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-421331CLMJean Davis1963-10-01——4532 Cedar Ln, Dallas, TX, 752540.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
ENR-102951ENRCharles Z Olson1970-04-02UHC-73785-8320627514765690 Meadow Ln # 607, Phoenix, AZ, 850270.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-404538CLMLisa Silva2002-04-16——6174 Willow Ct # 947, Columbus, OH, 432350.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418107CLMKathleen R Lawson1941-07-17UHC-48976-7142853174932728 Valley View Dr, Charlotte, NC, 282020.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101917ENRFatima Stevens1979-04-05UHC-61847-88—715 Spring St, Scottsdale, AZ0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-21899PRVVirginia Greene2005-06-22UHC-49687-5626555240914747 Willow Ct, San Diego, CA, 921520.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130782ENRJerry Q Moore1963-04-12UHC-01331-3282146626495838 Lincoln Way, Columbus, OH0.50Name re-casedCity re-casedState name converted to codeZIP missing+3 more
PRV-25895PRVKelly Vasquez1994-11-02——2110 Church St, Mesa, AZ, 852740.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-100631ENRKenneth Y Edwards2002-12-07UHC-87921-7191081517526068 Forest Ave, Sacramento, CA, 958070.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-133308ENRMegan Ortiz1961-08-20UHC-20744-1840958603859249 Desert Sky Blvd, Los Angeles, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28238PRVBruce Harvey2004-03-21—68975922839486 Indian School Rd, Orlando, FL, 328760.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424979CLMJulia Snyder—UHC-13287-8755193308809086 Canyon Rd, Los Angeles, CA, 900030.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404609CLMJudy V Long2001-05-20UHC-14892-64—4143 Apache Blvd, Gilbert, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-112827ENRMegan Reed2005-11-11UHC-55099-8624281316238402 Mesa Dr, Sacramento, CA, 958120.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56276TPAJeffrey Payne———1553 Palm Dr, Houston, TX, 770900.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-22226PRVVirginia G Yang1988-08-28UHC-41415-62—200 Jefferson Ave, Mesa, AZ, 852870.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-127068ENRZachary Pena1950-06-06UHC-45681-3437991116966126 Mountain View Dr, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58159TPACharlotte Elliott1996-01-01——7422 Market St, Glendale, AZ, 853220.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-428739CLMCarl Li———2696 Sage Ct, Jacksonville, FL, 322770.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-140074ENRPhilip Z Stephens1940-02-17UHC-52177-385218261425145 Cedar Ln, Dallas, TX, 752710.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22374PRVJose Maldonado1953-02-07UHC-41703-3176634824475368 Camelback Rd, Los Angeles, CA, 900140.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-128725ENRKimberly M James2002-07-23UHC-59619-3326897890081599 Hillcrest Rd, Seattle, WA, 981610.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-418318CLMEmily Boyd1998-06-24UHC-29831-34—547 Willow Ct, Tucson, AZ, 857990.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416151CLMNancy Q Washington2007-05-05——2444 Lincoln Way Apt 20, Plano, TX, 750370.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125162ENRJudy V Hoffman1949-11-07UHC-63831-1582397707759408 Valley View Dr, Phoenix, AZ, 850160.50Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+3 more
ENR-112879ENRAshley Lopez1944-08-15UHC-75234-8369340616501743 Sage Ct Apt 5, Denver, CO, 802720.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-422131CLMSamuel Martinez1993-04-08UHC-56424-34—8593 Jefferson Ave, Eden Prairie, MN, 553380.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-432108CLMAndrew Jacobs1990-12-11——5166 Highland Ave # 228, Austin, TX, 787200.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125075ENRGerald Little1996-11-14UHC-94042-5169159416523476 Ocean Ave, Columbus, OH, 432970.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20878PRVDrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ, 852570.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21624PRVTerry D Guzman1950-12-08—47587129393966 Bayshore Dr, Nashville, TN, 372470.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413062CLMCarlos W Myers1958-01-13UHC-75972-296616616502302 Bayshore Dr, Las Vegas, NV, 891010.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57395TPADennis Murphy1953-03-18—48072785239734 Bayshore Dr, Charlotte, NC, 282770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428556CLM—Junk1949-05-17—62784739681303 Ocean Ave, Fresno, CA, 937930.50Date of birth reformattedPhone reformattedState name converted to codeGender normalised+3 more
CLM-418911CLMCamila Kelley1964-06-15—33287153883227 Desert Sky Blvd Apt 22, Miami, FL, 331820.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 92 of 2,000PreviousNext