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-427667CLMStephen Davis1963-12-19UHC-10367-58—4730 Washington St, Las Vegas, NV, 891740.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57710TPACharlotte Duncan1989-11-08——9268 Valley View Dr, Columbus, OH, 432640.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53917TPAAmanda Ortiz1971-11-28——9163 Desert Sky Blvd, Atlanta, GA, 303610.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409328CLMJose Campbell1993-11-18UHC-25523-0662432631568087 Market St, Tempe, AZ, 852380.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142600ENRCarl C Simmons—UHC-25020-0889423385955222 Ocean Ave, Denver, CO, 802900.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133970ENRIsabella R Ferguson1995-12-16UHC-91349-7225875298309627 Ocean Ave, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-119577ENRJoshua V Wallace1990-03-27UHC-69314-9981498658702783 Oak St, Jacksonville, FL, 322150.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+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
CLM-414749CLMAllen E Mei1991-09-17UHC-06040-50—2703 Main St, Tampa, FL, 336340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105064ENRBenjamin Burton1970-06-13UHC-06418-8767287885676438 Washington St, Chandler, AZ, 852040.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429373CLMJennifer Parker1977-11-09UHC-33407-884946594255241 Forest Ave, Austin, TX, 787160.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-113206ENRJoseph Fowler1950-08-18UHC-38879-7223530379967897 Elm St Apt 34, Miami, FL0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-401236CLMJordan Cruz2008-01-23UHC-28356-9497245526374114 Spring St, Plano, TX, 750470.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113569ENRTeresa V Jensen1969-05-24UHC-06673-31—7399 Forest Ave, Los Angeles, CA, 900570.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
ENR-117611ENRBradley Peterson—UHC-57031-7141377507917298 Washington St, Miami, FL0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51496TPAAbigail McDoald1969-07-26——2735 Washington St # 570, Fresno, CA, 937100.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-60105TPADiana Mills1954-03-08—41861584998309 Canyon Rd, Denver, CO, 802370.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52935TPAJohnny Little1968-05-02——1768 Maple Ave, Gilbert, AZ, 852540.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413783CLMDonald Ray1956-10-23UHC-01772-8057391247563621 Lake View Rd Apt 3, Orlando, FL, 328000.50Name re-casedTwo-digit birth yearUnit split from streetEmail lower-cased+3 more
TPA-61486TPAChristian Salazar———6140 Elm St, Columbus, OH, 432020.50Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+3 more
CLM-424666CLMAlice Mejia1942-06-13——649 Apache Blvd, Denver, CO, 802540.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-56790TPAJack M Barnes1979-04-24—76667693323185 Washington St, Las Vegas, NV, 891250.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
CLM-426436CLMJennifre L Carroll1946-04-23—79420648224830 River Rd # 414, Las Vegas, NV, 891280.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-139060ENRJeremy K Moore1995-09-27UHC-26263-4594557312227041 Willow Ct, Mesa, AZ, 852620.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411700CLMMateo King1951-02-19—61231882164459 Hillcrest Rd, Tempe, AZ, 852030.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118174ENRRoss S Keith1939-07-21UHC-82496-4837689744654892 Baseline Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423423CLMCarolyn Porter1960-04-02UHC-22051-9296045202104594 River Rd, Sacramento, CA, 958150.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-134430ENROlivia G Johnson1971-01-09UHC-35132-0473878299188638 Washington St, Seattle, WA, 981810.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+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
CLM-418905CLMAustin Li1962-04-04UHC-41620-28—3597 Spring St, Plano, TX, 750290.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-413849CLMHeather Q Schultz2003-12-09UHC-31606-7823279989158354 Baseline Rd, Tucson, AZ, 857450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112216ENRLane S Carol1956-06-01UHC-14000-0257574998277896 Willow Ct, Mesa, AZ, 852500.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-122923ENRCarl Tran1959-06-10UHC-23306-3856435506129834 Desert Sky Blvd, Eden Prairie, MN0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-406095CLMAlan W Tran1970-06-06UHC-55420-11—7475 Valley View Dr, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401620CLMDiaana Rice2002-10-03——4811 Maple Ave # 691, Fresno, CA, 937010.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421125CLMMadison Wilson2002-03-26UHC-28652-3395723362995217 Ocean Ave, San Antonio, TX, 782270.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-135959ENRJulie N Garrett1940-06-04UHC-79164-9223331351395021 Pine Dr, San Antonio, TX, 782210.50Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-426414CLMJulie Rojas1950-04-23UHC-51780-16—5396 Meadow Ln # 484, San Diego, CA, 921390.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429143CLMHeather Nelson———3480 Main St, Plano, TX, 750590.50Name re-casedDate of birth missingSSN last four extractedStreet suffix standardised+3 more
CLM-418843CLMDavid Masson—UHC-84212-3179096479334860 Mountain View Dr, Jacksonville, FL, 322550.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422373CLMJessica Q Sanchez1948-10-19——2365 Mountain View Dr, Sacramento, CA, 958880.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-128573ENRKathryn Sanders1984-05-23UHC-07424-634855737664452 Bayshore Dr # 126, Las Vegas, NV, 891060.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
TPA-57654TPAJudy Pierce1991-02-15UHC-76830-07—2875 Maple Ave Apt 8, San Antonio, TX, 782390.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425200CLMJean W Gonzales1941-09-26UHC-86751-2435847574966416 Canyon Rd, San Antonio, TX, 782770.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-410594CLMAlice Pierce1941-03-26UHC-24760-22—217 Washington St # 973, Austin, TX, 787840.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421183CLMGary M Guerrero1985-12-10—41059451495571 Jefferson Ave, Los Angeles, CA0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419888CLMBrian Walsh1969-11-11UHC-92358-31833588381383 Lincoln Way, Houston, TX, 770960.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-124929ENRAmber I Fernandez1970-08-14UHC-71712-8160855744801598 Central Ave, Minneapolis, MN, 554930.50Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-142347ENRGary B Hughes1979-03-22UHC-28631-85—3338 Willow Ct, Orlando, FL, 328260.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 110 of 2,000PreviousNext