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
CLM-429884CLMAnn Garrett1938-12-18UHC-63615-33—5563 Lincoln Way # 379, Houston, TX, 770730.52Name split from “Last, First”Member ID reformattedUnit split from streetState name converted to code+2 more
CLM-406174CLMJean Kelly2007-01-26——1655 Cedar Ln, Chandler, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-133191ENRPamela R Arnold1974-03-06UHC-14514-4931793129443833 Willow Ct, Tempe, AZ0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418690CLMBilly Anderson1984-05-10—7867473559—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
ENR-108164ENRRuth George1964-10-19UHC-96926-0390550087562934 Sunset Blvd, Chandler, AZ, 852090.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105658ENRJoshua E Vega1996-03-27UHC-02385-4736691590012246 Mesa Dr, Dallas, TX, 752090.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-130763ENREugene K Nguyen1992-09-24UHC-72367-6028527965006870 Camelback Rd Apt 37, Dallas, TX, 752490.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-100748ENRCarlos P Kim1967-12-10UHC-90592-8967823362641107 Park Pl, Columbus, OH, 432330.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403283CLMJudith E Gilbert1955-10-23UHC-52805-66—7478 Market St, Austin, TX, 787150.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55937TPACharles Austin1979-02-16——787 Grand Ave, Mesa, AZ, 852710.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-103362ENRLusi Vega1938-07-28UHC-18828-5689842596192560 Ocean Ave, Minneapolis, MN, 554580.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-126026ENRCharles E George1984-08-28UHC-68001-45—8364 Camelback Rd, Nashville, TN, 372250.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-114142ENRCharlotte Little1977-08-05UHC-17946-9194266617842244 Canyon Rd, Denver, CO0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423404CLMScott Duncan1997-10-26UHC-47476-28—4543 Indian School Rd, Gilbert, AZ0.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27807PRVBobby Dean1941-05-26UHC-81117-274083330786717 Valley View Dr Apt 12, Jacksonville, FL, 322870.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26811PRVDiego Ferguson1984-06-08UHC-07762-2297068595371523 Union St Apt 4, San Antonio, TX, 782290.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426586CLMDiana Garrett1962-01-07UHC-79807-80—2079 Ocean Ave, Nashville, TN, 372830.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-102817ENRAndrew C Cooper1975-01-17UHC-60313-72—7383 Bayshore Dr, Columbus, OH0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-404044CLMRobert Wng1951-08-03UHC-24041-45—167 Harbor Blvd, Sacramento, CA, 958880.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136908ENRMei L Clark1987-03-09UHC-15546-2076589629294102 Sunset Blvd, Glendale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415830CLMGabriel L Hawkins1949-12-22—86434193263579 Desert Sky Blvd, San Antonio, TX, 782170.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-20637PRVAhmed Gutierrez1938-05-12——6178 Forest Ave, Columbus, OH, 432040.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131329ENRAisha Y Gilbert1971-08-08——8619 Elm St, Houston, TX, 770470.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-142614ENRJason James1957-02-14UHC-94506-0474132840419716 Mountain View Dr # 769, Glendale, AZ, 853520.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
TPA-55840TPAAnthony Aguilar1989-11-06—76280888847499 Jefferson Ave, Phoenix, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-105847ENRGloria V Ortega2007-02-20UHC-54492-8262566424504707 Highland Ave, Tempe, AZ, 852520.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
ENR-105848ENRGloria V Ortega2007-02-20UHC-54492-8262566424504707 Highland Ave, Tempe, AZ, 852520.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
CLM-427240CLMJuan Richardson1953-06-28UHC-66465-9929142351024782 Palm Dr, Scottsdale, AZ, 852790.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-127948ENRMichelle O Clark1987-06-28UHC-76779-1271862752434196 Union St # 234, Miami, FL, 331160.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-100741ENRAmy Z Sullivan1964-12-06UHC-96279-9592550248083192 Willow Ct, Austin, TX, 787750.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25649PRVEmily Jimenez1974-01-09—92174385802840 Spring St, Minneapolis, MN, 554160.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427819CLMAndrea Armstrong1958-04-28UHC-90391-35—1343 Willow Ct, Tampa, FL, 336020.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-134616ENRJuile Rojas1950-04-23UHC-51780-1633671266005396 Meadow Ln # 617, San Diego, CA, 921390.52Name re-casedPhone reformattedSSN last four extractedUnit split from street+2 more
TPA-63482TPARachel Turner1990-04-03—21265272122262 Apache Blvd, Phoenix, AZ, 850450.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-117831ENRTeresa H Walsh1949-10-07UHC-14924-5485865719161450 Meadow Ln, Las Vegas, NV, 891560.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-420923CLMNaancy Freeman1991-07-03UHC-64096-58—4919 Sunset Blvd, San Antonio, TX, 782620.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138064ENRRaymond W Mason1997-01-09UHC-02558-9549691593652597 Mountain View Dr, Austin, TX, 787470.52Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-128841ENRCynthia I Kelley1951-10-26UHC-66524-4233555132452490 Meadow Ln, Sacramento, CA, 958220.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112884ENRMason Wood2006-11-17UHC-07180-7237123431119111 Cedar Ln, San Diego, CA, 921340.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-53105TPAGerald Y Wagner1982-02-05—62794681729744 River Rd # 478, Charlotte, NC, 282690.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120503ENRHannah P Carter2003-02-12UHC-42439-8931732797226743 Church St, Tempe, AZ, 852330.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62213TPATyler Z Sanders1994-01-19—64972440731664 Forest Ave, Minneapolis, MN, 554560.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-141235ENR—Junk2002-09-26UHC-55937-6042285731475295 Main St, Mesa, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54357TPAPeter Wong1965-05-19—37986576891640 Ocean Ave, Seattle, WA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418568CLMSteven Howell2008-02-19UHC-92754-01—1820 Maple Ave Apt 37, Sacramento, CA, 958780.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426803CLMHannah Chavez1968-07-28UHC-39743-8669136746942210 Park Pl, Glendale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423575CLMDouglas Daniels1957-01-06UHC-43682-30—3223 Washington St, Denver, CO0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-416406CLMHeather Hill—UHC-75926-3534090333998353 Washington St # 185, Atlanta, GA, 303840.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-403501CLMLori N Duncan1965-10-18UHC-77386-4087698161752740 Oak St, Plano, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-122611ENRJesse Ramos—UHC-50341-3639392439682438 Ocean Ave, Denver, CO, 802810.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
100,000 rows, page 153 of 2,000PreviousNext