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-421146CLMMaria Hoffman2000-05-27UHC-58570-09—6203 Indian School Rd, Tampa, FL, 336580.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20802PRVAlan Brown2004-01-08UHC-69982-03—740 Central Ave Apt 13, Phoenix, AZ, 850770.48Name split from “Last, First”Member ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-119428ENRBarbara K Lynch1961-05-26UHC-36424-1540082448186512 Sage Ct, Nashville, TN, 372580.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-52083TPAHelen Cruz1988-11-02—2427366336756 Central Ave, Orlando, FL0.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
CLM-405109CLMTerry Peterson1964-12-22—5813042921298 Desert Sky Blvd, Glendale, AZ, 853930.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-117825ENRFatima Espinoza1944-08-11UHC-02164-7068354674997168 Church St, Denver, CO, 802210.48Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114015ENRSteven Campbell1996-09-20UHC-56403-1344327949925909 Central Ave, Orlando, FL, 328980.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404879CLMGary P Burton1988-01-22UHC-41264-81—4869 Church St, Gilbert, AZ0.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423199CLMSara Wallace1970-10-27UHC-48359-676659671601298 Ridge Rd Apt 25, Minneapolis, MN, 554710.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-403750CLMHenry Little1944-12-26UHC-93359-732435746946266 Camelback Rd, Atlanta, GA, 303610.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-52483TPAJoyce Lewis1998-12-24——908 River Rd, Tempe, AZ, 852660.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-102246ENRChristian S Roobinson1950-02-06UHC-15823-8490757725014202 Grand Ave, Denver, CO, 802930.48Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-122741ENRJerry E Contreras1983-12-09UHC-90619-6093442805331086 Lincoln Way, Houston, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56134TPAMadison Henderson1973-06-23——7189 Lake View Rd Apt 17, Plano, TX, 750150.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25996PRVMelissa I Gibson1965-07-09—29821108859252 Mesa Dr, Mesa, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24354PRVGeorge M Bell———3580 Spring St, Seattle, WA, 981500.48Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+4 more
TPA-55702TPAKathleen Morgan1960-02-04—48732096522706 Elm St, Denver, CO, 802840.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101466ENRChristopher U Montgomery2002-04-21UHC-85412-78—3292 Apache Blvd, Tampa, FL, 336230.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-53681TPAArjun Chavez1958-07-21—77527778633309 Elm St # 945, Charlotte, NC, 282760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408820CLMZachary Hudson1945-08-22—23671285794326 Palm Dr, Houston, TX0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138552ENRMichael N Montgomery1992-03-02UHC-33107-3422344608883406 Union St, Nashville, TN, 372730.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51422TPAOmar W Rios———5383 Union St Apt 40, Plano, TX, 750430.48Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+4 more
TPA-51709TPABobby Cooper1998-12-01—4882831996379 Church St, Chandler, AZ, 852780.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129487ENRJudy Z Foster2002-03-24UHC-43426-863396578993638 Harbor Blvd, Minneapolis, MN0.48Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
CLM-432509CLMKevin Johnston1956-06-01—38853791828262 Maple Ave # 382, Fresno, CA, 937520.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-132685ENRMason O Bradley1986-07-19UHC-43681-0352993200072852 Apache Blvd, Minneapolis, MN, 554140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425753CLMAbigail Grant1953-02-13UHC-92965-8322282811127908 Hillcrest Rd Apt 30, Tempe, AZ, 852530.48Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-421517CLMDylan Burns1947-12-02UHC-47416-3777042383738794 Harbor Blvd, Nashville, TN, 372730.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110759ENRRoy Sandoval1991-08-11UHC-79513-08—1003 Church St, Jacksonville, FL0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54945TPALaura Coleman1977-10-16—72774261528086 Washington St # 220, Houston, TX, 770270.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416714CLMElijah Torres1968-03-21UHC-90396-64—7315 Church St Apt 32, Eden Prairie, MN, 553330.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-112139ENRDennis T Bryant1949-10-22UHC-30043-1557538657671329 Hillcrest Rd, Dallas, TX, 752340.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422095CLM—Junk1967-09-18UHC-42415-0353550543218889 Bayshore Dr, Dallas, TX, 752010.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407594CLMBetty X Tucker1958-07-15—82994521313595 Central Ave, Tucson, AZ0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-415480CLMCatherine Lawrence—UHC-09218-8637070437299836 Canyon Rd, Chandler, AZ, 852490.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-126202ENRJoan Le1962-09-25UHC-35979-4986333548782959 Maple Ave, San Diego, CA, 921210.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-100353ENRSara G Obrien1909-10-09UHC-90658-18—8262 Elm St, Minneapolis, MN, 554080.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-100182ENRMargaret Reyes1990-05-04UHC-72818-4668529226242556 Lake View Rd Apt 12, Tampa, FL0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55599TPAMei Jackson2005-12-15UHC-50141-31—2468 Willow Ct, Gilbert, AZ, 852880.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
CLM-417575CLMElizabeth Baker1994-09-04UHC-60905-95—9587 Park Pl, San Antonio, TX, 782370.48Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-110350ENRBrittany Q Graham1987-01-04UHC-81173-0953760236133057 Sunset Blvd, Tampa, FL, 336350.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410638CLMEugene Petrson1942-11-20UHC-76324-6186797252282480 Ocean Ave, Minneapolis, MN, 554890.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58292TPAEthan Weaver1967-06-05——8731 Washington St, Mesa, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59067TPAJulie Kelly1984-06-24——2150 Park Pl, Glendale, AZ, 853130.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403186CLMYuki A Herrera2004-09-05——1268 Palm Dr, Minneapolis, MN, 554690.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-27681PRVLauren Peters1984-07-16—22528577911420 Oak St, Glendale, AZ, 853920.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-133537ENRJean Brooks2004-02-06UHC-50329-0479795980879313 Meadow Ln, Tampa, FL, 336710.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-103778ENRKayla Thompson1999-03-06UHC-07497-4343257950837048 Cedar Ln, Tucson, AZ, 857090.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428430CLMJohn Lewis1949-04-11——2158 Sunset Blvd, Las Vegas, NV, 891210.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-127977ENRPatricia Perry1975-08-04UHC-59294-1633255615296200 Grand Ave, Las Vegas, NV, 891140.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
100,000 rows, page 65 of 2,000PreviousNext